Completed
Push — master ( 5162b8...eb339d )
by mains
02:44
created
php/jodel-web.php 1 patch
Spacing   +38 added lines, -38 removed lines patch added patch discarded remove patch
@@ -21,9 +21,9 @@  discard block
 block discarded – undo
21 21
 function isDeviceUidInDatabase($deviceUid)
22 22
 {
23 23
 	$db = new DatabaseConnect();  
24
-	$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid  . "'");
24
+	$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'");
25 25
 
26
-	if ($result->num_rows > 0)
26
+	if($result->num_rows > 0)
27 27
 	{
28 28
 		return TRUE;
29 29
 	}
@@ -40,7 +40,7 @@  discard block
 block discarded – undo
40 40
 	
41 41
 	$access_token;
42 42
 
43
-	if ($result->num_rows > 0)
43
+	if($result->num_rows > 0)
44 44
 	{
45 45
 			// output data of each row
46 46
 			while($row = $result->fetch_assoc()) {
@@ -57,7 +57,7 @@  discard block
 block discarded – undo
57 57
 
58 58
 	if($expiration_date <= time()) {
59 59
 		$accountCreator = new CreateUser();
60
-		$accountCreator->setAccessToken($access_token);//$accountData->getAccessToken());
60
+		$accountCreator->setAccessToken($access_token); //$accountData->getAccessToken());
61 61
 		$accountCreator->setDeviceUid($deviceUid);
62 62
 		$accountCreator->setLocation($location);
63 63
 		$data = $accountCreator->execute();
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 									expiration_date='" . $expiration_date . "'
73 73
 								WHERE device_uid='" . $device_uid . "'");
74 74
 
75
-		if($result === false){
75
+		if($result === false) {
76 76
 				echo "Adding account failed: (" . $db->errno . ") " . $db->error;
77 77
 		}	
78 78
 	}
@@ -85,7 +85,7 @@  discard block
 block discarded – undo
85 85
 	$db = new DatabaseConnect();  
86 86
 	$result = $db->query("SELECT * FROM accounts WHERE access_token='" . $accessToken . "'");
87 87
 	
88
-	if ($result->num_rows > 0)
88
+	if($result->num_rows > 0)
89 89
 	{
90 90
 			// output data of each row
91 91
 			while($row = $result->fetch_assoc()) {
@@ -102,7 +102,7 @@  discard block
 block discarded – undo
102 102
 
103 103
 	if($expiration_date <= time()) {
104 104
 		$accountCreator = new CreateUser();
105
-		$accountCreator->setAccessToken($access_token);//$accountData->getAccessToken());
105
+		$accountCreator->setAccessToken($access_token); //$accountData->getAccessToken());
106 106
 		$accountCreator->setDeviceUid($deviceUid);
107 107
 		$accountCreator->setLocation($location);
108 108
 		$data = $accountCreator->execute();
@@ -117,7 +117,7 @@  discard block
 block discarded – undo
117 117
 									expiration_date='" . $expiration_date . "'
118 118
 								WHERE device_uid='" . $device_uid . "'");
119 119
 
120
-		if($result === false){
120
+		if($result === false) {
121 121
 				echo "Adding account failed: (" . $db->errno . ") " . $db->error;
122 122
 		}	
123 123
 	}
@@ -132,7 +132,7 @@  discard block
 block discarded – undo
132 132
 
133 133
 	$access_token;
134 134
 
135
-	if ($result->num_rows > 0)
135
+	if($result->num_rows > 0)
136 136
 	{
137 137
 			// output data of each row
138 138
 			while($row = $result->fetch_assoc()) {
@@ -164,7 +164,7 @@  discard block
 block discarded – undo
164 164
 									expiration_date='" . $expiration_date . "'
165 165
 								WHERE device_uid='" . $device_uid . "'");
166 166
 
167
-		if($result === false){
167
+		if($result === false) {
168 168
 				echo "Adding account failed: (" . $db->errno . ") " . $db->error;
169 169
 		}	
170 170
 	}
@@ -175,11 +175,11 @@  discard block
 block discarded – undo
175 175
 function getLocationByAccessToken($accessToken)
176 176
 {
177 177
 	$db = new DatabaseConnect();
178
-	$result = $db->query("SELECT * FROM accounts WHERE access_token='" . $accessToken  . "'");
178
+	$result = $db->query("SELECT * FROM accounts WHERE access_token='" . $accessToken . "'");
179 179
 	
180 180
 	$location = new Location();
181 181
 	
182
-	if ($result->num_rows > 0)
182
+	if($result->num_rows > 0)
183 183
 	{
184 184
 		// output data of each row
185 185
 		while($row = $result->fetch_assoc())
@@ -200,11 +200,11 @@  discard block
 block discarded – undo
200 200
 function getLocationByDeviceUid($deviceUid)
201 201
 {
202 202
 	$db = new DatabaseConnect();
203
-	$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid  . "'");
203
+	$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'");
204 204
 	
205 205
 	$location = new Location();
206 206
 	
207
-	if ($result->num_rows > 0)
207
+	if($result->num_rows > 0)
208 208
 	{
209 209
 		// output data of each row
210 210
 		while($row = $result->fetch_assoc())
@@ -225,11 +225,11 @@  discard block
 block discarded – undo
225 225
 function getDeviceUidByAccessToken($accesstoken)
226 226
 {
227 227
 	$db = new DatabaseConnect();
228
-	$result = $db->query("SELECT device_uid FROM accounts WHERE access_token='" . $accesstoken  . "'");
228
+	$result = $db->query("SELECT device_uid FROM accounts WHERE access_token='" . $accesstoken . "'");
229 229
 	
230 230
 	$deviceUid;
231 231
 	
232
-	if ($result->num_rows > 0)
232
+	if($result->num_rows > 0)
233 233
 	{
234 234
 		// output data of each row
235 235
 		while($row = $result->fetch_assoc())
@@ -248,11 +248,11 @@  discard block
 block discarded – undo
248 248
 function getAccessTokenByDeviceUid($deviceUid)
249 249
 {
250 250
 	$db = new DatabaseConnect();
251
-	$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid  . "'");
251
+	$result = $db->query("SELECT * FROM accounts WHERE device_uid='" . $deviceUid . "'");
252 252
 	
253 253
 	$accessToken;
254 254
 	
255
-	if ($result->num_rows > 0)
255
+	if($result->num_rows > 0)
256 256
 	{
257 257
 		// output data of each row
258 258
 		while($row = $result->fetch_assoc())
@@ -313,7 +313,7 @@  discard block
 block discarded – undo
313 313
 	$result = $db->query("INSERT INTO votes (device_uid, postId)
314 314
 					VALUES ('" . $device_uid . "','" . $postId . "') ");
315 315
 	
316
-	if($result === false){
316
+	if($result === false) {
317 317
 			$error = db_error();
318 318
 			echo $error;
319 319
 			echo "Adding Vote failed: (" . $result->errno . ") " . $result->error;
@@ -342,11 +342,11 @@  discard block
 block discarded – undo
342 342
 	$result = $db->query("INSERT INTO accounts (access_token, refresh_token, token_type,
343 343
 					expires_in, expiration_date, distinct_id, device_uid, name, lat, lng)
344 344
 					VALUES ('" . $access_token . "','" . $refresh_token . "','" . $token_type .
345
-					"','" .  $expires_in . "','" . $expiration_date . "','" . $distinct_id .
345
+					"','" . $expires_in . "','" . $expiration_date . "','" . $distinct_id .
346 346
 					"','" . $device_uid . "','" . $name . "','" . $lat . "','" . $lng . "') ");
347 347
 
348 348
 	$success = TRUE;
349
-	if($result === false){
349
+	if($result === false) {
350 350
 			$error = db_error();
351 351
 			echo $error;
352 352
 			echo "Adding account failed: (" . $result->errno . ") " . $result->error;
@@ -392,7 +392,7 @@  discard block
 block discarded – undo
392 392
 {
393 393
 	preg_match('/bot|spider|google|twitter/i', $_SERVER['HTTP_USER_AGENT'], $matches);
394 394
 
395
-    return (isset($matches[0])) ? true : false;
395
+    return (isset($matches[0]))?true : false;
396 396
 }
397 397
 
398 398
 function botDeviceUidIsSet($config)
@@ -423,25 +423,25 @@  discard block
 block discarded – undo
423 423
 	$timediff_inDays = (string)$timediff->format('%d');
424 424
 	$timediff_inMonth = (string)$timediff->format('%m');
425 425
 
426
-	if($timediff_inMonth!=0)
426
+	if($timediff_inMonth != 0)
427 427
 	{
428 428
 			$timediff = $timediff_inMonth . "m";
429 429
 	}
430 430
 	else
431 431
 	{
432
-		if($timediff_inDays!=0)
432
+		if($timediff_inDays != 0)
433 433
 		{
434 434
 			$timediff = $timediff_inDays . "d";
435 435
 		}
436 436
 		else
437 437
 		{
438
-			if($timediff_inHours!=0)
438
+			if($timediff_inHours != 0)
439 439
 			{
440 440
 				$timediff = $timediff_inHours . "h";
441 441
 			}
442 442
 			else
443 443
 			{
444
-				if($timediff_inMinutes!=0)
444
+				if($timediff_inMinutes != 0)
445 445
 				{
446 446
 					$timediff = $timediff_inMinutes . "m";
447 447
 				}
@@ -455,7 +455,7 @@  discard block
 block discarded – undo
455 455
 
456 456
 
457 457
 	?>
458
-	<article id ="postId-<?php echo $post["post_id"]; ?>" class="jodel" style="background-color: #<?php echo $post["color"];?>;">
458
+	<article id ="postId-<?php echo $post["post_id"]; ?>" class="jodel" style="background-color: #<?php echo $post["color"]; ?>;">
459 459
 		<content>
460 460
 			<?php 
461 461
 			if(isset($post["image_url"])) {
@@ -470,24 +470,24 @@  discard block
 block discarded – undo
470 470
 			<?php
471 471
 				if($isDetailedView)
472 472
 				{?>
473
-					<a href="index.php?vote=up&getPostDetails=true&postID=<?php echo $post['post_id'];?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']);?>">
473
+					<a href="index.php?vote=up&getPostDetails=true&postID=<?php echo $post['post_id']; ?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']); ?>">
474 474
 		  <?php }
475 475
 				else
476 476
 				{?>
477
-					<a href="index.php?vote=up&postID=<?php echo $post['post_id'];?>">
477
+					<a href="index.php?vote=up&postID=<?php echo $post['post_id']; ?>">
478 478
 		  <?php } ?>
479 479
 						<i class="fa fa-angle-up fa-3x"></i>
480 480
 					</a>	
481 481
 						<br />
482
-					<?php echo $post["vote_count"];?><br />
482
+					<?php echo $post["vote_count"]; ?><br />
483 483
 			<?php
484 484
 				if($isDetailedView)
485 485
 				{?>
486
-					<a href="index.php?vote=down&getPostDetails=true&postID=<?php echo $post['post_id'];?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']);?>">
486
+					<a href="index.php?vote=down&getPostDetails=true&postID=<?php echo $post['post_id']; ?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']); ?>">
487 487
 		  <?php }
488 488
 				else
489 489
 				{?>
490
-					<a href="index.php?vote=down&postID=<?php echo $post['post_id'];?>">
490
+					<a href="index.php?vote=down&postID=<?php echo $post['post_id']; ?>">
491 491
 		  <?php } ?>
492 492
 						<i class="fa fa-angle-down fa-3x"></i>
493 493
 					</a>
@@ -499,14 +499,14 @@  discard block
 block discarded – undo
499 499
 					<td class="time">
500 500
 						<span class="tip" data-tooltip="Time">
501 501
 							<i class="fa fa-clock-o"></i>
502
-							<?php echo $timediff;?>
503
-							<span class="tiptext"><?php echo $d->format('Y-m-d H:i:s');?></span>
502
+							<?php echo $timediff; ?>
503
+							<span class="tiptext"><?php echo $d->format('Y-m-d H:i:s'); ?></span>
504 504
 						</span> 
505 505
 					</td>
506 506
 					<td class="comments">
507 507
 						<?php if(!$isDetailedView) {?>
508 508
 						<span data-tooltip="Comments">
509
-							<a href="index.php?getPostDetails=true&view=<?php echo $view;?>&postID=<?php echo $post["post_id"];?>">
509
+							<a href="index.php?getPostDetails=true&view=<?php echo $view; ?>&postID=<?php echo $post["post_id"]; ?>">
510 510
 								<i class="fa fa-commenting-o"></i>
511 511
 								<?php if(array_key_exists("child_count", $post)) {
512 512
 											echo $post["child_count"];
@@ -535,7 +535,7 @@  discard block
 block discarded – undo
535 535
 									{
536 536
 							  			?>
537 537
 							  			<span data-tooltip="Author">
538
-											<i class="fa fa-user-o"></i> #<?php echo $post["user_handle"];?> |
538
+											<i class="fa fa-user-o"></i> #<?php echo $post["user_handle"]; ?> |
539 539
 										</span>
540 540
 										<?php
541 541
 									}
@@ -545,8 +545,8 @@  discard block
 block discarded – undo
545 545
 
546 546
 						<span class="tip" data-tooltip="Distance">
547 547
 							<i class="fa fa-map-marker"></i>
548
-							<?php echo $post['distance'];?> km
549
-							<span class="tiptext"><?php echo $post['location']['name'];?></span>
548
+							<?php echo $post['distance']; ?> km
549
+							<span class="tiptext"><?php echo $post['location']['name']; ?></span>
550 550
 						</span>
551 551
 					</td>
552 552
 				</tr>
Please login to merge, or discard this patch.