name; $code = $execute_external_procedure->sql; $commentaire = $execute_external_procedure->comment; } else { $row = mysql_fetch_row($res); $idp = $row[0]; $name = $row[1]; if (!$code) $code = $row[2]; $commentaire = $row[3]; } print "

"; print $param_proc_hidden; if($force_exec){ print "";//On a forcé la requete } if (!$is_external) { print "

".htmlentities($msg["procs_execute"]." ".$name, ENT_QUOTES, $charset)."

".htmlentities($commentaire, ENT_QUOTES, $charset)."

"; print ""; print "
"; } else { print "

".htmlentities($msg["remote_procedures_executing"]." ".$name, ENT_QUOTES, $charset)."

".htmlentities($commentaire, ENT_QUOTES, $charset)."

"; print ""; print "
"; } $linetemp = explode(";", $code); for ($i=0;$i".$msg["procs_ligne"]." $cle : $valeur

"; if (($pmb_procs_force_execution && $force_exec) || (($PMBuserid == 1) && $force_exec) || explain_requete($valeur)) { $res = @mysql_query($valeur, $dbh); echo mysql_error(); $nbr_lignes = @mysql_num_rows($res); $nbr_champs = @mysql_num_fields($res); if($nbr_lignes) { echo ""; for($i=0; $i < $nbr_champs; $i++) { // ajout de liens pour trier les pages $fieldname = mysql_field_name($res, $i); $sortasc = "asc"; $sortdesc = "desc"; print(""); } for($i=0; $i < $nbr_lignes; $i++) { $row = mysql_fetch_row($res); echo ""; foreach($row as $dummykey=>$col) { if(trim($col)=='') $col = ' '; print ''; } echo ""; } echo "

${fieldname}
'.$col.'

"; } else { $ligne_affected=mysql_affected_rows($dbh); print "
".$msg['admin_misc_lignes']." ".$ligne_affected; $err = mysql_error($dbh); if ($err){ print "
$err"; }else{ if($ligne_affected){ $do_reindexation=true; } } echo "

"; } } else { // erreur explain_requete print "

".htmlentities($msg["proc_param_explain_failed"], ENT_QUOTES, $charset)."

".$erreur_explain_rqt; if ($pmb_procs_force_execution || ($PMBuserid == 1)) { if(!$is_external){ $lien_force="./admin.php?categ=proc&sub=proc&action=final&id=".$id."&force_exec=1"; }else{ $lien_force="./admin.php?categ=proc&sub=proc&action=final_remote&id=".$id."&force_exec=1"; } print " "; } } } } // fin while if($do_reindexation){ echo "

".$msg['admin_proc_reindex']."

"; } print ""; } else { print $msg["proc_param_query_failed"]; }