Changeset 587 for trunk/include/functions_category.inc.php

Timestamp:

Oct 30, 2004, 5:42:29 PM (19 years ago)

Author:

z0rglub

Message:

• function mysql_query replaced by pwg_query : the same with debugging features

• by default, DEBUG is set to 0 (off)

File:

• trunk/include/functions_category.inc.php (modified) (15 diffs)

trunk/include/functions_category.inc.php

@@ -89 +89 @@
       $query = 'SELECT id';
       $query.= ' FROM '.CATEGORIES_TABLE.' WHERE id = '.$cat.';';
-      $result = mysql_query( $query );
+      $result = pwg_query( $query );
       if ( mysql_num_rows( $result ) != 0 )
       {
@@ -140 +140 @@
 
   $plain_structure = array();
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   while ( $row = mysql_fetch_array( $result ) )
   {
@@ -271 +271 @@
 // ;';
  
-  $row = mysql_fetch_array( mysql_query( $query ) );
+  $row = mysql_fetch_array( pwg_query( $query ) );
 
   if ( !isset( $row['total'] ) ) $row['total'] = 0;
@@ -307 +307 @@
   $query.= ' AND a.site_id = b.id';
   $query.= ';';
-  $row = mysql_fetch_array( mysql_query( $query ) );
+  $row = mysql_fetch_array( pwg_query( $query ) );
 
   $cat = array();
@@ -330 +330 @@
   $query.= ' ORDER BY id ASC';
   $query.= ';';
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   while( $row = mysql_fetch_array( $result ) )
   {
@@ -369 +369 @@
     $query.= ' FROM '.CATEGORIES_TABLE.' WHERE id = '.$category_id;
     $query.= ';';
-    $row = mysql_fetch_array( mysql_query( $query ) );
+    $row = mysql_fetch_array( pwg_query( $query ) );
     $uppercats = $row['uppercats'];
   }
@@ -379 +379 @@
   $query.= ' FROM '.CATEGORIES_TABLE.' WHERE id IN ('.$uppercats.')';
   $query.= ';';
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   while( $row = mysql_fetch_array( $result ) )
   {
@@ -404 +404 @@
     AND c.id = '.$category_id.'
 ;';
-  $row = mysql_fetch_array(mysql_query($query));
+  $row = mysql_fetch_array(pwg_query($query));
   return $row['galleries_url'];
 }
@@ -594 +594 @@
   WHERE '.implode(' OR ', $search_cat_clauses).'
 ;';
-            $result = mysql_query($query);
+            $result = pwg_query($query);
             $cat_ids = array();
             while ($row = mysql_fetch_array($result))
@@ -669 +669 @@
       {
         $page['title'] = $conf['top_number'].' '.$lang['most_visited_cat'];
-        
-        if ( isset( $forbidden ) ) $page['where'] = ' WHERE '.$forbidden;
-        else                       $page['where'] = '';
+
+        $page['where'] = 'WHERE hit > 0';
+        if (isset($forbidden))
+        {
+          $page['where'] = "\n".'    AND '.$forbidden;
+        }
+
         $conf['order_by'] = ' ORDER BY hit DESC, file ASC';
         $page['cat_nb_images'] = $conf['top_number'];
@@ -750 +754 @@
   '.$page['where'].'
 ;';
-        $row = mysql_fetch_array(mysql_query($query));
+        $row = mysql_fetch_array(pwg_query($query));
         if ($row['count'] < $conf['top_number'])
         {
@@ -789 +793 @@
       if (isset($query))
       {
-        $result = mysql_query( $query );
+        $result = pwg_query( $query );
         $row = mysql_fetch_array( $result );
         $page['cat_nb_images'] = $row['nb_total_images'];
@@ -844 +848 @@
   $query.= ';';
 
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   while ( $row = mysql_fetch_array( $result ) )
   {
@@ -875 +879 @@
   $query.= ' ORDER BY RAND()';
   $query.= ';';
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   while ( $row = mysql_fetch_array( $result ) )
   {
@@ -883 +887 @@
     }
   }
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   while ( $row = mysql_fetch_array( $result ) )
   {