Changeset 64
- Timestamp:
- Sep 5, 2003, 9:27:45 PM (21 years ago)
- Location:
- trunk
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/category.php
r61 r64 234 234 $array_cat_directories = array(); 235 235 236 $query = 'SELECT id,file,date_available,tn_ext,name,filesize';237 $query.= ',storage_category_id ,category_id';238 $query.= ' FROM '.PREFIX_TABLE.'images ';239 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id =image_id';236 $query = 'SELECT distinct(id),file,date_available,tn_ext,name,filesize'; 237 $query.= ',storage_category_id'; 238 $query.= ' FROM '.PREFIX_TABLE.'images AS i'; 239 $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id=ic.image_id'; 240 240 $query.= $page['where']; 241 241 $query.= $conf['order_by']; … … 252 252 while ( $row = mysql_fetch_array( $result ) ) 253 253 { 254 // retrieving the storage dir of the picture 254 255 if ( $array_cat_directories[$row['storage_category_id']] == '' ) 255 256 { -
trunk/include/functions_category.inc.php
r61 r64 494 494 $page['title'] = $lang['favorites']; 495 495 496 $page['where'] = ', '.PREFIX_TABLE.'favorites ';496 $page['where'] = ', '.PREFIX_TABLE.'favorites AS fav'; 497 497 $page['where'].= ' WHERE user_id = '.$user['id']; 498 $page['where'].= ' AND image_id = id';498 $page['where'].= ' AND fav.image_id = id'; 499 499 500 500 $query = 'SELECT COUNT(*) AS nb_total_images'; -
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.