Parašė Žmogus· 2010 Kov. 29 14:03:02
#6
<?php
if (!defined("IN_FUSION")) { die("Access Denied"); }
//define("DB_BANAI", DB_PREFIX."banai");
$result = dbquery("SELECT * FROM ".DB_PREFIX."banai" tn LEFT JOIN ".DB_PREFIX."banai" tu ON tn.user_id=tu.ban_id
WHERE ban_time < ".time()."");
while($data = dbarray($result)){
$query=dbquery("UPDATE ".DB_USERS." SET user_status='0' WHERE user_id='".$data['user_id']."'");
$query=dbquery("DELETE FROM ".DB_PREFIX."banai" WHERE ban_time < ".time()."");
}
?>
Gal veiks