* @author Claire Figueras */ include("session.php"); require_once("class_functions.php"); require_once("class_db.php"); if ($_POST['value'] == "submit") { $db = new dbquery(); $db->connect(); $db2 = new dbquery(); $db2->connect(); $this_user = $_SESSION['user']['UserId']; /* if ($_GET['user_missing'] <> '') { $this_user = $_GET['user_missing']; }*/ // First we delete all virtual basket where the user was the basket owner $db->query("delete from ".$_SESSION['tablename']['missing_user']." where is_virtual = 'Y' and basket_owner = '".$this_user."'"); //Then we search all the virtual baskets assigned to the user $db->query("select basket_owner, basket_id from ".$_SESSION['tablename']['missing_user']." where is_virtual='Y' and user_abs = 'demo'" ); // and delete this baskets if they were reassigned to someone else while($res = $db->fetch_object()) { $db2->query("delete from ".$_SESSION['tablename']['missing_user']." where is_virtual ='Y' and basket_id = '".$res->basket_id."' and basket_owner = '".$res->basket_owner."'"); } // then we delete all baskets where the user was the missing user $db->query("DELETE from ".$_SESSION['tablename']['missing_user']." WHERE user_abs='".$this_user."'"); $_SESSION['abs_user_status'] = false; $db->query("update ".$_SESSION['tablename']['users']." set status = 'OK' WHERE user_id='".$this_user."'"); //$db->show(); if($_SESSION['history']['userabs'] == "true") { require_once("class_history.php"); $history = new history(); $history->add($_SESSION['tablename']['users'],$this_user,"RET",$this_user." "._BACK_FROM_VACATION); } //exit(); /* if ($_GET['user_missing'] <>"") { ?>