From d8d8ca5ed389f8c3e22a928d3be9e87bd1f05f39 Mon Sep 17 00:00:00 2001
From: nikrou <nikrou@piwigo.org>
Date: Sun, 9 May 2010 20:52:38 +0000
Subject: Fix get_enums function for SQLite hard coded enums values for all
 tables because enum feature doesn't exists for SQLite.

git-svn-id: http://piwigo.org/svn/trunk@6153 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 include/dblayer/functions_pdo-sqlite.inc.php | 14 +++++++++++++-
 include/dblayer/functions_sqlite.inc.php     | 14 +++++++++++++-
 2 files changed, 26 insertions(+), 2 deletions(-)

(limited to 'include/dblayer')

diff --git a/include/dblayer/functions_pdo-sqlite.inc.php b/include/dblayer/functions_pdo-sqlite.inc.php
index d59e3b510..a4c3881f0 100644
--- a/include/dblayer/functions_pdo-sqlite.inc.php
+++ b/include/dblayer/functions_pdo-sqlite.inc.php
@@ -431,7 +431,19 @@ function pwg_db_cast_to_text($string)
  */
 function get_enums($table, $field)
 {
-  return array();
+  $Enums['categories']['status'] = array('public', 'private');
+  $Enums['history']['section'] = array('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats');
+  $Enums['user_infos']['status'] = array('webmaster','admin','normal','generic','guest');
+  $Enums['image']['type'] = array('picture','high','other');
+  $Enums['plugins']['state'] = array('active', 'inactive');
+  $Enums['user_cache_image']['access_type'] = array('NOT IN','IN');
+
+  $table = str_replace($GLOBALS['prefixeTable'], '', $table);
+  if (isset($Enums[$table][$field])) {
+    return $Enums[$table][$field];
+  } else {
+    return array();
+  }
 }
 
 // get_boolean transforms a string to a boolean value. If the string is
diff --git a/include/dblayer/functions_sqlite.inc.php b/include/dblayer/functions_sqlite.inc.php
index 5c8f76a9c..1b34d3fcb 100644
--- a/include/dblayer/functions_sqlite.inc.php
+++ b/include/dblayer/functions_sqlite.inc.php
@@ -443,7 +443,19 @@ function pwg_db_cast_to_text($string)
  */
 function get_enums($table, $field)
 {
-  return array();
+  $Enums['categories']['status'] = array('public', 'private');
+  $Enums['history']['section'] = array('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats');
+  $Enums['user_infos']['status'] = array('webmaster','admin','normal','generic','guest');
+  $Enums['image']['type'] = array('picture','high','other');
+  $Enums['plugins']['state'] = array('active', 'inactive');
+  $Enums['user_cache_image']['access_type'] = array('NOT IN','IN');
+
+  $table = str_replace($GLOBALS['prefixeTable'], '', $table);
+  if (isset($Enums[$table][$field])) {
+    return $Enums[$table][$field];
+  } else {
+    return array();
+  }
 }
 
 // get_boolean transforms a string to a boolean value. If the string is
-- 
cgit v1.2.3