Subversion Repositories svnkaklik

Compare Revisions

Ignore whitespace Rev 5 → Rev 6

/web/test/gallery/cpg133/searchnew.php
0,0 → 1,480
<?php
/*************************
Coppermine Photo Gallery
************************
Copyright (c) 2003-2005 Coppermine Dev Team
v1.1 originaly written by Gregory DEMAR
 
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; either version 2 of the License, or
(at your option) any later version.
********************************************
Coppermine version: 1.3.3
$Source: /cvsroot/coppermine/stable/searchnew.php,v $
$Revision: 1.10 $
$Author: gaugau $
$Date: 2005/04/19 03:17:11 $
**********************************************/
 
define('IN_COPPERMINE', true);
define('SEARCHNEW_PHP', true);
 
require('include/init.inc.php');
 
if (!GALLERY_ADMIN_MODE) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);
 
/**
* Local functions definition
*/
 
/**
* albumselect()
*
* return the HTML code for a listbox with name $id that contains the list
* of all albums
*
* @param string $id the name of the listbox
* @return the HTML code
*/
function albumselect($id = "album")
{
global $CONFIG, $lang_search_new_php;
static $select = "";
 
if ($select == "") {
$result = db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = 0 ORDER BY title");
$rowset = db_fetch_rowset($result);
mysql_free_result($result);
 
$result = db_query("SELECT DISTINCT a.aid as aid, a.title as title, c.name as cname FROM {$CONFIG['TABLE_ALBUMS']} as a, {$CONFIG['TABLE_CATEGORIES']} as c WHERE a.category = c.cid AND a.category < '" . FIRST_USER_CAT . "' ORDER BY cname,title");
while ($row = mysql_fetch_array($result)) {
$row['title'] = $row['cname'] . " - " . $row['title'];
$rowset[] = $row;
}
mysql_free_result($result);
 
if (defined('UDB_INTEGRATION')) {
$sql = udb_get_admin_album_list();
} else {
$sql = "SELECT aid, CONCAT('(', user_name, ') ', title) AS title " . "FROM {$CONFIG['TABLE_ALBUMS']} AS a " . "INNER JOIN {$CONFIG['TABLE_USERS']} AS u ON category = (" . FIRST_USER_CAT . " + user_id) " . "ORDER BY title";
}
$result = db_query($sql);
while ($row = mysql_fetch_array($result)) $rowset[] = $row;
mysql_free_result($result);
 
$select = '<option value="0">' . $lang_search_new_php['select_album'] . '</option>\n';
 
foreach ($rowset as $row) {
$select .= "<option value=\"" . $row["aid"] . "\">" . $row["title"] . "</option>\n";
}
}
 
return "\n<select name=\"$id\" class=\"listbox\">\n$select</select>\n";
}
 
/**
* dirheader()
*
* return the HTML code for the row to be displayed when we start a new
* directory
*
* @param $dir the directory
* @param $dirid the name of the listbox that will list the albums
* @return the HTML code
*/
function dirheader($dir, $dirid)
{
global $CONFIG, $lang_search_new_php;
$warning = '';
 
if (!is_writable($CONFIG['fullpath'] . $dir))
$warning = "<tr><td class=\"tableh2\" valign=\"middle\" colspan=\"3\">\n" . "<b>{$lang_search_new_php['warning']}</b>: {$lang_search_new_php['change_perm']}</td></tr>\n";
return "<tr><td class=\"tableh2\" valign=\"middle\" colspan=\"3\">\n" .
sprintf($lang_search_new_php['target_album'], $dir, albumselect($dirid)) . "</td></tr>\n" . $warning;
}
 
