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

Timestamp:

May 25, 2003, 10:31:39 AM (21 years ago)

Author:

z0rglub

Message:

search improved

File:

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

trunk/include/functions_category.inc.php

@@ -133 +133 @@
       if ( $page['cat'] == 'search' )
       {
-        $url.= "&search=".$_GET['search'];
+        $url.= "&search=".$_GET['search'].'&mode='.$_GET['mode'];
       }
       $lien_cat = add_session_id( $url );
@@ -382 +382 @@
     else
     {
-      $query = '';
+      if ( $page['cat'] == 'search' or $page['cat'] == 'most_visited'
+           or $page['cat'] == 'recent' or $page['cat'] == 'best_rated' )
+      {
+        // we must not show pictures of a forbidden category
+        $restricted_cats = get_all_restrictions( $user['id'],$user['status'] );
+        foreach ( $restricted_cats as $restricted_cat ) {
+          $where_append.= ' AND cat_id != '.$restricted_cat;
+        }
+      }
       // search result
       if ( $page['cat'] == 'search' )
@@ -392 +400 @@
           $page['title'].= $_GET['search']."</span>";
         }
-        $page['where'] = " WHERE ( file LIKE '%".$_GET['search']."%'";
-        $page['where'].= " OR name LIKE '%".$_GET['search']."%'";
-        $page['where'].= " OR comment LIKE '%".$_GET['search']."%' )";
+
+        $page['where'] = ' WHERE (';
+        $fields = array( 'file', 'name', 'comment' );
+        $words = explode( ',', $_GET['search'] );
+        $sql_search = array();
+        foreach ( $words as $i => $word ) {
+          if ( $_GET['mode'] == 'OR' )
+          {
+            if ( $i != 0 ) $page['where'].= ' OR';
+            foreach ( $fields as $j => $field ) {
+              if ( $j != 0 ) $page['where'].= ' OR';
+              $page['where'].= ' '.$field." LIKE '%".$word."%'";
+            }
+          }
+          else if ( $_GET['mode'] == 'AND' )
+          {
+            if ( $i != 0 ) $page['where'].= ' AND';
+            $page['where'].= ' (';
+            foreach ( $fields as $j => $field ) {
+              if ( $j != 0 ) $page['where'].= ' OR';
+              $page['where'].= ' '.$field." LIKE '%".$word."%'";
+            }
+            $page['where'].= ' )';
+          }
+        }
+        $page['where'].= ' )';
+        $page['where'].= $where_append;
 
         $query = 'SELECT COUNT(*) AS nb_total_images';
@@ -401 +433 @@
         $query.= ';';
 
-        $url.= '&amp;search='.$_GET['search'];
+        $url.= '&amp;search='.$_GET['search'].'&amp;mode='.$_GET['mode'];
       }
       // favorites displaying
@@ -426 +458 @@
         $page['where'] = " WHERE date_available > '";
         $page['where'].= date( 'Y-m-d', $date )."'";
+        $page['where'].= $where_append;
 
         $query = 'SELECT COUNT(*) AS nb_total_images';
@@ -436 +469 @@
       {
         $page['title'] = $conf['top_number'].' '.$lang['most_visited_cat'];
-        $page['where'] = ' WHERE cat_id != -1';
+        $page['where'] = ' WHERE cat_id != -1'.$where_append;
         $conf['order_by'] = ' ORDER BY hit DESC, file ASC';
         $page['cat_nb_images'] = $conf['top_number'];
@@ -450 +483 @@
         $row = mysql_fetch_array( $result );
         $page['cat_nb_images'] = $row['nb_total_images'];
-      }
-      
-      if ( $page['cat'] == 'search' or $page['cat'] == 'most_visited'
-           or $page['cat'] == 'recent' or $page['cat'] == 'best_rated' )
-      {
-        // we must not show pictures of a forbidden category
-        $restricted_cats = get_all_restrictions( $user['id'],$user['status'] );
-        foreach ( $restricted_cats as $restricted_cat ) {
-          $page['where'].= ' AND cat_id != '.$restricted_cat;
-        }
       }
     }
@@ -519 +542 @@
   while ( $row = mysql_fetch_array( $result ) )
   {
-    if ( $row['nb_images'] == 0 )
-    {
-      $non_empty_cat = get_first_non_empty_cat_id( $row['id'] );
-    }
-    else
-    {
-      $non_empty_cat = $row['id'];
-    }
     // only categories with findable picture in any of its subcats is
     // represented.
-    if ( $non_empty_cat != false )
+    if ( ( $row['nb_images'] != 0 and $non_empty_cat = $row['id'] )
+         or $non_empty_cat = get_first_non_empty_cat_id( $row['id'] ) )
     {
       $temp_cat = array(
-        'id' => $row['id'],
-        'name' => $row['name'],
-        'dir' => $row['dir'],
-        'date_dernier' => $row['date_dernier'],
+        'id'            => $row['id'],
+        'name'          => $row['name'],
+        'dir'           => $row['dir'],
+        'date_dernier'  => $row['date_dernier'],
         'non_empty_cat' => $non_empty_cat );
       array_push( $cats, $temp_cat );