How to: Ban Everyone is ICQ UIN

[Disasterpiece]

UPDATE user SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6' AND posts < 1;

too easy, eh? :P

[djjeffa]

Originally Posted by Disasterpiece

UPDATE user SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6' AND posts < 1;

too easy, eh? :P

I tried and got this

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'djjeffa_djjeffavb.user' doesn't exist

[djjeffa]

Originally Posted by djjeffa

I tried and got this

bumP....

[Zachery]

Need to use your table prefix.

UPDATE PREFIXuser SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6' AND posts < 1;

[djjeffa]

Originally Posted by Zachery

Need to use your table prefix.

UPDATE PREFIXuser SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6' AND posts < 1;

wow I missed this lol.
hate to sound stupid but what is the table prefix?

[Zachery]

A prefix added on all of your tables specified in your config.php file that all of your database tables have

[djjeffa]

my prefix is vb but when I put

UPDATE vb/user SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6' AND posts < 1

I get

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/user SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6' AND posts < ' at line 1

im I doing it wrong?

[Zachery]

I very much doubt your table prefix is vb/

[djjeffa]

Originally Posted by Zachery

I very much doubt your table prefix is vb/

this is from my confige file am I doing somthing wrong?

//	****** TABLE PREFIX ******
	//	Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb';

[Zachery]

UPDATE vbuser SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6' AND posts < 1;