if ($OCSServer != "NONE") { $connect->set('SmartQQRobotTalk1_' . $sourceunsql, $aim, 0); } } else { mysql_close($con); if ($flag1 == 1) { die('None3'); } else { die('None4'); } } } else { mysql_close($con); die('None1'); } } //从回复数据库中读取语句 $sql = "SELECT * FROM data WHERE no = '{$aimno}' limit 1"; $result = mysql_query($sql); $row = mysql_fetch_array($result); if ($row != "") { $response = _rowget('data', $row); if ($OCSServer != "NONE") { $connect->set('SmartQQRobotData1_' . $aimno, $response, 0); } mysql_close($con); die($response); } else { mysql_close($con); die('None2'); }
$sql = "SELECT * FROM data WHERE data = '{$aimsql}' limit 1"; $result = mysql_query($sql); $row = mysql_fetch_array($result); } $aimno = _rowget('no', $row); if ($OCSServer != "NONE") { $connect->set('SmartQQRobotData1_' . $aimno, _rowget('data', $row), 0); } //寻找是否存在原语句 $no = -1; $sql = "SELECT * FROM talk WHERE source = '{$sourcesql}' limit 1"; $result = mysql_query($sql); $row = mysql_fetch_array($result); if ($row != "") { $aim = _rowget('aim', $row); $no = _rowget('no', $row); $str = explode(",", $aim); $enable = explode(",", $row['enable']); for ($i = 0; $i < count($str); $i++) { if ($str[$i] == $aimno) { if ($enable[$i] == 1 || $enable[$i] == 3) { mysql_close($con); die('Already'); } else { if ($enable[$i] == 2) { mysql_close($con); die('Forbidden'); } else { $WaittingFlag = 1; $WaittingIndex = $i; }
$appid_six = substr($appid, 0, 6); $areaid = ''; $flag = 0; if ($OCSServer != "NONE") { $connect = new Memcache(); //声明一个新的memcached链接 $connect->addServer($OCSServer, 11211); //添加实例地址 端口号 $areaid = $connect->get('SmartQQRobotWeatherCityID_' . $_REQUEST[city]); } else { $flag = 1; } if ($areaid == '') { $sql = "SELECT * FROM weathercityid WHERE city = '" . mysql_real_escape_string($_REQUEST[city]) . "' limit 1"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $areaid = _rowget('id', $row); if ($areaid == '') { die("NoCity"); } if ($flag == 0) { $connect->set('SmartQQRobotWeatherCityID_' . $_REQUEST[city], $areaid, 0); } } $date = date("YmdHi"); $URLBase = "http://open.weather.com.cn/data/?areaid=" . $areaid . "&type=" . $_REQUEST[type] . "_v&date=" . $date . "&appid="; $public_key = $URLBase . $appid; $key = base64_encode(hash_hmac('sha1', $public_key, $private_key, TRUE)); $URL = $URLBase . $appid_six . "&key=" . urlencode($key); $result = file_get_contents($URL); echo $result;