update(
$wpdb->prefix.'mlw_quizzes',
array(
'deleted' => 0,
),
array(
'quiz_id' => sanitize_text_field( intval( $_POST['restore_quiz'] ) ),
),
array(
'%d',
),
array(
'%d',
)
);
if ( ! $restore ) {
?>
'quiz',
'meta_key' => 'quiz_id',
'meta_value' => sanitize_text_field( intval( $_POST['restore_quiz'] ) ),
));
if ( $my_query->have_posts() ) {
while ( $my_query->have_posts() ) {
$my_query->the_post();
$my_post = array(
'ID' => get_the_ID(),
'post_status' => 'publish',
);
wp_update_post( $my_post );
}
}
wp_reset_postdata();
?>
get_results( "SELECT * FROM {$wpdb->prefix}mlw_quizzes WHERE deleted = 1" );
?>
get_var( "SELECT COUNT(trail_id) FROM {$wpdb->prefix}mlw_qm_audit_trail" );
// If user has gone to the next audit page, load current page and beginning.
// Else, start at 0.
if ( isset( $_GET['audit_page'] ) ) {
$page = intval( $_GET['audit_page'] ) + 1;
$begin = $table_limit * $begin;
} else {
$page = 0;
$begin = 0;
}
$left = $audit_total - ( $page * $table_limit );
$audit_trails = $wpdb->get_results( $wpdb->prepare( "SELECT trail_id, action_user, action, time
FROM {$wpdb->prefix}mlw_qm_audit_trail ORDER BY trail_id DESC LIMIT %d, %d", $begin, $table_limit ) );
?>
Total actions since QSM installed:
0 ) {
$previous = $page - 2;
?>
$table_limit ) {
?>
$table_limit ) {
?>
| ID |
|
|
|
";
echo "{$audit->trail_id} | ";
echo "{$audit->action_user} | ";
echo "{$audit->action} | ";
echo "{$audit->time} | ";
echo "";
}
?>