Changeset 2327 for trunk/picture.php

Timestamp:

May 3, 2008, 3:52:08 AM (16 years ago)

Author:

rvelices

Message:

just some optimizations (especially for large dbs)

• replace some REGEXP with LIKE in sql
• optimized queries for the combination of large data sets with picture_url_style file

File:

• trunk/picture.php (modified) (3 diffs)

trunk/picture.php

@@ -36 +36 @@
 }
 
+$page['rank_of'] = array_flip($page['items']);
+
 // if this image_id doesn't correspond to this category, an error message is
 // displayed, and execution is stopped
-if (!in_array($page['image_id'], $page['items']))
+if ( !isset($page['rank_of'][$page['image_id']]) )
 {
   page_not_found(
@@ -100 +102 @@
 // |                            initialization                             |
 // +-----------------------------------------------------------------------+
-
-$page['rank_of'] = array_flip($page['items']);
 
 // caching first_rank, last_rank, current_rank in the displayed
@@ -868 +868 @@
   include(PHPWG_ROOT_PATH.'include/picture_metadata.inc.php');
 }
-//------------------------------------------------------------ log informations
-pwg_log($picture['current']['id'], 'picture');
 
 include(PHPWG_ROOT_PATH.'include/page_header.php');
 trigger_action('loc_end_picture');
 $template->pparse('picture');
+//------------------------------------------------------------ log informations
+pwg_log($picture['current']['id'], 'picture');
 include(PHPWG_ROOT_PATH.'include/page_tail.php');
 ?>