[mirrors/Kyberia-bloodline.git] / admin / sessioncleaner.php

<?
include_once("../inc/kyberia.inc");
$database=new CLASS_KYBERIA();
$q="select id_user from sessions where last<date_sub(NOW(),INTERVAL 1 HOUR)";
echo $q;
$set=$database->query($q);
while($set->next()) {
	$q="update user set user_action='',user_mode='off',user_action_param_name='',user_action_param_id='',user_action_param_value='' where id='".$set->getString('id_user')."'";
	echo $q;
	$database->query($q);
	$database->query("delete from sessions where id_user='".$set->getString('id_user')."'");
}
?>
Commit	Line	Data
bc13d5d6 H	1	<?
	2	include_once("../inc/kyberia.inc");
	3	$database=new CLASS_KYBERIA();
	4	$q="select id_user from sessions where last<date_sub(NOW(),INTERVAL 1 HOUR)";
	5	echo $q;
	6	$set=$database->query($q);
	7	while($set->next()) {
	8	$q="update user set user_action='',user_mode='off',user_action_param_name='',user_action_param_id='',user_action_param_value='' where id='".$set->getString('id_user')."'";
	9	echo $q;
	10	$database->query($q);
	11	$database->query("delete from sessions where id_user='".$set->getString('id_user')."'");
	12	}
	13	?>