[insert_php]
global $wpdb;
$result = $wpdb->get_results( "SELECT * from `wp_bp_activity` WHERE `user_id` = 158 AND `secondary_item_id` = 15712 ORDER BY `wp_bp_activity`.`id` DESC”);
$starttime = $result[0]->date_recorded;
$metaid = $result[1]->id;
$endtime = $result[2]->date_recorded;
echo "Quiz Start Time: ".$starttime. "
". "Quiz End Time: ".$endtime . "
". ” Activity Meta ID: ". $metaid. "";
$result1 = $wpdb->get_results( "SELECT * FROM `wp_bp_activity_meta` WHERE `activity_id`= $metaid ");
$quizdetails = $result1[2]->meta_value;
$quizd = (unserialize($quizdetails));
echo "
Obtained Marks: ". $quizd[user_marks]. "";
echo "
Total Marks: ". $quizd[total_marks]. "";
$result5 = $wpdb->get_results( "SELECT wp_bp_activity.user_id, wp_bp_activity.secondary_item_id, wp_bp_activity_meta.meta_value, wp_bp_activity_meta.activity_id, wp_bp_activity.id
FROM wp_bp_activity, wp_bp_activity_meta
WHERE wp_bp_activity.id=wp_bp_activity_meta.activity_id AND wp_bp_activity.secondary_item_id = 10395 AND `user_id` = 191 AND wp_bp_activity_meta.meta_key = ‘percentage’
ORDER BY CAST(meta_value AS UNSIGNED) desc , wp_bp_activity.id DESC”);
echo ‘
'; print_r($result5); echo '
‘;
[/insert_php]
$result5 = $wpdb->get_results("SELECT meta_key as user_id, meta_value as marks FROM wp_postmeta WHERE meta_key REGEXP ‘^[0-9]+$’ AND post_id = %d ORDER BY CAST(meta_value AS DECIMAL(10,2)) DESC LIMIT 0,%d”,3504,10);