Changeset 1086 for trunk/common

Timestamp:

12/22/09 14:21:51 (2 years ago)

Author:

Prostu

Message:

Show and delete all the pages that have a round name in their text.

Reviewed: ​http://reviewboard.infoarena.ro/r/115/

File:

• trunk/common/db/textblock.php (modified) (3 diffs)

trunk/common/db/textblock.php

@@ -243 +243 @@
 
 // Grep through textblocks. This is mostly a hack needed for macro_grep.php
-function textblock_grep($substr, $page, $regexp = false) {
+// Also used for round deletion
+function textblock_grep($substr, $page, $regexp = false, $offset = 0, $count = 0) {
     if (!$regexp) {
         $compare = "LIKE";
@@ -255 +256 @@
                       WHERE `name` LIKE '%s' AND
                             (`text` $compare '%s' OR `title` $compare '%s')
-                      ORDER BY `name`",
+                      ORDER BY `name`
+                      LIMIT %s, %s",
+                      db_escape($page), db_escape($substr), db_escape($substr),
+                      db_escape($offset), db_escape($count));
+    return db_fetch_all($query);
+}
+
+function textblock_grep_count($substr, $page, $regexp = false) {
+    if (!$regexp) {
+        $compare = "LIKE";
+    } else {
+        $compare = "REGEXP";
+    }
+    $query = sprintf("SELECT COUNT(*) as `cnt`
+                      FROM ia_textblock
+                      WHERE `name` LIKE '%s' AND
+                            (`text` $compare '%s' OR `title` $compare '%s')",
                       db_escape($page), db_escape($substr), db_escape($substr));
-    return db_fetch_all($query);
+    return db_fetch($query);
 }
 
@@ -278 +295 @@
     db_query("DELETE FROM `ia_textblock_revision` WHERE `name` = '$pageesc'");
     db_query("DELETE FROM `ia_textblock` WHERE `name` = '$pageesc'");
-    if (db_affected_rows() != 1) {
-        return true;
-    }
+
+    return (db_affected_rows() != 0);
 }