The Arcive of vBulletin Modifications Site. |
|
![]() |
|||||||||||||||||||||||||
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 ; -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ 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(); Code:
$phrasegroups = array('arcade','showthread'); 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; } // 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> 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: Show Your Support
|
Comments |
#2
|
||||
|
||||
![]()
Awesome! I'll certainly have a look at this one later tonight..
Thanks for sharing your work. ![]() |
#3
|
|||
|
|||
![]() Quote:
![]() game size, champion, record, played games, personal record... |
#4
|
|||
|
|||
![]()
cool, when you say game rating, does this include your arcade home layout, too? That looks very organized!
let us know ![]() |
#5
|
|||
|
|||
![]()
Rick Sample.
No. The rest was made before. And it's mush more hard for me to make clear instructions than to make the code ![]() Generally it's templates modification. Because my board in russian it needs to translate back :ermm: |
#6
|
||||
|
||||
![]()
thanks for sharing looks like a very nice addon.
|
#7
|
|||
|
|||
![]()
you beat frankenberrie at that one!
|
#8
|
|||
|
|||
![]()
Where are the phrases?
|
#9
|
|||
|
|||
![]()
you've got one extra space in your alter table games query for votetotal and votenum on this page that gives a database column not found error. Removing the space fixes that.
|
#10
|
||||
|
||||
![]()
where are the spaces to be removed?
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|