database_num_rows($album) != 1) { header("Location: user_event_photos.php"); exit(); } if($task == "rotate") { $query=$database->database_query("SELECT * FROM se_eventmedia, se_eventalbums WHERE eventmedia_id='".$media_id."' AND eventmedia_eventalbum_id=eventalbum_id"); $row=$database->database_fetch_array($query); $event = new se_event($user->user_info['user_id'], $row["eventalbum_event_id"]); $media_id = $_GET['media_id']; $dir = $_GET['dir']; if($dir == "cc") { $dir = 90; } else { $dir = 270; } // ROTATE IMAGE $ext=$event->album_media_rotate($media_id, $dir); // SET THUMBPATH $thumb_path = event_dir($row["eventalbum_event_id"]).$media_id."_thumb.".$ext."?".rand(); if(!file_exists($thumb_path)){ $thumb_path = event_dir($row["eventalbum_event_id"]).$media_id.".".$ext."?".rand(); } // SEND AJAX CONFIRMATION echo ""; exit(); // UPDATE FILES IN THIS ALBUM } //if($user->level_info[level_album_allow] == 0) { header("Location: home.php"); exit(); } function general(){ // BE SURE ALBUM BELONGS TO THIS USER global $user, $database; ?>


database_query("SELECT * FROM se_events, se_eventalbums, se_eventmedia WHERE eventalbum_id=eventmedia_eventalbum_id AND eventalbum_event_id=event_id AND eventmedia_user_id='".$user->user_info[user_id]."'"); while($row=$database->database_fetch_array($album)) { $album1 = $database->database_query("SELECT * FROM se_eventmediatags WHERE eventmediatag_eventmedia_id='".$row["eventmedia_id"]."'"); $tags=""; while($rowusers=$database->database_fetch_array($album1)) { $thisuser=$database->database_query("SELECT user_username FROM se_users WHERE user_id='".$database->database_real_escape_string($rowusers['eventmediatag_user_id'])."'"); $rowuser=$database->database_fetch_array($thisuser); if($tags==""){ $tags=$rowuser["user_username"]."
";} else{$tags.=$rowuser["user_username"]."
";} } ?>
Event
">
Title
Caption
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 ""; exit(); // UPDATE FILES IN THIS ALBUM } 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; } else */ if($task=="delete") { $query=$database->database_query("SELECT * FROM se_eventmedia, se_eventalbums WHERE eventmedia_eventalbum_id=eventalbum_id AND eventmedia_id='".$database->database_real_escape_string($media_id)."' AND eventmedia_user_id='".$user->user_info["user_id"]."'"); $row=$database->database_fetch_array($query); $database->database_query("DELETE FROM se_eventmedia WHERE eventmedia_id='".$database->database_real_escape_string($row["eventmedia_id"])."' AND eventmedia_user_id='".$user->user_info["user_id"]."'"); $database->database_query("DELETE FROM se_eventmediacomments WHERE eventmediacomment_eventmedia_id='".$database->database_real_escape_string($row["eventmedia_id"])."'"); @unlink(event_dir($row['eventalbum_event_id']).$row["eventmedia_id"].".".$row['eventmedia_ext']); @unlink(event_dir($row['eventalbum_event_id']).$row["eventmedia_id"]."_thumb.".$row['eventmedia_ext']); //header("Location:group.php?group_id=".$group_id); 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", "
", $_POST[$var2])); $media_album_id = $_POST[$var3]; $database->database_query("UPDATE se_eventmedia SET eventmedia_title='$media_title', eventmedia_desc='$media_desc' WHERE eventmedia_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 eventmediatag_id FROM se_eventmediatags WHERE eventmediatag_eventmedia_id='".$database->database_real_escape_string($_POST["media_id"])."' AND eventmediatag_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_eventmediatags SET eventmediatag_eventmedia_id='".$database->database_real_escape_string($_POST["media_id"])."', eventmediatag_user_id='".$database->database_real_escape_string($to_user->user_info["user_id"])."', eventmediatag_date='".time()."'"); $query=$database->database_query("SELECT * FROM se_eventmedia, se_eventalbums WHERE eventmedia_id='".$media_id."' AND eventmedia_eventalbum_id=eventalbum_id"); $group=$database->database_fetch_array($query); $notify->notify_add($to_user->user_info["user_id"], 'eventphototag', $_POST["media_id"], Array($group["eventalbum_event_id"], $_POST["media_id"]), Array($group["eventalbum_event_id"], $_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 ""; 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 ""; 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"; ?>