Leaders
Accuracy
get_results( "SELECT * FROM scores WHERE game_id = 1 ORDER BY score DESC LIMIT 5;" );
$scores_count = count( $scores_found );
if( $scores_count < 5 )
{
$pad_count = ( 5 - $scores_count );
for ($i=0; $i < $pad_count; $i++)
{
$scores_found[] = (object) array(
'score' => 0,
'user_name' => '-',
'user_avatar' => $template_url.'/assets/main/img/elements/default.jpg'
);
}
}
foreach( $scores_found as $entry )
{
?>
1st
PTS
get_results( "SELECT * FROM scores WHERE game_id = 2 ORDER BY score DESC LIMIT 5;" );
$scores_count = count( $scores_found );
if( $scores_count < 5 )
{
$pad_count = ( 5 - $scores_count );
for ($i=0; $i < $pad_count; $i++)
{
$scores_found[] = (object) array(
'score' => 0,
'user_name' => '-',
'user_avatar' => $template_url.'/assets/main/img/elements/default.jpg'
);
}
}
foreach( $scores_found as $entry )
{
?>
1st
PTS
get_results( "SELECT * FROM scores WHERE game_id = 3 ORDER BY score DESC LIMIT 5;" );
$scores_count = count( $scores_found );
if( $scores_count < 5 )
{
$pad_count = ( 5 - $scores_count );
for ($i=0; $i < $pad_count; $i++)
{
$scores_found[] = (object) array(
'score' => 0,
'user_name' => '-',
'user_avatar' => $template_url.'/assets/main/img/elements/default.jpg'
);
}
}
foreach( $scores_found as $entry )
{
?>
1st
PTS
get_results( "SELECT * FROM scores WHERE game_id = 4 ORDER BY score DESC LIMIT 5;" );
$scores_count = count( $scores_found );
if( $scores_count < 5 )
{
$pad_count = ( 5 - $scores_count );
for ($i=0; $i < $pad_count; $i++)
{
$scores_found[] = (object) array(
'score' => 0,
'user_name' => '-',
'user_avatar' => $template_url.'/assets/main/img/elements/default.jpg'
);
}
}
foreach( $scores_found as $entry )
{
?>
1st
PTS
Upcoming
Events
ID );
$event_location = get_field( 'event_location', $event->ID );
$event_date = get_field( 'event_date', $event->ID );
$event_conclusion = get_field( 'event_conclusion', $event->ID );
$event_url = get_field( 'event_url', $event->ID );
$date_number = date( 'd', strtotime($event_date) );
$date_day = date( 'D', strtotime($event_date) );
$date_month = date( 'M', strtotime($event_date) );
if( $event_url != '' )
{
?>