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
|