quiz_id = intval( $_GET['quiz_id'] );
}
}
/**
* Sets quiz ID
*
* @since 3.8.1
* @param int $quiz_id The ID of the quiz.
* @access public
* @return void
*/
public function set_id( $quiz_id ) {
$this->quiz_id = intval( $quiz_id );
}
/**
* Gets the quiz ID stored (for backwards compatibility)
*
* @since 5.0.0
* @return int|false The ID of the quiz stored or false
*/
public function get_id() {
if ( $this->quiz_id ) {
return intval( $this->quiz_id );
} else {
return false;
}
}
/**
* Creates a new quiz with the default settings
*
* @access public
* @since 3.7.1
* @param string $quiz_name The name of the new quiz.
* @return void
*/
public function create_quiz( $quiz_name ) {
global $mlwQuizMasterNext;
global $wpdb;
$results = $wpdb->insert(
$wpdb->prefix . 'mlw_quizzes',
array(
'quiz_name' => $quiz_name,
'message_before' => 'Welcome to your %QUIZ_NAME%',
'message_after' => 'Thanks for submitting your response! You can edit this message on the "Results Pages" tab.
%CONTACT_ALL%
%QUESTIONS_ANSWERS%',
'message_comment' => 'Please fill in the comment box below.',
'message_end_template' => '',
'user_email_template' => '%QUESTIONS_ANSWERS%',
'admin_email_template' => '%QUESTIONS_ANSWERS%',
'submit_button_text' => 'Submit',
'name_field_text' => 'Name',
'business_field_text' => 'Business',
'email_field_text' => 'Email',
'phone_field_text' => 'Phone Number',
'comment_field_text' => 'Comments',
'email_from_text' => 'Wordpress',
'question_answer_template' => '%QUESTION%
Answer Provided: %USER_ANSWER%
Correct Answer: %CORRECT_ANSWER%
Comments Entered: %USER_COMMENTS%
',
'leaderboard_template' => '',
'system' => 0,
'randomness_order' => 0,
'loggedin_user_contact' => 0,
'show_score' => 0,
'send_user_email' => 0,
'send_admin_email' => 0,
'contact_info_location' => 0,
'user_name' => 2,
'user_comp' => 2,
'user_email' => 2,
'user_phone' => 2,
'admin_email' => get_option( 'admin_email', 'Enter email' ),
'comment_section' => 1,
'question_from_total' => 0,
'total_user_tries' => 0,
'total_user_tries_text' => 'You are only allowed 1 try and have already submitted your quiz.',
'certificate_template' => '',
'social_media' => 0,
'social_media_text' => 'I just scored %CORRECT_SCORE%% on %QUIZ_NAME%!',
'pagination' => 0,
'pagination_text' => 'Next',
'timer_limit' => 0,
'quiz_stye' => '',
'question_numbering' => 0,
'quiz_settings' => '',
'theme_selected' => 'primary',
'last_activity' => current_time( 'mysql' ),
'require_log_in' => 0,
'require_log_in_text' => 'This quiz is for logged in users only.',
'limit_total_entries' => 0,
'limit_total_entries_text' => 'Unfortunately, this quiz has a limited amount of entries it can recieve and has already reached that limit.',
'scheduled_timeframe' => '',
'scheduled_timeframe_text' => '',
'quiz_views' => 0,
'quiz_taken' => 0,
'deleted' => 0,
),
array(
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%s',
'%d',
'%d',
'%d',
'%s',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%s',
'%s',
'%d',
'%s',
'%d',
'%s',
'%s',
'%s',
'%d',
'%d',
'%d',
)
);
if ( false !== $results ) {
$new_quiz = $wpdb->insert_id;
$current_user = wp_get_current_user();
$quiz_post = array(
'post_title' => $quiz_name,
'post_content' => "[mlw_quizmaster quiz=$new_quiz]",
'post_status' => 'publish',
'post_author' => $current_user->ID,
'post_type' => 'quiz',
);
$quiz_post_id = wp_insert_post( $quiz_post );
add_post_meta( $quiz_post_id, 'quiz_id', $new_quiz );
$mlwQuizMasterNext->alertManager->newAlert(__('Your new quiz or survey has been created successfully. To begin editing, click the Edit link.', 'quiz-master-next'), 'success');
$mlwQuizMasterNext->audit_manager->new_audit( "New Quiz/Survey Has Been Created: $quiz_name" );
// Hook called after new quiz or survey has been created. Passes quiz_id to hook
do_action('qmn_quiz_created', $new_quiz);
} else {
$mlwQuizMasterNext->alertManager->newAlert(sprintf(__('There has been an error in this action. Please share this with the developer. Error Code: %s', 'quiz-master-next'), '0001'), 'error');
$mlwQuizMasterNext->log_manager->add("Error 0001", $wpdb->last_error.' from '.$wpdb->last_query, 0, 'error');
}
}
/**
* Deletes a quiz with the given quiz_id
*
* @access public
* @since 3.7.1
* @return void
*/
public function delete_quiz($quiz_id, $quiz_name)
{
global $mlwQuizMasterNext;
global $wpdb;
$results = $wpdb->update(
$wpdb->prefix . "mlw_quizzes",
array(
'deleted' => 1
),
array( 'quiz_id' => $quiz_id ),
array(
'%d'
),
array( '%d' )
);
$delete_question_results = $wpdb->update(
$wpdb->prefix . "mlw_questions",
array(
'deleted' => 1
),
array( 'quiz_id' => $quiz_id ),
array(
'%d'
),
array( '%d' )
);
if ($results != false)
{
$my_query = new WP_Query( array('post_type' => 'quiz', 'meta_key' => 'quiz_id', 'meta_value' => $quiz_id) );
if( $my_query->have_posts() )
{
while( $my_query->have_posts() )
{
$my_query->the_post();
$my_post = array(
'ID' => get_the_ID(),
'post_status' => 'trash'
);
wp_update_post( $my_post );
}
}
wp_reset_postdata();
$mlwQuizMasterNext->alertManager->newAlert(__('Your quiz or survey has been deleted successfully.', 'quiz-master-next'), 'success');
$mlwQuizMasterNext->audit_manager->new_audit( "Quiz/Survey Has Been Deleted: $quiz_name" );
}
else
{
$mlwQuizMasterNext->alertManager->newAlert(sprintf(__('There has been an error in this action. Please share this with the developer. Error Code: %s', 'quiz-master-next'), '0002'), 'error');
$mlwQuizMasterNext->log_manager->add("Error 0002", $wpdb->last_error.' from '.$wpdb->last_query, 0, 'error');
}
// Hook called after quiz or survey is deleted. Hook passes quiz_id to function
do_action('qmn_quiz_deleted', $quiz_id);
}
/**
* Edits the name of the quiz with the given ID
*
* @access public
* @since 3.7.1
* @param int $quiz_id The ID of the quiz.
* @param string $quiz_name The new name of the quiz.
* @return void
*/
public function edit_quiz_name( $quiz_id, $quiz_name ) {
global $mlwQuizMasterNext;
global $wpdb;
$results = $wpdb->update(
$wpdb->prefix . 'mlw_quizzes',
array(
'quiz_name' => $quiz_name,
),
array( 'quiz_id' => $quiz_id ),
array(
'%s',
),
array( '%d' )
);
if ( false !== $results ) {
$mlwQuizMasterNext->alertManager->newAlert( __( 'The name of your quiz or survey has been updated successfully.', 'quiz-master-next' ), 'success' );
$mlwQuizMasterNext->audit_manager->new_audit( "Quiz/Survey Name Has Been Edited: $quiz_name" );
} else {
$error = $wpdb->last_error;
if ( empty( $error ) ) {
$error = __( 'Unknown error', 'quiz-master-next' );
}
$mlwQuizMasterNext->alertManager->newAlert( __( 'An error occurred while trying to update the name of your quiz or survey. Please try again.', 'quiz-master-next' ), 'error' );
$mlwQuizMasterNext->log_manager->add( 'Error when updating quiz name', "Tried {$wpdb->last_query} but got $error", 0, 'error' );
}
// Fires when the name of a quiz/survey is edited.
do_action( 'qsm_quiz_name_edited', $quiz_id, $quiz_name );
// Legacy code.
do_action( 'qmn_quiz_name_edited', $quiz_id );
}
/**
* Duplicates the quiz with the given ID and gives new quiz the given quiz name
*
* @access public
* @since 3.7.1
* @return void
*/
public function duplicate_quiz($quiz_id, $quiz_name, $is_duplicating_questions)
{
global $mlwQuizMasterNext;
global $wpdb;
$table_name = $wpdb->prefix . "mlw_quizzes";
$mlw_qmn_duplicate_data = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $table_name WHERE quiz_id=%d", $quiz_id ) );
$results = $wpdb->insert(
$table_name,
array(
'quiz_name' => $quiz_name,
'message_before' => $mlw_qmn_duplicate_data->message_before,
'message_after' => $mlw_qmn_duplicate_data->message_after,
'message_comment' => $mlw_qmn_duplicate_data->message_comment,
'message_end_template' => $mlw_qmn_duplicate_data->message_end_template,
'user_email_template' => $mlw_qmn_duplicate_data->user_email_template,
'admin_email_template' => $mlw_qmn_duplicate_data->admin_email_template,
'submit_button_text' => $mlw_qmn_duplicate_data->submit_button_text,
'name_field_text' => $mlw_qmn_duplicate_data->name_field_text,
'business_field_text' => $mlw_qmn_duplicate_data->business_field_text,
'email_field_text' => $mlw_qmn_duplicate_data->email_field_text,
'phone_field_text' => $mlw_qmn_duplicate_data->phone_field_text,
'comment_field_text' => $mlw_qmn_duplicate_data->comment_field_text,
'email_from_text' => $mlw_qmn_duplicate_data->email_from_text,
'question_answer_template' => $mlw_qmn_duplicate_data->question_answer_template,
'leaderboard_template' => $mlw_qmn_duplicate_data->leaderboard_template,
'system' => $mlw_qmn_duplicate_data->system,
'randomness_order' => $mlw_qmn_duplicate_data->randomness_order,
'loggedin_user_contact' => $mlw_qmn_duplicate_data->loggedin_user_contact,
'show_score' => $mlw_qmn_duplicate_data->show_score,
'send_user_email' => $mlw_qmn_duplicate_data->send_user_email,
'send_admin_email' => $mlw_qmn_duplicate_data->send_admin_email,
'contact_info_location' => $mlw_qmn_duplicate_data->contact_info_location,
'user_name' => $mlw_qmn_duplicate_data->user_name,
'user_comp' => $mlw_qmn_duplicate_data->user_comp,
'user_email' => $mlw_qmn_duplicate_data->user_email,
'user_phone' => $mlw_qmn_duplicate_data->user_phone,
'admin_email' => get_option( 'admin_email', 'Enter email' ),
'comment_section' => $mlw_qmn_duplicate_data->comment_section,
'question_from_total' => $mlw_qmn_duplicate_data->question_from_total,
'total_user_tries' => $mlw_qmn_duplicate_data->total_user_tries,
'total_user_tries_text' => $mlw_qmn_duplicate_data->total_user_tries_text,
'certificate_template' => $mlw_qmn_duplicate_data->certificate_template,
'social_media' => $mlw_qmn_duplicate_data->social_media,
'social_media_text' => $mlw_qmn_duplicate_data->social_media_text,
'pagination' => $mlw_qmn_duplicate_data->pagination,
'pagination_text' => $mlw_qmn_duplicate_data->pagination_text,
'timer_limit' => $mlw_qmn_duplicate_data->timer_limit,
'quiz_stye' => $mlw_qmn_duplicate_data->quiz_stye,
'question_numbering' => $mlw_qmn_duplicate_data->question_numbering,
'quiz_settings' => $mlw_qmn_duplicate_data->quiz_settings,
'theme_selected' => $mlw_qmn_duplicate_data->theme_selected,
'last_activity' => date("Y-m-d H:i:s"),
'require_log_in' => $mlw_qmn_duplicate_data->require_log_in,
'require_log_in_text' => $mlw_qmn_duplicate_data->require_log_in_text,
'limit_total_entries' => $mlw_qmn_duplicate_data->limit_total_entries,
'limit_total_entries_text' => $mlw_qmn_duplicate_data->limit_total_entries_text,
'scheduled_timeframe' => $mlw_qmn_duplicate_data->scheduled_timeframe,
'scheduled_timeframe_text' => $mlw_qmn_duplicate_data->scheduled_timeframe_text,
'quiz_views' => 0,
'quiz_taken' => 0,
'deleted' => 0
),
array(
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%d',
'%s',
'%d',
'%d',
'%d',
'%s',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%s',
'%s',
'%d',
'%s',
'%d',
'%s',
'%s',
'%s',
'%d',
'%d',
'%d',
)
);
$mlw_new_id = $wpdb->insert_id;
//Update quiz settings
$update_quiz_settings = unserialize($mlw_qmn_duplicate_data->quiz_settings);
$update_pages = unserialize($update_quiz_settings['pages']);
if ( false != $results ) {
$current_user = wp_get_current_user();
$quiz_post = array(
'post_title' => $quiz_name,
'post_content' => "[mlw_quizmaster quiz=$mlw_new_id]",
'post_status' => 'publish',
'post_author' => $current_user->ID,
'post_type' => 'quiz'
);
$quiz_post_id = wp_insert_post( $quiz_post );
add_post_meta( $quiz_post_id, 'quiz_id', $mlw_new_id );
$mlwQuizMasterNext->alertManager->newAlert(__('Your quiz or survey has been duplicated successfully.', 'quiz-master-next'), 'success');
$mlwQuizMasterNext->audit_manager->new_audit( "New Quiz/Survey Has Been Created: $quiz_name" );
do_action('qmn_quiz_duplicated', $quiz_id, $mlw_new_id);
}
else
{
$mlwQuizMasterNext->alertManager->newAlert(sprintf(__('There has been an error in this action. Please share this with the developer. Error Code: %s', 'quiz-master-next'), '0011'), 'error');
$mlwQuizMasterNext->log_manager->add("Error 0011", $wpdb->last_error.' from '.$wpdb->last_query, 0, 'error');
}
if ($is_duplicating_questions)
{
$table_name = $wpdb->prefix."mlw_questions";
$mlw_current_questions = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_name WHERE deleted=0 AND quiz_id=%d", $quiz_id ) );
foreach ($mlw_current_questions as $mlw_question)
{
$question_results = $wpdb->insert(
$table_name,
array(
'quiz_id' => $mlw_new_id,
'question_name' => $mlw_question->question_name,
'answer_array' => $mlw_question->answer_array,
'answer_one' => $mlw_question->answer_one,
'answer_one_points' => $mlw_question->answer_one_points,
'answer_two' => $mlw_question->answer_two,
'answer_two_points' => $mlw_question->answer_two_points,
'answer_three' => $mlw_question->answer_three,
'answer_three_points' => $mlw_question->answer_three_points,
'answer_four' => $mlw_question->answer_four,
'answer_four_points' => $mlw_question->answer_four_points,
'answer_five' => $mlw_question->answer_five,
'answer_five_points' => $mlw_question->answer_five_points,
'answer_six' => $mlw_question->answer_six,
'answer_six_points' => $mlw_question->answer_six_points,
'correct_answer' => $mlw_question->correct_answer,
'question_answer_info' => $mlw_question->question_answer_info,
'comments' => $mlw_question->comments,
'hints' => $mlw_question->hints,
'question_order' => $mlw_question->question_order,
'question_type_new' => $mlw_question->question_type_new,
'question_settings' => $mlw_question->question_settings,
'category' => $mlw_question->category,
'deleted' => 0
),
array(
'%d',
'%s',
'%s',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d',
'%d',
'%s',
'%d',
'%s',
'%d',
'%s',
'%s',
'%s',
'%d'
)
);
foreach ($update_pages as $pages_key => $pages_value) {
foreach ($pages_value as $pages_k_q => $page_q_id) {
if($page_q_id == $mlw_question->question_id){
$update_pages[$pages_key][$pages_k_q] = $wpdb->insert_id;
}
}
}
if ($question_results == false)
{
$mlwQuizMasterNext->alertManager->newAlert(sprintf(__('There has been an error in this action. Please share this with the developer. Error Code: %s', 'quiz-master-next'), '0020'), 'error');
$mlwQuizMasterNext->log_manager->add("Error 0020", $wpdb->last_error.' from '.$wpdb->last_query, 0, 'error');
}
}
$update_quiz_settings['pages'] = serialize($update_pages);
$wpdb->update(
$wpdb->prefix . "mlw_quizzes",
array(
'quiz_settings' => serialize($update_quiz_settings),
),
array(
'quiz_id' => $mlw_new_id
)
);
}
}
/**
* Retrieves setting store in quiz_settings
*
* @deprecated 6.0.3 Use the get_quiz_setting function in the pluginHelper object.
* @since 3.8.1
* @access public
* @param string $setting_name The slug of the setting.
* @return string The value of the setting
*/
public function get_setting( $setting_name ) {
global $wpdb;
$qmn_settings_array = '';
$qmn_quiz_settings = $wpdb->get_var( $wpdb->prepare( "SELECT quiz_settings FROM " . $wpdb->prefix . "mlw_quizzes" . " WHERE quiz_id=%d", $this->quiz_id ) );
if ( is_serialized( $qmn_quiz_settings ) && is_array( @unserialize( $qmn_quiz_settings ) ) ) {
$qmn_settings_array = @unserialize( $qmn_quiz_settings );
}
if ( is_array( $qmn_settings_array ) && isset( $qmn_settings_array[ $setting_name ] ) ) {
return $qmn_settings_array[ $setting_name ];
} else {
return '';
}
}
/**
* Updates setting stored in quiz_settings
*
* @deprecated 6.0.3 Use the update_quiz_setting function in the pluginHelper object.
* @since 3.8.1
* @access public
* @param string $setting_name The slug of the setting.
* @param mixed $setting_value The value for the setting.
* @return bool True if update was successful
*/
public function update_setting( $setting_name, $setting_value ) {
global $wpdb;
$qmn_settings_array = array();
$qmn_quiz_settings = $wpdb->get_var( $wpdb->prepare( "SELECT quiz_settings FROM " . $wpdb->prefix . "mlw_quizzes" . " WHERE quiz_id=%d", $this->quiz_id ) );
if (is_serialized($qmn_quiz_settings) && is_array(@unserialize($qmn_quiz_settings)))
{
$qmn_settings_array = @unserialize($qmn_quiz_settings);
}
$qmn_settings_array[$setting_name] = $setting_value;
$qmn_serialized_array = serialize($qmn_settings_array);
$results = $wpdb->update(
$wpdb->prefix . "mlw_quizzes",
array(
'quiz_settings' => $qmn_serialized_array
),
array( 'quiz_id' => $this->quiz_id ),
array(
'%s'
),
array( '%d' )
);
if ($results != false)
{
return true;
}
else
{
return false;
}
}
/**
* Deletes setting stored in quiz_settings
*
* @deprecated 6.0.3
* @since 3.8.1
* @access public
* @return void
*/
public function delete_setting( $setting_name ) {
global $wpdb;
$qmn_settings_array = array();
$qmn_quiz_settings = $wpdb->get_var( $wpdb->prepare( "SELECT quiz_settings FROM " . $wpdb->prefix . "mlw_quizzes" . " WHERE quiz_id=%d", $this->quiz_id ) );
if (is_serialized($qmn_quiz_settings) && is_array(@unserialize($qmn_quiz_settings)))
{
$qmn_settings_array = @unserialize($qmn_quiz_settings);
}
if (is_array($qmn_settings_array) && isset($qmn_settings_array[$setting_name]))
{
unset($qmn_settings_array[$setting_name]);
}
$qmn_serialized_array = serialize($qmn_settings_array);
$results = $wpdb->update(
$wpdb->prefix . "mlw_quizzes",
array(
'quiz_settings' => $qmn_serialized_array
),
array( 'quiz_id' => $this->quiz_id ),
array(
'%s'
),
array( '%d' )
);
}
}