public function setUserInfo($openID)
{
$token = $this->getToken();
if ($token == '') {
return '';
}
$url = "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" . $token . "&openid=" . $openID;
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_HEADER, 0);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.64 Safari/537.31");
$content = curl_exec($curl);
curl_close($curl);
$data = json_decode($content, true);
$mysqlHelperObj = new mysqlHelper();
$sql = "select id from users where user='******'";
$id = $mysqlHelperObj->queryValue($sql, 'id');
if ($id == '') {
$sql = "insert into users (user) values('" . $openID . "')";
$mysqlHelperObj->execute($sql);
}
$sql = "update users set name='" . $data['nickname'] . "', city='" . $data['city'] . "',province='" . $data['province'] . "',sex='" . $data['sex'] . "',country='" . $data['country'] . "',headimgurl='" . addslashes($data['headimgurl']) . "', where user='******'";
$mysqlHelperObj->execute($sql);
return 'true';
}
function d_isautoreply($fromuser)
{
$mysqlHelperObj = new mysqlHelper();
$autoreply = 1;
$sql = "select autoreply from users where user = '******' ";
$mysqlHelperObj = new mysqlHelper();
$value = $mysqlHelperObj->queryValue($sql, "autoreply");
if ($value != "") {
$autoreply = $value;
} else {
//d_setsubscribe($fromuser);
//$mysqlHelperObj = new mysqlHelper();
$sql = "update users set subscribe='1' where user = '******'";
$mysqlHelperObj->execute($sql);
//if($mysqlHelperObj->execute($sql) == false) {
$ptime = time();
$sql = "insert into users (user, ptime)values('{$fromuser}', FROM_UNIXTIME({$ptime}) )";
$mysqlHelperObj->execute($sql);
//}
}
return $autoreply;
}
function secret_getflag($fromuser)
{
$sql = "select secret_flag from users where user = '******'";
$mysqlHelperObj = new mysqlHelper();
$value = $mysqlHelperObj->queryValue($sql, "secret_flag");
if ($value != "") {
return $value;
} else {
d_insertuser($fromuser);
}
return 0;
}
