$table_nom = '';
if (!empty($value['table_nom'])) {
$table_nom = $value['table_nom'];
}
$requete_type = '';
if (!empty($value['type'])) {
$requete_type = $value['type'];
}
if ($requete_type == 'insert') {
mysql_query($value['query'], $wiki->dblink);
}
}
break;
case 'synchronisation':
// Recherche derniere date mise à jour
$last = $wiki->LoadSingle("select max(update_date) as update_date from locations");
$sql_contenu = PMA_readFile("http://www.onem-france.org/saga/synchro.php?date=" . urlencode($last['update_date']), '', 1);
$tab_requete_sql = array();
PMA_splitSqlFile($tab_requete_sql, $sql_contenu, '');
foreach ($tab_requete_sql as $value) {
$table_nom = '';
if (!empty($value['table_nom'])) {
$table_nom = $value['table_nom'];
}
$requete_type = '';
if (!empty($value['type'])) {
$requete_type = $value['type'];
}
if ($requete_type == 'insert') {
mysql_query($value['query'], $wiki->dblink);
}
foreach ($_POST['suppr'] as $page) {
// Effacement de la page en utilisant la méthode adéquate
// (si DeleteOrphanedPage ne convient pas, soit on créé
// une autre, soit on la modifie
$wiki->DeleteOrphanedPage($page);
$deletedPages .= $page . ", ";
}
$deletedPages = trim($deletedPages, ", ");
}
// -- 3.2 Restauration des pages sélectionnées ---
if (!empty($_POST['rev'])) {
//print_r($_POST["rev"]);
foreach ($_POST["rev"] as $rev_id) {
buffer::str($rev_id . "<br>");
// Sélectionne la révision
$revision = $wiki->LoadSingle("select * from " . $wiki->config["table_prefix"] . "pages where id = '" . mysql_escape_string($rev_id) . "' limit 1");
// Fait de la dernière version de cette révision
// une version archivée
$requeteUpdate = "update " . $wiki->config["table_prefix"] . "pages " . "set latest = 'N' " . "where latest = 'Y' " . "and tag = '" . $revision["tag"] . "' " . "limit 1";
$wiki->Query($requeteUpdate);
$restoredPages .= $revision["tag"] . ", ";
// add new revision
$wiki->Query("insert into " . $wiki->config["table_prefix"] . "pages set " . "tag = '" . mysql_escape_string($revision['tag']) . "', " . "time = now(), " . "owner = '" . mysql_escape_string($revision['owner']) . "', " . "user = '******', " . "latest = 'Y', " . "body = '" . mysql_escape_string(chop($revision['body'])) . "'");
}
}
$restoredPages = trim($restoredPages, ", ");
buffer::str("<li>Pages restaurées : " . $restoredPages . ".</li>\n");
buffer::str("<li>Pages supprimées : " . $deletedPages . ".</li>\n");
buffer::str("</ul>\n");
buffer::str("<p><a href=\"" . $despam_url . "\">Retour au formulaire de départ >></a></p>\n");
buffer::str("<p><a href=\"");
