Changeset 3147 for branches/2.0/include/picture_comment.inc.php

Timestamp:

Feb 14, 2009, 3:28:21 AM (16 years ago)

Author:

rvelices

Message:

merge 3145-3146 from trunk
Last (I hope) paranoic optims ...

• move get_uysername and get_groupname from public to admin/functions.inc.php
• optim in index.php
• tags.tpl does not need smarty modifier included
• move func get_comment_post_key from functions_comment to functions (avoid extra inclusion every time on picture page)

File:

• branches/2.0/include/picture_comment.inc.php (modified) (2 diffs)

branches/2.0/include/picture_comment.inc.php

@@ -89 +89 @@
 if ($page['show_comments'])
 {
-  // number of comment for this picture
-  $query = 'SELECT COUNT(*) AS nb_comments';
-  $query.= ' FROM '.COMMENTS_TABLE.' WHERE image_id = '.$page['image_id'];
-  $query.= " AND validated = 'true'";
-  $query.= ';';
+  // number of comments for this picture
+  $query = '
+SELECT COUNT(*) AS nb_comments
+  FROM '.COMMENTS_TABLE.'
+  WHERE image_id='.$page['image_id']." AND validated = 'true'";
   $row = mysql_fetch_array( pwg_query( $query ) );
 
@@ -161 +161 @@
       or (is_a_guest() and $conf['comments_forall']))
   {
-    include_once(PHPWG_ROOT_PATH.'include/functions_comment.inc.php');
     $key = get_comment_post_key($page['image_id']);
     $content = '';