/**
* picrow()
*
* return the HTML code for a row to be displayed for an image
* the row contains a checkbox, the image name, a thumbnail
*
* @param $picfile the full path of the file that contains the picture
* @param $picid the name of the check box
* @return the HTML code
*/
function picrow($picfile, $picid, $albid)
{
global $CONFIG, $expic_array;
 
$encoded_picfile = base64_encode($picfile);
$picname = $CONFIG['fullpath'] . $picfile;
$pic_url = urlencode($picfile);
$pic_fname = basename($picfile);
$pic_dirname = dirname($picname);
 
$thumb_file = dirname($picname) . '/' . $CONFIG['thumb_pfx'] . $pic_fname;
if (file_exists($thumb_file)) {
$thumb_info = getimagesize($picname);
$thumb_size = compute_img_size($thumb_info[0], $thumb_info[1], 48);
$img = '<img src="' . path2url($thumb_file) . '" ' . $thumb_size['geom'] . ' class="thumbnail" border="0" />';
} elseif (is_image($picname)) {
$img = '<img src="showthumb.php?picfile=' . $pic_url . '&size=48" class="thumbnail" border="0">';
} else {
$file['filepath'] = $pic_dirname.'/'; //substr($picname,0,strrpos($picname,'/'))
$file['filename'] = $pic_fname;
$filepathname = get_pic_url($file,'thumb');
//$mime_content = get_type($picname);
//$extension = file_exists("images/thumb_{$mime_content['extension']}.jpg") ? $mime_content['extension']:$mime_content['content'];
//$img = '<img src="images/thumb_'.$extension.'.jpg" class="thumbnail" width="48" border="0">';
$img = '<img src="'.$filepathname.'" class="thumbnail" width="48" border="0">';
}
 
if (filesize($picname) && is_readable($picname)) {
//$fullimagesize = getimagesize($picname); COMMENTED OUT FOR VIDEO SUPPORT
$winsizeX = ($fullimagesize[0] + 16);
$winsizeY = ($fullimagesize[1] + 16);
 
//$checked = isset($expic_array[$picfile]) || !$fullimagesize ? '' : 'checked';
 
$checked = isset($expic_array[$picfile]) ? '' : 'checked';
 
return <<<EOT
<tr>
<td class="tableb" valign="middle">
<input name="pics[]" id="picselector" type="checkbox" value="$picid" $checked />
<input name="album_lb_id_$picid" type="hidden" value="$albid" />
<input name="picfile_$picid" type="hidden" value="$encoded_picfile" />
</td>
<td class="tableb" valign="middle" width="100%">
<a href="javascript:;" onClick= "MM_openBrWindow('displayimage.php?&fullsize=1&picfile=$pic_url', 'ImageViewer', 'toolbar=yes, status=yes, resizable=yes, width=$winsizeX, height=$winsizeY')">$pic_fname</a>
</td>
<td class="tableb" valign="middle" align="center">
<a href="javascript:;" onClick= "MM_openBrWindow('displayimage.php?&fullsize=1&picfile=$pic_url', 'ImageViewer', 'toolbar=yes, status=yes, resizable=yes, width=$winsizeX, height=$winsizeY')"><img src="images/spacer.gif" width="1" height="48" alt="" border="0" />$img<br /></a>
</td>
</tr>
EOT;
} else {
$winsizeX = (300);
$winsizeY = (300);
return <<<EOT
<tr>
<td class="tableb" valign="middle">
&nbsp;
</td>
<td class="tableb" valign="middle" width="100%">
<i>$pic_fname</i>
</td>
<td class="tableb" valign="middle" align="center">
<a href="javascript:;" onClick= "MM_openBrWindow('displayimage.php?&fullsize=1&picfile=$pic_url', 'ImageViewer', 'toolbar=yes, status=yes, resizable=yes, width=$winsizeX, height=$winsizeY')"><img src="showthumb.php?picfile=$pic_url&size=48" class="thumbnail" border="0" /><br /></a>
</td>
</tr>
EOT;
}
}
 
/**
* getfoldercontent()
*
* return the files and directories of a folder in two arrays
*
* @param $folder the folder to read
* @param $dir_array the array that will contain name of sub-dir
* @param $pic_array the array that will contain name of picture
* @param $expic_array an array that contains pictures already in db
* @return
*/
function getfoldercontent($folder, &$dir_array, &$pic_array, &$expic_array)
{
global $CONFIG;
$dir = opendir($CONFIG['fullpath'] . $folder);
while ($file = readdir($dir)) {
if (is_dir($CONFIG['fullpath'] . $folder . $file)) {
if ($file != "." && $file != "..")
$dir_array[] = $file;
}
if (is_file($CONFIG['fullpath'] . $folder . $file)) {
if (strncmp($file, $CONFIG['thumb_pfx'], strlen($CONFIG['thumb_pfx'])) != 0 && strncmp($file, $CONFIG['normal_pfx'], strlen($CONFIG['normal_pfx'])) != 0 && $file != 'index.html')
$pic_array[] = $file;
}
}
closedir($dir);
 
natcasesort($dir_array);
natcasesort($pic_array);
}
 
