Changeset 2135 for trunk/include/ws_functions.inc.php

Timestamp:

Oct 12, 2007, 5:27:34 AM (17 years ago)

Author:

rvelices

Message:

• fix plugin menu link broken with xamp (realpath behaves differently)
• complete quick search rewriting
  • now we can quote phrases as in google "New York" is not the same as New York
  • user comments not searched anymore (faster)
  • the big full text query does not use joins anymore (faster)
  • related tags not shown on the index page, but now you can see the matching tags and matching categories

File:

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

trunk/include/ws_functions.inc.php

@@ -760 +760 @@
   include_once(PHPWG_ROOT_PATH.'include/functions_picture.inc.php');
 
-  $where_clauses = ws_std_image_sql_filter( $params );
-  $order_by = ws_std_image_sql_order($params);
-
-  if ( !empty($where_clauses) and !empty($order_by) )
-  {
+  $where_clauses = ws_std_image_sql_filter( $params, 'i.' );
+  $order_by = ws_std_image_sql_order($params, 'i.');
+
+  if ( !empty($order_by) )
+  {
+    global $conf;
+    $conf['order_by'] = 'ORDER BY '.$order_by;
     $page['super_order_by']=1; // quick_search_result might be faster
   }
-  $search_result = get_quick_search_results($params['query']);
-
-  global $image_ids; //needed for sorting by rank (usort)
-  if ( ( !isset($search_result['as_is'])
-      or !empty($where_clauses)
-      or !empty($order_by) )
-      and !empty($search_result['items']) )
-  {
-    $where_clauses[] = 'id IN ('
-        .wordwrap(implode(', ', $search_result['items']), 80, "\n")
-        .')';
-    $where_clauses[] = get_sql_condition_FandF(
-        array
-          (
-            'forbidden_categories' => 'category_id',
-            'visible_categories' => 'category_id',
-            'visible_images' => 'id'
-          ),
-        '', true
-      );
-    $query = '
-SELECT DISTINCT id FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id=image_id
-  WHERE '.implode('
-    AND ', $where_clauses);
-    if (!empty($order_by))
-    {
-      $query .= '
-  ORDER BY '.$order_by;
-    }
-    $image_ids = array_from_query($query, 'id');
-    global $ranks;
-    $ranks = array_flip( $search_result['items'] );
-    usort(
-      $image_ids,
-      create_function('$i1,$i2', 'global $ranks; return $ranks[$i1]-$ranks[$i2];')
-    );
-    unset ($ranks);
-  }
-  else
-  {
-    $image_ids = $search_result['items'];
-  }
+
+  $search_result = get_quick_search_results($params['query'],
+    implode(',', $where_clauses) );
+  $image_ids = $search_result['items'];
 
   $image_ids = array_slice($image_ids,