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];
}
if (!$is_external)
print "
".$msg["procs_execute"]." $name
$commentaire
";
else
print "
".$msg["remote_procedures_executing"]." $name
$commentaire
";
$linetemp = explode(";", $code);
for ($i=0;$i".$msg["procs_ligne"]." $cle : $valeur
";
if (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("| ${fieldname} | ");
}
for($i=0; $i < $nbr_lignes; $i++) {
$row = mysql_fetch_row($res);
echo "";
foreach($row as $dummykey=>$col) {
if(trim($col)=='') $col = ' ';
print '| '.$col.' | ';
}
echo "
";
}
echo "
";
} 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 $valeur."
".$msg["proc_param_explain_failed"]."
".$erreur_explain_rqt;
}
}
} // fin while
if($do_reindexation){
echo "".$msg['admin_proc_reindex']."
";
}
} else {
print $msg["proc_param_query_failed"];
}