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