sql_query($sql_information_insert) or die(mysql_error());
//Khoi tao thong tin login
$_SESSION['login'] = $curenttime;
$sql_account = "SELECT `id` FROM `tblaccess` ORDER BY id DESC LIMIT 0,1";
$sql_account = $db->sql_query($sql_account) or die(mysql_error());
while($sql_account_rows = $db->sql_fetchrow($sql_account))
{
$_SESSION['acc'] = $sql_account_rows['id'];
}
}
$clear_id = "";
//Kiem tra neu session['acc'] qua 5 ngay ma khong online thi se bi xoa tai khoan
$sql_check = "Select id,(NOW()-date) as KKK from `tblaccess`";
$sql_check = $db->sql_query($sql_check) or die(mysql_error());
while($sql_check_rows = $db->sql_fetchrow($sql_check))
{
$time_in_use = ($sql_check_rows['KKK']/3600);
$time_in_use = (int)$time_in_use;
if($time_in_use>=240 && $sql_check_rows['id']<>$_SESSION['acc'])
{
$clear_id .= $sql_check_rows['id'].",";
}
}
//Xoa tat ca cac truy cap khong mua hang
if($clear_id<>"")
{
$clear_id = "(".$clear_id."0)";
//Xoa cac san pham da them vao
$sql_delete = "delete from `tbladds` WHERE user in".$clear_id;
$db->sql_query($sql_delete) or die(mysql_error());
//Xoa cac quyen truy câp do
$sql_delete = "DELETE FROM `tblaccess` WHERE `id` in".$clear_id;
$db->sql_query($sql_delete) or die(mysql_error());
}
?>
