/**
* Membuat record baru.
*
* @return boolean
*/
public function create($data = [])
{
try {
$this->db->insert($this->table, $data);
return true;
} catch (\Exception $e) {
die($e->getMessage);
}
}
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));
}
}
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);
}
}
/**
* 保存 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();
}
