Delete users by User Profile Field?...

[cjwinternet]

Hi

I'm doing a clean up of old accounts, and I noticed that quite a few of the banned members (spammers) had a User Profile Field (specifically extra_03) that was always filled in as '123456'.

Doing a search reveals 600 other spammers in there.

The question is, how can I mass delete these? There only seems to be a way to individually delete them, can it be done in bulk using a query?

Regards

Chris

[Scotteh]

<?php
$db = mysql_connect("localhost","USER","PASS");
if (!$db)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("FORUMSDATABASE", $db);

mysql_query("DELETE FROM user WHERE FIELDNAMEGOESHEREI.EEXTRA_03='123456'");

mysql_close($con);
?>

[cjwinternet]

Thanks, but it didn't work at all.

<?php
$db = mysql_connect("localhost","xxxxxx","xxxxxx");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("xxxxxx", $db);

mysql_query("DELETE FROM user WHERE extra_3='123456'");

mysql_close($con);
?>

I tried that, with the connection details in config.php, I also tried adding the table prefix 'vb_'

I just get the 'Could not connect' message.

Also I stripped this bit out...

DELETE FROM user WHERE extra_3='123456'

and tried to run it from with vbulletin ACP

It required the prefix...

DELETE FROM vb_user WHERE extra_3='123456'

but whatever I did to 'extra_3' I get this message...

error desc: Unknown column 'vb_extra_3' in 'where clause'

or

error desc: Unknown column 'extra_3' in 'where clause'

Any suggestions ?

Regards

Chris

[Scotteh]

on the mysql database for "user" what columns is there is the "extra_3" column definately there?

[cjwinternet]

I don't know what it's name is. That's the name of the text area in the user profile field.

[Scotteh]

Check your database as it will be in there but you need the name of the one thats used in the database otherwise it won't find it.