$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";