Changeset 11327 for extensions/Comments_on_Albums/include/coa_admin_comments.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_admin_comments.php (modified) (4 diffs)

extensions/Comments_on_Albums/include/coa_admin_comments.php

@@ -3 +3 @@
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
-global $template, $conf;
+global $template, $conf, $user;
 load_language('plugin.lang', COA_PATH);
 
@@ -11 +11 @@
 include_once(PHPWG_ROOT_PATH.'admin/include/tabsheet.class.php');
 
-$tabs = array(
-  array(
-    'code' => 'pictures',
-    'label' => l10n('COA_comments_photos'),
-    ),
-  array(
-    'code' => 'albums',
-    'label' => l10n('COA_comments_albums'),
-    ),
-  );
-
-$tab_codes = array_map(create_function('$a', 'return $a["code"];'), $tabs);
-
-if (isset($_GET['section']) and in_array($_GET['section'], $tab_codes)) 
+if (isset($_GET['section']) and $_GET['section'] == 'albums')
 {
-  $page['tab'] = $_GET['section'];
+  $page['tab'] = 'albums';
 } 
 else 
 {
-  $page['tab'] = $tabs[0]['code'];
+  $page['tab'] = 'pictures';
 }
 
 $tabsheet = new tabsheet();
-foreach ($tabs as $tab) 
-{
-  $tabsheet->add(
-    $tab['code'],
-    $tab['label'],
-    get_root_url().'admin.php?page=comments&section='.$tab['code']
-    );
-}
+$tabsheet->add('pictures', l10n('COA_comments_photos'), get_root_url().'admin.php?page=comments');
+$tabsheet->add('albums', l10n('COA_comments_albums'), get_root_url().'admin.php?page=comments&section=albums');
 $tabsheet->select($page['tab']);
 $tabsheet->assign();
@@ -134 +115 @@
     com.date, 
     com.author,
-    '.$conf['user_fields']['username'].' AS username, 
+    u.'.$conf['user_fields']['username'].' AS username, 
     com.content, 
-    cat.name
+    cat.name,
+    img.id AS image_id,
+    img.path,
+    img.tn_ext
   FROM '.COA_TABLE.' AS com
-    INNER JOIN '.CATEGORIES_TABLE.' AS cat
+    LEFT JOIN '.CATEGORIES_TABLE.' AS cat
       ON cat.id = com.category_id
     LEFT JOIN '.USERS_TABLE.' AS u
       ON u.'.$conf['user_fields']['id'].' = com.author_id
+    LEFT JOIN '.USER_CACHE_CATEGORIES_TABLE.' AS ucc 
+      ON ucc.cat_id = com.category_id AND ucc.user_id = '.$user['id'].'
+    LEFT JOIN '.IMAGES_TABLE.' AS img
+      ON img.id = ucc.user_representative_picture_id
   WHERE validated = \'false\'
   ORDER BY com.date DESC
@@ -159 +147 @@
     }
     
+    // thumbnail
+    $row['thumb'] = get_thumbnail_url(
+      array(
+        'id' => $row['image_id'],
+        'path' => $row['path'],
+        'tn_ext' => @$row['tn_ext'],
+        )
+     );
+    
     // comment content
     $template->append(
       'comments', 
       array(
+        'ID' => $row['id'],
         'CAT_URL' => PHPWG_ROOT_PATH.'admin.php?page=cat_modify&cat_id='.$row['category_id'],
-        'CAT_NAME' => $row['name'],
-        'ID' => $row['id'],
+        'CAT_NAME' => trigger_event('render_category_name', $row['name']),
+        'TN_SRC' => $row['thumb'],
         'AUTHOR' => trigger_event('render_comment_author', $author_name),
         'DATE' => format_date($row['date'], true),