Fix some sql issues :

- permalink that use if() syntax
- add tables themes for other database engines that mysql

git-svn-id: http://piwigo.org/svn/trunk@5192 68402e56-0260-453c-a942-63ccdbb3a9ee

2 files changed, 6 insertions, 2 deletions

diff --git a/include/dblayer/functions_mysql.inc.php b/include/dblayer/functions_mysql.inc.php
index 8f757ac30..24b075f85 100644
--- a/include/dblayer/functions_mysql.inc.php
+++ b/include/dblayer/functions_mysql.inc.php
@@ -124,7 +124,7 @@ SELECT IF(MAX('.$column.')+1 IS NULL, 1, MAX('.$column.')+1)
 
 function pwg_db_changes($result) 
 {
-  return mysql_affected_rows($result);
+  return mysql_affected_rows();
 }
 
 function pwg_db_num_rows($result) 
@@ -461,7 +461,7 @@ function do_maintenance_all_tables()
 function pwg_db_concat($array)
 {
   $string = implode($array, ',');
-  return 'CONCAT(\''. $string.'\')';
+  return 'CONCAT('. $string.')';
 }
 
 function pwg_db_concat_ws($array, $separator)
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php
index 4ce30a75a..187ecbe8f 100644
--- a/include/functions_category.inc.php
+++ b/include/functions_category.inc.php
@@ -311,6 +311,10 @@ function display_select_categories($categories,
   $tpl_cats = array();
   foreach ($categories as $category)
   {
+    if (!empty($category['permalink']))
+    {
+      $category['name'] .= ' √';
+    }
     if ($fullname)
     {
       $option = get_cat_display_name_cache($category['uppercats'],