[insert_php]
global $current_user;
get_currentuserinfo();
/*echo ‘Username: ‘ . $current_user->user_login . “\n”;
echo ‘User email: ‘ . $current_user->user_email . “\n”;
echo ‘User level: ‘ . $current_user->user_level . “\n”;
echo ‘User first name: ‘ . $current_user->user_firstname . “\n”;
echo ‘User last name: ‘ . $current_user->user_lastname . “\n”;
echo ‘User display name: ‘ . $current_user->display_name . “\n”;
echo ‘User ID: ‘ . $current_user->ID . “\n”;*/
global $wpdb;
$results = $wpdb->get_results( “SELECT * FROM wpsu_wpcw_user_progress_quizzes WHERE user_id = ‘”.$current_user->ID.”‘”);
foreach ($results as $result)
{
echo $result->quiz_grade;
if ($result->quiz_grade < 75)
{
echo 'Start Quiz‘;
}
else {
echo “
You have already passed the quiz.
“;
echo “
Download Your Credentials
“;
global $wpdb;
$certIDs = $wpdb->get_results( “SELECT cert_access_key FROM wpsu_wpcw_certificates WHERE cert_user_id = ‘”.$current_user->ID.”‘”);
foreach ($certIDs as $certID) {
$certID->cert_access_key;
}
$certLink = ‘Download Badge & Presentation‘;
}
}
[/insert_php]