aboutsummaryrefslogtreecommitdiffstats
path: root/admin/infos_images.php
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2003-05-09 12:42:42 +0000
committerz0rglub <z0rglub@piwigo.org>2003-05-09 12:42:42 +0000
commit867c2379ff66ce0f2c4f872a13027fd649aa076d (patch)
treefd182bca99fc6cfe09a7821fab35ce2629fdab44 /admin/infos_images.php
parentfe51c10474152f319d08229147adbc95fcd6c219 (diff)
Initial revision
git-svn-id: http://piwigo.org/svn/trunk@2 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin/infos_images.php')
-rw-r--r--admin/infos_images.php248
1 files changed, 248 insertions, 0 deletions
diff --git a/admin/infos_images.php b/admin/infos_images.php
new file mode 100644
index 000000000..a5c1b75a4
--- /dev/null
+++ b/admin/infos_images.php
@@ -0,0 +1,248 @@
+<?php
+/***************************************************************************
+ * infos_images.php is a part of PhpWebGallery *
+ * ------------------- *
+ * last update : Wednesday, July 25, 2002 *
+ * email : pierrick@z0rglub.com *
+ * *
+ ***************************************************************************/
+
+/***************************************************************************
+ * *
+ * 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; *
+ * *
+ ***************************************************************************/
+ function check_date_format ( $date )
+ {
+ // la date arrive à ce format : JJ/MM/AAAA
+ // checkdate ( int month, int day, int year)
+ $tab_date = explode( "/", $date );
+ return checkdate ( $tab_date[1], $tab_date[0], $tab_date[2]);
+ }
+
+ function date_convert( $date )
+ {
+ // la date arrive à ce format : JJ/MM/AAAA
+ // il faut la transformer en AAAA-MM-JJ
+ $tab_date = explode( "/", $date );
+ return $tab_date[2]."-".$tab_date[1]."-".$tab_date[0];
+ }
+
+ function date_convert_back( $date )
+ {
+ // la date arrive à ce format : AAAA-MM-JJ
+ // il faut la transformer en JJ/MM/AAAA
+ if ( $date != "" )
+ {
+ $tab_date = explode( "-", $date );
+ return $tab_date[2]."/".$tab_date[1]."/".$tab_date[0];
+ }
+ else
+ {
+ return "";
+ }
+ }
+
+ include_once( "./include/isadmin.inc.php" );
+ $page['nb_image_page'] = 5;
+ check_cat_id( $HTTP_GET_VARS['cat_id'] );
+ if ( isset( $page['cat'] ) )
+ {
+ //------------------------------------------------------------mises à jour
+ // 1. options individuelles
+ $query = "select id,file ";
+ $query.= "from $prefixeTable"."images ";
+ $query.= "where cat_id = ".$page['cat']." ";
+ $result = mysql_query( $query );
+ $i = 1;
+ while ( $row = mysql_fetch_array( $result ) )
+ {
+ $name = "name-".$row['id'];
+ $author = "author-".$row['id'];
+ $comment = "comment-".$row['id'];
+ $date_creation = "date_creation-".$row['id'];
+ if ( isset( $HTTP_POST_VARS[$name] ) )
+ {
+ $query = "update $prefixeTable"."images ";
+ if ( $HTTP_POST_VARS[$name] == "" )
+ {
+ $query.= "set name = NULL ";
+ }
+ else
+ {
+ $query.= "set name = '".htmlspecialchars( $HTTP_POST_VARS[$name], ENT_QUOTES )."' ";
+ }
+ if ( $HTTP_POST_VARS[$author] == "" )
+ {
+ $query.= ", author = NULL ";
+ }
+ else
+ {
+ $query.= ", author = '".htmlspecialchars( $HTTP_POST_VARS[$author], ENT_QUOTES )."' ";
+ }
+ if ( $HTTP_POST_VARS[$comment] == "" )
+ {
+ $query.= ", comment = NULL ";
+ }
+ else
+ {
+ $query.= ", comment = '".htmlspecialchars( $HTTP_POST_VARS[$comment], ENT_QUOTES )."' ";
+ }
+ if ( check_date_format( $HTTP_POST_VARS[$date_creation] ) )
+ {
+ $date = date_convert( $HTTP_POST_VARS[$date_creation] );
+ $query.= ", date_creation = '$date' ";
+ }
+ else if ( $HTTP_POST_VARS[$date_creation] == "" )
+ {
+ $query.= ", date_creation = NULL ";
+ }
+ $query.= "where id = '".$row['id']."';";
+ mysql_query( $query );
+ }
+ }
+ // 2. options générales
+ if ( $HTTP_POST_VARS['use_common_author'] == 1 )
+ {
+ $query = "update $prefixeTable"."images ";
+ if ( $HTTP_POST_VARS['author_cat'] == "" )
+ {
+ $query.= "set author = NULL ";
+ }
+ else
+ {
+ $query.= "set author = '".$HTTP_POST_VARS['author_cat']."' ";
+ }
+ $query.= "where cat_id = ".$page['cat'].";";
+ mysql_query( $query );
+ }
+ if ( $HTTP_POST_VARS['use_common_date_creation'] == 1 )
+ {
+ // la date arrive à ce format : JJ/MM/AAAA
+ // il faut la transformer en AAAA-MM-JJ
+ if ( check_date_format( $HTTP_POST_VARS['date_creation_cat'] ) )
+ {
+ $date = date_convert( $HTTP_POST_VARS['date_creation_cat'] );
+ $query = "update $prefixeTable"."images ";
+ if ( $HTTP_POST_VARS['date_creation_cat'] == "" )
+ {
+ $query.= "set date_creation = NULL ";
+ }
+ else
+ {
+ $query.= "set date_creation = '$date' ";
+ }
+ $query.= "where cat_id = ".$page['cat'].";";
+ mysql_query( $query );
+ }
+ else
+ {
+ echo $lang['infoimage_err_date'];
+ }
+ }
+ //----------------------------------------------------affichage de la page
+ // détection de la page en cours
+ if( !isset( $HTTP_GET_VARS['start'] ) || !is_numeric( $HTTP_GET_VARS['start'] ) || ( is_numeric( $HTTP_GET_VARS['start'] ) && $HTTP_GET_VARS['start'] < 0 ) )
+ {
+ $page['start'] = 0;
+ }
+ else
+ {
+ $page['start'] = $HTTP_GET_VARS['start'];
+ }
+
+ if ( is_numeric( $HTTP_GET_VARS['num'] ) && $HTTP_GET_VARS['num'] >= 0 )
+ {
+ $page['start'] = floor( $HTTP_GET_VARS['num'] / $page['nb_image_page'] ) * $page['nb_image_page'];
+ }
+ // retrieving category information
+ $result = get_cat_info( $page['cat'] );
+ $cat['local_dir'] = $result['local_dir'];
+ $cat['dir'] = $result['dir'];
+ $cat['name'] = $result['name'];
+ $cat['site_id'] = $result['site_id'];
+ $cat['nb_images'] = $result['nb_images'];
+
+ $url = "./admin.php?page=infos_images&amp;cat_id=".$page['cat'];
+ $page['navigation_bar'] = create_navigation_bar( $url, $cat['nb_images'], $page['start'], $page['nb_image_page'], "" );
+ echo"
+ <form method=\"post\" action=\"".add_session_id_to_url( "./admin.php?page=infos_images&amp;cat_id=".$page['cat']."&amp;start=".$page['start'] )."\">
+ <table width=\"100%\">
+ <tr>
+ <th colspan=\"3\">".$lang['infoimage_general']." \"".get_cat_display_name( $cat['name'], " - ", "font-style:italic;" )."\"</th>
+ </tr>
+ <tr>
+ <td><div style=\"margin-left:50px;\">".$lang['author']."</div></td>
+ <td style=\"text-align:center;\"><input type=\"text\" name=\"author_cat\" value=\"\" maxlength=\"255\"/></td>
+ <td style=\"text-align:left;\"><input type=\"checkbox\" name=\"use_common_author\" value=\"1\"/>".$lang['infoimage_useforall']."</td>
+ </tr>
+ <tr>
+ <td><div style=\"margin-left:50px;\">".$lang['infoimage_creation_date']." [DD/MM/YYYY]</div></td>
+ <td style=\"text-align:center;\"><input type=\"text\" name=\"date_creation_cat\" value=\"\" size=\"12\" maxlength=\"10\"/></td>
+ <td style=\"text-align:left;\"><input type=\"checkbox\" name=\"use_common_date_creation\" value=\"1\"/>".$lang['infoimage_useforall']."</td>
+ </tr>
+ </table>";
+ echo"
+ <table width=\"100%\">
+ <tr>
+ <th colspan=\"5\">".$lang['infoimage_detailed']."</th>
+ </tr>
+ <tr>
+ <td colspan=\"5\" align=\"center\">".$page['navigation_bar']."</td>
+ </tr>
+ <tr>
+ <td class=\"row2\" style=\"text-align:center;\">".$lang['thumbnail']."</td>
+ <td class=\"row2\" style=\"text-align:center;\">".$lang['infoimage_title']."</td>
+ <td class=\"row2\" style=\"text-align:center;\">".$lang['author']."</td>
+ <td class=\"row2\" style=\"text-align:center;\">".$lang['infoimage_comment']."</td>
+ <td class=\"row2\" style=\"text-align:center;\">".$lang['infoimage_creation_date']."</td>
+ </tr>";
+ $query = "select id,file,comment,author,tn_ext,name,date_creation";
+ $query.= " from $prefixeTable"."images";
+ $query.= " where cat_id = ".$page['cat'];
+ $query.= $conf['order_by'];
+ $query.= " limit ".$page['start'].",".$page['nb_image_page'];
+ $query.= ";";
+ $result = mysql_query( $query );
+ $i = 1;
+ while ( $row = mysql_fetch_array( $result ) )
+ {
+ echo"
+ <tr>";
+ // création des liens vers la miniature
+ $file = substr ( $row['file'], 0, strrpos ( $row['file'], ".") );
+ if ( $cat['site_id'] == 1 )
+ {
+ $lien_thumbnail = "../galleries/".$cat['local_dir']."/";
+ }
+ else
+ {
+ $lien_thumbnail = $cat['dir'];
+ }
+ $lien_thumbnail.= "thumbnail/".$conf['prefixe_thumbnail'].$file.".".$row['tn_ext'];
+ // création du "style" de la ligne
+ $style = "style=\"text-align:center;\"";
+ if ( $i%2 == 0 )
+ {
+ $style.= " class=\"row2\"";
+ }
+ echo"
+ <td $style><a name=\"".$row['id']."\"><img src=\"$lien_thumbnail\" alt=\"\" class=\"miniature\" title=\"".$row['file']."\"/></td>
+ <td $style>$file<br /><input type=\"text\" name=\"name-".$row['id']."\" value=\"".$row['name']."\" maxlength=\"255\"/></td>
+ <td $style><input type=\"text\" name=\"author-".$row['id']."\" value=\"".$row['author']."\" maxlength=\"255\"/></td>
+ <td $style><textarea name=\"comment-".$row['id']."\" rows=\"3\" cols=\"40\" style=\"overflow:auto\">".$row['comment']."</textarea></td>
+ <td $style><input type=\"text\" name=\"date_creation-".$row['id']."\" value=\"".date_convert_back( $row['date_creation'] )."\" maxlength=\"10\" size=\"12\"/></td>";
+ echo"
+ </tr>";
+ $i++;
+ }
+ echo"
+ <tr>
+ <td colspan=\"5\" style=\"text-align:center;\"><input type=\"submit\" value=\"".$lang['submit']."\"/></td>
+ </tr>
+ </table>
+ </form>";
+ }
+?> \ No newline at end of file