function EasySCP_create_pdns_db() { System_Daemon::debug('Create PowerDNS Database'); if (file_exists(DaemonConfig::$cfg->{'CONF_DIR'} . '/database/powerdns.sql')) { DB::query(file_get_contents(DaemonConfig::$cfg->{'CONF_DIR'} . '/database/powerdns.sql'))->closeCursor(); DB::setDatabase(); return 'Ok'; } else { return 'Error: Required file ' . DaemonConfig::$cfg->{'CONF_DIR'} . '/database/powerdns.sql not found'; } }
/** * */ function finishMigration() { $cfg = EasySCP_Registry::get('Config'); DB::setDatabase(); $sql_query = "\n\t\tUPDATE domain SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE domain_aliasses SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE mail_users SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE htaccess SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE htaccess_groups SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE htaccess_users SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE subdomain SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE subdomain_alias SET status = '{$cfg->ITEM_ADD_STATUS}';\n\t\tUPDATE user_gui_props SET lang = '', layout = '';\n\t"; DB::query($sql_query)->closeCursor(); send_request('100 CORE checkAll'); }