V3Arcade - Game Rating addon

V3Arcade - Game Rating addon

Mod Version: 1.00, by GenSec

This modification is in the archives.

vB Version: 3.0.3	Rating: (0 vote - 0 average)	Installs: 24
Released: 07 Nov 2004	Last Update: Never	Downloads: 3
Not Supported

These hack adds rating system for your arcade games.

Files to edit: 1
Templates to edit: 2
Files to add: 1

Add 1 new db table + 2 changes for games table

Very easy to install...
################################################################################ ################
Before the installation!
Please make a Backup of your database and the changed files!
################################################################################ ################

1. ADD this to MySQL DB using phpmyadmin or admincp :

Code:

ALTER TABLE `games` ADD `votetotal` smallint(5)  UNSIGNED DEFAULT '0' NOT NULL ;
ALTER TABLE `games` ADD `votenum` smallint(5)  UNSIGNED DEFAULT '0' NOT NULL ;
CREATE TABLE `game_rate` (
  `gamerateid` int(11) NOT NULL auto_increment,
  `gameid` int(11) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `vote` smallint(5) default NULL,
  `ipaddress` char(15) NOT NULL default '',
  PRIMARY KEY  (`gamerateid`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

2. Upload gamerate.php to your forumroot directory.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
There are somу redirects phrases like "redirect_threadrate_add", "error_threadratevoted" etc.
You саn change them to similar with the word "game" instead of "thread".
I didn't. And it works fine on my board.

3. Edit arcade.php
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Find:

Code:

$phrasegroups = array();

Change to:

Code:

$phrasegroups = array('arcade','showthread');

* in case you decide to use the above "thread" phrases

Find:

Code:

	// While loop constructs the $gamebits variable, with games where scores have been recorded
	while ($game = $DB_site->fetch_array($result_topscore2)) {

Add right after:

Code:

      // display ratings if enabled
    	if ($game['votenum'] > 0)
	    {
		$game['voteavg'] = vb_number_format($game['votetotal'] / $game['votenum'], 2);
		$game['rating'] = round($game['voteavg']);
		} else { 
        $game['rating']=0;
	    }
        //

Find:

Code:

$thisGame = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "games WHERE gameid=$gameid");

Add right after:

Code:

// display ratings if enabled
$show['rating'] = false;
	if ($thisGame['votenum'] > 0)
	{
		$thisGame['voteavg'] = vb_number_format($thisGame['votetotal'] / $thisGame['votenum'], 2);
		$game['rating'] = round($thisGame['voteavg']);
			$show['rating'] = true;
	}
	 if ($rating = $DB_site->query_first("
	 	SELECT vote, gamerateid FROM " . TABLE_PREFIX . "game_rate
		WHERE userid = $bbuserinfo[userid] AND gameid = $gameid
	")) {
    		if ($$rating['vote'])
 	          {
				$voteselected["$rating[vote]"] = HTML_SELECTED;
				$votechecked["$rating[vote]"] = HTML_CHECKED;
			  }	else {
				$voteselected[0] = HTML_SELECTED;
				$votechecked[0] = HTML_CHECKED;
			  }
     }
//

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Save arcade.php

4. Edit arcade templates

to place the voting form in play control panel

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

In arcade_play template find:

Code:

<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%"> 
  <tr> 
    <td class="thead" colspan="2"><span class="smallfont">$thisGame[title]</span></td> 
  </tr>

Add right after:

Code:

<tr>
<td class="alt2" align="center" id="gamerating" nowrap="nowrap"><span class="smallfont">
<a href="#goto_gamerating">
<if condition="$show['rating']">$vbphrase[rating]</a>: <img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$game[rating].gif" alt="<phrase 1="$thisGame[votenum]" 2="$thisGame[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" />
                  <else />$vbphrase[rate_thread]</a></if>
<if condition="$show['popups']"><script type="text/javascript"> vbmenu_register("gamerating"); </script></if>
</span></td></tr>

Find:

Code:

 <tr><td class="alt1" align="center"><img src="$stylevar[imgdir_arcade]/backtip.gif" border=0></td>
</table>
</td>
</tr></table>

Add right after:

Code:

<div class="vbmenu_popup" id="gamerating_menu" style="display:none">
<form action="gamerate.php" method="post">
	<table cellpadding="4" cellspacing="1" border="0">
	<tr>
		<td class="thead">Зацени игру<a name="goto_gamerating"></a></td>
	</tr>
	<tr>
		<td class="vbmenu_option" title="nohilite">
		<div><img class="inlineimg" src="$stylevar[imgdir_rating]/rating_5.gif" alt="$vbphrase[excellent]" /><label for="vote5"><input type="radio" name="vote" id="vote5" value="5" $votechecked[5] />$vbphrase[excellent]</label></div>
		<div><img class="inlineimg" src="$stylevar[imgdir_rating]/rating_4.gif" alt="$vbphrase[good]" /><label for="vote4"><input type="radio" name="vote" id="vote4" value="4" $votechecked[4] />$vbphrase[good]</label></div>
		<div><img class="inlineimg" src="$stylevar[imgdir_rating]/rating_3.gif" alt="$vbphrase[average]" /><label for="vote3"><input type="radio" name="vote" id="vote3" value="3" $votechecked[3] />$vbphrase[average]</label></div>
		<div><img class="inlineimg" src="$stylevar[imgdir_rating]/rating_2.gif" alt="$vbphrase[bad]" /><label for="vote2"><input type="radio" name="vote" id="vote2" value="2" $votechecked[2] />$vbphrase[bad]</label></div>
		<div><img class="inlineimg" src="$stylevar[imgdir_rating]/rating_1.gif" alt="$vbphrase[terrible]" /><label for="vote1"><input type="radio" name="vote" id="vote1" value="1" $votechecked[1] />$vbphrase[terrible]</label></div>
		</td>
	</tr>
	<tr>
		<td class="vbmenu_option" title="nohilite" align="center">
	<input type="hidden" name="s" value="$session[dbsessionhash]" />
	<input type="hidden" name="gameid" value="$gameid" />
	<input type="submit" class="button" value="$vbphrase[vote_now]" />
		</td>
	</tr>
	</table>
</form>
</div>

Save arcade_play

5. At last find the right place to show the game rating

I placed in arcade_main_games_bit temlate :
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

Code:

<if condition="$game['rating'] > 0"><img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$game[rating].gif" alt="<phrase 1="$game[votenum]" 2="$game[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" border="0" />
</if>

#############################
Thats all!

I hope it works :classic:

Download

This modification is archived and cannot be downloaded.

Screenshots

vBulletin LTS