diff options
Diffstat (limited to 'services')
-rw-r--r-- | services/recent.php | 64 |
1 files changed, 0 insertions, 64 deletions
diff --git a/services/recent.php b/services/recent.php deleted file mode 100644 index 808b5a165..000000000 --- a/services/recent.php +++ /dev/null @@ -1,64 +0,0 @@ -<?php
-
-$where =
- get_sql_condition_FandF
- (
- array
- (
- 'forbidden_categories' => 'ic.category_id',
- 'visible_categories' => 'ic.category_id',
- 'visible_images' => 'i.id'
- ),
- ''
- );
-$list = implode(',', $final);
-if ( $where !== '' and $list !== '' )
-{
- $where .= ' AND ';
-}
-$where .= ( $list == '') ? '' :
- 'i.`id` IN ('. $list .')';
-$query='
- SELECT DISTINCT (i.`id`),
- i.`path` , i.`file` , i.`date_available` ,
- i.`date_creation`, i.`tn_ext` , i.`name` ,
- i.`filesize` , i.`storage_category_id` , i.`average_rate`,
- i.`comment` , i.`author` , i.`hit` ,i.`width` ,
- i.`height`
- FROM `'.IMAGES_TABLE.'` AS i
- INNER JOIN `'.IMAGE_CATEGORY_TABLE.'`
- AS ic ON i.`id` = ic.`image_id`
- WHERE '. $where .'
-';
-/* recent = Date_available desc order */
-$query .= ' ORDER BY i.`date_available` DESC, RAND() DESC ';
-$query .= ' LIMIT 0 , '. $limit .';';
-// echo $query . '<br />';
-$result = pwg_query( $query );
-
-$template->assign_vars(
- array(
- 'TITLE' => 'recent',
- )
- );
-$template->assign_block_vars(
- 'row', array()
- );
-$template->assign_block_vars(
- 'row.Normal',
- array(
- 'WIDTH'=> 682,
- 'HEIGH'=> 682,
- 'URL'=> 'http://www.monsite.com/pwg/galleries/shared/cat/image.jpg',
- )
- );
-$template->assign_block_vars(
- 'row',
- array(
- 'ID'=> 22,
- 'CAPTION'=> 'L\'image que je veux',
- 'DATE'=> '18/12/2006',
- 'COMMENT'=> 'Voila voili voilou ! Voila voili voilou !',
- )
- );
-?>
|