Changeset 11327 for extensions/Comments_on_Albums/include/coa_comments_page.php

Timestamp:

Jun 12, 2011, 12:29:11 AM (13 years ago)

Author:

mistic100

Message:

correct link in notification mail, add album thumbnail on comments list (both public and admin side)

File:

• extensions/Comments_on_Albums/include/coa_comments_page.php (modified) (5 diffs)

extensions/Comments_on_Albums/include/coa_comments_page.php

@@ -197 +197 @@
     com.validated
   FROM '.COA_TABLE.' AS com
-  LEFT JOIN '.USERS_TABLE.' As u
-    ON u.'.$conf['user_fields']['id'].' = com.author_id
+    LEFT JOIN '.USERS_TABLE.' As u
+      ON u.'.$conf['user_fields']['id'].' = com.author_id
   WHERE '.implode('
     AND ', $page['where_clauses']).'
@@ -234 +234 @@
     cat.permalink, 
     cat.uppercats, 
-    com.id as comment_id
+    com.id as comment_id,
+    img.id AS image_id,
+    img.path,
+    img.tn_ext
   FROM '.CATEGORIES_TABLE.' AS cat
-  LEFT JOIN '.COA_TABLE.' AS com
-    ON cat.id=com.category_id
+    LEFT JOIN '.COA_TABLE.' AS com
+      ON com.category_id = cat.id
+    LEFT JOIN '.USER_CACHE_CATEGORIES_TABLE.' AS ucc 
+      ON ucc.cat_id = cat.id AND ucc.user_id = '.$user['id'].'
+    LEFT JOIN '.IMAGES_TABLE.' AS img
+      ON img.id = ucc.user_representative_picture_id
   '.get_sql_condition_FandF(
     array(
@@ -251 +258 @@
     foreach ($comments as $comment) 
     {
-      // category
-      $name = $categories[$comment['comment_id']]['name'];
-      $url = duplicate_index_url(
+      // category url
+      $comment['cat_url'] = duplicate_index_url(
         array(
           'category' => array(
@@ -263 +269 @@
           )
         );
+       
+      // category thumbnail
+      $comment['thumb'] = get_thumbnail_url(
+        array(
+          'id' => $categories[$comment['comment_id']]['image_id'],
+          'path' => $categories[$comment['comment_id']]['path'],
+          'tn_ext' => @$categories[$comment['comment_id']]['tn_ext'],
+          )
+       );
       
       // comment content
       $tpl_comment = array(
         'ID' => $comment['comment_id'],
-        'CAT_URL' => $url,
-        'CAT_NAME' => $name,
+        'U_PICTURE' => $comment['cat_url'],
+        'ALT' => trigger_event('render_category_name', $categories[$comment['comment_id']]['name']),
+        'TN_SRC' => $comment['thumb'],
         'AUTHOR' => trigger_event('render_comment_author', $comment['author']),
         'DATE' => format_date($comment['date'], true),
@@ -341 +357 @@
   
   function coa_change_comments_list($content, &$smarty) {
-    $search = '<div class="description"{if isset($comment.IN_EDIT)} style="height:200px"{/if}>';
-
-    $replacement = '<div class="category-title">
-  <a href="{$comment.CAT_URL}">{$comment.CAT_NAME}</a>
-</div>
-'.$search;
-
+    $search = '<img src="{$comment.TN_SRC}" alt="{$comment.ALT}">';
+    $replacement = $search.'<br/>{$comment.ALT}';
     return str_replace($search, $replacement, $content);
   }