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

Timestamp:

May 23, 2008, 12:15:48 PM (16 years ago)

Author:

rvelices

Message:

• merge r2355 from 1.7 to trunk: fix display of menubar related tags in IE7
• optimized sql query in permalinks
• remove some unused global variable declarations
• fix bug in admin/themeconf.inc.php

File:

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

trunk/include/functions_category.inc.php

@@ -366 +366 @@
   }
   $query ='
-SELECT c.id, op.permalink, 1 AS is_old
-  FROM '.OLD_PERMALINKS_TABLE.' op INNER JOIN '.CATEGORIES_TABLE.' c
-    ON op.cat_id=c.id
-  WHERE op.permalink IN ('.$in.')
+SELECT cat_id AS id, permalink, 1 AS is_old
+  FROM '.OLD_PERMALINKS_TABLE.'
+  WHERE permalink IN ('.$in.')
 UNION
 SELECT id, permalink, 0 AS is_old