| 0,0 → 1,452 |
|---|
| <?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/modifyalb.php,v $ |
| $Revision: 1.7 $ |
| $Author: gaugau $ |
| $Date: 2005/04/19 03:17:11 $ |
| **********************************************/ |
| /* |
| $Id: modifyalb.php,v 1.7 2005/04/19 03:17:11 gaugau Exp $ |
| */ |
| |
| define('IN_COPPERMINE', true); |
| define('MODIFYALB_PHP', true); |
| |
| include("include/init.inc.php"); |
| |
| if (!(GALLERY_ADMIN_MODE || USER_ADMIN_MODE)) { |
| cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__); |
| } |
| // Type 0 => input |
| // 1 => yes/no |
| // 2 => Category |
| // 3 => Textarea |
| // 4 => Album thumbnail |
| // 5 => Album visibility |
| |
| // add footnote |
| $notice1 = ' *'; |
| |
| $captionLabel = $lang_modifyalb_php['alb_desc']; |
| if ($CONFIG['show_bbcode_help']) {$captionLabel .= '<hr />'.$lang_bbcode_help;} |
| $data = array($lang_modifyalb_php['general_settings'], |
| array($lang_modifyalb_php['alb_title'], 'title', 0), |
| array($lang_modifyalb_php['alb_cat'], 'category', 2), |
| array($captionLabel, 'description', 3), |
| array($lang_modifyalb_php['alb_thumb'], 'thumb', 4), |
| $lang_modifyalb_php['alb_perm'], |
| array($lang_modifyalb_php['can_view'], 'visibility', 5), |
| array($lang_modifyalb_php['can_upload'].$notice1, 'uploads', 1), |
| array($lang_modifyalb_php['can_post_comments'].$notice1, 'comments', 1), |
| array($lang_modifyalb_php['can_rate'].$notice1, 'votes', 1), |
| ); |
| |
| function get_subcat_data($parent, $ident = '') |
| { |
| global $CONFIG, $CAT_LIST; |
| |
| $result = db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '$parent' AND cid != 1 ORDER BY pos"); |
| if (mysql_num_rows($result) > 0) { |
| $rowset = db_fetch_rowset($result); |
| foreach ($rowset as $subcat) { |
| $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']); |
| get_subcat_data($subcat['cid'], $ident . ' '); |
| } |
| } |
| } |
| |
| function form_label($text) |
| { |
| echo <<<EOT |
| <tr> |
| <td class="tableh2" colspan="2"> |
| <b>$text</b> |
| </td> |
| </tr> |
| |
| EOT; |
| } |
| |
| function form_input($text, $name) |
| { |
| global $ALBUM_DATA; |
| |
| $value = $ALBUM_DATA[$name]; |
| |
| echo <<<EOT |
| <tr> |
| <td width="40%" class="tableb"> |
| $text |
| </td> |
| <td width="60%" class="tableb" valign="top"> |
| <input type="text" style="width: 100%" name="$name" value="$value" class="textinput"> |
| </td> |
| </tr> |
| |
| EOT; |
| } |
| |
| function form_yes_no($text, $name) |
| { |
| global $ALBUM_DATA, $lang_yes, $lang_no; |
| |
| if ($name == 'uploads' && USER_ADMIN_MODE) { |
| echo " <input type=\"hidden\" name=\"$name\" value=\"{$ALBUM_DATA['uploads']}\">"; |
| return; |
| } |
| |
| $value = isset($ALBUM_DATA[$name]) ? $ALBUM_DATA[$name] : false; |
| $yes_selected = $value == 'YES' ? 'checked="checked"' : ''; |
| $no_selected = $value == 'NO' ? 'checked="checked"' : ''; |
| |
| echo <<<EOT |
| <tr> |
| <td class="tableb"> |
| $text |
| </td> |
| <td class="tableb" valign="top"> |
| <input type="radio" id="{$name}1" name="$name" value="YES" $yes_selected /><label for="{$name}1" class="clickable_option">$lang_yes</label> |
| |
| <input type="radio" id="{$name}0" name="$name" value="NO" $no_selected /><label for="{$name}0" class="clickable_option">$lang_no</label> |
| </td> |
| </tr> |
| |
| EOT; |
| } |
| |
| function form_category($text, $name) |
| { |
| global $ALBUM_DATA, $CAT_LIST, $USER_DATA, $lang_modifyalb_php; |
| |
| if (!GALLERY_ADMIN_MODE || $ALBUM_DATA['category'] > FIRST_USER_CAT) { |
| echo <<<EOT |
| <tr> |
| <td class="tableb"> |
| $text |
| </td> |
| <td class="tableb" valign="top"> |
| <i>{$lang_modifyalb_php['user_gal']}</i> |
| <input type="hidden" name="$name" value="{$ALBUM_DATA['category']}"> |
| </td> |
| |
| EOT; |
| return; |
| } |
| |
| $CAT_LIST = array(); |
| $CAT_LIST[] = array(0, $lang_modifyalb_php['no_cat']); |
| get_subcat_data(0, ''); |
| |
| echo <<<EOT |
| <tr> |
| <td class="tableb"> |
| $text |
| </td> |
| <td class="tableb" valign="top"> |
| <select name="$name" class="listbox"> |
| EOT; |
| foreach($CAT_LIST as $category) { |
| echo ' <option value="' . $category[0] . '"' . ($ALBUM_DATA['category'] == $category[0] ? ' selected': '') . ">" . $category[1] . "</option>\n"; |
| } |
| echo <<<EOT |
| </select> |
| </td> |
| </tr> |
| |
| EOT; |
| } |
| |
| function form_textarea($text, $name) |
| { |
| global $ALBUM_DATA; |
| |
| $value = $ALBUM_DATA[$name]; |
| |
| echo <<<EOT |
| <tr> |
| <td class="tableb" valign="top"> |
| $text |
| </td> |
| <td class="tableb" valign="top"> |
| <textarea name="$name" rows="5" cols="40" wrap="virtual" class="textinput" style="width: 100%;">{$ALBUM_DATA['description']}</textarea> |
| </td> |
| </tr> |
| EOT; |
| } |
| |
| function form_alb_thumb($text, $name) |
| { |
| global $CONFIG, $ALBUM_DATA, $album, $lang_modifyalb_php; |
| |
| $results = db_query("SELECT pid, filepath, filename, url_prefix FROM {$CONFIG['TABLE_PICTURES']} WHERE aid='$album' AND approved='YES' ORDER BY filename"); |
| if (mysql_num_rows($results) == 0) { |
| echo <<<EOT |
| <tr> |
| <td class="tableb" valign="top"> |
| $text |
| </td> |
| <td class="tableb" valign="top"> |
| <i>{$lang_modifyalb_php['alb_empty']}</i> |
| <input type="hidden" name="$name" value="0"> |
| </td> |
| </tr> |
| |
| EOT; |
| return; |
| } |
| |
| echo <<<EOT |
| <script language="JavaScript" type="text/JavaScript"> |
| var Pic = new Array() |
| |
| Pic[0] = 'images/nopic.jpg' |
| |
| EOT; |
| |
| $initial_thumb_url = 'images/nopic.jpg'; |
| $img_list = array(0 => $lang_modifyalb_php['last_uploaded']); |
| while ($picture = mysql_fetch_array($results)) { |
| $thumb_url = get_pic_url($picture, 'thumb'); |
| echo "Pic[{$picture['pid']}] = '" . $thumb_url . "'\n"; |
| if ($picture['pid'] == $ALBUM_DATA[$name]) $initial_thumb_url = $thumb_url; |
| $img_list[$picture['pid']] = htmlspecialchars($picture['filename']); |
| } // while |
| echo <<<EOT |
| |
| function ChangeThumb(index) |
| { |
| document.images.Thumb.src = Pic[index] |
| } |
| </script> |
| |
| EOT; |
| $thumb_cell_height = $CONFIG['thumb_width'] + 17; |
| echo <<<EOT |
| <tr> |
| <td class="tableb" valign="top"> |
| $text |
| </td> |
| <td class="tableb" align="center"> |
| <table cellspacing="0" cellpadding="5" border="0"> |
| <tr> |
| <td width="$thumb_cell_height" height="$thumb_cell_height" align="center"><img src="$initial_thumb_url" name='Thumb' class='image' /><br /></td> |
| </tr> |
| </table> |
| <select name="$name" class="listbox" onChange="if(this.options[this.selectedIndex].value) ChangeThumb(this.options[this.selectedIndex].value);" onKeyUp="if(this.options[this.selectedIndex].value) ChangeThumb(this.options[this.selectedIndex].value);"> |
| |
| EOT; |
| foreach($img_list as $pid => $pic_name) { |
| echo ' <option value="' . $pid . '"' . ($pid == $ALBUM_DATA[$name] ? ' selected':'') . '>' . $pic_name . "</option>\n"; |
| } |
| echo <<<EOT |
| </select> |
| </td> |
| </tr> |
| |
| EOT; |
| } |
| |
| function form_visibility($text, $name) |
| { |
| global $CONFIG, $USER_DATA, $ALBUM_DATA, $lang_modifyalb_php; |
| |
| if (!$CONFIG['allow_private_albums']) { |
| echo ' <input type="hidden" name="' . $name . '" value="0">' . "\n"; |
| return; |
| } |
| |
| if (GALLERY_ADMIN_MODE) { |
| $options = array(0 => $lang_modifyalb_php['public_alb'], FIRST_USER_CAT + USER_ID => $lang_modifyalb_php['me_only']); |
| if ($ALBUM_DATA['category'] > FIRST_USER_CAT) { |
| if (defined('UDB_INTEGRATION')) { |
| $owner_name = udb_get_user_name($ALBUM_DATA['category'] - FIRST_USER_CAT); |
| } else { |
| $result = db_query("SELECT user_name FROM {$CONFIG['TABLE_USERS']} WHERE user_id='" . ($ALBUM_DATA['category'] - FIRST_USER_CAT) . "'"); |
| if (mysql_num_rows($result)) { |
| $user = mysql_fetch_array($result); |
| $owner_name = $user['user_name']; |
| } |
| } |
| $options[$ALBUM_DATA['category']] = sprintf($lang_modifyalb_php['owner_only'], $owner_name); |
| } |
| $result = db_query("SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} WHERE 1"); |
| while ($group = mysql_fetch_array($result)) { |
| $options[$group['group_id']] = sprintf($lang_modifyalb_php['groupp_only'], $group['group_name']); |
| } // while |
| } else { |
| $options = array(0 => $lang_modifyalb_php['public_alb'], |
| FIRST_USER_CAT + USER_ID => $lang_modifyalb_php['me_only'], |
| ); |
| $result = db_query("SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id IN " . USER_GROUP_SET); |
| while ($group = mysql_fetch_array($result)) { |
| $options[$group['group_id']] = sprintf($lang_modifyalb_php['groupp_only'], $group['group_name']); |
| } // while |
| } |
| echo <<<EOT |
| <tr> |
| <td class="tableb"> |
| $text |
| </td> |
| <td class="tableb" valign="top"> |
| <select name="$name" class="listbox"> |
| |
| EOT; |
| foreach ($options as $value => $caption) { |
| echo ' <option value ="' . $value . '"' . ($ALBUM_DATA['visibility'] == $value ? ' selected': '') . '>' . $caption . "</option>\n"; |
| } |
| echo <<<EOT |
| </select> |
| </td> |
| </tr> |
| |
| EOT; |
| } |
| |
| function create_form(&$data) |
| { |
| foreach($data as $element) { |
| if ((is_array($element))) { |
| switch ($element[2]) { |
| case 0 : |
| form_input($element[0], $element[1]); |
| break; |
| case 1 : |
| form_yes_no($element[0], $element[1]); |
| break; |
| case 2 : |
| form_category($element[0], $element[1]); |
| break; |
| case 3 : |
| form_textarea($element[0], $element[1]); |
| break; |
| case 4 : |
| form_alb_thumb($element[0], $element[1]); |
| break; |
| case 5 : |
| form_visibility($element[0], $element[1]); |
| break; |
| default: |
| cpg_die(CRITICAL_ERROR, 'Invalid action for form creation', __FILE__, __LINE__); |
| } // switch |
| } else { |
| form_label($element); |
| } |
| } |
| } |
| |
| function alb_list_box() |
| { |
| global $CONFIG, $album, $PHP_SELF; |
| |
| if (GALLERY_ADMIN_MODE) { |
| $result = db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category < '" . FIRST_USER_CAT . "' ORDER BY title"); |
| $rowset = db_fetch_rowset($result); |
| 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); |
| } else { |
| $result = db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = '" . (FIRST_USER_CAT + USER_ID) . "' ORDER BY title"); |
| $rowset = db_fetch_rowset($result); |
| mysql_free_result($result); |
| } |
| |
| if (count($rowset)) { |
| $lb = "<select name=\"album_listbox\" class=\"listbox\" onChange=\"if(this.options[this.selectedIndex].value) window.location.href='$PHP_SELF?album='+this.options[this.selectedIndex].value;\">\n"; |
| foreach ($rowset as $row) { |
| $selected = ($row['aid'] == $album) ? "SELECTED" : ""; |
| $lb .= " <option value=\"" . $row['aid'] . "\" $selected>" . $row['title'] . "</option>\n"; |
| } |
| $lb .= "</select>\n"; |
| return $lb; |
| } |
| } |
| |
| if (!isset($HTTP_GET_VARS['album'])) { |
| if (GALLERY_ADMIN_MODE) { |
| $results = db_query("SELECT * FROM {$CONFIG['TABLE_ALBUMS']} WHERE 1 LIMIT 1"); |
| } else { |
| $results = db_query("SELECT * FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = " . (FIRST_USER_CAT + USER_ID) . " LIMIT 1"); |
| } |
| if (mysql_num_rows($results) == 0) cpg_die(ERROR, $lang_modifyalb_php['err_no_alb_to_modify'], __FILE__, __LINE__); |
| $ALBUM_DATA = mysql_fetch_array($results); |
| $album = $ALBUM_DATA['aid']; |
| } else { |
| $album = (int)$HTTP_GET_VARS['album']; |
| $results = db_query("SELECT * FROM {$CONFIG['TABLE_ALBUMS']} WHERE aid='$album'"); |
| if (!mysql_num_rows($results)) cpg_die(CRITICAL_ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__); |
| $ALBUM_DATA = mysql_fetch_array($results); |
| } |
| |
| $cat = $ALBUM_DATA['category']; |
| $actual_cat = $cat; |
| |
| if (!GALLERY_ADMIN_MODE && $ALBUM_DATA['category'] != FIRST_USER_CAT + USER_ID) { |
| cpg_die(ERROR, $lang_errors['perm_denied'], __FILE__, __LINE__); |
| } |
| |
| pageheader(sprintf($lang_modifyalb_php['upd_alb_n'], $ALBUM_DATA['title'])); |
| starttable("100%"); |
| |
| $album_lb = alb_list_box(); |
| |
| echo <<<EOT |
| <tr> |
| <td colspan="2" class="tableh1"> |
| <table width="100%" cellpadding="0" cellspacing="0" border="0"> |
| <tr> |
| <td class="statlink"><h2>{$lang_modifyalb_php['update']}</h2></td> |
| <td align="right">$album_lb</td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| <form method="post" action="db_input.php"> |
| <input type="hidden" name="event" value="album_update"> |
| <input type="hidden" name="aid" value="$album"> |
| |
| EOT; |
| create_form($data); |
| echo <<<EOT |
| <tr> |
| <td colspan="2" align="left" class="tablef"> |
| EOT; |
| if (GALLERY_ADMIN_MODE) { |
| printf($lang_modifyalb_php['notice1'],'<a href="groupmgr.php">','</a>'); |
| } |
| else { |
| printf($lang_modifyalb_php['notice1'],'',''); |
| } |
| echo <<<EOT |
| </td> |
| </tr> |
| <tr> |
| <td colspan="2" align="center" class="tablef"> |
| <input type="submit" class="button" value="{$lang_modifyalb_php['update']}"> |
| </td> |
| </form> |
| </tr> |
| EOT; |
| |
| endtable(); |
| pagefooter(); |
| ob_end_flush(); |
| |
| ?> |