public function install()
{
ConfigurationAccessor::set('cookie-prefix', 'sym-members', 'members');
$this->_Parent->saveConfig();
Symphony::Database()->import("\r\n\t\t\t\r\n\t\t\t\tCREATE TABLE `tbl_fields_member` (\r\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\r\n\t\t\t\t `field_id` int(11) unsigned NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t UNIQUE KEY `field_id` (`field_id`)\r\n\t\t\t\t);\r\n\r\n\r\n\t\t\t\tCREATE TABLE `tbl_fields_memberlink` (\r\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\r\n\t\t\t\t `field_id` int(11) unsigned NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t UNIQUE KEY `field_id` (`field_id`)\r\n\t\t\t\t);\r\n\r\n\r\n\t\t\t\tCREATE TABLE `tbl_fields_memberrole` (\r\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\r\n\t\t\t\t `field_id` int(11) unsigned NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t UNIQUE KEY `field_id` (`field_id`)\r\n\t\t\t\t);\r\n\r\n\t\t\t\tCREATE TABLE `tbl_members_login_tokens` (\r\n\t\t\t\t `member_id` int(11) unsigned NOT NULL,\r\n\t\t\t\t `token` varchar(8) NOT NULL,\r\n\t\t\t\t `expiry` int(11) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`member_id`),\r\n\t\t\t\t KEY `token` (`token`)\r\n\t\t\t\t) ;\r\n\r\n\r\n\t\t\t\tCREATE TABLE `tbl_members_roles` (\r\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\r\n\t\t\t\t `name` varchar(60) NOT NULL,\r\n\t\t\t\t `email_subject` varchar(255) default NULL,\r\n\t\t\t\t `email_body` longtext ,\r\n\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t UNIQUE KEY `name` (`name`)\r\n\t\t\t\t) ;\r\n\r\n\r\n\t\t\t\tCREATE TABLE `tbl_members_roles_event_permissions` (\r\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\r\n\t\t\t\t `role_id` int(11) unsigned NOT NULL,\r\n\t\t\t\t `event` varchar(50) NOT NULL,\r\n\t\t\t\t `action` varchar(60) NOT NULL,\r\n\t\t\t\t `allow` enum('yes','no') NOT NULL default 'no',\r\n\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t KEY `role_id` (`role_id`,`event`,`action`)\r\n\t\t\t\t) ;\r\n\r\n\r\n\t\t\t\tCREATE TABLE `tbl_members_roles_page_permissions` (\r\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\r\n\t\t\t\t `role_id` int(11) unsigned NOT NULL,\r\n\t\t\t\t `page_id` int(11) unsigned NOT NULL,\r\n\t\t\t\t `allow` enum('yes','no') NOT NULL default 'no',\r\n\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t KEY `role_id` (`role_id`,`page_id`)\r\n\t\t\t\t)\r\n\t\t\t\r\n\t\t\t");
Symphony::Database()->query("INSERT INTO `tbl_members_roles` VALUES (1, 'Guest', NULL, NULL);");
}
function action()
{
##Do not proceed if the config file is read only
if (!is_writable(CONFIG)) {
redirect($this->_Parent->getCurrentPageURL());
}
if (isset($_POST['action']['save'])) {
$settings = array_map('addslashes', $_POST['fields']);
foreach ($settings as $key => $value) {
ConfigurationAccessor::set($key, $value, 'members');
}
$this->_Parent->saveConfig();
redirect($this->_Parent->getCurrentPageURL());
}
}
