Просмотр файла wap_counter_strike_online_game/WCS/optim.php

<?

$a = mysql_fetch_assoc(mysql_query("SELECT `go` FROM `optim` WHERE klu4 = '1'"));

if ($a['go']<time()){

$i = time() + 1800;
mysql_query ("Update optim set go='".$i."' WHERE klu4 = '1'");

$i = time() - 1800;
mysql_query("OPTIMIZE TABLE game");
mysql_query("OPTIMIZE TABLE online");
mysql_query("OPTIMIZE TABLE users");
mysql_query("OPTIMIZE TABLE chater");
mysql_query("OPTIMIZE TABLE chater2");
mysql_query("OPTIMIZE TABLE tmchater");
mysql_query("OPTIMIZE TABLE modchater");

$roptim = "creategame";
$time=time()-3600;
$s = mysql_query("SELECT `idg` FROM `creategame` where `timebattle`<'$time' LIMIT 0,200");
while($ss=mysql_fetch_assoc($s)){

$zaeb = mysql_query("SELECT `name` FROM `users` WHERE `cgame` ='$ss[idg]' LIMIT 0,100");

while($sn=mysql_fetch_assoc($zaeb)){
mysql_query ("Update users set `cgame`='0' WHERE `name` = '$sn[name]'");}
mysql_query("delete from $roptim WHERE `idg`='$ss[idg]");}

$roptim = "chater3";
mysql_query("delete from $roptim WHERE timec<'".$i."'");
mysql_query("OPTIMIZE TABLE $roptim");

$roptim = "pm";
mysql_query("delete from $roptim WHERE kad<'".$i."' and status='0'");
mysql_query("OPTIMIZE TABLE $roptim");
/*
$roptim = "log";
mysql_query("delete from $roptim WHERE `ip`='' and `soft`=''");
mysql_query("OPTIMIZE TABLE $roptim");
*/
}
?>