예제 #1
0
 public function install()
 {
     load_textdomain('private_messages', dirname(__FILE__) . '/lang/' . $this->feather->forum_settings['o_default_lang'] . '/private-messages.mo');
     $database_scheme = array('pms_data' => "CREATE TABLE IF NOT EXISTS %t% (\n                `conversation_id` int(10) unsigned NOT NULL,\n                `user_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',\n                `viewed` tinyint(1) unsigned NOT NULL DEFAULT '0',\n                `folder_id` int(10) unsigned NOT NULL DEFAULT '2',\n                PRIMARY KEY (`conversation_id`, `user_id`),\n                KEY `folder_idx` (`folder_id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_folders' => "CREATE TABLE IF NOT EXISTS %t% (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `name` varchar(80) NOT NULL DEFAULT 'New Folder',\n                `user_id` int(10) unsigned NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`),\n                KEY `user_idx` (`user_id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_messages' => "CREATE TABLE IF NOT EXISTS %t% (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `poster` varchar(200) NOT NULL DEFAULT '',\n                `poster_id` int(10) unsigned NOT NULL DEFAULT '1',\n                `poster_ip` varchar(39) DEFAULT NULL,\n                `message` mediumtext,\n                `hide_smilies` tinyint(1) NOT NULL DEFAULT '0',\n                `sent` int(10) unsigned NOT NULL DEFAULT '0',\n                `edited` int(10) unsigned DEFAULT NULL,\n                `edited_by` varchar(200) DEFAULT NULL,\n                `conversation_id` int(10) unsigned NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`),\n                KEY `conversation_idx` (`conversation_id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_conversations' => "CREATE TABLE IF NOT EXISTS %t% (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `poster` varchar(200) NOT NULL DEFAULT '',\n                `poster_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `subject` varchar(255) NOT NULL DEFAULT '',\n                `first_post_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `last_post_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `last_post` int(10) unsigned NOT NULL DEFAULT '0',\n                `last_poster` varchar(200) DEFAULT NULL,\n                `num_replies` mediumint(8) unsigned NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_blocks' => "CREATE TABLE `%t%` (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `user_id` int(10) NOT NULL DEFAULT '0',\n                `block_id` int(10) NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
     // Create tables
     $installer = new \FeatherBB\Model\Install();
     foreach ($database_scheme as $table => $sql) {
         $installer->create_table($this->feather->forum_settings['db_prefix'] . $table, $sql);
     }
     // Create default inboxes
     $folders = array(__('New', 'private_messages'), __('Inbox', 'private_messages'), __('Archived', 'private_messages'));
     foreach ($folders as $folder) {
         $insert = array('name' => $folder, 'user_id' => 1);
         $installer->add_data('pms_folders', $insert);
     }
 }
 public function install()
 {
     translate('private_messages', 'private-messages', ForumSettings::get('o_default_lang'));
     $database_scheme = array('pms_data' => "CREATE TABLE IF NOT EXISTS %t% (\n                `conversation_id` int(10) unsigned NOT NULL,\n                `user_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',\n                `viewed` tinyint(1) unsigned NOT NULL DEFAULT '0',\n                `folder_id` int(10) unsigned NOT NULL DEFAULT '2',\n                PRIMARY KEY (`conversation_id`, `user_id`),\n                KEY `folder_idx` (`folder_id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_folders' => "CREATE TABLE IF NOT EXISTS %t% (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `name` varchar(80) NOT NULL DEFAULT 'New Folder',\n                `user_id` int(10) unsigned NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`),\n                KEY `user_idx` (`user_id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_messages' => "CREATE TABLE IF NOT EXISTS %t% (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `poster` varchar(200) NOT NULL DEFAULT '',\n                `poster_id` int(10) unsigned NOT NULL DEFAULT '1',\n                `poster_ip` varchar(39) DEFAULT NULL,\n                `message` mediumtext,\n                `hide_smilies` tinyint(1) NOT NULL DEFAULT '0',\n                `sent` int(10) unsigned NOT NULL DEFAULT '0',\n                `edited` int(10) unsigned DEFAULT NULL,\n                `edited_by` varchar(200) DEFAULT NULL,\n                `conversation_id` int(10) unsigned NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`),\n                KEY `conversation_idx` (`conversation_id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_conversations' => "CREATE TABLE IF NOT EXISTS %t% (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `poster` varchar(200) NOT NULL DEFAULT '',\n                `poster_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `subject` varchar(255) NOT NULL DEFAULT '',\n                `first_post_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `last_post_id` int(10) unsigned NOT NULL DEFAULT '0',\n                `last_post` int(10) unsigned NOT NULL DEFAULT '0',\n                `last_poster` varchar(200) DEFAULT NULL,\n                `num_replies` mediumint(8) unsigned NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;", 'pms_blocks' => "CREATE TABLE IF NOT EXISTS %t% (\n                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n                `user_id` int(10) NOT NULL DEFAULT '0',\n                `block_id` int(10) NOT NULL DEFAULT '0',\n                PRIMARY KEY (`id`)\n            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
     // Create tables
     $installer = new \FeatherBB\Model\Install();
     foreach ($database_scheme as $table => $sql) {
         $installer->create_table(ForumSettings::get('db_prefix') . $table, $sql);
     }
     DB::for_table('groups')->raw_execute('ALTER TABLE ' . ForumSettings::get('db_prefix') . 'groups ADD `g_pm_limit` smallint(3) NOT NULL DEFAULT \'0\'');
     DB::for_table('groups')->raw_execute('ALTER TABLE ' . ForumSettings::get('db_prefix') . 'groups ADD `g_use_pm` tinyint(1) NOT NULL DEFAULT \'0\'');
     DB::for_table('groups')->raw_execute('ALTER TABLE ' . ForumSettings::get('db_prefix') . 'groups ADD `g_pm_folder_limit` int(3) NOT NULL DEFAULT \'0\'');
     // Create default inboxes
     $folders = array(__('New', 'private_messages'), __('Inbox', 'private_messages'), __('Archived', 'private_messages'));
     foreach ($folders as $folder) {
         $insert = array('name' => $folder, 'user_id' => 1);
         $installer->add_data('pms_folders', $insert);
     }
 }