include("login_check.php");
include("include/header.php");
//connexion a la base de donnees
include("banner.php");
include("parametre.php");
include("library/fonctions_php.php");
if( isset( $_GET['id_label'] ) ) $id_label = ( $_GET['id_label'] );//id du label du noeud
if( isset( $_GET['id_label1'] ) ) $id_label1 = ( $_GET['id_label1'] );//id du label du noeud
if( isset( $_GET['id_label2'] ) ) $id_label2 = ( $_GET['id_label2'] );//id du label du noeud
if( isset( $_GET['type'] ) ) $type = ( $_GET['type'] );//type de labellisation generique/specifique
if( isset( $_GET['periode'] ) ) $my_period =derange_periode($_GET['periode']);// periode
else $my_period = '-1';
connexion_base($server,$user,$password,$database);
//bloc recuperation infos du noeud de la carte:
//un noeud= un ensemble de clusters qui partagent le même label.
$resultat=mysql_query("select id,forme_principale FROM concepts ORDER by forme_principale") or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) $liste_termes[$ligne['id']] = $ligne['forme_principale'];
create_concept_string();
if ($type=="s")
{
$sql ="select id_cluster FROM cluster WHERE periode = \"".$my_period."\" and label_2 = \"".$id_label."\" GROUP by id_cluster";//on s'attache à extraire l'ensemble des clusters associés au label specifique donné
}
elseif ($type=="g")
{
function remove_sondage($connect, $numsondage)
{
$connect->StartTrans();
$req = 'DELETE FROM sondage WHERE id_sondage = ' . $connect->Param('numsondage');
$sql = $connect->Prepare($req);
$connect->Execute($sql, array($numsondage));
$req = 'DELETE FROM sujet_studs WHERE id_sondage = ' . $connect->Param('numsondage');
$sql = $connect->Prepare($req);
$connect->Execute($sql, array($numsondage));
$req = 'DELETE FROM user_studs WHERE id_sondage = ' . $connect->Param('numsondage');
$sql = $connect->Prepare($req);
$connect->Execute($sql, array($numsondage));
$req = 'DELETE FROM comments WHERE id_sondage = ' . $connect->Param('numsondage');
$sql = $connect->Prepare($req);
$connect->Execute($sql, array($numsondage));
$suppression_OK = !$connect->HasFailedTrans();
$connect->CompleteTrans();
return $suppression_OK;
}
$connect = connexion_base();
define('COMMENT_EMPTY', 0x1);
define('COMMENT_USER_EMPTY', 0x10);
define('COMMENT_INSERT_FAILED', 0x100);
define('NAME_EMPTY', 0x1000);
define('NAME_TAKEN', 0x10000);
define('NO_POLL', 0x100000);
define('NO_POLL_ID', 0x1000000);
define('INVALID_EMAIL', 0x10000000);
define('TITLE_EMPTY', 0x100000000);
define('INVALID_DATE', 0x1000000000);
$err = 0;
