Parašė Žmogus· 2010 Kov. 29 14:03:42
#8
Oj mano klaida :D
<?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()."");
}
?>