mmainstreet /
jodel-web
| @@ 375-398 (lines=24) @@ | ||
| 372 | return $access_token; |
|
| 373 | } |
|
| 374 | ||
| 375 | function getLocationByAccessToken($accessToken) |
|
| 376 | { |
|
| 377 | $db = new DatabaseConnect(); |
|
| 378 | $result = $db->query("SELECT * FROM accounts WHERE access_token='" . $accessToken . "'"); |
|
| 379 | ||
| 380 | $location = new Location(); |
|
| 381 | ||
| 382 | if ($result->num_rows > 0) |
|
| 383 | { |
|
| 384 | // output data of each row |
|
| 385 | while($row = $result->fetch_assoc()) |
|
| 386 | { |
|
| 387 | $location->setLat($row['lat']); |
|
| 388 | $location->setLng($row['lng']); |
|
| 389 | $location->setCityName($row['name']); |
|
| 390 | } |
|
| 391 | } |
|
| 392 | else |
|
| 393 | { |
|
| 394 | echo "Error: 0 results"; |
|
| 395 | } |
|
| 396 | ||
| 397 | return $location; |
|
| 398 | } |
|
| 399 | ||
| 400 | function getLocationByDeviceUid($deviceUid) |
|
| 401 | { |
|
| @@ 400-423 (lines=24) @@ | ||
| 397 | return $location; |
|
| 398 | } |
|
| 399 | ||
| 400 | function getLocationByDeviceUid($deviceUid) |
|
| 401 | { |
|
| 402 | $db = new DatabaseConnect(); |
|
| 403 | $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'"); |
|
| 404 | ||
| 405 | $location = new Location(); |
|
| 406 | ||
| 407 | if ($result->num_rows > 0) |
|
| 408 | { |
|
| 409 | // output data of each row |
|
| 410 | while($row = $result->fetch_assoc()) |
|
| 411 | { |
|
| 412 | $location->setLat($row['lat']); |
|
| 413 | $location->setLng($row['lng']); |
|
| 414 | $location->setCityName($row['name']); |
|
| 415 | } |
|
| 416 | } |
|
| 417 | else |
|
| 418 | { |
|
| 419 | echo "Error: 0 results"; |
|
| 420 | } |
|
| 421 | ||
| 422 | return $location; |
|
| 423 | } |
|
| 424 | ||
| 425 | function getDeviceUidByAccessToken($accesstoken) |
|
| 426 | { |
|
