/**
* 获取系统配置
*/
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;
}
}
