aboutsummaryrefslogtreecommitdiffstats
path: root/admin
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2003-05-17 10:49:14 +0000
committerz0rglub <z0rglub@piwigo.org>2003-05-17 10:49:14 +0000
commit8b044b0111a9a22066b82a33c28f956981819f55 (patch)
treec4ed5d300daf64788042b94681893e95b241e46c /admin
parentb7b705f2685da04caa0be91debc2c66d279fddf5 (diff)
*** empty log message ***
git-svn-id: http://piwigo.org/svn/trunk@10 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin')
-rw-r--r--admin/admin.php6
-rw-r--r--admin/cat.php37
-rw-r--r--admin/configuration.php41
-rw-r--r--admin/create_listing_file.php280
-rw-r--r--admin/edit_cat.php8
-rw-r--r--admin/historique.php6
-rw-r--r--admin/infos_images.php10
-rw-r--r--admin/install.php442
-rw-r--r--admin/perm.php20
-rw-r--r--admin/update.php575
-rw-r--r--admin/user_add.php2
-rw-r--r--admin/user_list.php8
-rw-r--r--admin/user_modify.php4
-rw-r--r--admin/waiting.php6
14 files changed, 1025 insertions, 420 deletions
diff --git a/admin/admin.php b/admin/admin.php
index a4c8b77c3..5730356fe 100644
--- a/admin/admin.php
+++ b/admin/admin.php
@@ -35,7 +35,7 @@ switch ( $_GET['page'] )
$titre = $lang['title_modify']; $page_valide = true; break;
case 'historique':
$titre = $lang['title_history']; $page_valide = true; break;
- case 'miseajour':
+ case 'update':
$titre = $lang['title_update']; $page_valide = true; break;
case 'configuration':
$titre = $lang['title_configuration']; $page_valide = true; break;
@@ -115,7 +115,7 @@ $vtp->addSession( $handle, 'summary' );
$vtp->setVar( $handle, 'summary.indent', '' );
$vtp->setVar( $handle, 'summary.link',
add_session_id( $link_start.'waiting' ) );
-$query = 'select id from '.$prefixeTable.'waiting;';
+$query = 'select id from '.PREFIX_TABLE.'waiting;';
$result = mysql_query( $query );
$nb_waiting = '';
if ( mysql_num_rows( $result ) > 0 )
@@ -128,7 +128,7 @@ $vtp->closeSession( $handle, 'summary' );
$vtp->addSession( $handle, 'summary' );
$vtp->setVar( $handle, 'summary.indent', '' );
$vtp->setVar( $handle, 'summary.link',
- add_session_id( $link_start.'miseajour' ) );
+ add_session_id( $link_start.'update' ) );
$vtp->setVar( $handle, 'summary.name', $lang['menu_update'] );
$vtp->closeSession( $handle, 'summary' );
// thumbnails
diff --git a/admin/cat.php b/admin/cat.php
index 2033d667d..890fa866a 100644
--- a/admin/cat.php
+++ b/admin/cat.php
@@ -1,11 +1,10 @@
<?php
/***************************************************************************
- * this file is a part of PhpWebGallery *
+ * cat.php *
* ------------------- *
- * version : 1.3 *
- * url : http://phpwebgallery.net *
- * help : http://forum.phpwebgallery.net *
- * author : Pierrick LE GALL *
+ * application : PhpWebGallery 1.3 *
+ * website : http://www.phpwebgallery.net *
+ * author : Pierrick LE GALL <pierrick@z0rglub.com> *
* *
***************************************************************************/
@@ -32,7 +31,7 @@ if ( isset( $_GET['up'] ) && is_numeric( $_GET['up'] ) )
// 1. searching level (id_uppercat)
// and rank of the category to move
$query = 'select id_uppercat,rank';
- $query.= ' from '.$prefixeTable.'categories';
+ $query.= ' from '.PREFIX_TABLE.'categories';
$query.= ' where id = '.$_GET['up'];
$query.= ';';
$row = mysql_fetch_array( mysql_query( $query ) );
@@ -41,7 +40,7 @@ if ( isset( $_GET['up'] ) && is_numeric( $_GET['up'] ) )
// 2. searching the id and the rank of the category
// just above at the same level
$query = 'select id,rank';
- $query.= ' from '.$prefixeTable.'categories';
+ $query.= ' from '.PREFIX_TABLE.'categories';
$query.= ' where rank < '.$rank;
if ( $level == '' )
{
@@ -58,12 +57,12 @@ if ( isset( $_GET['up'] ) && is_numeric( $_GET['up'] ) )
$new_rank = $row['rank'];
$replaced_cat = $row['id'];
// 3. exchanging ranks between the two categories
- $query = 'update '.$prefixeTable.'categories';
+ $query = 'update '.PREFIX_TABLE.'categories';
$query.= ' set rank = '.$new_rank;
$query.= ' where id = '.$_GET['up'];
$query.= ';';
mysql_query( $query );
- $query = 'update '.$prefixeTable.'categories';
+ $query = 'update '.PREFIX_TABLE.'categories';
$query.= ' set rank = '.$rank;
$query.= ' where id = '.$replaced_cat;
$query.= ';';
@@ -74,7 +73,7 @@ if ( isset( $_GET['down'] ) && is_numeric( $_GET['down'] ) )
// 1. searching level (id_uppercat)
// and rank of the category to move
$query = 'select id_uppercat,rank';
- $query.= ' from '.$prefixeTable.'categories';
+ $query.= ' from '.PREFIX_TABLE.'categories';
$query.= ' where id = '.$_GET['down'];
$query.= ';';
$row = mysql_fetch_array( mysql_query( $query ) );
@@ -83,7 +82,7 @@ if ( isset( $_GET['down'] ) && is_numeric( $_GET['down'] ) )
// 2. searching the id and the rank of the category
// just below at the same level
$query = 'select id,rank';
- $query.= ' from '.$prefixeTable.'categories';
+ $query.= ' from '.PREFIX_TABLE.'categories';
$query.= ' where rank > '.$rank;
if ( $level == '' )
{
@@ -100,12 +99,12 @@ if ( isset( $_GET['down'] ) && is_numeric( $_GET['down'] ) )
$new_rank = $row['rank'];
$replaced_cat = $row['id'];
// 3. exchanging ranks between the two categories
- $query = 'update '.$prefixeTable.'categories';
+ $query = 'update '.PREFIX_TABLE.'categories';
$query.= ' set rank = '.$new_rank;
$query.= ' where id = '.$_GET['down'];
$query.= ';';
mysql_query( $query );
- $query = 'update '.$prefixeTable.'categories';
+ $query = 'update '.PREFIX_TABLE.'categories';
$query.= ' set rank = '.$rank;
$query.= ' where id = '.$replaced_cat;
$query.= ';';
@@ -114,12 +113,10 @@ if ( isset( $_GET['down'] ) && is_numeric( $_GET['down'] ) )
//------------------------------------------------------------------ reordering
function ordering( $id_uppercat )
{
- global $prefixeTable;
-
$rank = 1;
$query = 'select id';
- $query.= ' from '.$prefixeTable.'categories';
+ $query.= ' from '.PREFIX_TABLE.'categories';
if ( !is_numeric( $id_uppercat ) )
{
$query.= ' where id_uppercat is NULL';
@@ -133,7 +130,7 @@ function ordering( $id_uppercat )
$result = mysql_query( $query );
while ( $row = mysql_fetch_array( $result ) )
{
- $query = 'update '.$prefixeTable.'categories';
+ $query = 'update '.PREFIX_TABLE.'categories';
$query.= ' set rank = '.$rank;
$query.= ' where id = '.$row['id'];
$query.= ';';
@@ -148,11 +145,11 @@ ordering( 'NULL' );
function display_cat_manager( $id_uppercat, $indent,
$uppercat_visible, $level )
{
- global $prefixeTable,$lang,$conf,$sub,$vtp;
+ global $lang,$conf,$sub,$vtp;
// searching the min_rank and the max_rank of the category
$query = 'select min(rank) as min, max(rank) as max';
- $query.= ' from '.$prefixeTable.'categories';
+ $query.= ' from '.PREFIX_TABLE.'categories';
if ( !is_numeric( $id_uppercat ) )
{
$query.= ' where id_uppercat is NULL';
@@ -180,7 +177,7 @@ function display_cat_manager( $id_uppercat, $indent,
}
$query = 'select id,name,dir,nb_images,status,rank,site_id';
- $query.= ' from '.$prefixeTable.'categories';
+ $query.= ' from '.PREFIX_TABLE.'categories';
if ( !is_numeric( $id_uppercat ) )
{
$query.= ' where id_uppercat is NULL';
diff --git a/admin/configuration.php b/admin/configuration.php
index d0d4a6fc5..75be943db 100644
--- a/admin/configuration.php
+++ b/admin/configuration.php
@@ -3,6 +3,7 @@
* configuration.php *
* ------------------- *
* application : PhpWebGallery 1.3 *
+ * website : http://www.phpwebgallery.net *
* author : Pierrick LE GALL <pierrick@z0rglub.com> *
* *
***************************************************************************/
@@ -34,17 +35,16 @@ $Caracs = array("¥" => "Y", "µ" => "u", "À" => "A", "Á" => "A",
"ù" => "u", "ú" => "u", "û" => "u", "ü" => "u",
"ý" => "y", "ÿ" => "y");
//------------------------------ verification and registration of modifications
-$conf_infos = array( 'prefixe_thumbnail', 'webmaster', 'mail_webmaster',
- 'acces', 'session_id_size', 'session_time',
- 'session_keyword', 'max_user_listbox', 'show_comments',
- 'nb_comment_page', 'upload_available',
- 'upload_maxfilesize', 'upload_maxwidth',
- 'upload_maxheight', 'upload_maxwidth_thumbnail',
- 'upload_maxheight_thumbnail' );
-$default_user_infos = array( 'nb_image_line', 'nb_line_page', 'theme',
- 'language', 'maxwidth', 'maxheight', 'expand',
- 'show_nb_comments', 'short_period', 'long_period',
- 'template' );
+$conf_infos =
+array( 'prefixe_thumbnail','webmaster','mail_webmaster','acces',
+ 'session_id_size','session_time','session_keyword','max_user_listbox',
+ 'show_comments','nb_comment_page','upload_available',
+ 'upload_maxfilesize', 'upload_maxwidth','upload_maxheight',
+ 'upload_maxwidth_thumbnail','upload_maxheight_thumbnail' );
+$default_user_infos =
+array( 'nb_image_line','nb_line_page','theme','language','maxwidth',
+ 'maxheight','expand','show_nb_comments','short_period','long_period',
+ 'template' );
$error = array();
$i = 0;
if ( $_GET['valider'] == 1 )
@@ -52,13 +52,13 @@ if ( $_GET['valider'] == 1 )
//purge de la table des session si demandé
if ( $_POST['empty_session_table'] == 1 )
{
- $query = 'delete from '.$prefixeTable.'sessions';
+ $query = 'delete from '.PREFIX_TABLE.'sessions';
$query.= ' where expiration < '.time().';';
mysql_query( $query );
}
// deletion of site as asked
$query = 'select id';
- $query.= ' from '.$prefixeTable.'sites';
+ $query.= ' from '.PREFIX_TABLE.'sites';
$query.= " where galleries_url <> './galleries/';";
$result = mysql_query( $query );
while ( $row = mysql_fetch_array( $result ) )
@@ -182,8 +182,8 @@ if ( $_GET['valider'] == 1 )
// dans le cas où il n'y aucune erreurs
if ( sizeof( $error ) == 0 )
{
- mysql_query( 'delete from '.$prefixeTable.'config;' );
- $query = 'insert into '.$prefixeTable.'config';
+ mysql_query( 'delete from '.PREFIX_TABLE.'config;' );
+ $query = 'insert into '.PREFIX_TABLE.'config';
$query.= ' (';
for ( $i = 0; $i < sizeof( $conf_infos ); $i++ )
{
@@ -219,7 +219,7 @@ if ( $_GET['valider'] == 1 )
$tab_theme = explode( ' - ', $_POST['theme'] );
$_POST['theme'] = $tab_theme[0].'/'.$tab_theme[1];
- $query = 'update '.$prefixeTable.'users';
+ $query = 'update '.PREFIX_TABLE.'users';
$query.= ' set';
for ( $i = 0; $i < sizeof( $default_user_infos ); $i++ )
{
@@ -271,7 +271,7 @@ else
}
$query.= $conf_infos[$i];
}
- $query .= ' from '.$prefixeTable.'config;';
+ $query .= ' from '.PREFIX_TABLE.'config;';
$row = mysql_fetch_array( mysql_query( $query ) );
@@ -292,7 +292,7 @@ else
}
$query.= $default_user_infos[$i];
}
- $query .= ' from '.$prefixeTable.'users';
+ $query .= ' from '.PREFIX_TABLE.'users';
$query.= " where username = 'guest'";
$query.= ';';
@@ -308,8 +308,7 @@ $sub = $vtp->Open( '../template/'.$user['template'].
'/admin/configuration.vtp' );
// language
$vtp->setGlobalVar( $sub, 'conf_confirmation', $lang['conf_confirmation'] );
-$vtp->setGlobalVar( $sub, 'conf_remote_site_title',
- $lang['conf_remote_site_title'] );
+$vtp->setGlobalVar( $sub, 'remote_site', $lang['remote_site'] );
$vtp->setGlobalVar( $sub, 'delete', $lang['delete'] );
$vtp->setGlobalVar( $sub, 'conf_remote_site_delete_info',
$lang['conf_remote_site_delete_info'] );
@@ -885,7 +884,7 @@ $vtp->closeSession( $sub, 'space_line' );
$vtp->closeSession( $sub, 'line' );
//------------------------------------------------ remote sites administration
$query = 'select id,galleries_url';
-$query.= ' from '.$prefixeTable.'sites';
+$query.= ' from '.PREFIX_TABLE.'sites';
$query.= " where galleries_url <> './galleries/';";
$result = mysql_query( $query );
if ( mysql_num_rows( $result ) > 0 )
diff --git a/admin/create_listing_file.php b/admin/create_listing_file.php
index 9b94486ef..f3b816bbc 100644
--- a/admin/create_listing_file.php
+++ b/admin/create_listing_file.php
@@ -1,128 +1,162 @@
<?php
- $prefixe_thumbnail = "TN-";
+$prefixe_thumbnail = 'TN-';
-
- $tab_ext = array ( 'jpg', 'JPG','gif','GIF','png','PNG' );
+$conf['picture_ext'] = array ( 'jpg', 'gif', 'png', 'JPG', 'GIF', 'PNG' );
- $listing = "";
-
- $local_folder = substr( $PHP_SELF, 0, strrpos( $PHP_SELF, "/" ) + 1 );
- $url = "http://".$HTTP_HOST.$local_folder;
- $listing.= "<url>$url</url>";
-
- // get_dirs retourne un tableau contenant tous les sous-répertoires d'un répertoire
- function get_dirs( $rep, $indent, $level )
- {
- $sub_rep = array();
- $i = 0;
- $dirs = "";
- if ( $opendir = opendir ( $rep ) )
- {
- while ( $file = readdir ( $opendir ) )
- {
- if ( $file != "." && $file != ".." && is_dir ( $rep."/".$file ) && $file != "thumbnail" )
- {
- $sub_rep[$i++] = $file;
- }
- }
- }
- // write of the dirs
- for ( $i = 0; $i < sizeof( $sub_rep ); $i++ )
- {
- $dirs.= "\n".$indent."<dir".$level.">";
- $dirs.= "\n".$indent."\t<name>".$sub_rep[$i]."</name>";
- $dirs.= get_pictures( $rep."/".$sub_rep[$i], $indent."\t" );
- $dirs.= get_dirs( $rep."/".$sub_rep[$i], $indent."\t", $level + 1 );
- $dirs.= "\n".$indent."</dir".$level.">";
- }
- return $dirs;
- }
-
- function is_image ( $filename )
- {
- global $tab_ext;
- if ( in_array ( substr ( strrchr($filename,"."), 1, strlen ( $filename ) ), $tab_ext ) )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
+$listing = '';
+
+$end = strrpos( $_SERVER['PHP_SELF'], '/' ) + 1;
+$local_folder = substr( $_SERVER['PHP_SELF'], 0, $end );
+$url = 'http://'.$_SERVER['HTTP_HOST'].$local_folder;
+
+$listing.= "<url>$url</url>";
- function TN_exist ( $dir, $file )
- {
- global $tab_ext, $prefixe_thumbnail;
-
- $titre = substr ( $file, 0, -4 );
- for ( $i = 0; $i < sizeof ( $tab_ext ); $i++ )
- {
- $test = $dir."/thumbnail/".$prefixe_thumbnail.$titre.".".$tab_ext[$i];
- if ( is_file ( $test ) )
- {
- return $tab_ext[$i];
- }
- }
- return false;
- }
-
- function get_pictures( $rep, $indent )
- {
- $pictures = array();
- $i = 0;
- $tn_ext = "";
- $root = "";
- if ( $opendir = opendir ( $rep ) )
- {
- while ( $file = readdir ( $opendir ) )
- {
- if ( is_image( $file ) && $tn_ext = TN_exist( $rep, $file ) )
- {
- $pictures[$i] = array();
- $pictures[$i]['file'] = $file;
- $pictures[$i]['tn_ext'] = $tn_ext;
- $pictures[$i]['date'] = date( "Y-m-d", filemtime ( $rep."/".$file ) );
- $pictures[$i]['filesize'] = floor ( filesize( $rep."/".$file ) / 1024 );
- $image_size = @getimagesize( $rep."/".$file );
- $pictures[$i]['width'] = $image_size[0];
- $pictures[$i]['height'] = $image_size[1];
- $i++;
- }
- }
- }
- // write of the node <root> with all the pictures at the root of the directory
- $root.= "\n".$indent."<root>";
- if ( sizeof( $pictures ) > 0 )
- {
- for( $i = 0; $i < sizeof( $pictures ); $i++ )
- {
- $root.= "\n".$indent."\t<picture>";
- $root.= "\n".$indent."\t\t<file>".$pictures[$i]['file']."</file>";
- $root.= "\n".$indent."\t\t<tn_ext>".$pictures[$i]['tn_ext']."</tn_ext>";
- $root.= "\n".$indent."\t\t<date>".$pictures[$i]['date']."</date>";
- $root.= "\n".$indent."\t\t<filesize>".$pictures[$i]['filesize']."</filesize>";
- $root.= "\n".$indent."\t\t<width>".$pictures[$i]['width']."</width>";
- $root.= "\n".$indent."\t\t<height>".$pictures[$i]['height']."</height>";
- $root.= "\n".$indent."\t</picture>";
- }
- }
- $root.= "\n".$indent."</root>";
- return $root;
- }
-
- $listing.= get_dirs( ".", "", 0 );
-
- if ( $fp = @fopen("./listing.xml","w") )
- {
- fwrite( $fp, $listing );
- fclose( $fp );
- }
- else
- {
- echo "impossible de créer ou d'écrire dans le fichier listing.xml";
- }
-
- //echo str_replace( "\t", "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", nl2br( htmlspecialchars( $listing, ENT_QUOTES ) ) );
- echo "listing.xml created";
+// get_dirs retourne un tableau contenant tous les sous-répertoires d'un
+// répertoire
+function get_dirs( $rep, $indent, $level )
+{
+ $sub_rep = array();
+ $i = 0;
+ $dirs = "";
+ if ( $opendir = opendir ( $rep ) )
+ {
+ while ( $file = readdir ( $opendir ) )
+ {
+ if ( $file != "."
+ and $file != ".."
+ and is_dir ( $rep."/".$file )
+ and $file != "thumbnail" )
+ {
+ $sub_rep[$i++] = $file;
+ }
+ }
+ }
+ // write of the dirs
+ for ( $i = 0; $i < sizeof( $sub_rep ); $i++ )
+ {
+ $dirs.= "\n".$indent.'<dir'.$level.' name="'.$sub_rep[$i].'">';
+ $dirs.= get_pictures( $rep.'/'.$sub_rep[$i], $indent.' ' );
+ $dirs.= get_dirs( $rep.'/'.$sub_rep[$i], $indent.' ', $level + 1 );
+ $dirs.= "\n".$indent.'</dir'.$level.'>';
+ }
+ return $dirs;
+}
+
+// get_extension returns the part of the string after the last "."
+function get_extension( $filename )
+{
+ return substr( strrchr( $filename, '.' ), 1, strlen ( $filename ) );
+}
+
+// get_filename_wo_extension returns the part of the string before the last
+// ".".
+// get_filename_wo_extension( 'test.tar.gz' ) -> 'test.tar'
+function get_filename_wo_extension( $filename )
+{
+ return substr( $filename, 0, strrpos( $filename, '.' ) );
+}
+
+function is_image( $filename )
+{
+ global $conf;
+
+ if ( !is_dir( $filename )
+ and in_array( get_extension( $filename ), $conf['picture_ext'] ) )
+ {
+ return true;
+ }
+ return false;
+}
+
+function TN_exists( $dir, $file )
+{
+ global $conf, $prefixe_thumbnail;
+
+ $titre = get_filename_wo_extension( $file );
+
+ for ( $i = 0; $i < sizeof ( $conf['picture_ext'] ); $i++ )
+ {
+ $base_tn_name = $dir.'/thumbnail/'.$prefixe_thumbnail.$titre.'.';
+ $ext = $conf['picture_ext'][$i];
+ if ( is_file( $base_tn_name.$ext ) )
+ {
+ return $ext;
+ }
+ }
+ echo 'The thumbnail is missing for '.$dir.'/'.$file;
+ echo '-> '.$dir.'/thumbnail/'.$prefixe_thumbnail.$titre.'.xxx';
+ echo ' ("xxx" can be : ';
+ for ( $i = 0; $i < sizeof ( $conf['picture_ext'] ); $i++ )
+ {
+ if ( $i > 0 )
+ {
+ echo ', ';
+ }
+ echo '"'.$conf['picture_ext'][$i].'"';
+ }
+ echo ')<br />';
+ return false;
+}
+
+function get_pictures( $rep, $indent )
+{
+ $pictures = array();
+
+ $tn_ext = '';
+ $root = '';
+ if ( $opendir = opendir ( $rep ) )
+ {
+ while ( $file = readdir ( $opendir ) )
+ {
+ if ( is_image( $file ) and $tn_ext = TN_exists( $rep, $file ) )
+ {
+ $picture = array();
+
+ $picture['file'] = $file;
+ $picture['tn_ext'] = $tn_ext;
+ $picture['date'] = date('Y-m-d',filemtime( $rep.'/'.$file ) );
+ $picture['filesize'] = floor( filesize( $rep."/".$file ) / 1024 );
+ $image_size = @getimagesize( $rep."/".$file );
+ $picture['width'] = $image_size[0];
+ $picture['height'] = $image_size[1];
+
+ array_push( $pictures, $picture );
+ }
+ }
+ }
+ // write of the node <root> with all the pictures at the root of the
+ // directory
+ $root.= "\n".$indent."<root>";
+ if ( sizeof( $pictures ) > 0 )
+ {
+ for( $i = 0; $i < sizeof( $pictures ); $i++ )
+ {
+ $root.= "\n".$indent.' ';
+ $root.= '<picture';
+ $root.= ' file="'. $pictures[$i]['file']. '"';
+ $root.= ' tn_ext="'. $pictures[$i]['tn_ext']. '"';
+ $root.= ' date="'. $pictures[$i]['date']. '"';
+ $root.= ' filesize="'. $pictures[$i]['filesize']. '"';
+ $root.= ' width="'. $pictures[$i]['width']. '"';
+ $root.= ' height="'. $pictures[$i]['height']. '"';
+ $root.= ' />';
+ }
+ }
+ $root.= "\n".$indent.'</root>';
+ return $root;
+}
+
+$listing.= get_dirs( '.', '', 0 );
+
+if ( $fp = @fopen("./listing.xml","w") )
+{
+ fwrite( $fp, $listing );
+ fclose( $fp );
+}
+else
+{
+ echo "I can't write the file listing.xml";
+}
+
+echo "listing.xml created";
?> \ No newline at end of file
diff --git a/admin/edit_cat.php b/admin/edit_cat.php
index ae93521c0..c813bac66 100644
--- a/admin/edit_cat.php
+++ b/admin/edit_cat.php
@@ -18,7 +18,7 @@
if ( $HTTP_GET_VARS['valider'] == 1 )
{
- $query = "update $prefixeTable"."categories ";
+ $query = "update PREFIX_TABLE"."categories ";
if ( $HTTP_POST_VARS['name'] == "" )
{
$query.= "set name = NULL, ";
@@ -39,7 +39,7 @@
$query.= "where id = '".$HTTP_GET_VARS['cat']."';";
mysql_query( $query );
- $result = mysql_query( "select id from $prefixeTable"."users where pseudo != '".$conf['webmaster']."';" );
+ $result = mysql_query( "select id from PREFIX_TABLE"."users where pseudo != '".$conf['webmaster']."';" );
while ( $row = mysql_fetch_array ( $result ) )
{
check_favorites( $row['id'] );
@@ -52,7 +52,7 @@
<form action=\"".add_session_id_to_url( "./admin.php?page=edit_cat&amp;cat=".$HTTP_GET_VARS['cat']."&amp;valider=1" )."\" method=\"post\">
<table style=\"width:100%;\">";
$query = "select a.id,name,dir,status,comment,id_uppercat,site_id,galleries_url";
- $query.= " from $prefixeTable"."categories as a, $prefixeTable"."sites as b";
+ $query.= " from PREFIX_TABLE"."categories as a, PREFIX_TABLE"."sites as b";
$query.= " where a.id = ".$HTTP_GET_VARS['cat'];
$query.= " and a.site_id = b.id;";
$row = mysql_fetch_array( mysql_query( $query ) );
@@ -86,7 +86,7 @@
// on récupère toutes les status possibles dans la base
// par l'intermédiaire de la fonction get_enums trouvable
// dans le fichier config.php
- $option = get_enums( $prefixeTable."categories", "status" );
+ $option = get_enums( PREFIX_TABLE."categories", "status" );
for ( $i = 0; $i < sizeof( $option ); $i++ )
{
if ( $option[$i] == $row['status'] )
diff --git a/admin/historique.php b/admin/historique.php
index 2aca5bfc1..eda2b1b27 100644
--- a/admin/historique.php
+++ b/admin/historique.php
@@ -18,7 +18,7 @@
if ( $HTTP_GET_VARS['empty'] == 1 )
{
- mysql_query( "delete from $prefixeTable"."history;" );
+ mysql_query( "delete from PREFIX_TABLE"."history;" );
}
define (NB_JOUR_HISTO,"7");
$tMois = array("janvier", "février", "mars", "avril", "mai", "juin", "juillet", "août", "septembre", "octobre", "novembre", "décembre");
@@ -28,7 +28,7 @@
// il faut trouver le unix date de la veille à 00h00 :
// time (); nous donne le nombre de secondes actuelle
$date_ref = time() - (7*24*60*60);
- $result = mysql_query( "select date,login,IP,categorie,page,titre,commentaire from $prefixeTable"."history where date > '$date_ref' order by date desc;");
+ $result = mysql_query( "select date,login,IP,categorie,page,titre,commentaire from PREFIX_TABLE"."history where date > '$date_ref' order by date desc;");
echo"<div style=\"text-align:center;\"><a href=\"".add_session_id_to_url( "./admin.php?page=historique&amp;empty=1" )."\">empty / vider</a></div>";
echo"<div style=\"color:green;text-align:center;margin:10px\">";
// affichage de la date du jour
@@ -71,7 +71,7 @@
</tr>";
// 2. affichage de tous les évènements pour le jour donné
// entre la veille à 23h59m59s et le jour même 23h59m59s
- $result = mysql_query("select date,login,IP,categorie,page,titre,commentaire from $prefixeTable"."history where date > '$debut' and date < '$fin' order by date desc;");
+ $result = mysql_query("select date,login,IP,categorie,page,titre,commentaire from PREFIX_TABLE"."history where date > '$debut' and date < '$fin' order by date desc;");
$fin = $debut;
// on recule le début d'une journée complète
$debut = $debut - 24*60*60;
diff --git a/admin/infos_images.php b/admin/infos_images.php
index a5c1b75a4..f1921c6d3 100644
--- a/admin/infos_images.php
+++ b/admin/infos_images.php
@@ -53,7 +53,7 @@
//------------------------------------------------------------mises à jour
// 1. options individuelles
$query = "select id,file ";
- $query.= "from $prefixeTable"."images ";
+ $query.= "from PREFIX_TABLE"."images ";
$query.= "where cat_id = ".$page['cat']." ";
$result = mysql_query( $query );
$i = 1;
@@ -65,7 +65,7 @@
$date_creation = "date_creation-".$row['id'];
if ( isset( $HTTP_POST_VARS[$name] ) )
{
- $query = "update $prefixeTable"."images ";
+ $query = "update PREFIX_TABLE"."images ";
if ( $HTTP_POST_VARS[$name] == "" )
{
$query.= "set name = NULL ";
@@ -106,7 +106,7 @@
// 2. options générales
if ( $HTTP_POST_VARS['use_common_author'] == 1 )
{
- $query = "update $prefixeTable"."images ";
+ $query = "update PREFIX_TABLE"."images ";
if ( $HTTP_POST_VARS['author_cat'] == "" )
{
$query.= "set author = NULL ";
@@ -125,7 +125,7 @@
if ( check_date_format( $HTTP_POST_VARS['date_creation_cat'] ) )
{
$date = date_convert( $HTTP_POST_VARS['date_creation_cat'] );
- $query = "update $prefixeTable"."images ";
+ $query = "update PREFIX_TABLE"."images ";
if ( $HTTP_POST_VARS['date_creation_cat'] == "" )
{
$query.= "set date_creation = NULL ";
@@ -200,7 +200,7 @@
<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.= " from PREFIX_TABLE"."images";
$query.= " where cat_id = ".$page['cat'];
$query.= $conf['order_by'];
$query.= " limit ".$page['start'].",".$page['nb_image_page'];
diff --git a/admin/install.php b/admin/install.php
index c87a63bbd..00058365f 100644
--- a/admin/install.php
+++ b/admin/install.php
@@ -14,9 +14,9 @@
* the Free Software Foundation; *
* *
***************************************************************************/
- function header_install()
- {
- $output = "
+function header_install()
+{
+ $output = "
<html>
<head>
<title>PhpWebGallery 1.2</title>
@@ -125,12 +125,12 @@
<table width=\"700\" class=\"table1\" style=\"margin:auto;\">
<tr>
<td class=\"contenucellule\">";
- return $output;
- }
+ return $output;
+}
- function footer_install()
- {
- $output = "
+function footer_install()
+{
+ $output = "
</td>
</tr>
</table>
@@ -139,92 +139,92 @@
</table>
</body>
</html>";
- return $output;
- }
+ return $output;
+}
- if ( isset( $HTTP_GET_VARS['language'] ) )
- {
- $isadmin = true;
- $lang = array();
- include( "../language/".$HTTP_GET_VARS['language'].".php" );
- }
+if ( isset( $HTTP_GET_VARS['language'] ) )
+{
+ $isadmin = true;
+ $lang = array();
+ include( "../language/".$HTTP_GET_VARS['language'].".php" );
+}
- /*---------------------------------------Step 1------------------------------------*/
- if ( $HTTP_GET_VARS['step'] == 1 )
- {
- $erreur1 = true;
- $message = "";
- // création du fichier de configuration de connexion à la BD mysql
- if( isset( $HTTP_POST_VARS['cfgBase'] ) && isset( $HTTP_POST_VARS['cfgUser'] ) && isset( $HTTP_POST_VARS['cfgPassword'] ) && isset( $HTTP_POST_VARS['cfgHote'] ) )
- {
- if ( @mysql_connect( $HTTP_POST_VARS['cfgHote'], $HTTP_POST_VARS['cfgUser'], $HTTP_POST_VARS['cfgPassword'] ) )
- {
- if ( @mysql_select_db($HTTP_POST_VARS['cfgBase'] ) )
- {
- $message.= "<div class=\"info\">".$lang['step1_confirmation']."</div>";
- $erreur1 = false;
- }
- else
- {
- $message.= "<div class=\"erreur\">".$lang['step1_err_db']."</div>";
- }
- }
- else
- {
- $message.= "<div class=\"erreur\">".$lang['step1_err_server']."</div>";
- }
+/*---------------------------------------Step 1------------------------------------*/
+if ( $HTTP_GET_VARS['step'] == 1 )
+{
+ $erreur1 = true;
+ $message = "";
+ // création du fichier de configuration de connexion à la BD mysql
+ if( isset( $HTTP_POST_VARS['cfgBase'] ) && isset( $HTTP_POST_VARS['cfgUser'] ) && isset( $HTTP_POST_VARS['cfgPassword'] ) && isset( $HTTP_POST_VARS['cfgHote'] ) )
+ {
+ if ( @mysql_connect( $HTTP_POST_VARS['cfgHote'], $HTTP_POST_VARS['cfgUser'], $HTTP_POST_VARS['cfgPassword'] ) )
+ {
+ if ( @mysql_select_db($HTTP_POST_VARS['cfgBase'] ) )
+ {
+ $message.= "<div class=\"info\">".$lang['step1_confirmation']."</div>";
+ $erreur1 = false;
+ }
+ else
+ {
+ $message.= "<div class=\"erreur\">".$lang['step1_err_db']."</div>";
+ }
+ }
+ else
+ {
+ $message.= "<div class=\"erreur\">".$lang['step1_err_server']."</div>";
+ }
- if ( !$erreur1 )
- {
- // écriture du fichier de configuration
- if ( $fp = @fopen("../include/mysql.inc.php","a+") )
- {
- fwrite( $fp, "<?php\n\t\$cfgBase='".$HTTP_POST_VARS['cfgBase']."';\n\t\$cfgUser='".$HTTP_POST_VARS['cfgUser']."';\n\t\$cfgPassword='".$HTTP_POST_VARS['cfgPassword']."';\n\t\$cfgHote='".$HTTP_POST_VARS['cfgHote']."';\n\t\$prefixeTable='".$HTTP_POST_VARS['prefixe']."';\n?>" );
- fclose( $fp );
- }
- $cfgHote = "";
- $cfgUser = "";
- $cfgPassword = "";
- $cfgBase = "";
- include ( "../include/mysql.inc.php" );
- $erreur2 = true;
- if ( @mysql_connect( $cfgHote, $cfgUser, $cfgPassword ) )
- {
- if ( @mysql_select_db ( $cfgBase ) )
- {
- $erreur2 = false;
- }
- }
- if ( $erreur2 )
- {
- $message.="<br /><br />".$lang['step1_err_copy']." :<br />
+ if ( !$erreur1 )
+ {
+ // écriture du fichier de configuration
+ if ( $fp = @fopen("../include/mysql.inc.php","a+") )
+ {
+ fwrite( $fp, "<?php\n\t\$cfgBase='".$HTTP_POST_VARS['cfgBase']."';\n\t\$cfgUser='".$HTTP_POST_VARS['cfgUser']."';\n\t\$cfgPassword='".$HTTP_POST_VARS['cfgPassword']."';\n\t\$cfgHote='".$HTTP_POST_VARS['cfgHote']."';\n\t\PREFIX_TABLE='".$HTTP_POST_VARS['prefixe']."';\n?>" );
+ fclose( $fp );
+ }
+ $cfgHote = "";
+ $cfgUser = "";
+ $cfgPassword = "";
+ $cfgBase = "";
+ include ( "../include/mysql.inc.php" );
+ $erreur2 = true;
+ if ( @mysql_connect( $cfgHote, $cfgUser, $cfgPassword ) )
+ {
+ if ( @mysql_select_db ( $cfgBase ) )
+ {
+ $erreur2 = false;
+ }
+ }
+ if ( $erreur2 )
+ {
+ $message.="<br /><br />".$lang['step1_err_copy']." :<br />
-----------------------------------------------------<br />
<div style=\"color:blue;\">&lt;?php<br />
\$cfgBase = '".$HTTP_POST_VARS['cfgBase']."';<br />
\$cfgUser = '".$HTTP_POST_VARS['cfgUser']."';<br />
\$cfgPassword = '".$HTTP_POST_VARS['cfgPassword']."';<br />
\$cfgHote = '".$HTTP_POST_VARS['cfgHote']."';<br />
- \$prefixeTable = '".$HTTP_POST_VARS['prefixe']."';<br />
+ \PREFIX_TABLE = '".$HTTP_POST_VARS['prefixe']."';<br />
?&gt;</div>
-----------------------------------------------------<br />";
- $message.= "<div style=\"text-align:center;\">".$lang['step1_err_copy_2']."<br />";
- $message.= "<a href=\"install.php?step=2&amp;language=".$HTTP_GET_VARS['language']."\">".$lang['step1_err_copy_next']."</a></div>";
- }
- else
- {
- $url = "install.php?step=2&language=".$HTTP_GET_VARS['language'];
- header("Request-URI: $url");
- header("Content-Location: $url");
- header("Location: $url");
- exit();
- }
- }
- }
+ $message.= "<div style=\"text-align:center;\">".$lang['step1_err_copy_2']."<br />";
+ $message.= "<a href=\"install.php?step=2&amp;language=".$HTTP_GET_VARS['language']."\">".$lang['step1_err_copy_next']."</a></div>";
+ }
+ else
+ {
+ $url = "install.php?step=2&language=".$HTTP_GET_VARS['language'];
+ header("Request-URI: $url");
+ header("Content-Location: $url");
+ header("Location: $url");
+ exit();
+ }
+ }
+ }
- echo header_install();
- if ( isset( $message ) && $message != "" )
- {
- echo"
+ echo header_install();
+ if ( isset( $message ) && $message != "" )
+ {
+ echo"
<table width=\"100%\">
<tr>
<th>".$lang['install_message']."</th>
@@ -233,10 +233,10 @@
<td>$message</td>
</tr>
</table>";
- }
- if ( $erreur1 )
- {
- echo"
+ }
+ if ( $erreur1 )
+ {
+ echo"
<form method=\"post\" action=\"install.php?step=1&amp;language=".$HTTP_GET_VARS['language']."\">
<table width=\"100%\">
<tr>
@@ -248,15 +248,15 @@
<tr>
<td>".$lang['step1_host']."</td>
<td align=center><input type='text' name='cfgHote' value='";
- if ( !isset( $HTTP_POST_VARS['cfgHote'] ) )
- {
- echo"localhost";
- }
- else
- {
- echo $HTTP_POST_VARS['cfgHote'];
- }
- echo"'></td>
+ if ( !isset( $HTTP_POST_VARS['cfgHote'] ) )
+ {
+ echo"localhost";
+ }
+ else
+ {
+ echo $HTTP_POST_VARS['cfgHote'];
+ }
+ echo"'></td>
<td class=\"row2\">".$lang['step1_host_info']."</td>
</tr>
<tr>
@@ -277,15 +277,15 @@
<tr>
<td>".$lang['step1_prefix']."</td>
<td align=center><input type='text' name='prefixe' value='";
- if ( !isset( $HTTP_POST_VARS['prefixe'] ) )
- {
- echo"phpwebgallery_";
- }
- else
- {
- echo $HTTP_POST_VARS['prefixe'];
- }
- echo"'></td>
+ if ( !isset( $HTTP_POST_VARS['prefixe'] ) )
+ {
+ echo"phpwebgallery_";
+ }
+ else
+ {
+ echo $HTTP_POST_VARS['prefixe'];
+ }
+ echo"'></td>
<td class=\"row2\">".$lang['step1_prefix_info']."</td>
</tr>
<tr>
@@ -296,19 +296,19 @@
</tr>
</table>
</form>";
- }
- echo footer_install();
- }
- /*---------------------------------------Step 2------------------------------------*/
- else if ( $HTTP_GET_VARS['step'] == 2 )
- {
- include( "../include/mysql.inc.php" );
- mysql_connect( $cfgHote, $cfgUser, $cfgPassword ) or die ( "erreur de connexion au serveur" );
- mysql_select_db( $cfgBase ) or die ( "erreur de connexion a la base de donnees" );
+ }
+ echo footer_install();
+}
+/*---------------------------------------Step 2------------------------------------*/
+else if ( $HTTP_GET_VARS['step'] == 2 )
+{
+ include( "../include/mysql.inc.php" );
+ mysql_connect( $cfgHote, $cfgUser, $cfgPassword ) or die ( "erreur de connexion au serveur" );
+ mysql_select_db( $cfgBase ) or die ( "erreur de connexion a la base de donnees" );
- if ( !isset( $HTTP_POST_VARS['submit'] ) )
- {
- $query = "CREATE TABLE ".$prefixeTable."categories (
+ if ( !isset( $HTTP_POST_VARS['submit'] ) )
+ {
+ $query = "CREATE TABLE ".PREFIX_TABLE."categories (
id tinyint(3) unsigned NOT NULL auto_increment,
date_dernier date NOT NULL default '0000-00-00',
nb_images smallint(5) unsigned NOT NULL default '0',
@@ -321,8 +321,8 @@
site_id tinyint(4) unsigned NOT NULL default '1',
PRIMARY KEY (id)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."comments (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."comments (
id int(11) unsigned NOT NULL auto_increment,
image_id smallint(5) unsigned NOT NULL default '0',
date int(11) unsigned NOT NULL default '0',
@@ -330,8 +330,8 @@
content longtext,
PRIMARY KEY (id)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."config (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."config (
periode_courte smallint(5) unsigned NOT NULL default '7',
periode_longue smallint(5) unsigned NOT NULL default '14',
prefixe_thumbnail varchar(10) NOT NULL default 'TN-',
@@ -352,14 +352,14 @@
upload_maxwidth_thumbnail smallint(5) unsigned NOT NULL default '150',
upload_maxheight_thumbnail smallint(5) unsigned NOT NULL default '100'
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."favorites (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."favorites (
user_id smallint(5) unsigned NOT NULL default '0',
image_id smallint(5) unsigned NOT NULL default '0',
KEY user_id (user_id,image_id)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."history (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."history (
date int(11) NOT NULL default '0',
login varchar(15) default NULL,
IP varchar(50) NOT NULL default '',
@@ -368,8 +368,8 @@
titre varchar(150) default NULL,
commentaire varchar(200) default NULL
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."images (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."images (
id smallint(5) unsigned NOT NULL auto_increment,
file varchar(255) NOT NULL default '',
cat_id tinyint(3) unsigned NOT NULL default '0',
@@ -386,29 +386,29 @@
PRIMARY KEY (id),
KEY cat_id (cat_id)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."restrictions (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."restrictions (
user_id smallint(5) unsigned NOT NULL default '0',
cat_id tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (user_id,cat_id)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."sessions (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."sessions (
id varchar(255) binary NOT NULL default '',
user_id smallint(5) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
ip varchar(255) NOT NULL default '',
PRIMARY KEY (id)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."sites (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."sites (
id tinyint(4) NOT NULL auto_increment,
galleries_url varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY galleries_url (galleries_url)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."users (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."users (
id smallint(5) unsigned NOT NULL auto_increment,
pseudo varchar(20) binary NOT NULL default '',
password varchar(255) NOT NULL default '',
@@ -423,8 +423,8 @@
PRIMARY KEY (id),
UNIQUE KEY pseudo (pseudo)
);";
- mysql_query( $query );
- $query = "CREATE TABLE ".$prefixeTable."waiting (
+ mysql_query( $query );
+ $query = "CREATE TABLE ".PREFIX_TABLE."waiting (
id int(10) unsigned NOT NULL auto_increment,
cat_id tinyint(3) unsigned NOT NULL default '0',
file varchar(255) NOT NULL default '',
@@ -434,67 +434,67 @@
tn_ext char(3) default NULL,
PRIMARY KEY (id)
);";
- mysql_query( $query );
- }
- if ( isset( $HTTP_POST_VARS['submit'] ) )
- {
- $configuration = false;
- $erreur = "";
- $nb_erreur = 0;
- // le pseudo du webmaster ne doit pas
- // 1. être vide
- // 2. commencer ou se terminer par un espace
- // 3. comporter les caractères ' ou "
- // Notes sur le pseudo du webmaster :
- // - lorsque l'on trouve plusieurs occurences
- // consécutives du caractère espace, on réduit à une seule occurence
- if ( $HTTP_POST_VARS['webmaster'] == "" )
- {
- $erreur .= "<li>".$lang['step2_err_login1']."</li>";
- $nb_erreur++;
- }
- $webmaster = ereg_replace( "[ ]{2,}", " ", $HTTP_POST_VARS['webmaster'] );
- if ( ereg( "^.* $", $webmaster ) || ereg( "^ .*$", $webmaster) )
- {
- $erreur .= "<li>".$lang['step2_err_login2']."</li>";
- $nb_erreur++;
- }
- if ( ereg( "'",$webmaster ) || ereg( "\"",$webmaster ) )
- {
- $erreur .= "<li>".$lang['step2_err_login3']."</li>";
- $nb_erreur++;
- }
- // on vérifie que le password rentré correspond bien à la confirmation faite par l'utilisateur
- if ( $HTTP_POST_VARS['pwdWebmaster'] != $HTTP_POST_VARS['pwdWebmasterConf'] )
- {
- $erreur .= "<li>".$lang['step2_err_pass']."</li>";
- $nb_erreur++;
- }
- // le mail doit être conforme à qqch du type : nom@serveur.com
- if( !ereg("([_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)+)", $HTTP_POST_VARS['mail_webmaster'] ) )
- {
- $erreur .= "<li>".$lang['step2_err_mail']."</li>";
- $nb_erreur++;
- }
- // on met à jour les paramètres de l'application dans le cas où il n'y aucune erreur
- if ( $nb_erreur == 0 )
- {
- mysql_query( "delete from $prefixeTable"."config" );
- $query = "insert into $prefixeTable"."config (webmaster,mail_webmaster) values ('$webmaster','".$HTTP_POST_VARS['mail_webmaster']."')";
- mysql_query($query);
- $query = "insert into $prefixeTable"."sites values (1, './galleries/');";
- mysql_query($query);
- $query = "insert into $prefixeTable"."users (pseudo,password,status,language) values ('$webmaster','".md5( $pwdWebmaster )."','admin','".$HTTP_GET_VARS['language']."')";
- mysql_query($query);
- mysql_query("insert into $prefixeTable"."users (pseudo,password,status,language) values ('visiteur','".md5( "" )."','visiteur','".$HTTP_GET_VARS['language']."')");
- $configuration = true;
- }
- }
+ mysql_query( $query );
+ }
+ if ( isset( $HTTP_POST_VARS['submit'] ) )
+ {
+ $configuration = false;
+ $erreur = "";
+ $nb_erreur = 0;
+ // le pseudo du webmaster ne doit pas
+ // 1. être vide
+ // 2. commencer ou se terminer par un espace
+ // 3. comporter les caractères ' ou "
+ // Notes sur le pseudo du webmaster :
+ // - lorsque l'on trouve plusieurs occurences
+ // consécutives du caractère espace, on réduit à une seule occurence
+ if ( $HTTP_POST_VARS['webmaster'] == "" )
+ {
+ $erreur .= "<li>".$lang['step2_err_login1']."</li>";
+ $nb_erreur++;
+ }
+ $webmaster = ereg_replace( "[ ]{2,}", " ", $HTTP_POST_VARS['webmaster'] );
+ if ( ereg( "^.* $", $webmaster ) || ereg( "^ .*$", $webmaster) )
+ {
+ $erreur .= "<li>".$lang['step2_err_login2']."</li>";
+ $nb_erreur++;
+ }
+ if ( ereg( "'",$webmaster ) || ereg( "\"",$webmaster ) )
+ {
+ $erreur .= "<li>".$lang['step2_err_login3']."</li>";
+ $nb_erreur++;
+ }
+ // on vérifie que le password rentré correspond bien à la confirmation faite par l'utilisateur
+ if ( $HTTP_POST_VARS['pwdWebmaster'] != $HTTP_POST_VARS['pwdWebmasterConf'] )
+ {
+ $erreur .= "<li>".$lang['step2_err_pass']."</li>";
+ $nb_erreur++;
+ }
+ // le mail doit être conforme à qqch du type : nom@serveur.com
+ if( !ereg("([_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)+)", $HTTP_POST_VARS['mail_webmaster'] ) )
+ {
+ $erreur .= "<li>".$lang['step2_err_mail']."</li>";
+ $nb_erreur++;
+ }
+ // on met à jour les paramètres de l'application dans le cas où il n'y aucune erreur
+ if ( $nb_erreur == 0 )
+ {
+ mysql_query( "delete from PREFIX_TABLE"."config" );
+ $query = "insert into PREFIX_TABLE"."config (webmaster,mail_webmaster) values ('$webmaster','".$HTTP_POST_VARS['mail_webmaster']."')";
+ mysql_query($query);
+ $query = "insert into PREFIX_TABLE"."sites values (1, './galleries/');";
+ mysql_query($query);
+ $query = "insert into PREFIX_TABLE"."users (pseudo,password,status,language) values ('$webmaster','".md5( $pwdWebmaster )."','admin','".$HTTP_GET_VARS['language']."')";
+ mysql_query($query);
+ mysql_query("insert into PREFIX_TABLE"."users (pseudo,password,status,language) values ('visiteur','".md5( "" )."','visiteur','".$HTTP_GET_VARS['language']."')");
+ $configuration = true;
+ }
+ }
- echo header_install();
- if ( $configuration )
- {
- echo"
+ echo header_install();
+ if ( $configuration )
+ {
+ echo"
<table width=\"100%\">
<tr>
<th>".$lang['install_end_title']."</th>
@@ -506,12 +506,12 @@
<td>".$lang['install_end_message']."</td>
</tr>
</table>";
- }
- else
- {
- if ( $nb_erreur > 0 )
- {
- echo"
+ }
+ else
+ {
+ if ( $nb_erreur > 0 )
+ {
+ echo"
<table width=100%>
<tr>
<th>".$lang['install_message']."</th>
@@ -526,8 +526,8 @@
<td>&nbsp;</td>
</tr>
</table>";
- }
- echo"
+ }
+ echo"
<form method=\"post\" action=\"install.php?step=2&amp;language=".$HTTP_GET_VARS['language']."\">
<table width=100%>
<tr>
@@ -566,34 +566,34 @@
</tr>
</table>
</form>";
- }
- echo footer_install();
- }
- /*----------------------------------Language choice------------------------------------*/
- else
- {
- include( "../include/functions.php" );
- echo header_install();
- echo"
+ }
+ echo footer_install();
+}
+/*----------------------------------Language choice------------------------------------*/
+else
+{
+ include( "../include/functions.php" );
+ echo header_install();
+ echo"
<form method=\"get\" action=\"install.php\">
<input type=\"hidden\" name=\"step\" value=\"1\"/>
<table width=\"100%\">
<tr>
<td align=\"center\">
<select name=\"language\">";
- $languages = get_languages( "../language/" );
- for ( $i = 0; $i < sizeof ( $languages ); $i++ )
- {
- echo"
+ $languages = get_languages( "../language/" );
+ for ( $i = 0; $i < sizeof ( $languages ); $i++ )
+ {
+ echo"
<option>".$languages[$i]."</option>";
- }
- echo"
+ }
+ echo"
</select>
<input type=\"submit\" value=\"Go\">
</td>
</tr>
</table>
</form>";
- echo footer_install();
- }
+ echo footer_install();
+}
?> \ No newline at end of file
diff --git a/admin/perm.php b/admin/perm.php
index 2407d9f6f..257bb21fb 100644
--- a/admin/perm.php
+++ b/admin/perm.php
@@ -18,7 +18,7 @@
//---------------------------------------------------données de l'utilisateur
if ( isset( $HTTP_GET_VARS['user_id'] ) )
{
- $query = "select id,pseudo,status from $prefixeTable"."users where id = '".$HTTP_GET_VARS['user_id']."';";
+ $query = "select id,pseudo,status from PREFIX_TABLE"."users where id = '".$HTTP_GET_VARS['user_id']."';";
$result = mysql_query( $query );
$row = mysql_fetch_array( $result );
$page['pseudo'] = $row['pseudo'];
@@ -51,14 +51,14 @@
{
if ( isset( $HTTP_GET_VARS['user_id'] ) )
{
- mysql_query ( "delete from $prefixeTable"."restrictions where user_id = ".$HTTP_GET_VARS['user_id'].";" );
- $result = mysql_query ( "select id from $prefixeTable"."categories;" );
+ mysql_query ( "delete from PREFIX_TABLE"."restrictions where user_id = ".$HTTP_GET_VARS['user_id'].";" );
+ $result = mysql_query ( "select id from PREFIX_TABLE"."categories;" );
while ( $row = mysql_fetch_array ( $result ) )
{
$nom_select = "acces-".$row['id'];
if ( $HTTP_POST_VARS[$nom_select] == 1 )
{
- mysql_query ( "insert into $prefixeTable"."restrictions (user_id,cat_id) values ('".$HTTP_GET_VARS['user_id']."','".$row['id']."');" );
+ mysql_query ( "insert into PREFIX_TABLE"."restrictions (user_id,cat_id) values ('".$HTTP_GET_VARS['user_id']."','".$row['id']."');" );
}
}
check_favorites( $HTTP_GET_VARS['user_id'] );
@@ -66,14 +66,14 @@
}
else if ( isset( $HTTP_GET_VARS['cat_id'] ) )
{
- mysql_query ( "delete from $prefixeTable"."restrictions where cat_id = '".$page['cat']."';" );
- $result = mysql_query( "select id from $prefixeTable"."users where pseudo != '".$conf['webmaster']."';" );
+ mysql_query ( "delete from PREFIX_TABLE"."restrictions where cat_id = '".$page['cat']."';" );
+ $result = mysql_query( "select id from PREFIX_TABLE"."users where pseudo != '".$conf['webmaster']."';" );
while ( $row = mysql_fetch_array ( $result ) )
{
$nom_select = "acces-".$row['id'];
if ( $HTTP_POST_VARS[$nom_select] == 1 )
{
- mysql_query ( "insert into $prefixeTable"."restrictions (user_id,cat_id) values ('".$row['id']."','".$page['cat']."');" );
+ mysql_query ( "insert into PREFIX_TABLE"."restrictions (user_id,cat_id) values ('".$row['id']."','".$page['cat']."');" );
}
check_favorites( $row['id'] );
}
@@ -83,7 +83,7 @@
//--------------------------------------------------------------- formulaire
function display_cat_manager( $id_uppercat, $indent, $uppercat_authorized, $level, $restriction )
{
- global $prefixeTable,$lang,$conf;
+ global PREFIX_TABLE,$lang,$conf;
$output = "";
@@ -121,7 +121,7 @@
}
$query = "select id,name,dir,rank";
- $query.= " from $prefixeTable"."categories";
+ $query.= " from PREFIX_TABLE"."categories";
if ( !is_numeric( $id_uppercat ) )
{
$query.= " where id_uppercat is NULL";
@@ -214,7 +214,7 @@
<form action=\"".add_session_id_to_url( "./admin.php?page=perm&amp;cat_id=".$page['cat'] )."\" method=\"post\">
<table style=\"width:100%;\">";
- $result = mysql_query( "select id,pseudo,status from $prefixeTable"."users where pseudo != '".$conf['webmaster']."';" );
+ $result = mysql_query( "select id,pseudo,status from PREFIX_TABLE"."users where pseudo != '".$conf['webmaster']."';" );
$i = 0;
while ( $row = mysql_fetch_array( $result ) )
{
diff --git a/admin/update.php b/admin/update.php
new file mode 100644
index 000000000..8684660e1
--- /dev/null
+++ b/admin/update.php
@@ -0,0 +1,575 @@
+<?php
+/***************************************************************************
+ * update.php *
+ * ------------------ *
+ * application : PhpWebGallery 1.3 *
+ * author : Pierrick LE GALL <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; *
+ * *
+ ***************************************************************************/
+
+include_once( './include/isadmin.inc.php' );
+//------------------------------------------------------------------- functions
+function insert_local_category( $cat_id )
+{
+ global $conf, $page;
+
+ $site_id = 1;
+
+ // 0. retrieving informations on the category to display
+ $cat_directory = '../galleries';
+
+ if ( is_numeric( $cat_id ) )
+ {
+ $result = get_cat_info( $cat_id );
+ $cat_directory.= '/'.$result['local_dir'];
+ // 1. display the category name to update
+ $output = '<img src="./images/puce.gif" alt="&gt;" />';
+ $output.= '<span style="font-weight:bold;">'.$result['name'][0].'</span>';
+ $output.= ' [ '.$result['last_dir'].' ]';
+ $output.= '<div class="retrait">';
+
+ // 2. we search pictures of the category only if the update is for all
+ // or a cat_id is specified
+ if ( isset( $page['cat'] ) or $_GET['update'] == 'all' )
+ {
+ $output.= insert_local_image( $cat_directory, $cat_id );
+ update_cat_info( $cat_id );
+ }
+ }
+
+ // 3. we have to remove the categories of the database not present anymore
+ $query = 'SELECT id';
+ $query.= ' FROM '.PREFIX_TABLE.'categories';
+ $query.= ' WHERE site_id = '.$site_id;
+ if ( !is_numeric( $cat_id ) )
+ {
+ $query.= ' AND id_uppercat IS NULL';
+ }
+ else
+ {
+ $query.= ' AND id_uppercat = '.$cat_id;
+ }
+ $query.= ';';
+ $result = mysql_query( $query );
+ while ( $row = mysql_fetch_array( $result ) )
+ {
+ // retrieving the directory
+ $rep = '../galleries';
+ $resultat = get_cat_info( $row['id'] );
+ $rep.= '/'.$resultat['local_dir'];
+
+ // is the directory present ?
+ if ( !is_dir( $rep ) )
+ {
+ delete_category( $row['id'] );
+ }
+ }
+
+ // 4. retrieving the sub-directories
+ $sub_rep = array();
+ $i = 0;
+ $dirs = '';
+ if ( $opendir = opendir ( $cat_directory ) )
+ {
+ while ( $file = readdir ( $opendir ) )
+ {
+ if ( $file != '.'
+ and $file != '..'
+ and is_dir ( $cat_directory.'/'.$file )
+ and $file != 'thumbnail' )
+ {
+ $sub_rep[$i++] = $file;
+ }
+ }
+ }
+
+ for ( $i = 0; $i < sizeof( $sub_rep ); $i++ )
+ {
+ // 5. Is the category already existing ? we create a subcat if not
+ // existing
+ $category_id = '';
+ $query = 'SELECT id';
+ $query.= ' FROM '.PREFIX_TABLE.'categories';
+ $query.= ' WHERE site_id = '.$site_id;
+ $query.= " AND dir = '".$sub_rep[$i]."'";
+ if ( !is_numeric( $cat_id ) )
+ {
+ $query.= ' AND id_uppercat IS NULL';
+ }
+ else
+ {
+ $query.= ' AND id_uppercat = '.$cat_id;
+ }
+ $query.= ';';
+ $result = mysql_query( $query );
+ if ( mysql_num_rows( $result ) == 0 )
+ {
+ // we have to create the category
+ $query = 'INSERT INTO '.PREFIX_TABLE.'categories';
+ $query.= ' (dir,site_id,id_uppercat) VALUES';
+ $query.= " ('".$sub_rep[$i]."','".$site_id."'";
+ if ( !is_numeric( $cat_id ) )
+ {
+ $query.= ',NULL';
+ }
+ else
+ {
+ $query.= ",'".$cat_id."'";
+ }
+ $query.= ');';
+ mysql_query( $query );
+ $category_id = mysql_insert_id();
+ }
+ else
+ {
+ // we get the already registered id
+ $row = mysql_fetch_array( $result );
+ $category_id = $row['id'];
+ }
+ // 6. recursive call
+ $output.= insert_local_category( $category_id );
+ }
+
+ if ( is_numeric( $cat_id ) )
+ {
+ $output.= '</div>';
+ }
+ return $output;
+}
+
+function insert_local_image( $rep, $category_id )
+{
+ global $lang,$conf,$count_new;
+
+ $output = '';
+ // we have to delete all the images from the database that :
+ // - are not in the directory anymore
+ // - don't have the associated thumbnail available anymore
+ $query = 'SELECT id,file,tn_ext';
+ $query.= ' FROM '.PREFIX_TABLE.'images';
+ $query.= ' WHERE cat_id = '.$category_id;
+ $query.= ';';
+ $result = mysql_query( $query );
+ while ( $row = mysql_fetch_array( $result ) )
+ {
+ $lien_image = $rep.'/'.$row['file'];
+ $lien_thumbnail = $rep.'/thumbnail/'.$conf['prefixe_thumbnail'];
+ $lien_thumbnail.= get_filename_wo_extension( $row['file'] );
+ $lien_thumbnail.= '.'.$row['tn_ext'];
+
+ if ( !is_file ( $lien_image ) or !is_file ( $lien_thumbnail ) )
+ {
+ if ( !is_file ( $lien_image ) )
+ {
+ $output.= $row['file'];
+ $output.= ' <span style="font-weight:bold;">';
+ $output.= $lang['update_disappeared'].'</span><br />';
+ }
+ if ( !is_file ( $lien_thumbnail ) )
+ {
+ $output.= $row['file'];
+ $output.= ' : <span style="font-weight:bold;">';
+ $output.= $lang['update_disappeared_tn'].'</span><br />';
+ }
+ // suppression de la base :
+ delete_image( $row['id'] );
+ }
+ }
+
+ // searching the new images in the directory
+ $pictures = array();
+ $tn_ext = '';
+ if ( $opendir = opendir ( $rep ) )
+ {
+ while ( $file = readdir ( $opendir ) )
+ {
+ if ( is_file( $rep.'/'.$file ) and is_image( $rep.'/'.$file ) )
+ {
+ // is the picture waiting for validation by an administrator ?
+ $query = 'SELECT id';
+ $query.= ' FROM '.PREFIX_TABLE.'waiting';
+ $query.= ' WHERE cat_id = '.$category_id;
+ $query.= " AND file = '".$file."'";
+ $query.= ';';
+ $result = mysql_query( $query );
+ if ( mysql_num_rows( $result ) == 0 )
+ {
+ if ( $tn_ext = TN_exists( $rep, $file ) )
+ {
+ // is the picture already in the database ?
+ $query = 'SELECT id';
+ $query.= ' FROM '.PREFIX_TABLE.'images';
+ $query.= ' WHERE cat_id = '.$category_id;
+ $query.= " AND file = '".$file."'";
+ $query.= ';';
+ $result = mysql_query( $query );
+ if ( mysql_num_rows( $result ) == 0 )
+ {
+ $picture = array();
+ $picture['file'] = $file;
+ $picture['tn_ext'] = $tn_ext;
+ $picture['date'] = date( 'Y-m-d', filemtime ( $rep.'/'.$file ) );
+ $picture['filesize'] = floor( filesize( $rep.'/'.$file ) / 1024);
+ $image_size = @getimagesize( $rep.'/'.$file );
+ $picture['width'] = $image_size[0];
+ $picture['height'] = $image_size[1];
+ array_push( $pictures, $picture );
+ }
+ }
+ else
+ {
+ $output.= '<span style="color:red;">';
+ $output.= $lang['update_missing_tn'].' : '.$file;
+ $output.= ' (<span style="font-weight:bold;">';
+ $output.= $conf['prefixe_thumbnail'];
+ $output.= get_filename_wo_extension( $file ).'.XXX</span>';
+ $output.= ', XXX = ';
+ $output.= implode( ', ', $conf['picture_ext'] );
+ $output.= ')</span><br />';
+ }
+ }
+ }
+ }
+ }
+ // inserting the pictures found in the directory
+ foreach ( $pictures as $picture ) {
+ $query = 'INSERT INTO '.PREFIX_TABLE.'images';
+ $query.= ' (file,cat_id,date_available,tn_ext,filesize,width,height)';
+ $query.= ' VALUES ';
+ $query.= "('".$picture['file']."','".$category_id."'";
+ $query.= ",'".$picture['date']."','".$picture['tn_ext']."'";
+ $query.= ",'".$picture['filesize']."','".$picture['width']."'";
+ $query.= ",'".$picture['height']."')";
+ $query.= ';';
+ mysql_query( $query );
+ $count_new++;
+
+ $output.= $picture['file'];
+ $output.= ' <span style="font-weight:bold;">';
+ $output.= $lang['update_research_added'].'</span>';
+ $output.= ' ('.$lang['update_research_tn_ext'].' '.$picture['tn_ext'].')';
+ $output.= '<br />';
+ }
+ return $output;
+}
+
+// The function "update_cat_info" updates the information about the last
+// online image and the number of images in the category
+function update_cat_info( $category_id )
+{
+ $query = 'SELECT date_available';
+ $query.= ' FROM '.PREFIX_TABLE.'images';
+ $query.= ' WHERE cat_id = '.$category_id;
+ $query.= ' ORDER BY date_available DESC';
+ $query.= ' LIMIT 0,1';
+ $query.= ';';
+ $result = mysql_query( $query );
+ $row = mysql_fetch_array( $result );
+ $date_last = $row['date_available'];
+
+ $query = 'SELECT COUNT(*) as nb_images';
+ $query.= ' FROM '.PREFIX_TABLE.'images';
+ $query.= ' WHERE cat_id = '.$category_id;
+ $result = mysql_query( $query );
+ $row = mysql_fetch_array( $result );
+ $nb_images = $row['nb_images'];
+
+ $query = 'UPDATE '.PREFIX_TABLE.'categories';
+ $query.= " SET date_dernier = '".$date_last."'";
+ $query.= ', nb_images = '.$nb_images;
+ $query.= ' where id = '.$category_id;
+ $query.= ';';
+ mysql_query( $query );
+}
+
+// remote_images verifies if a file named "listing.xml" is present is the
+// admin directory. If it is the case, creation of a remote picture storage
+// site if it doesn't already exists. Then, the function calls
+// insert_remote_category for this remote site on the root category.
+function remote_images()
+{
+ global $conf, $lang, $vtp, $sub;
+
+ // 1. is there a file listing.xml ?
+ if ( !( $xml_content = getXmlCode( 'listing.xml' ) ) )
+ {
+ return false;
+ }
+ $url = getContent( getChild( $xml_content, 'url' ) );
+ $vtp->setVar( $sub, 'remote_update.url', $url );
+
+ // 2. is the site already existing ?
+ $query = 'select id';
+ $query.= ' from '.PREFIX_TABLE.'sites';
+ $query.= " where galleries_url = '".$url."'";
+ $query.= ';';
+ $result = mysql_query( $query );
+ if ( mysql_num_rows($result ) == 0 )
+ {
+ // we have to register this site in the database
+ $query = 'insert into '.PREFIX_TABLE.'sites';
+ $query.= " (galleries_url) values ('".$url."')";
+ $query.= ';';
+ mysql_query( $query );
+ $site_id = mysql_insert_id();
+ }
+ else
+ {
+ // we get the already registered id
+ $row = mysql_fetch_array( $result );
+ $site_id = $row['id'];
+ }
+
+ // 3. available dirs in the file
+ $categories = insert_remote_category( $xml_content, $site_id, 'NULL', 0 );
+ $vtp->setVar( $sub, 'remote_update.categories', $categories );
+}
+
+// insert_remote_category searchs the "dir" node of the xml_dir given and
+// insert the contained categories if the are not in the database yet. The
+// function also deletes the categories that are in the database and not in
+// the xml_file.
+function insert_remote_category( $xml_dir, $site_id, $id_uppercat, $level )
+{
+ global $conf;
+
+ $output = '';
+ $categories = array();
+ $list_dirs = getChildren( $xml_dir, 'dir'.$level );
+ for ( $i = 0; $i < sizeof( $list_dirs ); $i++ )
+ {
+ // is the category already existing ?
+ $category_id = '';
+ $name = getAttribute( $list_dirs[$i], 'name' );
+ $categories[$i] = $name;
+
+ $output.= '<img src="./images/puce.gif">';
+ $output.= '<span style="font-weight:bold;">'.$name.'</span>';
+ $output.= '<div class="retrait">';
+
+ $query = 'select id';
+ $query.= ' from '.PREFIX_TABLE.'categories';
+ $query.= ' where site_id = '.$site_id;
+ $query.= " and dir = '".$name."'";
+ if ( $id_uppercat == 'NULL' )
+ {
+ $query.= ' and id_uppercat is NULL';
+ }
+ else
+ {
+ $query.= ' and id_uppercat = '.$id_uppercat;
+ }
+ $query.= ';';
+ $result = mysql_query( $query );
+ if ( mysql_num_rows( $result ) == 0 )
+ {
+ // we have to create the category
+ $query = 'insert into '.PREFIX_TABLE.'categories';
+ $query.= " (dir,site_id,id_uppercat) values ('".$name."',".$site_id;
+ if ( !is_numeric( $id_uppercat ) )
+ {
+ $query.= ',NULL';
+ }
+ else
+ {
+ $query.= ','.$id_uppercat;
+ }
+ $query.= ');';
+ mysql_query( $query );
+ $category_id = mysql_insert_id();
+ }
+ else
+ {
+ // we get the already registered id
+ $row = mysql_fetch_array( $result );
+ $category_id = $row['id'];
+ }
+ $output.= insert_remote_image( $list_dirs[$i], $category_id );
+ update_cat_info( $category_id );
+ $output.= insert_remote_category( $list_dirs[$i], $site_id,
+ $category_id, $level+1 );
+ $output.= '</div>';
+ }
+ // we have to remove the categories of the database not present in the xml
+ // file (ie deleted from the picture storage server)
+ $query = 'select dir,id';
+ $query.= ' from '.PREFIX_TABLE.'categories';
+ $query.= ' where site_id = '.$site_id;
+ if ( !is_numeric( $id_uppercat ) )
+ {
+ $query.= ' and id_uppercat is NULL';
+ }
+ else
+ {
+ $query.= ' and id_uppercat = '.$id_uppercat;
+ }
+ $query.= ';';
+ $result = mysql_query( $query );
+ while ( $row = mysql_fetch_array( $result ) )
+ {
+ // is the category in the xml file ?
+ if ( !in_array( $row['dir'], $categories ) )
+ {
+ delete_category( $row['id'] );
+ }
+ }
+
+ return $output;
+}
+
+// insert_remote_image searchs the "root" node of the xml_dir given and
+// insert the contained pictures if the are not in the database yet.
+function insert_remote_image( $xml_dir, $category_id )
+{
+ global $count_new,$lang;
+
+ $output = '';
+ $root = getChild( $xml_dir, 'root' );
+ $pictures = array();
+ $xml_pictures = getChildren( $root, 'picture' );
+ for ( $j = 0; $j < sizeof( $xml_pictures ); $j++ )
+ {
+ //<picture file="albatros.jpg" tn_ext="png" date="2002-04-14"
+ // filesize="35" width="640" height="480" />
+ $file = getAttribute( $xml_pictures[$j], 'file' );
+ $tn_ext = getAttribute( $xml_pictures[$j], 'tn_ext' );
+ $date = getAttribute( $xml_pictures[$j], 'date' );
+ $filesize = getAttribute( $xml_pictures[$j], 'filesize' );
+ $width = getAttribute( $xml_pictures[$j], 'width' );
+ $height = getAttribute( $xml_pictures[$j], 'height' );
+
+ $pictures[$j] = $file;
+
+ // is the picture already existing in the database ?
+ $query = 'select id,tn_ext';
+ $query.= ' from '.PREFIX_TABLE.'images';
+ $query.= ' where cat_id = '.$category_id;
+ $query.= " and file = '".$file."'";
+ $query.= ';';
+ $result = mysql_query( $query );
+ $query = '';
+ if ( mysql_num_rows( $result ) == 0 )
+ {
+ $query = 'insert into '.PREFIX_TABLE.'images';
+ $query.= ' (file,cat_id,date_available,tn_ext,filesize,width,height)';
+ $query.= ' values (';
+ $query.= "'".$file."'";
+ $query.= ",'".$category_id."'";
+ $query.= ",'".$date."'";
+ $query.= ",'".$tn_ext."'";
+ $query.= ",'".$filesize."'";
+ $query.= ",'".$width."'";
+ $query.= ",'".$height."'";
+ $query.= ')';
+ $query.= ';';
+
+ $output.= $file;
+ $output.= ' <span style="font-weight:bold;">';
+ $output.= $lang['update_research_added'].'</span>';
+ $output.= ' ('.$lang['update_research_tn_ext'].' '.$tn_ext.')<br />';
+
+ $count_new++;
+ }
+ else
+ {
+ // is the tn_ext the same in the xml file and in the database ?
+ $row = mysql_fetch_array( $result );
+ if ( $row['tn_ext'] != $tn_ext )
+ {
+ $query = 'update '.PREFIX_TABLE.'images';
+ $query.= ' set';
+ $query.= " tn_ext = '".$tn_ext."'";
+ $query.= ' where cat_id = '.$category_id;
+ $query.= " and file = '".$file."'";
+ $query.= ';';
+ }
+ }
+ // execution of the query
+ if ( $query != '' )
+ {
+ mysql_query( $query );
+ }
+ }
+ // we have to remove the pictures of the database not present in the xml file
+ // (ie deleted from the picture storage server)
+ $query = 'select id,file';
+ $query.= ' from '.PREFIX_TABLE.'images';
+ $query.= ' where cat_id = '.$category_id;
+ $query.= ';';
+ $result = mysql_query( $query );
+ while ( $row = mysql_fetch_array( $result ) )
+ {
+ // is the file in the xml file ?
+ if ( !in_array( $row['file'], $pictures ) )
+ {
+ delete_image( $row['id'] );
+ }
+ }
+ return $output;
+}
+//----------------------------------------------------- template initialization
+$sub = $vtp->Open( '../template/'.$user['template'].'/admin/update.vtp' );
+$tpl = array( 'update_default_title', 'update_only_cat', 'update_all',
+ 'update_research_conclusion', 'update_deletion_conclusion',
+ 'remote_site', 'update_part_research' );
+templatize_array( $tpl, 'lang', $sub );
+//-------------------------------------------- introduction : choices of update
+// Display choice if "update" var is not specified
+check_cat_id( $_GET['update'] );
+if ( !isset( $_GET['update'] )
+ and !( isset( $page['cat'] )
+ or $_GET['update'] == 'cats'
+ or $_GET['update'] == 'all' ) )
+{
+ $vtp->addSession( $sub, 'introduction' );
+ // only update the categories, not the pictures.
+ $url = add_session_id( './admin.php?page=update&amp;update=cats' );
+ $vtp->setVar( $sub, 'introduction.only_cat:url', $url );
+ // update the entire tree folder
+ $url = add_session_id( './admin.php?page=update&amp;update=all' );
+ $vtp->setVar( $sub, 'introduction.all:url', $url );
+ $vtp->closeSession( $sub, 'introduction' );
+}
+//------------------------------------------------- local update : ../galleries
+else
+{
+ $count_new = 0;
+ $count_deleted = 0;
+ $vtp->addSession( $sub, 'local_update' );
+ if ( isset( $page['cat'] ) )
+ {
+ $categories = insert_local_category( $page['cat'] );
+ }
+ else
+ {
+ $categories = insert_local_category( 'NULL' );
+ }
+ $vtp->setVar( $sub, 'local_update.categories', $categories );
+ $vtp->setVar( $sub, 'local_update.count_new', $count_new );
+ $vtp->setVar( $sub, 'local_update.count_deleted', $count_deleted );
+ $vtp->closeSession( $sub, 'local_update' );
+}
+//------------------------------------------------- remote update : listing.xml
+if ( @is_file( './listing.xml' ) )
+{
+ $count_new = 0;
+ $count_deleted = 0;
+ $vtp->addSession( $sub, 'remote_update' );
+
+ remote_images();
+ $vtp->setVar( $sub, 'remote_update.count_new', $count_new );
+ $vtp->setVar( $sub, 'remote_update.count_deleted', $count_deleted );
+
+ $vtp->closeSession( $sub, 'remote_update' );
+}
+//----------------------------------------------------------- sending html code
+$vtp->Parse( $handle , 'sub', $sub );
+?> \ No newline at end of file
diff --git a/admin/user_add.php b/admin/user_add.php
index ef50c13f1..d138c4933 100644
--- a/admin/user_add.php
+++ b/admin/user_add.php
@@ -63,7 +63,7 @@ if ( !isset( $_POST['status'] ) )
{
$_POST['status'] = 'guest';
}
-$option = get_enums( $prefixeTable.'users', 'status' );
+$option = get_enums( PREFIX_TABLE.'users', 'status' );
for ( $i = 0; $i < sizeof( $option ); $i++ )
{
$vtp->addSession( $sub, 'status_option' );
diff --git a/admin/user_list.php b/admin/user_list.php
index bcf6cc988..d4289489d 100644
--- a/admin/user_list.php
+++ b/admin/user_list.php
@@ -41,7 +41,7 @@ $vtp->setGlobalVar( $sub, 'listuser_button_create_address',
if ( isset ( $_GET['delete'] ) and is_numeric( $_GET['delete'] ) )
{
$query = 'select username';
- $query.= ' from '.$prefixeTable.'users';
+ $query.= ' from '.PREFIX_TABLE.'users';
$query.= ' where id = '.$_GET['delete'];
$query.= ';';
$row = mysql_fetch_array( mysql_query( $query ) );
@@ -65,7 +65,7 @@ if ( isset ( $_GET['delete'] ) and is_numeric( $_GET['delete'] ) )
and $row['username'] != $conf['webmaster'] )
{
$query = 'select count(*) as nb_result';
- $query.= ' from '.$prefixeTable.'users';
+ $query.= ' from '.PREFIX_TABLE.'users';
$query.= ' where id = '.$_GET['delete'];
$query.= ';';
$row2 = mysql_fetch_array( mysql_query( $query ) );
@@ -103,7 +103,7 @@ else
$vtp->setVar( $sub, 'users.form_action', $action );
$query = 'select id,username,status,mail_address';
- $query.= ' from '.$prefixeTable.'users';
+ $query.= ' from '.PREFIX_TABLE.'users';
$query.= ' order by status asc, username asc';
$query.= ';';
$result = mysql_query( $query );
@@ -217,7 +217,7 @@ else
$i = 0;
$query = 'select';
$query.= ' id,mail_address';
- $query.= ' from '.$prefixeTable.'users';
+ $query.= ' from '.PREFIX_TABLE.'users';
$query.= ';';
$result = mysql_query( $query );
while ( $row = mysql_fetch_array( $result ) )
diff --git a/admin/user_modify.php b/admin/user_modify.php
index 6e14589c3..4989c31e2 100644
--- a/admin/user_modify.php
+++ b/admin/user_modify.php
@@ -30,7 +30,7 @@ $display_form = true;
// id in $_GET['user_id']
$query = 'select';
$query.= ' username,status,mail_address';
-$query.= ' from '.$prefixeTable.'users';
+$query.= ' from '.PREFIX_TABLE.'users';
$query.= ' where id = '.$_GET['user_id'];
$query.= ';';
$row = mysql_fetch_array( mysql_query( $query ) );
@@ -107,7 +107,7 @@ if ( $display_form )
{
$_POST['status'] = 'guest';
}
- $option = get_enums( $prefixeTable.'users', 'status' );
+ $option = get_enums( PREFIX_TABLE.'users', 'status' );
for ( $i = 0; $i < sizeof( $option ); $i++ )
{
$vtp->addSession( $sub, 'status_option' );
diff --git a/admin/waiting.php b/admin/waiting.php
index 9e8f16dcc..927c976ae 100644
--- a/admin/waiting.php
+++ b/admin/waiting.php
@@ -19,7 +19,7 @@
if ( isset( $HTTP_POST_VARS['submit'] ) )
{
$query = "select id,cat_id,file,tn_ext";
- $query.= " from $prefixeTable"."waiting";
+ $query.= " from PREFIX_TABLE"."waiting";
$query.= ";";
$result = mysql_query( $query );
while ( $row = mysql_fetch_array( $result ) )
@@ -27,7 +27,7 @@
$key = "validate-".$row['id'];
if ( isset( $HTTP_POST_VARS[$key] ) )
{
- $query = "delete from $prefixeTable"."waiting";
+ $query = "delete from PREFIX_TABLE"."waiting";
$query.= " where id = ".$row['id'];
$query.= ";";
mysql_query( $query );
@@ -59,7 +59,7 @@
<th style=\"width:1px;\">&nbsp;</th>
</tr>";
$query = "select id,cat_id,file,username,mail_address,date,tn_ext";
- $query.= " from $prefixeTable"."waiting";
+ $query.= " from PREFIX_TABLE"."waiting";
$query.= " order by cat_id";
$query.= ";";
$result = mysql_query( $query );