Changeset 3412


Ignore:
Timestamp:
Jun 12, 2009, 10:28:31 AM (11 years ago)
Author:
grum
Message:

Update LMT to release 1.0.2

Location:
extensions/lmt
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • extensions/lmt/lmt_aip.class.inc.php

    r3396 r3412  
    822822    $img_liste = array();
    823823    $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   
    824           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
    825           WHERE lmti.image_id = img.id
    826             AND img.storage_category_id = cat.id ";
     824          FROM ".$this->tables["images"]." lmti LEFT OUTER JOIN ".$this->tables["licence_author"]." lmtla ON lmtla.id = lmti.author_id,
     825               ".IMAGES_TABLE." img LEFT OUTER JOIN ".CATEGORIES_TABLE." cat ON img.storage_category_id = cat.id
     826          WHERE lmti.image_id = img.id ";
    827827    if($_REQUEST['filter']!="")
    828828    {
     
    918918    $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,
    919919                 lmti.licence_type, lmtla.text1, lmtla.text2
    920           FROM ".CATEGORIES_TABLE." cat, ".CADDIE_TABLE." caddie, ".IMAGES_TABLE." img
     920          FROM ".CADDIE_TABLE." caddie, (".IMAGES_TABLE." img
     921            LEFT OUTER JOIN ".CATEGORIES_TABLE." cat ON img.storage_category_id = cat.id)
    921922            LEFT OUTER JOIN ".$this->tables["images"]." AS lmti
    922923              ON img.id = lmti.image_id 
    923924            LEFT OUTER JOIN ".$this->tables["licence_author"]." lmtla
    924925              ON lmtla.id = lmti.author_id
    925           WHERE img.storage_category_id = cat.id
    926             AND img.id = caddie.element_id
     926          WHERE img.id = caddie.element_id
    927927            AND caddie.user_id = '".$user['id']."'
    928928          ORDER BY cat.id, img.id ";
  • extensions/lmt/main.inc.php

    r3396 r3412  
    22/*
    33Plugin Name: LMT
    4 Version: 1.0.1
     4Version: 1.0.2
    55Description: Appliquer une licence sur ses photos / Apply a licence on photos
    66Plugin URI: http://phpwebgallery.net/ext/extension_view.php?eid=282
     
    2626|         |            |   like the 88x31 logo)
    2727|         |            | * modify the footer (allows to use html markup)
    28 |         |            |
     28| 1.0.2   | 2009/06/12 | * the plugin can't manage picture if no physical category
     29|         |            |   is affected (pictures uploaded with pLoader have
     30|         |            |   only virtual categories). For now, use a LEFT OUTER JOIN
     31|         |            |   on physical categorie ; virtual category management will
     32|         |            |   be coded for the next release
     33|         |            |   
     34|         |            |   
    2935 
    3036
     
    5258define('LMT_PATH' , PHPWG_PLUGINS_PATH . LMT_DIR . '/');
    5359
    54 define('LMT_VERSION' , '1.0.1'); // => ne pas oublier la version dans l'entête !!
     60define('LMT_VERSION' , '1.0.2'); // => ne pas oublier la version dans l'entête !!
    5561
    5662global $prefixeTable;
Note: See TracChangeset for help on using the changeset viewer.