| @@ 425-446 (lines=22) @@ | ||
| 422 | return $location; |
|
| 423 | } |
|
| 424 | ||
| 425 | function getDeviceUidByAccessToken($accesstoken) |
|
| 426 | { |
|
| 427 | $db = new DatabaseConnect(); |
|
| 428 | $result = $db->query("SELECT device_uid FROM accounts WHERE access_token='" . $accesstoken . "'"); |
|
| 429 | ||
| 430 | $deviceUid; |
|
| 431 | ||
| 432 | if ($result->num_rows > 0) |
|
| 433 | { |
|
| 434 | // output data of each row |
|
| 435 | while($row = $result->fetch_assoc()) |
|
| 436 | { |
|
| 437 | $deviceUid = $row['device_uid']; |
|
| 438 | } |
|
| 439 | } |
|
| 440 | else |
|
| 441 | { |
|
| 442 | echo "Error: 0 results"; |
|
| 443 | } |
|
| 444 | ||
| 445 | return $deviceUid; |
|
| 446 | } |
|
| 447 | ||
| 448 | function getAccessTokenByDeviceUid($deviceUid) |
|
| 449 | { |
|
| @@ 448-469 (lines=22) @@ | ||
| 445 | return $deviceUid; |
|
| 446 | } |
|
| 447 | ||
| 448 | function getAccessTokenByDeviceUid($deviceUid) |
|
| 449 | { |
|
| 450 | $db = new DatabaseConnect(); |
|
| 451 | $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'"); |
|
| 452 | ||
| 453 | $accessToken; |
|
| 454 | ||
| 455 | if ($result->num_rows > 0) |
|
| 456 | { |
|
| 457 | // output data of each row |
|
| 458 | while($row = $result->fetch_assoc()) |
|
| 459 | { |
|
| 460 | $accessToken = $row['access_token']; |
|
| 461 | } |
|
| 462 | } |
|
| 463 | else |
|
| 464 | { |
|
| 465 | echo "Error: 0 results"; |
|
| 466 | } |
|
| 467 | ||
| 468 | return $accessToken; |
|
| 469 | } |
|
| 470 | ||
| 471 | ||
| 472 | function getKarma($accessToken) |
|