Merging scribus and charlie repos
authorDan
Tue, 05 Jan 2010 09:56:21 -0500
changeset 1204 eaab1c22e237
parent 1203 c6587072e4c4 (current diff)
parent 1199 8d85b52ac9b6 (diff)
child 1205 c922ef08167a
Merging scribus and charlie repos
--- a/plugins/SpecialPageFuncs.php	Tue Jan 05 09:56:00 2010 -0500
+++ b/plugins/SpecialPageFuncs.php	Tue Jan 05 09:56:21 2010 -0500
@@ -298,7 +298,12 @@
   
   $db->free_result();
   
-  $q = $db->sql_unbuffered_query('SELECT CONCAT("ns=",namespace,";pid=",urlname) AS identifier, name FROM '.table_prefix.'pages WHERE visible!=0 ORDER BY name ASC;');
+  // This query needs to be generated based on the DBMS
+  $concat_column = ENANO_DBLAYER == 'MYSQL'
+                     ? 'CONCAT("ns=",namespace,";pid=",urlname)'
+                     : "'ns=' || namespace || ';pid=' || urlname";
+  
+  $q = $db->sql_unbuffered_query("SELECT $concat_column AS identifier, name FROM " . table_prefix . "pages WHERE visible != 0 ORDER BY name ASC;");
   if ( !$q )
     $db->_die();