function updateLocation($id, $ip) { if ($id) { $user = new User($id); if (!$user->hasLocation()) { $file = simplexml_load_file('http://api.ipinfodb.com/v2/ip_query.php?key=ca24e42293944a1bff78a2e8833baefb68fa34e2cb997c0becc7aaf4208a7706&ip=' . $ip); $db = Database::Obtain(); $data['latitude'] = $file->Latitude; $data['longitude'] = $file->Longitude; $where = 'id = ' . $db->escape($id); $db->update('users', $data, $where); } } }