Changeset 1518 in ExiteCMS for trunk/includes/theme_functions.php

Timestamp:

07/02/08 22:32:48 (4 years ago)

Author:

hverton

Message:

made the houskeeping queries low-priority
fixed transparancy in some admin index images
removed more unused images from the template
fixed transparancy in the external_link image
update the report template to allow a report process to return an error message

File:

• trunk/includes/theme_functions.php (modified) (2 diffs)

trunk/includes/theme_functions.php

@@ -463 +463 @@
         $minute = 60; $hour = $minute * 60; $day = $hour * 24;
         // flood control: set to 5 minutes
-        $result = dbquery("DELETE FROM ".$db_prefix."flood_control WHERE flood_timestamp < '".(time() - $minute * 5)."'");
+        $result = dbquery("DELETE LOW_PRIORITY FROM ".$db_prefix."flood_control WHERE flood_timestamp < '".(time() - $minute * 5)."'");
         // thread notifies: set to 14 days
-        $result = dbquery("DELETE FROM ".$db_prefix."thread_notify WHERE notify_datestamp < '".(time() - $day * 14)."'");
+        $result = dbquery("DELETE LOW_PRIORITY FROM ".$db_prefix."thread_notify WHERE notify_datestamp < '".(time() - $day * 14)."'");
         // new registered users: set to 3 days
-        $result = dbquery("DELETE FROM ".$db_prefix."new_users WHERE user_datestamp < '".(time() - $day * 3)."'");
+        $result = dbquery("DELETE LOW_PRIORITY FROM ".$db_prefix."new_users WHERE user_datestamp < '".(time() - $day * 3)."'");
         // deactivate accounts with a bad email address after 90 days (available since v7.0 rev.1060)
         if ($settings['revision'] >= 1060) {
@@ -474 +474 @@
         // read threads indicators: use the defined threshold (available since v7.0 rev.1193)
         if ($settings['revision'] >= 1193) {
-            $result = dbquery("DELETE FROM ".$db_prefix."threads_read WHERE thread_last_read < '".$settings['unread_threshold']."'", false);
+            $result = dbquery("DELETE LOW_PRIORITY FROM ".$db_prefix."threads_read WHERE thread_last_read < '".$settings['unread_threshold']."'", false);
         }
     }