*/
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();
}
?>