getModuleSpecific(); $newValues = Request::post('setting'); if (is_array($newValues)) { if (!User::hasPermission('superadmin')) { Message::addError('main.no-permission'); Util::redirect('?do=baseconfig'); } // Build variables for specific sub-settings if (empty($this->qry_extra['field'])) { $qry_insert = ''; $qry_values = ''; $params = array(); } else { $qry_insert = ', ' . $this->qry_extra['field']; $qry_values = ', :field_value'; $params = array('field_value' => $this->qry_extra['field_value']); $delExtra = " AND {$this->qry_extra['field']} = :field_value "; $delParams = array('field_value' => $this->qry_extra['field_value']); } if ($this->targetModule === false) { $override = false; } else { // Not editing global settings if ($this->getCurrentModuleName() === false) { Message::addError('main.value-invalid', $this->qry_extra['field'], $this->qry_extra['field_value']); Util::redirect('?do=BaseConfig'); } // Honor override checkbox $override = Request::post('override', array()); } // Load all existing config options to validate input $vars = BaseConfigUtil::getVariables(); foreach ($vars as $key => $var) { if (is_array($override) && (!isset($override[$key]) || $override[$key] !== 'on')) { // module mode - override not set - delete $delParams['key'] = $key; Database::exec("DELETE FROM {$this->qry_extra['table']} WHERE setting = :key $delExtra", $delParams); continue; } $validator = $var['validator']; $displayValue = (isset($newValues[$key]) ? $newValues[$key] : ''); // Validate data first! $mangledValue = Validator::validate($validator, $displayValue); if ($mangledValue === false) { Message::addWarning('main.value-invalid', $key, $displayValue); continue; } // Now put into DB Database::exec("INSERT INTO {$this->qry_extra['table']} (setting, value, displayvalue $qry_insert)" . " VALUES (:key, :value, :displayvalue $qry_values)" . " ON DUPLICATE KEY UPDATE value = :value, displayvalue = :displayvalue", array( 'key' => $key, 'value' => $mangledValue, 'displayvalue' => $displayValue ) + $params ); } Message::addSuccess('settings-updated'); if ($this->targetModule === false) { Util::redirect('?do=BaseConfig'); } elseif (empty($this->qry_extra['field'])) { Util::redirect('?do=BaseConfig&module=' . $this->targetModule); } else { Util::redirect('?do=BaseConfig&module=' . $this->targetModule . '&' . $this->qry_extra['field'] . '=' . $this->qry_extra['field_value']); } } } protected function doRender() { if (!User::hasPermission('superadmin')) { Message::addError('main.no-permission'); Util::redirect('?do=Main'); } // Check if valid submodule mode, store name if any if ($this->targetModule !== false) { $this->qry_extra['subheading'] = $this->getCurrentModuleName(); if ($this->qry_extra['subheading'] === false) { Message::addError('main.value-invalid', $this->qry_extra['field'], $this->qry_extra['field_value']); Util::redirect('?do=BaseConfig'); } } // List config options $settings = array(); $vars = BaseConfigUtil::getVariables(); $cats = BaseConfigUtil::getCategories(); // Get stuff that's set in DB already if (isset($this->qry_extra['field'])) { $where = " WHERE {$this->qry_extra['field']} = :field_value"; $params = array('field_value' => $this->qry_extra['field_value']); } else { $where = ''; $params = array(); } // Populate structure with existing config from db $res = Database::simpleQuery("SELECT setting, value, displayvalue FROM {$this->qry_extra['table']} " . " {$where} ORDER BY setting ASC", $params); while ($row = $res->fetch(PDO::FETCH_ASSOC)) { if (!isset($vars[$row['setting']]) || !is_array($vars[$row['setting']])) { $unknown[] = $row['setting']; continue; } $row += $vars[$row['setting']]; if (is_null($row['displayvalue'])) { $row['displayvalue'] = $row['defaultvalue']; } if (!isset($row['catid'])) { $row['catid'] = 'unknown'; } $settings[$row['catid']]['settings'][$row['setting']] = $row; } // Add entries that weren't in the db (global), setup override checkbox (module specific) foreach ($vars as $key => $var) { if (isset($settings[$var['catid']]['settings'][$key])) { // Value is set in DB $settings[$var['catid']]['settings'][$key]['checked'] = 'checked'; } else { // Value is not set in DB $settings[$var['catid']]['settings'][$key] = $var + array( 'setting' => $key ); } $settings[$var['catid']]['settings'][$key] += array( 'item' => $this->makeInput($var['validator'], $key, $var['defaultvalue']), 'description' => Util::markup(Dictionary::translateFileModule($var['module'], 'config-variables', $key)) ); } // Sort categories $sortvals = array(); foreach ($settings as $catid => &$setting) { $sortvals[] = isset($cats[$catid]) ? (int)$cats[$catid]['sortpos'] : 99999; $setting['category_id'] = $catid; $setting['category_name'] = Dictionary::translateFileModule($cats[$catid]['module'], 'config-variable-categories', $catid); if ($setting['category_name'] === false) { $setting['category_name'] = $catid; } $setting['settings'] = array_values($setting['settings']); } unset($setting); array_multisort($sortvals, SORT_ASC, SORT_NUMERIC, $settings); Render::addTemplate('_page', array( 'userid' => User::getId(), 'override' => $this->targetModule !== false, 'categories' => array_values($settings), 'target_module' => $this->targetModule, ) + $this->qry_extra); } private function getCurrentModuleName() { if (isset($this->qry_extra['tostring'])) { $method = explode('::', $this->qry_extra['tostring']); return call_user_func($method, $this->qry_extra['field_value']); } if (isset($this->qry_extra['field'])) { return $this->targetModule . ' // ' . $this->qry_extra['field'] . '=' . $this->qry_extra['field_value']; } return $this->targetModule; } private function getModuleSpecific() { $module = Request::any('module', '', 'string'); if ($module === '') { $this->qry_extra = array( 'table' => 'setting_global', ); return; } //\\//\\//\\ if (!Module::isAvailable($module)) { Message::addError('main.no-such-module', $module); Util::redirect('?do=baseconfig'); } $file = 'modules/' . $module . '/baseconfig/hook.json'; if (!file_exists($file)) { Message::addError('no-module-hook', $module); Util::redirect('?do=baseconfig'); } $hook = json_decode(file_get_contents($file), true); if (empty($hook['table'])) { Message::addError('invalid-hook', $module); Util::redirect('?do=baseconfig'); } if (isset($hook['field'])) { $hook['field_value'] = Request::any($hook['field'], '0', 'string'); } $this->targetModule = $module; $this->qry_extra = $hook; } /** * Create html snippet for setting, based on given validator * @param type $validator * @return boolean */ private function makeInput($validator, $setting, $current) { $parts = explode(':', $validator, 2); if ($parts[0] === 'list') { $items = explode('|', $parts[1]); $ret = ''; } // Password field guessing if (stripos($validator, 'password') !== false) { $type = Property::getPasswordFieldType(); } else { $type = 'text'; } // Fallback: single line input return ''; } }