function write($varname, $value)
{
if (!$this->valid_session()) {
return false;
}
$sql = "SELECT id FROM " . $this->session_vars_table . " WHERE name='" . $varname . "' AND session='" . $this->getSessionID() . "'";
$rez = Mysql::query_array($sql);
if (!isset($rez[0])) {
$rez = Mysql::query("INSERT INTO " . $this->session_vars_table . " \r\n\t\t \t\t\t(name,session,value) VALUES\r\n\t\t \t\t\t('" . $varname . "', '" . $this->getSessionID() . "', '" . $value . "')");
} else {
$mas["value"] = $value;
// $ids["session"] = $this->session;
$ids["name"] = $varname;
$sql = "UPDATE " . $this->session_vars_table . " SET `value` = '" . $value . "' WHERE name='" . $varname . "' AND session='" . $this->getSessionID() . "'";
Mysql::query($sql);
}
$GLOBALS[$varname] = $value;
$this->variables[$varname] = $value;
$this->s_touch();
}
* Time: 下午5:17
*/
include '../Visitor.php';
$userId = getUserId();
$mysql = new Mysql();
if (isset($_POST['from'])) {
$from = $_POST['from'];
} else {
$from = 0;
}
if (isset($_POST['size'])) {
$size = $_POST['size'];
} else {
$size = 30;
}
$waiting = "";
if (isset($_POST['waiting']) && $_POST['waiting']) {
$sendTime = time() - 10 * 60;
$waiting = " and timestamp>{$sendTime} ";
}
$sql = "SELECT *,ft.id as footprintId FROM footprint ft inner join foot f WHERE ft.footId=f.id and ft.userId={$userId} order by timestamp desc limit {$from},{$size}";
if (isset($sendTime)) {
$sql = "SELECT *,ft.id as footprintId FROM footprint ft inner join foot f WHERE ft.footId=f.id and ft.userId={$userId} {$waiting}order by timestamp desc limit {$from},{$size}";
}
$foot_array = $mysql->query_array($sql);
foreach ($foot_array as $v) {
$footprint = new FootPrint($v);
$footPrints[] = $footprint;
}
$res = [ok => 1, data => $footPrints];
echo json_encode($res);
<?php
/**
* Created by PhpStorm.
* User: shaoting
* Date: 15/7/26
* Time: 下午9:57
*/
include "../Visitor.php";
$userId = getUserId();
$mysql = new Mysql();
$result = $mysql->select("*", "`user_regular`", "`user_id`", "{$userId}");
if ($result) {
//echo "SELECT * FROM user_regular u inner join regular r WHERE r.id=u.regular_id and u.user_id={$userId}";
$regular_array = $mysql->query_array("select * from (SELECT u.*,r.host,r.threshold FROM user_regular u inner join regular r WHERE r.id=u.regular_id and u.user_id={$userId} order by time desc ) a group by host");
} else {
//echo "select * from (SELECT *,count(r.id) count FROM user_regular u inner join regular r WHERE r.id=u.regular_id group by r.id)a limit 10";
//无规则时返回大家用的最多的规则
$regular_array = $mysql->query_array("select * from (SELECT u.*,r.host,r.threshold,count(r.id) count FROM user_regular u inner join regular r WHERE r.id=u.regular_id group by r.id)a group by host order by time desc limit 10");
}
foreach ($regular_array as $v) {
$regular = new Regular($v);
$regulars[] = $regular;
}
$res = [ok => 1, data => $regulars];
echo json_encode($res);