function display_dir_tree($folder, $ident)
{
global $CONFIG, $PHP_SELF, $lang_search_new_php;
$dir_path = $CONFIG['fullpath'] . $folder;
 
 
if (!is_readable($dir_path)) return;
 
$dir = opendir($dir_path);
while ($file = readdir($dir)) {
//if (is_dir($CONFIG['fullpath'] . $folder . $file) && $file != "." && $file != "..") { // removed by following line for 'do not show folders with dots': gaugau 03-11-02
if (is_dir($CONFIG['fullpath'] . $folder . $file) && substr($file,0,1) != "." && strpos($file,"'") == FALSE && $file != substr($CONFIG['userpics'],0,strlen($CONFIG['userpics'])-1) && $file != "edit" ) {
$start_target = $folder . $file;
$dir_path = $CONFIG['fullpath'] . $folder . $file;
 
$warnings = '';
if (!is_writable($dir_path)) $warnings .= $lang_search_new_php['dir_ro'];
if (!is_readable($dir_path)) $warnings .= $lang_search_new_php['dir_cant_read'];
 
if ($warnings) $warnings = '&nbsp;&nbsp;&nbsp;<b>' . $warnings . '<b>';
 
echo <<<EOT
<tr>
<td class="tableb">
$ident<img src="images/folder.gif" alt="" />&nbsp;<a href= "$PHP_SELF?startdir=$start_target">$file</a>$warnings
</td>
</tr>
EOT;
display_dir_tree($folder . $file . '/', $ident . '&nbsp;&nbsp;&nbsp;&nbsp;');
}
}
closedir($dir);
}
 
/**
* getallpicindb()
*
* Fill an array where keys are the full path of all images in the picture table
*
* @param $pic_array the array to be filled
* @return
*/
function getallpicindb(&$pic_array, $startdir)
{
global $CONFIG;
 
$sql = "SELECT filepath, filename " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE filepath LIKE '$startdir%'";
$result = db_query($sql);
while ($row = mysql_fetch_array($result)) {
$pic_file = $row['filepath'] . $row['filename'];
$pic_array[$pic_file] = 1;
}
mysql_free_result($result);
}
 
/**
* getallalbumsindb()
*
* Fill an array with all albums where keys are aid of albums and values are
* album title
*
* @param $album_array the array to be filled
* @return
*/
function getallalbumsindb(&$album_array)
{
global $CONFIG;
 
$sql = "SELECT aid, title " . "FROM {$CONFIG['TABLE_ALBUMS']} " . "WHERE 1";
$result = db_query($sql);
 
while ($row = mysql_fetch_array($result)) {
$album_array[$row['aid']] = $row['title'];
}
mysql_free_result($result);
}
 
/**
* CPGscandir() //renamed because php5 has same function as scandir()
*
* recursive function that scan a directory, create the HTML code for each
* picture and add new pictures in an array
*
* @param $dir the directory to be scanned
* @param $expic_array the array that contains pictures already in DB
* @param $newpic_array the array that contains new pictures found
* @return
*/
function CPGscandir($dir, &$expic_array)
{
$dir = str_replace(".","" ,$dir);
static $dir_id = 0;
static $count = 0;
static $pic_id = 0;
 
$pic_array = array();
$dir_array = array();
 
getfoldercontent($dir, $dir_array, $pic_array, $expic_array);
 
if (count($pic_array) > 0) {
$dir_id_str = sprintf("d%04d", $dir_id++);
echo dirheader($dir, $dir_id_str);
foreach ($pic_array as $picture) {
$count++;
$pic_id_str = sprintf("i%04d", $pic_id++);
echo picrow($dir . $picture, $pic_id_str, $dir_id_str);
}
}
if (count($dir_array) > 0) {
foreach ($dir_array as $directory) {
if (substr($directory,0,1) != ".") // added do not show folders with dots: gaugau 03-11-02
CPGscandir($dir . $directory . '/', $expic_array);
}
}
return $count;
}
 
/**
* Main code
*/
 
$album_array = array();
getallalbumsindb($album_array);
// We need at least one album
if (!count($album_array)) cpg_die(ERROR, $lang_search_new_php['need_one_album'], __FILE__, __LINE__);
 
