QuizzesReportsGenerator::addQuizActivityFields( $strFields, $queryArgs )
Add quiz activity fields on sql statement
Description
Source
File: bp-integrations/learndash/buddypress/generators/QuizzesReportsGenerator.php
public function addQuizActivityFields($strFields, $queryArgs) { global $wpdb; $metaTable = $wpdb->prefix ."learndash_user_activity_meta"; $table = $wpdb->prefix ."learndash_user_activity"; $strFields .= ", ( SELECT mt_points.activity_meta_value FROM {$metaTable} as mt_points WHERE mt_points.activity_id = ld_user_activity.activity_id AND mt_points.activity_meta_key = 'points' ) as activity_points "; $strFields .= ", ( SELECT mt_score.activity_meta_value FROM {$metaTable} as mt_score WHERE mt_score.activity_id = ld_user_activity.activity_id AND mt_score.activity_meta_key = 'percentage' ) as activity_score "; $strFields .= ", ( SELECT mt_time_spent.activity_meta_value FROM {$metaTable} as mt_time_spent WHERE mt_time_spent.activity_id = ld_user_activity.activity_id AND mt_time_spent.activity_meta_key = 'timespent' ) as activity_time_spent "; $strFields .= ", ( SELECT count(*) FROM {$table} as mt_attempts WHERE mt_attempts.post_id = posts.ID AND mt_attempts.user_id = users.ID ) as activity_attemps "; return $strFields; }
Changelog
Version | Description |
---|---|
BuddyBoss 1.0.0 | Introduced. |
Questions?
We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.