pluginHelper->get_admin_results_tabs(); ?>
pluginHelper->register_admin_results_tab( __( 'Quiz Results', 'quiz-master-next' ), 'qsm_results_overview_tab_content' ); } add_action( 'plugins_loaded', 'qsm_results_overview_tab' ); /** * Generates HTML For Overview Tab * * @since 5.0.0 * @return void */ function qsm_results_overview_tab_content() { global $wpdb; global $mlwQuizMasterNext; // If nonce is correct, delete results. if ( isset( $_POST['delete_results_nonce'] ) && wp_verify_nonce( $_POST['delete_results_nonce'], 'delete_results') ) { // Variables from delete result form. $mlw_delete_results_id = intval( $_POST['result_id'] ); $mlw_delete_results_name = sanitize_text_field( $_POST['delete_quiz_name'] ); // Updates table to mark results as deleted. $results = $wpdb->update( $wpdb->prefix . 'mlw_results', array( 'deleted' => 1, ), array( 'result_id' => $mlw_delete_results_id ), array( '%d', ), array( '%d' ) ); if ( false === $results ) { $error = $wpdb->last_error; if ( empty( $error ) ) { $error = __( 'Unknown error', 'quiz-master-next' ); } $mlwQuizMasterNext->alertManager->newAlert( sprintf( __( 'There was an error when deleting this result. Error from WordPress: %s', 'quiz-master-next' ), $error ), 'error' ); $mlwQuizMasterNext->log_manager->add( 'Error deleting result', "Tried {$wpdb->last_query} but got $error.", 0, 'error' ); } else { $mlwQuizMasterNext->alertManager->newAlert( __('Your results has been deleted successfully.','quiz-master-next' ), 'success'); $mlwQuizMasterNext->audit_manager->new_audit( "Results Has Been Deleted From: $mlw_delete_results_name" ); } } // Check if bulk delete has been selected. If so, verify nonce. if ( isset( $_POST["bulk_delete"] ) && wp_verify_nonce( $_POST['bulk_delete_nonce'], 'bulk_delete') ) { // Ensure the POST variable is an array if ( is_array( $_POST["delete_results"] ) ) { // Cycle through the POST array which should be an array of the result ids of the results the user wishes to delete foreach( $_POST["delete_results"] as $result ) { // Santize by ensuring the value is an int $result_id = intval( $result ); $wpdb->update( $wpdb->prefix."mlw_results", array( 'deleted' => 1, ), array( 'result_id' => $result_id ), array( '%d' ), array( '%d' ) ); } $mlwQuizMasterNext->audit_manager->new_audit( "Results Have Been Bulk Deleted" ); } } // Prepares the SQL to retrieve the results. $table_limit = 40; $search_phrase_sql = ''; $order_by_sql = 'ORDER BY result_id DESC'; if ( isset( $_GET['qsm_search_phrase'] ) && ! empty( $_GET['qsm_search_phrase'] ) ) { // Sanitizes the search phrase and then uses $wpdb->prepare to properly escape the queries after using $wpdb->esc_like. $sanitized_search_phrase = sanitize_text_field( $_GET['qsm_search_phrase'] ); $search_phrase_percents = '%' . $wpdb->esc_like( $sanitized_search_phrase ) . '%'; $search_phrase_sql = $wpdb->prepare( ' AND (quiz_name LIKE %s OR name LIKE %s OR business LIKE %s OR email LIKE %s OR phone LIKE %s)', $search_phrase_percents, $search_phrase_percents, $search_phrase_percents, $search_phrase_percents, $search_phrase_percents ); $qsm_results_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(result_id) FROM {$wpdb->prefix}mlw_results WHERE deleted='0' AND (quiz_name LIKE %s OR name LIKE %s OR business LIKE %s OR email LIKE %s OR phone LIKE %s)", $search_phrase_percents, $search_phrase_percents, $search_phrase_percents, $search_phrase_percents, $search_phrase_percents ) ); } else { $qsm_results_count = $wpdb->get_var( "SELECT COUNT(result_id) FROM {$wpdb->prefix}mlw_results WHERE deleted = '0'" ); } // Gets the order by arg. Uses switch to create SQL to prevent SQL injection. if ( isset( $_GET['qmn_order_by'] ) ) { switch ( $_GET['qmn_order_by'] ) { case 'quiz_name': $order_by = 'quiz_name'; $order_by_sql = ' ORDER BY quiz_name DESC'; break; case 'name': $order_by = 'name'; $order_by_sql = ' ORDER BY name DESC'; break; case 'point_score': $order_by = 'point_score'; $order_by_sql = ' ORDER BY point_score DESC'; break; case 'correct_score': $order_by = 'correct_score'; $order_by_sql = ' ORDER BY correct_score DESC'; break; default: $order_by = 'quiz_name'; $order_by_sql = ' ORDER BY result_id DESC'; } } if ( isset( $_GET['qsm_results_page'] ) ) { $result_page = intval( $_GET['qsm_results_page'] ) + 1; $result_begin = $table_limit * $result_page; } else { $result_page = 0; $result_begin = 0; } $results_left = $qsm_results_count - ( $result_page * $table_limit ); if ( isset( $_GET['quiz_id'] ) && ! empty( $_GET['quiz_id'] ) ) { $quiz_id = intval( $_GET['quiz_id'] ); $mlw_quiz_data = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}mlw_results WHERE deleted='0' AND quiz_id = %d $search_phrase_sql $order_by_sql LIMIT %d, %d", $quiz_id, $result_begin, $table_limit ) ); } else { $mlw_quiz_data = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}mlw_results WHERE deleted = '0' $search_phrase_sql $order_by_sql LIMIT %d, %d", $result_begin, $table_limit ) ); } wp_enqueue_script( 'jquery' ); wp_enqueue_script( 'jquery-ui-core' ); wp_enqueue_script( 'jquery-ui-dialog' ); wp_enqueue_script( 'jquery-ui-button' ); wp_enqueue_script( 'qmn_admin_js', plugins_url( '../../js/admin.js', __FILE__ ) ); wp_enqueue_style( 'qmn_jquery_redmond_theme', plugins_url( '../../css/jquery-ui.css', __FILE__ ) ); wp_enqueue_style( 'qsm_admin_style', plugins_url( '../../css/qsm-admin.css', __FILE__ ), array() ); ?>