Changeset 64 for trunk/picture.php
- Timestamp:
- Sep 5, 2003, 9:27:45 PM (21 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/picture.php
r61 r64 41 41 $query = 'SELECT id,date_available,comment,hit,keywords'; 42 42 $query.= ',author,name,file,date_creation,filesize,width,height'; 43 $query.= ',storage_category_id,category_id'; 43 $query.= ',storage_category_id'; 44 if ( is_numeric( $page['cat'] ) ) 45 { 46 $query.= ',category_id'; 47 } 44 48 $query.= ' FROM '.PREFIX_TABLE.'images'; 45 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id =image_id';49 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id = ic.image_id'; 46 50 $query.= $page['where']; 47 51 $query.= ' AND id = '.$_GET['image_id']; … … 65 69 $page['storage_category_id'] = $row['storage_category_id']; 66 70 // retrieving the number of the picture in its category (in order) 67 $query = 'SELECT id';71 $query = 'SELECT DISTINCT(id)'; 68 72 $query.= ' FROM '.PREFIX_TABLE.'images'; 69 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id =image_id';73 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id = ic.image_id'; 70 74 $query.= $page['where']; 71 75 $query.= $conf['order_by']; … … 129 133 $query = 'SELECT id'; 130 134 $query.= ' FROM '.PREFIX_TABLE.'images'; 131 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id = image_id'; 135 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic'; 136 $query.= ' ON id = ic.image_id'; 132 137 $query.= $page['where']; 133 138 $query.= $conf['order_by']; … … 212 217 { 213 218 $prev = $page['num'] - 1; 214 $query = 'SELECT id,name,file,tn_ext,storage_category_id';219 $query = 'SELECT DISTINCT(id),name,file,tn_ext,storage_category_id'; 215 220 $query.= ' FROM '.PREFIX_TABLE.'images'; 216 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id =image_id';221 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id=ic.image_id'; 217 222 $query.= $page['where']; 218 223 $query.= $conf['order_by']; … … 458 463 } 459 464 //------------------------------------ admin link for information modifications 460 if ( $user['status'] == "admin" and is_numeric( $page['cat'] ))465 if ( $user['status'] == 'admin' ) 461 466 { 462 467 $vtp->addSession( $handle, 'modification' ); … … 470 475 { 471 476 $next = $page['num'] + 1; 472 $query = 'SELECT id,name,file,tn_ext,storage_category_id';477 $query = 'SELECT DISTINCT(id),name,file,tn_ext,storage_category_id'; 473 478 $query.= ' FROM '.PREFIX_TABLE.'images'; 474 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id =image_id';479 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id=ic.image_id'; 475 480 $query.= $page['where']; 476 481 $query.= $conf['order_by'];
Note: See TracChangeset
for help on using the changeset viewer.