Go to most recent revision | Blame | Last modification | View Log | Download
<?php/*************************Coppermine Photo Gallery************************Copyright (c) 2003-2005 Coppermine Dev Teamv1.1 originaly written by Gregory DEMARThis program is free software; you can redistribute it and/or modifyit under the terms of the GNU General Public License as published bythe 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"> </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-02if (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 = ' <b>' . $warnings . '<b>';echo <<<EOT<tr><td class="tableb">$ident<img src="images/folder.gif" alt="" /> <a href= "$PHP_SELF?startdir=$start_target">$file</a>$warnings</td></tr>EOT;display_dir_tree($folder . $file . '/', $ident . ' ');}}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-02CPGscandir($dir . $directory . '/', $expic_array);}}return $count;}/*** Main code*/$album_array = array();getallalbumsindb($album_array);// We need at least one albumif (!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-02getallpicindb($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();}?>