Changeset 12607 for extensions/Subscribe_to_comments/include/functions.inc.php

Timestamp:

Nov 11, 2011, 7:11:38 PM (12 years ago)

Author:

mistic100

Message:

display thumbnails on mails and subscriptions list
fix misplaced field on comment form
move management link to profile page

File:

• extensions/Subscribe_to_comments/include/functions.inc.php (modified) (10 diffs)

extensions/Subscribe_to_comments/include/functions.inc.php

@@ -58 +58 @@
     
   $generic_content = '
+<a href="'.$element['url'].'"><img src="'.$element['thumbnail'].'" alt="'.$element['name'].'"></a>
+<br>
 <b>.'.trigger_event('render_comment_author', $comm['author']).'</b> wrote :
 
@@ -79 +81 @@
 
 
-/*
+/**
  * add an email to subscribers list
  * @param int (image|category)_id
@@ -155 +157 @@
 }
 
-/*
+
+/**
  * remove an email from subscribers list
  * @param int (image|category)_id
@@ -205 +208 @@
 }
 
-/*
+
+/**
  * validate a subscription
  * @param int (image|category)_id
@@ -243 +247 @@
 }
 
+
 /**
  * create absolute url to subscriptions section
@@ -284 +289 @@
 }
 
+
 /**
  * get name and url of a picture
@@ -297 +303 @@
     id,
     name,
-    file
+    file,
+    path, 
+    tn_ext
   FROM '.IMAGES_TABLE.'
   WHERE id = '.$image_id.'
@@ -316 +324 @@
   $element['url'] = make_picture_url($url_params);
   
+  $element['thumbnail'] = get_thumbnail_url($element);
+  
   return $element;
 }
@@ -326 +336 @@
 function get_category_infos($cat_id)
 {
+  global $conf;
+  
   $query = '
 SELECT
-    id,
-    name,
-    permalink
-  FROM '.CATEGORIES_TABLE.'
-  WHERE id = '.$cat_id.'
+    cat.id,
+    cat.name,
+    cat.permalink,
+    img.id AS image_id,
+    img.path,
+    img.tn_ext
+  FROM '.CATEGORIES_TABLE.' AS cat
+    LEFT JOIN '.USER_CACHE_CATEGORIES_TABLE.' AS ucc 
+      ON ucc.cat_id = cat.id AND ucc.user_id = '.$conf['guest_id'].'
+    LEFT JOIN '.IMAGES_TABLE.' AS img
+      ON img.id = ucc.user_representative_picture_id
+  WHERE cat.id = '.$cat_id.'
 ;';
   $element = pwg_db_fetch_assoc(pwg_query($query));
+  // we use guest_id for user_cache beacause we don't know the status of recipient
   
   $url_params['section'] = 'categories';
@@ -340 +360 @@
   $element['url'] = make_index_url($url_params);
   
+  $element['thumbnail'] = get_thumbnail_url(array(
+    'id' => $element['image_id'],
+    'path' => $element['path'],
+    'tn_ext' => $element['tn_ext'],
+    ));
+  
   return $element;
 }
+
 
 /**