Changeset 12399 for extensions
- Timestamp:
- Oct 10, 2011, 5:55:35 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/piclens/generate_rss.php
r3916 r12399 88 88 89 89 $query = 'SELECT DISTINCT(img.id), img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 90 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,90 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 91 91 img.level ' 92 92 .' FROM ' . IMAGES_TABLE.' AS img' … … 109 109 110 110 $query = 'SELECT DISTINCT(img.id), img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 111 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,111 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 112 112 img.level, ic.category_id, cat.name AS catname, cat.comment AS catcomment, cat.rank, cat.status, 113 113 cat.visible, cat.uppercats, cat.permalink, cat.dir ' … … 129 129 array_push($cat, "1"); 130 130 $query = 'SELECT DISTINCT(img.id), img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 131 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,131 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 132 132 img.level, ic.category_id, cat.name AS catname, cat.comment AS catcomment, cat.rank, cat.status, 133 133 cat.visible, cat.uppercats, cat.permalink, cat.dir ' … … 148 148 149 149 $query = 'SELECT DISTINCT(img.id), img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 150 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,150 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 151 151 img.level ' 152 152 .' FROM ' . IMAGES_TABLE.' AS img' 153 153 .' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON img.id = ic.image_id' 154 .' WHERE img. average_rate IS NOT NULL '154 .' WHERE img.rating_score IS NOT NULL ' 155 155 .get_sql_condition_FandF 156 156 ( … … 168 168 169 169 $query = 'SELECT img.id, img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 170 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,170 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 171 171 img.level ' 172 172 .' FROM '.FAVORITES_TABLE.' AS fav ' … … 211 211 array_push($cat, "1"); 212 212 $query = 'SELECT distinct(img.id), img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 213 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,213 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 214 214 img.level ' 215 215 .' FROM '.IMAGES_TABLE.' AS img ' … … 275 275 276 276 $query = 'SELECT DISTINCT(img.id), img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 277 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,277 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 278 278 img.level, ic.category_id, cat.name AS catname, cat.comment AS catcomment, cat.rank, cat.status, 279 279 cat.visible, cat.uppercats, cat.permalink, cat.dir ' … … 343 343 344 344 $query = 'SELECT DISTINCT(img.id), img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 345 img.comment, img.author, img.hit ,img.filesize, img. average_rate, img.has_high, img.path,345 img.comment, img.author, img.hit ,img.filesize, img.rating_score, img.has_high, img.path, 346 346 img.level, ic.category_id, cat.name AS catname, cat.comment AS catcomment, cat.rank, cat.status, 347 347 cat.visible, cat.uppercats, cat.permalink, cat.dir '
Note: See TracChangeset
for help on using the changeset viewer.