public function settingAction() { $settingModel = Core_Model::factory('System_Model_Setting'); $options = array(); $settings = $settingModel->find_many(); foreach ($settings as $setting) { $options[$setting->name] = trim($setting->value); } if ($this->isPost()) { $sql = array(); $params = array(); $options = array_merge($options, $this->_request['params']); // Update settings $sql[] = 'UPDATE ' . $settingModel->getTableName() . ' SET value = CASE'; foreach (array_keys($options) as $key) { $sql[] = " WHEN name='{$key}' THEN :{$key}"; $params["{$key}"] = trim($this->_request['params'][$key]); } $sql[] = ' END'; $settingModel->raw_execute(implode('', $sql), $params); // Write cache $this->_cache['db']->save($options, 'db_settings'); $this->view->success = 'Change settings successfully'; } $this->view->options = $options; }
public function init() { parent::init(); $this->postModel = Core_Model::factory('Post_Model_Post'); // Get all categories $categoryModel = Core_Model::factory('Category_Model_Category'); $this->view->subcategories = array_filter($categoryModel->find_many(), create_function('$obj', 'return $obj->id_parent != 0;')); }
public static function checkAuth($username, $password) { $userModel = Core_Model::factory('User_Model_User'); $user = $userModel->where_equal('username', $username)->find_one(); if ($user) { return $user->password == sha1($user->salt . $password) ? $user : false; } return false; }
public function deleteAction() { if ($this->isAjax() && $this->isPost()) { $this->_noRender = true; $params = $this->_request['params']; $postModel = Core_Model::factory('Post_Model_Post'); if ($postModel->where_raw('(`id_category` = ? OR `id_subcategory` = ?)', array($params['id'], $params['id']))->find_one()) { echo json_encode(array('success' => true, 'redirect' => false, 'msg' => 'This category is associated with some posts')); } else { $subCategories = array_filter($this->view->categories, create_function('$obj', 'return $obj->id_parent == ' . (int) $params['id'] . ';')); // Update parent of subcategories if ($subCategories) { foreach ($subCategories as $category) { $category->id_parent = 0; $category->save(); } } $this->categoryModel->find_one($params['id'])->delete(); echo json_encode(array('success' => true, 'redirect' => true, 'href' => $this->_router->generate('route_admin_category'))); } } }