[geeklog-hg] geeklog: Fixed SQLs for upgrading from Geeklog-2.0.0

[geeklog-cvs at lists.geeklog.net]

changeset 9422:2b5b93189f8c
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/2b5b93189f8c
user: Kenji ITO <mystralkk at gmail.com>
date: Mon Jan 13 09:15:41 2014 +0900
description:
Fixed SQLs for upgrading from Geeklog-2.0.0

diffstat:

 sql/updates/mssql_2.0.0_to_2.1.0.php |  8 ++++----
 sql/updates/mysql_2.0.0_to_2.1.0.php |  8 ++++----
 sql/updates/pgsql_2.0.0_to_2.1.0.php |  8 ++++----
 3 files changed, 12 insertions(+), 12 deletions(-)

diffs (72 lines):

diff -r e07d894bb274 -r 2b5b93189f8c sql/updates/mssql_2.0.0_to_2.1.0.php
--- a/sql/updates/mssql_2.0.0_to_2.1.0.php	Sun Jan 12 22:09:09 2014 +0900
+++ b/sql/updates/mssql_2.0.0_to_2.1.0.php	Mon Jan 13 09:15:41 2014 +0900
@@ -164,16 +164,16 @@
 
     // Subgroup: File Manager
     // subgroup
-    $sg  =  (int) DB_getItem("MAX(subgroup)", $_TABLES['conf_values']) + 1;
+    $sg  =  (int) DB_getItem($_TABLES['conf_values'], "MAX(subgroup)") + 1;
 
     // fieldset
-    $fs  = (int) DB_getItem("MAX(fieldset)", $_TABLES['conf_values']) + 1;
+    $fs  = (int) DB_getItem($_TABLES['conf_values'], "MAX(fieldset)") + 1;
 
     // tab
-    $tab = (int) DB_getItem("MAX(tab)", $_TABLES['conf_values']) + 1;
+    $tab = (int) DB_getItem($_TABLES['conf_values'], "MAX(tab)") + 1;
     
     // sort
-    $so  = (int) DB_getItem("MAX(sort_order)", $_TABLES['conf_values']) + 10;
+    $so  = (int) DB_getItem($_TABLES['conf_values'], "MAX(sort_order)") + 10;
 
     // Subgroup: File Manager - General Settings
     $c->add('sg_filemanager', NULL, 'subgroup', $sg, $fs, NULL, 0, TRUE, $me, 0);
diff -r e07d894bb274 -r 2b5b93189f8c sql/updates/mysql_2.0.0_to_2.1.0.php
--- a/sql/updates/mysql_2.0.0_to_2.1.0.php	Sun Jan 12 22:09:09 2014 +0900
+++ b/sql/updates/mysql_2.0.0_to_2.1.0.php	Mon Jan 13 09:15:41 2014 +0900
@@ -164,16 +164,16 @@
 
     // Subgroup: File Manager
     // subgroup
-    $sg  =  (int) DB_getItem("MAX(subgroup)", $_TABLES['conf_values']) + 1;
+    $sg  =  (int) DB_getItem($_TABLES['conf_values'], "MAX(subgroup)" ) + 1;
 
     // fieldset
-    $fs  = (int) DB_getItem("MAX(fieldset)", $_TABLES['conf_values']) + 1;
+    $fs  = (int) DB_getItem($_TABLES['conf_values'], "MAX(fieldset)") + 1;
 
     // tab
-    $tab = (int) DB_getItem("MAX(tab)", $_TABLES['conf_values']) + 1;
+    $tab = (int) DB_getItem($_TABLES['conf_values'], "MAX(tab)") + 1;
     
     // sort
-    $so  = (int) DB_getItem("MAX(sort_order)", $_TABLES['conf_values']) + 10;
+    $so  = (int) DB_getItem($_TABLES['conf_values'], "MAX(sort_order)") + 10;
 
     // Subgroup: File Manager - General Settings
     $c->add('sg_filemanager', NULL, 'subgroup', $sg, $fs, NULL, 0, TRUE, $me, 0);
diff -r e07d894bb274 -r 2b5b93189f8c sql/updates/pgsql_2.0.0_to_2.1.0.php
--- a/sql/updates/pgsql_2.0.0_to_2.1.0.php	Sun Jan 12 22:09:09 2014 +0900
+++ b/sql/updates/pgsql_2.0.0_to_2.1.0.php	Mon Jan 13 09:15:41 2014 +0900
@@ -164,16 +164,16 @@
 
     // Subgroup: File Manager
     // subgroup
-    $sg  =  (int) DB_getItem("MAX(subgroup)", $_TABLES['conf_values']) + 1;
+    $sg  =  (int) DB_getItem($_TABLES['conf_values'], "MAX(subgroup)") + 1;
 
     // fieldset
-    $fs  = (int) DB_getItem("MAX(fieldset)", $_TABLES['conf_values']) + 1;
+    $fs  = (int) DB_getItem($_TABLES['conf_values'], "MAX(fieldset)") + 1;
 
     // tab
-    $tab = (int) DB_getItem("MAX(tab)", $_TABLES['conf_values']) + 1;
+    $tab = (int) DB_getItem($_TABLES['conf_values'], "MAX(tab)") + 1;
     
     // sort
-    $so  = (int) DB_getItem("MAX(sort_order)", $_TABLES['conf_values']) + 10;
+    $so  = (int) DB_getItem($_TABLES['conf_values'], "MAX(sort_order)") + 10;
 
     // Subgroup: File Manager - General Settings
     $c->add('sg_filemanager', NULL, 'subgroup', $sg, $fs, NULL, 0, TRUE, $me, 0);