V3Arcade - Game Rating addon

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 :

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:

$phrasegroups = array();

Change to:

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

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


Find:

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

Add right after:

      // 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:

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

Add right after:

// 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:

<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:

<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:

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

Add right after:

<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 :
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

<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:

[Lionel]

ALTER TABLE `games` ADD `votetotal ` smallint(5) UNSIGNED DEFAULT '0' NOT NULL ;

ALTER TABLE `games` ADD `votenum `

votetotal ' should be votetotal'

same for votenum

[GenSec]

Originally Posted by Lionel

Where are the phrases?

Thanks for "spaces"

The phrases are using by standart redirects in gamerate.php ( it's based on threadrate.php )
like

  
		eval(print_standard_redirect('redirect_threadrate_add'))

It uses
$vbphrase[threadrate_add] ="Your vote on this thread has been added."

You can change it to something like

eval(print_standard_redirect('redirect_game_add'))


and add the new phrase

$vbphrase[game_add] ="Your vote on this game has been added."

BUT you also can edit the original phrase to

$vbphrase[threadrate_add] ="Your vote has been added."

Up to you.

I desabled redirects at all.

[Lionel]

I removed the arcade phrases and used the showthread. Arcade was giving a myaql error since they were non existant.

[HarryBO]

Hi!

Thats a very nice Hack, but it seems I have a problem!

See my Screenshot!

How can I format the stars correctly?

[Lionel]

align="left"

[dina]

Great mod, however I had a problem with the phrases.

It gave this error;
mysql error: Unknown column 'language.phrasegroup_arcade' in 'field list'

So I changed the arcade.php to this $phrasegroups = array('showthread');
Removed the arcade bit

[HarryBO]

Where must I put this Code?

[Lionel]

Originally Posted by HarryBO

Where must I put this Code?

In the <td where you have the stars :squareeyed:

[HarryBO]

Sorry can you post the complete piece of Code? I´am an absolutely php-Noob!

[Lionel]

This is basic html in your template