Changeset 6153 for trunk

Timestamp:

May 9, 2010, 10:52:38 PM (14 years ago)

Author:

nikrou

Message:

Fix get_enums function for SQLite
hard coded enums values for all tables
because enum feature doesn't exists for SQLite.

Location:

trunk

Files:

• admin/user_list.php (modified) (1 diff)
• include/dblayer/functions_pdo-sqlite.inc.php (modified) (1 diff)
• include/dblayer/functions_sqlite.inc.php (modified) (1 diff)

trunk/admin/user_list.php

@@ -593 +593 @@
     isset($_POST['pref_submit']) ? $_POST['language'] : get_default_language());
 
-//Log::getInstance()->debug($status);
 // Status options
 foreach (get_enums(USER_INFOS_TABLE, 'status') as $status)

trunk/include/dblayer/functions_pdo-sqlite.inc.php

@@ -432 +432 @@
 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();
+  }
 }
 

trunk/include/dblayer/functions_sqlite.inc.php

@@ -444 +444 @@
 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();
+  }
 }