add_hooks(); } /** * Adds the various class functions to hooks and filters * * @since 4.7.1 */ public function add_hooks() { add_action( 'admin_init', array( $this, 'update' ) ); add_action( 'admin_init', array( $this, 'update' ) ); add_filter( 'plugin_action_links_' . QSM_PLUGIN_BASENAME, array( $this, 'plugin_action_links' ) ); add_filter( 'plugin_row_meta', array( $this, 'plugin_row_meta' ), 10, 2 ); add_action( 'plugins_loaded', array( $this, 'register_default_settings' ) ); } /** * Adds the default quiz settings * * @since 5.0.0 */ public function register_default_settings() { global $mlwQuizMasterNext; // Registers system setting $field_array = array( 'id' => 'system', 'label' => __('Which system is this quiz graded on?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Correct/Incorrect', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('Points', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('Not Graded', 'quiz-master-next'), 'value' => 2 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers progress_bar setting $field_array = array( 'id' => 'progress_bar', 'label' => __( 'Show a progress bar?', 'quiz-master-next' ), 'type' => 'radio', 'options' => array( array( 'label' => __( 'Yes', 'quiz-master-next' ), 'value' => 1 ), array( 'label' => __( 'No', 'quiz-master-next' ), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers require_log_in setting $field_array = array( 'id' => 'require_log_in', 'label' => __('Should the user be required to be logged in to take this quiz?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers required text setting $field_array = array( 'id' => 'require_log_in_text_msg', 'label' => __('Text for non logged in user. Note: This option will work if above option set to yes', 'quiz-master-next'), 'type' => 'text', 'default' => 'This quiz is for logged in users only.' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers pagination setting $field_array = array( 'id' => 'pagination', 'label' => __('How many questions per page would you like? (Leave 0 to use pages created on Questions tab)', 'quiz-master-next'), 'type' => 'number', 'options' => array( ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers timer_limit setting $field_array = array( 'id' => 'timer_limit', 'label' => __('How many minutes does the user have to finish the quiz? (Leave 0 for no time limit)', 'quiz-master-next'), 'type' => 'number', 'options' => array( ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Settings for quick result $field_array = array( 'id' => 'enable_result_after_timer_end', 'label' => __('Force submit after timer expiry?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers total_user_tries setting $field_array = array( 'id' => 'total_user_tries', 'label' => __('How many times can a user take this quiz? (Leave 0 for as many times as the user wants to.)', 'quiz-master-next'), 'type' => 'number', 'options' => array( ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers limit_total_entries setting $field_array = array( 'id' => 'limit_total_entries', 'label' => __('How many total entries can this quiz have? (Leave 0 for unlimited entries)', 'quiz-master-next'), 'type' => 'number', 'options' => array( ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers question_from_total setting $field_array = array( 'id' => 'question_from_total', 'label' => __('How many questions should be loaded for quiz? (Leave 0 to load all questions)', 'quiz-master-next'), 'type' => 'number', 'options' => array( ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers scheduled_time_start setting $field_array = array( 'id' => 'scheduled_time_start', 'label' => __('When should the user be able to start accessing the quiz? (Leave blank if the user can access anytime)', 'quiz-master-next'), 'type' => 'date', 'options' => array( ), 'default' => '' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers scheduled_time_end setting $field_array = array( 'id' => 'scheduled_time_end', 'label' => __('When should the user stop accessing the quiz? (Leave blank if the user can access anytime)', 'quiz-master-next'), 'type' => 'date', 'options' => array( ), 'default' => '' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers randomness_order setting $field_array = array( 'id' => 'randomness_order', 'label' => __('Are the questions random? (Question Order will not apply if this is yes)', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Random Questions', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('Random Questions And Answers', 'quiz-master-next'), 'value' => 2 ), array( 'label' => __('Random Answers', 'quiz-master-next'), 'value' => 3 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers contact_info_location setting $field_array = array( 'id' => 'contact_info_location', 'label' => __('Would you like to ask for the contact information at the beginning or at the end of the quiz?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Beginning', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('End', 'quiz-master-next'), 'value' => 1 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers loggedin_user_contact setting $field_array = array( 'id' => 'loggedin_user_contact', 'label' => __('If a logged-in user takes the quiz, would you like them to be able to edit contact information? If set to no, the fields will not show up for logged in users; however, the users information will be saved for the fields.', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 1 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers comment_section setting $field_array = array( 'id' => 'comment_section', 'label' => __('Would you like a place for the user to enter comments?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 1 ) ), 'default' => 1 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers question_numbering setting $field_array = array( 'id' => 'question_numbering', 'label' => __('Show question number on quiz?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers store_responses setting $field_array = array( 'id' => 'store_responses', 'label' => __( 'Store the responses in the database?', 'quiz-master-next' ), 'type' => 'radio', 'options' => array( array( 'label' => __( 'Yes', 'quiz-master-next' ), 'value' => 1 ), array( 'label' => __( 'No', 'quiz-master-next' ), 'value' => 0 ) ), 'default' => 1 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers social_media setting $field_array = array( 'id' => 'social_media', 'label' => __('Show social media sharing buttons? (Twitter & Facebook) This option is for here only for users of older versions. Please use the new template variables %FACEBOOK_SHARE% %TWITTER_SHARE% on your results pages instead of using this option!', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers disable_answer_onselect setting $field_array = array( 'id' => 'disable_answer_onselect', 'label' => __('Disable question once user selects answer? (Currently only work on multiple choice)', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers ajax_show_correct setting $field_array = array( 'id' => 'ajax_show_correct', 'label' => __('Dynamically add class for incorrect/correct answer after user selects answer? (Currently only works on multiple choice)', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers user_name setting $field_array = array( 'id' => 'user_name', 'label' => __("Should we ask for the user's name? (Only here for older versions. Use Contact tab for this.)", 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('Require', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 2 ) ), 'default' => 2 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers user_comp setting $field_array = array( 'id' => 'user_comp', 'label' => __('Should we ask for users business? (Only here for older versions. Use Contact tab for this.)', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('Require', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 2 ) ), 'default' => 2 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers user_email setting $field_array = array( 'id' => 'user_email', 'label' => __('Should we ask for users email? (Only here for older versions. Use Contact tab for this.)', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('Require', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 2 ) ), 'default' => 2 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers user_phone setting $field_array = array( 'id' => 'user_phone', 'label' => __('Should we ask for users phone number? (Only here for older versions. Use Contact tab for this.)', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 0 ), array( 'label' => __('Require', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 2 ) ), 'default' => 2 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers hide_auto fill setting $field_array = array( 'id' => 'contact_disable_autofill', 'label' => __('Disable auto fill for contact input?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ), ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers show category on front setting $field_array = array( 'id' => 'show_category_on_front', 'label' => __('Show category on front?', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ), ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Settings for quick result $field_array = array( 'id' => 'enable_quick_result_mc', 'label' => __('Show live results for questions inline', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ) ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); //Setting for retake quiz $field_array = array( 'id' => 'enable_retake_quiz_button', 'label' => __('Show RETAKE QUIZ button on result page', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ), ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); //Setting for pagination of quiz $field_array = array( 'id' => 'enable_pagination_quiz', 'label' => __('Enable pagination of quiz', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('Yes', 'quiz-master-next'), 'value' => 1 ), array( 'label' => __('No', 'quiz-master-next'), 'value' => 0 ), ), 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); //Setting for animation $field_array = array( 'id' => 'quiz_animation', 'label' => __('Select quiz animation', 'quiz-master-next'), 'type' => 'radio', 'options' => array( array( 'label' => __('bounce', 'quiz-master-next'), 'value' => 'bounce' ), array( 'label' => __('flash', 'quiz-master-next'), 'value' => 'flash' ), array( 'label' => __('pulse', 'quiz-master-next'), 'value' => 'pulse' ), array( 'label' => __('rubberBand', 'quiz-master-next'), 'value' => 'rubberBand' ), array( 'label' => __('shake', 'quiz-master-next'), 'value' => 'shake' ), array( 'label' => __('swing', 'quiz-master-next'), 'value' => 'swing' ), array( 'label' => __('tada', 'quiz-master-next'), 'value' => 'tada' ), array( 'label' => __('wobble', 'quiz-master-next'), 'value' => 'wobble' ), array( 'label' => __('jello', 'quiz-master-next'), 'value' => 'jello' ), array( 'label' => __('heartBeat', 'quiz-master-next'), 'value' => 'heartBeat' ), array( 'label' => __('No animation', 'quiz-master-next'), 'value' => '' ) ), 'default' => '' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_options' ); // Registers message_before setting $field_array = array( 'id' => 'message_before', 'label' => __("Message Displayed Before Quiz", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUIZ_NAME%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers message_comment setting $field_array = array( 'id' => 'message_comment', 'label' => __("Message Displayed Before Comments Box If Enabled", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUIZ_NAME%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers message_end_template setting $field_array = array( 'id' => 'message_end_template', 'label' => __("Message Displayed At End Of Quiz (Leave Blank To Omit Text Section)", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUIZ_NAME%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers total_user_tries_text setting $field_array = array( 'id' => 'total_user_tries_text', 'label' => __("Message Displayed If User Has Tried Quiz Too Many Times", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUIZ_NAME%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers require_log_in_text setting $field_array = array( 'id' => 'require_log_in_text', 'label' => __("Message Displayed If User Is Not Logged In And Quiz Requires Users To Be Logged In", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUIZ_NAME%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers scheduled_timeframe_text setting $field_array = array( 'id' => 'scheduled_timeframe_text', 'label' => __("Message Displayed If Date Is Outside Scheduled Timeframe", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUIZ_NAME%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers limit_total_entries_text setting $field_array = array( 'id' => 'limit_total_entries_text', 'label' => __("Message Displayed If The Limit Of Total Entries Has Been Reached", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUIZ_NAME%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers question_answer_template setting $field_array = array( 'id' => 'question_answer_template', 'label' => __("%QUESTIONS_ANSWERS% Text", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%QUESTION%', '%USER_ANSWER%', '%CORRECT_ANSWER%', '%USER_COMMENTS%', '%CORRECT_ANSWER_INFO%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers twitter_sharing_text setting $field_array = array( 'id' => 'twitter_sharing_text', 'label' => __("Twitter Sharing Text", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%POINT_SCORE%', '%AVERAGE_POINT%', '%AMOUNT_CORRECT%', '%TOTAL_QUESTIONS%', '%CORRECT_SCORE%', '%QUIZ_NAME%', '%TIMER%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers facebook_sharing_text setting $field_array = array( 'id' => 'facebook_sharing_text', 'label' => __("Facebook Sharing Text", 'quiz-master-next'), 'type' => 'editor', 'default' => 0, 'variables' => array( '%POINT_SCORE%', '%AVERAGE_POINT%', '%AMOUNT_CORRECT%', '%TOTAL_QUESTIONS%', '%CORRECT_SCORE%', '%QUIZ_NAME%', '%TIMER%', '%CURRENT_DATE%' ) ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers submit_button_text setting $field_array = array( 'id' => 'submit_button_text', 'label' => __('Text for submit button', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers name_field_text setting $field_array = array( 'id' => 'name_field_text', 'label' => __('Text for name field', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers business_field_text setting $field_array = array( 'id' => 'business_field_text', 'label' => __('Text for business field', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers email_field_text setting $field_array = array( 'id' => 'email_field_text', 'label' => __('Text for email field', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers phone_field_text setting $field_array = array( 'id' => 'phone_field_text', 'label' => __('Text for phone number field', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers comment_field_text setting $field_array = array( 'id' => 'comment_field_text', 'label' => __('Text for comments field', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers previous_button_text setting $field_array = array( 'id' => 'previous_button_text', 'label' => __('Text for previous button', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers next_button_text setting $field_array = array( 'id' => 'next_button_text', 'label' => __('Text for next button', 'quiz-master-next'), 'type' => 'text', 'default' => 0 ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers hint_text setting $field_array = array( 'id' => 'hint_text', 'label' => __('Text for hint', 'quiz-master-next'), 'type' => 'text', 'default' => 'Hint' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers empty_error_text setting $field_array = array( 'id' => 'empty_error_text', 'label' => __('Text for when user has not filled in all required fields', 'quiz-master-next'), 'type' => 'text', 'default' => 'Please complete all required fields!' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers email_error_text setting $field_array = array( 'id' => 'email_error_text', 'label' => __('Text for when user filled in email field with invalid email', 'quiz-master-next'), 'type' => 'text', 'default' => 'Not a valid e-mail address!' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers number_error_text setting $field_array = array( 'id' => 'number_error_text', 'label' => __('Text for when user has filled in number field with invalid number', 'quiz-master-next'), 'type' => 'text', 'default' => 'This field must be a number!' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); // Registers incorrect_error_text setting $field_array = array( 'id' => 'incorrect_error_text', 'label' => __('Text for when user has not filled in captcha correctly', 'quiz-master-next'), 'type' => 'text', 'default' => 'The entered text is not correct!' ); $mlwQuizMasterNext->pluginHelper->register_quiz_setting( $field_array, 'quiz_text' ); } /** * Installs the plugin and its database tables * * @since 4.7.1 */ public static function install() { global $wpdb; $charset_collate = $wpdb->get_charset_collate(); $quiz_table_name = $wpdb->prefix . "mlw_quizzes"; $question_table_name = $wpdb->prefix . "mlw_questions"; $results_table_name = $wpdb->prefix . "mlw_results"; $audit_table_name = $wpdb->prefix . "mlw_qm_audit_trail"; if( $wpdb->get_var( "SHOW TABLES LIKE '$quiz_table_name'" ) != $quiz_table_name ) { $sql = "CREATE TABLE $quiz_table_name ( quiz_id mediumint(9) NOT NULL AUTO_INCREMENT, quiz_name TEXT NOT NULL, message_before TEXT NOT NULL, message_after TEXT NOT NULL, message_comment TEXT NOT NULL, message_end_template TEXT NOT NULL, user_email_template TEXT NOT NULL, admin_email_template TEXT NOT NULL, submit_button_text TEXT NOT NULL, name_field_text TEXT NOT NULL, business_field_text TEXT NOT NULL, email_field_text TEXT NOT NULL, phone_field_text TEXT NOT NULL, comment_field_text TEXT NOT NULL, email_from_text TEXT NOT NULL, question_answer_template TEXT NOT NULL, leaderboard_template TEXT NOT NULL, system INT NOT NULL, randomness_order INT NOT NULL, loggedin_user_contact INT NOT NULL, show_score INT NOT NULL, send_user_email INT NOT NULL, send_admin_email INT NOT NULL, contact_info_location INT NOT NULL, user_name INT NOT NULL, user_comp INT NOT NULL, user_email INT NOT NULL, user_phone INT NOT NULL, admin_email TEXT NOT NULL, comment_section INT NOT NULL, question_from_total INT NOT NULL, total_user_tries INT NOT NULL, total_user_tries_text TEXT NOT NULL, certificate_template TEXT NOT NULL, social_media INT NOT NULL, social_media_text TEXT NOT NULL, pagination INT NOT NULL, pagination_text TEXT NOT NULL, timer_limit INT NOT NULL, quiz_stye TEXT NOT NULL, question_numbering INT NOT NULL, quiz_settings TEXT NOT NULL, theme_selected TEXT NOT NULL, last_activity DATETIME NOT NULL, require_log_in INT NOT NULL, require_log_in_text TEXT NOT NULL, limit_total_entries INT NOT NULL, limit_total_entries_text TEXT NOT NULL, scheduled_timeframe TEXT NOT NULL, scheduled_timeframe_text TEXT NOT NULL, disable_answer_onselect INT NOT NULL, ajax_show_correct INT NOT NULL, quiz_views INT NOT NULL, quiz_taken INT NOT NULL, deleted INT NOT NULL, PRIMARY KEY (quiz_id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); } if( $wpdb->get_var( "SHOW TABLES LIKE '$question_table_name'" ) != $question_table_name ) { $sql = "CREATE TABLE $question_table_name ( question_id mediumint(9) NOT NULL AUTO_INCREMENT, quiz_id INT NOT NULL, question_name TEXT NOT NULL, answer_array TEXT NOT NULL, answer_one TEXT NOT NULL, answer_one_points INT NOT NULL, answer_two TEXT NOT NULL, answer_two_points INT NOT NULL, answer_three TEXT NOT NULL, answer_three_points INT NOT NULL, answer_four TEXT NOT NULL, answer_four_points INT NOT NULL, answer_five TEXT NOT NULL, answer_five_points INT NOT NULL, answer_six TEXT NOT NULL, answer_six_points INT NOT NULL, correct_answer INT NOT NULL, question_answer_info TEXT NOT NULL, comments INT NOT NULL, hints TEXT NOT NULL, question_order INT NOT NULL, question_type INT NOT NULL, question_type_new TEXT NOT NULL, question_settings TEXT NOT NULL, category TEXT NOT NULL, deleted INT NOT NULL, PRIMARY KEY (question_id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); } if( $wpdb->get_var( "SHOW TABLES LIKE '$results_table_name'" ) != $results_table_name ) { $sql = "CREATE TABLE $results_table_name ( result_id mediumint(9) NOT NULL AUTO_INCREMENT, quiz_id INT NOT NULL, quiz_name TEXT NOT NULL, quiz_system INT NOT NULL, point_score INT NOT NULL, correct_score INT NOT NULL, correct INT NOT NULL, total INT NOT NULL, name TEXT NOT NULL, business TEXT NOT NULL, email TEXT NOT NULL, phone TEXT NOT NULL, user INT NOT NULL, user_ip TEXT NOT NULL, time_taken TEXT NOT NULL, time_taken_real DATETIME NOT NULL, quiz_results TEXT NOT NULL, deleted INT NOT NULL, PRIMARY KEY (result_id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); } if( $wpdb->get_var( "SHOW TABLES LIKE '$audit_table_name'" ) != $audit_table_name ) { $sql = "CREATE TABLE $audit_table_name ( trail_id mediumint(9) NOT NULL AUTO_INCREMENT, action_user TEXT NOT NULL, action TEXT NOT NULL, time TEXT NOT NULL, PRIMARY KEY (trail_id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); } global $mlwQuizMasterNext; $mlwQuizMasterNext->register_quiz_post_types(); flush_rewrite_rules(); } /** * Updates the plugin * * @since 4.7.1 */ public function update() { global $mlwQuizMasterNext; $data = $mlwQuizMasterNext->version; if ( ! get_option( 'qmn_original_version' ) ) { add_option( 'qmn_original_version', $data ); } if ( get_option( 'mlw_quiz_master_version' ) != $data ) { global $wpdb; $table_name = $wpdb->prefix . "mlw_quizzes"; //Update 0.5 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'comment_section'") != "comment_section") { $sql = "ALTER TABLE ".$table_name." ADD comment_field_text TEXT NOT NULL AFTER phone_field_text"; $results = $wpdb->query( $sql ); $sql = "ALTER TABLE ".$table_name." ADD comment_section INT NOT NULL AFTER admin_email"; $results = $wpdb->query( $sql ); $sql = "ALTER TABLE ".$table_name." ADD message_comment TEXT NOT NULL AFTER message_after"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET comment_field_text='Comments', comment_section=1, message_comment='Enter You Text Here'"; $results = $wpdb->query( $update_sql ); } //Update 0.9.4 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'randomness_order'") != "randomness_order") { $sql = "ALTER TABLE ".$table_name." ADD randomness_order INT NOT NULL AFTER system"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET randomness_order=0"; $results = $wpdb->query( $update_sql ); } //Update 0.9.5 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_answer_template'") != "question_answer_template") { $sql = "ALTER TABLE ".$table_name." ADD question_answer_template TEXT NOT NULL AFTER comment_field_text"; $results = $wpdb->query( $sql ); $mlw_question_answer_default = "%QUESTION%
Answer Provided: %USER_ANSWER%
Correct Answer: %CORRECT_ANSWER%
Comments Entered: %USER_COMMENTS%
"; $update_sql = "UPDATE ".$table_name." SET question_answer_template='".$mlw_question_answer_default."'"; $results = $wpdb->query( $update_sql ); } //Update 0.9.6 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'contact_info_location'") != "contact_info_location") { $sql = "ALTER TABLE ".$table_name." ADD contact_info_location INT NOT NULL AFTER send_admin_email"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET contact_info_location=0"; $results = $wpdb->query( $update_sql ); } //Update 1.0 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'email_from_text'") != "email_from_text") { $sql = "ALTER TABLE ".$table_name." ADD email_from_text TEXT NOT NULL AFTER comment_field_text"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET email_from_text='Wordpress'"; $results = $wpdb->query( $update_sql ); } //Update 1.3.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'loggedin_user_contact'") != "loggedin_user_contact") { $sql = "ALTER TABLE ".$table_name." ADD loggedin_user_contact INT NOT NULL AFTER randomness_order"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET loggedin_user_contact=0"; $results = $wpdb->query( $update_sql ); } //Update 1.5.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_from_total'") != "question_from_total") { $sql = "ALTER TABLE ".$table_name." ADD question_from_total INT NOT NULL AFTER comment_section"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET question_from_total=0"; $results = $wpdb->query( $update_sql ); } //Update 1.6.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'total_user_tries'") != "total_user_tries") { $sql = "ALTER TABLE ".$table_name." ADD total_user_tries INT NOT NULL AFTER question_from_total"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET total_user_tries=0"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'total_user_tries_text'") != "total_user_tries_text") { $sql = "ALTER TABLE ".$table_name." ADD total_user_tries_text TEXT NOT NULL AFTER total_user_tries"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET total_user_tries_text='Enter Your Text Here'"; $results = $wpdb->query( $update_sql ); } //Update 1.8.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'message_end_template'") != "message_end_template") { $sql = "ALTER TABLE ".$table_name." ADD message_end_template TEXT NOT NULL AFTER message_comment"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET message_end_template=''"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'certificate_template'") != "certificate_template") { $sql = "ALTER TABLE ".$table_name." ADD certificate_template TEXT NOT NULL AFTER total_user_tries_text"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET certificate_template='Enter your text here!'"; $results = $wpdb->query( $update_sql ); } //Update 1.9.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'social_media'") != "social_media") { $sql = "ALTER TABLE ".$table_name." ADD social_media INT NOT NULL AFTER certificate_template"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET social_media='0'"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'social_media_text'") != "social_media_text") { $sql = "ALTER TABLE ".$table_name." ADD social_media_text TEXT NOT NULL AFTER social_media"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET social_media_text='I just score a %CORRECT_SCORE%% on %QUIZ_NAME%!'"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'pagination'") != "pagination") { $sql = "ALTER TABLE ".$table_name." ADD pagination INT NOT NULL AFTER social_media_text"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET pagination=0"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'pagination_text'") != "pagination_text") { $sql = "ALTER TABLE ".$table_name." ADD pagination_text TEXT NOT NULL AFTER pagination"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET pagination_text='Next'"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'timer_limit'") != "timer_limit") { $sql = "ALTER TABLE ".$table_name." ADD timer_limit INT NOT NULL AFTER pagination_text"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET timer_limit=0"; $results = $wpdb->query( $update_sql ); } //Update 2.1.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'quiz_stye'") != "quiz_stye") { $sql = "ALTER TABLE ".$table_name." ADD quiz_stye TEXT NOT NULL AFTER timer_limit"; $results = $wpdb->query( $sql ); $mlw_style_default = " div.mlw_qmn_quiz input[type=radio], div.mlw_qmn_quiz input[type=submit], div.mlw_qmn_quiz label { cursor: pointer; } div.mlw_qmn_quiz input:not([type=submit]):focus, div.mlw_qmn_quiz textarea:focus { background: #eaeaea; } div.mlw_qmn_quiz { text-align: left; } div.quiz_section { } div.mlw_qmn_timer { position:fixed; top:200px; right:0px; width:130px; color:#00CCFF; border-radius: 15px; background:#000000; text-align: center; padding: 15px 15px 15px 15px } div.mlw_qmn_quiz input[type=submit], a.mlw_qmn_quiz_link { border-radius: 4px; position: relative; background-image: linear-gradient(#fff,#dedede); background-color: #eee; border: #ccc solid 1px; color: #333; text-shadow: 0 1px 0 rgba(255,255,255,.5); box-sizing: border-box; display: inline-block; padding: 5px 5px 5px 5px; margin: auto; }"; $update_sql = "UPDATE ".$table_name." SET quiz_stye='".$mlw_style_default."'"; $results = $wpdb->query( $update_sql ); } //Update 2.2.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_numbering'") != "question_numbering") { $sql = "ALTER TABLE ".$table_name." ADD question_numbering INT NOT NULL AFTER quiz_stye"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET question_numbering='0'"; $results = $wpdb->query( $update_sql ); } //Update 2.8.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'quiz_settings'") != "quiz_settings") { $sql = "ALTER TABLE ".$table_name." ADD quiz_settings TEXT NOT NULL AFTER question_numbering"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET quiz_settings=''"; $results = $wpdb->query( $update_sql ); } //Update 3.0.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'theme_selected'") != "theme_selected") { $sql = "ALTER TABLE ".$table_name." ADD theme_selected TEXT NOT NULL AFTER quiz_settings"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET theme_selected='default'"; $results = $wpdb->query( $update_sql ); } //Update 3.3.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'last_activity'") != "last_activity") { $sql = "ALTER TABLE ".$table_name." ADD last_activity DATETIME NOT NULL AFTER theme_selected"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET last_activity='".date("Y-m-d H:i:s")."'"; $results = $wpdb->query( $update_sql ); } //Update 3.5.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'require_log_in'") != "require_log_in") { $sql = "ALTER TABLE ".$table_name." ADD require_log_in INT NOT NULL AFTER last_activity"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET require_log_in='0'"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'require_log_in_text'") != "require_log_in_text") { $sql = "ALTER TABLE ".$table_name." ADD require_log_in_text TEXT NOT NULL AFTER require_log_in"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET require_log_in_text='Enter Text Here'"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'limit_total_entries'") != "limit_total_entries") { $sql = "ALTER TABLE ".$table_name." ADD limit_total_entries INT NOT NULL AFTER require_log_in_text"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET limit_total_entries='0'"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'limit_total_entries_text'") != "limit_total_entries_text") { $sql = "ALTER TABLE ".$table_name." ADD limit_total_entries_text TEXT NOT NULL AFTER limit_total_entries"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET limit_total_entries_text='Enter Text Here'"; $results = $wpdb->query( $update_sql ); } //Update 3.7.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'scheduled_timeframe'") != "scheduled_timeframe") { $sql = "ALTER TABLE ".$table_name." ADD scheduled_timeframe TEXT NOT NULL AFTER limit_total_entries_text"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET scheduled_timeframe=''"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'scheduled_timeframe_text'") != "scheduled_timeframe_text") { $sql = "ALTER TABLE ".$table_name." ADD scheduled_timeframe_text TEXT NOT NULL AFTER scheduled_timeframe"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET scheduled_timeframe_text='Enter Text Here'"; $results = $wpdb->query( $update_sql ); } //Update 4.3.0 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'disable_answer_onselect'") != "disable_answer_onselect") { $sql = "ALTER TABLE ".$table_name." ADD disable_answer_onselect INT NOT NULL AFTER scheduled_timeframe_text"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET disable_answer_onselect=0"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'ajax_show_correct'") != "ajax_show_correct") { $sql = "ALTER TABLE ".$table_name." ADD ajax_show_correct INT NOT NULL AFTER disable_answer_onselect"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET ajax_show_correct=0"; $results = $wpdb->query( $update_sql ); } global $wpdb; $table_name = $wpdb->prefix . "mlw_questions"; //Update 0.5 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'comments'") != "comments") { $sql = "ALTER TABLE ".$table_name." ADD comments INT NOT NULL AFTER correct_answer"; $results = $wpdb->query( $sql ); $sql = "ALTER TABLE ".$table_name." ADD hints TEXT NOT NULL AFTER comments"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET comments=1, hints=''"; $results = $wpdb->query( $update_sql ); } //Update 0.8 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_order'") != "question_order") { $sql = "ALTER TABLE ".$table_name." ADD question_order INT NOT NULL AFTER hints"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET question_order=0"; $results = $wpdb->query( $update_sql ); } if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_type'") != "question_type") { $sql = "ALTER TABLE ".$table_name." ADD question_type INT NOT NULL AFTER question_order"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET question_type=0"; $results = $wpdb->query( $update_sql ); } //Update 1.1.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_answer_info'") != "question_answer_info") { $sql = "ALTER TABLE ".$table_name." ADD question_answer_info TEXT NOT NULL AFTER correct_answer"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET question_answer_info=''"; $results = $wpdb->query( $update_sql ); } //Update 2.5.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'answer_array'") != "answer_array") { $sql = "ALTER TABLE ".$table_name." ADD answer_array TEXT NOT NULL AFTER question_name"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET answer_array=''"; $results = $wpdb->query( $update_sql ); } //Update 3.1.1 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_settings'") != "question_settings") { $sql = "ALTER TABLE ".$table_name." ADD question_settings TEXT NOT NULL AFTER question_type"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET question_settings=''"; $results = $wpdb->query( $update_sql ); } //Update 4.0.0 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'category'") != "category") { $sql = "ALTER TABLE ".$table_name." ADD category TEXT NOT NULL AFTER question_settings"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET category=''"; $results = $wpdb->query( $update_sql ); } //Update 4.0.0 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'question_type_new'") != "question_type_new") { $sql = "ALTER TABLE ".$table_name." ADD question_type_new TEXT NOT NULL AFTER question_type"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET question_type_new=question_type"; $results = $wpdb->query( $update_sql ); } //Update 2.6.1 $results = $wpdb->query( "ALTER TABLE ".$wpdb->prefix . "mlw_qm_audit_trail CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;" ); $results = $wpdb->query( "ALTER TABLE ".$wpdb->prefix . "mlw_questions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci" ); $results = $wpdb->query( "ALTER TABLE ".$wpdb->prefix . "mlw_quizzes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci" ); $results = $wpdb->query( "ALTER TABLE ".$wpdb->prefix . "mlw_results CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci" ); global $wpdb; $table_name = $wpdb->prefix . "mlw_results"; //Update 2.6.4 if($wpdb->get_var("SHOW COLUMNS FROM ".$table_name." LIKE 'user'") != "user") { $sql = "ALTER TABLE ".$table_name." ADD user INT NOT NULL AFTER phone"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE ".$table_name." SET user=0"; $results = $wpdb->query( $update_sql ); } // Update 4.7.0 if( $wpdb->get_var( "SHOW COLUMNS FROM $table_name LIKE 'user_ip'" ) != "user_ip" ) { $sql = "ALTER TABLE $table_name ADD user_ip TEXT NOT NULL AFTER user"; $results = $wpdb->query( $sql ); $update_sql = "UPDATE $table_name SET user_ip='Unknown'"; $results = $wpdb->query( $update_sql ); } // Update 5.0.0 $settings = (array) get_option( 'qmn-settings', array() ); if ( ! isset( $settings['results_details_template'] ) ) { $settings['results_details_template'] = "

