| @@ 225-246 (lines=22) @@ | ||
| 222 | return $location; |
|
| 223 | } |
|
| 224 | ||
| 225 | function getDeviceUidByAccessToken($accesstoken) |
|
| 226 | { |
|
| 227 | $db = new DatabaseConnect(); |
|
| 228 | $result = $db->query("SELECT device_uid FROM accounts WHERE access_token='" . $accesstoken . "'"); |
|
| 229 | ||
| 230 | $deviceUid; |
|
| 231 | ||
| 232 | if ($result->num_rows > 0) |
|
| 233 | { |
|
| 234 | // output data of each row |
|
| 235 | while($row = $result->fetch_assoc()) |
|
| 236 | { |
|
| 237 | $deviceUid = $row['device_uid']; |
|
| 238 | } |
|
| 239 | } |
|
| 240 | else |
|
| 241 | { |
|
| 242 | echo "Error: 0 results"; |
|
| 243 | } |
|
| 244 | ||
| 245 | return $deviceUid; |
|
| 246 | } |
|
| 247 | ||
| 248 | function getAccessTokenByDeviceUid($deviceUid) |
|
| 249 | { |
|
| @@ 248-269 (lines=22) @@ | ||
| 245 | return $deviceUid; |
|
| 246 | } |
|
| 247 | ||
| 248 | function getAccessTokenByDeviceUid($deviceUid) |
|
| 249 | { |
|
| 250 | $db = new DatabaseConnect(); |
|
| 251 | $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'"); |
|
| 252 | ||
| 253 | $accessToken; |
|
| 254 | ||
| 255 | if ($result->num_rows > 0) |
|
| 256 | { |
|
| 257 | // output data of each row |
|
| 258 | while($row = $result->fetch_assoc()) |
|
| 259 | { |
|
| 260 | $accessToken = $row['access_token']; |
|
| 261 | } |
|
| 262 | } |
|
| 263 | else |
|
| 264 | { |
|
| 265 | echo "Error: 0 results"; |
|
| 266 | } |
|
| 267 | ||
| 268 | return $accessToken; |
|
| 269 | } |
|
| 270 | ||
| 271 | ||
| 272 | function getKarma($accessToken) |
|