public function getTokenFromDataBase()
{
date_default_timezone_set('Asia/Shanghai');
$mysqlHelperObj = new mysqlHelper();
$sql = "select token, tokenTime from icoding order by id desc limit 1";
$rows = $mysqlHelperObj->queryValueArray($sql);
if ($rows == '') {
return '';
}
$token = $rows[0]['token'];
$tokenTime = $rows[0]['tokenTime'];
if (time() - $tokenTime < 7000) {
return $token;
}
return '';
}
function data_getjoke($fromuser)
{
// $query="SELECT content,id FROM jokes ORDER BY RAND() limit 1";
$query = "SELECT jokes.id as tid, content FROM jokes, users WHERE users.joke_flag <= jokes.id and users.user='******' order by jokes.id limit 1";
$mysqlHelperObj = new mysqlHelper();
$rows = $mysqlHelperObj->queryValueArray($sql);
if ($rows != "") {
$row = $rows[0];
$content = $row['content'];
$id = $row['tid'];
$sql = "update users set joke_flag ={$id}+1 where user='******'";
$mysqlHelperObj->execute($sql);
$sql = "update jokes set pcount = pcount+1 where id = '{$id}'";
$mysqlHelperObj->execute($sql);
return $content;
}
$sql = "select content,id from jokes where id >= (SELECT FLOOR(RAND() * (SELECT MAX(ID) FROM jokes))) order by id limit 1 ";
$rows = $mysqlHelperObj->queryValueArray($sql);
if ($rows != "") {
$row = $rows[0];
$content = $row['content'];
$id = $row['id'];
$sql = "update jokes set pcount = pcount+1 where id = '{$id}'";
$mysqlHelperObj->execute($sql);
return $content;
}
return "";
}
function d_getvalues_3($fromuser, $key, $key1, $key2)
{
$value = '';
$value1 = '';
$value2 = '';
$sql = "select {$key} , {$key1}, {$key2} from users where user = '******' ";
$mysqlHelperObj = new mysqlHelper();
$rows = $mysqlHelperObj->queryValueArray($sql);
if ($rows != "") {
$row = $rows[0];
$value = $row["{$key}"];
$value1 = $row["{$key1}"];
$value2 = $row["{$key2}"];
}
return array(stripslashes($value), stripslashes($value1), stripslashes($value2));
}
public function fromdb($name, $type)
{
$msg = '';
date_default_timezone_set('PRC');
if ($type == 'ymsg') {
$t = date('Y');
$sql = "SELECT {$type} as msg FROM astrological where name = '{$name}' and y ='{$t}'";
} else {
if ($type == 'mmsg') {
$t = date('n');
$sql = "SELECT {$type} as msg FROM astrological where name = '{$name}' and m ='{$t}'";
} else {
if ($type == 'wmsg') {
$z = date('z');
$t = date('w');
$sql = "SELECT {$type} as msg FROM astrological where name = '{$name}' and w < {$t} and wd < {$z} - 7";
} else {
if ($type == 'dmsg') {
$t = date('z');
$sql = "SELECT {$type} as msg FROM astrological where name = '{$name}' and d ='{$t}'";
}
}
}
}
$mysqlHelperObj = new mysqlHelper();
$rows = $mysqlHelperObj->queryValueArray($sql);
if ($rows != "") {
$row = $rows[0];
$msg = $row['msg'];
}
return $msg;
}
public function getCitypinyin($city)
{
$sql = "select pinyin from cityair where city='{$city}'";
$mysqlHelperObj = new mysqlHelper();
$rows = $mysqlHelperObj->queryValueArray($sql);
if ($rows != "") {
$row = $rows[0];
return $row['pinyin'];
}
return "";
}
function secret_wordsbyuser($touser)
{
//database connection
$contetstr = '';
$secretIndex = 0;
$sql = "select pcount, secretwords.id as sid, city, sex, touser, words,UNIX_TIMESTAMP(secretwords.ptime) as pptime from secretwords, users where touser like '%{$touser}%' and users.user= secretwords.user order by secretwords.id desc";
// $sql = "select city, touser, words, UNIX_TIMESTAMP(ptime) as ptime from secretwords where touser like '%$touser%' order by id desc limit 50";
$nn = 0;
date_default_timezone_set('PRC');
$mysqlHelperObj = new mysqlHelper();
$rows = $mysqlHelperObj->queryValueArray($sql);
if ($rows != "") {
$len = count($rows);
for ($i = 0; $i < $len; $i++) {
$row = $rows[$i];
$city = $row['city'];
$sex = $row['sex'];
$touser = $row['touser'];
$words = $row['words'];
$ptime = $row['pptime'];
$pcount = intval($row['pcount']) + 1;
array_push($idStack, $row['sid']);
if ($sex == '0') {
$sex = '某女生';
} else {
if ($sex == '1') {
$sex = '某男生';
} else {
$sex = '某人';
}
}
if (strlen($words) > 0) {
$nn = $nn + 1;
$contetstr .= "【第 {$nn} 条】\n";
$contetstr .= date('Y-m-d H:i', $ptime) . "\n";
$contetstr .= "{$city} {$sex} \n对 {$touser} 说：\n";
$contetstr .= "{$words} \n";
$contetstr .= "-------浏览次数({$pcount})\n";
}
}
$c = count($idStack);
for ($ii = 0; $ii < $c; $ii++) {
$sql = "update secretwords set pcount = pcount + 1 where id = '" . $idStack[$ii] . "'";
$mysqlHelperObj->execute($sql);
}
}
if (strlen($contetstr) == 0) {
$contetstr = "还没有发给 {$touser} 的告白哦~\n快叫{$touser} 的同学朋友也来关注我吧，兴许他们会对TA说出心里的告白哦~\n ";
}
return $contetstr . secret_ending();
}
