Completed
Push — master ( 87612b...9237aa )
by mains
02:52
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())
@@ -320,7 +320,7 @@  discard block
 block discarded – undo
320 320
 	$result = $db->query("INSERT INTO votes (device_uid, postId, type)
321 321
 					VALUES ('" . $device_uid . "','" . $postId . "','" . $voteType . "')");
322 322
 	
323
-	if($result === false){
323
+	if($result === false) {
324 324
 			$error = db_error();
325 325
 			echo $error;
326 326
 			echo "Adding Vote failed: (" . $result->errno . ") " . $result->error;
@@ -348,11 +348,11 @@  discard block
 block discarded – undo
348 348
 	$result = $db->query("INSERT INTO accounts (access_token, refresh_token, token_type,
349 349
 					expires_in, expiration_date, distinct_id, device_uid, name, lat, lng)
350 350
 					VALUES ('" . $access_token . "','" . $refresh_token . "','" . $token_type .
351
-					"','" .  $expires_in . "','" . $expiration_date . "','" . $distinct_id .
351
+					"','" . $expires_in . "','" . $expiration_date . "','" . $distinct_id .
352 352
 					"','" . $device_uid . "','" . $name . "','" . $lat . "','" . $lng . "') ");
353 353
 
354 354
 	$success = TRUE;
355
-	if($result === false){
355
+	if($result === false) {
356 356
 			$error = db_error();
357 357
 			echo $error;
358 358
 			echo "Adding account failed: (" . $result->errno . ") " . $result->error;
@@ -398,7 +398,7 @@  discard block
 block discarded – undo
398 398
 {
399 399
 	preg_match('/bot|spider|google|twitter/i', $_SERVER['HTTP_USER_AGENT'], $matches);
400 400
 
401
-    return (isset($matches[0])) ? true : false;
401
+    return (isset($matches[0]))?true : false;
402 402
 }
403 403
 
404 404
 function botDeviceUidIsSet($config)
@@ -467,25 +467,25 @@  discard block
 block discarded – undo
467 467
 	$timediff_inDays = (string)$timediff->format('%d');
468 468
 	$timediff_inMonth = (string)$timediff->format('%m');
469 469
 
470
-	if($timediff_inMonth!=0)
470
+	if($timediff_inMonth != 0)
471 471
 	{
472 472
 			$timediff = $timediff_inMonth . "m";
473 473
 	}
474 474
 	else
475 475
 	{
476
-		if($timediff_inDays!=0)
476
+		if($timediff_inDays != 0)
477 477
 		{
478 478
 			$timediff = $timediff_inDays . "d";
479 479
 		}
480 480
 		else
481 481
 		{
482
-			if($timediff_inHours!=0)
482
+			if($timediff_inHours != 0)
483 483
 			{
484 484
 				$timediff = $timediff_inHours . "h";
485 485
 			}
486 486
 			else
487 487
 			{
488
-				if($timediff_inMinutes!=0)
488
+				if($timediff_inMinutes != 0)
489 489
 				{
490 490
 					$timediff = $timediff_inMinutes . "m";
491 491
 				}
@@ -499,7 +499,7 @@  discard block
 block discarded – undo
499 499
 
500 500
 
501 501
 	?>
502
-	<article id ="postId-<?php echo $post["post_id"]; ?>" class="jodel" style="background-color: #<?php echo $post["color"];?>;">
502
+	<article id ="postId-<?php echo $post["post_id"]; ?>" class="jodel" style="background-color: #<?php echo $post["color"]; ?>;">
503 503
 		<content>
504 504
 			<?php 
505 505
 			if(isset($post["image_url"])) {
@@ -514,24 +514,24 @@  discard block
 block discarded – undo
514 514
 			<?php
515 515
 				if($isDetailedView)
516 516
 				{?>
517
-					<a href="index.php?vote=up&getPostDetails=true&postID=<?php echo $post['post_id'];?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']);?>" rel="nofollow">
517
+					<a href="index.php?vote=up&getPostDetails=true&postID=<?php echo $post['post_id']; ?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']); ?>" rel="nofollow">
518 518
 		  <?php }
519 519
 				else
520 520
 				{?>
521
-					<a href="index.php?vote=up&postID=<?php echo $post['post_id'];?>" rel="nofollow">
521
+					<a href="index.php?vote=up&postID=<?php echo $post['post_id']; ?>" rel="nofollow">
522 522
 		  <?php } ?>
523 523
 						<i class="fa fa-angle-up fa-3x"></i>
524 524
 					</a>	
525 525
 						<br />
526
-					<?php echo $post["vote_count"];?><br />
526
+					<?php echo $post["vote_count"]; ?><br />
527 527
 			<?php
528 528
 				if($isDetailedView)
529 529
 				{?>
530
-					<a href="index.php?vote=down&getPostDetails=true&postID=<?php echo $post['post_id'];?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']);?>" rel="nofollow">
530
+					<a href="index.php?vote=down&getPostDetails=true&postID=<?php echo $post['post_id']; ?>&postID_parent=<?php echo htmlspecialchars($_GET['postID']); ?>" rel="nofollow">
531 531
 		  <?php }
532 532
 				else
533 533
 				{?>
534
-					<a href="index.php?vote=down&postID=<?php echo $post['post_id'];?>" rel="nofollow">
534
+					<a href="index.php?vote=down&postID=<?php echo $post['post_id']; ?>" rel="nofollow">
535 535
 		  <?php } ?>
536 536
 						<i class="fa fa-angle-down fa-3x"></i>
537 537
 					</a>
@@ -543,14 +543,14 @@  discard block
 block discarded – undo
543 543
 					<td class="time">
544 544
 						<span class="tip" data-tooltip="Time">
545 545
 							<i class="fa fa-clock-o"></i>
546
-							<?php echo $timediff;?>
547
-							<span class="tiptext"><?php echo $d->format('Y-m-d H:i:s');?></span>
546
+							<?php echo $timediff; ?>
547
+							<span class="tiptext"><?php echo $d->format('Y-m-d H:i:s'); ?></span>
548 548
 						</span> 
549 549
 					</td>
550 550
 					<td class="comments">
551 551
 						<?php if(!$isDetailedView) {?>
552 552
 						<span data-tooltip="Comments">
553
-							<a href="index.php?getPostDetails=true&view=<?php echo $view;?>&postID=<?php echo $post["post_id"];?>">
553
+							<a href="index.php?getPostDetails=true&view=<?php echo $view; ?>&postID=<?php echo $post["post_id"]; ?>">
554 554
 								<i class="fa fa-commenting-o"></i>
555 555
 								<?php if(array_key_exists("child_count", $post)) {
556 556
 											echo $post["child_count"];
@@ -579,7 +579,7 @@  discard block
 block discarded – undo
579 579
 									{
580 580
 							  			?>
581 581
 							  			<span data-tooltip="Author">
582
-											<i class="fa fa-user-o"></i> #<?php echo $post["user_handle"];?> |
582
+											<i class="fa fa-user-o"></i> #<?php echo $post["user_handle"]; ?> |
583 583
 										</span>
584 584
 										<?php
585 585
 									}
@@ -589,8 +589,8 @@  discard block
 block discarded – undo
589 589
 
590 590
 						<span class="tip" data-tooltip="Distance">
591 591
 							<i class="fa fa-map-marker"></i>
592
-							<?php echo $post['distance'];?> km
593
-							<span class="tiptext"><?php echo $post['location']['name'];?></span>
592
+							<?php echo $post['distance']; ?> km
593
+							<span class="tiptext"><?php echo $post['location']['name']; ?></span>
594 594
 						</span>
595 595
 					</td>
596 596
 				</tr>
Please login to merge, or discard this patch.