if (isset($HTTP_POST_VARS['insert'])) {
if (!isset($HTTP_POST_VARS['pics'])) cpg_die(ERROR, $lang_search_new_php['no_pic_to_add'], __FILE__, __LINE__);
 
pageheader($lang_search_new_php['page_title']);
starttable("100%");
echo <<<EOT
<tr>
<td colspan="4" class="tableh1"><h2>{$lang_search_new_php['insert']}</h2></td>
</tr>
<tr>
<td class="tableh2" valign="middle" align="center"><b>{$lang_search_new_php['folder']}</b></td>
<td class="tableh2" valign="middle" align="center"><b>{$lang_search_new_php['image']}</b></td>
<td class="tableh2" valign="middle" align="center"><b>{$lang_search_new_php['album']}</b></td>
<td class="tableh2" valign="middle" align="center"><b>{$lang_search_new_php['result']}</b></td>
</tr>
EOT;
 
$count = 0;
foreach ($HTTP_POST_VARS['pics'] as $pic_id) {
$album_lb_id = $HTTP_POST_VARS['album_lb_id_' . $pic_id];
$album_id = $HTTP_POST_VARS[$album_lb_id];
 
$pic_file = base64_decode($HTTP_POST_VARS['picfile_' . $pic_id]);
$dir_name = dirname($pic_file) . "/";
$file_name = basename($pic_file);
 
if ($album_id) {
// To avoid problems with PHP scripts max execution time limit, each picture is
// added individually using a separate script that returns an image
$status = "<a href=\"addpic.php?aid=$album_id&pic_file=" . ($HTTP_POST_VARS['picfile_' . $pic_id]) . "&reload=" . uniqid('') . "\"><img src=\"addpic.php?aid=$album_id&pic_file=" . ($HTTP_POST_VARS['picfile_' . $pic_id]) . "&reload=" . uniqid('') . "\" class=\"thumbnail\" border=\"0\" width=\"24\" height=\"24\" alt=\"\" /><br /></a>";
$album_name = $album_array[$album_id];
} else {
$album_name = $lang_search_new_php['no_album'];
$status = "<img src=\"images/up_na.gif\" alt=\"" . $lang_search_new_php['no_album'] . "\" class=\"thumbnail\" border=\"0\" width=\"24\" height=\"24\" /><br />";
}
echo "<tr>\n";
echo "<td class=\"tableb\" valign=\"middle\" align=\"left\">$dir_name</td>\n";
echo "<td class=\"tableb\" valign=\"middle\" align=\"left\">$file_name</td>\n";
echo "<td class=\"tableb\" valign=\"middle\" align=\"left\">$album_name</td>\n";
echo "<td class=\"tableb\" valign=\"middle\" align=\"center\">$status</td>\n";
echo "</tr>\n";
$count++;
flush();
}
echo <<<EOT
<tr>
<td class="tableh2" colspan="4">
<b>{$lang_search_new_php['be_patient']}</b>
</td>
</tr>
<tr>
<td class="tableb" colspan="4">
{$lang_search_new_php['notes']}
</td>
</tr>
 
EOT;
endtable();
pagefooter();
ob_end_flush();
} elseif (isset($HTTP_GET_VARS['startdir'])) {
pageheader($lang_search_new_php['page_title']);
starttable("100%");
echo <<<EOT
<form method="post" action="$PHP_SELF?insert=1" name="selectPics">
<tr>
<td colspan="3" class="tableh1"><h2>{$lang_search_new_php['list_new_pic']}</h2></td>
</tr>
 
EOT;
$expic_array = array();
$check_all = $lang_search_new_php['check_all'];
$uncheck_all = $lang_search_new_php['uncheck_all'];
// added below table, JavaScript and additional check/uncheck options: gaugau 03-11-02
 
getallpicindb($expic_array, $HTTP_GET_VARS['startdir']);
if (CPGscandir($HTTP_GET_VARS['startdir'] . '/', $expic_array)) {
 
echo <<<EOT
<tr>
<td colspan="3" align="center" class="tablef">
<script language="javascript" type="text/javascript">
<!--
function checkAll(field)
{
for (i = 0; i < field.length; i++)
field[i].checked = true ;
}
 
function uncheckAll(field)
{
for (i = 0; i < field.length; i++)
field[i].checked = false ;
}
-->
</script>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left">
<input type="button" name="CheckAll" class="button" value="$check_all" onClick="checkAll(document.selectPics.picselector)">
<input type="button" name="UnCheckAll" class="button" value="$uncheck_all" onClick="uncheckAll(document.selectPics.picselector)">
</td>
<td align="center">
<input type="submit" class="button" name="insert" value="{$lang_search_new_php['insert_selected']}">
</td>
</tr>
</table>
</td>
</tr>
</form>
 
EOT;
} else {
echo <<<EOT
<tr>
<td colspan="3" align="center" class="tableb">
<br /><br />
<b>{$lang_search_new_php['no_pic_found']}</b>
<br /><br /><br />
</td>
</tr>
</form>
 
EOT;
}
endtable();
pagefooter();
ob_end_flush();
} else {
pageheader($lang_search_new_php['page_title']);
starttable(-1, $lang_search_new_php['select_dir']);
display_dir_tree('', '');
echo <<<EOT
<tr>
<td class="tablef">
<b>{$lang_search_new_php['select_dir_msg']}</b>
</td>
</tr>
 
EOT;
endtable();
pagefooter();
ob_end_flush();
}
 
?>