|
{$lang_editpics_php['approve']}
{$lang_editpics_php['postpone_app']}
{$lang_editpics_php['del_pic']}
|
EOT;
} else {
echo <<
{$lang_editpics_php['del_pic']}
{$lang_editpics_php['reset_view_count']}
{$lang_editpics_php['reset_votes']}
{$lang_editpics_php['del_comm']}
|
EOT;
}
}
function form_input($text, $name, $max_length,$field_width=100)
{
global $CURRENT_PIC;
$value = $CURRENT_PIC[$name];
$name .= $CURRENT_PIC['pid'];
if ($text == '') {
echo " \n";
return;
}
echo <<
$text
|
|
EOT;
}
function form_alb_list_box($text, $name)
{
global $CONFIG, $CURRENT_PIC;
global $user_albums_list, $public_albums_list;
$sel_album = $CURRENT_PIC['aid'];
$name .= $CURRENT_PIC['pid'];
echo <<
$text
|
|
EOT;
}
function form_textarea($text, $name, $max_length)
{
global $ALBUM_DATA, $CURRENT_PIC;
$value = $CURRENT_PIC[$name];
$name .= $CURRENT_PIC['pid'];
echo <<
$text
|
|
EOT;
}
function create_form(&$data)
{
foreach($data as $element){
if ((is_array($element))) {
switch($element[2]){
case 0 :
form_input($element[0], $element[1], $element[3]);
break;
case 1 :
form_alb_list_box($element[0], $element[1]);
break;
case 2 :
form_textarea($element[0], $element[1], $element[3]);
break;
case 3 :
form_pic_info($element[0]);
break;
case 4 :
form_options();
break;
default:
cpg_die(CRITICAL_ERROR, 'Invalid action for form creation', __FILE__, __LINE__);
} // switch
} else {
form_label($element);
}
}
}
function get_user_albums($user_id)
{
global $CONFIG, $USER_ALBUMS_ARRAY, $user_albums_list;
if (!isset($USER_ALBUMS_ARRAY[$user_id])) {
$user_albums = db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='".(FIRST_USER_CAT + $user_id)."' ORDER BY title");
if (mysql_num_rows($user_albums)) {
$user_albums_list=db_fetch_rowset($user_albums);
} else {
$user_albums_list = array();
}
mysql_free_result($user_albums);
$USER_ALBUMS_ARRAY[$user_id] = $user_albums_list;
} else {
$user_albums_list = &$USER_ALBUMS_ARRAY[$user_id];
}
}
if (GALLERY_ADMIN_MODE) {
$public_albums = db_query("SELECT DISTINCT aid, title, IF(category = 0, CONCAT('> ', title), CONCAT(name,' < ',title)) AS cat_title FROM {$CONFIG['TABLE_ALBUMS']}, {$CONFIG['TABLE_CATEGORIES']} WHERE category < '" . FIRST_USER_CAT . "' AND (category = 0 OR category = cid) ORDER BY cat_title");
if (mysql_num_rows($public_albums)) {
$public_albums_list=db_fetch_rowset($public_albums);
} else {
$public_albums_list = array();
}
mysql_free_result($public_albums);
} else {
$public_albums_list = array();
}
get_user_albums(USER_ID);
if (count($HTTP_POST_VARS)) process_post_data();
$start = isset($HTTP_GET_VARS['start']) ? (int)$HTTP_GET_VARS['start'] : 0;
$count = isset($HTTP_GET_VARS['count']) ? (int)$HTTP_GET_VARS['count'] : 25;
$next_target = $PHP_SELF.'?album='.$album_id.'&start='.($start+$count).'&count='.$count.((UPLOAD_APPROVAL_MODE==1)?"&mode=upload_approval":"");
$prev_target = $PHP_SELF.'?album='.$album_id.'&start='.max(0,$start-$count).'&count='.$count.((UPLOAD_APPROVAL_MODE==1)?"&mode=upload_approval":"");
$s50 = $count == 50 ? 'selected' : '';
$s75 = $count == 75 ? 'selected' : '';
$s100 = $count == 100 ? 'selected' : '';
if (UPLOAD_APPROVAL_MODE) {
$result=db_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'NO'");
$nbEnr = mysql_fetch_array($result);
$pic_count = $nbEnr[0];
// Update user names for pictures
$sql = "SELECT pid, owner_id FROM {$CONFIG['TABLE_PICTURES']} WHERE owner_id != 0 AND owner_name = ''";
$result = db_query($sql);
while($row = mysql_fetch_array($result)){
if(defined('UDB_INTEGRATION')){
$owner_name = udb_get_user_name($row['owner_id']);
} else {
$result2 = db_query("SELECT user_name FROM {$CONFIG['TABLE_USERS']} WHERE user_id = '".$row['owner_id']."'");
if (mysql_num_rows($result2)){
$row2 = mysql_fetch_array($result2);
mysql_free_result($result2);
$owner_name = $row2['user_name'];
} else {
$owner_name = '';
}
}
if($owner_name){
db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET owner_name = '$owner_name' WHERE pid = {$row['pid']} LIMIT 1");
} else {
db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET owner_id = 0 WHERE pid = {$row['pid']} LIMIT 1");
}
}
mysql_free_result($result);
$sql = "SELECT * ".
"FROM {$CONFIG['TABLE_PICTURES']} ".
"WHERE approved = 'NO' ".
"ORDER BY pid ".
"LIMIT $start, $count";
$result = db_query($sql);
$form_target = $PHP_SELF.'?mode=upload_approval&start='.$start.'&count='.$count;
$title = $lang_editpics_php['upl_approval'];
} else {
$result=db_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = '$album_id'");
$nbEnr = mysql_fetch_array($result);
$pic_count = $nbEnr[0];
mysql_free_result($result);
$result = db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = '$album_id' ORDER BY filename LIMIT $start, $count");
$form_target = $PHP_SELF.'?album='.$album_id.'&start='.$start.'&count='.$count;
$title = $lang_editpics_php['edit_pics'];
}
if (!mysql_num_rows($result)) cpg_die(INFORMATION, $lang_errors['no_img_to_display'], __FILE__, __LINE__);
if ($start + $count < $pic_count) {
$next_link = "{$lang_editpics_php['see_next']} - ";
} else {
$next_link = '';
}
if ($start > 0) {
$prev_link = "{$lang_editpics_php['see_prev']} - ";
} else {
$prev_link = '';
}
$pic_count_text = sprintf($lang_editpics_php['n_pic'], $pic_count);
pageheader($title);
starttable("100%", $title, 3);
echo <<
function textCounter(field, maxlimit) {
if (field.value.length > maxlimit) // if too long...trim it!
field.value = field.value.substring(0, maxlimit);
}
EOT;
$mode= (UPLOAD_APPROVAL_MODE==1) ? "&mode=upload_approval":"";
echo <<
|
EOT;
while($CURRENT_PIC = mysql_fetch_array($result)){
if (GALLERY_ADMIN_MODE) get_user_albums($CURRENT_PIC['owner_id']);
create_form($data);
flush();
} // while
mysql_free_result($result);
echo <<
|
EOT;
endtable();
pagefooter();
ob_end_flush();
?>