Subversion Repositories svnkaklik

Rev

Details | Last modification | View Log

Rev Author Line No. Line
6 kaklik 1
<?php
2
// +-----------------------------------------------------------------------+
3
// | PhpWebGallery - a PHP based picture gallery                           |
4
// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
5
// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net |
6
// +-----------------------------------------------------------------------+
7
// | branch        : BSF (Best So Far)
8
// | file          : $RCSfile: category_default.inc.php,v $
9
// | last update   : $Date: 2005/01/07 23:10:51 $
10
// | last modifier : $Author: plg $
11
// | revision      : $Revision: 1.17 $
12
// +-----------------------------------------------------------------------+
13
// | This program is free software; you can redistribute it and/or modify  |
14
// | it under the terms of the GNU General Public License as published by  |
15
// | the Free Software Foundation                                          |
16
// |                                                                       |
17
// | This program is distributed in the hope that it will be useful, but   |
18
// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
19
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
20
// | General Public License for more details.                              |
21
// |                                                                       |
22
// | You should have received a copy of the GNU General Public License     |
23
// | along with this program; if not, write to the Free Software           |
24
// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
25
// | USA.                                                                  |
26
// +-----------------------------------------------------------------------+
27
 
28
/**
29
 * This file is included by category.php to show thumbnails for the default
30
 * case
31
 * 
32
 */
33
 
34
/**
35
 * $array_cat_directories is a cache hash associating category id with their
36
 * complete directory
37
 */
38
$array_cat_directories = array();
39
 
40
$query = '
41
SELECT DISTINCT(id),path,file,date_available
42
       ,tn_ext,name,filesize,storage_category_id,average_rate
43
  FROM '.IMAGES_TABLE.' AS i
44
    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=ic.image_id
45
  '.$page['where'].'
46
  '.$conf['order_by'].'
47
  LIMIT '.$page['start'].','.$page['nb_image_page'].'
48
;';
49
//echo '<pre>'.$query.'</pre>';
50
$result = pwg_query($query);
51
 
52
// template thumbnail initialization
53
if ( mysql_num_rows($result) > 0 )
54
{
55
  $template->assign_block_vars('thumbnails', array());
56
  // first line
57
  $template->assign_block_vars('thumbnails.line', array());
58
  // current row displayed
59
  $row_number = 0;
60
}
61
 
62
while ($row = mysql_fetch_array($result))
63
{
64
  // name of the picture
65
  if (isset($row['name']) and $row['name'] != '')
66
  {
67
    $name = $row['name'];
68
  }
69
  else
70
  {
71
    $name = str_replace('_', ' ', get_filename_wo_extension($row['file']));
72
  }
73
  if ($page['cat'] == 'best_rated')
74
  {
75
    $name = '('.$row['average_rate'].') '.$name;
76
  }
77
 
78
  if ($page['cat'] == 'search')
79
  {
80
    $name = replace_search($name, $_GET['search']);
81
  }
82
 
83
  $thumbnail_url = get_thumbnail_src($row['path'], @$row['tn_ext']);
84
 
85
  // message in title for the thumbnail
86
  $thumbnail_title = $row['file'];
87
  if (isset($row['filesize']))
88
  {
89
    $thumbnail_title .= ' : '.$row['filesize'].' KB';
90
  }
91
  // url link on picture.php page
92
  $url_link = PHPWG_ROOT_PATH.'picture.php?cat='.$page['cat'];
93
  $url_link.= '&amp;image_id='.$row['id'];
94
  if ($page['cat'] == 'search')
95
  {
96
    $url_link.= '&amp;search='.$_GET['search'];
97
  }
98
  else if ($page['cat'] == 'list')
99
  {
100
    $url_link.= '&amp;list='.$_GET['list'];
101
  }
102
 
103
  $template->assign_block_vars(
104
    'thumbnails.line.thumbnail',
105
    array(
106
      'IMAGE'              => $thumbnail_url,
107
      'IMAGE_ALT'          => $row['file'],
108
      'IMAGE_TITLE'        => $thumbnail_title,
109
      'IMAGE_NAME'         => $name,
110
      'IMAGE_TS'           => get_icon($row['date_available']),
111
      'IMAGE_STYLE'        => 'thumb_picture',
112
 
113
      'U_IMG_LINK'         => add_session_id($url_link)
114
      )
115
    );
116
 
117
  if ($user['show_nb_comments']
118
      and is_numeric($page['cat'])
119
      and $page['cat_commentable'])
120
  {
121
    $query = '
122
SELECT COUNT(*) AS nb_comments
123
  FROM '.COMMENTS_TABLE.'
124
  WHERE image_id = '.$row['id'].'
125
    AND validated = \'true\'
126
;';
127
    $row = mysql_fetch_array(pwg_query($query));
128
    $template->assign_block_vars(
129
      'thumbnails.line.thumbnail.nb_comments',
130
      array('NB_COMMENTS'=>$row['nb_comments']));
131
  }
132
 
133
  // create a new line ?
134
  if (++$row_number == $user['nb_image_line'])
135
  {
136
    $template->assign_block_vars('thumbnails.line', array());
137
    $row_number = 0;
138
  }
139
}
140
?>