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