@@ -18,7 +18,8 @@ discard block |
||
| 18 | 18 | |
| 19 | 19 | $lastPostId = ""; |
| 20 | 20 | |
| 21 | -function isTokenFresh(Location $location) { |
|
| 21 | +function isTokenFresh(Location $location) |
|
| 22 | +{ |
|
| 22 | 23 | $db = new DatabaseConnect(); |
| 23 | 24 | $result = $db->query("SELECT * FROM accounts WHERE id='1'"); |
| 24 | 25 | |
@@ -29,7 +30,8 @@ discard block |
||
| 29 | 30 | if ($result->num_rows > 0) |
| 30 | 31 | { |
| 31 | 32 | // output data of each row |
| 32 | - while($row = $result->fetch_assoc()) { |
|
| 33 | + while($row = $result->fetch_assoc()) |
|
| 34 | + { |
|
| 33 | 35 | //$access_token = $row["access_token"]; |
| 34 | 36 | $expiration_date = $row["expiration_date"]; |
| 35 | 37 | $deviceUid = $row["device_uid"]; |
@@ -41,7 +43,8 @@ discard block |
||
| 41 | 43 | echo "0 results"; |
| 42 | 44 | } |
| 43 | 45 | |
| 44 | - if($expiration_date <= time()) { |
|
| 46 | + if($expiration_date <= time()) |
|
| 47 | + { |
|
| 45 | 48 | $accountCreator = new CreateUser(); |
| 46 | 49 | $accountCreator->setAccessToken($access_token);//$accountData->getAccessToken()); |
| 47 | 50 | $accountCreator->setDeviceUid($deviceUid); |
@@ -63,7 +66,8 @@ discard block |
||
| 63 | 66 | WHERE device_uid='" . $device_uid . "'"); |
| 64 | 67 | |
| 65 | 68 | $success = TRUE; |
| 66 | - if($result === false){ |
|
| 69 | + if($result === false) |
|
| 70 | + { |
|
| 67 | 71 | echo "Adding account failed: (" . $db->errno . ") " . $db->error; |
| 68 | 72 | $success = FALSE; |
| 69 | 73 | } |
@@ -85,7 +89,8 @@ discard block |
||
| 85 | 89 | return $data["karma"]; |
| 86 | 90 | } |
| 87 | 91 | |
| 88 | -function registerAccount(Location $location) { |
|
| 92 | +function registerAccount(Location $location) |
|
| 93 | +{ |
|
| 89 | 94 | $accountCreator = new CreateUser(); |
| 90 | 95 | $accountCreator->setLocation($location); |
| 91 | 96 | $data = $accountCreator->execute(); |
@@ -106,7 +111,8 @@ discard block |
||
| 106 | 111 | "','" . $device_uid . "') "); |
| 107 | 112 | |
| 108 | 113 | $success = TRUE; |
| 109 | - if($result === false){ |
|
| 114 | + if($result === false) |
|
| 115 | + { |
|
| 110 | 116 | $error = db_error(); |
| 111 | 117 | echo $error; |
| 112 | 118 | echo "Adding account failed: (" . $result->errno . ") " . $result->error; |
@@ -117,7 +123,7 @@ discard block |
||
| 117 | 123 | } |
| 118 | 124 | |
| 119 | 125 | function getPosts($lastPostId, $accessToken, $url) |
| 120 | -{ |
|
| 126 | +{ |
|
| 121 | 127 | $accountCreator = new GetPosts(); |
| 122 | 128 | $accountCreator->setLastPostId($lastPostId); |
| 123 | 129 | $accountCreator->setAccessToken($accessToken); |
@@ -127,7 +133,8 @@ discard block |
||
| 127 | 133 | return $data; |
| 128 | 134 | } |
| 129 | 135 | |
| 130 | -function createAccount() { |
|
| 136 | +function createAccount() |
|
| 137 | +{ |
|
| 131 | 138 | $location = new Location(); |
| 132 | 139 | $location->setLat(50.690399); |
| 133 | 140 | $location->setLng(10.918175); |
@@ -17,18 +17,22 @@ discard block |
||
| 17 | 17 | require_once 'php/Requests/libary/Requests.php'; |
| 18 | 18 | Requests::register_autoloader(); |
| 19 | 19 | |
| 20 | -function getPosts($lastPostId, $url) { |
|
| 20 | +function getPosts($lastPostId, $url) |
|
| 21 | +{ |
|
| 21 | 22 | $db = new DatabaseConnect(); |
| 22 | - if ($db->connect_errno) { |
|
| 23 | + if ($db->connect_errno) |
|
| 24 | + { |
|
| 23 | 25 | echo 'Sorry, die Verbindung zu unserem superfetten endgeilen |
| 24 | 26 | Server ist hops gegangen. Wegen '. $db -> connect_error; |
| 25 | 27 | } |
| 26 | 28 | |
| 27 | 29 | $result = $db->query("SELECT * FROM accounts WHERE id='1'"); |
| 28 | 30 | |
| 29 | - if ($result->num_rows > 0) { |
|
| 31 | + if ($result->num_rows > 0) |
|
| 32 | + { |
|
| 30 | 33 | // output data of each row |
| 31 | - while($row = $result->fetch_assoc()) { |
|
| 34 | + while($row = $result->fetch_assoc()) |
|
| 35 | + { |
|
| 32 | 36 | $access_token = $row["access_token"]; |
| 33 | 37 | } |
| 34 | 38 | } |
@@ -49,7 +53,8 @@ discard block |
||
| 49 | 53 | |
| 50 | 54 | if(isset($_GET['view'])) |
| 51 | 55 | { |
| 52 | - switch ($_GET['view']) { |
|
| 56 | + switch ($_GET['view']) |
|
| 57 | + { |
|
| 53 | 58 | case 'comment': |
| 54 | 59 | $view = 'comment'; |
| 55 | 60 | break; |
@@ -84,7 +89,8 @@ discard block |
||
| 84 | 89 | } |
| 85 | 90 | } |
| 86 | 91 | |
| 87 | - if(isset($_GET['lastPostId'])) { |
|
| 92 | + if(isset($_GET['lastPostId'])) |
|
| 93 | + { |
|
| 88 | 94 | |
| 89 | 95 | $lastPostId = htmlspecialchars($_GET['lastPostId']); |
| 90 | 96 | |
@@ -94,9 +100,11 @@ discard block |
||
| 94 | 100 | ?> |
| 95 | 101 | <div class="nextPosts"> |
| 96 | 102 | <?php |
| 97 | - for($i = 0; $i<$loops; $i++) { |
|
| 103 | + for($i = 0; $i<$loops; $i++) |
|
| 104 | + { |
|
| 98 | 105 | |
| 99 | - if(isset($posts[$i])) { |
|
| 106 | + if(isset($posts[$i])) |
|
| 107 | + { |
|
| 100 | 108 | $lastPostId = $posts[$i]['post_id']; |
| 101 | 109 | |
| 102 | 110 | |
@@ -112,7 +120,8 @@ discard block |
||
| 112 | 120 | $timediff_inHours = (string)$timediff->format('%h'); |
| 113 | 121 | $timediff_inDays = (string)$timediff->format('%d'); |
| 114 | 122 | $timediff_inMonth = (string)$timediff->format('%m'); |
| 115 | - if($timediff_inMonth!=0) { |
|
| 123 | + if($timediff_inMonth!=0) |
|
| 124 | + { |
|
| 116 | 125 | $timediff = $timediff_inMonth . "m"; |
| 117 | 126 | } |
| 118 | 127 | else |
@@ -145,10 +154,12 @@ discard block |
||
| 145 | 154 | <article class="jodel" style="background-color: #<?php echo $posts[$i]["color"];?>;"> |
| 146 | 155 | <content> |
| 147 | 156 | <?php |
| 148 | - if(isset($posts[$i]["image_url"])) { |
|
| 157 | + if(isset($posts[$i]["image_url"])) |
|
| 158 | + { |
|
| 149 | 159 | echo '<img src="' . $posts[$i]["image_url"] . '">'; |
| 150 | 160 | } |
| 151 | - else { |
|
| 161 | + else |
|
| 162 | + { |
|
| 152 | 163 | echo str_replace(' ', ' ', nl2br(htmlspecialchars($posts[$i]["message"]))); |
| 153 | 164 | } |
| 154 | 165 | ?> |
@@ -174,13 +185,19 @@ discard block |
||
| 174 | 185 | </span> |
| 175 | 186 | </td> |
| 176 | 187 | <td class="comments"> |
| 177 | - <?php if($showCommentIcon) {?> |
|
| 188 | + <?php if($showCommentIcon) |
|
| 189 | +{ |
|
| 190 | +?> |
|
| 178 | 191 | <span data-tooltip="Comments"> |
| 179 | 192 | <a href="index.php?getPostDetails=true&view=<?php echo $view;?>&postID=<?php echo $posts[$i]["post_id"];?>"> |
| 180 | 193 | <i class="fa fa-commenting-o"></i> |
| 181 | - <?php if(array_key_exists("child_count", $posts[$i])) { |
|
| 194 | + <?php if(array_key_exists("child_count", $posts[$i])) |
|
| 195 | +{ |
|
| 182 | 196 | echo $posts[$i]["child_count"]; |
| 183 | - } else echo "0"; |
|
| 197 | + } |
|
| 198 | + else { |
|
| 199 | + echo "0"; |
|
| 200 | + } |
|
| 184 | 201 | ?> |
| 185 | 202 | </a> |
| 186 | 203 | </span> |
@@ -31,7 +31,8 @@ discard block |
||
| 31 | 31 | //createAccount(); |
| 32 | 32 | |
| 33 | 33 | //Set Location |
| 34 | - if(isset($_GET['city'])) { |
|
| 34 | + if(isset($_GET['city'])) |
|
| 35 | + { |
|
| 35 | 36 | $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . htmlspecialchars($_GET['city']) . '&key=AIzaSyCwhnja-or07012HqrhPW7prHEDuSvFT4w'; |
| 36 | 37 | $result = Requests::post($url); |
| 37 | 38 | if(json_decode($result->body, true)['status'] == 'ZERO_RESULTS' || json_decode($result->body, true)['status'] == 'INVALID_REQUEST') |
@@ -52,11 +53,14 @@ discard block |
||
| 52 | 53 | } |
| 53 | 54 | |
| 54 | 55 | //Vote |
| 55 | - if(isset($_GET['vote']) && isset($_GET['postID'])) { |
|
| 56 | - if($_GET['vote'] == "up") { |
|
| 56 | + if(isset($_GET['vote']) && isset($_GET['postID'])) |
|
| 57 | + { |
|
| 58 | + if($_GET['vote'] == "up") |
|
| 59 | + { |
|
| 57 | 60 | $accountCreator = new Upvote(); |
| 58 | 61 | } |
| 59 | - else if($_GET['vote'] == "down") { |
|
| 62 | + else if($_GET['vote'] == "down") |
|
| 63 | + { |
|
| 60 | 64 | $accountCreator = new Downvote(); |
| 61 | 65 | } |
| 62 | 66 | $accountCreator->setAccessToken($accessToken); |
@@ -68,7 +72,8 @@ discard block |
||
| 68 | 72 | |
| 69 | 73 | |
| 70 | 74 | //SendJodel |
| 71 | - if(isset($_POST['message'])) { |
|
| 75 | + if(isset($_POST['message'])) |
|
| 76 | + { |
|
| 72 | 77 | $ancestor; |
| 73 | 78 | if(isset($_POST['ancestor'])) |
| 74 | 79 | { |
@@ -113,7 +118,11 @@ discard block |
||
| 113 | 118 | <a href="index.php"> |
| 114 | 119 | <h1> |
| 115 | 120 | JodelBlue |
| 116 | - <?php if(!isset($_GET['postID']) && !isset($_GET['getPostDetails'])) echo '<i class="fa fa-refresh fa-1x"></i>';?> |
|
| 121 | + <?php if(!isset($_GET['postID']) && !isset($_GET['getPostDetails'])) |
|
| 122 | +{ |
|
| 123 | + echo '<i class="fa fa-refresh fa-1x"></i>'; |
|
| 124 | +} |
|
| 125 | +?> |
|
| 117 | 126 | </h1> |
| 118 | 127 | </a> |
| 119 | 128 | </div> |
@@ -131,7 +140,8 @@ discard block |
||
| 131 | 140 | //Set View |
| 132 | 141 | if(isset($_GET['view'])) |
| 133 | 142 | { |
| 134 | - switch ($_GET['view']) { |
|
| 143 | + switch ($_GET['view']) |
|
| 144 | + { |
|
| 135 | 145 | case 'comment': |
| 136 | 146 | $view = 'comment'; |
| 137 | 147 | break; |
@@ -151,7 +161,8 @@ discard block |
||
| 151 | 161 | } |
| 152 | 162 | |
| 153 | 163 | //Get Post Details |
| 154 | - if(isset($_GET['postID']) && isset($_GET['getPostDetails'])) { |
|
| 164 | + if(isset($_GET['postID']) && isset($_GET['getPostDetails'])) |
|
| 165 | + { |
|
| 155 | 166 | //Header Nav in Comment View |
| 156 | 167 | ?> |
| 157 | 168 | <a id="comment-back" href="index.php?view=<?php echo $view;?>#postId-<?php echo htmlspecialchars($_GET['postID']);?>"> |
@@ -169,13 +180,17 @@ discard block |
||
| 169 | 180 | $data = $accountCreator->execute(); |
| 170 | 181 | |
| 171 | 182 | $posts[0] = $data; |
| 172 | - if(isset($data['children'])) { |
|
| 173 | - foreach($data['children'] as $child) { |
|
| 183 | + if(isset($data['children'])) |
|
| 184 | + { |
|
| 185 | + foreach($data['children'] as $child) |
|
| 186 | + { |
|
| 174 | 187 | array_push($posts, $child); |
| 175 | 188 | } |
| 176 | 189 | $loops = $data['child_count'] + 1; |
| 177 | 190 | } |
| 178 | - else $loops = 1; |
|
| 191 | + else { |
|
| 192 | + $loops = 1; |
|
| 193 | + } |
|
| 179 | 194 | $showCommentIcon = FALSE; |
| 180 | 195 | } |
| 181 | 196 | //Get Posts |
@@ -203,9 +218,11 @@ discard block |
||
| 203 | 218 | } |
| 204 | 219 | |
| 205 | 220 | |
| 206 | - for($i = 0; $i<$loops; $i++) { |
|
| 221 | + for($i = 0; $i<$loops; $i++) |
|
| 222 | + { |
|
| 207 | 223 | |
| 208 | - if(isset($posts[$i])) { |
|
| 224 | + if(isset($posts[$i])) |
|
| 225 | + { |
|
| 209 | 226 | $lastPostId = $posts[$i]['post_id']; |
| 210 | 227 | |
| 211 | 228 | |
@@ -221,7 +238,8 @@ discard block |
||
| 221 | 238 | $timediff_inHours = (string)$timediff->format('%h'); |
| 222 | 239 | $timediff_inDays = (string)$timediff->format('%d'); |
| 223 | 240 | $timediff_inMonth = (string)$timediff->format('%m'); |
| 224 | - if($timediff_inMonth!=0) { |
|
| 241 | + if($timediff_inMonth!=0) |
|
| 242 | + { |
|
| 225 | 243 | $timediff = $timediff_inMonth . "m"; |
| 226 | 244 | } |
| 227 | 245 | else |
@@ -254,10 +272,12 @@ discard block |
||
| 254 | 272 | <article id ="postId-<?php echo $posts[$i]["post_id"]; ?>" class="jodel" style="background-color: #<?php echo $posts[$i]["color"];?>;"> |
| 255 | 273 | <content> |
| 256 | 274 | <?php |
| 257 | - if(isset($posts[$i]["image_url"])) { |
|
| 275 | + if(isset($posts[$i]["image_url"])) |
|
| 276 | + { |
|
| 258 | 277 | echo '<img src="' . $posts[$i]["image_url"] . '">'; |
| 259 | 278 | } |
| 260 | - else { |
|
| 279 | + else |
|
| 280 | + { |
|
| 261 | 281 | echo str_replace(' ', ' ', nl2br(htmlspecialchars($posts[$i]["message"]))); |
| 262 | 282 | } |
| 263 | 283 | ?> |
@@ -283,13 +303,19 @@ discard block |
||
| 283 | 303 | </span> |
| 284 | 304 | </td> |
| 285 | 305 | <td class="comments"> |
| 286 | - <?php if($showCommentIcon) {?> |
|
| 306 | + <?php if($showCommentIcon) |
|
| 307 | +{ |
|
| 308 | +?> |
|
| 287 | 309 | <span data-tooltip="Comments"> |
| 288 | 310 | <a href="index.php?getPostDetails=true&view=<?php echo $view;?>&postID=<?php echo $posts[$i]["post_id"];?>"> |
| 289 | 311 | <i class="fa fa-commenting-o"></i> |
| 290 | - <?php if(array_key_exists("child_count", $posts[$i])) { |
|
| 312 | + <?php if(array_key_exists("child_count", $posts[$i])) |
|
| 313 | +{ |
|
| 291 | 314 | echo $posts[$i]["child_count"]; |
| 292 | - } else echo "0"; |
|
| 315 | + } |
|
| 316 | + else { |
|
| 317 | + echo "0"; |
|
| 318 | + } |
|
| 293 | 319 | ?> |
| 294 | 320 | </a> |
| 295 | 321 | </span> |
@@ -313,7 +339,9 @@ discard block |
||
| 313 | 339 | |
| 314 | 340 | </content> |
| 315 | 341 | |
| 316 | - <?php if(!isset($_GET['postID']) && !isset($_GET['getPostDetails'])) { ?> |
|
| 342 | + <?php if(!isset($_GET['postID']) && !isset($_GET['getPostDetails'])) |
|
| 343 | +{ |
|
| 344 | +?> |
|
| 317 | 345 | <p id="loading"> |
| 318 | 346 | Loading… |
| 319 | 347 | </p> |
@@ -325,7 +353,14 @@ discard block |
||
| 325 | 353 | <article> |
| 326 | 354 | <h2>Position</h2> |
| 327 | 355 | <form method="get"> |
| 328 | - <input type="text" id="city" name="city" placeholder="<?php if(isset($newPositionStatus)) echo $newPositionStatus; else echo htmlspecialchars($posts[0]["location"]["name"]); ?>" required> |
|
| 356 | + <input type="text" id="city" name="city" placeholder="<?php if(isset($newPositionStatus)) |
|
| 357 | +{ |
|
| 358 | + echo $newPositionStatus; |
|
| 359 | +} |
|
| 360 | +else { |
|
| 361 | + echo htmlspecialchars($posts[0]["location"]["name"]); |
|
| 362 | +} |
|
| 363 | +?>" required> |
|
| 329 | 364 | |
| 330 | 365 | <input type="submit" value="Set Location" /> |
| 331 | 366 | </form> |
@@ -338,7 +373,9 @@ discard block |
||
| 338 | 373 | </article> |
| 339 | 374 | |
| 340 | 375 | <article> |
| 341 | - <?php if(isset($_GET['postID']) && isset($_GET['getPostDetails'])) { ?> |
|
| 376 | + <?php if(isset($_GET['postID']) && isset($_GET['getPostDetails'])) |
|
| 377 | +{ |
|
| 378 | +?> |
|
| 342 | 379 | <h2>Comment on Jodel</h2> |
| 343 | 380 | <form method="POST"> |
| 344 | 381 | <input type="hidden" name="ancestor" value="<?php echo htmlspecialchars($_GET['postID']);?>" /> |
@@ -346,7 +383,10 @@ discard block |
||
| 346 | 383 | <br /> |
| 347 | 384 | <input type="submit" value="SEND" /> |
| 348 | 385 | </form> |
| 349 | - <?php } else { ?> |
|
| 386 | + <?php } |
|
| 387 | +else |
|
| 388 | +{ |
|
| 389 | +?> |
|
| 350 | 390 | <h2>New Jodel</h2> |
| 351 | 391 | <form method="POST"> |
| 352 | 392 | <textarea id="message" name="message" placeholder="Send a Jodel to all students within 10km" required></textarea> |
@@ -367,13 +407,25 @@ discard block |
||
| 367 | 407 | <div class="col-sm-12"> |
| 368 | 408 | <div class="row"> |
| 369 | 409 | <div class="col-sm-3"> |
| 370 | - <a href="index.php" <?php if($view=='time') echo 'class="active"';?>><i class="fa fa-clock-o fa-3x"></i></a> |
|
| 410 | + <a href="index.php" <?php if($view=='time') |
|
| 411 | +{ |
|
| 412 | + echo 'class="active"'; |
|
| 413 | +} |
|
| 414 | +?>><i class="fa fa-clock-o fa-3x"></i></a> |
|
| 371 | 415 | </div> |
| 372 | 416 | <div class="col-sm-3"> |
| 373 | - <a href="index.php?view=comment" <?php if($view=='comment') echo 'class="active"';?>><i class="fa fa-commenting-o fa-3x"></i></a> |
|
| 417 | + <a href="index.php?view=comment" <?php if($view=='comment') |
|
| 418 | +{ |
|
| 419 | + echo 'class="active"'; |
|
| 420 | +} |
|
| 421 | +?>><i class="fa fa-commenting-o fa-3x"></i></a> |
|
| 374 | 422 | </div> |
| 375 | 423 | <div class="col-sm-3"> |
| 376 | - <a href="index.php?view=upVote" <?php if($view=='upVote') echo 'class="active"';?>><i class="fa fa-angle-up fa-3x"></i></a> |
|
| 424 | + <a href="index.php?view=upVote" <?php if($view=='upVote') |
|
| 425 | +{ |
|
| 426 | + echo 'class="active"'; |
|
| 427 | +} |
|
| 428 | +?>><i class="fa fa-angle-up fa-3x"></i></a> |
|
| 377 | 429 | </div> |
| 378 | 430 | <div class="col-sm-3"> |
| 379 | 431 | <nav> |
@@ -397,7 +449,9 @@ discard block |
||
| 397 | 449 | $(this).addClass('selected'); |
| 398 | 450 | }); |
| 399 | 451 | |
| 400 | - <?php if(!isset($_GET['postID']) && !isset($_GET['getPostDetails'])) { ?> |
|
| 452 | + <?php if(!isset($_GET['postID']) && !isset($_GET['getPostDetails'])) |
|
| 453 | +{ |
|
| 454 | +?> |
|
| 401 | 455 | $(document).ready(function() { |
| 402 | 456 | var win = $(window); |
| 403 | 457 | var lastPostId = "<?php echo $lastPostId; ?>"; |