Changeset 659 for trunk/include/functions.inc.php

Timestamp:

Dec 27, 2004, 3:30:49 PM (19 years ago)

Author:

plg

Message:

• admin/update : filesystem synchronization process completely rewritten. How to speed up sync ? by avoiding recursivity !

• admin/update : option to display verbose information details

• admin/update : option to simulate only. No database insert, delete or update will be made

• bug fixed : in admin/cat_list, if you delete a virtual category, you may create a gap in the rank list. This gap will generate errors when trying to move a category on this gap. Fixed by calling ordering and update_global_rank at category deletion.

• admin/cat_list, only one query to insert a new virtual category (no need of a second query to update uppercats and global_rank)

• for a given category, even if empty, the representing element must not be the one of a forbidden category for the current user

• generation time optionnaly displayed on the bottom of each page becomes more price : number of SQL queries and SQL time added.

File:

• trunk/include/functions.inc.php (modified) (1 diff)

trunk/include/functions.inc.php

@@ -462 +462 @@
 function pwg_query($query)
 {
-  global $conf;
+  global $conf,$count_queries,$queries_time;
   
   $start = get_moment();
   $result = mysql_query($query);
-
+  
+  $time = get_moment() - $start;
+  $count_queries++;
+  $queries_time+= $time;
+  
   if ($conf['show_queries'])
   {
-    global $count_queries,$queries_time;
-   
-    $time = get_moment() - $start;
-    $count_queries++;
-    
     $output = '';
     $output.= '<pre>['.$count_queries.'] '."\n".$query;
-    $queries_time+= $time;
     $output.= "\n".'(this query time : '.number_format( $time, 3, '.', ' ').' s)</b>';
     $output.= "\n".'(total SQL time  : '.number_format( $queries_time, 3, '.', ' ').' s)';
     $output.= '</pre>';
+    
     echo $output;
   }