Файл: ewar/users_clear.php
Строк: 103
<?php
include("includes/config.php");
include("includes/header.php");
deletecache('arena_and_duel_opponents');
deletecache('sum_rating');
deletecache('duel_rating');
$query = mysql_query("SELECT * FROM `vartotojai`");
$galioja = strtotime(date("Y-m-d H:i:s")) - 60 * 60 * 24 * 30;
$sk = 1;
while($row = mysql_fetch_array($query)) {
deletecache('arena_opponents'.$row['id']);
deletecache('duel_opponents'.$row['id']);
if((strtotime($row['paskutinis_prisijungimas']) < $galioja && $row['level'] < 10) or substr($row['nick'], 0, 4) == "Боец") {
echo "$sk. ".$row['nick']." (Level: ".$row['level'].", ".$row['paskutinis_prisijungimas'].")
<br/>";
deletecache('coliseum.data.uid'.$row['id']);
deletecache('dung.fight.hash'.$row['id']);
for($i = 1; $i <= 6; $i ++) {
$league_cache = readcache($i.'_league_cache');
if($league_cache != false) {
if (array_key_exists($row['id'], $league_cache)) {
unset($league_cache[$row['id']]);
writecache($i.'_league_cache', $league_cache);
}
}
}
mysql_query("DELETE FROM `2pay_data` WHERE `v1` = '".$row['id']."'");
mysql_query("DELETE FROM `arena` WHERE `user` = '".$row['id']."' OR `opponent` = '".$row['id']."' OR `opponent2` = '".$row['id']."'");
mysql_query("DELETE FROM `atsiliepimai` WHERE `kieno` = '".$row['id']."' OR `kas` = '".$row['id']."'");
mysql_query("DELETE FROM `auksiniu_log` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `blacklist` WHERE `user_id` = '".$row['id']."' OR `blacklist_user_id` = '".$row['id']."'");
mysql_query("DELETE FROM `block` WHERE `nick_id` = '".$row['id']."' OR `kas` = '".$row['id']."'");
mysql_query("DELETE FROM `cave` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `chat` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `chat_online` WHERE `nick_id` = '".$row['id']."'");
$query2 = mysql_query("SELECT * FROM `clan_memb` WHERE `user` = '".$row['id']."' AND `rank` = '4'");
while($row2 = mysql_fetch_assoc($query2)) {
mysql_query("DELETE FROM `clans` WHERE `id` = '".$row2['clan']."'");
mysql_query("DELETE FROM `clan_chat` WHERE `clan` = '".$row2['clan']."'");
mysql_query("DELETE FROM `clan_chat_online` WHERE `clan` = '".$row2['clan']."'");
mysql_query("DELETE FROM `clan_invite` WHERE `clan` = '".$row2['clan']."'");
mysql_query("DELETE FROM `clan_journal` WHERE `clan` = '".$row2['clan']."'");
mysql_query("DELETE FROM `clan_memb` WHERE `clan` = '".$row2['clan']."'");
mysql_query("DELETE FROM `clan_msg` WHERE `clan` = '".$row2['clan']."'");
}
mysql_query("DELETE FROM `clan_chat` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `clan_chat_online` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `clan_invite` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `clan_memb` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `clan_msg` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `clan_msg_read` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `clan_search` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `coliseum` WHERE `uid` = '".$row['id']."'");
mysql_query("DELETE FROM `duel` WHERE `user` = '".$row['id']."' OR `opponent` = '".$row['id']."'");
mysql_query("DELETE FROM `exchange` WHERE `user_id` = '".$row['id']."'");
mysql_query("DELETE FROM `farm` WHERE `user` = '".$row['id']."'");
$query3 = mysql_query("SELECT * FROM `forumas` WHERE `kas` = '".$row['id']."'");
while($row3 = mysql_fetch_array($query3)) {
mysql_query("DELETE FROM `forumas` WHERE `id` = '".$row3['id']."'");
mysql_query("DELETE FROM `forumo_zinutes` WHERE `temos_id` = '".$row3['id']."'");
}
mysql_query("DELETE FROM `forumo_online` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `forumo_zinutes` WHERE `kas` = '".$row['id']."'");
mysql_query("DELETE FROM `inbox` WHERE `kieno` = '".$row['id']."' OR `nuo_ko_ar_kam` = '".$row['id']."'");
mysql_query("DELETE FROM `inv` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `loterija` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `loterijos_laimetojas` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `news_vertinimai` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `online` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `pets` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `premijos` WHERE `kieno` = '".$row['id']."' OR `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `priminimai` WHERE `nick_id` = '".$row['id']."'");
mysql_query("DELETE FROM `sack` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `strides` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `support` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `support_comment` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `user_q` WHERE `user` = '".$row['id']."'");
mysql_query("DELETE FROM `vartotojai` WHERE `id` = '".$row['id']."'");
$sk ++;
}
}
include("includes/foot.php");
?>