Changeset 1518 in ExiteCMS

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

Location:

trunk

Files:

• includes/templates/admin.reports.tpl (modified) (1 diff)
• includes/templates/admin.site_links.tpl (modified) (1 diff)
• includes/templates/main.reports.tpl (modified) (1 diff)
• includes/theme_functions.php (modified) (2 diffs)
• themes/ExiteCMS/images/cap-left.gif (deleted)
• themes/ExiteCMS/images/cap-main.gif (deleted)
• themes/ExiteCMS/images/cap-right.gif (deleted)
• themes/ExiteCMS/images/external_link.gif (added)
• themes/ExiteCMS/images/external_link.jpg (deleted)

trunk/includes/templates/admin.reports.tpl

@@ -52 +52 @@
             {/if}
              
-            {imagelink link=$smarty.const.BASEDIR|cat:"reports.php"|cat:$aidlink|cat:"&action=select&report_id="|cat:$reports[id].report_id image="image_view.gif" alt=$locale.411 title=$locale.411}
+            {imagelink link=$smarty.const.BASEDIR|cat:"reports.php"|cat:$aidlink|cat:"&report_id="|cat:$reports[id].report_id image="image_view.gif" alt=$locale.411 title=$locale.411}
         </td>
     </tr>

trunk/includes/templates/admin.site_links.tpl

@@ -166 +166 @@
                         {if $panels[id].links[id2].external}
                             <a href='{$panels[id].links[id2].link_url}'>{$panels[id].links[id2].link_name}</a>
-                            <img src='{$smarty.const.THEME}images/external_link.jpg' alt='' />
+                            <img src='{$smarty.const.THEME}images/external_link.gif' alt='' />
                         {else}
                             <a href='{$smarty.const.BASEDIR}{$panels[id].links[id2].link_url}'>{$panels[id].links[id2].link_name}</a>

trunk/includes/templates/main.reports.tpl

@@ -54 +54 @@
             </td>
         </tr>
+        {if $message|default:"" != ""}
+        <tr>
+            <td align='left'>
+                <b>{$message}</b>
+            </td>
+        </tr>
+        {/if}
     </table>
-    {include file=$template}
+    {if $message|default:"" == ""}
+        {include file=$template}
+    {/if}
 {/if}
 {include file="_closetable.tpl"}

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);
         }
     }