Gamebit Username HTML Markup

[stangger5]

html username color for Gamebit on Main arcade page.
v3Arcade Mod Version: 2.0.3A..

Need to edit arcade.php

Fine: // ##### Let the games begin!
Replace just the // ##### Let the games begin code with this:

	// ##### Let the games begin!
	$gamebits = '';
	$categorygamecnt = '0';

	// No category id, so show a random selection of games.
	if (!$vbulletin->GPC['categoryid'])
	{
		$games = $db->query_read("
			SELECT arcade_games.*, user.username, user.usergroupid , arcade_categories.catname
			FROM " . TABLE_PREFIX . "v3arcade_games AS arcade_games
			LEFT JOIN " . TABLE_PREFIX . "user AS user ON (arcade_games.highscorerid = user.userid)
			LEFT JOIN " . TABLE_PREFIX . "v3arcade_categories AS arcade_categories ON (arcade_games.categoryid = arcade_categories.categoryid)
			" . iif($bitfieldcheck, "WHERE $bitfieldcheck") . "
			ORDER BY RAND()
			LIMIT " . $vbulletin->options['gamesperpage']
		);
          $categorygamecnt = $db->num_rows($games);
	}
	// Favorites
	else if ($vbulletin->GPC['categoryid'] == 2)
	{
		$gamecount = sizeof($favcache);

		if ($gamecount)
		{
			// set defaults
			sanitize_pageresults($gamecount, $pagenumber, $perpage, 100, $vbulletin->options['gamesperpage']);

			$start = (int)($perpage * $pagenumber) - $perpage;

			$games = $db->query_read("
				SELECT arcade_games.*, user.username, user.usergroupid , arcade_categories.catname
				FROM " . TABLE_PREFIX . "v3arcade_games AS arcade_games
				LEFT JOIN " . TABLE_PREFIX . "user AS user ON (arcade_games.highscorerid = user.userid)
				LEFT JOIN " . TABLE_PREFIX . "v3arcade_categories AS arcade_categories ON (arcade_games.categoryid = arcade_categories.categoryid)
				WHERE arcade_games.gameid IN (" . implode(',', $favcache) . ")
					" . iif($bitfieldcheck, 'AND ' . $bitfieldcheck) . "
				LIMIT $start, " . $vbulletin->options['gamesperpage']
			);
			$categorygamecnt = $db->num_rows($games);
		}
	}
	// Get games only from the specified category id.
	else
	{
		$querywhere = '';
          $queryorder = 'title ASC';

		// Newest Games
          if ($vbulletin->GPC['categoryid'] == -2)
          {
               $queryorder = 'arcade_games.gameid DESC';
               $categoryname = $vbphrase['new'];
          }

		//if ($vbulletin->GPC['categoryid'] != -1)
		if ($vbulletin->GPC['categoryid'] >= 0)
		{
			$querywhere = 'arcade_games.categoryid = ' . $vbulletin->GPC['categoryid'];
		}

		if ($bitfieldcheck)
		{
			$querywhere = ($querywhere ? $querywhere . ' AND ' : '') . $bitfieldcheck;
		}

		if ($querywhere)
		{
			$querywhere = 'WHERE ' . $querywhere;
		}

		if ($queryorder)
		{
			$queryorder = 'ORDER BY ' . $queryorder;
		}

		// First of all, get a total game count.
		$countquery = $db->query_first("
			SELECT COUNT(*) AS gamecount
			FROM " . TABLE_PREFIX . "v3arcade_games AS arcade_games
			$querywhere
		");
		$gamecount = $countquery['gamecount'];
          $categorygamecnt = $countquery['gamecount'];

		// set defaults
		sanitize_pageresults($gamecount, $pagenumber, $perpage, 100, $vbulletin->options['gamesperpage']);

		$start = (int)($perpage*$pagenumber)-$perpage;

		$games = $db->query_read("
			SELECT arcade_games.*, user.username, user.usergroupid , arcade_categories.catname
			FROM " . TABLE_PREFIX . "v3arcade_games AS arcade_games
			LEFT JOIN " . TABLE_PREFIX . "user AS user ON (arcade_games.highscorerid = user.userid)
			LEFT JOIN " . TABLE_PREFIX . "v3arcade_categories AS arcade_categories ON (arcade_games.categoryid = arcade_categories.categoryid)
			$querywhere
               $queryorder
			LIMIT $start, " . $vbulletin->options['gamesperpage']
		);
	}

	if ($db->num_rows($games))
	{
		// Page navigation
		if ($vbulletin->GPC['categoryid'])
		{
			$pagenav = construct_page_nav(
				$pagenumber,
				$perpage,
				$gamecount,
				'arcade.php?' . $vbulletin->session->vars['sessionurl'],
				($vbulletin->GPC['categoryid'] ? '&categoryid=' . $vbulletin->GPC['categoryid'] : '')
				. ($vbulletin->GPC['perpage'] ? '&pp=' . $perpage : '')
			);
		}

		// Game cache contains all the data we need to populate the game row - image links, titles, descriptions, etc.
		$gamecache = array();

		while ($game = $db->fetch_array($games))
		{
			/* Now, because we need to use this data to let us know which games to get score data for,
			we're caching it here rather than spitting out the game rows. */
			$gamecache[$game['gameid']] = $game;
		}

		// Only bother with high scores if the user is actually logged in.
		if ($vbulletin->userinfo['userid'])
		{
			$scoredata = $db->query_read("
				SELECT MAX(score) AS personalbest, MIN(score) AS personalbestr, gameid
				FROM " . TABLE_PREFIX . "v3arcade_sessions
				WHERE gameid IN (" . implode(',', array_keys($gamecache)) . ")
					AND userid = " . $vbulletin->userinfo['userid'] . "
				GROUP BY gameid
			");
			while ($score = $db->fetch_array($scoredata))
			{
				// Add this data to the $gamecache array
				$gamecache[$score['gameid']]['personalbest'] = ($gamecache[$score['gameid']]['isreverse'] ? $score['personalbestr'] : $score['personalbest']);
			}
		}

		$gamebit_tempname = ($barsize) ? 'v3arcade_game_bit_slim' : 'v3arcade_game_bit';

		// Now we can use $gamecache to populate our game section.
		foreach ($gamecache as $key => $game)
		{
			exec_switch_bg();

			$show['rating'] = false;
			if ($game['votecount'])
			{
				$game['rating_acc'] = round(($game['votepoints'] / $game['votecount']), 2);
				$game['rating'] = ceil($game['rating_acc']);
				$show['rating'] = true;
			}

			$show['fav'] = $favcache[$game['gameid']];

			$game['awardimg'] = arcade_award_img($game);

			($hook = vBulletinHook::fetch_hook('arcade_game_bit')) ? eval($hook) : false;

			// set these below the hook incase anyone needs to do raw score comparing
			$game['highscore'] = v3_score_format($game['highscore']);
			$game['personalbest'] = vb_number_format($game['personalbest']);

                        $game['username'] = fetch_musername($game);

			$templater = vB_Template::create($gamebit_tempname);
			$templater->register('game', $game);
			$gamebits .= $templater->render();
		}
	}

[lagrace]

hello and thank you for sharing