user_id = $user_id; } // END se_album() METHOD // THIS METHOD RETURNS THE TOTAL NUMBER OF ALBUMS // INPUT: $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // OUTPUT: AN INTEGER REPRESENTING THE NUMBER OF ALBUMS function album_total($where = "") { global $database; // BEGIN ALBUM QUERY /*$sql = " SELECT NULL FROM se_albums ";*/ $sql = " SELECT COUNT(*) as cnt FROM se_albums "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY $sql .= " WHERE 1=1 "; if( !$this->user_id ){ $sql .= " AND se_users.user_enabled='1' "; } // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " AND album_user_id='{$this->user_id}' "; // INSERT AND IF NECESSARY if( !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; //if(empty($where)){mail("sean@bateworld.com", "PAGE NO WHERE2", $_SERVER["PHP_SELF"]."?".$_SERVER["QUERY_STRING"]."".$sql);} $res2=$database->database_query($sql); // GET AND RETURN TOTAL PHOTO ALBUMS $row= $database->database_fetch_assoc($res2); $album_total=$row['cnt']; //$album_total = $database->database_num_rows($database->database_query($sql)); return (int) $album_total; } // END album_total() METHOD // THIS METHOD RETURNS AN ARRAY OF ALBUMS // INPUT: $start REPRESENTING THE ALBUM TO START WITH // $limit REPRESENTING THE NUMBER OF ALBUMS TO RETURN // $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE // $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // OUTPUT: AN ARRAY OF ALBUMS function album_list($start, $limit, $sort_by = "album_id DESC", $where = "") { global $database, $user, $owner; // BEGIN QUERY $sql = " SELECT se_albums.*, se_albums.album_totalfiles AS total_files, se_albums.album_totalspace AS total_space, se_media.approved "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname "; // CONTINUE QUERY $sql .= " FROM se_albums LEFT JOIN se_media ON se_albums.album_cover = se_media.media_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ){$sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; } // ADD WHERE IF NECESSARY $sql .= " WHERE 1=1 "; if( !$this->user_id ){ $sql .= " AND se_users.user_enabled='1' "; } if($owner->user_info["user_id"]==$user->user_info["user_id"]||$this->user_id==$user->user_info["user_id"]){ $sql .= " "; } else{ $sql .= " AND (se_albums.album_cover=0 OR approved=1) "; } // ENSURE USER ID IS NOT EMPTY if( $this->user_id ){$sql .= " AND album_user_id='{$this->user_id}' "; } // INSERT AND IF NECESSARY if( !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; // ADD ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; //if(SE_DEBUG1){echo $sql;} //exit; // RUN QUERY $resource = $database->database_query($sql); // GET ALBUMS INTO AN ARRAY $album_array = Array(); while( $album_info = $database->database_fetch_assoc($resource) ) { // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $album_info['user_id']; $author->user_info['user_username'] = $album_info['user_username']; $author->user_info['user_fname'] = $album_info['user_fname']; $author->user_info['user_lname'] = $album_info['user_lname']; $author->user_info['user_photo'] = $album_info['user_photo']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$album_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id'] == $album_info['album_user_id'] ) { $author =& $user; } // CONVERT SPACE TO MB $album_space_mb = ($album_info['total_space'] / 1024) / 1024; $album_space_mb = round($album_space_mb, 2); // GET PATH OF ALBUM COVER $album_cover_id = 0; $album_cover_ext = ""; if( $album_info['album_cover'] ) { $album_cover_query = $database->database_query("SELECT media_id, media_ext, cloud FROM se_media WHERE media_id='{$album_info['album_cover']}' AND media_album_id='{$album_info['album_id']}' LIMIT 1"); if( $database->database_num_rows($album_cover_query) ) { $album_cover_array = $database->database_fetch_assoc($album_cover_query); $album_cover_id = $album_cover_array['media_id']; $album_cover_ext = $album_cover_array['media_ext']; $cloud = $album_cover_array['cloud']; } } // CREATE ARRAY OF ALBUM DATA SE_Language::_preload(user_privacy_levels($album_info['album_privacy'])); // SET OTHER INFO $album_info['album_author'] =& $author; $album_info['album_space'] = $album_space_mb; $album_info['cloud'] = $cloud; $album_info['album_privacy'] = user_privacy_levels($album_info['album_privacy']); $album_info['album_cover_id'] = $album_cover_id; $album_info['album_cover_ext'] = $album_cover_ext; $album_info['album_files'] = $album_info['total_files']; $album_array[] = $album_info; unset($author, $album_info); } // RETURN ARRAY return $album_array; } // END album_list() METHOD // THIS METHOD RETURNS THE SPACE USED // INPUT: $album_id (OPTIONAL) REPRESENTING THE ID OF THE ALBUM TO CALCULATE // OUTPUT: AN INTEGER REPRESENTING THE SPACE USED function album_space($album_id = 0) { global $database; return 0; // BEGIN QUERY $album_query = "SELECT sum(se_media.media_filesize) AS total_space"; // CONTINUE QUERY $album_query .= " FROM se_albums LEFT JOIN se_media ON se_albums.album_id=se_media.media_album_id"; // ADD WHERE IF NECESSARY if($this->user_id != 0 || $album_id != 0) { $album_query .= " WHERE"; } // ENSURE USER ID IS NOT EMPTY if($this->user_id != 0) { $album_query .= " album_user_id='".$this->user_id."'"; } // INSERT AND IF NECESSARY if($this->user_id != 0 && $album_id != 0) { $album_query .= " AND"; } // SPECIFY ALBUM IF NECESSARY if($album_id != 0) { $album_query .= " album_id='$album_id'"; } // GET AND RETURN TOTAL SPACE USED $space_info = $database->database_fetch_assoc($database->database_query($album_query)); return $space_info["total_space"]; } // END album_space() METHOD function set_photo($name) { global $database, $user; $current=$user->user_info["user_photo"]; $y=explode(".", $current); if($name!="."){ if(!is_numeric($y[0])){ $media_path = str_replace("./", "", $url->url_userdir($user->user_info["user_id"]).$user->user_info["user_photo"]); $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "", $media_path), ));}catch (Exception $e) {} if(SE_DEBUG1){send_admin("sean@bateworld.com", "A", $_SERVER['DOCUMENT_ROOT']."/".$media_path);} @unlink($_SERVER['DOCUMENT_ROOT']."/".$media_path); } $database->database_query("UPDATE se_users SET user_photo='".$name."' WHERE user_id='".$user->user_info["user_id"]."'"); } } // THIS METHOD DELETES A SPECIFIED ALBUM // INPUT: $album_id REPRESENTING THE ID OF THE ALBUM TO DELETE // OUTPUT: function album_delete($album_id) { global $database, $url, $user; if($user=="") { $killuser=1; $user = new SEUser(Array($this->user_id)); } $media = $database->database_query("SELECT media_id, media_ext FROM se_media WHERE media_album_id='$album_id'"); // LOOP OVER MEDIA while($media_info = $database->database_fetch_assoc($media)) { $media_path = $url->url_userdir($this->user_id).$media_info["media_id"].".".$media_info["media_ext"]; if(file_exists($media_path)) { unlink($media_path); } $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "", $media_path), ));}catch (Exception $e) {} //Sean stuff if($user->user_info["user_photo"]==$media_info["media_id"].".".$media_info["media_ext"]) { $new=$database->database_query("SELECT album_id FROM se_albums WHERE album_user_id='".$user->user_info["user_id"]."' AND album_id!='".$album_id."' AND album_totalfiles>0 LIMIT 1"); while($media_info1 = $database->database_fetch_assoc($new)) { $new1=$database->database_query("SELECT media_id, media_ext FROM se_media WHERE media_album_id='".$media_info1["album_id"]."' LIMIT 1"); $z=0; while($media_info2 = $database->database_fetch_assoc($new1)) { $database->database_query("UPDATE se_users SET user_photo='".$media_info2["media_id"].".".$media_info2["media_ext"]."' WHERE user_id='".$user->user_info["user_id"]."'"); $z++; } if($z==0) { $database->database_query("UPDATE se_users SET user_photo='' WHERE user_id='".$user->user_info["user_id"]."'"); } } } $thumb_path = $url->url_userdir($this->user_id).$media_info["media_id"]."_thumb.".$media_info["media_ext"]; if(file_exists($thumb_path)) { unlink($thumb_path); } try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "", $thumb_path), ));}catch (Exception $e) {} } $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user->user_info["user_id"]}', time='".time()."', action='User has deleted a photo album and all photos in it'"); $database->database_query("DELETE FROM se_albums, se_media, se_mediacomments, se_mediatags USING se_albums LEFT JOIN se_media ON se_albums.album_id=se_media.media_album_id LEFT JOIN se_mediacomments ON se_media.media_id=se_mediacomments.mediacomment_media_id LEFT JOIN se_mediatags ON se_media.media_id=se_mediatags.mediatag_media_id WHERE se_albums.album_id='$album_id'"); // CALL ALBUM CREATION HOOK ($hook = SE_Hook::exists('se_album_delete')) ? SE_Hook::call($hook, array()) : NULL; if($killuser=="1") { $killuser=0; $user = ""; } } // END album_delete() METHOD // THIS METHOD DELETES SELECTED ALBUMS // INPUT: $start REPRESENTING THE ALBUM TO START WITH // $limit REPRESENTING THE NUMBER OF ALBUMS TO RETURN // $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE // $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // OUTPUT: function album_delete_selected($start, $limit, $sort_by = "album_id DESC", $where = "") { global $database; // BEGIN QUERY $album_query = "SELECT se_albums.*, count(se_media.media_id) AS total_files, sum(se_media.media_filesize) AS total_space"; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if($this->user_id == 0) { $album_query .= ", se_users.user_id, se_users.user_username, se_users.user_photo"; } // CONTINUE QUERY $album_query .= " FROM se_albums LEFT JOIN se_media ON se_albums.album_id=se_media.media_album_id"; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if($this->user_id == 0) { $album_query .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id"; } // ADD WHERE IF NECESSARY if($where != "" || $this->user_id != 0) { $album_query .= " WHERE"; } // ENSURE USER ID IS NOT EMPTY if($this->user_id != 0) { $album_query .= " album_user_id='".$this->user_id."'"; } // INSERT AND IF NECESSARY if($this->user_id != 0 && $where != "") { $album_query .= " AND"; } // ADD WHERE CLAUSE, IF NECESSARY if($where != "") { $album_query .= " $where"; } // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $album_query .= " GROUP BY album_id ORDER BY $sort_by LIMIT $start, $limit"; // RUN QUERY $albums = $database->database_query($album_query); // GET ALBUMS INTO AN ARRAY $album_array = Array(); while($album_info = $database->database_fetch_assoc($albums)) { $var = "delete_album_".$album_info["album_id"]; if($_POST[$var] == 1) { $this->user_id=$album_info["album_user_id"]; $this->album_delete($album_info["album_id"]); } } } // END album_delete_selected() METHOD function list_files_count($where) { global $database, $user, $owner; // BEGIN QUERY $sql = " SELECT count(se_media.media_id) AS total_files "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_enabled, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname "; // ADD ADDITIONAL SELECTS if( !empty($select) ) $sql .= $select; // CONTINUE QUERY $sql .= " FROM se_media LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY if( !empty($where) || $this->user_id ) $sql .= " WHERE "; // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " album_user_id='{$this->user_id}' "; // INSERT AND IF NECESSARY if( $this->user_id && !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; // ADD GROUP BY, ORDER, AND LIMIT CLAUSE //if(SE_DEBUG1){echo $sql;} // RUN QUERY $resource = $database->database_query($sql); // GET MEDIA INTO AN ARRAY $media_array = array(); while($media_info = $database->database_fetch_assoc($resource)) { // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $media_info['user_id']; $author->user_info['user_username'] = $media_info['user_username']; $author->user_info['user_photo'] = $media_info['user_photo']; $author->user_info['user_fname'] = $media_info['user_fname']; $author->user_info['user_lname'] = $media_info['user_lname']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $user; } $media_info['media_author'] =& $author; // BACKWARDS COMPAT $media_info['media_comments_total'] = $media_info['total_comments']; $media_info['media_desc'] = str_replace("
", "\r\n", $media_info['media_desc']); // CREATE ARRAY OF MEDIA DATA $media_array[] = $media_info; unset($media_info, $author); } // echo $media_array[0]["total_files"]."
"; //var_dump($media_array);exit; // RETURN ARRAY return $media_array[0]["total_files"]; } // THIS METHOD RETURNS THE NUMBER OF FILES // INPUT: $album_id (OPTIONAL) REPRESENTING THE ID OF THE ALBUM TO CALCULATE // $where (OPTIONAL) REPRESENTING A WHERE CLAUSE // OUTPUT: AN INTEGER REPRESENTING THE NUMBER OF FILES function list_files($start, $limit, $sort_by = "media_id DESC", $where = "", $select = "") { global $database, $user, $owner; // BEGIN QUERY $sql = " SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_search, se_albums.album_title, se_media.media_totalcomments AS total_comments "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_enabled, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname "; // ADD ADDITIONAL SELECTS if( !empty($select) ) $sql .= $select; // CONTINUE QUERY $sql .= " FROM se_media FORCE INDEX (PRIMARY) LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY if( !empty($where) || $this->user_id ) $sql .= " WHERE "; // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " album_user_id='{$this->user_id}' "; // INSERT AND IF NECESSARY if( $this->user_id && !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; if(SE_DEBUG){ //echo $sql; //exit; } // RUN QUERY $resource = $database->database_query($sql); // GET MEDIA INTO AN ARRAY $media_array = array(); while($media_info = $database->database_fetch_assoc($resource)) { // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $media_info['user_id']; $author->user_info['user_username'] = $media_info['user_username']; $author->user_info['user_photo'] = $media_info['user_photo']; $author->user_info['user_fname'] = $media_info['user_fname']; $author->user_info['user_lname'] = $media_info['user_lname']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $user; } $media_info['media_author'] =& $author; // BACKWARDS COMPAT $media_info['media_comments_total'] = $media_info['total_comments']; $media_info['media_desc'] = str_replace("
", "\r\n", $media_info['media_desc']); // CREATE ARRAY OF MEDIA DATA $media_array[] = $media_info; unset($media_info, $author); } // RETURN ARRAY return $media_array; } // END album_files() METHOD function list_files1($start, $limit, $sort_by = "media_id DESC", $where = "", $select = "") { global $database, $user, $owner; // BEGIN QUERY $sql = " SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_title, se_media.media_totalcomments AS total_comments "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_username "; // ADD ADDITIONAL SELECTS if( !empty($select) ) $sql .= $select; // CONTINUE QUERY $sql .= " FROM se_media FORCE INDEX (PRIMARY) LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id "; if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE // ADD WHERE IF NECESSARY if( !empty($where) || $this->user_id ) $sql .= " WHERE "; // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " album_user_id='{$this->user_id}' "; if( !$this->user_id ) $sql .= " se_users.user_enabled='1'"; // INSERT AND IF NECESSARY if( //$this->user_id && !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; if(SE_DEBUG){ echo $sql; //exit; } // RUN QUERY $resource = $database->database_query($sql); // GET MEDIA INTO AN ARRAY $media_array = array(); while($media_info = $database->database_fetch_assoc($resource)) { // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $media_info['user_id']; $author->user_info['user_username'] = $media_info['user_username']; $author->user_info['user_photo'] = $media_info['user_photo']; $author->user_info['user_fname'] = $media_info['user_fname']; $author->user_info['user_lname'] = $media_info['user_lname']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $user; } $media_info['media_author'] =& $author; // BACKWARDS COMPAT $media_info['media_comments_total'] = $media_info['total_comments']; $media_info['media_desc'] = str_replace("
", "\r\n", $media_info['media_desc']); // CREATE ARRAY OF MEDIA DATA $media_array[] = $media_info; unset($media_info, $author); } // RETURN ARRAY return $media_array; } function album_tagged_files($album_id = 0, $where = "") { global $database, $user; // BEGIN QUERY $album_query = "SELECT count(se_media.media_id) AS total_files"; // CONTINUE QUERY $album_query .= " FROM se_mediatags, se_albums LEFT JOIN se_media ON se_albums.album_id=se_media.media_album_id"; // ADD WHERE IF NECESSARY $album_query .= " WHERE se_mediatags.mediatag_media_id=se_media.media_id AND mediatag_user_id='".$user->user_info["user_id"]."' "; // if($_SERVER['REMOTE_ADDR']=="24.47.141.40"){echo $album_query;} // GET AND RETURN TOTAL FILES //if($_SERVER['REMOTE_ADDR']!="73.180.162.90"){ //echo $album_query;//} $file_info = $database->database_fetch_assoc($database->database_query($album_query)); return $file_info["total_files"]; } function album_tagged_media_list($start, $limit, $sort_by = "media_id DESC", $where = "", $select = "") { global $database, $user, $owner; // BEGIN QUERY $sql = " SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_title, se_media.media_totalcomments AS total_comments "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION $sql .= ", se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname "; // ADD ADDITIONAL SELECTS if( !empty($select) ) $sql .= $select; // CONTINUE QUERY $sql .= " FROM se_mediatags, se_media LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY $sql .= " WHERE se_mediatags.mediatag_media_id=se_media.media_id AND mediatag_user_id='".$user->user_info["user_id"]."' "; // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; // RUN QUERY $resource = $database->database_query($sql); // GET MEDIA INTO AN ARRAY $media_array = array(); while($media_info = $database->database_fetch_assoc($resource)) { $tags=""; $checkusers=$database->database_query("SELECT * FROM se_mediatags WHERE mediatag_media_id='".$database->database_real_escape_string($media_info['media_id'])."'"); while($rowusers=$database->database_fetch_array($checkusers)) { $thisuser=$database->database_query("SELECT user_username FROM se_users WHERE user_id='".$database->database_real_escape_string($rowusers['mediatag_user_id'])."'"); $rowuser=$database->database_fetch_array($thisuser); if($tags==""){ $tags=$rowuser["user_username"]."
";} else{$tags.=$rowuser["user_username"]."
";} } $media_info['media_tags']=$tags; // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $media_info['user_id']; $author->user_info['user_username'] = $media_info['user_username']; $author->user_info['user_photo'] = $media_info['user_photo']; $author->user_info['user_fname'] = $media_info['user_fname']; $author->user_info['user_lname'] = $media_info['user_lname']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $user; } $media_info['media_author'] =& $author; // BACKWARDS COMPAT $media_info['media_comments_total'] = $media_info['total_comments']; //$media_info['media_desc'] = str_replace("
", "\r\n", $media_info['media_desc']); // CREATE ARRAY OF MEDIA DATA $media_array[] = $media_info; unset($media_info, $author); } // RETURN ARRAY return $media_array; } // END album_media_list() METHOD // THIS METHOD RETURNS THE NUMBER OF FILES // INPUT: $album_id (OPTIONAL) REPRESENTING THE ID OF THE ALBUM TO CALCULATE // $where (OPTIONAL) REPRESENTING A WHERE CLAUSE // OUTPUT: AN INTEGER REPRESENTING THE NUMBER OF FILES function album_files($album_id = 0, $where = "") { global $database; // NEW HANDLING /*if($_SERVER['REMOTE_ADDR']!="73.180.162.90"){if( empty($where) ) { $sql = " SELECT album_totalfiles FROM se_albums WHERE "; if( $this->user_id ) $sql .= " album_user_id='{$this->user_id}' "; if( $this->user_id && $album_id ) $sql .= " && "; if( $album_id ) $sql .= " album_id='{$album_id}' "; if($_SERVER['REMOTE_ADDR']=="24.47.141.40"){ //$sql="SELECT count(se_media.media_id) AS album_totalfiles FROM se_media"; } $resource = $database->database_query($sql); if( $resource ) { $file_info = $database->database_fetch_assoc($resource); return $file_info['album_totalfiles']; } }}*/ // BEGIN QUERY $album_query = "SELECT count(se_media.media_id) AS total_files"; // CONTINUE QUERY $album_query .= " FROM se_albums LEFT JOIN se_media ON se_albums.album_id=se_media.media_album_id"; // ADD WHERE IF NECESSARY if($this->user_id != 0 || $album_id != 0 || $where != "") { $album_query .= " WHERE"; } // ENSURE USER ID IS NOT EMPTY if($this->user_id != 0) { $album_query .= " album_user_id='".$this->user_id."'"; } // INSERT AND IF NECESSARY if($this->user_id != 0 && ($album_id != 0 || $where != "")) { $album_query .= " AND"; } // SPECIFY ALBUM IF NECESSARY if($album_id != 0) { $album_query .= " album_id='$album_id'"; } // INSERT AND IF NECESSARY if($album_id != 0 && $where != "") { $album_query .= " AND"; } // ADD WHERE CLAUSE if($where != "") { $album_query .= " $where"; } // if($_SERVER['REMOTE_ADDR']=="24.47.141.40"){echo $album_query;} // GET AND RETURN TOTAL FILES //if($_SERVER['REMOTE_ADDR']!="73.180.162.90"){echo $album_query;} $file_info = $database->database_fetch_assoc($database->database_query($album_query)); return $file_info["total_files"]; } // END album_files() METHOD function album_noalbum($file_name, $album_id, &$space_left) { global $database, $url, $user; // SET KEY VARIABLES $file_maxsize = $user->level_info["level_album_maxsize"]; $file_exts = explode(",", str_replace(" ", "", strtolower($user->level_info["level_album_exts"]))); $file_types = explode(",", str_replace(" ", "", strtolower($user->level_info["level_album_mimes"]))); $file_maxwidth = $user->level_info["level_album_width"]; $file_maxheight = $user->level_info["level_album_height"]; $user_directory = $url->url_userdir($user->user_info['user_id']); $user_path_array = explode("/", $user_directory); array_pop($user_path_array); array_pop($user_path_array); $subdir = implode("/", $user_path_array)."/"; /*if( !is_dir($subdir) ) { mkdir($subdir, 0777); chmod($subdir, 0777); $handle = fopen($subdir."index.php", 'x+'); fclose($handle); } if( !is_dir($user_directory) ) { mkdir($user_directory, 0777); chmod($user_directory, 0777); $handle = fopen($user_directory."/index.php", 'x+'); fclose($handle); }*/ $new_media = new se_upload(); $new_media->new_upload($file_name, $file_maxsize, $file_exts, $file_types, $file_maxwidth, $file_maxheight); // UPLOAD AND RESIZE PHOTO IF NO ERROR if($new_media->is_error == 0) { // GET MAX ORDER $max = $database->database_fetch_assoc($database->database_query("SELECT max(media_order) AS max FROM se_media WHERE user_id='".$user->user_info["user_id"]."'")); $media_order = $max["max"]+1; $consentmarking=$_POST["consent"]; if($consentmarking==1){$marketingdate=time();} if($user->user_info["staff"]==1){ // INSERT ROW INTO MEDIA TABLE $database->database_query(" INSERT INTO se_media ( media_album_id, media_date, media_order, rights, consentgiven, ai, filename, approved, media_user_id, rightspermanent ) VALUES ( '0', '".time()."', '".$database->database_real_escape_string($media_order)."', '1', '".$database->database_real_escape_string(time())."', '".$database->database_real_escape_string($_POST["ai"])."', '".$database->database_real_escape_string($_FILES[$file_name]['name'])."', 1, '".$user->user_info["user_id"]."', 1 ) "); } else{$database->database_query(" INSERT INTO se_media ( media_album_id, media_date, media_order, rights, consentgiven, ai, filename, media_user_id, rightspermanent ) VALUES ( '0', '".time()."', '".$database->database_real_escape_string($media_order)."', '1', '".$database->database_real_escape_string(time())."', '".$database->database_real_escape_string($_POST["ai"])."', '".$database->database_real_escape_string($_FILES[$file_name]['name'])."', '".$user->user_info["user_id"]."', 1 ) ");} $media_id = $database->database_insert_id(); wrapup("upload_photo"); $pathinfo = pathinfo($_FILES[$file_name]['name']); $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user->user_info["user_id"]}', time='".time()."', action='User has added a new photo'"); $filename = $pathinfo['filename']; $filename = md5(uniqid()); $ext = $pathinfo['extension']; $photo_newname = $media_id.".".$ext; $photo_newname1 = $media_id."_thumb.".$ext; if(in_array($ext, Array('jpg', 'jpeg', 'png', 'bmp', 'gif'))){$new_media->is_image =1;} // CHECK IF IMAGE RESIZING IS AVAILABLE, OTHERWISE MOVE UPLOADED IMAGE if($new_media->is_image == 1) { $file_dest = $url->url_userdir($user->user_info['user_id']).$photo_newname; $thumb_dest = $url->url_userdir($user->user_info['user_id']).$photo_newname1; //echo $file_dest; $new_media->upload_photo($file_dest); // UPLOAD THUMB $new_media->upload_thumb($thumb_dest, 200); // UPLOAD FILE $file_ext = $ext; // $file_filesize = filesize($file_dest); } else { $file_dest = $url->url_userdir($user->user_info["user_id"]).$media_id.".".$new_media->file_ext; // UPLOAD THUMB IF NECESSARY if($new_media->file_ext == 'gif') { $thumb_dest = $url->url_userdir($user->user_info["user_id"]).$media_id."_thumb.jpg"; $new_media->upload_thumb($thumb_dest, 200); } // MOVE FILE $new_media->upload_file($file_dest); $pathinfo = pathinfo($file_dest); $filename = $pathinfo['filename']; $filename = md5(uniqid()); $ext = $pathinfo['extension']; $file_ext =$ext; // $file_filesize = filesize($file_dest); } if( !is_numeric($file_filesize) ) $file_filesize = 0; // CHECK SPACE LEFT if($file_filesize > $space_left) { $new_media->is_error = 1000085; } else { $space_left = $space_left-$file_filesize; } //if(!$database->database_ping()) if (!is_object($database) && !$database instanceof mysqli) { global $database, $database_host, $database_username, $database_password, $database_name; $database =NULL; $database =& SEDatabase::getInstance(); } // DELETE FROM DATABASE IF ERROR if($new_media->is_error != 0) { $database->database_query("DELETE FROM se_media WHERE media_id='$media_id' AND media_album_id=0"); @unlink($file_dest); } // UPDATE ROW IF NO ERROR else { { $database->database_query("UPDATE se_media SET media_ext='{$file_ext}', media_filesize='{$file_filesize}', cloud=1 WHERE media_id='{$media_id}' AND media_album_id='0' LIMIT 1") or die(mail("leprakhauns@gmail.com", "DB ERROR", $database->database_error())); //$database->database_query("UPDATE se_albums SET album_totalfiles=album_totalfiles+1, album_totalspace=album_totalspace+'{$file_filesize}' WHERE album_id='{$album_id}' LIMIT 1"); } } } // RETURN FILE STATS $file_result = array( 'is_error' => $new_media->is_error, 'file_name' => $_FILES[$file_name]['name'], 'media_id' => $media_id, 'media_ext' => $file_ext, 'media_filesize' => $file_filesize ); return $file_result; } // THIS METHOD UPLOADS MEDIA TO AN ALBUM // INPUT: $file_name REPRESENTING THE NAME OF THE FILE INPUT // $album_id REPRESENTING THE ID OF THE ALBUM TO UPLOAD THE MEDIA TO // $space_left REPRESENTING THE AMOUNT OF SPACE LEFT // OUTPUT: function album_media_upload($file_name, $album_id, &$space_left) { global $database, $url, $user; // SET KEY VARIABLES $file_maxsize = $user->level_info["level_album_maxsize"]; $file_exts = explode(",", str_replace(" ", "", strtolower($user->level_info["level_album_exts"]))); $file_types = explode(",", str_replace(" ", "", strtolower($user->level_info["level_album_mimes"]))); $file_maxwidth = $user->level_info["level_album_width"]; $file_maxheight = $user->level_info["level_album_height"]; $user_directory = $url->url_userdir($user->user_info['user_id']); $user_path_array = explode("/", $user_directory); array_pop($user_path_array); array_pop($user_path_array); $subdir = implode("/", $user_path_array)."/"; /* if( !is_dir($subdir) ) { mkdir($subdir, 0777); chmod($subdir, 0777); $handle = fopen($subdir."index.php", 'x+'); fclose($handle); } if( !is_dir($user_directory) ) { mkdir($user_directory, 0777); chmod($user_directory, 0777); $handle = fopen($user_directory."/index.php", 'x+'); fclose($handle); } */ $new_media = new se_upload(); $new_media->new_upload($file_name, $file_maxsize, $file_exts, $file_types, $file_maxwidth, $file_maxheight); // UPLOAD AND RESIZE PHOTO IF NO ERROR if($new_media->is_error == 0) { // GET MAX ORDER $max = $database->database_fetch_assoc($database->database_query("SELECT max(media_order) AS max FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE se_albums.album_user_id='".$user->user_info["user_id"]."'")); $media_order = $max["max"]+1; $consentmarking=$_POST["consent"]; if($consentmarking==1){$marketingdate=time();} if($user->user_info["staff"]==1){ // INSERT ROW INTO MEDIA TABLE $database->database_query(" INSERT INTO se_media ( media_album_id, media_date, media_order, rights, consentgiven, ai, filename, approved ) VALUES ( '".$database->database_real_escape_string($album_id)."', '".time()."', '".$database->database_real_escape_string($media_order)."', '".$database->database_real_escape_string($consentmarking)."', '".$database->database_real_escape_string($marketingdate)."', '".$database->database_real_escape_string($_POST["ai"])."', '".$database->database_real_escape_string($_FILES[$file_name]['name'])."', 1 ) "); } else{$database->database_query(" INSERT INTO se_media ( media_album_id, media_date, media_order, rights, consentgiven, ai, filename ) VALUES ( '".$database->database_real_escape_string($album_id)."', '".time()."', '".$database->database_real_escape_string($media_order)."', '".$database->database_real_escape_string($consentmarking)."', '".$database->database_real_escape_string($marketingdate)."', '".$database->database_real_escape_string($_POST["ai"])."', '".$database->database_real_escape_string($_FILES[$file_name]['name'])."' ) ");} $media_id = $database->database_insert_id(); wrapup("upload_photo"); $pathinfo = pathinfo($_FILES[$file_name]['name']); $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user->user_info["user_id"]}', time='".time()."', action='User has added a new photo'"); $filename = $pathinfo['filename']; $filename = md5(uniqid()); $ext = $pathinfo['extension']; $photo_newname = $media_id.".".$ext; $photo_newname1 = $media_id."_thumb.".$ext; if(in_array($ext, Array('jpg', 'jpeg', 'png', 'bmp', 'gif'))){$new_media->is_image =1;} // CHECK IF IMAGE RESIZING IS AVAILABLE, OTHERWISE MOVE UPLOADED IMAGE if($new_media->is_image == 1) { $file_dest = $url->url_userdir($user->user_info['user_id']).$photo_newname; $thumb_dest = $url->url_userdir($user->user_info['user_id']).$photo_newname1; //echo $file_dest; $new_media->upload_photo($file_dest); // UPLOAD THUMB $new_media->upload_thumb($thumb_dest, 200); // UPLOAD FILE $file_ext = $ext; //$file_filesize = filesize($file_dest); } else { $file_dest = $url->url_userdir($user->user_info["user_id"]).$media_id.".".$new_media->file_ext; // UPLOAD THUMB IF NECESSARY if($new_media->file_ext == 'gif') { $thumb_dest = $url->url_userdir($user->user_info["user_id"]).$media_id."_thumb.jpg"; $new_media->upload_thumb($thumb_dest, 200); } // MOVE FILE $new_media->upload_file($file_dest); $pathinfo = pathinfo($file_dest); $filename = $pathinfo['filename']; $filename = md5(uniqid()); $ext = $pathinfo['extension']; $file_ext =$ext; // $file_filesize = filesize($file_dest); } if( !is_numeric($file_filesize) ) $file_filesize = 0; // CHECK SPACE LEFT if($file_filesize > $space_left) { $new_media->is_error = 1000085; } else { $space_left = $space_left-$file_filesize; } //if(!$database->database_ping()) if (!is_object($database) && !$database instanceof mysqli) { global $database, $database_host, $database_username, $database_password, $database_name; $database =NULL; $database =& SEDatabase::getInstance(); } // DELETE FROM DATABASE IF ERROR if($new_media->is_error != 0) { $database->database_query("DELETE FROM se_media WHERE media_id='$media_id' AND media_album_id='$album_id'"); @unlink($file_dest); } // UPDATE ROW IF NO ERROR else { { $database->database_query("UPDATE se_media SET media_ext='{$file_ext}', media_filesize='{$file_filesize}', cloud=1 WHERE media_id='{$media_id}' AND media_album_id='{$album_id}' LIMIT 1") or die(mail("leprakhauns@gmail.com", "DB ERROR", $database->database_error())); $database->database_query("UPDATE se_albums SET album_totalfiles=album_totalfiles+1, album_totalspace=album_totalspace+'{$file_filesize}' WHERE album_id='{$album_id}' LIMIT 1"); } } } // RETURN FILE STATS $file_result = array( 'is_error' => $new_media->is_error, 'file_name' => $_FILES[$file_name]['name'], 'media_id' => $media_id, 'media_ext' => $file_ext, 'media_filesize' => $file_filesize ); return $file_result; } // END album_media_upload() METHOD // THIS METHOD RETURNS AN ARRAY OF MEDIA // INPUT: $start REPRESENTING THE MEDIA TO START WITH // $limit REPRESENTING THE NUMBER OF MEDIA TO RETURN // $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE // $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // $select (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO SELECT // OUTPUT: AN ARRAY OF MEDIA function album_media_list($start, $limit, $sort_by = "media_id DESC", $where = "", $select = "") { global $database, $user, $owner; // BEGIN QUERY $sql = " SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_title, se_media.media_totalcomments AS total_comments "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname "; // ADD ADDITIONAL SELECTS if( !empty($select) ) $sql .= $select; // CONTINUE QUERY $sql .= " FROM se_media LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY /*if( !empty($where) || $this->user_id ) $sql .= " WHERE ";*/ if($owner->user_info["user_id"]==$user->user_info["user_id"]||$this->user_id==$user->user_info["user_id"]){ $sql .= " WHERE approved!=1000 "; } else{ $sql .= " WHERE approved=1 "; } // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " AND album_user_id='{$this->user_id}' "; // INSERT AND IF NECESSARY //if( $this->user_id && !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " AND {$where} "; // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; // RUN QUERY $resource = $database->database_query($sql); // GET MEDIA INTO AN ARRAY $media_array = array(); while($media_info = $database->database_fetch_assoc($resource)) { $tags=""; $checkusers=$database->database_query("SELECT * FROM se_mediatags WHERE mediatag_media_id='".$database->database_real_escape_string($media_info['media_id'])."'"); while($rowusers=$database->database_fetch_array($checkusers)) { $thisuser=$database->database_query("SELECT user_username FROM se_users WHERE user_id='".$database->database_real_escape_string($rowusers['mediatag_user_id'])."'"); $rowuser=$database->database_fetch_array($thisuser); if($tags==""){ $tags=$rowuser["user_username"]."
";} else{$tags.=$rowuser["user_username"]."
";} } $media_info['media_tags']=$tags; // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $media_info['user_id']; $author->user_info['user_username'] = $media_info['user_username']; $author->user_info['user_photo'] = $media_info['user_photo']; $author->user_info['user_fname'] = $media_info['user_fname']; $author->user_info['user_lname'] = $media_info['user_lname']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $user; } $media_info['media_author'] =& $author; // BACKWARDS COMPAT $media_info['media_comments_total'] = $media_info['total_comments']; //$media_info['media_desc'] = str_replace("
", "\r\n", $media_info['media_desc']); // CREATE ARRAY OF MEDIA DATA $media_array[] = $media_info; unset($media_info, $author); } // RETURN ARRAY return $media_array; } // END album_media_list() METHOD // THIS METHOD UPDATES MEDIA INFORMATION // INPUT: $start REPRESENTING THE MEDIA TO START WITH // $limit REPRESENTING THE NUMBER OF MEDIA TO RETURN // $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE // $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // OUTPUT: AN ARRAY CONTAINING ALL THE MEDIA ID function album_media_update($start, $limit, $sort_by = "media_id DESC", $where = "") { global $database; // BEGIN QUERY $media_query = "SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_title, count(se_mediacomments.mediacomment_id) AS total_comments"; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if($this->user_id == 0) { $media_query .= ", se_users.user_id, se_users.user_username, se_users.user_photo"; } // CONTINUE QUERY $media_query .= " FROM se_media LEFT JOIN se_mediacomments ON se_mediacomments.mediacomment_media_id=se_media.media_id LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id"; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if($this->user_id == 0) { $media_query .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id"; } // ADD WHERE IF NECESSARY if($where != "" || $this->user_id != 0) { $media_query .= " WHERE"; } // ENSURE USER ID IS NOT EMPTY if($this->user_id != 0) { $media_query .= " album_user_id='".$this->user_id."'"; } // INSERT AND IF NECESSARY if($this->user_id != 0 && $where != "") { $media_query .= " AND"; } // ADD WHERE CLAUSE, IF NECESSARY if($where != "") { $media_query .= " $where"; } // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $media_query .= " GROUP BY media_id ORDER BY $sort_by LIMIT $start, $limit"; // RUN QUERY $media = $database->database_query($media_query); // GET MEDIA INTO AN ARRAY $media_array = Array(); while($media_info = $database->database_fetch_assoc($media)) { $var1 = "media_title_".$media_info["media_id"]; $var2 = "media_desc_".$media_info["media_id"]; $var3 = "media_album_id_".$media_info["media_id"]; $media_title = censor($_POST[$var1]); $media_desc = censor(str_replace("\r\n", "
", $_POST[$var2])); $media_album_id = $_POST[$var3]; if($media_title != $media_info["media_title"] || $media_desc != $media_info["media_desc"] || $media_album_id != $media_info["media_album_id"]) { if($media_album_id != $media_info["media_album_id"]) { if($database->database_num_rows($database->database_query("SELECT album_id FROM se_albums WHERE album_id='$media_album_id' AND album_user_id='".$this->user_id."' LIMIT 1")) != 1) { $media_album_id = $media_info["media_album_id"]; } } $database->database_query("UPDATE se_media SET media_title='$media_title', media_desc='$media_desc', media_album_id='$media_album_id' WHERE media_id='".$media_info["media_id"]."'"); } if($media_album_id == $media_info["media_album_id"]) { $media_array[] = $media_info["media_id"]; } } return $media_array; } function album_media_update_new($start, $limit, $sort_by = "media_id DESC", $where = "") { global $database; // BEGIN QUERY $media_query = "SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_title, count(se_mediacomments.mediacomment_id) AS total_comments"; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if($this->user_id == 0) { $media_query .= ", se_users.user_id, se_users.user_username, se_users.user_photo"; } // CONTINUE QUERY $media_query .= " FROM se_media LEFT JOIN se_mediacomments ON se_mediacomments.mediacomment_media_id=se_media.media_id LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id"; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if($this->user_id == 0) { $media_query .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id"; } // ADD WHERE IF NECESSARY if($where != "" || $this->user_id != 0) { $media_query .= " WHERE"; } // ENSURE USER ID IS NOT EMPTY if($this->user_id != 0) { $media_query .= " album_user_id='".$this->user_id."'"; } // INSERT AND IF NECESSARY if($this->user_id != 0 && $where != "") { $media_query .= " AND"; } // ADD WHERE CLAUSE, IF NECESSARY if($where != "") { $media_query .= " $where"; } // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $media_query .= " GROUP BY media_id ORDER BY $sort_by LIMIT $start, $limit"; // RUN QUERY $media = $database->database_query($media_query); // GET MEDIA INTO AN ARRAY $media_array = Array(); while($media_info = $database->database_fetch_assoc($media)) { $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]; if($media_title != $media_info["media_title"] || $media_desc != $media_info["media_desc"] || $media_album_id != $media_info["media_album_id"]) { if($media_album_id != $media_info["media_album_id"]) { if($database->database_num_rows($database->database_query("SELECT album_id FROM se_albums WHERE album_id='$media_album_id' AND album_user_id='".$this->user_id."' LIMIT 1")) != 1) { $media_album_id = $media_info["media_album_id"]; } } $database->database_query("UPDATE se_media SET media_title='$media_title', media_desc='$media_desc', media_album_id='$media_album_id' WHERE media_id='".$media_info["media_id"]."'"); } if($media_album_id == $media_info["media_album_id"]) { $media_array[] = $media_info["media_id"]; } } return $media_array; } // END album_media_update() METHOD // THIS METHOD DELETES SELECTED MEDIA // INPUT: $start REPRESENTING THE MEDIA TO START WITH // $limit REPRESENTING THE NUMBER OF MEDIA TO RETURN // $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE // $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // OUTPUT: function album_media_delete($start, $limit, $sort_by = "media_id DESC", $where = "") { global $database, $url, $user; $delete = $_POST['delete']; if(!is_array($delete)){return;} if(is_array($delete) && count($delete) == 0) { return; } if(is_array($delete)){$del1=implode(", ", $delete);}elseif($delete!=null&&$delete!=""){$del1=$delete;} if($del1==""){$del1=-1;} // BEGIN QUERY $media_query = " SELECT se_media.media_id, se_media.media_ext, se_media.media_album_id, se_media.media_filesize FROM se_media LEFT JOIN se_mediacomments ON se_mediacomments.mediacomment_media_id=se_media.media_id LEFT JOIN se_albums ON se_albums.album_id=se_media.media_album_id "; // ADD WHERE IF NECESSARY $media_query .= " WHERE se_media.media_id IN(".$del1.") && se_albums.album_user_id='{$this->user_id}' "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $media_query .= " AND $where"; } // ADD GROUP BY, ORDER, AND LIMIT CLAUSE $media_query .= " GROUP BY media_id ORDER BY $sort_by LIMIT $start, $limit"; // RUN QUERY $media = $database->database_query($media_query) or die(error_log($media_query)); // LOOP OVER MEDIA $thumbs = Array(); while($media_info = $database->database_fetch_assoc($media)) { $media_path = $url->url_userdir($this->user_id).$media_info["media_id"].".".$media_info["media_ext"]; if(file_exists($media_path)) { @unlink($media_path); } $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "", $media_path), ));}catch (Exception $e) {} $thumb_path = $url->url_userdir($this->user_id).$media_info["media_id"]."_thumb.".$media_info["media_ext"]; if(file_exists($thumb_path)) { @unlink($thumb_path); } try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "", $thumb_path), ));}catch (Exception $e) {} $thumbs[] = $url->url_base.substr($url->url_userdir($this->user_id), 2).$media_info["media_id"]."_thumb.".$media_info["media_ext"]; $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user->user_info["user_id"]}', time='".time()."', action='User has deleted a photo of theirs'"); // DECREMENT ALBUM FILES AND SPACE COUNT if( !is_numeric($media_info['media_filesize']) ){ $media_info['media_filesize'] = 0;} $database->database_query("UPDATE se_albums SET album_totalfiles=album_totalfiles-1, album_totalspace=album_totalspace-'{$media_info['media_filesize']}' WHERE album_id='{$media_info['media_album_id']}' LIMIT 1"); $database->database_query("DELETE FROM se_mediacomments WHERE mediacomment_media_id='".$media_info["media_id"]."'"); $database->database_query("DELETE FROM se_mediatags WHERE mediatag_media_id='".$media_info["media_id"]."'"); $database->database_query("DELETE FROM se_media WHERE media_id='".$media_info["media_id"]."'"); } // DELETE ACTION MEDIA IF NECESSARY //$database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_path IN ('".implode("', '", $thumbs)."')"); // DELETE MEDIA FROM DATABASE // $database->database_query("DELETE FROM se_media, se_mediacomments, se_mediatags USING se_media LEFT JOIN se_mediacomments ON se_media.media_id=se_mediacomments.mediacomment_media_id LEFT JOIN se_mediatags ON se_media.media_id=se_mediatags.mediatag_media_id WHERE se_media.media_id IN(".$del1.")"); return TRUE; } // END album_media_delete() METHOD // THIS METHOD ROTATES SELECTED MEDIA // INPUT: $media_id REPRESENTING THE ID OF THE MEDIA TO ROTATE // $angle REPRESENTING THE NUMBER OF DEGREES TO ROTATE THE IMAGE // OUTPUT: function album_media_rotate($media_id, $dir) { global $database, $url; // ENSURE MEDIA BELONGS TO USER $media = $database->database_query("SELECT se_media.* FROM se_media LEFT JOIN se_albums ON se_media.media_album_id=se_albums.album_id WHERE media_id='$media_id' AND album_user_id='".$this->user_id."'"); if($database->database_num_rows($media) != 1) { return; } $media_info = $database->database_fetch_assoc($media); $media_path = $url->url_userdir($this->user_id).$media_info["media_id"].".".$media_info["media_ext"]; $thumb_path = $url->url_userdir($this->user_id).$media_info["media_id"]."_thumb.".$media_info["media_ext"]; // GET IMAGE INFORMATION $media_dimensions = @getimagesize($media_path); $media_width = $media_dimensions[0]; $media_height = $media_dimensions[1]; // ROTATE IMAGE /* switch($media_info["media_ext"]) { case "gif": case "GIF": $old = imagecreatefromgif($media_path); $rotate = imagerotate($old, $dir, 0); imagejpeg($rotate, $media_path, 100); ImageDestroy($old); ImageDestroy($rotate); break; case "bmp": case "BMP": $old = imagecreatefrombmp($media_path); $rotate = imagerotate($old, $dir, 0); imagejpeg($rotate, $media_path, 100); ImageDestroy($old); ImageDestroy($rotate); break; case "jpeg": case "jpg": case "JPEG": case "JPG": $old = imagecreatefromjpeg($media_path); //mail("leprakhauns@gmail.com", "AAA", $media_path); $rotate = imagerotate($old, $dir, 0); imagejpeg($rotate, $media_path, 100); ImageDestroy($old); ImageDestroy($rotate); break; case "png": case "PNG": $old = imagecreatefrompng($media_path); $rotate = imagerotate($old, $dir, 0); imagejpeg($rotate, $media_path, 100); ImageDestroy($old); ImageDestroy($rotate); break; } // GET THUMB INFO $thumb_dimensions = @getimagesize($thumb_path); $thumb_width = $thumb_dimensions[0]; $thumb_height = $thumb_dimensions[1]; */ system("/usr/bin/convert '".$media_path."' -rotate ".$dir." '".$media_path."'", $array); system("/usr/bin/convert '".$thumb_path."' -rotate ".$dir." '".$thumb_path."'", $array); /* else{ $old = imagecreatefromjpeg($media_path); //mail("leprakhauns@gmail.com", "AAA", $media_path); $rotate = imagerotate($old, $dir, 0); imagejpeg($rotate, $media_path, 100); ImageDestroy($old); ImageDestroy($rotate); // ROTATE THUMB $old = imagecreatefromjpeg($thumb_path); $rotate = imagerotate($old, $dir, 0); imagejpeg($rotate, $thumb_path, 100); ImageDestroy($old); ImageDestroy($rotate); }*/ /* $old = imagecreatefrompng($media_path); imageAlphaBlending($old, true); imageSaveAlpha($old, true); //mail("leprakhauns@gmail.com", "AAA", $media_path); $rotate = imagerotate($old, $dir, 0); imagepng($rotate, $media_path, 100); ImageDestroy($old); ImageDestroy($rotate); // ROTATE THUMB $old = imagecreatefrompng($thumb_path); imageAlphaBlending($old, true); imageSaveAlpha($old, true); $rotate = imagerotate($old, $dir, 0); imagepng($rotate, $thumb_path, 100); ImageDestroy($old); ImageDestroy($rotate); */ //if($dir=="c"){$rotate=90;}else{$rotate=270;} //error_log("/usr/bin/convert ".$this->file_tempname." -coalesce ".$photo_dest.""); //system("/usr/bin/convert -strip -size ".$this->file_width."x".$this->file_height." '".$photo_dest."' -resize $heightx$width '".$photo_dest."'", $array); /*$cf_cache_v1 = new cloudflare_cache( array( "tkn" => "b4fafa93f2bcd7ce518553d2df2793edd06e8", "email" => "lepslair@gmail.com", "z" => "bateworld.com" ) );*/ highwindsdelete(IMAGECDN.substr($media_path,2)); highwindsdelete(IMAGECDN.substr($thumb_path,2)); # Update cache all in domain //$res = $cf_cache_v1->purge_file("https://bateworld.com/".substr($media_path,2)); //$res = $cf_cache_v1->purge_file("https://bateworld.com/".substr($thumb_path,2)); //$res = $cf_cache_v1->purge_file(true); //$res = $cf_cache_v1->purge_all(); //mail("leprakhauns@gmail.com", "rotate", "/".substr($thumb_path,2)); # Update cache file(s) (url) //mail("leprakhauns@gmail.com", "rrr", $media_path); return $media_info["media_ext"]; } // END album_media_rotate() METHOD function randomalbums($where) { global $database, $user, $owner; // BEGIN QUERY $sql = " SELECT se_albums.*, se_albums.album_totalfiles AS total_files, se_albums.album_totalspace AS total_space, se_media.approved "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname, se_users.user_enabled "; // CONTINUE QUERY $sql .= " FROM se_albums, se_media "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " , se_users "; // ADD WHERE IF NECESSARY $sql .= " WHERE se_albums.album_user_id=se_users.user_id AND album_cover=se_media.media_id "; if($owner->user_info["user_id"]==$user->user_info["user_id"]||$this->user_id==$user->user_info["user_id"]){ $sql .= " AND approved!=1000 "; } else{ $sql .= " AND approved=1 "; } // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " AND album_user_id='{$this->user_id}' "; // INSERT AND IF NECESSARY if( !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; $num=$this->album_total("album_search=1 AND se_users.user_enabled=1 ")-56; $rand=rand(1, $num); //$rand=rand(1, 1000-56); if($rand<1){$rand=1;} $top=$rand+55; // ADD ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY album_id LIMIT $rand, 130 "; // RUN QUERY $resource = $database->database_query($sql); // GET ALBUMS INTO AN ARRAY $album_array = Array(); while( $album_info = $database->database_fetch_assoc($resource) ) { if($album_info['user_enabled']==1){ // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $album_info['user_id']; $author->user_info['user_username'] = $album_info['user_username']; $author->user_info['user_fname'] = $album_info['user_fname']; $author->user_info['user_lname'] = $album_info['user_lname']; $author->user_info['user_photo'] = $album_info['user_photo']; $author->user_info['user_enabled'] = $album_info['user_enabled']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$album_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id'] == $album_info['album_user_id'] ) { $author =& $user; } // CONVERT SPACE TO MB $album_space_mb = ($album_info['total_space'] / 1024) / 1024; $album_space_mb = round($album_space_mb, 2); // GET PATH OF ALBUM COVER $album_cover_id = 0; $album_cover_ext = ""; if( $album_info['album_cover'] ) { $album_cover_query = $database->database_query("SELECT media_id, media_ext FROM se_media WHERE media_id='{$album_info['album_cover']}' AND media_album_id='{$album_info['album_id']}' LIMIT 1"); if( $database->database_num_rows($album_cover_query) ) { $album_cover_array = $database->database_fetch_assoc($album_cover_query); $album_cover_id = $album_cover_array['media_id']; $album_cover_ext = $album_cover_array['media_ext']; } } // CREATE ARRAY OF ALBUM DATA SE_Language::_preload(user_privacy_levels($album_info['album_privacy'])); // SET OTHER INFO $album_info['album_author'] =& $author; $album_info['album_space'] = $album_space_mb; $album_info['album_privacy'] = user_privacy_levels($album_info['album_privacy']); $album_info['album_cover_id'] = $album_cover_id; $album_info['album_cover_ext'] = $album_cover_ext; $album_info['album_files'] = $album_info['total_files']; $signup_user = new se_user(Array($album_info['user_id'])); /*$signup_user->user_info['user_id'] = $album_info['user_id']; $signup_user->user_info['user_username'] = $album_info['user_username']; $signup_user->user_info['user_photo'] = $signup_user->user_photo('./images/nophoto.png'); $signup_user->user_info['user_fname'] = $album_info['user_fname']; $signup_user->user_info['user_lname'] = $album_info['user_lname'];*/ // $signup_user->user_displayname(); //echo var_dump($album_info['album_author']->user_displayname()); //$signup_user->user_info['display_name']=$signup_user->user_displayname(); //echo $signup_user->user_info['user_username']; // exit; $album_array[] = $album_info; //$album_array[] =& $signup_user; unset($author, $album_info, $signup_user); } } // RETURN ARRAY return $album_array; } function randomphotos($where) { global $database, $user, $owner, $setting; // BEGIN QUERY $sql = " SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_title, se_media.media_totalcomments AS total_comments "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname, se_users.user_enabled "; // ADD ADDITIONAL SELECTS if( !empty($select) ) $sql .= $select; // CONTINUE QUERY $sql .= " FROM se_media LEFT JOIN se_albums FORCE INDEX (PRIMARY) ON se_albums.album_id=se_media.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY if( !empty($where) || $this->user_id ) $sql .= " WHERE "; // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " album_user_id='{$this->user_id}' "; // INSERT AND IF NECESSARY if( $this->user_id && !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; $rand=rand(1, $setting["total_searchable_albums"]-130); // $rand=rand(1, 1000-56); if($rand<1){$rand=1;} $top=$rand+55; // ADD ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY album_id LIMIT $rand, 130 "; //if(SE_DEBUG1){echo $sql;} // echo $sql; exit; // RUN QUERY $resource = $database->database_query($sql); // GET MEDIA INTO AN ARRAY $media_array = array(); while($media_info = $database->database_fetch_assoc($resource)) { if($album_info['user_enabled']==1){ // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $media_info['user_id']; $author->user_info['user_username'] = $media_info['user_username']; $author->user_info['user_photo'] = $media_info['user_photo']; $author->user_info['user_fname'] = $media_info['user_fname']; $author->user_info['user_lname'] = $media_info['user_lname']; $author->user_info['user_enabled'] = $media_info['user_enabled']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $user; } } $media_info['media_author'] =& $author; // BACKWARDS COMPAT $media_info['media_comments_total'] = $media_info['total_comments']; $media_info['media_desc'] = str_replace("
", "\r\n", $media_info['media_desc']); // CREATE ARRAY OF MEDIA DATA $media_array[] = $media_info; unset($media_info, $author); } // RETURN ARRAY return $media_array; } function randomphotos_page($where) { global $database, $user, $owner, $setting; // BEGIN QUERY $sql = " SELECT se_media.*, se_albums.album_id, se_albums.album_user_id, se_albums.album_title, se_albums.album_search, se_media.media_totalcomments AS total_comments "; // IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION if( !$this->user_id ) $sql .= ", se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname, se_users.user_enabled "; // ADD ADDITIONAL SELECTS if( !empty($select) ) $sql .= $select; // CONTINUE QUERY $sql .= " FROM se_media LEFT JOIN se_albums FORCE INDEX (PRIMARY) ON se_albums.album_id=se_media.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_albums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY //if( !empty($where) || $this->user_id ) $sql .= " WHERE album_search=1 AND se_users.user_enabled=1 AND shadowbanned=0 "; // ENSURE USER ID IS NOT EMPTY if( $this->user_id ) $sql .= " AND album_user_id='{$this->user_id}' "; // INSERT AND IF NECESSARY if( $this->user_id && !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " AND {$where} "; $rand=rand(1, $setting["total_searchable_albums"]-1500); // $rand=rand(1, 1000-56); if($rand<1){$rand=1;} $top=$rand+55; // ADD ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY album_id LIMIT $rand, 1500 "; // echo $sql; exit; // RUN QUERY $resource = $database->database_query($sql); // GET MEDIA INTO AN ARRAY $media_array = array(); while($media_info = $database->database_fetch_assoc($resource)) { //if($media_info['user_enabled']==1) { // IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR if( !$this->user_id ) { $author = new se_user(); $author->user_exists = TRUE; $author->user_info['user_id'] = $media_info['user_id']; $author->user_info['user_username'] = $media_info['user_username']; $author->user_info['user_photo'] = $media_info['user_photo']; $author->user_info['user_fname'] = $media_info['user_fname']; $author->user_info['user_lname'] = $media_info['user_lname']; $author->user_info['user_enabled'] = $media_info['user_enabled']; $author->user_displayname(); } // OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER elseif( $owner->user_exists && $owner->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $owner; } elseif( $user->user_exists && $user->user_info['user_id']==$media_info['album_user_id'] ) { $author =& $user; } } $media_info['media_author'] =& $author; // BACKWARDS COMPAT $media_info['media_comments_total'] = $media_info['total_comments']; $media_info['media_desc'] = str_replace("
", "\r\n", $media_info['media_desc']); // CREATE ARRAY OF MEDIA DATA $media_array[] = $media_info; unset($media_info, $author); } // RETURN ARRAY return $media_array; } } ?>