Hi! I just had a guy sign up and play without posting. I emailed him to ask how but so far nothing. Has anyone else had this problem?

i get Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT arcademinposts AS number FROM vb_33usergroup
WHERE usergroupid=6

mysql error: Unknown column 'arcademinposts' in 'field list'

mysql error number: 1054

Date: Tuesday 03rd of August 2004 11:31:50 AM
Script: http://teenagechaos.com/arcade.php?do=play&gameid=17
Referer: http://teenagechaos.com/arcade.php?
Username: Adam
IP Address: #######

pm with help.

You didn't run the query toa dd the field "arcademinposts." Read the instructions carefulyl and see if you missed any steps.

And Diva, I've never heard of that happening.. If you find out what happened, let me know and I will post a bug fix. I think it could be your installation though. Make sure you go through every step. Also make sure that you specified the minimum posts for your default usergroup that new users are put into..

installed and so far looks like its working fine :) Nice one ima click install :p

At first I thought I messed up something. Then after examining the code I realize what it was.

My original mod stops people from accessing the games.
This one stops from playing the games. So they still have access to view games and scores but can't play them.

Works with my heavily modded vb3. Thx

INSTALLS!!!

I am looking at adding this usefull hack to my forum but just need to check something.

running these queries as they are give me an error because I have a prefix on my forum of vb3_. I can edit the queries with no problem, but how much on the edited code do I also need to edit to get this to work, I can see a few references to 'usergroup[arcademinposts]' which I assume need editing, but what about the references to $usergroup['arcademinposts'] ??
regards
keith
REF: queries that fail
ALTER TABLE `usergroup` ADD `arcademinposts` INT( 11 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `usergroup` ADD `arcademintime` INT( 11 ) DEFAULT '0' NOT NULL ;

I believe that if people have made two spam posts, and then got those posts deleted by staff, they can still play in the arcade.

Is there any way to check to see if the user has made two still-existent posts before letting him play?

vB3.03 Here.

Installed perfectly.

Works even better.

Thank you! It is what I've been looking for.

And yes, I whole heartedly clicked INSTALL!

Can you tell I am happy now?

:banana:

Clicked install, great hack. only one small problem.

http://upload.nemesisforums.net/user...teqz/code1.png


I'm sure it's not ok to remove it, so why is it showing up?