Файл: album_modcp.php
Строк: 454
<?php
/***************************************************************************
* album_modcp.php
* -------------------
* Разработка: (C) 2003 Smartor
* Модификация: чел
***************************************************************************/
/***************************************************************************
*
* Эта версия phpBB-WAP является бесплатным
* программным обеспечением и распространяется
* в рамках лицензии GNU General Public License.
* Автор модификации настоятельно не
* рекомендует распрострянять её так, как
* распространялась 5 версия мода.
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
$album_root_path = $phpbb_root_path . 'album_mod/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_ALBUM);
init_userprefs($userdata);
include($album_root_path . 'album_common.'.$phpEx);
if( isset($HTTP_GET_VARS['pic_id']) )
{
$pic_id = intval($HTTP_GET_VARS['pic_id']);
}
else
{
$pic_id = FALSE;
}
if( $pic_id != FALSE )
{
$sql = "SELECT *
FROM ". ALBUM_TABLE ."
WHERE pic_id = '$pic_id'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query pic information', '', __LINE__, __FILE__, $sql);
}
$thispic = $db->sql_fetchrow($result);
if( empty($thispic) )
{
message_die(GENERAL_ERROR, $lang['Pic_not_exist']);
}
$cat_id = $thispic['pic_cat_id'];
$user_id = $thispic['pic_user_id'];
}
else
{
if( isset($HTTP_POST_VARS['cat_id']) )
{
$cat_id = intval($HTTP_POST_VARS['cat_id']);
}
else if( isset($HTTP_GET_VARS['cat_id']) )
{
$cat_id = intval($HTTP_GET_VARS['cat_id']);
}
else
{
message_die(GENERAL_ERROR, 'No categories specified');
}
}
if( ($cat_id == PERSONAL_GALLERY) and (($HTTP_GET_VARS['mode'] == 'lock') or ($HTTP_GET_VARS['mode'] == 'unlock')) )
{
$thiscat = init_personal_gallery_cat($user_id);
}
else
{
$sql = "SELECT *
FROM ". ALBUM_CAT_TABLE ."
WHERE cat_id = '$cat_id'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query category information', '', __LINE__, __FILE__, $sql);
}
$thiscat = $db->sql_fetchrow($result);
}
if (empty($thiscat))
{
message_die(GENERAL_ERROR, $lang['Category_not_exist']);
}
$auth_data = album_user_access($cat_id, $thiscat, 0, 0, 0, 0, 0, 0); // MODERATOR only
if( isset($HTTP_POST_VARS['mode']) )
{
if( isset($HTTP_POST_VARS['move']) )
{
$mode = 'move';
}
else if( isset($HTTP_POST_VARS['lock']) )
{
$mode = 'lock';
}
else if( isset($HTTP_POST_VARS['unlock']) )
{
$mode = 'unlock';
}
else if( isset($HTTP_POST_VARS['delete']) )
{
$mode = 'delete';
}
else if( isset($HTTP_POST_VARS['approval']) )
{
$mode = 'approval';
}
else if( isset($HTTP_POST_VARS['unapproval']) )
{
$mode = 'unapproval';
}
else
{
$mode = '';
}
}
else if( isset($HTTP_GET_VARS['mode']) )
{
$mode = trim(htmlspecialchars($HTTP_GET_VARS['mode']));
}
else
{
$mode = '';
}
if ($auth_data['moderator'] == 0)
{
if (!$userdata['session_logged_in'])
{
redirect(append_sid("login.$phpEx?redirect=album_modcp.$phpEx&cat_id=$cat_id"));
}
else
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
}
if ($mode == '')
{
if( isset($HTTP_GET_VARS['start']) )
{
$start = intval($HTTP_GET_VARS['start']);
}
else if( isset($HTTP_POST_VARS['start']) )
{
$start = intval($HTTP_POST_VARS['start']);
}
else
{
$start = 0;
}
if( isset($HTTP_GET_VARS['sort_method']) )
{
switch ($HTTP_GET_VARS['sort_method'])
{
case 'pic_title':
$sort_method = 'pic_title';
break;
case 'pic_user_id':
$sort_method = 'pic_user_id';
break;
case 'pic_view_count':
$sort_method = 'pic_view_count';
break;
case 'rating':
$sort_method = 'rating';
break;
case 'comments':
$sort_method = 'comments';
break;
case 'new_comment':
$sort_method = 'new_comment';
break;
default:
$sort_method = 'pic_time';
}
}
else if( isset($HTTP_POST_VARS['sort_method']) )
{
switch ($HTTP_POST_VARS['sort_method'])
{
case 'pic_title':
$sort_method = 'pic_title';
break;
case 'pic_user_id':
$sort_method = 'pic_user_id';
break;
case 'pic_view_count':
$sort_method = 'pic_view_count';
break;
case 'rating':
$sort_method = 'rating';
break;
case 'comments':
$sort_method = 'comments';
break;
case 'new_comment':
$sort_method = 'new_comment';
break;
default:
$sort_method = 'pic_time';
}
}
else
{
$sort_method = 'pic_time';
}
if( isset($HTTP_GET_VARS['sort_order']) )
{
switch ($HTTP_GET_VARS['sort_order'])
{
case 'ASC':
$sort_order = 'ASC';
break;
default:
$sort_order = 'DESC';
}
}
else if( isset($HTTP_POST_VARS['sort_order']) )
{
switch ($HTTP_POST_VARS['sort_order'])
{
case 'ASC':
$sort_order = 'ASC';
break;
default:
$sort_order = 'DESC';
}
}
else
{
$sort_order = 'DESC';
}
$sql = "SELECT COUNT(pic_id) AS count
FROM ". ALBUM_TABLE ."
WHERE pic_cat_id = '$cat_id'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not count pics in this category', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$total_pics = $row['count'];
$pics_per_page = $board_config['topics_per_page'];
if ($total_pics > 0)
{
$limit_sql = ($start == 0) ? $pics_per_page : $start .', '. $pics_per_page;
$pic_approval_sql = '';
if( ($userdata['user_level'] != ADMIN) and ($thiscat['cat_approval'] == ALBUM_ADMIN) )
{
$pic_approval_sql = 'AND p.pic_approval = 1';
}
$sql = "SELECT p.pic_id, p.pic_title, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, p.pic_lock, p.pic_approval, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(c.comment_id) AS comments, MAX(c.comment_id) AS new_comment
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
WHERE p.pic_cat_id = '$cat_id' $pic_approval_sql
GROUP BY p.pic_id
ORDER BY $sort_method $sort_order
LIMIT $limit_sql";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query pics information', '', __LINE__, __FILE__, $sql);
}
$picrow = array();
while( $row = $db->sql_fetchrow($result) )
{
$picrow[] = $row;
}
for ($i = 0; $i <count($picrow); $i++)
{
if( ($picrow[$i]['user_id'] == ALBUM_GUEST) or ($picrow[$i]['username'] == '') )
{
$pic_poster = ($picrow[$i]['pic_username'] == '') ? $lang['Guest'] : $picrow[$i]['pic_username'];
}
else
{
$pic_poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&". POST_USERS_URL .'='. $picrow[$i]['user_id']) .'">'. $picrow[$i]['username'] .'</a>';
}
$row_class = ( !($i % 2) ) ? 'row_easy' : 'row_hard';
$template->assign_block_vars('picrow', array(
'PIC_ID' => $picrow[$i]['pic_id'],
'ROW_CLASS' => $row_class,
'PIC_TITLE' => '<a href="'. append_sid("album_pic.$phpEx?pic_id=". $picrow[$i]['pic_id']) .'" target="_blank">'. $picrow[$i]['pic_title'] .'</a>',
'POSTER' => $pic_poster,
'TIME' => create_date($board_config['default_dateformat'], $picrow[$i]['pic_time'], $board_config['board_timezone']),
'RATING' => ($picrow[$i]['rating'] == 0) ? $lang['Not_rated'] : round($picrow[$i]['rating'], 2),
'COMMENTS' => $picrow[$i]['comments'],
'LOCK' => ($picrow[$i]['pic_lock'] == 0) ? '' : $lang['Locked'],
'APPROVAL' => ($picrow[$i]['pic_approval'] == 0) ? $lang['Not_approved'] : $lang['Approved']
)
);
}
$template->assign_vars(array(
'PAGINATION' => generate_pagination(append_sid("album_modcp.$phpEx?cat_id=$cat_id&sort_method=$sort_method&sort_order=$sort_order"), $total_pics, $pics_per_page, $start),
'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $pics_per_page ) + 1 ), ceil( $total_pics / $pics_per_page ))
)
);
}
else
{
$template->assign_block_vars('no_pics', array());
}
$page_title = $lang['Album'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template->set_filenames(array(
'body' => 'album_modcp_body.tpl')
);
$sort_rating_option = '';
$sort_comments_option = '';
if( $album_config['rate'] == 1 )
{
$sort_rating_option = '<option value="rating" ';
$sort_rating_option .= ($sort_method == 'rating') ? 'selected="selected"' : '';
$sort_rating_option .= '>' . $lang['Rating'] .'</option>';
}
if( $album_config['comment'] == 1 )
{
$sort_comments_option = '<option value="comments" ';
$sort_comments_option .= ($sort_method == 'comments') ? 'selected="selected"' : '';
$sort_comments_option .= '>' . $lang['Comments'] .'</option>';
$sort_new_comment_option = '<option value="new_comment" ';
$sort_new_comment_option .= ($sort_method == 'new_comment') ? 'selected="selected"' : '';
$sort_new_comment_option .= '>' . $lang['New_Comment'] .'</option>';
}
$template->assign_vars(array(
'U_VIEW_CAT' => append_sid("album_modcp.$phpEx?cat_id=$cat_id"),
'CAT_TITLE' => $thiscat['cat_title'],
'L_CATEGORY' => $lang['Category'],
'L_MODCP' => $lang['Mod_CP'],
'L_NO_PICS' => $lang['No_Pics'],
'L_VIEW' => $lang['View'],
'L_POSTER' => $lang['Poster'],
'L_POSTED' => $lang['Posted'],
'S_ALBUM_ACTION' => append_sid("album_modcp.$phpEx?cat_id=$cat_id"),
'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
'L_ORDER' => $lang['Order'],
'L_SORT' => $lang['Sort'],
'L_TIME' => $lang['Time'],
'L_PIC_TITLE' => $lang['Pic_Title'],
'L_POSTER' => $lang['Poster'],
'L_RATING' => $lang['Rating'],
'L_COMMENTS' => $lang['Comments'],
'L_STATUS' => $lang['Status'],
'L_APPROVAL' => $lang['Approval'],
'L_SELECT' => $lang['Select'],
'L_DELETE' => $lang['Delete'],
'L_MOVE' => $lang['Move'],
'L_LOCK' => $lang['Lock'],
'L_UNLOCK' => $lang['Unlock'],
'DELETE_BUTTON' => ($auth_data['delete'] == 1) ? '<input type="submit" name="delete" value="'. $lang['Delete'] .'" />' : '',
'APPROVAL_BUTTON' => ( ($userdata['user_level'] != ADMIN) and ($thiscat['cat_approval'] == ALBUM_ADMIN) ) ? '' : '<input type="submit" name="approval" value="'. $lang['Approve'] .'" />',
'UNAPPROVAL_BUTTON' => ( ($userdata['user_level'] != ADMIN) and ($thiscat['cat_approval'] == ALBUM_ADMIN) ) ? '' : '<input type="submit" name="unapproval" value="'. $lang['Unapprove'] .'" />',
'L_USERNAME' => $lang['Sort_Username'],
'SORT_TIME' => ($sort_method == 'pic_time') ? 'selected="selected"' : '',
'SORT_PIC_TITLE' => ($sort_method == 'pic_title') ? 'selected="selected"' : '',
'SORT_USERNAME' => ($sort_method == 'pic_user_id') ? 'selected="selected"' : '',
'SORT_VIEW' => ($sort_method == 'pic_view_count') ? 'selected="selected"' : '',
'SORT_RATING_OPTION' => $sort_rating_option,
'SORT_COMMENTS_OPTION' => $sort_comments_option,
'SORT_NEW_COMMENT_OPTION' => $sort_new_comment_option,
'L_ASC' => $lang['Sort_Ascending'],
'L_DESC' => $lang['Sort_Descending'],
'SORT_ASC' => ($sort_order == 'ASC') ? 'selected="selected"' : '',
'SORT_DESC' => ($sort_order == 'DESC') ? 'selected="selected"' : ''
)
);
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
else
{
if ($mode == 'move')
{
if( !isset($HTTP_POST_VARS['target']) )
{
$pic_id_array = array();
if ($pic_id != FALSE) // from GET
{
$pic_id_array[] = $pic_id;
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id_array = $HTTP_POST_VARS['pic_id'];
if( !is_array($pic_id_array) )
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
}
for ($i = 0; $i < count($pic_id_array); $i++)
{
$template->assign_block_vars('pic_id_array', array(
'VALUE' => $pic_id_array[$i])
);
}
$sql = "SELECT *
FROM ". ALBUM_CAT_TABLE ."
WHERE cat_id <> '$cat_id'
ORDER BY cat_order ASC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
$catrows = array();
while( $row = $db->sql_fetchrow($result) )
{
$album_user_access = album_user_access($row['cat_id'], $row, 0, 1, 0, 0, 0, 0);
if ($album_user_access['upload'] == 1)
{
$catrows[] = $row;
}
}
if( count($catrows) == 0 )
{
message_die(GENERAL_MESSAGE, 'There is no more categories which you have permisson to move pics to');
}
$category_select = '<select name="target">';
for ($i = 0; $i < count($catrows); $i++)
{
$category_select .= '<option value="'. $catrows[$i]['cat_id'] .'">'. $catrows[$i]['cat_title'] .'</option>';
}
$category_select .= '</select>';
$page_title = $lang['Album'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template->set_filenames(array(
'body' => 'album_move_body.tpl')
);
$template->assign_vars(array(
'S_ALBUM_ACTION' => append_sid("album_modcp.$phpEx?mode=move&cat_id=$cat_id"),
'L_MOVE' => $lang['Move'],
'L_MOVE_TO_CATEGORY' => $lang['Move_to_Category'],
'S_CATEGORY_SELECT' => $category_select)
);
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id = $HTTP_POST_VARS['pic_id'];
if( is_array($pic_id) )
{
$pic_id_sql = implode(',', $pic_id);
}
else
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
$sql = "SELECT pic_id
FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql) AND pic_cat_id <> $cat_id";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not obtain album information', '', __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result) > 0 )
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
}
$sql = "UPDATE ". ALBUM_TABLE ."
SET pic_cat_id = ". intval($HTTP_POST_VARS['target']) ."
WHERE pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update album information', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Pics_moved_successfully'] .'<br /><br />'. sprintf($lang['Click_return_category'], "<a href="" . append_sid("album_cat.$phpEx?cat_id=$cat_id") . "">", "</a>") .'<br /><br />'. sprintf($lang['Click_return_modcp'], "<a href="" . append_sid("album_modcp.$phpEx?cat_id=$cat_id") . "">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_album_index'], "<a href="" . append_sid("album.$phpEx") . "">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
}
else if ($mode == 'lock')
{
if ($pic_id != FALSE)
{
$pic_id_sql = $pic_id;
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id = $HTTP_POST_VARS['pic_id'];
if( is_array($pic_id) )
{
$pic_id_sql = implode(',', $pic_id);
}
else
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
}
$sql = "SELECT pic_id
FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql) AND pic_cat_id <> $cat_id";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not obtain album information', '', __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result) > 0 )
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
$sql = "UPDATE ". ALBUM_TABLE ."
SET pic_lock = 1
WHERE pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update album information', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Pics_locked_successfully'] .'<br /><br />';
if ($cat_id != PERSONAL_GALLERY)
{
$message .= sprintf($lang['Click_return_category'], "<a href="" . append_sid("album_cat.$phpEx?cat_id=$cat_id") . "">", "</a>") .'<br /><br />'. sprintf($lang['Click_return_modcp'], "<a href="" . append_sid("album_modcp.$phpEx?cat_id=$cat_id") . "">", "</a>") . "<br /><br />";
}
else
{
$message .= sprintf($lang['Click_return_personal_gallery'], "<a href="" . append_sid("album_personal.$phpEx") . "">", "</a>");
}
$message .= '<br /><br />' . sprintf($lang['Click_return_album_index'], "<a href="" . append_sid("album.$phpEx") . "">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else if ($mode == 'unlock')
{
if ($pic_id != FALSE)
{
$pic_id_sql = $pic_id;
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id = $HTTP_POST_VARS['pic_id'];
if( is_array($pic_id) )
{
$pic_id_sql = implode(',', $pic_id);
}
else
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
}
$sql = "SELECT pic_id
FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql) AND pic_cat_id <> $cat_id";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not obtain album information', '', __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result) > 0 )
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
$sql = "UPDATE ". ALBUM_TABLE ."
SET pic_lock = 0
WHERE pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update album information', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Pics_unlocked_successfully'] .'<br /><br />';
if ($cat_id != PERSONAL_GALLERY)
{
$message .= sprintf($lang['Click_return_category'], "<a href="" . append_sid("album_cat.$phpEx?cat_id=$cat_id") . "">", "</a>") .'<br /><br />'. sprintf($lang['Click_return_modcp'], "<a href="" . append_sid("album_modcp.$phpEx?cat_id=$cat_id") . "">", "</a>") . "<br /><br />";
}
else
{
$message .= sprintf($lang['Click_return_personal_gallery'], "<a href="" . append_sid("album_personal.$phpEx") . "">", "</a>");
}
$message .= '<br /><br />' . sprintf($lang['Click_return_album_index'], "<a href="" . append_sid("album.$phpEx") . "">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else if ($mode == 'approval')
{
if ($pic_id != FALSE)
{
$pic_id_sql = $pic_id;
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id = $HTTP_POST_VARS['pic_id'];
if( is_array($pic_id) )
{
$pic_id_sql = implode(',', $pic_id);
}
else
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
}
$sql = "SELECT pic_id
FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql) AND pic_cat_id <> $cat_id";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not obtain album information', '', __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result) > 0 )
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
$sql = "UPDATE ". ALBUM_TABLE ."
SET pic_approval = 1
WHERE pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update album information', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Pics_approved_successfully'] .'<br /><br />'. sprintf($lang['Click_return_category'], "<a href="" . append_sid("album_cat.$phpEx?cat_id=$cat_id") . "">", "</a>") .'<br /><br />'. sprintf($lang['Click_return_modcp'], "<a href="" . append_sid("album_modcp.$phpEx?cat_id=$cat_id") . "">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_album_index'], "<a href="" . append_sid("album.$phpEx") . "">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else if ($mode == 'unapproval')
{
if ($pic_id != FALSE)
{
$pic_id_sql = $pic_id;
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id = $HTTP_POST_VARS['pic_id'];
if( is_array($pic_id) )
{
$pic_id_sql = implode(',', $pic_id);
}
else
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
}
$sql = "SELECT pic_id
FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql) AND pic_cat_id <> $cat_id";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not obtain album information', '', __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result) > 0 )
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
$sql = "UPDATE ". ALBUM_TABLE ."
SET pic_approval = 0
WHERE pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update album information', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Pics_unapproved_successfully'] .'<br /><br />'. sprintf($lang['Click_return_category'], "<a href="" . append_sid("album_cat.$phpEx?cat_id=$cat_id") . "">", "</a>") .'<br /><br />'. sprintf($lang['Click_return_modcp'], "<a href="" . append_sid("album_modcp.$phpEx?cat_id=$cat_id") . "">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_album_index'], "<a href="" . append_sid("album.$phpEx") . "">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else if ($mode == 'delete')
{
if ($auth_data['delete'] == 0)
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
if( !isset($HTTP_POST_VARS['confirm']) )
{
$pic_id_array = array();
if ($pic_id != FALSE)
{
$pic_id_array[] = $pic_id;
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id_array = $HTTP_POST_VARS['pic_id'];
if( !is_array($pic_id_array) )
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
}
if ( isset($HTTP_POST_VARS['cancel']) )
{
$redirect = "album_modcp.$phpEx?cat_id=$cat_id";
redirect(append_sid($redirect, true));
}
$hidden_field = '';
for ($i = 0; $i < count($pic_id_array); $i++)
{
$hidden_field .= '<input name="pic_id[]" type="hidden" value="'. $pic_id_array[$i] .'" />' . "n";
}
$page_title = $lang['Album'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template->set_filenames(array(
'body' => 'confirm_body.tpl')
);
$template->assign_vars(array(
'MESSAGE_TITLE' => $lang['Confirm'],
'MESSAGE_TEXT' => $lang['Album_delete_confirm'],
'S_HIDDEN_FIELDS' => $hidden_field,
'L_NO' => $lang['No'],
'L_YES' => $lang['Yes'],
'S_CONFIRM_ACTION' => append_sid("album_modcp.$phpEx?mode=delete&cat_id=$cat_id"),
)
);
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
else
{
if( isset($HTTP_POST_VARS['pic_id']) )
{
$pic_id = $HTTP_POST_VARS['pic_id'];
if( is_array($pic_id) )
{
$pic_id_sql = implode(',', $pic_id);
}
else
{
message_die(GENERAL_ERROR, 'Invalid request');
}
}
else
{
message_die(GENERAL_ERROR, 'No pics specified');
}
$sql = "SELECT pic_id
FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql) AND pic_cat_id <> $cat_id";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not obtain album information', '', __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result) > 0 )
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
$sql = "DELETE FROM ". ALBUM_COMMENT_TABLE ."
WHERE comment_pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete related comments', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM ". ALBUM_RATE_TABLE ."
WHERE rate_pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete related ratings', '', __LINE__, __FILE__, $sql);
}
$sql = "SELECT pic_filename, pic_thumbnail
FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not obtain filenames', '', __LINE__, __FILE__, $sql);
}
$filerow = array();
while( $row = $db->sql_fetchrow($result) )
{
$filerow[] = $row;
}
for ($i = 0; $i < count($filerow); $i++)
{
if( ($filerow[$i]['pic_thumbnail'] != '') and (@file_exists(ALBUM_CACHE_PATH . $filerow[$i]['pic_thumbnail'])) )
{
@unlink(ALBUM_CACHE_PATH . $filerow[$i]['pic_thumbnail']);
}
@unlink(ALBUM_UPLOAD_PATH . $filerow[$i]['pic_filename']);
}
$sql = "DELETE FROM ". ALBUM_TABLE ."
WHERE pic_id IN ($pic_id_sql)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete DB entry', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Pics_deleted_successfully'] .'<br /><br />'. sprintf($lang['Click_return_category'], "<a href="" . append_sid("album_cat.$phpEx?cat_id=$cat_id") . "">", "</a>") .'<br /><br />'. sprintf($lang['Click_return_modcp'], "<a href="" . append_sid("album_modcp.$phpEx?cat_id=$cat_id") . "">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_album_index'], "<a href="" . append_sid("album.$phpEx") . "">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
}
else
{
message_die(GENERAL_ERROR, 'Invalid_mode');
}
}
?>