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