Delete users by User Profile Field?...

[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