Update of /home/spip-cvs/spip/ecrire
In directory miel:/tmp/cvs-serv2659/ecrire
Modified Files:
optimiser.php3
Log Message:
(oups)
Index: optimiser.php3
RCS file: /home/spip-cvs/spip/ecrire/optimiser.php3,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -d -r1.13 -r1.14
--- optimiser.php3 16 Nov 2003 18:47:48 -0000 1.13
+++ optimiser.php3 16 Nov 2003 18:51:58 -0000 1.14
@@ -171,7 +171,22 @@
$result = spip_query($query);
while ($row = spip_fetch_array($result)) $mots[] = $row['id_mot'];
-
+ if ($mots) {
+ $mots = join(",", $mots);
+
+ $query = "DELETE FROM spip_mots_articles WHERE id_mot NOT IN ($mots)";
+ spip_query($query);
+ $query = "DELETE FROM spip_mots_breves WHERE id_mot NOT IN ($mots)";
+ spip_query($query);
+ $query = "DELETE FROM spip_mots_forum WHERE id_mot NOT IN ($mots)";
+ spip_query($query);
+ $query = "DELETE FROM spip_mots_rubriques WHERE id_mot NOT IN ($mots)";
+ spip_query($query);
+ $query = "DELETE FROM spip_mots_syndic WHERE id_mot NOT IN ($mots)";
+ spip_query($query);
+ }
+
+
//
// Documents
//