@@ -79,9 +79,9 @@ discard block |
||
79 | 79 | public function fetchOneBy(array $where = []) |
80 | 80 | { |
81 | 81 | $queryBuilder = $this->connection->createQueryBuilder() |
82 | - ->select('*') |
|
83 | - ->from(self::TABLE) |
|
84 | - ->setMaxResults(1); |
|
82 | + ->select('*') |
|
83 | + ->from(self::TABLE) |
|
84 | + ->setMaxResults(1); |
|
85 | 85 | |
86 | 86 | if (count($where) > 0) { |
87 | 87 | foreach ($where as $column => $value) { |
@@ -112,8 +112,8 @@ discard block |
||
112 | 112 | public function fetchBy(array $where = []) |
113 | 113 | { |
114 | 114 | $queryBuilder = $this->connection->createQueryBuilder() |
115 | - ->select('*') |
|
116 | - ->from(self::TABLE); |
|
115 | + ->select('*') |
|
116 | + ->from(self::TABLE); |
|
117 | 117 | |
118 | 118 | if (count($where) > 0) { |
119 | 119 | foreach ($where as $column => $value) { |
@@ -184,7 +184,7 @@ discard block |
||
184 | 184 | $databaseArray |
185 | 185 | ); |
186 | 186 | |
187 | - $entity->cacheId = (int) $this->connection->lastInsertId(); |
|
187 | + $entity->cacheId = (int)$this->connection->lastInsertId(); |
|
188 | 188 | |
189 | 189 | return $entity; |
190 | 190 | } |
@@ -298,38 +298,38 @@ discard block |
||
298 | 298 | $entity = new GeoCacheEntity(); |
299 | 299 | $entity->cacheId = $data['cache_id']; |
300 | 300 | $entity->uuid = $data['uuid']; |
301 | - $entity->node = (int) $data['node']; |
|
301 | + $entity->node = (int)$data['node']; |
|
302 | 302 | $entity->dateCreated = new DateTime($data['date_created']); |
303 | - $entity->isPublishdate = (bool) $data['is_publishdate']; |
|
303 | + $entity->isPublishdate = (bool)$data['is_publishdate']; |
|
304 | 304 | $entity->lastModified = new DateTime($data['last_modified']); |
305 | - $entity->okapiSyncbase = (int) $data['okapi_syncbase']; |
|
305 | + $entity->okapiSyncbase = (int)$data['okapi_syncbase']; |
|
306 | 306 | $entity->listingLastModified = new DateTime($data['listing_last_modified']); |
307 | 307 | $entity->metaLastModified = new DateTime($data['meta_last_modified']); |
308 | - $entity->userId = (int) $data['user_id']; |
|
308 | + $entity->userId = (int)$data['user_id']; |
|
309 | 309 | $entity->name = $data['name']; |
310 | - $entity->longitude = (double) $data['longitude']; |
|
311 | - $entity->latitude = (double) $data['latitude']; |
|
312 | - $entity->type = (int) $data['type']; |
|
313 | - $entity->status = (int) $data['status']; |
|
310 | + $entity->longitude = (double)$data['longitude']; |
|
311 | + $entity->latitude = (double)$data['latitude']; |
|
312 | + $entity->type = (int)$data['type']; |
|
313 | + $entity->status = (int)$data['status']; |
|
314 | 314 | $entity->country = $data['country']; |
315 | 315 | $entity->dateHidden = new DateTime($data['date_hidden']); |
316 | - $entity->size = (int) $data['size']; |
|
317 | - $entity->difficulty = (int) $data['difficulty']; |
|
318 | - $entity->terrain = (int) $data['terrain']; |
|
316 | + $entity->size = (int)$data['size']; |
|
317 | + $entity->difficulty = (int)$data['difficulty']; |
|
318 | + $entity->terrain = (int)$data['terrain']; |
|
319 | 319 | $entity->logpw = $data['logpw']; |
320 | - $entity->searchTime = (float) $data['search_time']; |
|
321 | - $entity->wayLength = (float) $data['way_length']; |
|
320 | + $entity->searchTime = (float)$data['search_time']; |
|
321 | + $entity->wayLength = (float)$data['way_length']; |
|
322 | 322 | $entity->wpGc = $data['wp_gc']; |
323 | 323 | $entity->wpGcMaintained = $data['wp_gc_maintained']; |
324 | 324 | $entity->wpOc = $data['wp_oc']; |
325 | 325 | $entity->descLanguages = $data['desc_languages']; |
326 | 326 | $entity->defaultDesclang = $data['default_desclang']; |
327 | 327 | $entity->dateActivate = new DateTime($data['date_activate']); |
328 | - $entity->needNpaRecalc = (bool) $data['need_npa_recalc']; |
|
329 | - $entity->showCachelists = (bool) $data['show_cachelists']; |
|
330 | - $entity->protectOldCoords = (bool) $data['protect_old_coords']; |
|
331 | - $entity->needsMaintenance = (bool) $data['needs_maintenance']; |
|
332 | - $entity->listingOutdated = (bool) $data['listing_outdated']; |
|
328 | + $entity->needNpaRecalc = (bool)$data['need_npa_recalc']; |
|
329 | + $entity->showCachelists = (bool)$data['show_cachelists']; |
|
330 | + $entity->protectOldCoords = (bool)$data['protect_old_coords']; |
|
331 | + $entity->needsMaintenance = (bool)$data['needs_maintenance']; |
|
332 | + $entity->listingOutdated = (bool)$data['listing_outdated']; |
|
333 | 333 | $entity->flagsLastModified = new DateTime($data['flags_last_modified']); |
334 | 334 | |
335 | 335 | return $entity; |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | ); |
38 | 38 | if ($r) { |
39 | 39 | if ($r['object_type'] == 1) { |
40 | - $check = (int) $connection |
|
40 | + $check = (int)$connection |
|
41 | 41 | ->fetchColumn( |
42 | 42 | 'SELECT COUNT(*) |
43 | 43 | FROM `cache_logs` |
@@ -62,7 +62,7 @@ discard block |
||
62 | 62 | |
63 | 63 | } |
64 | 64 | } elseif ($r['object_type'] == 2) { |
65 | - $check = (int) $connection |
|
65 | + $check = (int)$connection |
|
66 | 66 | ->fetchColumn( |
67 | 67 | 'SELECT COUNT(*) |
68 | 68 | FROM `caches` |
@@ -142,22 +142,22 @@ |
||
142 | 142 | |
143 | 143 | $tpl->assign('showdetails', true); |
144 | 144 | |
145 | - $r['hidden'] = (int) $connection->fetchColumn( |
|
145 | + $r['hidden'] = (int)$connection->fetchColumn( |
|
146 | 146 | 'SELECT COUNT(*) FROM `caches` WHERE `user_id`=:userId', [':userId' => $r['user_id']] |
147 | 147 | ); |
148 | - $r['hidden_active'] = (int) $connection->fetchColumn( |
|
148 | + $r['hidden_active'] = (int)$connection->fetchColumn( |
|
149 | 149 | 'SELECT COUNT(*) FROM `caches` WHERE `user_id`= :userId AND `status`=1', |
150 | 150 | [':userId' => $r['user_id']] |
151 | 151 | ); |
152 | - $r['logentries'] = (int) $connection->fetchColumn( |
|
152 | + $r['logentries'] = (int)$connection->fetchColumn( |
|
153 | 153 | 'SELECT COUNT(*) FROM `cache_logs` WHERE `user_id`= :userId', |
154 | 154 | [':userId' => $r['user_id']] |
155 | 155 | ); |
156 | - $r['deleted_logentries'] = (int) $connection->fetchColumn( |
|
156 | + $r['deleted_logentries'] = (int)$connection->fetchColumn( |
|
157 | 157 | 'SELECT COUNT(*) FROM `cache_logs_archived` WHERE `user_id`= :userId', |
158 | 158 | [':userId' => $r['user_id']] |
159 | 159 | ); |
160 | - $r['reports'] = (int) $connection->fetchColumn( |
|
160 | + $r['reports'] = (int)$connection->fetchColumn( |
|
161 | 161 | 'SELECT COUNT(*) FROM `cache_reports` WHERE `userid`= :userId', |
162 | 162 | [':userId' => $r['user_id']] |
163 | 163 | ); |
@@ -218,10 +218,10 @@ |
||
218 | 218 | $entity->nativeName = $data['native_name']; |
219 | 219 | $entity->de = $data['de']; |
220 | 220 | $entity->en = $data['en']; |
221 | - $entity->translationId = (int) $data['trans_id']; |
|
222 | - $entity->listDefaultDe = (bool) $data['list_default_de']; |
|
223 | - $entity->listDefaultEn = (bool) $data['list_default_en']; |
|
224 | - $entity->isTranslated = (bool) $data['is_translated']; |
|
221 | + $entity->translationId = (int)$data['trans_id']; |
|
222 | + $entity->listDefaultDe = (bool)$data['list_default_de']; |
|
223 | + $entity->listDefaultEn = (bool)$data['list_default_en']; |
|
224 | + $entity->isTranslated = (bool)$data['is_translated']; |
|
225 | 225 | |
226 | 226 | return $entity; |
227 | 227 | } |
@@ -181,9 +181,9 @@ |
||
181 | 181 | $entity->name = $data['name']; |
182 | 182 | $entity->de = $data['de']; |
183 | 183 | $entity->en = $data['en']; |
184 | - $entity->translationId = (int) $data['trans_id']; |
|
185 | - $entity->listDefaultDe = (bool) $data['list_default_de']; |
|
186 | - $entity->listDefaultEn = (bool) $data['list_default_en']; |
|
184 | + $entity->translationId = (int)$data['trans_id']; |
|
185 | + $entity->listDefaultDe = (bool)$data['list_default_de']; |
|
186 | + $entity->listDefaultEn = (bool)$data['list_default_en']; |
|
187 | 187 | $entity->sortDe = $data['sort_de']; |
188 | 188 | $entity->sortEn = $data['sort_en']; |
189 | 189 |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | $databaseArray |
113 | 113 | ); |
114 | 114 | |
115 | - $entity->id = (int) $this->connection->lastInsertId(); |
|
115 | + $entity->id = (int)$this->connection->lastInsertId(); |
|
116 | 116 | |
117 | 117 | return $entity; |
118 | 118 | } |
@@ -140,7 +140,7 @@ discard block |
||
140 | 140 | ['id' => $entity->id] |
141 | 141 | ); |
142 | 142 | |
143 | - $entity->id = (int) $this->connection->lastInsertId(); |
|
143 | + $entity->id = (int)$this->connection->lastInsertId(); |
|
144 | 144 | |
145 | 145 | return $entity; |
146 | 146 | } |
@@ -222,13 +222,13 @@ discard block |
||
222 | 222 | public function getEntityFromDatabaseArray(array $data) |
223 | 223 | { |
224 | 224 | $entity = new UserEntity(); |
225 | - $entity->id = (int) $data['user_id']; |
|
225 | + $entity->id = (int)$data['user_id']; |
|
226 | 226 | $entity->username = $data['username']; |
227 | 227 | $entity->password = $data['password']; |
228 | 228 | $entity->email = $data['email']; |
229 | - $entity->latitude = (double) $data['latitude']; |
|
230 | - $entity->longitude = (double) $data['longitude']; |
|
231 | - $entity->isActive = (bool) $data['is_active_flag']; |
|
229 | + $entity->latitude = (double)$data['latitude']; |
|
230 | + $entity->longitude = (double)$data['longitude']; |
|
231 | + $entity->isActive = (bool)$data['is_active_flag']; |
|
232 | 232 | $entity->firstname = $data['first_name']; |
233 | 233 | $entity->lastname = $data['last_name']; |
234 | 234 | $entity->country = $data['country']; |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | */ |
27 | 27 | public static function fromEMail($email) |
28 | 28 | { |
29 | - $userId = (int) sql_value("SELECT `user_id` FROM `user` WHERE `email`='&1'", 0, $email); |
|
29 | + $userId = (int)sql_value("SELECT `user_id` FROM `user` WHERE `email`='&1'", 0, $email); |
|
30 | 30 | if ($userId === 0) { |
31 | 31 | return null; |
32 | 32 | } |
@@ -41,7 +41,7 @@ discard block |
||
41 | 41 | */ |
42 | 42 | public static function fromUsername($username) |
43 | 43 | { |
44 | - $userId = (int) sql_value("SELECT `user_id` FROM `user` WHERE `username`='&1'", 0, $username); |
|
44 | + $userId = (int)sql_value("SELECT `user_id` FROM `user` WHERE `username`='&1'", 0, $username); |
|
45 | 45 | if ($userId === 0) { |
46 | 46 | return null; |
47 | 47 | } |
@@ -28,14 +28,14 @@ |
||
28 | 28 | [':wp' => $_REQUEST['wp']] |
29 | 29 | ); |
30 | 30 | } else { |
31 | - $cacheId = isset($_REQUEST['cacheid']) ? (int) $_REQUEST['cacheid'] : -1; |
|
31 | + $cacheId = isset($_REQUEST['cacheid']) ? (int)$_REQUEST['cacheid'] : -1; |
|
32 | 32 | } |
33 | 33 | |
34 | 34 | $showHistory = false; |
35 | 35 | $error = ''; |
36 | 36 | |
37 | 37 | if ($cacheId >= 0 && |
38 | - $connection->fetchColumn('SELECT COUNT(*) FROM `caches` WHERE `cache_id`=:id',[':id' => $cacheId]) <> 1) |
|
38 | + $connection->fetchColumn('SELECT COUNT(*) FROM `caches` WHERE `cache_id`=:id', [':id' => $cacheId]) <> 1) |
|
39 | 39 | { |
40 | 40 | $error = $translate->t('Cache not found', '', '', 0); |
41 | 41 | } elseif ($cacheId > 0) { |
@@ -66,16 +66,16 @@ discard block |
||
66 | 66 | // current cache and log-counters |
67 | 67 | $tpl->assign( |
68 | 68 | 'count_hiddens', |
69 | - number1000((int) $connection->fetchColumn('SELECT COUNT(*) AS `hiddens` FROM `caches` WHERE `status` = 1')) |
|
69 | + number1000((int)$connection->fetchColumn('SELECT COUNT(*) AS `hiddens` FROM `caches` WHERE `status` = 1')) |
|
70 | 70 | ); |
71 | 71 | $tpl->assign( |
72 | 72 | 'count_founds', |
73 | - number1000((int) $connection->fetchColumn('SELECT COUNT(*) AS `founds` FROM `cache_logs` WHERE `type` = 1')) |
|
73 | + number1000((int)$connection->fetchColumn('SELECT COUNT(*) AS `founds` FROM `cache_logs` WHERE `type` = 1')) |
|
74 | 74 | ); |
75 | 75 | $tpl->assign( |
76 | 76 | 'count_users', |
77 | 77 | number1000( |
78 | - (int) $connection->fetchColumn( |
|
78 | + (int)$connection->fetchColumn( |
|
79 | 79 | 'SELECT COUNT(*) AS `users` |
80 | 80 | FROM ( |
81 | 81 | SELECT DISTINCT `user_id` |
@@ -93,7 +93,7 @@ discard block |
||
93 | 93 | // get total event count for all countries |
94 | 94 | $tpl->assign( |
95 | 95 | 'total_events', |
96 | - (int) $connection->fetchColumn( |
|
96 | + (int)$connection->fetchColumn( |
|
97 | 97 | 'SELECT COUNT(*) |
98 | 98 | FROM `caches` |
99 | 99 | WHERE `type` = 6 |