get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '" . date( "Y-m-d", current_time( 'timestamp' ) )." 00:00:00' AND '" . date( "Y-m-d", current_time( 'timestamp' ) )." 23:59:59') AND deleted=0"); $mlw_last_week = mktime(0, 0, 0, date("m") , date("d")-7, date("Y")); $mlw_last_week = date("Y-m-d", $mlw_last_week); $mlw_qmn_last_weekday_taken = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$mlw_last_week." 00:00:00' AND '".$mlw_last_week." 23:59:59') AND deleted=0"); if ($mlw_qmn_last_weekday_taken != 0) { $mlw_qmn_analyze_today = round((($mlw_qmn_today_taken - $mlw_qmn_last_weekday_taken) / $mlw_qmn_last_weekday_taken) * 100, 2); } else { $mlw_qmn_analyze_today = $mlw_qmn_today_taken * 100; } $mlw_this_week = mktime(0, 0, 0, date("m") , date("d")-6, date("Y")); $mlw_this_week = date("Y-m-d", $mlw_this_week); $mlw_qmn_this_week_taken = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$mlw_this_week." 00:00:00' AND '".date("Y-m-d")." 23:59:59') AND deleted=0"); $mlw_last_week_start = mktime(0, 0, 0, date("m") , date("d")-13, date("Y")); $mlw_last_week_start = date("Y-m-d", $mlw_last_week_start); $mlw_last_week_end = mktime(0, 0, 0, date("m") , date("d")-7, date("Y")); $mlw_last_week_end = date("Y-m-d", $mlw_last_week_end); $mlw_qmn_last_week_taken = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$mlw_last_week_start." 00:00:00' AND '".$mlw_last_week_end." 23:59:59') AND deleted=0"); if ($mlw_qmn_last_week_taken != 0) { $mlw_qmn_analyze_week = round((($mlw_qmn_this_week_taken - $mlw_qmn_last_week_taken) / $mlw_qmn_last_week_taken) * 100, 2); } else { $mlw_qmn_analyze_week = $mlw_qmn_this_week_taken * 100; } $mlw_this_month = mktime(0, 0, 0, date("m") , date("d")-29, date("Y")); $mlw_this_month = date("Y-m-d", $mlw_this_month); $mlw_qmn_this_month_taken = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$mlw_this_month." 00:00:00' AND '".date("Y-m-d")." 23:59:59') AND deleted=0"); $mlw_last_month_start = mktime(0, 0, 0, date("m") , date("d")-59, date("Y")); $mlw_last_month_start = date("Y-m-d", $mlw_last_month_start); $mlw_last_month_end = mktime(0, 0, 0, date("m") , date("d")-30, date("Y")); $mlw_last_month_end = date("Y-m-d", $mlw_last_month_end); $mlw_qmn_last_month_taken = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$mlw_last_month_start." 00:00:00' AND '".$mlw_last_month_end." 23:59:59') AND deleted=0"); if ($mlw_qmn_last_month_taken != 0) { $mlw_qmn_analyze_month = round((($mlw_qmn_this_month_taken - $mlw_qmn_last_month_taken) / $mlw_qmn_last_month_taken) * 100, 2); } else { $mlw_qmn_analyze_month = $mlw_qmn_this_month_taken * 100; } $mlw_this_quater = mktime(0, 0, 0, date("m") , date("d")-89, date("Y")); $mlw_this_quater = date("Y-m-d", $mlw_this_quater); $mlw_qmn_this_quater_taken = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$mlw_this_quater." 00:00:00' AND '".date("Y-m-d")." 23:59:59') AND deleted=0"); $mlw_last_quater_start = mktime(0, 0, 0, date("m") , date("d")-179, date("Y")); $mlw_last_quater_start = date("Y-m-d", $mlw_last_quater_start); $mlw_last_quater_end = mktime(0, 0, 0, date("m") , date("d")-90, date("Y")); $mlw_last_quater_end = date("Y-m-d", $mlw_last_quater_end); $mlw_qmn_last_quater_taken = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "mlw_results WHERE (time_taken_real BETWEEN '".$mlw_last_quater_start." 00:00:00' AND '".$mlw_last_quater_end." 23:59:59') AND deleted=0"); if ($mlw_qmn_last_quater_taken != 0) { $mlw_qmn_analyze_quater = round((($mlw_qmn_this_quater_taken - $mlw_qmn_last_quater_taken) / $mlw_qmn_last_quater_taken) * 100, 2); } else { $mlw_qmn_analyze_quater = $mlw_qmn_this_quater_taken * 100; } $mlw_stat_total_active_quiz = $wpdb->get_var( "SELECT COUNT(*) FROM ".$wpdb->prefix."mlw_quizzes WHERE deleted=0 LIMIT 1" ); $mlw_stat_total_questions = $wpdb->get_var( "SELECT COUNT(*) FROM ".$wpdb->prefix."mlw_questions WHERE deleted=0 LIMIT 1" ); $mlw_stat_most_popular_quiz = $wpdb->get_row( "SELECT quiz_name FROM ".$wpdb->prefix."mlw_quizzes WHERE deleted=0 ORDER BY quiz_taken Desc LIMIT 1" ); $mlw_stat_least_popular_quiz = $wpdb->get_row( "SELECT quiz_name FROM ".$wpdb->prefix."mlw_quizzes WHERE deleted=0 ORDER BY quiz_taken ASC LIMIT 1" ); ?>