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: