mmainstreet /
jodel-web
| @@ 175-198 (lines=24) @@ | ||
| 172 | return $access_token; |
|
| 173 | } |
|
| 174 | ||
| 175 | function getLocationByAccessToken($accessToken) |
|
| 176 | { |
|
| 177 | $db = new DatabaseConnect(); |
|
| 178 | $result = $db->query("SELECT * FROM accounts WHERE access_token='" . $accessToken . "'"); |
|
| 179 | ||
| 180 | $location = new Location(); |
|
| 181 | ||
| 182 | if ($result->num_rows > 0) |
|
| 183 | { |
|
| 184 | // output data of each row |
|
| 185 | while($row = $result->fetch_assoc()) |
|
| 186 | { |
|
| 187 | $location->setLat($row['lat']); |
|
| 188 | $location->setLng($row['lng']); |
|
| 189 | $location->setCityName($row['name']); |
|
| 190 | } |
|
| 191 | } |
|
| 192 | else |
|
| 193 | { |
|
| 194 | echo "Error: 0 results"; |
|
| 195 | } |
|
| 196 | ||
| 197 | return $location; |
|
| 198 | } |
|
| 199 | ||
| 200 | function getLocationByDeviceUid($deviceUid) |
|
| 201 | { |
|
| @@ 200-223 (lines=24) @@ | ||
| 197 | return $location; |
|
| 198 | } |
|
| 199 | ||
| 200 | function getLocationByDeviceUid($deviceUid) |
|
| 201 | { |
|
| 202 | $db = new DatabaseConnect(); |
|
| 203 | $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'"); |
|
| 204 | ||
| 205 | $location = new Location(); |
|
| 206 | ||
| 207 | if ($result->num_rows > 0) |
|
| 208 | { |
|
| 209 | // output data of each row |
|
| 210 | while($row = $result->fetch_assoc()) |
|
| 211 | { |
|
| 212 | $location->setLat($row['lat']); |
|
| 213 | $location->setLng($row['lng']); |
|
| 214 | $location->setCityName($row['name']); |
|
| 215 | } |
|
| 216 | } |
|
| 217 | else |
|
| 218 | { |
|
| 219 | echo "Error: 0 results"; |
|
| 220 | } |
|
| 221 | ||
| 222 | return $location; |
|
| 223 | } |
|
| 224 | ||
| 225 | function getDeviceUidByAccessToken($accesstoken) |
|
| 226 | { |
|
