Hi Dudi, Le dimanche 25 juillet 2010 à 19:37 +0300, Dudi Goldenberg a écrit :
> Is there a way/script to remove a user (by his UID) including all > DSPAM data associated with this user? I use the following PHP cli script (it takes the user id as argument, which might not be what you want): #!/usr/bin/php <?php $server = "127.0.0.1"; $user = "<dspam_db_user>"; $pwd = "<dspam_db_password>"; $link = mysql_connect($server, $user, $pwd); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("dspam", $link); if (!$db_selected) { die (mysql_error()); } $alltables = mysql_query("SHOW TABLES") or die(mysql_error()); while ($tableName = mysql_fetch_array($alltables)) { echo " - Cleaning " . $tableName[0] . "\n"; mysql_query("DELETE FROM `".$tableName[0]."` WHERE uid>."$_SERVER['argv'][1].") or die(mysql_error()); } mysql_close($link); ?> Cheers, Julien -- Julien Valroff <jul...@kirya.net> http://www.kirya.net GPG key: 4096R/290D20C5 092F 4CB5 5F19 E006 1CFD B489 D32B 8D66 290D 20C5 ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user