RootForum Community

Code: Select all

<? 
$a = 0;
$db = mysql_connect("localhost","user","pass");

$query = mysql_query("SELECT * FROM confixx.kunden WHERE gesperrt='1' AND anbieter='res1' ORDER BY kunde");

while($result = mysql_fetch_array($query)) { 

mysql_query("DELETE FROM kunden WHERE kunde='$result[kunde]'"); 
mysql_query("UPDATE cronjobs SET cronfile='', neu=1 WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM domains WHERE kunde='$result[kunde]'"); 
mysql_query("UPDATE cssl SET loeschen = 1 WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM autoresponder WHERE kunde='$result[kunde]'"); 
mysql_query("UPDATE allgemein SET deluser=1, domains=1, delpop=1, delftp=1, httpd=1, aliases=1, dns=1, frontpage='1', cssl='1', frontpagedel='1'"); 
mysql_query("UPDATE ipadressen SET kunde='' WHERE kunde='$result[kunde]' AND anbieter='res1'"); 
mysql_query("UPDATE transfer SET geloescht='1' WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM pwschutz WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM users WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM htaccess WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM fehlermeldungen WHERE kunde='$result[kunde]'"); 
mysql_query("UPDATE ereignisse SET geloescht='1' WHERE kunde='$result[kunde]'"); 
mysql_query("UPDATE frontpage SET loeschen='1', neu='0' WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM perl WHERE kunde='$result[kunde]'"); 
mysql_query("DELETE FROM webalizer WHERE kunde='$result[kunde]'");

$a = $a + 1;
echo "$a || <b>".$result['kunde']."</b> | ".$result['firstname']." | ".$result['name']." | ".$result['anschrift']." | ".$result['plz']." | ".$result['plzort']." | ".$result['land']." | ".$result['emailadresse']."<br>";
 
} 

mysql_close($db); 
?>