Ignore:
Timestamp:
06/12/09 10:28:31 (11 years ago)
Author:
grum
Message:

Update LMT to release 1.0.2

File:
1 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 "; 
Note: See TracChangeset for help on using the changeset viewer.