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