<?php
/***************************************************************************
  *                            update_links.php                             *
  *                            -------------------                          *
  *   application   : PhpWebGallery 1.3                                     *
  *   author        : Pierrick LE GALL <pierrick@z0rglub.com>               *
  *                                                                         *
  ***************************************************************************/

$base_url = 'http://www.phpwebgallery.net/download/templates';
define( PREFIX_INCLUDE, '.' );
include( '../include/functions.inc.php' );
database_connection();

$categories = array( 6 => 'default' );

foreach ( $categories as $cat_id => $dir ) {
  $query = 'SELECT id,file';
  $query.= ' FROM '.PREFIX_TABLE.'images';
  $query.= ' WHERE storage_category_id = '.$cat_id;
  $query.= ';';
  $result = mysql_query( $query );
  while ( $row = mysql_fetch_array( $result ) )
  {
    $filewoext = get_filename_wo_extension( $row['file'] );
    $comment = '<span style="font-size=16px;">';
    $comment.= '[ <a href="'.$base_url.'/'.$dir.'/'.$filewoext.'.zip"';
    $comment.= ' class="download">';
    $comment.= $filewoext.'.zip';
    $comment.= '</a> ]';
    $comment.= '</span>';

    $query = 'UPDATE '.PREFIX_TABLE.'images';
    $query.= " SET comment = '".$comment."'";
    $query.= ' WHERE id = '.$row['id'];
    $query.= ';';
    mysql_query( $query );
  }
}
?>