Exemplo n.º 1
0
            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');
}
Exemplo n.º 2
0
    $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;
                }
Exemplo n.º 3
0
$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;