[Soto]

Hey, just wanted to let you know that I've installed this hack on my boards at www.swanseasucks.com/vforum/arcade.php and it's really great.

I did have some trouble installing it because I am a complete novice at this sort of thing, but from a few of the posts I've read here other people had the same problem I did with sql errors after editing arcade.php - this was for two reasons.

1 - as already pointed out, removing 'arcade' from the line

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

when changing arcade.php

2 - the code for creating a table assumes that there is no prefix on the database and so creates a table called 'game_rate' - however, if your vbulletin database is prefixed then you need to change the following code to reflect that:

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 ;

example: should your database be prefixed vbx_ then the first line of that code should read

CREATE TABLE `vbx_game_rate` (

Obviously you need to replace 'vbx_' with whatever your database prefix is (you can find that through phpmyadmin or whatever.

I hope that helps someone as I nearly had a heart attack when it all went pear shaped

*_*_*_*_*_*_*_*_*_*_*_*_*_*_*

Now, can some one explain to me what files to change so that it says "rate game" rather than "rate thread"?

Thanks all, and thanks for a great hack.