<?php
if(!defined('IN_DZZ')) {
exit('Access Denied');
}
class table_user_qqconnect extends dzz_table
{
public function __construct() {
$this->_table = 'user_qqconnect';
$this->_pk = 'openid';
parent::__construct();
}
public function fetch_by_openid($openid){
return DB::fetch_first("select qq.openid,u.* from %t qq LEFT JOIN %t u ON qq.uid=u.uid where qq.openid=%d",array($this->_table,'user',$openid));
}
public function insert_by_openid($openid,$uid,$uinfo,$unbind=0){
if(!$openid) return false;
if(!$user=C::t('user')->fetch($uid)) return false;
if(!DB::insert($this->_table,array('openid'=>$openid,'uid'=>$uid,'unbind'=>$unbind,'dateline'=>TIMESTAMP),1,true)){
return false;
}
}
}
?>