@@ -152,7 +152,7 @@ discard block |
||
152 | 152 | " OR descriptive_title LIKE CONCAT('%', :search_2, '%'))" . |
153 | 153 | " AND multimedia_file_refn NOT LIKE 'http://%'" . |
154 | 154 | " AND multimedia_file_refn NOT LIKE 'https://%'"; |
155 | - $ARGS1 = [ |
|
155 | + $ARGS1 = [ |
|
156 | 156 | 'media_path_1' => $media_path, |
157 | 157 | 'media_folder' => $media_folder, |
158 | 158 | 'media_path_2' => Database::escapeLike($media_path), |
@@ -169,7 +169,7 @@ discard block |
||
169 | 169 | " AND multimedia_file_refn LIKE CONCAT(:media_path_3, '%')" . |
170 | 170 | " AND multimedia_file_refn NOT LIKE 'http://%'" . |
171 | 171 | " AND multimedia_file_refn NOT LIKE 'https://%'"; |
172 | - $ARGS2 = [ |
|
172 | + $ARGS2 = [ |
|
173 | 173 | 'media_folder' => $media_folder, |
174 | 174 | 'media_path_3' => $media_path, |
175 | 175 | ]; |
@@ -181,7 +181,7 @@ discard block |
||
181 | 181 | $ARGS2['media_path_4'] = Database::escapeLike($media_path); |
182 | 182 | } |
183 | 183 | |
184 | - $order = $request->get('order', []); |
|
184 | + $order = $request->get('order', []); |
|
185 | 185 | $SELECT1 .= " ORDER BY "; |
186 | 186 | if ($order) { |
187 | 187 | foreach ($order as $key => $value) { |
@@ -205,7 +205,7 @@ discard block |
||
205 | 205 | } |
206 | 206 | |
207 | 207 | if ($length > 0) { |
208 | - $SELECT1 .= " LIMIT :length OFFSET :start"; |
|
208 | + $SELECT1 .= " LIMIT :length OFFSET :start"; |
|
209 | 209 | $ARGS1['length'] = $length; |
210 | 210 | $ARGS1['start'] = $start; |
211 | 211 | } |
@@ -238,7 +238,7 @@ discard block |
||
238 | 238 | " JOIN `##media_file` USING (m_id, m_file)" . |
239 | 239 | " WHERE (multimedia_file_refn LIKE 'http://%' OR multimedia_file_refn LIKE 'https://%')" . |
240 | 240 | " AND (multimedia_file_refn LIKE CONCAT('%', :search_1, '%') OR descriptive_title LIKE CONCAT('%', :search_2, '%'))"; |
241 | - $ARGS1 = [ |
|
241 | + $ARGS1 = [ |
|
242 | 242 | 'search_1' => Database::escapeLike($search), |
243 | 243 | 'search_2' => Database::escapeLike($search), |
244 | 244 | ]; |
@@ -274,7 +274,7 @@ discard block |
||
274 | 274 | } |
275 | 275 | |
276 | 276 | if ($length > 0) { |
277 | - $SELECT1 .= " LIMIT :length OFFSET :start"; |
|
277 | + $SELECT1 .= " LIMIT :length OFFSET :start"; |
|
278 | 278 | $ARGS1['length'] = $length; |
279 | 279 | $ARGS1['start'] = $start; |
280 | 280 | } |
@@ -193,7 +193,7 @@ |
||
193 | 193 | |
194 | 194 | // Username already exists |
195 | 195 | if (User::findByUserName($username) !== null) { |
196 | - throw new Exception(I18N::translate('Duplicate username. A user with that username already exists. Please choose another username.'.$username)); |
|
196 | + throw new Exception(I18N::translate('Duplicate username. A user with that username already exists. Please choose another username.' . $username)); |
|
197 | 197 | } |
198 | 198 | |
199 | 199 | // Email already exists |
@@ -975,8 +975,8 @@ |
||
975 | 975 | // For backwards compatibility with webtrees 1.x we store the two calendar formats in one variable |
976 | 976 | // e.g. "gregorian_and_jewish" |
977 | 977 | $tree->setPreference('CALENDAR_FORMAT', implode('_and_', array_unique([ |
978 | - $request->get('CALENDAR_FORMAT0', 'none'), |
|
979 | - $request->get('CALENDAR_FORMAT1', 'none'), |
|
978 | + $request->get('CALENDAR_FORMAT0', 'none'), |
|
979 | + $request->get('CALENDAR_FORMAT1', 'none'), |
|
980 | 980 | ]))); |
981 | 981 | $tree->setPreference('CHART_BOX_TAGS', implode(',', $request->get('CHART_BOX_TAGS', []))); |
982 | 982 | $tree->setPreference('CONTACT_USER_ID', $request->get('CONTACT_USER_ID')); |
@@ -46,7 +46,7 @@ |
||
46 | 46 | <select name="tree_name" class="form-control" id="import-server-file"> |
47 | 47 | <option value=""></option> |
48 | 48 | <?php foreach ($gedcom_files as $gedcom_file): ?> |
49 | - <option value="<?= e($gedcom_file) ?>" <?= $gedcom_file === $default_gedcom_file? 'selected' : '' ?>> |
|
49 | + <option value="<?= e($gedcom_file) ?>" <?= $gedcom_file === $default_gedcom_file ? 'selected' : '' ?>> |
|
50 | 50 | <?= e($gedcom_file) ?> |
51 | 51 | </option> |
52 | 52 | <?php endforeach ?> |
@@ -1604,7 +1604,7 @@ |
||
1604 | 1604 | $height = (int) $attrs['height']; |
1605 | 1605 | } |
1606 | 1606 | |
1607 | - $person = Individual::getInstance($id, $this->tree); |
|
1607 | + $person = Individual::getInstance($id, $this->tree); |
|
1608 | 1608 | $media_file = $person->findHighlightedMediaFile(); |
1609 | 1609 | |
1610 | 1610 | if ($media_file !== null && $media_file->fileExists()) { |
@@ -255,35 +255,35 @@ discard block |
||
255 | 255 | |
256 | 256 | $args = []; |
257 | 257 | if ($search) { |
258 | - $sql .= " AND log_message LIKE CONCAT('%', :search, '%')"; |
|
258 | + $sql .= " AND log_message LIKE CONCAT('%', :search, '%')"; |
|
259 | 259 | $args['search'] = $search; |
260 | 260 | } |
261 | 261 | if ($from) { |
262 | - $sql .= " AND log_time >= :from"; |
|
262 | + $sql .= " AND log_time >= :from"; |
|
263 | 263 | $args['from'] = $from; |
264 | 264 | } |
265 | 265 | if ($to) { |
266 | - $sql .= " AND log_time < TIMESTAMPADD(DAY, 1 , :to)"; // before end of the day |
|
266 | + $sql .= " AND log_time < TIMESTAMPADD(DAY, 1 , :to)"; // before end of the day |
|
267 | 267 | $args['to'] = $to; |
268 | 268 | } |
269 | 269 | if ($type) { |
270 | - $sql .= " AND log_type = :type"; |
|
270 | + $sql .= " AND log_type = :type"; |
|
271 | 271 | $args['type'] = $type; |
272 | 272 | } |
273 | 273 | if ($text) { |
274 | - $sql .= " AND log_message LIKE CONCAT('%', :text, '%')"; |
|
274 | + $sql .= " AND log_message LIKE CONCAT('%', :text, '%')"; |
|
275 | 275 | $args['text'] = $text; |
276 | 276 | } |
277 | 277 | if ($ip) { |
278 | - $sql .= " AND ip_address LIKE CONCAT('%', :ip, '%')"; |
|
278 | + $sql .= " AND ip_address LIKE CONCAT('%', :ip, '%')"; |
|
279 | 279 | $args['ip'] = $ip; |
280 | 280 | } |
281 | 281 | if ($username) { |
282 | - $sql .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
282 | + $sql .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
283 | 283 | $args['user'] = $username; |
284 | 284 | } |
285 | 285 | if ($gedc) { |
286 | - $sql .= " AND gedcom_name = :gedc"; |
|
286 | + $sql .= " AND gedcom_name = :gedc"; |
|
287 | 287 | $args['gedc'] = $gedc; |
288 | 288 | } |
289 | 289 | |
@@ -309,7 +309,7 @@ discard block |
||
309 | 309 | } |
310 | 310 | |
311 | 311 | if ($length) { |
312 | - $sql .= " LIMIT :limit OFFSET :offset"; |
|
312 | + $sql .= " LIMIT :limit OFFSET :offset"; |
|
313 | 313 | $args['limit'] = $length; |
314 | 314 | $args['offset'] = $start; |
315 | 315 | } |
@@ -361,35 +361,35 @@ discard block |
||
361 | 361 | |
362 | 362 | $args = []; |
363 | 363 | if ($search) { |
364 | - $sql .= " AND log_message LIKE CONCAT('%', :search, '%')"; |
|
364 | + $sql .= " AND log_message LIKE CONCAT('%', :search, '%')"; |
|
365 | 365 | $args['search'] = $search; |
366 | 366 | } |
367 | 367 | if ($from) { |
368 | - $sql .= " AND log_time >= :from"; |
|
368 | + $sql .= " AND log_time >= :from"; |
|
369 | 369 | $args['from'] = $from; |
370 | 370 | } |
371 | 371 | if ($to) { |
372 | - $sql .= " AND log_time < TIMESTAMPADD(DAY, 1 , :to)"; // before end of the day |
|
372 | + $sql .= " AND log_time < TIMESTAMPADD(DAY, 1 , :to)"; // before end of the day |
|
373 | 373 | $args['to'] = $to; |
374 | 374 | } |
375 | 375 | if ($type) { |
376 | - $sql .= " AND log_type = :type"; |
|
376 | + $sql .= " AND log_type = :type"; |
|
377 | 377 | $args['type'] = $type; |
378 | 378 | } |
379 | 379 | if ($text) { |
380 | - $sql .= " AND log_message LIKE CONCAT('%', :text, '%')"; |
|
380 | + $sql .= " AND log_message LIKE CONCAT('%', :text, '%')"; |
|
381 | 381 | $args['text'] = $text; |
382 | 382 | } |
383 | 383 | if ($ip) { |
384 | - $sql .= " AND ip_address LIKE CONCAT('%', :ip, '%')"; |
|
384 | + $sql .= " AND ip_address LIKE CONCAT('%', :ip, '%')"; |
|
385 | 385 | $args['ip'] = $ip; |
386 | 386 | } |
387 | 387 | if ($username) { |
388 | - $sql .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
388 | + $sql .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
389 | 389 | $args['user'] = $username; |
390 | 390 | } |
391 | 391 | if ($gedc) { |
392 | - $sql .= " AND gedcom_name = :gedc"; |
|
392 | + $sql .= " AND gedcom_name = :gedc"; |
|
393 | 393 | $args['gedc'] = $gedc; |
394 | 394 | } |
395 | 395 | |
@@ -421,37 +421,37 @@ discard block |
||
421 | 421 | |
422 | 422 | $args = []; |
423 | 423 | if ($from) { |
424 | - $sql .= " AND log_time >= :from"; |
|
424 | + $sql .= " AND log_time >= :from"; |
|
425 | 425 | $args['from'] = $from; |
426 | 426 | } |
427 | 427 | if ($to) { |
428 | - $sql .= " AND log_time < TIMESTAMPADD(DAY, 1 , :to)"; // before end of the day |
|
428 | + $sql .= " AND log_time < TIMESTAMPADD(DAY, 1 , :to)"; // before end of the day |
|
429 | 429 | $args['to'] = $to; |
430 | 430 | } |
431 | 431 | if ($type) { |
432 | - $sql .= " AND log_type = :type"; |
|
432 | + $sql .= " AND log_type = :type"; |
|
433 | 433 | $args['type'] = $type; |
434 | 434 | } |
435 | 435 | if ($text) { |
436 | - $sql .= " AND log_message LIKE CONCAT('%', :text, '%')"; |
|
436 | + $sql .= " AND log_message LIKE CONCAT('%', :text, '%')"; |
|
437 | 437 | $args['text'] = $text; |
438 | 438 | } |
439 | 439 | if ($ip) { |
440 | - $sql .= " AND ip_address LIKE CONCAT('%', :ip, '%')"; |
|
440 | + $sql .= " AND ip_address LIKE CONCAT('%', :ip, '%')"; |
|
441 | 441 | $args['ip'] = $ip; |
442 | 442 | } |
443 | 443 | if ($username) { |
444 | - $sql .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
444 | + $sql .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
445 | 445 | $args['user'] = $username; |
446 | 446 | } |
447 | 447 | if ($gedc) { |
448 | - $sql .= " AND gedcom_name = :gedc"; |
|
448 | + $sql .= " AND gedcom_name = :gedc"; |
|
449 | 449 | $args['gedc'] = $gedc; |
450 | 450 | } |
451 | 451 | |
452 | 452 | $sql .= " ORDER BY log_id"; |
453 | 453 | |
454 | - $rows = Database::prepare($sql )->execute($args)->fetchAll(); |
|
454 | + $rows = Database::prepare($sql)->execute($args)->fetchAll(); |
|
455 | 455 | |
456 | 456 | $data = ''; |
457 | 457 |
@@ -165,7 +165,7 @@ |
||
165 | 165 | public function getFileAction(Request $request): Response { |
166 | 166 | $file = $request->get('file', ''); |
167 | 167 | |
168 | - if (!preg_match('/^(\d+)-([imnrs])-(\d+)$/', $file, $match)) { |
|
168 | + if (!preg_match('/^(\d+)-([imnrs])-(\d+)$/', $file, $match)) { |
|
169 | 169 | throw new NotFoundHttpException('Bad sitemap file'); |
170 | 170 | } |
171 | 171 |
@@ -165,7 +165,7 @@ |
||
165 | 165 | public function getFileAction(Request $request): Response { |
166 | 166 | $file = $request->get('file', ''); |
167 | 167 | |
168 | - if (!preg_match('/^(\d+)-([imnrs])-(\d+)$/', $file, $match)) { |
|
168 | + if (!preg_match('/^(\d+)-([imnrs])-(\d+)$/', $file, $match)) { |
|
169 | 169 | throw new NotFoundHttpException('Bad sitemap file'); |
170 | 170 | } |
171 | 171 |