}
//fin valeur nonvide
}
// fin while list $cle
$nb_element_apres = $myCart->nb_item;
$msg["caddie_affiche_nb_ajouts"] = str_replace('!!nb_a_ajouter!!', $nb_element_a_ajouter, $msg["caddie_affiche_nb_ajouts"]);
$msg["caddie_affiche_nb_ajouts"] = str_replace('!!nb_ajoutes!!', $nb_element_apres - $nb_element_avant, $msg["caddie_affiche_nb_ajouts"]);
$res_exec = "<hr />{$msg['caddie_affiche_nb_ajouts']}<hr />";
print pmb_bidi($res_exec);
}
// fin if $droit
print aff_cart_nb_items($myCart);
break;
default:
print aff_cart_nb_items($myCart);
show_procs($idcaddie);
break;
}
} else {
aff_paniers($idcaddie, "NOTI", "./catalog.php?categ=caddie&sub=collecte&moyen=selection", "", $msg["caddie_select_ajouter"], "", 0, 0, 0);
}
function show_procs($idcaddie)
{
global $msg;
global $PMBuserid;
global $dbh;
print "<hr />{$msg['caddie_select_proc']}<br /><table>";
// affichage du tableau des procédures
if ($PMBuserid != 1) {
$where = " and (autorisations='{$PMBuserid}' or autorisations like '{$PMBuserid} %' or autorisations like '% {$PMBuserid} %' or autorisations like '% {$PMBuserid}') ";
}
case "TABLEAUHTML":
echo "<h1>" . $msg[1130] . " : " . $msg[1131] . "</h1>";
break;
case "TABLEAUCSV":
break;
case "EXPORT_NOTI":
$fichier_temp_nom = str_replace(" ", "", microtime());
$fichier_temp_nom = str_replace("0.", "", $fichier_temp_nom);
$fname = tempnam("./temp", $fichier_temp_nom . ".doc");
break;
default:
echo "<h1>" . $msg[1130] . " : " . $msg[1131] . "</h1>";
break;
}
if (!$id_proc) {
show_procs($dbh);
} else {
@set_time_limit($pmb_set_time_limit);
//Récupération des variables postées, on en aura besoin pour les liens
$page = $_SERVER[SCRIPT_NAME];
$requete = "SELECT idproc, name, requete, comment, proc_notice_tpl, proc_notice_tpl_field FROM procs where idproc='" . $id_proc . "' ";
$res = mysql_query($requete, $dbh) or die("<br/>SQL error : <br/>" . mysql_error() . "<br/>SQL Query : <br/>" . $requete);
$row = mysql_fetch_row($res);
//Requete et calcul du nombre de pages à afficher selon la taille de la base 'pret'
//********************************************************************************/
// récupérer ici la procédure à lancer
$sql = $row[2];
//$proc_notice_tpl=$row[4];
$proc_notice_tpl_field = $row[5];
if (preg_match_all("|!!(.*)!!|U", $sql, $query_parameters) && $form_type == "") {
$hp = new parameters($id_proc, "procs");
}
if (!$the_procedure) {
echo htmlentities($msg["remote_procedures_error_client"], ENT_QUOTES, $charset);
break;
}
if ($the_procedure->type != "PEMPS") {
echo htmlentities($msg["remote_procedures_circ_noPEMPS"], ENT_QUOTES, $charset);
break;
}
$sql = "CREATE TEMPORARY TABLE remote_proc LIKE procs";
mysql_query($sql, $dbh) or die(mysql_error());
$sql = "INSERT INTO remote_proc (idproc, name, requete, comment, autorisations, parameters, num_classement) VALUES (0, '" . mysql_escape_string($the_procedure->name) . "', '" . mysql_escape_string($the_procedure->sql) . "', '" . mysql_escape_string($the_procedure->comment) . "', '', '" . mysql_escape_string($the_procedure->params) . "', 0)";
mysql_query($sql, $dbh) or die(mysql_error());
$idproc = mysql_insert_id($dbh);
$hp = new parameters($idproc, "remote_proc");
if (preg_match_all("|!!(.*)!!|U", $hp->proc->requete, $query_parameters)) {
$hp->get_final_query();
$the_procedure->sql = $hp->final_query;
}
$execute_external = true;
$execute_external_procedure = $the_procedure;
include "./circ/caddie/gestion/execute.inc.php";
break;
default:
if (!$pmb_procedure_server_address) {
echo $msg["remote_procedures_error_noaddress"];
break;
}
show_procs();
break;
}