Quiz Results for %QUIZ_NAME%

%CONTACT_ALL%

Name Provided: %USER_NAME%

Business Provided: %USER_BUSINESS%

Phone Provided: %USER_PHONE%

Email Provided: %USER_EMAIL%

Score Received: %AMOUNT_CORRECT%/%TOTAL_QUESTIONS% or %CORRECT_SCORE%% or %POINT_SCORE% points

Answers Provided:

The user took %TIMER% to complete quiz.

Comments entered were: %COMMENT_SECTION%

The answers were as follows:

%QUESTIONS_ANSWERS%"; update_option( 'qmn-settings' , $settings ); } update_option('mlw_quiz_master_version' , $data); } if ( ! get_option('mlw_advert_shows') ) { add_option( 'mlw_advert_shows' , 'true' ); } } /** * Adds new links to the plugin action links * * @since 4.7.1 */ public function plugin_action_links( $links ) { $action_links = array( 'settings' => '' . __( 'Quizzes/Surveys', 'quiz-master-next' ) . '', ); return array_merge( $action_links, $links ); } /** * Adds new links to the plugin row meta * * @since 4.7.1 */ public function plugin_row_meta( $links, $file ) { if ( $file == QSM_PLUGIN_BASENAME ) { $row_meta = array( 'docs' => '' . __( 'Documentation', 'quiz-master-next' ) . '', 'support' => '' . __( 'Support', 'quiz-master-next' ) . '', ); return array_merge( $links, $row_meta ); } return (array) $links; } } $qsm_install = new QSM_Install(); ?>