'd', 'key' => 'user_id', 'value' => $user_id ), array( 'type' => 's', 'key' => 'short_name', 'value' => $achievement['short_name'] ) ), 1 );
if ( !$achievement_date ) {
$icon = 'cross.png';
$alt = __( 'Achievement has not been unlocked', 'dp-achievements' );
$extra = '';
} else {
$icon = 'tick.png';
$alt = __( 'Achievement has been unlocked', 'dp-achievements' );
$extra = sprintf( ' %s', apply_filters( 'dpa_filter_achievement_date', mysql2date( get_option( 'date_format' ), $achievement_date ) ) );
}
?>
-
'd', 'key' => 'active', 'value' => 1 ) ) );
$total_achievements = array();
$earnt_achievements = array();
foreach ( (array) $categories as $category ) {
$total_achievements[$category] = dpa_get( 'COUNT(short_name)', array( array( 'type' => 's', 'key' => 'category', 'value' => $category ), array( 'type' => 'd', 'key' => 'active', 'value' => 1 ) ) );
}
//number of EARNT achievements PER CATEGORY
foreach ( (array) $categories as $category ) {
$earnt_achievements[$category] = dpa_get_unlocked( 'COUNT(short_name)', array( array( 'type' => 'd', 'key' => 'user_id', 'value' => $user_id ), array( 'type' => 's', 'key' => 'short_name', 'value' => '' ), array( 'type' => 's', 'key' => 'category', 'value' => $category ), array( 'type' => 'd', 'key' => 'active', 'value' => 1 ) ) );
}
$stats = array();
foreach ( (array) $categories as $category ) {
$stats[$category] = array( 'name' => $category,
'total' => $total_achievements[$category],
'earnt' => $earnt_achievements[$category],
'percentage' => ( $earnt_achievements[$category] / $total_achievements[$category] ) * 100 );
}
foreach ( (array) $stats as $s ) {
$class = 'bar';
if ( $s['percentage'] < 100 )
$class .= ' flatright';
?>
'd', 'key' => 'active', 'value' => 1 ) ) );
$percentage = ($earnt / $active) * 100;
$class = 'bar';
if ( $s['percentage'] < 100 )
$class .= ' flatright';
?>
'd', 'key' => 'user_id', 'value' => $user_id ), array( 'type' => 's', 'key' => 'short_name', 'value' => '' ), array( 'type' => 'd', 'key' => 'active', 'value' => 1 ) ), 5, 'achieved_at DESC' );
}
?>