$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=\"");