示例#1
0
 public function updateconfig()
 {
     $this->checkCsrfToken();
     // confirm the forms authorisation key
     $this->throwForbiddenUnless(SecurityUtil::checkPermission($this->name . '::', '::', ACCESS_ADMIN));
     // get current module variables
     $vars = ModUtil::getVar($this->name);
     // get module variables from form
     $modvars = array();
     $modvars['table_prefix'] = FormUtil::getPassedValue('table_prefix', 'phpbb_', 'POST');
     $modvars['page_title'] = FormUtil::getPassedValue('page_title', '', 'POST');
     $modvars['page_description'] = FormUtil::getPassedValue('page_description', '', 'POST');
     $modvars['page_robots'] = FormUtil::getPassedValue('page_robots', '', 'POST');
     // table prefix change
     if ($vars['table_prefix'] && $vars['table_prefix'] != $modvars['table_prefix']) {
         // table prefix is changed
         $mandatoryinprefix = 'phpbb';
         if (strpos($modvars['table_prefix'], $mandatoryinprefix) === false) {
             return LogUtil::registerError($this->__('Error: table prefix must contain fragment <b>phpbb</b>.'));
         }
         // ok, let's change in db
         $connection = Doctrine_Manager::getInstance()->getCurrentConnection();
         $stmt = $connection->prepare("SHOW TABLES LIKE '%" . $vars['table_prefix'] . "_%'");
         try {
             $stmt->execute();
         } catch (Exception $e) {
             return LogUtil::registerError(__('Error: ') . $e->getMessage());
         }
         $items = $stmt->fetchAll(Doctrine_Core::FETCH_NUM);
         $tablenames = ZphpBB2_Util::getTableNames();
         foreach ($items as $item) {
             $table_stem = ZphpBB2_Util::getTableStem($item[0], $vars['table_prefix']);
             if (in_array($table_stem, $tablenames)) {
                 $stmt = $connection->prepare('RENAME TABLE ' . $item[0] . " TO " . $modvars['table_prefix'] . $table_stem);
                 try {
                     $stmt->execute();
                 } catch (Exception $e) {
                     return LogUtil::registerError(__('Error: ') . $e->getMessage());
                 }
             }
         }
     }
     // update module variables
     $this->setVars($modvars);
     // the module configuration has been updated successfuly
     LogUtil::registerStatus($this->__('Done! Module configuration updated.'));
     return System::redirect(ModUtil::url($this->name, 'admin', 'main'));
 }
示例#2
0
 /**
  * Delete module
  *
  * @return  boolean    true/false
  */
 public function uninstall()
 {
     $table_prefix = ModUtil::getVar('ZphpBB2', 'table_prefix', 'phpbb_');
     $tablenames = ZphpBB2_Util::getTableNames();
     $connection = Doctrine_Manager::getInstance()->getCurrentConnection();
     // str_replace is because _ is wildcard character, as %
     $stmt = $connection->prepare("SHOW TABLES LIKE '" . str_replace('_', '\\_', $table_prefix) . "%'");
     try {
         $stmt->execute();
     } catch (Exception $e) {
         return LogUtil::registerError(__('Error: ') . $e->getMessage());
     }
     $items = $stmt->fetchAll(Doctrine_Core::FETCH_NUM);
     foreach ($items as $item) {
         $table_stem = ZphpBB2_Util::getTableStem($item[0], $table_prefix);
         if (in_array($table_stem, $tablenames)) {
             $stmt = $connection->prepare("DROP TABLE `" . $item[0] . "`");
             try {
                 $stmt->execute();
             } catch (Exception $e) {
                 return LogUtil::registerError(__('Error: ') . $e->getMessage());
             }
         }
     }
     // Unregister event handlers
     EventUtil::unregisterPersistentModuleHandler('ZphpBB2', 'user.account.create', array('ZphpBB2_Listener_UsersSynch', 'createAccountListener'));
     EventUtil::unregisterPersistentModuleHandler('ZphpBB2', 'user.account.update', array('ZphpBB2_Listener_UsersSynch', 'updateAccountListener'));
     EventUtil::unregisterPersistentModuleHandler('ZphpBB2', 'user.account.delete', array('ZphpBB2_Listener_UsersSynch', 'deleteAccountListener'));
     return true;
 }