262 lines
11 KiB
PHP
262 lines
11 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
/* $Id: user_album_update.php 293 2010-01-21 01:16:21Z phil $ */
|
||
|
|
|
||
|
|
$page = "user_album_update";
|
||
|
|
include "header.php";
|
||
|
|
|
||
|
|
$rand=rand(1, 2000000);
|
||
|
|
|
||
|
|
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
|
||
|
|
if(isset($_GET['album_id'])) { $album_id = $_GET['album_id']; } elseif(isset($_POST['album_id'])) { $album_id = $_POST['album_id']; } else { $album_id = 0; }
|
||
|
|
if(isset($_GET['media_id'])) { $media_id = $_GET['media_id']; } elseif(isset($_POST['media_id'])) { $media_id = $_POST['media_id']; } else { $media_id = 0; }
|
||
|
|
|
||
|
|
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
|
||
|
|
if(isset($_POST['cpp'])) { $cpp = $_POST['cpp']; } elseif(isset($_GET['cpp'])) { $cpp = $_GET['cpp']; } else { $cpp = 40; }
|
||
|
|
// ENSURE ALBUMS ARE ENABLED FOR THIS USER
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
if($user->level_info[level_album_allow] == 0) { header("Location: home.php"); exit(); }
|
||
|
|
|
||
|
|
// BE SURE ALBUM BELONGS TO THIS USER
|
||
|
|
$album = $database->database_query("SELECT * FROM se_albums WHERE album_id='".$database->database_real_escape_string($album_id)."' AND album_user_id='".$user->user_info[user_id]."'");
|
||
|
|
if($database->database_num_rows($album) != 1) { header("Location: user_album.php"); exit(); }
|
||
|
|
$album_info = $database->database_fetch_assoc($album);
|
||
|
|
|
||
|
|
|
||
|
|
// SET VARS
|
||
|
|
$result = 0;
|
||
|
|
$album = new se_album($user->user_info[user_id]);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// ROTATE
|
||
|
|
if($task == "rotate") {
|
||
|
|
|
||
|
|
|
||
|
|
$media_id = $_GET['media_id'];
|
||
|
|
$dir = $_GET['dir'];
|
||
|
|
|
||
|
|
if($dir == "cc") { $dir = 90; } else { $dir = 270; }
|
||
|
|
|
||
|
|
// ROTATE IMAGE
|
||
|
|
$ext=$album->album_media_rotate($media_id, $dir);
|
||
|
|
|
||
|
|
// SET THUMBPATH
|
||
|
|
$thumb_path = $url->url_userdir($user->user_info[user_id]).$media_id."_thumb.".$ext."?".rand();
|
||
|
|
|
||
|
|
// SEND AJAX CONFIRMATION
|
||
|
|
echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'><script type='text/javascript'>";
|
||
|
|
echo "var img = window.parent.document.getElementById('file_$media_id');";
|
||
|
|
echo "img.src = '$thumb_path';";
|
||
|
|
echo "</script></head><body></body></html>";
|
||
|
|
exit();
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// UPDATE FILES IN THIS ALBUM
|
||
|
|
}
|
||
|
|
elseif($task == "revokerights") {
|
||
|
|
|
||
|
|
$query=$database->database_query("SELECT * FROM se_albums WHERE album_id='".$database->database_real_escape_string($album_info["album_id"])."' AND album_user_id='".$user->user_info["user_id"]."'");
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
$database->database_query("UPDATE se_media SET rights=0, consenttaken='".time()."' WHERE media_album_id=".$database->database_real_escape_string($album_info["album_id"])." AND media_id=".$database->database_real_escape_string($media_id));
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
elseif($task == "giverights") {
|
||
|
|
|
||
|
|
$query=$database->database_query("SELECT * FROM se_albums WHERE album_id='".$database->database_real_escape_string($album_info["album_id"])."' AND album_user_id='".$user->user_info["user_id"]."'");
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
$database->database_query("UPDATE se_media SET rights=1, consentgiven='".time()."' WHERE media_album_id=".$database->database_real_escape_string($album_info["album_id"])." AND media_id=".$database->database_real_escape_string($media_id)." AND consenttaken=0");
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
elseif($task == "setphoto") {
|
||
|
|
|
||
|
|
$query=$database->database_query("SELECT * FROM se_albums WHERE album_id='$album_info[album_id]' AND album_user_id='".$user->user_info["user_id"]."'");
|
||
|
|
while($row=$database->database_fetch_array($query))
|
||
|
|
{
|
||
|
|
$query1=$database->database_query("SELECT * FROM se_media WHERE media_id='".$media_id."' AND media_album_id='$album_info[album_id]'");
|
||
|
|
$row1=$database->database_fetch_assoc($query1);
|
||
|
|
|
||
|
|
$database->database_query("UPDATE se_users SET user_photo='".$row1["media_id"].".".$row1["media_ext"]."' WHERE user_id='".$user->user_info["user_id"]."'");
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
$qs = str_replace("&task=setphoto", "", $_SERVER['QUERY_STRING']);
|
||
|
|
$_SERVER['QUERY_STRING']=$qs;
|
||
|
|
header("Location: user_album_update.php?".$qs);
|
||
|
|
exit;
|
||
|
|
}
|
||
|
|
elseif($task == "removephoto") {
|
||
|
|
$qs = str_replace("&task=removephoto", "", $_SERVER['QUERY_STRING']);
|
||
|
|
header("Location: user_album_update.php?".$qs);
|
||
|
|
exit;
|
||
|
|
}
|
||
|
|
elseif($task == "doupdate") {
|
||
|
|
|
||
|
|
// GET TOTAL FILES
|
||
|
|
$total_files = $album->album_files($album_info[album_id]);
|
||
|
|
|
||
|
|
// DELETE NECESSARY FILES
|
||
|
|
$album->album_media_delete(0, $total_files, "media_id ASC", "(media_album_id='$album_info[album_id]')");
|
||
|
|
|
||
|
|
// UPDATE NECESSARY FILES
|
||
|
|
//$media_array = $album->album_media_update(0, $total_files, "media_id ASC", "(media_album_id='$album_info[album_id]')");
|
||
|
|
|
||
|
|
// SET ALBUM COVER AND UPDATE DATE
|
||
|
|
$newdate = time();
|
||
|
|
$album_info[album_cover] = $_POST['album_cover'];
|
||
|
|
//if(!in_array($album_info[album_cover], $media_array)) { $album_info[album_cover] = $media_array[0]; }
|
||
|
|
$database->database_query("UPDATE se_albums SET album_cover='$album_info[album_cover]', album_dateupdated='$newdate' WHERE album_id='$album_info[album_id]' AND album_user_id='".$user->user_info["user_id"]."'");
|
||
|
|
|
||
|
|
// UPDATE LAST UPDATE DATE (SAY THAT 10 TIMES FAST)
|
||
|
|
$user->user_lastupdate();
|
||
|
|
|
||
|
|
// SHOW SUCCESS MESSAGE
|
||
|
|
$result = 1;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// MOVE MEDIA UP
|
||
|
|
} elseif($task == "editmedia") {
|
||
|
|
|
||
|
|
// GET TOTAL FILES
|
||
|
|
$total_files = $album->album_files($album_info[album_id]);
|
||
|
|
|
||
|
|
// DELETE NECESSARY FILES
|
||
|
|
|
||
|
|
// UPDATE NECESSARY FILES
|
||
|
|
|
||
|
|
$var1 = "media_title";
|
||
|
|
$var2 = "media_desc";
|
||
|
|
$var3 = "media_album_id";
|
||
|
|
$media_title = censor($_POST[$var1]);
|
||
|
|
$media_desc = censor(str_replace("\r\n", "<br>", $_POST[$var2]));
|
||
|
|
$media_album_id = $_POST[$var3];
|
||
|
|
$database->database_query("UPDATE se_media SET media_title='$media_title', media_desc='$media_desc', media_album_id='$media_album_id' WHERE media_id='".$database->database_real_escape_string($_POST["media_id"])."'");
|
||
|
|
$tags=array_filter(preg_split('/[\s,;]+?/', $tags));
|
||
|
|
$tags=explode(",", $_POST["tags"]);
|
||
|
|
|
||
|
|
foreach($tags as $tag)
|
||
|
|
{
|
||
|
|
|
||
|
|
$to_user = new SEUser(array(NULL, $tag));
|
||
|
|
$checkusers=$database->database_query("SELECT mediatag_id FROM se_mediatags WHERE mediatag_media_id='".$database->database_real_escape_string($_POST["media_id"])."' AND mediatag_user_id='".$database->database_real_escape_string($to_user->user_info["user_id"])."'");
|
||
|
|
if($database->database_num_rows($checkusers)==0&&$to_user->user_info["user_id"]>0){
|
||
|
|
$database->database_query("INSERT INTO se_mediatags SET mediatag_media_id='".$database->database_real_escape_string($_POST["media_id"])."', mediatag_user_id='".$database->database_real_escape_string($to_user->user_info["user_id"])."', mediatag_date='".time()."'");
|
||
|
|
|
||
|
|
$notify->notify_add($to_user->user_info["user_id"], 'phototag', $_POST["media_id"], Array($user->user_info["user_username"], $_POST["media_id"]), Array($user->user_info["user_username"], $_POST["media_id"]));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// SET ALBUM COVER AND UPDATE DATE
|
||
|
|
$newdate = time();
|
||
|
|
|
||
|
|
// UPDATE LAST UPDATE DATE (SAY THAT 10 TIMES FAST)
|
||
|
|
$user->user_lastupdate();
|
||
|
|
|
||
|
|
// SHOW SUCCESS MESSAGE
|
||
|
|
$result = 1;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// MOVE MEDIA UP
|
||
|
|
}elseif($task == "moveup") {
|
||
|
|
$media_id = $_GET['media_id'];
|
||
|
|
|
||
|
|
$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();
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
elseif($task == "movedown") {
|
||
|
|
$media_id = $_GET['media_id'];
|
||
|
|
|
||
|
|
$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);
|
||
|
|
mail("leprakhauns@gmail.com", "A", "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 ASC LIMIT 1");
|
||
|
|
$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 ASC 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]);
|
||
|
|
$page_vars = make_page($total_files, $cpp, $p);
|
||
|
|
$file_array = $album->album_media_list($page_vars[0], $cpp, "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]'");
|
||
|
|
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
|
||
|
|
{
|
||
|
|
if(($page_vars[1]+10)==$x)
|
||
|
|
{break;}
|
||
|
|
$for[$y]=$x;
|
||
|
|
$y++;
|
||
|
|
}
|
||
|
|
$rand=rand(1, 200000);
|
||
|
|
$smarty->assign('rand', $rand);
|
||
|
|
|
||
|
|
$smarty->assign('for', $for);
|
||
|
|
// ASSIGN VARIABLES AND SHOW UDPATE ALBUMS PAGE
|
||
|
|
$smarty->assign('result', $result);
|
||
|
|
$smarty->assign('files', $file_array);
|
||
|
|
$smarty->assign('files_total', $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));
|
||
|
|
$smarty->assign('album_info', $album_info);
|
||
|
|
$smarty->assign('albums', $album_array);
|
||
|
|
$smarty->assign('albums_total', $total_albums);
|
||
|
|
$smarty->assign('rand', $rand);
|
||
|
|
include "footer.php";
|
||
|
|
?>
|