Changeset 12154 for extensions/ExtendedDescription/main.inc.php

Timestamp:

Sep 13, 2011, 10:51:56 PM (13 years ago)

Author:

plg

Message:

add pattern [random album=xx]

File:

• extensions/ExtendedDescription/main.inc.php (modified) (2 diffs)

extensions/ExtendedDescription/main.inc.php

@@ -118 +118 @@
   $replacements[] = ($param == 'subcatify_category_description') ? '' : 'get_img_thumb("$1", "$2", "$3")';
 
+    // [random album=xx]
+    $patterns[] = '#\[random\s+(?:album|cat)=\s*?(\d+)\s*?\]#ie';
+    $replacements[] = 'extdesc_get_random_photo("$1")';
 
   // Balises <!--complete-->, <!--more--> et <!--up-down-->
@@ -347 +350 @@
 
 
+function extdesc_get_random_photo($category_id)
+{
+  $query = '
+SELECT
+    path
+  FROM '.IMAGES_TABLE.'
+    JOIN '.IMAGE_CATEGORY_TABLE.' ON image_id = id
+  WHERE category_id = '.$category_id.'
+  ORDER BY '.DB_RANDOM_FUNCTION.'()
+  LIMIT 1
+;';
+  $result = pwg_query($query);
+  while ($row = pwg_db_fetch_assoc($result))
+  {
+    return '<img src="'.$row['path'].'">';
+  }
+
+  return '';
+}
+
 if (script_basename() == 'admin' or script_basename() == 'popuphelp')
 {