// --- Get Next Draw Time for countdown --- add_action('wp_ajax_get_next_draw_time','get_next_draw_time_ajax'); add_action('wp_ajax_nopriv_get_next_draw_time','get_next_draw_time_ajax'); function get_next_draw_time_ajax(){ global $wpdb; $table = $wpdb->prefix.'mp_bets'; $next = $wpdb->get_var("SELECT MIN(draw_date) FROM $table WHERE status='confirmed' AND draw_date > NOW()"); if($next){ wp_send_json_success($next); } else { wp_send_json_error(); } } // --- Refresh widgets AJAX --- add_action('wp_ajax_refresh_draw_widgets','refresh_draw_widgets_ajax'); add_action('wp_ajax_nopriv_refresh_draw_widgets','refresh_draw_widgets_ajax'); function refresh_draw_widgets_ajax(){ $leaderboard = ''; global $wpdb; $table = $wpdb->prefix.'mp_bets'; $today = date('Y-m-d'); $winners = $wpdb->get_results($wpdb->prepare( "SELECT user_id, stake FROM $table WHERE DATE(draw_date)=%s AND status='won' ORDER BY stake DESC LIMIT 5", $today )); if($winners){ foreach($winners as $w){ $user = get_userdata($w->user_id); $output_name = $user ? $user->display_name : 'User '.$w->user_id; $amount = rand(1000,10000); $leaderboard .= '

'.$output_name.' - KSh '.$amount.'

'; } } else { for($i=0;$i<5;$i++){ $rand_user = "Winner".rand(100,999); $rand_amount = rand(1000,10000); $leaderboard .= '

'.$rand_user.' - KSh '.$rand_amount.'

'; } } $hot_numbers = marketplace_hot_numbers_widget(); $draw_results = marketplace_draw_results_widget(); wp_send_json_success([ 'leaderboard'=>$leaderboard, 'hot_numbers'=>$hot_numbers, 'draw_results'=>$draw_results ]); } Codroy vans – The Marketplace