DATE_SUB(NOW(),INTERVAL 3 DAY) ORDER BY time DESC LIMIT 0,5"); while ($t = spip_fetch_array($s)) { print jour($t[time]).'/'.mois($t[time]).' '.heures($t[time]).'h'.minutes($t[time]); echo ' '.$t[tag].' ('.$t[user].')
'; } } function w_purger($wiki) { w_archiver($wiki); $tbl = "wiki_".$wiki."_pages"; spip_query("DELETE FROM $tbl WHERE latest='N'"); return "PURGE"; } function w_archiver($wiki) { $date=date("Y-m-d-h-i-s"); $fp = fopen("ecrire/data/wiki_".$wiki."_dump_$date.txt", "w"); include ('mysql_dump_lib.phps'); foreach (array('acls','links','pages','referrers','users') as $table) { $tbl = "wiki_".$wiki."_".$table; dump_table($tbl, $fp); } fclose ($fp); copy ('ecrire/wakka_'.$wiki.'_config.php', 'ecrire/data/wakka_'.$wiki.'_config.txt'); return "ARCHIVE"; } function w_supprimer($wiki) { w_archiver($wiki); foreach (array('acls','links','pages','referrers','users') as $table) { $tbl = "wiki_".$wiki."_".$table; if (!spip_query("DROP TABLE $tbl")) return "Pas pu dropper la table $tbl : ".mysql_error(); } unlink ('ecrire/wakka_'.$wiki.'_config.php'); return "SUPPRIME"; } /////////////////////////////////////////////////////////////// if ($auteur_session['statut'] != '0minirezo') die ('Page réservée aux admins.'); echo "

admin des wikis

\n"; $s = spip_query("SHOW TABLES"); while ($t = spip_fetch_array($s)) { if (ereg("^wiki_(.*)_pages$", $t[0], $regs)) { $wiki_base[] = $regs[1]; } } // ici on pourrait aussi regarder les fichiers wakka_....config.php foreach ($wiki_base as $wiki) { if ($coul<>'#cccccc') $coul='#cccccc'; else $coul='#eeeeee'; echo "\n"; } ?>

"; echo "$wiki"; echo "

"; echo "++ "; echo "

"; echo recents($wiki); echo "

"; if ($action == 'arch' AND $w==$wiki) { echo w_archiver($wiki); } else echo "archiver"; echo "

"; if ($action == 'purger' AND $w==$wiki) { echo w_purger($wiki); } else echo "purger"; echo "

"; if ($action == 'supp' AND $w==$wiki) { echo w_supprimer($wiki); } else echo "supprimer"; echo "