Changeset 3412 for extensions/lmt

Timestamp:

Jun 12, 2009, 10:28:31 AM (15 years ago)

Author:

grum

Message:

Update LMT to release 1.0.2

Location:

extensions/lmt

Files:

• lmt_aip.class.inc.php (modified) (2 diffs)
• main.inc.php (modified) (3 diffs)

extensions/lmt/lmt_aip.class.inc.php

@@ -822 +822 @@
     $img_liste = array();
     $sql="SELECT SQL_CALC_FOUND_ROWS lmti.*, img.file, img.path, img.tn_ext, cat.id as catid, cat.name as catname, cat.permalink, lmtla.text1, lmtla.text2   
-          FROM ".$this->tables["images"]." lmti LEFT OUTER JOIN ".$this->tables["licence_author"]." lmtla ON lmtla.id = lmti.author_id, ".IMAGES_TABLE." img, ".CATEGORIES_TABLE." cat
-          WHERE lmti.image_id = img.id 
-            AND img.storage_category_id = cat.id ";
+          FROM ".$this->tables["images"]." lmti LEFT OUTER JOIN ".$this->tables["licence_author"]." lmtla ON lmtla.id = lmti.author_id, 
+               ".IMAGES_TABLE." img LEFT OUTER JOIN ".CATEGORIES_TABLE." cat ON img.storage_category_id = cat.id
+          WHERE lmti.image_id = img.id ";
     if($_REQUEST['filter']!="")
     {
@@ -918 +918 @@
     $sql="SELECT SQL_CALC_FOUND_ROWS img.id as image_id, img.file, img.path, img.tn_ext, cat.id as catid, cat.name as catname, cat.permalink,
                  lmti.licence_type, lmtla.text1, lmtla.text2 
-          FROM ".CATEGORIES_TABLE." cat, ".CADDIE_TABLE." caddie, ".IMAGES_TABLE." img 
+          FROM ".CADDIE_TABLE." caddie, (".IMAGES_TABLE." img 
+            LEFT OUTER JOIN ".CATEGORIES_TABLE." cat ON img.storage_category_id = cat.id)
             LEFT OUTER JOIN ".$this->tables["images"]." AS lmti
               ON img.id = lmti.image_id  
             LEFT OUTER JOIN ".$this->tables["licence_author"]." lmtla 
               ON lmtla.id = lmti.author_id
-          WHERE img.storage_category_id = cat.id 
-            AND img.id = caddie.element_id
+          WHERE img.id = caddie.element_id
             AND caddie.user_id = '".$user['id']."'
           ORDER BY cat.id, img.id ";

extensions/lmt/main.inc.php

@@ -2 +2 @@
 /*
 Plugin Name: LMT
-Version: 1.0.1
+Version: 1.0.2
 Description: Appliquer une licence sur ses photos / Apply a licence on photos
 Plugin URI: http://phpwebgallery.net/ext/extension_view.php?eid=282
@@ -26 +26 @@
 |         |            |   like the 88x31 logo)
 |         |            | * modify the footer (allows to use html markup)
-|         |            |
+| 1.0.2   | 2009/06/12 | * the plugin can't manage picture if no physical category
+|         |            |   is affected (pictures uploaded with pLoader have
+|         |            |   only virtual categories). For now, use a LEFT OUTER JOIN 
+|         |            |   on physical categorie ; virtual category management will
+|         |            |   be coded for the next release
+|         |            |   
+|         |            |   
   
 
@@ -52 +58 @@
 define('LMT_PATH' , PHPWG_PLUGINS_PATH . LMT_DIR . '/');
 
-define('LMT_VERSION' , '1.0.1'); // => ne pas oublier la version dans l'entête !!
+define('LMT_VERSION' , '1.0.2'); // => ne pas oublier la version dans l'entête !!
 
 global $prefixeTable;