source: trunk/admin/waiting.php @ 486

<?php
// +-----------------------------------------------------------------------+
// |                              waiting.php                              |
// +-----------------------------------------------------------------------+
// | application   : PhpWebGallery <http://phpwebgallery.net>              |
// | branch        : BSF (Best So Far)                                     |
// +-----------------------------------------------------------------------+
// | file          : $RCSfile$
// | last update   : $Date: 2004-02-11 23:20:38 +0000 (Wed, 11 Feb 2004) $
// | last modifier : $Author: z0rglub $
// | revision      : $Revision: 362 $
// +-----------------------------------------------------------------------+
// | 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.                                                                  |
// +-----------------------------------------------------------------------+
include_once( './admin/include/isadmin.inc.php' );
//--------------------------------------------------------------------- updates
if ( isset( $_POST['submit'] ) )
{
  $query = 'SELECT id,storage_category_id,file,tn_ext';
  $query.= ' FROM '.PREFIX_TABLE.'waiting';
  $query.= " WHERE validated = 'false'";
  $query.= ';';
  $result = mysql_query( $query );
  while ( $row = mysql_fetch_array( $result ) )
  {
    $key = 'validate-'.$row['id'];
    if ( isset( $_POST[$key] ) )
    {
      if ( $_POST[$key] == 'true' )
      {
        // The uploaded element was validated, we have to set the
        // "validated" field to "true"
        $query = 'UPDATE '.PREFIX_TABLE.'waiting';
        $query.= " SET validated = 'true'";
        $query.= ' WHERE id = '.$row['id'];
        $query.= ';';
        mysql_query( $query );
        // linking logically the picture to its storage category
        $query = 'INSERT INTO';
      }
      else
      {
        // The uploaded element was refused, we have to delete its reference
        // in the database and to delete the element as well.
        $query = 'DELETE FROM '.PREFIX_TABLE.'waiting';
        $query.= ' WHERE id = '.$row['id'];
        $query.= ';';
        mysql_query( $query );
        // deletion of the associated files
        $dir = get_complete_dir( $row['storage_category_id'] );
        unlink( '.'.$dir.$row['file'] );
        if ( $row['tn_ext'] != '' )
        {
          $thumbnail = $conf['prefix_thumbnail'];
          $thumbnail.= get_filename_wo_extension( $row['file'] );
          $thumbnail.= '.'.$row['tn_ext'];
          $url = '.'.$dir.'thumbnail/'.$thumbnail;
          unlink( $url );
        }
      }
    }
  }
}
//----------------------------------------------------- template initialization
$sub = $vtp->Open( './template/'.$user['template'].'/admin/waiting.vtp' );
$tpl = array( 'category','date','author','thumbnail','file','delete',
              'submit','waiting_update' );
templatize_array( $tpl, 'lang', $sub );
//-------------------------------------------------------- confirmation message
if ( isset( $_POST['submit'] ) )
{
  $vtp->addSession( $sub, 'confirmation' );
  $vtp->closeSession( $sub, 'confirmation' );
}
//---------------------------------------------------------------- form display
$cat_names = array();
$query = 'SELECT id,storage_category_id,file,username,mail_address';
$query.= ',date,tn_ext';
$query.= ' FROM '.PREFIX_TABLE.'waiting';
$query.= " WHERE validated = 'false'";
$query.= ' ORDER BY storage_category_id';
$query.= ';';
$result = mysql_query( $query );
$i = 0;
while ( $row = mysql_fetch_array( $result ) )
{
  $vtp->addSession( $sub, 'picture' );
  $vtp->setVar( $sub, 'picture.id', $row['id'] );
  if ( $i++ % 2 == 0 )
  {
    $vtp->setVar( $sub, 'picture.class', 'row2' );
  }
  if ( !isset( $cat_names[$row['storage_category_id']] ) )
  {
    $cat = get_cat_info( $row['storage_category_id'] );
    $cat_names[$row['storage_category_id']] = array();
    $cat_names[$row['storage_category_id']]['dir'] =
      '.'.get_complete_dir( $row['storage_category_id'] );
    $cat_names[$row['storage_category_id']]['display_name'] =
      get_cat_display_name( $cat['name'], ' &gt; ', 'font-weight:bold;' );
  }
  // category name
  $vtp->setVar( $sub, 'picture.cat_name',
                $cat_names[$row['storage_category_id']]['display_name'] );
  // date displayed like this (in English ) :
  //                     Sunday 15 June 2003 21:29
  $date = format_date( $row['date'], 'unix', true );
  $vtp->setVar( $sub, 'picture.date', $date );
  // file preview link
  $url = $cat_names[$row['storage_category_id']]['dir'].$row['file'];
  $vtp->setVar( $sub, 'picture.preview_url', $url );
  // file name
  $vtp->setVar( $sub, 'picture.file', $row['file'] );
  // is there an existing associated thumnail ?
  if ( isset( $row['tn_ext'] ) and $row['tn_ext'] != '' )
  {
    $vtp->addSession( $sub, 'thumbnail' );
    $thumbnail = $conf['prefix_thumbnail'];
    $thumbnail.= get_filename_wo_extension( $row['file'] );
    $thumbnail.= '.'.$row['tn_ext'];
    $url = $cat_names[$row['storage_category_id']]['dir'];
    $url.= 'thumbnail/'.$thumbnail;
    $vtp->setVar( $sub, 'thumbnail.preview_url', $url );
    $vtp->setVar( $sub, 'thumbnail.file', $thumbnail );
    $vtp->closeSession( $sub, 'thumbnail' );
  }
  else
  {
    $vtp->addSession( $sub, 'no_thumbnail' );
    $vtp->closeSession( $sub, 'no_thumbnail' );
  }
  // username and associated mail address
  $vtp->setVar( $sub, 'picture.mail_address', $row['mail_address'] );
  $vtp->setVar( $sub, 'picture.username', $row['username'] );

  $vtp->closeSession( $sub, 'picture' );
}
//----------------------------------------------------------- sending html code
$vtp->Parse( $handle , 'sub', $sub );
?>