set_filenames(array( 'hall_of_fame' => 'hall_of_fame.tpl') ); $template->assign_vars(array( 'L_RANK' => $lang['boardrank'], 'L_GAME' => $lang['game'], 'L_ARCADE_USER' => $lang['arcade_user'], 'L_SCORE' => $lang['boardscore'], 'L_HELD_TIME' => $lang['held_time'], 'L_DATE' => $lang['boarddate'], 'L_LONGEST_SCORE' => 'Longest Running Highscores') ); $count = 1; $sql ="SELECT g.*, u.username, u.user_id FROM " . GAMES_TABLE. " g LEFT JOIN " . USERS_TABLE. " u ON g.game_highuser = u.user_id WHERE g.game_highscore > 0 ORDER BY g.game_highdate ASC LIMIT 0,10"; if( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, "Cannot access game stats", '', __LINE__, __FILE__, $sql); } while ( $row = $db->sql_fetchrow($result)) { $held_time = time() - $row['game_highdate']; $held_time = sec2hms($held_time); $template->assign_block_vars('record_row', array( 'GAME_NAME' => '' . $row['game_name'] . '', 'USERNAME' => '' . $row['username'] . ' ', 'HIGHSCORE' => number_format($row['game_highscore']), 'HIGHSCORE_DATE' => create_date( $board_config['default_dateformat'] , $row['game_highdate'] , $board_config['board_timezone'] ), 'COUNT' => $count, 'HELD_TIME' => $held_time )); $count++; } $template->assign_var_from_handle('HALL_OF_FAME', 'hall_of_fame'); ?>