@@ -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 | |