Changeset 76 for trunk/include/onupdate.php

Timestamp:

Jan 30, 2009, 9:55:03 PM (15 years ago)

Author:

toemon

Message:

xpressmeプラグイン側で、XOOPSグループに対する権限設定を行うためのデータベースと設定画面を追加
（まだ完全に動いてません）

File:

• trunk/include/onupdate.php (modified) (1 diff)

trunk/include/onupdate.php

@@ -100 +100 @@
                         )$charset_collate;";
                 dbDelta($queries);
+        }
+
+        if (! enhanced_table_check($mydirname,'group_role')){
+                $xp_prefix = $mydirname;
+                if ($xp_prefix == 'wordpress'){
+                        $xp_prefix = 'wp';
+                }
+                
+                $charset_collate = '';
+                if ( version_compare(mysql_get_server_info(), '4.1.0', '>=') ) {
+                        if ( ! empty($wpdb->charset) )
+                        $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
+                        if ( ! empty($wpdb->collate) )
+                        $charset_collate .= " COLLATE $wpdb->collate";
+                }
+        
+                $group_role = XOOPS_DB_PREFIX . '_' . $xp_prefix .'_group_role' ;
+                $views_queries ="CREATE TABLE $group_role (
+                        groupid smallint(5) unsigned NOT NULL default '0',
+                        name varchar(50)  NOT NULL default '' ,
+                        description text  NOT NULL default '',
+                        group_type varchar(10)  NOT NULL default '' ,
+                        role varchar(20)  NOT NULL default '' ,
+                        KEY groupid (groupid)
+                        )$charset_collate;";
+                dbDelta($views_queries);
         }