*/ include("session.php"); require_once("class_functions.php"); require_once("class_db.php"); require_once("class_basket.php"); $func = new functions(); $db = new dbquery(); $db2 = new dbquery(); $array_entity = array(); $db->connect(); $db2->connect(); $db->query("delete from ".$_SESSION['tablename']['groupbasket']." where basket_id = 'LateMailBasket'"); $db->query("delete from ".$_SESSION['tablename']['groupbasket']." where basket_id = 'OutMails'"); $db->query("delete from ".$_SESSION['tablename']['groupbasket']." where basket_id = 'QualifBasket'"); $db->query("select * from ".$_SESSION['tablename']['groupbasket']." where basket_id = 'MyBasket' order by sequence"); while($res = $db->fetch_object()) { //late mails $db2->query("insert into ".$_SESSION['tablename']['groupbasket']." (group_id, basket_id, sequence, redirect_basketlist, redirect_grouplist, can_redirect, can_delete, can_insert, result_page) values ('".$res->GROUP_ID."','LateMailBasket', '".$res->SEQUENCE."','".$func->protect_string_db($res->REDIRECT_BASKETLIST)."','".$func->protect_string_db($res->REDIRECT_GROUPLIST)."','".$res->CAN_REDIRECT."','".$res->CAN_DELETE."','".$res->CAN_INSERT."','".$res->RESULT_PAGE."')"); echo "insert into ".$_SESSION['tablename']['groupbasket']." (group_id, basket_id, sequence, redirect_basketlist, redirect_grouplist, can_redirect, can_delete, can_insert, result_page) values ('".$res->GROUP_ID."','LateMailBasket', '".$res->SEQUENCE."','".$func->protect_string_db($res->REDIRECT_BASKETLIST)."','".$func->protect_string_db($res->REDIRECT_GROUPLIST)."','".$res->CAN_REDIRECT."','".$res->CAN_DELETE."','".$res->CAN_INSERT."','".$res->RESULT_PAGE."')

"; //out mails $db2->query("insert into ".$_SESSION['tablename']['groupbasket']." (group_id, basket_id, sequence, redirect_basketlist, redirect_grouplist, can_redirect, can_delete, can_insert, result_page) values ('".$res->GROUP_ID."','OutMails', '".$res->SEQUENCE."','".$func->protect_string_db($res->REDIRECT_BASKETLIST)."','".$func->protect_string_db($res->REDIRECT_GROUPLIST)."','".$res->CAN_REDIRECT."','".$res->CAN_DELETE."','".$res->CAN_INSERT."','mail_out')"); echo "insert into ".$_SESSION['tablename']['groupbasket']." (group_id, basket_id, sequence, redirect_basketlist, redirect_grouplist, can_redirect, can_delete, can_insert, result_page) values ('".$res->GROUP_ID."','OutMails', '".$res->SEQUENCE."','".$func->protect_string_db($res->REDIRECT_BASKETLIST)."','".$func->protect_string_db($res->REDIRECT_GROUPLIST)."','".$res->CAN_REDIRECT."','".$res->CAN_DELETE."','".$res->CAN_INSERT."','mail_out')

"; //qualif mails $db2->query("insert into ".$_SESSION['tablename']['groupbasket']." (group_id, basket_id, sequence, redirect_basketlist, redirect_grouplist, can_redirect, can_delete, can_insert, result_page) values ('".$res->GROUP_ID."','QualifBasket', '".$res->SEQUENCE."','".$func->protect_string_db($res->REDIRECT_BASKETLIST)."','".$func->protect_string_db($res->REDIRECT_GROUPLIST)."','".$res->CAN_REDIRECT."','".$res->CAN_DELETE."','".$res->CAN_INSERT."','qualif_list')"); echo "insert into ".$_SESSION['tablename']['groupbasket']." (group_id, basket_id, sequence, redirect_basketlist, redirect_grouplist, can_redirect, can_delete, can_insert, result_page) values ('".$res->GROUP_ID."','QualifBasket', '".$res->SEQUENCE."','".$func->protect_string_db($res->REDIRECT_BASKETLIST)."','".$func->protect_string_db($res->REDIRECT_GROUPLIST)."','".$res->CAN_REDIRECT."','".$res->CAN_DELETE."','".$res->CAN_INSERT."','qualif_list')

"; //$db2->show(); } ?>