649 lines
21 KiB
PHP
649 lines
21 KiB
PHP
|
|
<?php
|
||
|
|
if ( ! defined( 'ABSPATH' ) ) {
|
||
|
|
exit;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* QMN Quiz Creator Class
|
||
|
|
*
|
||
|
|
* This class handles quiz creation, update, and deletion from the admin panel
|
||
|
|
*
|
||
|
|
* The Quiz Creator class handles all the quiz management functions that is done from the admin panel
|
||
|
|
*
|
||
|
|
* @since 3.7.1
|
||
|
|
*/
|
||
|
|
class QMNQuizCreator {
|
||
|
|
|
||
|
|
/**
|
||
|
|
* QMN ID of quiz
|
||
|
|
*
|
||
|
|
* @var object
|
||
|
|
* @since 3.7.1
|
||
|
|
*/
|
||
|
|
private $quiz_id;
|
||
|
|
|
||
|
|
/**
|
||
|
|
* If the quiz ID is set, store it as the class quiz ID
|
||
|
|
*
|
||
|
|
* @since 3.7.1
|
||
|
|
*/
|
||
|
|
public function __construct() {
|
||
|
|
if ( isset( $_GET['quiz_id'] ) ) {
|
||
|
|
$this->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. <br>%CONTACT_ALL% <br>%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%<br /> Answer Provided: %USER_ANSWER%<br /> Correct Answer: %CORRECT_ANSWER%<br /> Comments Entered: %USER_COMMENTS%<br />',
|
||
|
|
'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' )
|
||
|
|
);
|
||
|
|
}
|
||
|
|
}
|