$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";
}
if ($user->user_exists) {
$profile_viewers_array = explode(",", $profile_viewers);
if (in_array($user->user_info['user_id'], $profile_viewers_array)) {
array_splice($profile_viewers_array, array_search($user->user_info['user_id'], $profile_viewers_array), 1);
}
$profile_viewers_array[] = $user->user_info['user_id'];
krsort($profile_viewers_array);
$profile_viewers = implode(",", array_filter($profile_viewers_array));
}
}
$database->database_query("INSERT INTO se_profileviews (profileview_user_id, profileview_views, profileview_viewers) VALUES ('{$owner->user_info['user_id']}', '1', '{$profile_viewers}') ON DUPLICATE KEY UPDATE profileview_views=profileview_views+1, profileview_viewers='{$profile_viewers}'");
}
// CREATE ALBUM OBJECT
$album = new se_album($owner->user_info['user_id']);
$fotos = $album->album_media_list(0, 4, "media_id DESC", "media_ext = 'jpg' or media_ext = 'jpeg' or media_ext = 'gif' or media_ext = 'png' or media_ext = 'bmp'");
/*echo "<pre>";
print_r($fotos);
echo "</pre>";
die();
*/
// DELETE COMMENT NOTIFICATIONS IF VIEWING COMMENT PAGE
if ($v == "comments" && $user->user_info['user_id'] == $owner->user_info['user_id']) {
$database->database_query("DELETE FROM se_notifys WHERE notify_user_id='{$owner->user_info['user_id']}' AND notify_notifytype_id='3' AND notify_object_id='{$owner->user_info['user_id']}'");
}
// GET PROFILE COMMENTS
$comment = new se_comment('profile', 'user_id', $owner->user_info['user_id']);
$comments = $comment->comment_list(0, 30);
$total_comments = $comment->comment_total();
foreach ($comments as &$comment) {
$num_month = date("n", $comment['comment_date']);
$smarty->assign('error_header', 639);
$smarty->assign('error_message', 1000125);
$smarty->assign('error_submit', 641);
include "footer.php";
}
// UPDATE ALBUM VIEWS
if ($user->user_info[user_id] != $owner->user_info['user_id']) {
$album_views_new = $album_info[album_views] + 1;
$database->database_query("UPDATE se_albums SET album_views='{$album_views_new}' WHERE album_id='{$album_info['album_id']}' LIMIT 1");
}
// GET TOTAL FILES IN ALBUM
$total_files = $album->album_files($album_info['album_id'], $where);
// MAKE MEDIA PAGES
$page_vars = make_page($total_files, $media_per_page, $p);
// GET MEDIA ARRAY
$file_array = $album->album_media_list($page_vars[0], $media_per_page, $sortby, $where, $select);
// SET GLOBAL PAGE TITLE
$global_page_title[0] = 1000155;
$global_page_title[1] = $owner->user_displayname;
$global_page_title[2] = $album_info['album_title'];
$global_page_description[0] = 1000156;
$global_page_description[1] = $album_info['album_desc'];
// ASSIGN VARIABLES AND DISPLAY ALBUM PAGE
$smarty->assign('album_info', $album_info);
$smarty->assign('files', $file_array);
$smarty->assign('total_files', $total_files);
$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($file_array));
include "footer.php";
/* $Id: user_blog_album_browse.php 168 2009-05-22 23:15:00Z john $ */
$page = "user_blog_album_browse";
include "header.php";
// ENSURE ALBUMS ARE ENABLED FOR THIS USER
if (!$user->level_info['level_album_allow'] || !$user->level_info['level_blog_create']) {
//header("Location: user_home.php");
exit;
}
$album = new se_album($user->user_info['user_id']);
// Show albums
if (empty($_GET['album_id'])) {
// GET ALBUMS
$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);
} else {
$album_id = $_GET['album_id'];
$album_query = $database->database_query("SELECT * FROM se_albums WHERE album_id='{$album_id}' AND album_user_id='{$user->user_info['user_id']}'");
$album_info = $database->database_fetch_assoc($album_query);
$total_files = $album->album_files($album_info['album_id']);
$file_array = $album->album_media_list(0, $total_files, "media_id ASC", "(media_album_id='{$album_id}')");
$smarty->assign('album_id', $album_id);
$smarty->assign('album_info', $album_info);
$smarty->assign('media_total', $total_files);
$smarty->assign('media', $file_array);
}
// ASSIGN VARIABLES AND SHOW VIEW ALBUMS PAGE
include "footer.php";
