Delete users by User Profile Field?...
 

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

<?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);
?>

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

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

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

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.