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