Changeset 4367 for trunk/include/category_cats.inc.php

Timestamp:

Nov 25, 2009, 8:02:57 PM (14 years ago)

Author:

nikrou

Message:

Feature 1255: modification in sql queries

• manage random function
• manage regex syntax
• manage quote (single instead of double)
• manage interval

File:

• trunk/include/category_cats.inc.php (modified) (3 diffs)

trunk/include/category_cats.inc.php

@@ -36 +36 @@
   FROM '.CATEGORIES_TABLE.' c INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.'
   ON id = cat_id and user_id = '.$user['id'].'
-  WHERE date_last >= SUBDATE(
-    CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY
-  )
+  WHERE date_last >= '.pwg_db_get_recent_period_expression($user['recent_period']).'
 '.get_sql_condition_FandF
   (
@@ -105 +103 @@
       "\n  AND"
     ).'
-  ORDER BY RAND()
+  ORDER BY '.DB_RANDOM_FUNCTION.'()
   LIMIT 1
 ;';
@@ -133 +131 @@
       "\n  AND"
     ).'
-    ORDER BY RAND()
+    ORDER BY '.DB_RANDOM_FUNCTION.'()
     LIMIT 1
   ;';