html username color for the side box ,,Latest Scores..
v3Arcade Mod Version: 2.0.3A..
Need to edit includes/v3arcade_functions.php
Fine: // ##### Update Latest Scores Cache #####
Replace just the Update Latest Scores Cache code with this:
Code:
// ##### Update Latest Scores Cache ###########################################
function build_arcade_latest()
{
global $vbulletin;
if (!$vbulletin->options['arcadelatescores'])
{
return false;
}
$cache = array(
'scoreslimit' => $vbulletin->options['arcadelatescores'],
'scores' => array()
);
// Show the latest scores, excluding tournament events
$latest = $vbulletin->db->query_read("
SELECT sessions.*, games.title, user.username, user.userid, user.usergroupid
FROM " . TABLE_PREFIX . "v3arcade_sessions AS sessions
LEFT JOIN " . TABLE_PREFIX . "v3arcade_games AS games ON (sessions.gameid = games.gameid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (sessions.userid = user.userid)
WHERE valid = 1
AND tourid = 0
ORDER BY finish DESC
LIMIT " . $vbulletin->options['arcadelatescores']
);
while ($late = $vbulletin->db->fetch_array($latest))
{
$late['username'] = fetch_musername($late);
$late['score'] = v3_score_format($late['score']);
$cache['scores'][] = $late;
}
build_datastore('v3a_newscores', serialize($cache), 1);
return $cache;
}
Important:It will update the user color after someone plays a game..
Bookmarks