connect(); //Retrieve the baskets list order by name $db->query("SELECT * FROM baskets ORDER BY BASKET_NAME"); while( $res = $db->fetch_assoc() ) { $baskets[$res['BASKET_ID']] = $res; } //Retrieve the others notifs type from the {path_to_letterbox/xml/notif.xml} $others_notifs = new DomDocument(); $others_notifs->load("xml/notif.xml"); $xp_others_notifs = new domxpath($others_notifs); foreach($xp_others_notifs->query("/ROOT/NOTIFICATION") as $nt) { $ID = $nt->getElementsByTagName("ID")->item(0)->nodeValue; foreach( $xp_others_notifs->query("*",$nt) as $nt_field ) { if( is_numeric($ID) ) $notif_types[$ID][$nt_field->nodeName] = $nt_field->nodeValue; } } //Retrieve the informations from the selected notification if( isset($_GET['id']) ) { $select = array(); if( is_numeric($_GET['id']) ) { $select['LABEL'] = $notif_types[$_GET['id']]['LABEL']; } else { $db->query("SELECT BASKET_NAME FROM baskets WHERE BASKET_ID = '".$_GET['id']."'"); $select['LABEL'] = $db->fetch_object()->BASKET_NAME; } $db->query("SELECT * FROM mailer_rights WHERE BASKET_OR_OTHER = '".$_GET['id']."'"); $select['MGE'] = $db->fetch_assoc(); $db->query("SELECT * FROM mge_user_or_group WHERE BASKET_OR_OTHER = '".$_GET['id']."'"); while( $res = $db->fetch_assoc() ) $select['USER_OR_GROUP'][] = $res; } ?>

'; ?>