Subversion Repositories svnkaklik

<?php

// +-----------------------------------------------------------------------+

// | PhpWebGallery - a PHP based picture gallery                           |

// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |

// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net |

// +-----------------------------------------------------------------------+

// | branch        : BSF (Best So Far)

// | file          : $RCSfile: category_default.inc.php,v $

// | last update   : $Date: 2005/01/07 23:10:51 $

// | last modifier : $Author: plg $

// | revision      : $Revision: 1.17 $

// +-----------------------------------------------------------------------+

// | This program is free software; you can redistribute it and/or modify  |

// | it under the terms of the GNU General Public License as published by  |

// | the Free Software Foundation                                          |

// |                                                                       |

// | This program is distributed in the hope that it will be useful, but   |

// | WITHOUT ANY WARRANTY; without even the implied warranty of            |

// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |

// | General Public License for more details.                              |

// |                                                                       |

// | You should have received a copy of the GNU General Public License     |

// | along with this program; if not, write to the Free Software           |

// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |

// | USA.                                                                  |

// +-----------------------------------------------------------------------+

/**

 * This file is included by category.php to show thumbnails for the default

 * case

 * 

 */

/**

 * $array_cat_directories is a cache hash associating category id with their

 * complete directory

 */

$array_cat_directories = array();

$query = '

SELECT DISTINCT(id),path,file,date_available

       ,tn_ext,name,filesize,storage_category_id,average_rate

  FROM '.IMAGES_TABLE.' AS i

    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=ic.image_id

  '.$page['where'].'

  '.$conf['order_by'].'

  LIMIT '.$page['start'].','.$page['nb_image_page'].'

;';

//echo '<pre>'.$query.'</pre>';

$result = pwg_query($query);

// template thumbnail initialization

if ( mysql_num_rows($result) > 0 )

{

  $template->assign_block_vars('thumbnails', array());

  // first line

  $template->assign_block_vars('thumbnails.line', array());

  // current row displayed

  $row_number = 0;

}

while ($row = mysql_fetch_array($result))

{

  // name of the picture

  if (isset($row['name']) and $row['name'] != '')

  {

    $name = $row['name'];

  }

  else

  {

    $name = str_replace('_', ' ', get_filename_wo_extension($row['file']));

  }

  if ($page['cat'] == 'best_rated')

  {

    $name = '('.$row['average_rate'].') '.$name;

  }

  if ($page['cat'] == 'search')

  {

    $name = replace_search($name, $_GET['search']);

  }

  $thumbnail_url = get_thumbnail_src($row['path'], @$row['tn_ext']);

  // message in title for the thumbnail

  $thumbnail_title = $row['file'];

  if (isset($row['filesize']))

  {

    $thumbnail_title .= ' : '.$row['filesize'].' KB';

  }

  // url link on picture.php page

  $url_link = PHPWG_ROOT_PATH.'picture.php?cat='.$page['cat'];

  $url_link.= '&image_id='.$row['id'];

  if ($page['cat'] == 'search')

  {

    $url_link.= '&search='.$_GET['search'];

  }

  else if ($page['cat'] == 'list')

  {

    $url_link.= '&list='.$_GET['list'];

  }

  $template->assign_block_vars(

    'thumbnails.line.thumbnail',

    array(

      'IMAGE'              => $thumbnail_url,

      'IMAGE_ALT'          => $row['file'],

      'IMAGE_TITLE'        => $thumbnail_title,

      'IMAGE_NAME'         => $name,

      'IMAGE_TS'           => get_icon($row['date_available']),

      'IMAGE_STYLE'        => 'thumb_picture',

      'U_IMG_LINK'         => add_session_id($url_link)

      )

    );

  if ($user['show_nb_comments']

      and is_numeric($page['cat'])

      and $page['cat_commentable'])

  {

    $query = '

SELECT COUNT(*) AS nb_comments

  FROM '.COMMENTS_TABLE.'

  WHERE image_id = '.$row['id'].'

    AND validated = \'true\'

;';

    $row = mysql_fetch_array(pwg_query($query));

    $template->assign_block_vars(

      'thumbnails.line.thumbnail.nb_comments',

      array('NB_COMMENTS'=>$row['nb_comments']));

  }

  // create a new line ?

  if (++$row_number == $user['nb_image_line'])

  {

    $template->assign_block_vars('thumbnails.line', array());

    $row_number = 0;

  }

}

?>