Completed
Push — master ( 65e7b8...2d8c2c )
by mains
02:58
created
php/JodelAccount.php 4 patches
Indentation   +456 added lines, -456 removed lines patch added patch discarded remove patch
@@ -2,505 +2,505 @@
 block discarded – undo
2 2
 
3 3
 class JodelAccount
4 4
 {
5
-    public $accessToken;
6
-    public $expirationDate;
7
-    public $refreshToken;
8
-    public $distinctId;
9
-    public $deviceUid;
10
-
11
-    //is the Account a Bot or Spider?
12
-    public $isBot;
5
+	public $accessToken;
6
+	public $expirationDate;
7
+	public $refreshToken;
8
+	public $distinctId;
9
+	public $deviceUid;
10
+
11
+	//is the Account a Bot or Spider?
12
+	public $isBot;
13 13
     
14
-    // array of voted Jodels
15
-    public $votes;
16
-
17
-    //Location of the Account
18
-    public $location;
19
-
20
-    function __construct($deviceUid = NULL, $isBot = FALSE)
21
-    {
22
-        if($deviceUid == NULL)
23
-        {
24
-            $this->deviceUid = $this->createAccount();
25
-        }
26
-        else
27
-        {
28
-            $this->deviceUid = $deviceUid;
29
-        }
30
-
31
-        $this->isBot        = $isBot;
32
-        $this->location     = $this->getLocation();
33
-
34
-        if(!$this->isTokenFresh())
35
-        {
36
-            $this->refreshToken();
37
-        }
38
-        $this->accessToken  = $this->getAccessToken();
39
-    }
40
-
41
-    function isAccountVerified()
42
-    {
43
-        $accountCreator = new GetUserConfig();
44
-        $accountCreator->setAccessToken($this->accessToken);
45
-        $data = $accountCreator->execute();
46
-
47
-        return $data['verified'];
48
-    }
49
-
50
-    function locationEquals($city)
51
-    {
52
-        $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($city) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w';
53
-        $result = Requests::post($url);
54
-        if(json_decode($result->body, true)['status'] == 'ZERO_RESULTS' || json_decode($result->body, true)['status'] == 'INVALID_REQUEST')
55
-        {
56
-            error_log('Error locationEquals');
57
-            return FALSE;
58
-        }
59
-        else
60
-        {
61
-            $name = json_decode($result->body, true)['results']['0']['address_components']['0']['long_name'];
62
-            $lat = json_decode($result->body, true)['results']['0']['geometry']['location']['lat'];
63
-            $lng = json_decode($result->body, true)['results']['0']['geometry']['location']['lng'];
64
-        }
65
-
66
-        $db = new DatabaseConnect();
67
-        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
14
+	// array of voted Jodels
15
+	public $votes;
16
+
17
+	//Location of the Account
18
+	public $location;
19
+
20
+	function __construct($deviceUid = NULL, $isBot = FALSE)
21
+	{
22
+		if($deviceUid == NULL)
23
+		{
24
+			$this->deviceUid = $this->createAccount();
25
+		}
26
+		else
27
+		{
28
+			$this->deviceUid = $deviceUid;
29
+		}
30
+
31
+		$this->isBot        = $isBot;
32
+		$this->location     = $this->getLocation();
33
+
34
+		if(!$this->isTokenFresh())
35
+		{
36
+			$this->refreshToken();
37
+		}
38
+		$this->accessToken  = $this->getAccessToken();
39
+	}
40
+
41
+	function isAccountVerified()
42
+	{
43
+		$accountCreator = new GetUserConfig();
44
+		$accountCreator->setAccessToken($this->accessToken);
45
+		$data = $accountCreator->execute();
46
+
47
+		return $data['verified'];
48
+	}
49
+
50
+	function locationEquals($city)
51
+	{
52
+		$url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($city) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w';
53
+		$result = Requests::post($url);
54
+		if(json_decode($result->body, true)['status'] == 'ZERO_RESULTS' || json_decode($result->body, true)['status'] == 'INVALID_REQUEST')
55
+		{
56
+			error_log('Error locationEquals');
57
+			return FALSE;
58
+		}
59
+		else
60
+		{
61
+			$name = json_decode($result->body, true)['results']['0']['address_components']['0']['long_name'];
62
+			$lat = json_decode($result->body, true)['results']['0']['geometry']['location']['lat'];
63
+			$lng = json_decode($result->body, true)['results']['0']['geometry']['location']['lng'];
64
+		}
65
+
66
+		$db = new DatabaseConnect();
67
+		$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
68 68
         
69
-        $location = new Location();
69
+		$location = new Location();
70 70
         
71
-        if ($result->num_rows > 0)
72
-        {
73
-            // output data of each row
74
-            while($row = $result->fetch_assoc())
75
-            {
76
-                $location->setLat($row['lat']);
77
-                $location->setLng($row['lng']);
78
-                $location->setCityName($row['name']);
79
-            }
80
-        }
81
-        else
82
-        {
83
-            error_log("Error no Location found - getLocation");
84
-        }
85
-
86
-        if($location->getLat() == $lat && $location->getLng() == $lng && $location->getCityName() == $name)
87
-        {
88
-            return TRUE;
89
-        }  
90
-        else
91
-        {
92
-            return FALSE;
93
-        }
94
-    }
95
-
96
-    function setLocation()
97
-    {
98
-        //Is Channel or City
99
-        if(substr($_GET['city'], 0, 1) === '#')
100
-        {
101
-            return htmlspecialchars($_GET['city']) . " " . $this->location->cityName;
102
-        }                
103
-        else
104
-        {
105
-            $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($_GET['city']) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w';
106
-            $result = Requests::post($url);
107
-            if(json_decode($result->body, true)['status'] == 'ZERO_RESULTS' || json_decode($result->body, true)['status'] == 'INVALID_REQUEST')
108
-            {
109
-                return "0 results";
110
-            }
111
-            else
112
-            {
113
-                $name = json_decode($result->body, true)['results']['0']['address_components']['0']['long_name'];
114
-                $lat = json_decode($result->body, true)['results']['0']['geometry']['location']['lat'];
115
-                $lng = json_decode($result->body, true)['results']['0']['geometry']['location']['lng'];
116
-
117
-                $location = new Location();
118
-                $location->setLat($lat);
119
-                $location->setLng($lng);
120
-                $location->setCityName($name);
121
-                $accountCreator = new UpdateLocation();
122
-                $accountCreator->setLocation($location);
123
-                $accountCreator->setAccessToken($this->accessToken);
124
-                $data = $accountCreator->execute();
125
-
126
-                //safe location to db
127
-                $db = new DatabaseConnect();
128
-
129
-                if($data == 'Success')
130
-                {
131
-                    $result = $db->query("UPDATE accounts 
71
+		if ($result->num_rows > 0)
72
+		{
73
+			// output data of each row
74
+			while($row = $result->fetch_assoc())
75
+			{
76
+				$location->setLat($row['lat']);
77
+				$location->setLng($row['lng']);
78
+				$location->setCityName($row['name']);
79
+			}
80
+		}
81
+		else
82
+		{
83
+			error_log("Error no Location found - getLocation");
84
+		}
85
+
86
+		if($location->getLat() == $lat && $location->getLng() == $lng && $location->getCityName() == $name)
87
+		{
88
+			return TRUE;
89
+		}  
90
+		else
91
+		{
92
+			return FALSE;
93
+		}
94
+	}
95
+
96
+	function setLocation()
97
+	{
98
+		//Is Channel or City
99
+		if(substr($_GET['city'], 0, 1) === '#')
100
+		{
101
+			return htmlspecialchars($_GET['city']) . " " . $this->location->cityName;
102
+		}                
103
+		else
104
+		{
105
+			$url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($_GET['city']) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w';
106
+			$result = Requests::post($url);
107
+			if(json_decode($result->body, true)['status'] == 'ZERO_RESULTS' || json_decode($result->body, true)['status'] == 'INVALID_REQUEST')
108
+			{
109
+				return "0 results";
110
+			}
111
+			else
112
+			{
113
+				$name = json_decode($result->body, true)['results']['0']['address_components']['0']['long_name'];
114
+				$lat = json_decode($result->body, true)['results']['0']['geometry']['location']['lat'];
115
+				$lng = json_decode($result->body, true)['results']['0']['geometry']['location']['lng'];
116
+
117
+				$location = new Location();
118
+				$location->setLat($lat);
119
+				$location->setLng($lng);
120
+				$location->setCityName($name);
121
+				$accountCreator = new UpdateLocation();
122
+				$accountCreator->setLocation($location);
123
+				$accountCreator->setAccessToken($this->accessToken);
124
+				$data = $accountCreator->execute();
125
+
126
+				//safe location to db
127
+				$db = new DatabaseConnect();
128
+
129
+				if($data == 'Success')
130
+				{
131
+					$result = $db->query("UPDATE accounts 
132 132
                             SET name='" . $name . "',
133 133
                                 lat='" . $lat . "',
134 134
                                 lng='" . $lng . "'
135 135
                             WHERE access_token='" . $this->accessToken . "'");
136 136
 
137
-                    if($result === false)
138
-                    {
139
-                            echo "Updating location failed: (" . $db->errno . ") " . $db->error;
140
-                    }
141
-                    else
142
-                    {
143
-                        user_log('User with JodelDeviceId:' . $this->deviceUid .  ' [' . $_SERVER['REMOTE_ADDR'] . '][' . $_SERVER ['HTTP_USER_AGENT'] . '] changed to Location: ' . $name);
144
-                    }
145
-                }
146
-
147
-                return $name;
148
-            }
149
-        }
150
-    }
151
-
152
-    function getLocation()
153
-    {
154
-        $db = new DatabaseConnect();
155
-        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
137
+					if($result === false)
138
+					{
139
+							echo "Updating location failed: (" . $db->errno . ") " . $db->error;
140
+					}
141
+					else
142
+					{
143
+						user_log('User with JodelDeviceId:' . $this->deviceUid .  ' [' . $_SERVER['REMOTE_ADDR'] . '][' . $_SERVER ['HTTP_USER_AGENT'] . '] changed to Location: ' . $name);
144
+					}
145
+				}
146
+
147
+				return $name;
148
+			}
149
+		}
150
+	}
151
+
152
+	function getLocation()
153
+	{
154
+		$db = new DatabaseConnect();
155
+		$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
156 156
         
157
-        $location = new Location();
157
+		$location = new Location();
158 158
         
159
-        if ($result->num_rows > 0)
160
-        {
161
-            // output data of each row
162
-            while($row = $result->fetch_assoc())
163
-            {
164
-                $location->setLat($row['lat']);
165
-                $location->setLng($row['lng']);
166
-                $location->setCityName($row['name']);
167
-            }
168
-        }
169
-        else
170
-        {
171
-            echo "Error: 0 results";
172
-            error_log("Error no Location found - getLocation");
173
-        }
174
-
175
-        return $location;
176
-    }
177
-
178
-    function verifyCaptcha()
179
-    {
180
-        if(isset($_GET['deviceUid']))
181
-        {
182
-            $deviceUid = $_GET['deviceUid'];
183
-        }
184
-        if(isset($_POST['deviceUid']))
185
-        {
186
-            $deviceUid = $_POST['deviceUid'];
187
-        }
188
-        $jodelAccountForVerify = new JodelAccount($deviceUid);
189
-
190
-        $solution = $_GET['solution'];
191
-        $solution = array_map('intval', explode('-', $solution));
192
-
193
-        $accountCreator = new PostCaptcha();
194
-        $accountCreator->setAccessToken($jodelAccountForVerify->accessToken);
195
-        $accountCreator->captchaKey = $_GET['key'];
196
-        $accountCreator->captchaSolution = $solution;
197
-        $verified = $accountCreator->execute();
198
-
199
-        if(isset($verified->status_code))
200
-        {
201
-            return $verified->status_code;
202
-        }
203
-        return $verified['verified'];
204
-    }
205
-
206
-    //ToDo Spider Check
207
-    function votePostId($postId, $vote)
208
-    {
209
-        if(!$this->isBot)
210
-        {
211
-            if(!$this->isAccountVerified())
212
-            {
213
-                $view = new View();
214
-                $view->showCaptcha($this->accessToken, $this->deviceUid);
215
-            }
216
-
217
-            if(!$this->hasVoted($postId))
218
-            {
219
-                if($vote == "up")
220
-                {
221
-                    $accountCreator = new Upvote();
222
-                }
223
-                else if($vote == "down")
224
-                {
225
-                    $accountCreator = new Downvote();
226
-                }
227
-
228
-                $accountCreator->setAccessToken($this->accessToken);
229
-                $accountCreator->postId = htmlspecialchars($postId);
230
-                $data = $accountCreator->execute();
231
-
232
-                if(array_key_exists('post', $data))
233
-                {
234
-                    $this->addVoteWithPostIdAndType($postId, $vote);
235
-                    return TRUE;
236
-                }
237
-                else if(array_key_exists('error', $data))
238
-                {
239
-                    error_log('Could not vote - Error: ' . $data['error']);
240
-                }
241
-                else
242
-                {
243
-                    error_log('Could not vote - Error: ' . $data['status_code']);
244
-                    error_log('Could not vote: ' . print_r($data, true));
245
-                    return FALSE;
246
-                } 
247
-            }
248
-            else
249
-            {
250
-                return FALSE;
251
-            }
252
-        }
253
-
254
-        return FALSE;
255
-    }
256
-
257
-    //ToDo Spider Check
258
-    function sendJodel($location, $view)
259
-    {
260
-        if(!$this->isAccountVerified())
261
-        {
262
-            showCaptcha($this->accessToken);
263
-        }
264
-
265
-        $accountCreator = new SendJodel();
266
-
267
-        if(isset($_POST['ancestor']))
268
-        {
269
-            $ancestor = $_POST['ancestor'];
270
-            $accountCreator->ancestor = $ancestor;
271
-        }
272
-        if(isset($_POST['color']))
273
-        {
274
-            $color = $_POST['color'];
275
-            switch ($color) {
276
-                case '8ABDB0':
277
-                    $color = '8ABDB0';
278
-                    break;
279
-                case '9EC41C':
280
-                    $color = '9EC41C';
281
-                    break;
282
-                case '06A3CB':
283
-                    $color = '06A3CB';
284
-                    break;
285
-                case 'FFBA00':
286
-                    $color = 'FFBA00';
287
-                    break;
288
-                case 'DD5F5F':
289
-                    $color = 'DD5F5F';
290
-                    break;
291
-                case 'FF9908':
292
-                    $color = 'FF9908';
293
-                    break;
294
-                default:
295
-                    $color = '8ABDB0';
296
-                    break;
297
-            }
298
-            $accountCreator->color = $color;
299
-        }
300
-
301
-        $accountCreatorLocation = new UpdateLocation();
302
-        $accountCreatorLocation->setLocation($location);
303
-        $accountCreatorLocation->setAccessToken($this->accessToken);
304
-        $data = $accountCreatorLocation->execute();
159
+		if ($result->num_rows > 0)
160
+		{
161
+			// output data of each row
162
+			while($row = $result->fetch_assoc())
163
+			{
164
+				$location->setLat($row['lat']);
165
+				$location->setLng($row['lng']);
166
+				$location->setCityName($row['name']);
167
+			}
168
+		}
169
+		else
170
+		{
171
+			echo "Error: 0 results";
172
+			error_log("Error no Location found - getLocation");
173
+		}
174
+
175
+		return $location;
176
+	}
177
+
178
+	function verifyCaptcha()
179
+	{
180
+		if(isset($_GET['deviceUid']))
181
+		{
182
+			$deviceUid = $_GET['deviceUid'];
183
+		}
184
+		if(isset($_POST['deviceUid']))
185
+		{
186
+			$deviceUid = $_POST['deviceUid'];
187
+		}
188
+		$jodelAccountForVerify = new JodelAccount($deviceUid);
189
+
190
+		$solution = $_GET['solution'];
191
+		$solution = array_map('intval', explode('-', $solution));
192
+
193
+		$accountCreator = new PostCaptcha();
194
+		$accountCreator->setAccessToken($jodelAccountForVerify->accessToken);
195
+		$accountCreator->captchaKey = $_GET['key'];
196
+		$accountCreator->captchaSolution = $solution;
197
+		$verified = $accountCreator->execute();
198
+
199
+		if(isset($verified->status_code))
200
+		{
201
+			return $verified->status_code;
202
+		}
203
+		return $verified['verified'];
204
+	}
205
+
206
+	//ToDo Spider Check
207
+	function votePostId($postId, $vote)
208
+	{
209
+		if(!$this->isBot)
210
+		{
211
+			if(!$this->isAccountVerified())
212
+			{
213
+				$view = new View();
214
+				$view->showCaptcha($this->accessToken, $this->deviceUid);
215
+			}
216
+
217
+			if(!$this->hasVoted($postId))
218
+			{
219
+				if($vote == "up")
220
+				{
221
+					$accountCreator = new Upvote();
222
+				}
223
+				else if($vote == "down")
224
+				{
225
+					$accountCreator = new Downvote();
226
+				}
227
+
228
+				$accountCreator->setAccessToken($this->accessToken);
229
+				$accountCreator->postId = htmlspecialchars($postId);
230
+				$data = $accountCreator->execute();
231
+
232
+				if(array_key_exists('post', $data))
233
+				{
234
+					$this->addVoteWithPostIdAndType($postId, $vote);
235
+					return TRUE;
236
+				}
237
+				else if(array_key_exists('error', $data))
238
+				{
239
+					error_log('Could not vote - Error: ' . $data['error']);
240
+				}
241
+				else
242
+				{
243
+					error_log('Could not vote - Error: ' . $data['status_code']);
244
+					error_log('Could not vote: ' . print_r($data, true));
245
+					return FALSE;
246
+				} 
247
+			}
248
+			else
249
+			{
250
+				return FALSE;
251
+			}
252
+		}
253
+
254
+		return FALSE;
255
+	}
256
+
257
+	//ToDo Spider Check
258
+	function sendJodel($location, $view)
259
+	{
260
+		if(!$this->isAccountVerified())
261
+		{
262
+			showCaptcha($this->accessToken);
263
+		}
264
+
265
+		$accountCreator = new SendJodel();
266
+
267
+		if(isset($_POST['ancestor']))
268
+		{
269
+			$ancestor = $_POST['ancestor'];
270
+			$accountCreator->ancestor = $ancestor;
271
+		}
272
+		if(isset($_POST['color']))
273
+		{
274
+			$color = $_POST['color'];
275
+			switch ($color) {
276
+				case '8ABDB0':
277
+					$color = '8ABDB0';
278
+					break;
279
+				case '9EC41C':
280
+					$color = '9EC41C';
281
+					break;
282
+				case '06A3CB':
283
+					$color = '06A3CB';
284
+					break;
285
+				case 'FFBA00':
286
+					$color = 'FFBA00';
287
+					break;
288
+				case 'DD5F5F':
289
+					$color = 'DD5F5F';
290
+					break;
291
+				case 'FF9908':
292
+					$color = 'FF9908';
293
+					break;
294
+				default:
295
+					$color = '8ABDB0';
296
+					break;
297
+			}
298
+			$accountCreator->color = $color;
299
+		}
300
+
301
+		$accountCreatorLocation = new UpdateLocation();
302
+		$accountCreatorLocation->setLocation($location);
303
+		$accountCreatorLocation->setAccessToken($this->accessToken);
304
+		$data = $accountCreatorLocation->execute();
305 305
         
306 306
 		if($data != 'Success')
307 307
 		{
308 308
 			error_log(print_r($data, true));
309 309
 		}
310 310
 
311
-        $accountCreator->location = $this->location;
311
+		$accountCreator->location = $this->location;
312 312
         
313
-        $accountCreator->setAccessToken($this->accessToken);
314
-        $data = $accountCreator->execute();
315
-
316
-        if(isset($_POST['ancestor']))
317
-        {
318
-            header('Location: ' . $view->toUrl());
319
-            exit;
320
-        }
321
-        else
322
-        {
323
-            header('Location: ' . $view->baseUrl);
324
-            exit;
325
-        }
326
-    }
327
-
328
-    function isTokenFresh()
329
-    {
330
-        $db = new DatabaseConnect();  
331
-        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid . "'");
332
-
333
-        if ($result->num_rows > 0)
334
-        {
335
-            // output data of each row
336
-            while($row = $result->fetch_assoc())
337
-            {
338
-                    $expiration_date = $row["expiration_date"];
339
-            }
340
-        }
341
-        else
342
-        {
343
-            error_log('0 results');
344
-        }
345
-
346
-        if($expiration_date <= time())
347
-        {
348
-           return FALSE;
349
-        }
313
+		$accountCreator->setAccessToken($this->accessToken);
314
+		$data = $accountCreator->execute();
315
+
316
+		if(isset($_POST['ancestor']))
317
+		{
318
+			header('Location: ' . $view->toUrl());
319
+			exit;
320
+		}
321
+		else
322
+		{
323
+			header('Location: ' . $view->baseUrl);
324
+			exit;
325
+		}
326
+	}
327
+
328
+	function isTokenFresh()
329
+	{
330
+		$db = new DatabaseConnect();  
331
+		$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid . "'");
332
+
333
+		if ($result->num_rows > 0)
334
+		{
335
+			// output data of each row
336
+			while($row = $result->fetch_assoc())
337
+			{
338
+					$expiration_date = $row["expiration_date"];
339
+			}
340
+		}
341
+		else
342
+		{
343
+			error_log('0 results');
344
+		}
345
+
346
+		if($expiration_date <= time())
347
+		{
348
+		   return FALSE;
349
+		}
350 350
         
351
-        return TRUE;
352
-    }
353
-
354
-    function refreshToken()
355
-    {
356
-        $accountCreator = new CreateUser();
357
-        $accountCreator->setAccessToken($this->accessToken);
358
-        $accountCreator->setDeviceUid($this->deviceUid);
359
-        $accountCreator->setLocation($this->location);
360
-        $data = $accountCreator->execute();
361
-
362
-        $access_token = (string)$data[0]['access_token'];
363
-        $expiration_date = $data[0]['expiration_date'];
364
-        $device_uid = (string)$data[1];
351
+		return TRUE;
352
+	}
353
+
354
+	function refreshToken()
355
+	{
356
+		$accountCreator = new CreateUser();
357
+		$accountCreator->setAccessToken($this->accessToken);
358
+		$accountCreator->setDeviceUid($this->deviceUid);
359
+		$accountCreator->setLocation($this->location);
360
+		$data = $accountCreator->execute();
361
+
362
+		$access_token = (string)$data[0]['access_token'];
363
+		$expiration_date = $data[0]['expiration_date'];
364
+		$device_uid = (string)$data[1];
365 365
         
366
-        $db = new DatabaseConnect();  
367
-        $result = $db->query("UPDATE accounts 
366
+		$db = new DatabaseConnect();  
367
+		$result = $db->query("UPDATE accounts 
368 368
                                 SET access_token='" . $access_token . "',
369 369
                                     expiration_date='" . $expiration_date . "'
370 370
                                 WHERE device_uid='" . $device_uid . "'");
371 371
 
372
-        if($result === false){
373
-                error_log("Adding account failed: (" . $db->errno . ") " . $db->error);
374
-        }   
375
-    }
372
+		if($result === false){
373
+				error_log("Adding account failed: (" . $db->errno . ") " . $db->error);
374
+		}   
375
+	}
376 376
 
377 377
 
378 378
 
379
-    function getAccessToken()
380
-    {
381
-        $db = new DatabaseConnect();
382
-        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
379
+	function getAccessToken()
380
+	{
381
+		$db = new DatabaseConnect();
382
+		$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
383 383
         
384
-        $accessToken;
384
+		$accessToken;
385 385
         
386
-        if ($result->num_rows > 0)
387
-        {
388
-            // output data of each row
389
-            while($row = $result->fetch_assoc())
390
-            {
391
-                $accessToken = $row['access_token'];
392
-            }
393
-        }
394
-        else
395
-        {
396
-            error_log('Error: 0 results');
397
-        }
398
-
399
-        return $accessToken;
400
-    }
401
-
402
-
403
-    function getKarma()
404
-    {
405
-        $accountCreator = new GetKarma();
406
-        $accountCreator->setAccessToken($this->accessToken);
407
-        $data = $accountCreator->execute();
386
+		if ($result->num_rows > 0)
387
+		{
388
+			// output data of each row
389
+			while($row = $result->fetch_assoc())
390
+			{
391
+				$accessToken = $row['access_token'];
392
+			}
393
+		}
394
+		else
395
+		{
396
+			error_log('Error: 0 results');
397
+		}
398
+
399
+		return $accessToken;
400
+	}
401
+
402
+
403
+	function getKarma()
404
+	{
405
+		$accountCreator = new GetKarma();
406
+		$accountCreator->setAccessToken($this->accessToken);
407
+		$data = $accountCreator->execute();
408 408
         
409
-        return $data['karma'];
410
-    }
409
+		return $data['karma'];
410
+	}
411 411
 
412
-    function hasVoted($postId)
413
-    {
414
-        $db = new DatabaseConnect();
412
+	function hasVoted($postId)
413
+	{
414
+		$db = new DatabaseConnect();
415 415
 
416
-        $postId = $db->real_escape_string($postId);
416
+		$postId = $db->real_escape_string($postId);
417 417
 
418
-        $result = $db->query("SELECT id FROM votes WHERE (postId = '" . $postId . "' AND device_uid = '" . $this->deviceUid . "')");
418
+		$result = $db->query("SELECT id FROM votes WHERE (postId = '" . $postId . "' AND device_uid = '" . $this->deviceUid . "')");
419 419
         
420
-        if($result === false)
421
-        {
422
-            $error = db_error();
423
-            echo $error;
424
-            error_log("Adding Vote failed: (" . $result->errno . ") " . $result->error);
425
-        }
426
-
427
-        if($result->num_rows == 0)
428
-        {
429
-            return FALSE;
430
-        }
431
-        else
432
-        {
433
-            return TRUE;
434
-        }
435
-    }
436
-
437
-    function addVoteWithPostIdAndType($postId, $voteType)
438
-    {
439
-        $db = new DatabaseConnect();  
440
-
441
-        $postId = $db->real_escape_string($postId);
442
-        $voteType = $db->real_escape_string($voteType);
420
+		if($result === false)
421
+		{
422
+			$error = db_error();
423
+			echo $error;
424
+			error_log("Adding Vote failed: (" . $result->errno . ") " . $result->error);
425
+		}
426
+
427
+		if($result->num_rows == 0)
428
+		{
429
+			return FALSE;
430
+		}
431
+		else
432
+		{
433
+			return TRUE;
434
+		}
435
+	}
436
+
437
+	function addVoteWithPostIdAndType($postId, $voteType)
438
+	{
439
+		$db = new DatabaseConnect();  
440
+
441
+		$postId = $db->real_escape_string($postId);
442
+		$voteType = $db->real_escape_string($voteType);
443 443
         
444
-        if($this->hasVoted($postId))
445
-        {
446
-            return "Already voted";
447
-        }
444
+		if($this->hasVoted($postId))
445
+		{
446
+			return "Already voted";
447
+		}
448 448
 
449
-        $result = $db->query("INSERT INTO votes (device_uid, postId, type)
449
+		$result = $db->query("INSERT INTO votes (device_uid, postId, type)
450 450
                         VALUES ('" . $this->deviceUid . "','" . $postId . "','" . $voteType . "')");
451 451
         
452
-        if($result === false){
453
-                $error = db_error();
454
-                echo $error;
455
-                echo "Adding Vote failed: (" . $result->errno . ") " . $result->error;
456
-        }       
457
-    }
458
-
459
-    function registerAccount($location) {
460
-        $accountCreator = new CreateUser();
461
-        $accountCreator->setLocation($location);
462
-        $data = $accountCreator->execute();
452
+		if($result === false){
453
+				$error = db_error();
454
+				echo $error;
455
+				echo "Adding Vote failed: (" . $result->errno . ") " . $result->error;
456
+		}       
457
+	}
458
+
459
+	function registerAccount($location) {
460
+		$accountCreator = new CreateUser();
461
+		$accountCreator->setLocation($location);
462
+		$data = $accountCreator->execute();
463 463
         
464
-        $access_token = (string)$data[0]['access_token'];
465
-        $refresh_token = (string)$data[0]['refresh_token'];
466
-        $token_type = (string)$data[0]['token_type'];
467
-        $expires_in = $data[0]['expires_in'];
468
-        $expiration_date = $data[0]['expiration_date'];
469
-        $distinct_id = (string)$data[0]['distinct_id'];
470
-        $device_uid = (string)$data[1];
471
-
472
-        $name = $location->cityName;
473
-        $lat = $location->lat;
474
-        $lng = $location->lng;
464
+		$access_token = (string)$data[0]['access_token'];
465
+		$refresh_token = (string)$data[0]['refresh_token'];
466
+		$token_type = (string)$data[0]['token_type'];
467
+		$expires_in = $data[0]['expires_in'];
468
+		$expiration_date = $data[0]['expiration_date'];
469
+		$distinct_id = (string)$data[0]['distinct_id'];
470
+		$device_uid = (string)$data[1];
471
+
472
+		$name = $location->cityName;
473
+		$lat = $location->lat;
474
+		$lng = $location->lng;
475 475
         
476
-        $db = new DatabaseConnect();  
477
-        $result = $db->query("INSERT INTO accounts (access_token, refresh_token, token_type,
476
+		$db = new DatabaseConnect();  
477
+		$result = $db->query("INSERT INTO accounts (access_token, refresh_token, token_type,
478 478
                         expires_in, expiration_date, distinct_id, device_uid, name, lat, lng)
479 479
                         VALUES ('" . $access_token . "','" . $refresh_token . "','" . $token_type .
480
-                        "','" .  $expires_in . "','" . $expiration_date . "','" . $distinct_id .
481
-                        "','" . $device_uid . "','" . $name . "','" . $lat . "','" . $lng . "') ");
482
-
483
-        $success = TRUE;
484
-        if($result === false){
485
-                $error = $db->error();
486
-                echo $error;
487
-                echo "Adding account failed: (" . $result->errno . ") " . $result->error;
488
-                $success = FALSE;
489
-        }   
480
+						"','" .  $expires_in . "','" . $expiration_date . "','" . $distinct_id .
481
+						"','" . $device_uid . "','" . $name . "','" . $lat . "','" . $lng . "') ");
482
+
483
+		$success = TRUE;
484
+		if($result === false){
485
+				$error = $db->error();
486
+				echo $error;
487
+				echo "Adding account failed: (" . $result->errno . ") " . $result->error;
488
+				$success = FALSE;
489
+		}   
490 490
         
491
-        return $device_uid;
492
-    }
491
+		return $device_uid;
492
+	}
493 493
 
494
-    function createAccount()
495
-    {
496
-        $config = parse_ini_file('config/config.ini.php');
497
-        $location = new Location();
498
-        $location->setLat($config['default_lat']);
499
-        $location->setLng($config['default_lng']);
500
-        $location->setCityName($config['default_location']);
494
+	function createAccount()
495
+	{
496
+		$config = parse_ini_file('config/config.ini.php');
497
+		$location = new Location();
498
+		$location->setLat($config['default_lat']);
499
+		$location->setLng($config['default_lng']);
500
+		$location->setCityName($config['default_location']);
501 501
 
502
-        $deviceUid = $this->registerAccount($location);
502
+		$deviceUid = $this->registerAccount($location);
503 503
 
504
-        return $deviceUid;
505
-    }
504
+		return $deviceUid;
505
+	}
506 506
 }
507 507
\ No newline at end of file
Please login to merge, or discard this patch.
Spacing   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -35,7 +35,7 @@  discard block
 block discarded – undo
35 35
         {
36 36
             $this->refreshToken();
37 37
         }
38
-        $this->accessToken  = $this->getAccessToken();
38
+        $this->accessToken = $this->getAccessToken();
39 39
     }
40 40
 
41 41
     function isAccountVerified()
@@ -64,11 +64,11 @@  discard block
 block discarded – undo
64 64
         }
65 65
 
66 66
         $db = new DatabaseConnect();
67
-        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
67
+        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid . "'");
68 68
         
69 69
         $location = new Location();
70 70
         
71
-        if ($result->num_rows > 0)
71
+        if($result->num_rows > 0)
72 72
         {
73 73
             // output data of each row
74 74
             while($row = $result->fetch_assoc())
@@ -140,7 +140,7 @@  discard block
 block discarded – undo
140 140
                     }
141 141
                     else
142 142
                     {
143
-                        user_log('User with JodelDeviceId:' . $this->deviceUid .  ' [' . $_SERVER['REMOTE_ADDR'] . '][' . $_SERVER ['HTTP_USER_AGENT'] . '] changed to Location: ' . $name);
143
+                        user_log('User with JodelDeviceId:' . $this->deviceUid . ' [' . $_SERVER['REMOTE_ADDR'] . '][' . $_SERVER ['HTTP_USER_AGENT'] . '] changed to Location: ' . $name);
144 144
                     }
145 145
                 }
146 146
 
@@ -152,11 +152,11 @@  discard block
 block discarded – undo
152 152
     function getLocation()
153 153
     {
154 154
         $db = new DatabaseConnect();
155
-        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
155
+        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid . "'");
156 156
         
157 157
         $location = new Location();
158 158
         
159
-        if ($result->num_rows > 0)
159
+        if($result->num_rows > 0)
160 160
         {
161 161
             // output data of each row
162 162
             while($row = $result->fetch_assoc())
@@ -272,7 +272,7 @@  discard block
 block discarded – undo
272 272
         if(isset($_POST['color']))
273 273
         {
274 274
             $color = $_POST['color'];
275
-            switch ($color) {
275
+            switch($color) {
276 276
                 case '8ABDB0':
277 277
                     $color = '8ABDB0';
278 278
                     break;
@@ -330,7 +330,7 @@  discard block
 block discarded – undo
330 330
         $db = new DatabaseConnect();  
331 331
         $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid . "'");
332 332
 
333
-        if ($result->num_rows > 0)
333
+        if($result->num_rows > 0)
334 334
         {
335 335
             // output data of each row
336 336
             while($row = $result->fetch_assoc())
@@ -369,7 +369,7 @@  discard block
 block discarded – undo
369 369
                                     expiration_date='" . $expiration_date . "'
370 370
                                 WHERE device_uid='" . $device_uid . "'");
371 371
 
372
-        if($result === false){
372
+        if($result === false) {
373 373
                 error_log("Adding account failed: (" . $db->errno . ") " . $db->error);
374 374
         }   
375 375
     }
@@ -379,11 +379,11 @@  discard block
 block discarded – undo
379 379
     function getAccessToken()
380 380
     {
381 381
         $db = new DatabaseConnect();
382
-        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid  . "'");
382
+        $result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $this->deviceUid . "'");
383 383
         
384 384
         $accessToken;
385 385
         
386
-        if ($result->num_rows > 0)
386
+        if($result->num_rows > 0)
387 387
         {
388 388
             // output data of each row
389 389
             while($row = $result->fetch_assoc())
@@ -449,7 +449,7 @@  discard block
 block discarded – undo
449 449
         $result = $db->query("INSERT INTO votes (device_uid, postId, type)
450 450
                         VALUES ('" . $this->deviceUid . "','" . $postId . "','" . $voteType . "')");
451 451
         
452
-        if($result === false){
452
+        if($result === false) {
453 453
                 $error = db_error();
454 454
                 echo $error;
455 455
                 echo "Adding Vote failed: (" . $result->errno . ") " . $result->error;
@@ -477,11 +477,11 @@  discard block
 block discarded – undo
477 477
         $result = $db->query("INSERT INTO accounts (access_token, refresh_token, token_type,
478 478
                         expires_in, expiration_date, distinct_id, device_uid, name, lat, lng)
479 479
                         VALUES ('" . $access_token . "','" . $refresh_token . "','" . $token_type .
480
-                        "','" .  $expires_in . "','" . $expiration_date . "','" . $distinct_id .
480
+                        "','" . $expires_in . "','" . $expiration_date . "','" . $distinct_id .
481 481
                         "','" . $device_uid . "','" . $name . "','" . $lat . "','" . $lng . "') ");
482 482
 
483 483
         $success = TRUE;
484
-        if($result === false){
484
+        if($result === false) {
485 485
                 $error = $db->error();
486 486
                 echo $error;
487 487
                 echo "Adding account failed: (" . $result->errno . ") " . $result->error;
Please login to merge, or discard this patch.
Braces   +12 added lines, -7 removed lines patch added patch discarded remove patch
@@ -86,7 +86,7 @@  discard block
 block discarded – undo
86 86
         if($location->getLat() == $lat && $location->getLng() == $lng && $location->getCityName() == $name)
87 87
         {
88 88
             return TRUE;
89
-        }  
89
+        }
90 90
         else
91 91
         {
92 92
             return FALSE;
@@ -99,7 +99,7 @@  discard block
 block discarded – undo
99 99
         if(substr($_GET['city'], 0, 1) === '#')
100 100
         {
101 101
             return htmlspecialchars($_GET['city']) . " " . $this->location->cityName;
102
-        }                
102
+        }
103 103
         else
104 104
         {
105 105
             $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($_GET['city']) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w';
@@ -272,7 +272,8 @@  discard block
 block discarded – undo
272 272
         if(isset($_POST['color']))
273 273
         {
274 274
             $color = $_POST['color'];
275
-            switch ($color) {
275
+            switch ($color)
276
+            {
276 277
                 case '8ABDB0':
277 278
                     $color = '8ABDB0';
278 279
                     break;
@@ -369,7 +370,8 @@  discard block
 block discarded – undo
369 370
                                     expiration_date='" . $expiration_date . "'
370 371
                                 WHERE device_uid='" . $device_uid . "'");
371 372
 
372
-        if($result === false){
373
+        if($result === false)
374
+        {
373 375
                 error_log("Adding account failed: (" . $db->errno . ") " . $db->error);
374 376
         }   
375 377
     }
@@ -449,14 +451,16 @@  discard block
 block discarded – undo
449 451
         $result = $db->query("INSERT INTO votes (device_uid, postId, type)
450 452
                         VALUES ('" . $this->deviceUid . "','" . $postId . "','" . $voteType . "')");
451 453
         
452
-        if($result === false){
454
+        if($result === false)
455
+        {
453 456
                 $error = db_error();
454 457
                 echo $error;
455 458
                 echo "Adding Vote failed: (" . $result->errno . ") " . $result->error;
456 459
         }       
457 460
     }
458 461
 
459
-    function registerAccount($location) {
462
+    function registerAccount($location)
463
+    {
460 464
         $accountCreator = new CreateUser();
461 465
         $accountCreator->setLocation($location);
462 466
         $data = $accountCreator->execute();
@@ -481,7 +485,8 @@  discard block
 block discarded – undo
481 485
                         "','" . $device_uid . "','" . $name . "','" . $lat . "','" . $lng . "') ");
482 486
 
483 487
         $success = TRUE;
484
-        if($result === false){
488
+        if($result === false)
489
+        {
485 490
                 $error = $db->error();
486 491
                 echo $error;
487 492
                 echo "Adding account failed: (" . $result->errno . ") " . $result->error;
Please login to merge, or discard this patch.
Upper-Lower-Casing   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -51,16 +51,16 @@  discard block
 block discarded – undo
51 51
     {
52 52
         $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($city) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w';
53 53
         $result = Requests::post($url);
54
-        if(json_decode($result->body, true)['status'] == 'ZERO_RESULTS' || json_decode($result->body, true)['status'] == 'INVALID_REQUEST')
54
+        if(json_decode($result->body, TRUE)['status'] == 'ZERO_RESULTS' || json_decode($result->body, TRUE)['status'] == 'INVALID_REQUEST')
55 55
         {
56 56
             error_log('Error locationEquals');
57 57
             return FALSE;
58 58
         }
59 59
         else
60 60
         {
61
-            $name = json_decode($result->body, true)['results']['0']['address_components']['0']['long_name'];
62
-            $lat = json_decode($result->body, true)['results']['0']['geometry']['location']['lat'];
63
-            $lng = json_decode($result->body, true)['results']['0']['geometry']['location']['lng'];
61
+            $name = json_decode($result->body, TRUE)['results']['0']['address_components']['0']['long_name'];
62
+            $lat = json_decode($result->body, TRUE)['results']['0']['geometry']['location']['lat'];
63
+            $lng = json_decode($result->body, TRUE)['results']['0']['geometry']['location']['lng'];
64 64
         }
65 65
 
66 66
         $db = new DatabaseConnect();
@@ -104,15 +104,15 @@  discard block
 block discarded – undo
104 104
         {
105 105
             $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($_GET['city']) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w';
106 106
             $result = Requests::post($url);
107
-            if(json_decode($result->body, true)['status'] == 'ZERO_RESULTS' || json_decode($result->body, true)['status'] == 'INVALID_REQUEST')
107
+            if(json_decode($result->body, TRUE)['status'] == 'ZERO_RESULTS' || json_decode($result->body, TRUE)['status'] == 'INVALID_REQUEST')
108 108
             {
109 109
                 return "0 results";
110 110
             }
111 111
             else
112 112
             {
113
-                $name = json_decode($result->body, true)['results']['0']['address_components']['0']['long_name'];
114
-                $lat = json_decode($result->body, true)['results']['0']['geometry']['location']['lat'];
115
-                $lng = json_decode($result->body, true)['results']['0']['geometry']['location']['lng'];
113
+                $name = json_decode($result->body, TRUE)['results']['0']['address_components']['0']['long_name'];
114
+                $lat = json_decode($result->body, TRUE)['results']['0']['geometry']['location']['lat'];
115
+                $lng = json_decode($result->body, TRUE)['results']['0']['geometry']['location']['lng'];
116 116
 
117 117
                 $location = new Location();
118 118
                 $location->setLat($lat);
@@ -134,7 +134,7 @@  discard block
 block discarded – undo
134 134
                                 lng='" . $lng . "'
135 135
                             WHERE access_token='" . $this->accessToken . "'");
136 136
 
137
-                    if($result === false)
137
+                    if($result === FALSE)
138 138
                     {
139 139
                             echo "Updating location failed: (" . $db->errno . ") " . $db->error;
140 140
                     }
@@ -241,7 +241,7 @@  discard block
 block discarded – undo
241 241
                 else
242 242
                 {
243 243
                     error_log('Could not vote - Error: ' . $data['status_code']);
244
-                    error_log('Could not vote: ' . print_r($data, true));
244
+                    error_log('Could not vote: ' . print_r($data, TRUE));
245 245
                     return FALSE;
246 246
                 } 
247 247
             }
@@ -305,7 +305,7 @@  discard block
 block discarded – undo
305 305
         
306 306
 		if($data != 'Success')
307 307
 		{
308
-			error_log(print_r($data, true));
308
+			error_log(print_r($data, TRUE));
309 309
 		}
310 310
 
311 311
         $accountCreator->location = $this->location;
@@ -369,7 +369,7 @@  discard block
 block discarded – undo
369 369
                                     expiration_date='" . $expiration_date . "'
370 370
                                 WHERE device_uid='" . $device_uid . "'");
371 371
 
372
-        if($result === false){
372
+        if($result === FALSE){
373 373
                 error_log("Adding account failed: (" . $db->errno . ") " . $db->error);
374 374
         }   
375 375
     }
@@ -417,7 +417,7 @@  discard block
 block discarded – undo
417 417
 
418 418
         $result = $db->query("SELECT id FROM votes WHERE (postId = '" . $postId . "' AND device_uid = '" . $this->deviceUid . "')");
419 419
         
420
-        if($result === false)
420
+        if($result === FALSE)
421 421
         {
422 422
             $error = db_error();
423 423
             echo $error;
@@ -449,7 +449,7 @@  discard block
 block discarded – undo
449 449
         $result = $db->query("INSERT INTO votes (device_uid, postId, type)
450 450
                         VALUES ('" . $this->deviceUid . "','" . $postId . "','" . $voteType . "')");
451 451
         
452
-        if($result === false){
452
+        if($result === FALSE){
453 453
                 $error = db_error();
454 454
                 echo $error;
455 455
                 echo "Adding Vote failed: (" . $result->errno . ") " . $result->error;
@@ -481,7 +481,7 @@  discard block
 block discarded – undo
481 481
                         "','" . $device_uid . "','" . $name . "','" . $lat . "','" . $lng . "') ");
482 482
 
483 483
         $success = TRUE;
484
-        if($result === false){
484
+        if($result === FALSE){
485 485
                 $error = $db->error();
486 486
                 echo $error;
487 487
                 echo "Adding account failed: (" . $result->errno . ") " . $result->error;
Please login to merge, or discard this patch.