function getUserInfo($id)
{
$link = chat_db();
$sql = mysql_query('SELECT `id`,`nickname`,`url` FROM `users` WHERE `id` = "' . $id . '"');
$tmp['id'] = mysql_result($sql, 0, 'id');
$tmp['name'] = mysql_result($sql, 0, 'nickname');
$tmp['url'] = mysql_result($sql, 0, 'url');
$tmp['img'] = getUserPic(mysql_result($sql, 0, 'id'));
return $tmp;
}
function getSqlData($arr, $data)
{
global $colNames;
$newData = array();
foreach ($arr as $table => $col) {
foreach ($col as $id) {
$val = $colNames[$table][$id];
if ($val == "pic") {
$newData[$val] = getUserPic($data[$val]);
} else {
if ($val == "itemImageSrc") {
$newData[$val] = getItemPic($data[$val]);
} else {
$newData[$val] = $data[$val];
}
}
}
}
return $newData;
}
function getUserInformation($itemId)
{
if (!($itemId > 0)) {
return -1;
}
$data = array();
$query = "SELECT `users`.`uid`, `users`.`fname`, `users`.`pic` FROM `item`, `users` WHERE `item`.`iid`={$itemId} AND `item`.`uid` = `users`.`uid`;";
if ($result = mysql_query($query)) {
while ($res = mysql_fetch_array($result)) {
$data["pic"] = getUserPic($res["pic"]);
$data["userId"] = $res["uid"];
$data["fname"] = $res["fname"];
return $data;
}
}
return $data;
}
function getUsersByLocation($longitude, $latitude, $diff = 2)
{
$lowLon = $longitude - $diff;
$higLon = $longitude + $diff;
$lowLat = $latitude - $diff;
$higLat = $latitude + $diff;
if ($lowLat < -90) {
$temp = $lowLat;
$lowLat = $higLat;
$higLat = $temp + 180;
}
if ($lowLon < -180) {
$temp = $lowLon;
$lowLon = $higLon;
$higLon = $temp + 360;
}
if ($higLat > 90) {
$temp = $higLat;
$higLat = $lowLat;
$lowLat = $temp - 180;
}
if ($higLon > 180) {
$temp = $higLon;
$higLon = $lowLon;
$lowLon = $temp - 360;
}
$colsArray = array("item" => array(1, 4), "address" => array(3, 4, 5), "users" => array(1, 2, 4, 5, 6));
$colStr = getSqlColumns($colsArray);
//`users`.`uid`, `users`.`pic`, `users`.`uname`, `item`.`itemImageSrc`
$query = "SELECT {$colStr} FROM `item`, `address`, `users` WHERE (`address`.`latitude` > {$lowLat} AND `address`.`latitude` < {$higLat}) AND (`address`.`longitude` > {$lowLon} AND `address`.`longitude` < {$higLon}) AND `item`.`aid` = `address`.`aid` AND `item`.`uid` = `users`.`uid`";
// Long way to go over here...
if ($result = mysql_query($query)) {
while ($ret = mysql_fetch_array($result)) {
$uname = $ret["uname"];
if (!isset($this->users[$uname])) {
$this->users[$uname] = array("pic" => getUserPic($ret["pic"]), "fname" => $ret["fname"], "gender" => $ret["gender"], "uid" => $ret["uid"], "uname" => $ret["uname"], "owningItems" => array());
}
$this->users[$uname]["owningItems"][] = array("itemImageSrc" => getItemPic($ret["itemImageSrc"]), "itemId" => $ret["iid"]);
}
}
return $this->users;
}
function getMessagesBefore($uid, $hash, $ruid, $limit, $before)
{
if (!checkCookies($uid, $hash)) {
return 3;
}
if (!($ruid > 0)) {
return 4;
}
if (!$this->hasUser($ruid)) {
return 5;
}
$beforeData = "AND `message`.`mid` < {$before} ";
if (!($before > 0)) {
$beforeData = "";
}
if (!($limit > 0)) {
return 6;
}
$query = "SELECT `users`.`fname` as `rfname`, `users`.`pic` as `rpic`, `last`.`sfname`, `last`.`spic`,`last`.`message`, `last`.`messageCreated`, `last`.`suid`, `last`.`mid`, `last`.`ruid` FROM (SELECT `users`.`fname` as `sfname`, `users`.`pic` as `spic`, `message`.`message`, `message`.`mid`, `message`.`messageCreated`, `message`.`suid`, `message`.`ruid` FROM `message`, `users` WHERE `users`.`uid` = `message`.`suid` {$beforeData}) AS `last`, `users` WHERE `users`.`uid`=`last`.`ruid` ORDER BY `last`.`messageCreated` ASC LIMIT {$limit};";
$messages = array();
if ($result = mysql_query($query)) {
while ($res = mysql_fetch_array($result)) {
$messages[$res["mid"]] = array("mid" => $res["mid"], "suid" => $res["suid"], "ruid" => $res["ruid"], "message" => $res["message"], "messageCreated" => $res["messageCreated"], "rfname" => $res["rfname"], "sfname" => $res["sfname"], "rpic" => getUserPic($res["rpic"]), "spic" => getUserPic($res["spic"]));
}
return $messages;
}
return 2;
}
if (isset($_SESSION['name'])) {
$name = $_SESSION['name'];
$longitude = $_POST['longitude'];
$latitude = $_POST['latitude'];
$res = setUserPos($longitude, $latitude);
}
break;
case 'getUserPic':
if (isset($_SESSION['name'])) {
$name = $_SESSION['name'];
$longMin = floatval($_POST['longMin']);
$longMax = floatval($_POST['longMax']);
$latMin = floatval($_POST['latMin']);
$latMax = floatval($_POST['latMax']);
$num = intval($_POST['num']);
$res = getUserPic($name, $num, $longMin, $longMax, $latMin, $latMax);
echo $res;
} else {
echo "";
}
break;
case 'getAllPic':
$longMin = floatval($_POST['longMin']);
$longMax = floatval($_POST['longMax']);
$latMin = floatval($_POST['latMin']);
$latMax = floatval($_POST['latMax']);
$num = intval($_POST['num']);
$res = getAllPic($num, $longMin, $longMax, $latMin, $latMax);
echo $res;
break;
default:
