$media_query = $database->database_query("SELECT media_id, media_order, media_album_id FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE media_id='{$media_id}' AND se_albums.album_user_id='" . $user->user_info[user_id] . "'");
if ($database->database_num_rows($media_query) == 1) {
$media_info = $database->database_fetch_assoc($media_query);
$prev_query = $database->database_query("SELECT media_id, media_order FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE se_media.media_album_id='{$media_info['media_album_id']}' AND se_albums.album_user_id='" . $user->user_info[user_id] . "' AND media_order<{$media_info['media_order']} ORDER BY media_order DESC LIMIT 1");
if ($database->database_num_rows($prev_query) == 1) {
$prev_info = $database->database_fetch_assoc($prev_query);
// SWITCH ORDER
$database->database_query("UPDATE se_media SET media_order={$prev_info['media_order']} WHERE media_id={$media_info['media_id']}");
$database->database_query("UPDATE se_media SET media_order={$media_info['media_order']} WHERE media_id={$prev_info['media_id']}");
// SEND AJAX CONFIRMATION
echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'><script type='text/javascript'>";
echo "window.parent.reorderMedia('{$media_info['media_id']}', '{$prev_info['media_id']}');";
echo "</script></head><body></body></html>";
exit;
}
}
}
// SHOW FILES IN THIS ALBUM
$total_files = $album->album_files($album_info[album_id]);
$file_array = $album->album_media_list(0, $total_files, "media_order ASC", "(media_album_id='{$album_info['album_id']}')");
// GET LIST OF OTHER ALBUMS
$total_albums = $album->album_total("album_id<>'{$album_info['album_id']}'");
$album_array = $album->album_list(0, $total_albums, "album_order ASC", "album_id<>'{$album_info['album_id']}'");
// ASSIGN VARIABLES AND SHOW UDPATE ALBUMS PAGE
$smarty->assign('result', $result);
$smarty->assign('files', $file_array);
$smarty->assign('files_total', $total_files);
$smarty->assign('album_info', $album_info);
$smarty->assign('albums', $album_array);
$smarty->assign('albums_total', $total_albums);
include "footer.php";
$smarty->assign('error_submit', 641);
include "footer.php";
}
// ENSURE ALBUMS ARE ENABLED FOR THIS USER
if (!$owner->level_info['level_album_allow']) {
header("Location: " . $url->url_create('profile', $owner->user_info['user_username']));
exit;
}
// SET PRIVACY LEVEL AND WHERE CLAUSE
$privacy_max = $owner->user_privacy_max($user);
$where = "(album_privacy & {$privacy_max})";
// CREATE ALBUM OBJECT
$album = new se_album($owner->user_info['user_id']);
// GET TOTAL ALBUMS
$total_albums = $album->album_total($where);
// GET ALBUM ARRAY
$album_array = $album->album_list(0, $total_albums, "album_order ASC", $where);
// GET CUSTOM ALBUM STYLE IF ALLOWED
if ($owner->level_info['level_album_style']) {
$albumstyle_info = $database->database_fetch_assoc($database->database_query("SELECT albumstyle_css FROM se_albumstyles WHERE albumstyle_user_id='{$owner->user_info['user_id']}' LIMIT 1"));
$global_css = $albumstyle_info['albumstyle_css'];
}
// SET GLOBAL PAGE TITLE
$global_page_title[0] = 1000160;
$global_page_title[1] = $owner->user_displayname;
$global_page_description[0] = 1000161;
$global_page_description[1] = $owner->user_displayname;
// ASSIGN SMARTY VARIABLES AND DISPLAY ALBUMS PAGE
$smarty->assign('albums', $album_array);
$smarty->assign('total_albums', $total_albums);
include "footer.php";
}
if ($user->user_exists && $user->level_info['level_album_allow']) {
$plugin_vars['menu_user'] = array('file' => 'user_album.php', 'icon' => 'album_album16.gif', 'title' => 1000007);
}
// SET PROFILE MENU VARS
if ($owner->level_info['level_album_allow'] && $page == "profile") {
// START ALBUM
$album = new se_album($owner->user_info['user_id']);
$sort = "album_id DESC";
// GET PRIVACY LEVEL AND SET WHERE
$album_privacy_max = $owner->user_privacy_max($user);
$where = "(album_privacy & {$album_privacy_max})";
// GET TOTAL ALBUMS
$total_albums = $album->album_total($where);
// GET ALBUM ARRAY
$albums = $album->album_list(0, $total_albums, $sort, $where);
// ASSIGN ALBUMS SMARY VARIABLE
$smarty->assign('albums', $albums);
$smarty->assign('total_albums', $total_albums);
// SET PROFILE MENU VARS
if ($total_albums) {
// DETERMINE WHERE TO SHOW ALBUMS
$level_album_profile = explode(",", $owner->level_info['level_album_profile']);
$user_profile_album = in_array($owner->user_info['user_profile_album'], $level_album_profile) ? $owner->user_info['user_profile_album'] : $level_album_profile[0];
// SHOW ALBUM IN APPROPRIATE LOCATION
if ($user_profile_album == "tab") {
$plugin_vars['menu_profile_tab'] = array('file' => 'profile_album_tab.tpl', 'title' => 1000007, 'name' => 'album');
} else {
$plugin_vars['menu_profile_side'] = array('file' => 'profile_album_side.tpl', 'title' => 1000007, 'name' => 'album');
}
}
$album->album_delete_selected($start, $albums_per_page, $sort, $where);
}
// GET TOTAL ALBUMS
$total_albums = $album->album_total($where);
// MAKE ALBUM PAGES
$page_vars = make_page($total_albums, $albums_per_page, $p);
$page_array = array();
for ($x = 0; $x <= $page_vars[2] - 1; $x++) {
if ($x + 1 == $page_vars[1]) {
$link = "1";
} else {
$link = "0";
}
$page_array[$x] = array('page' => $x + 1, 'link' => $link);
}
// GET ALBUM ARRAY
$albums = $album->album_list($page_vars[0], $albums_per_page, $sort, $where);
// ASSIGN VARIABLES AND SHOW VIEW ALBUMS PAGE
$smarty->assign('total_albums', $total_albums);
$smarty->assign('pages', $page_array);
$smarty->assign('albums', $albums);
$smarty->assign('f_title', $f_title);
$smarty->assign('f_owner', $f_owner);
$smarty->assign('i', $i);
$smarty->assign('t', $t);
$smarty->assign('u', $u);
$smarty->assign('f', $f);
$smarty->assign('su', $su);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('s', $s);
include "admin_footer.php";
$new_album_cover = $album_info[album_cover];
}
$database->database_query("UPDATE se_albums SET album_cover='{$new_album_cover}', album_dateupdated='{$newdate}' WHERE album_id='{$album_id}'");
// UPDATE LAST UPDATE DATE (SAY THAT 10 TIMES FAST)
$user->user_lastupdate();
// INSERT ACTION
$album_title = $album_info[album_title];
if (strlen($album_title) > 100) {
$album_title = substr($album_title, 0, 97) . "...";
}
$actions->actions_add($user, "newmedia", array($user->user_info[user_username], $user->user_displayname, $album_id, $album_title), $action_media, 60, FALSE, "user", $user->user_info[user_id], $album_info[album_privacy]);
}
}
// Get album list
$total_albums = $album->album_total();
$album_array = $album->album_list(0, $total_albums);
$space_used = $album->album_space();
$total_files = $album->album_files();
$smarty->assign('albums_total', $total_albums);
$smarty->assign_by_ref('albums', $album_array);
// START NEW SESSION AND SET SESSION VARS FOR UPLOADER
// Backwards compatibility with <SE3.10
if (!session_id()) {
session_start();
}
if (!empty($_COOKIE['user_id'])) {
$_SESSION['ul_user_id'] = $_COOKIE['user_id'];
$_SESSION['ul_user_email'] = $_COOKIE['user_email'];
$_SESSION['ul_user_password'] = $_COOKIE['se_user_pass'];
}
// Keep with 3.10+
$s = "album_dateupdated DESC";
}
if ($v != "0" && $v != "1") {
$v = 0;
}
// SET WHERE CLAUSE
$where = "CASE\r\n\t WHEN se_albums.album_user_id='{$user->user_info[user_id]}'\r\n\t THEN TRUE\r\n\t WHEN ((se_albums.album_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)\r\n\t THEN TRUE\r\n\t WHEN ((se_albums.album_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)\r\n\t THEN TRUE\r\n\t WHEN ((se_albums.album_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_albums.album_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))\r\n\t THEN TRUE\r\n\t WHEN ((se_albums.album_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_albums.album_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))\r\n\t THEN TRUE\r\n\t WHEN ((se_albums.album_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_albums.album_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))\r\n\t THEN TRUE\r\n\t ELSE FALSE\r\n\tEND";
// ONLY MY FRIENDS' ALBUMS
if ($v == "1" && $user->user_exists) {
// SET WHERE CLAUSE
$where .= " AND (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$user->user_info['user_id']}' AND friend_user_id2=se_albums.album_user_id AND friend_status=1)";
}
// CREATE ALBUM OBJECT
$album = new se_album();
// GET TOTAL ALBUMS
$total_albums = $album->album_total($where);
// MAKE ENTRY PAGES
$albums_per_page = 10;
$page_vars = make_page($total_albums, $albums_per_page, $p);
// GET ALBUM ARRAY
$album_array = $album->album_list($page_vars[0], $albums_per_page, $s, $where);
// ASSIGN SMARTY VARIABLES AND DISPLAY ALBUMS PAGE
$smarty->assign('albums', $album_array);
$smarty->assign('total_albums', $total_albums);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('maxpage', $page_vars[2]);
$smarty->assign('p_start', $page_vars[0] + 1);
$smarty->assign('p_end', $page_vars[0] + count($album_array));
$smarty->assign('s', $s);
$smarty->assign('v', $v);
include "footer.php";
