static function set_config($name, $value)
{
$one = DB::one('core_config', array('where' => array('slug' => $name)));
if ($one) {
DB::update('core_config', array('body' => $value), 'slug=:slug', array(':slug' => $name));
} else {
DB::insert('core_config', array('slug' => $name, 'body' => $value));
}
}
/**
* 返回用户信息
*
*/
static function get_member($id)
{
$cacheId = 'get_member_' . $id;
$one = \Yii::$app->cache->get($cacheId);
if (!$one) {
$one = DB::one('oauth_users', array('where' => array('id' => $id)));
$one = (object) $one;
\Yii::$app->cache->set($cacheId, $one, 86400 * 360 * 360);
}
return $one;
}
function actionDisplay($id, $form)
{
$id = (int) $id;
if ($id < 1) {
exit;
}
$one = DB::one('comment', array('where' => array('id' => $id)));
$display = $one['display'] == 1 ? 0 : 1;
DB::update('comment', array('display' => $display), 'id=:id', array(':id' => $id));
flash('success', __('sucessful'));
$this->redirect(url('comment/site/index', array('form' => $form)));
}
/**
* 保存 body
*/
static function body($body)
{
$slug = md5(trim($body));
$cacheId = 'database#comment_body_slug_' . $slug;
$one = cache($cacheId);
if (!$one) {
$one = DB::one('comment_body', array('where' => array('slug' => $slug)));
cache($cacheId, $one);
}
if ($one) {
return $one['id'];
}
DB::insert('comment_body', array('slug' => $slug, 'body' => $body));
return DB::id();
}
function member_get_third_set_user($me, $oauth_id, $token)
{
$me['email'] = $me['email'] ?: 'info';
$uniqid = md5(uniqid(microtime()));
if (!$me['id']) {
flash('error', __('login failed'));
$this->redirect(return_url());
}
$one = DB::one('oauth_users', array('where' => array('uid' => $me['id'], 'oauth_id' => $oauth_id)));
if ($one) {
DB::update('oauth_users', array('name' => $me['name'], 'email' => $me['email'], 'token' => $token, 'uuid' => $uniqid), "id=:id", array(':id' => $one['id']));
} else {
DB::insert('oauth_users', array('uid' => $me['id'], 'name' => $me['name'], 'email' => $me['email'], 'oauth_id' => $oauth_id, 'token' => $token, 'uuid' => $uniqid));
}
$one = DB::one('oauth_users', array('where' => array('uuid' => $uniqid, 'oauth_id' => $oauth_id)));
if ($one) {
$value = array('id' => $one['id'], 'name' => $one['name'], 'email' => $one['email'], 'oauth' => true);
cookie('user', json_encode($value), 0);
}
}
