@@ -49,7 +49,7 @@ |
||
| 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 | } |
@@ -2,491 +2,491 @@ |
||
| 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 |
@@ -51,16 +51,16 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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; |
@@ -5,7 +5,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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) { |