@@ -146,8 +146,7 @@ |
||
| 146 | 146 | |
| 147 | 147 | $event['additional_sql_data'] = $additional_sql_data; |
| 148 | 148 | unset($exif); |
| 149 | - } |
|
| 150 | - else |
|
| 149 | + } else |
|
| 151 | 150 | { |
| 152 | 151 | $additional_sql_data = $event['additional_sql_data']; |
| 153 | 152 | $additional_sql_data['image_exif_data'] = ''; |
@@ -70,7 +70,7 @@ discard block |
||
| 70 | 70 | $this->user = $user; |
| 71 | 71 | $this->gallery_config = $gallery_config; |
| 72 | 72 | $this->gallery_auth = $gallery_auth; |
| 73 | - $this->gallery_url = $gallery_url; |
|
| 73 | + $this->gallery_url = $gallery_url; |
|
| 74 | 74 | $this->gallery_user = $gallery_user; |
| 75 | 75 | } |
| 76 | 76 | |
@@ -83,7 +83,7 @@ discard block |
||
| 83 | 83 | { |
| 84 | 84 | $this->user->add_lang_ext('phpbbgallery/exif', 'info_exif'); |
| 85 | 85 | |
| 86 | - $return_ary['vars']['IMAGE_SETTINGS']['disp_exifdata'] = array('lang' => 'DISP_EXIF_DATA', 'validate' => 'bool', 'type' => 'radio:yes_no'); |
|
| 86 | + $return_ary['vars']['IMAGE_SETTINGS']['disp_exifdata'] = array('lang' => 'DISP_EXIF_DATA', 'validate' => 'bool', 'type' => 'radio:yes_no'); |
|
| 87 | 87 | $event['return_ary'] = $return_ary; |
| 88 | 88 | } |
| 89 | 89 | } |
@@ -249,8 +249,7 @@ discard block |
||
| 249 | 249 | { |
| 250 | 250 | $mod_array[] = 0; |
| 251 | 251 | } |
| 252 | - } |
|
| 253 | - else |
|
| 252 | + } else |
|
| 254 | 253 | { |
| 255 | 254 | $mod_array = array($album); |
| 256 | 255 | } |
@@ -340,8 +339,7 @@ discard block |
||
| 340 | 339 | $this->template->assign_vars(array( |
| 341 | 340 | 'TOTAL_PAGES' => $this->language->lang('PAGE_TITLE_NUMBER', $page + 1), |
| 342 | 341 | )); |
| 343 | - } |
|
| 344 | - else |
|
| 342 | + } else |
|
| 345 | 343 | { |
| 346 | 344 | $this->pagination->generate_template_pagination(array( |
| 347 | 345 | 'routes' => array( |
@@ -396,8 +394,7 @@ discard block |
||
| 396 | 394 | if (is_array($ids)) |
| 397 | 395 | { |
| 398 | 396 | return array_map('intval', $ids); |
| 399 | - } |
|
| 400 | - else |
|
| 397 | + } else |
|
| 401 | 398 | { |
| 402 | 399 | return array((int) $ids); |
| 403 | 400 | } |
@@ -64,7 +64,7 @@ discard block |
||
| 64 | 64 | protected $reports_table; |
| 65 | 65 | |
| 66 | 66 | public function __construct(\phpbbgallery\core\log $gallery_log, \phpbbgallery\core\auth\auth $gallery_auth, \phpbb\user $user, |
| 67 | - \phpbb\language\language $language, \phpbb\db\driver\driver_interface $db, \phpbb\user_loader $user_loader, |
|
| 67 | + \phpbb\language\language $language, \phpbb\db\driver\driver_interface $db, \phpbb\user_loader $user_loader, |
|
| 68 | 68 | \phpbbgallery\core\album\album $album, \phpbb\template\template $template, \phpbb\controller\helper $helper, |
| 69 | 69 | \phpbbgallery\core\config $gallery_config, \phpbb\pagination $pagination, \phpbbgallery\core\notification\helper $notification_helper, |
| 70 | 70 | $images_table, $reports_table) |
@@ -363,7 +363,7 @@ discard block |
||
| 363 | 363 | 'REPORT_TIME' => $this->user->format_date($VAR['report_time']), |
| 364 | 364 | )); |
| 365 | 365 | unset($album_tmp); |
| 366 | - $reported_images_count ++; |
|
| 366 | + $reported_images_count++; |
|
| 367 | 367 | } |
| 368 | 368 | $this->template->assign_vars(array( |
| 369 | 369 | 'TOTAL_IMAGES_REPORTED' => $status == 1 ? $this->language->lang('WAITING_REPORTED_IMAGE', (int) $count) : $this->language->lang('WAITING_REPORTED_DONE', (int) $count), |
@@ -279,7 +279,7 @@ discard block |
||
| 279 | 279 | include_once($this->root_path . 'includes/message_parser.' . $this->php_ext); |
| 280 | 280 | } |
| 281 | 281 | $message_parser = new \parse_message(); |
| 282 | - $message_parser->message = utf8_normalize_nfc($this->get_description()); |
|
| 282 | + $message_parser->message = utf8_normalize_nfc($this->get_description()); |
|
| 283 | 283 | if ($message_parser->message) |
| 284 | 284 | { |
| 285 | 285 | $message_parser->parse(true, true, true, true, false, true, true, true); |
@@ -334,7 +334,7 @@ discard block |
||
| 334 | 334 | |
| 335 | 335 | $sql_ary = array_merge($sql_ary, $additional_sql_data); |
| 336 | 336 | |
| 337 | - $sql = 'UPDATE ' . $this->images_table. ' |
|
| 337 | + $sql = 'UPDATE ' . $this->images_table . ' |
|
| 338 | 338 | SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' |
| 339 | 339 | WHERE image_id = ' . (int) $image_id; |
| 340 | 340 | $this->db->sql_query($sql); |
@@ -452,7 +452,7 @@ discard block |
||
| 452 | 452 | // Rotate the image |
| 453 | 453 | if ($this->gallery_config->get('allow_rotate') && $this->get_rotating()) |
| 454 | 454 | { |
| 455 | - $this->tools->rotate_image($this->get_rotating(),$this->gallery_config->get('allow_resize')); |
|
| 455 | + $this->tools->rotate_image($this->get_rotating(), $this->gallery_config->get('allow_resize')); |
|
| 456 | 456 | if ($this->tools->rotated) |
| 457 | 457 | { |
| 458 | 458 | $this->tools->write_image($this->tools->image_source, $this->gallery_config->get('jpg_quality'), true); |
@@ -144,8 +144,7 @@ discard block |
||
| 144 | 144 | { |
| 145 | 145 | $this->zip_file = $this->file; |
| 146 | 146 | $this->upload_zip(); |
| 147 | - } |
|
| 148 | - else |
|
| 147 | + } else |
|
| 149 | 148 | { |
| 150 | 149 | $image_id = $this->prepare_file(); |
| 151 | 150 | if ($image_id) |
@@ -210,8 +209,7 @@ discard block |
||
| 210 | 209 | if (is_dir($current_dir . $file)) |
| 211 | 210 | { |
| 212 | 211 | $this->read_zip_folder($current_dir . $file . '/'); |
| 213 | - } |
|
| 214 | - else if (in_array(utf8_substr(strtolower($file), utf8_strrpos($file, '.') + 1), self::get_allowed_types(false, true))) |
|
| 212 | + } else if (in_array(utf8_substr(strtolower($file), utf8_strrpos($file, '.') + 1), self::get_allowed_types(false, true))) |
|
| 215 | 213 | { |
| 216 | 214 | if (!$this->file_limit || ($this->uploaded_files < $this->file_limit)) |
| 217 | 215 | { |
@@ -231,23 +229,20 @@ discard block |
||
| 231 | 229 | { |
| 232 | 230 | $this->uploaded_files++; |
| 233 | 231 | $this->images[] = (int) $image_id; |
| 234 | - } |
|
| 235 | - else |
|
| 232 | + } else |
|
| 236 | 233 | { |
| 237 | 234 | if ($this->file->error) |
| 238 | 235 | { |
| 239 | 236 | $this->new_error($this->language->lang('UPLOAD_ERROR', $this->file->get('uploadname'), implode('<br />» ', $this->file->error))); |
| 240 | 237 | } |
| 241 | 238 | } |
| 242 | - } |
|
| 243 | - else |
|
| 239 | + } else |
|
| 244 | 240 | { |
| 245 | 241 | $this->quota_error(); |
| 246 | 242 | @unlink($current_dir . $file); |
| 247 | 243 | } |
| 248 | 244 | |
| 249 | - } |
|
| 250 | - else |
|
| 245 | + } else |
|
| 251 | 246 | { |
| 252 | 247 | @unlink($current_dir . $file); |
| 253 | 248 | } |
@@ -356,8 +351,7 @@ discard block |
||
| 356 | 351 | { |
| 357 | 352 | $this->file->clean_filename('unique_ext'); |
| 358 | 353 | $this->file->move_file(substr($this->gallery_url->path('upload'), 0, -1), false, false, CHMOD_ALL); |
| 359 | - } |
|
| 360 | - else |
|
| 354 | + } else |
|
| 361 | 355 | { |
| 362 | 356 | // Okay, this looks hacky, but what we do here is, we store the directory name in the filename. |
| 363 | 357 | // However phpBB strips directories form the filename, when moving, so we need to specify that again. |
@@ -411,8 +405,7 @@ discard block |
||
| 411 | 405 | //$this->file->height = $this->tools->image_size['height']; |
| 412 | 406 | //$this->file->width = $this->tools->image_size['width']; |
| 413 | 407 | } |
| 414 | - } |
|
| 415 | - else |
|
| 408 | + } else |
|
| 416 | 409 | { |
| 417 | 410 | $this->file->remove(); |
| 418 | 411 | $this->new_error($this->language->lang('UPLOAD_ERROR', $this->file->get('uploadname'), $this->language->lang('UPLOAD_IMAGE_SIZE_TOO_BIG'))); |
@@ -190,9 +190,9 @@ |
||
| 190 | 190 | $this->db->sql_freeresult($result); |
| 191 | 191 | |
| 192 | 192 | $sql = 'UPDATE ' . $this->contest_table . ' |
| 193 | - SET contest_first = ' . (int) $first .', |
|
| 194 | - contest_second = ' . (int) $second .', |
|
| 195 | - contest_third = ' . (int) $third .' |
|
| 193 | + SET contest_first = ' . (int) $first . ', |
|
| 194 | + contest_second = ' . (int) $second . ', |
|
| 195 | + contest_third = ' . (int) $third . ' |
|
| 196 | 196 | WHERE contest_album_id = ' . (int) $album_id; |
| 197 | 197 | $this->db->sql_query($sql); |
| 198 | 198 | |
@@ -165,8 +165,7 @@ |
||
| 165 | 165 | { |
| 166 | 166 | $this->resync($album_id); |
| 167 | 167 | } |
| 168 | - } |
|
| 169 | - else |
|
| 168 | + } else |
|
| 170 | 169 | { |
| 171 | 170 | $this->resync((int) $album_ids); |
| 172 | 171 | } |
@@ -158,7 +158,7 @@ discard block |
||
| 158 | 158 | */ |
| 159 | 159 | public function display_box() |
| 160 | 160 | { |
| 161 | - $this->template->assign_var('GALLERY_RATING', self::MODE_SELECT);//@todo: phpbb_ext_gallery_core_config::get('rating_mode')); |
|
| 161 | + $this->template->assign_var('GALLERY_RATING', self::MODE_SELECT); //@todo: phpbb_ext_gallery_core_config::get('rating_mode')); |
|
| 162 | 162 | |
| 163 | 163 | switch (self::MODE_SELECT)//@todo: phpbb_ext_gallery_core_config::get('rating_mode')) |
| 164 | 164 | { |
@@ -201,7 +201,7 @@ discard block |
||
| 201 | 201 | */ |
| 202 | 202 | public function get_image_rating($user_rating = false, $display_contest_end = true) |
| 203 | 203 | { |
| 204 | - $this->template->assign_var('GALLERY_RATING', self::MODE_SELECT);//@todo: phpbb_ext_gallery_core_config::get('rating_mode')); |
|
| 204 | + $this->template->assign_var('GALLERY_RATING', self::MODE_SELECT); //@todo: phpbb_ext_gallery_core_config::get('rating_mode')); |
|
| 205 | 205 | |
| 206 | 206 | switch (self::MODE_SELECT)//@todo: phpbb_ext_gallery_core_config::get('rating_mode')) |
| 207 | 207 | { |
@@ -216,8 +216,7 @@ discard block |
||
| 216 | 216 | return $this->language->lang('CONTEST_RATING_HIDDEN'); |
| 217 | 217 | } |
| 218 | 218 | return $this->language->lang('CONTEST_RESULT_HIDDEN', $this->user->format_date(($this->album_data('contest_start') + $this->album_data('contest_end')), false, true)); |
| 219 | - } |
|
| 220 | - else |
|
| 219 | + } else |
|
| 221 | 220 | { |
| 222 | 221 | if ($user_rating) |
| 223 | 222 | { |
@@ -364,8 +363,7 @@ discard block |
||
| 364 | 363 | if (is_array($image_ids)) |
| 365 | 364 | { |
| 366 | 365 | $image_ids = array_map('intval', $image_ids); |
| 367 | - } |
|
| 368 | - else |
|
| 366 | + } else |
|
| 369 | 367 | { |
| 370 | 368 | $image_ids = (int) $image_ids; |
| 371 | 369 | } |
@@ -399,8 +397,7 @@ discard block |
||
| 399 | 397 | if (is_array($image_ids)) |
| 400 | 398 | { |
| 401 | 399 | $image_ids = array_map('intval', $image_ids); |
| 402 | - } |
|
| 403 | - else |
|
| 400 | + } else |
|
| 404 | 401 | { |
| 405 | 402 | $image_ids = (int) $image_ids; |
| 406 | 403 | } |
@@ -23,13 +23,13 @@ discard block |
||
| 23 | 23 | * |
| 24 | 24 | * Constants defining some album properties |
| 25 | 25 | */ |
| 26 | - const PUBLIC_ALBUM = 0; |
|
| 26 | + const PUBLIC_ALBUM = 0; |
|
| 27 | 27 | |
| 28 | - const TYPE_CAT = 0; |
|
| 29 | - const TYPE_UPLOAD = 1; |
|
| 28 | + const TYPE_CAT = 0; |
|
| 29 | + const TYPE_UPLOAD = 1; |
|
| 30 | 30 | const TYPE_CONTEST = 2; |
| 31 | 31 | |
| 32 | - const ALBUM_OPEN = 0; |
|
| 32 | + const ALBUM_OPEN = 0; |
|
| 33 | 33 | const ALBUM_LOCKED = 1; |
| 34 | 34 | |
| 35 | 35 | /** |
@@ -58,22 +58,22 @@ discard block |
||
| 58 | 58 | /** |
| 59 | 59 | * Only visible for moderators. |
| 60 | 60 | */ |
| 61 | - const STATUS_UNAPPROVED = 0; |
|
| 61 | + const STATUS_UNAPPROVED = 0; |
|
| 62 | 62 | |
| 63 | 63 | /** |
| 64 | 64 | * Visible for everyone with the i_view-permissions |
| 65 | 65 | */ |
| 66 | - const STATUS_APPROVED = 1; |
|
| 66 | + const STATUS_APPROVED = 1; |
|
| 67 | 67 | |
| 68 | 68 | /** |
| 69 | 69 | * Visible for everyone with the i_view-permissions, but only moderators can comment. |
| 70 | 70 | */ |
| 71 | - const STATUS_LOCKED = 2; |
|
| 71 | + const STATUS_LOCKED = 2; |
|
| 72 | 72 | |
| 73 | 73 | /** |
| 74 | 74 | * Orphan files are only visible for their author, because they're not yet ready uploaded. |
| 75 | 75 | */ |
| 76 | - const STATUS_ORPHAN = 3; |
|
| 76 | + const STATUS_ORPHAN = 3; |
|
| 77 | 77 | |
| 78 | 78 | /** |
| 79 | 79 | * Constants regarding the image contest relation |
@@ -316,7 +316,7 @@ |
||
| 316 | 316 | |
| 317 | 317 | public function generate_image_src() |
| 318 | 318 | { |
| 319 | - $this->image_src = $this->path . $this->data['image_filename']; |
|
| 319 | + $this->image_src = $this->path . $this->data['image_filename']; |
|
| 320 | 320 | |
| 321 | 321 | if ($this->data['image_filemissing'] || !file_exists($this->path_source . $this->data['image_filename'])) |
| 322 | 322 | { |
@@ -238,8 +238,7 @@ discard block |
||
| 238 | 238 | $this->data['album_user_id'] = 1; |
| 239 | 239 | $this->data['image_filemissing'] = 0; |
| 240 | 240 | $this->data['album_watermark'] = 0; |
| 241 | - } |
|
| 242 | - else |
|
| 241 | + } else |
|
| 243 | 242 | { |
| 244 | 243 | $sql = 'SELECT * |
| 245 | 244 | FROM ' . $this->table_images . ' i |
@@ -409,8 +408,7 @@ discard block |
||
| 409 | 408 | { |
| 410 | 409 | $response->headers->set('expires', '-1'); |
| 411 | 410 | } |
| 412 | - } |
|
| 413 | - else |
|
| 411 | + } else |
|
| 414 | 412 | { |
| 415 | 413 | $response->headers->set('Content-Disposition', 'inline; ' . $this->tool->header_filename(htmlspecialchars_decode($this->tool->image_name) . '.' . $this->tool->image_type)); |
| 416 | 414 | if ($this->tool->is_ie_greater7($this->user->browser)) |
@@ -249,8 +249,7 @@ discard block |
||
| 249 | 249 | 'last_image' => end($process->images), |
| 250 | 250 | ); |
| 251 | 251 | $this->notification_helper->new_image($data); |
| 252 | - } |
|
| 253 | - else |
|
| 252 | + } else |
|
| 254 | 253 | { |
| 255 | 254 | $target = array( |
| 256 | 255 | 'album_id' => $album_id, |
@@ -355,8 +354,7 @@ discard block |
||
| 355 | 354 | { |
| 356 | 355 | $this->language->add_lang('ucp'); |
| 357 | 356 | $error_array[] = $this->language->lang($result . '_USERNAME'); |
| 358 | - } |
|
| 359 | - else |
|
| 357 | + } else |
|
| 360 | 358 | { |
| 361 | 359 | $process->set_username($username); |
| 362 | 360 | } |
@@ -375,8 +373,7 @@ discard block |
||
| 375 | 373 | if (!$process->uploaded_files) |
| 376 | 374 | { |
| 377 | 375 | $process->new_error($this->language->lang('UPLOAD_NO_FILE')); |
| 378 | - } |
|
| 379 | - else |
|
| 376 | + } else |
|
| 380 | 377 | { |
| 381 | 378 | $mode = 'upload_edit'; |
| 382 | 379 | // Remove submit, so we get the first screen of step 2. |
@@ -422,8 +419,7 @@ discard block |
||
| 422 | 419 | if ($VAR == 'zip') |
| 423 | 420 | { |
| 424 | 421 | continue; |
| 425 | - } |
|
| 426 | - else |
|
| 422 | + } else |
|
| 427 | 423 | { |
| 428 | 424 | $filetypes[] = $VAR; |
| 429 | 425 | } |
@@ -523,8 +519,7 @@ discard block |
||
| 523 | 519 | 'last_image' => end($process->images), |
| 524 | 520 | ); |
| 525 | 521 | $this->notification_helper->new_image($data); |
| 526 | - } |
|
| 527 | - else |
|
| 522 | + } else |
|
| 528 | 523 | { |
| 529 | 524 | $target = array( |
| 530 | 525 | 'album_id' => (int) $album_id, |
@@ -591,8 +586,7 @@ discard block |
||
| 591 | 586 | if (file_exists($phpbbgallery_core_file) && is_writable($phpbbgallery_core_file) && file_exists($phpbbgallery_core_file_source) && is_writable($phpbbgallery_core_file_source) && file_exists($phpbbgallery_core_file_medium) && is_writable($phpbbgallery_core_file_medium) && file_exists($phpbbgallery_core_file_mini) && is_writable($phpbbgallery_core_file_mini)) |
| 592 | 587 | { |
| 593 | 588 | return true; |
| 594 | - } |
|
| 595 | - else |
|
| 589 | + } else |
|
| 596 | 590 | { |
| 597 | 591 | return false; |
| 598 | 592 | } |
@@ -232,8 +232,7 @@ discard block |
||
| 232 | 232 | if ($search_terms == 'all') |
| 233 | 233 | { |
| 234 | 234 | $keywords .= ' ' . $add_keywords; |
| 235 | - } |
|
| 236 | - else |
|
| 235 | + } else |
|
| 237 | 236 | { |
| 238 | 237 | $search_terms = 'all'; |
| 239 | 238 | $keywords = preg_replace('#\s+#u', ' |', $keywords) . ' ' .$add_keywords; |
@@ -271,8 +270,7 @@ discard block |
||
| 271 | 270 | if (empty($search_album)) |
| 272 | 271 | { |
| 273 | 272 | $sql_where[] = $this->db->sql_in_set('i.image_album_id', $this->gallery_auth->acl_album_ids('i_view')); |
| 274 | - } |
|
| 275 | - else |
|
| 273 | + } else |
|
| 276 | 274 | { |
| 277 | 275 | $sql_where[] = $this->db->sql_in_set('i.image_album_id', $search_album); |
| 278 | 276 | } |
@@ -141,10 +141,10 @@ discard block |
||
| 141 | 141 | |
| 142 | 142 | public function base($page = 1) |
| 143 | 143 | { |
| 144 | - $search_id = $this->request->variable('search_id', ''); |
|
| 144 | + $search_id = $this->request->variable('search_id', ''); |
|
| 145 | 145 | $image_id = $this->request->variable('image_id', 0); |
| 146 | 146 | |
| 147 | - $submit = $this->request->variable('submit', false); |
|
| 147 | + $submit = $this->request->variable('submit', false); |
|
| 148 | 148 | $keywords = utf8_normalize_nfc($this->request->variable('keywords', '', true)); |
| 149 | 149 | $add_keywords = utf8_normalize_nfc($this->request->variable('add_keywords', '', true)); |
| 150 | 150 | $username = $this->request->variable('username', '', true); |
@@ -152,13 +152,13 @@ discard block |
||
| 152 | 152 | $search_terms = $this->request->variable('terms', 'all'); |
| 153 | 153 | $search_album = $this->request->variable('aid', array(0)); |
| 154 | 154 | $search_child = $this->request->variable('sc', true); |
| 155 | - $search_fields = $this->request->variable('sf', 'all'); |
|
| 156 | - $sort_days = $this->request->variable('st', 0); |
|
| 155 | + $search_fields = $this->request->variable('sf', 'all'); |
|
| 156 | + $sort_days = $this->request->variable('st', 0); |
|
| 157 | 157 | $sort_key = $this->request->variable('sk', 't'); |
| 158 | 158 | $sort_dir = $this->request->variable('sd', 'd'); |
| 159 | 159 | $filtered = $this->request->variable('filtered', false); |
| 160 | 160 | |
| 161 | - $start = ($page - 1) * $this->gallery_config->get('items_per_page'); |
|
| 161 | + $start = ($page - 1) * $this->gallery_config->get('items_per_page'); |
|
| 162 | 162 | if ($filtered) |
| 163 | 163 | { |
| 164 | 164 | $submit = true; |
@@ -175,7 +175,7 @@ discard block |
||
| 175 | 175 | if ($this->gallery_config->get('allow_rates')) |
| 176 | 176 | { |
| 177 | 177 | $sort_by_text['ra'] = $this->language->lang('RATING'); |
| 178 | - $sort_by_sql['ra'] = 'image_rate_points';//@todo: (phpbb_gallery_contest::$mode == phpbb_gallery_contest::MODE_SUM) ? 'image_rate_points' : 'image_rate_avg'; |
|
| 178 | + $sort_by_sql['ra'] = 'image_rate_points'; //@todo: (phpbb_gallery_contest::$mode == phpbb_gallery_contest::MODE_SUM) ? 'image_rate_points' : 'image_rate_avg'; |
|
| 179 | 179 | $sort_by_text['r'] = $this->language->lang('RATES_COUNT'); |
| 180 | 180 | $sort_by_sql['r'] = 'image_rates'; |
| 181 | 181 | } |
@@ -206,7 +206,7 @@ discard block |
||
| 206 | 206 | { |
| 207 | 207 | trigger_error(sprintf($this->language->lang('TOO_FEW_AUTHOR_CHARS'), $this->config['min_search_author_chars'])); |
| 208 | 208 | } |
| 209 | - $username_parsed = (strpos($username, '*') !== false) ? ' username_clean ' . $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), utf8_clean_string($this->db->sql_escape($username)))) : ' username_clean = \'' . $this->db->sql_escape(utf8_clean_string($username)) .'\''; |
|
| 209 | + $username_parsed = (strpos($username, '*') !== false) ? ' username_clean ' . $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), utf8_clean_string($this->db->sql_escape($username)))) : ' username_clean = \'' . $this->db->sql_escape(utf8_clean_string($username)) . '\''; |
|
| 210 | 210 | $sql = 'SELECT user_id |
| 211 | 211 | FROM ' . USERS_TABLE . ' |
| 212 | 212 | WHERE ' . $username_parsed . ' |
@@ -224,7 +224,7 @@ discard block |
||
| 224 | 224 | |
| 225 | 225 | if (!empty($user_id)) |
| 226 | 226 | { |
| 227 | - $sql_where[] = $this->db->sql_in_set('i.image_user_id', $user_id); |
|
| 227 | + $sql_where[] = $this->db->sql_in_set('i.image_user_id', $user_id); |
|
| 228 | 228 | } |
| 229 | 229 | // if we search in an existing search result just add the additional keywords. But we need to use "all search terms"-mode |
| 230 | 230 | // so we can keep the old keywords in their old mode, but add the new ones as required words |
@@ -237,7 +237,7 @@ discard block |
||
| 237 | 237 | else |
| 238 | 238 | { |
| 239 | 239 | $search_terms = 'all'; |
| 240 | - $keywords = preg_replace('#\s+#u', ' |', $keywords) . ' ' .$add_keywords; |
|
| 240 | + $keywords = preg_replace('#\s+#u', ' |', $keywords) . ' ' . $add_keywords; |
|
| 241 | 241 | } |
| 242 | 242 | } |
| 243 | 243 | $keywords_ary = ($keywords) ? explode(' ', $keywords) : array(); |
@@ -262,7 +262,7 @@ discard block |
||
| 262 | 262 | $match_search_query = ''; |
| 263 | 263 | foreach ($matches as $match) |
| 264 | 264 | { |
| 265 | - $match_search_query .= (($match_search_query) ? ' OR ' : '') . 'LOWER('. $match . ') '; |
|
| 265 | + $match_search_query .= (($match_search_query) ? ' OR ' : '') . 'LOWER(' . $match . ') '; |
|
| 266 | 266 | $match_search_query .= $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), $this->db->get_any_char() . mb_strtolower($word) . $this->db->get_any_char())); |
| 267 | 267 | } |
| 268 | 268 | $search_query .= ((!$search_query) ? '' : (($search_terms == 'all') ? ' AND ' : ' OR ')) . '(' . $match_search_query . ')'; |
@@ -291,7 +291,7 @@ discard block |
||
| 291 | 291 | trigger_error('NO_SEARCH_RESULTS'); |
| 292 | 292 | } |
| 293 | 293 | $sql_array['SELECT'] = '*, a.album_name, a.album_status, a.album_user_id, a.album_id'; |
| 294 | - $sql_array['LEFT_JOIN'] = array( |
|
| 294 | + $sql_array['LEFT_JOIN'] = array( |
|
| 295 | 295 | array( |
| 296 | 296 | 'FROM' => array($this->albums_table => 'a'), |
| 297 | 297 | 'ON' => 'a.album_id = i.image_album_id', |
@@ -319,7 +319,7 @@ discard block |
||
| 319 | 319 | { |
| 320 | 320 | $this->image->assign_block('imageblock.image', $row, $show_options, $thumbnail_link, $imagename_link); |
| 321 | 321 | } |
| 322 | - $current_page = $page*$this->gallery_config->get('items_per_page'); |
|
| 322 | + $current_page = $page * $this->gallery_config->get('items_per_page'); |
|
| 323 | 323 | $this->pagination->generate_template_pagination(array( |
| 324 | 324 | 'routes' => array( |
| 325 | 325 | 'phpbbgallery_core_search', |