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