/** * 获取系统配置 */ public function getOptions() { $sql = "SELECT * FROM {$this->T('www_options')}"; $list = odb::dbslave()->getAll($sql, MYSQL_ASSOC); $info = array(); if (!empty($list)) { foreach ($list as $key => $value) { $info[$value['optionName']] = $value['optionValue']; } } return $info; }
public function delCache($c) { if (!isset($c['type'])) { $cList = $c; $t = 0; if (empty($c)) { return false; } foreach ($cList as $c) { $c = self::getKeyName($c); $sql = "SELECT * FROM {$this->T('www_cache_key')} WHERE `key`='{$c['key']}'"; $list = odb::dbslave()->getAll($sql, MYSQL_ASSOC); if (!empty($list)) { foreach ($list as $key => $value) { $t = cache($value['type'])->delete($value['key'] . $value['key_']); } $sql = "DELETE FROM {$this->T('www_cache_key')} WHERE `key`='{$c['key']}'"; odb::db()->query($sql); $t += odb::db()->affectedRows(); } } return $t; } else { if (empty($c)) { return false; } $c = self::getKeyName($c); $sql = "SELECT * FROM {$this->T('www_cache_key')} WHERE `key`='{$c['key']}'"; $list = odb::dbslave()->getAll($sql, MYSQL_ASSOC); if (!empty($list)) { foreach ($list as $key => $value) { cache($c['type'])->delete($value['key'] . $value['key_']); } $sql = "DELETE FROM {$this->T('www_cache_key')} WHERE `key`='{$c['key']}'"; odb::db()->query($sql); return odb::db()->affectedRows(); } } return false; }
/** * 删除登录SESSION * @param unknown_type $session_key */ public function delSessionKey($session_key) { if (!empty($session_key)) { $tmp_session_id = substr($session_key, 0, 32); if ($this->genSessionKey($tmp_session_id) == substr($session_key, 32)) { $session_id = $tmp_session_id; } else { return false; } } else { return false; } $table = $this->T('www_session'); $sql = "DELETE FROM {$table} WHERE Sesskey='{$session_id}' LIMIT 1"; odb::dbslave()->query($sql); if (odb::dbslave()->affectedRows()) { return true; } else { return false; } }