PDA

View Full Version : Latest Scores Username HTML Markup



stangger5
01-24-2021, 11:23 AM
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:


// ##### 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..

lagrace
01-24-2021, 05:38 PM
hello and thank you for sharing