group_id = $group_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_groupalbums ";*/ $sql = " SELECT COUNT(*) as cnt FROM se_groupalbums "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE /*if( !$this->group_id ) $sql .= " LEFT JOIN se_groups ON se_groupalbums.groupalbum_group_id=se_groups.group_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->group_id ) $sql .= " AND groupalbum_group_id='{$this->group_id}' "; // INSERT AND IF NECESSARY if( !empty($where) ) $sql .= " AND"; // ADD WHERE CLAUSE, IF NECESSARY if( !empty($where) ) $sql .= " {$where} "; $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_groupalbums.*, se_groupalbums.groupalbum_totalfiles AS total_files, se_groupalbums.groupalbum_totalspace AS total_space "; // 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_groupalbums "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE /*if( !$this->user_id ){$sql .= " LEFT JOIN se_groups ON se_groupalbums.album_user_id=se_users.user_id "; }*/ // ADD WHERE IF NECESSARY $sql .= "WHERE groupalbum_totalfiles!='jijjoijsoijiojsdfiofiosjisjrfoijf' "; if( $this->group_id ) $sql .= " AND groupalbum_group_id='{$this->group_id}' "; /* 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} "; // ADD ORDER, AND LIMIT CLAUSE $sql .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; // 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 groupmedia_id, groupmedia_ext FROM se_groupmedia WHERE groupmedia_id='{$album_info['groupalbum_cover']}' AND groupmedia_groupalbum_id='{$album_info['groupalbum_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['groupmedia_id']; $album_cover_ext = $album_cover_array['groupmedia_ext']; } } else{ $album_cover_query = $database->database_query("SELECT groupmedia_id, groupmedia_ext FROM se_groupmedia WHERE groupmedia_groupalbum_id='{$album_info['groupalbum_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['groupmedia_id']; $album_cover_ext = $album_cover_array['groupmedia_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['groupalbum_space'] = $album_space_mb; $album_info['groupalbum_privacy'] = user_privacy_levels($album_info['groupalbum_privacy']); $album_info['groupalbum_cover_id'] = $album_cover_id; $album_info['groupalbum_cover_ext'] = $album_cover_ext; $album_info['groupalbum_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_groupmedia.media_filesize) AS total_space"; // CONTINUE QUERY $album_query .= " FROM se_groupalbums LEFT JOIN se_groupmedia ON se_groupalbums.groupalbum_id=se_groupmedia.groupmedia_groupalbum_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 .= " groupalbum_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; if($name!="."){ $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)); if($user=="") {return;} } $media = $database->database_query("SELECT groupmedia_id, groupmedia_ext FROM se_groupmedia WHERE groupmedia_groupalbum_id='$album_id'"); // LOOP OVER MEDIA while($media_info = $database->database_fetch_assoc($media)) { $media_path = get_groupdir($this->group_id).$media_info["groupmedia_id"].".".$media_info["groupmedia_ext"]; // mail("leprakhauns@gmail.com", "l123ll", $media_path);exit; 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 = get_groupdir($this->group_id).$media_info["groupmedia_id"]."_thumb.".$media_info["groupmedia_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("DELETE FROM se_groupalbums, se_groupmedia, se_groupmediacomments, se_groupmediatags USING se_groupalbums LEFT JOIN se_groupmedia ON se_groupalbums.groupalbum_id=se_groupmedia.groupmedia_groupalbum_id LEFT JOIN se_groupmediacomments ON se_groupmedia.groupmedia_id=se_groupmediacomments.groupmediacomment_groupmedia_id LEFT JOIN se_groupmediatags ON se_groupmedia.groupmedia_id=se_groupmediatags.groupmediatag_groupmedia_id WHERE se_groupalbums.groupalbum_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_groupalbums.*, count(se_groupmedia.media_id) AS total_files, sum(se_groupmedia.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_groupalbums LEFT JOIN se_groupmedia ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.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_groupalbums.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_groupmedia.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_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_groupmedia LEFT JOIN se_groupalbums ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_groupalbums.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 // 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_groupmedia.*, se_groupalbums.groupmedia_groupalbum_id, se_groupalbums.album_user_id, se_groupalbums.album_title, se_groupmedia.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_groupmedia FORCE INDEX (PRIMARY) LEFT JOIN se_groupalbums ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_groupalbums.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_groupmedia.*, se_groupalbums.groupmedia_groupalbum_id, se_groupalbums.album_user_id, se_groupalbums.album_title, se_groupmedia.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_groupmedia FORCE INDEX (PRIMARY) LEFT JOIN se_groupalbums ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.media_album_id "; if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_groupalbums.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_groupmedia.groupmedia_id) AS total_files"; // CONTINUE QUERY $album_query .= " FROM se_groupmediatags, se_groupalbums LEFT JOIN se_groupmedia ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.groupmedia_groupalbum_id"; // ADD WHERE IF NECESSARY $album_query .= " WHERE se_groupmediatags.groupmediatag_media_id=se_groupmedia.groupmedia_id AND groupmediatag_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_groupmedia.*, se_groupalbums.groupmedia_groupalbum_id, se_groupalbums.album_user_id, se_groupalbums.album_title, se_groupmedia.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_groupmediatags, se_groupmedia LEFT JOIN se_groupalbums ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE $sql .= " LEFT JOIN se_users ON se_groupalbums.album_user_id=se_users.user_id "; // ADD WHERE IF NECESSARY $sql .= " WHERE se_groupmediatags.mediatag_media_id=se_groupmedia.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_groupmediatags WHERE groupmediatag_groupmedia_id='".$database->database_real_escape_string($media_info['groupmedia_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['groupmediatag_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_groupalbums 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_groupmedia.media_id) AS album_totalfiles FROM se_groupmedia"; } $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_groupmedia.groupmedia_id) AS total_files"; // CONTINUE QUERY $album_query .= " FROM se_groupalbums LEFT JOIN se_groupmedia ON se_groupalbums.groupalbum_id=se_groupmedia.groupmedia_groupalbum_id"; // ADD WHERE IF NECESSARY if($this->group_id != 0 || $album_id != 0 || $where != "") { $album_query .= " WHERE"; } // ENSURE USER ID IS NOT EMPTY if($this->group_id != 0) { $album_query .= " groupalbum_group_id='".$this->group_id."'"; } // INSERT AND IF NECESSARY if($this->group_id != 0 && ($album_id != 0 || $where != "")) { $album_query .= " AND"; } // SPECIFY ALBUM IF NECESSARY if($album_id != 0) { $album_query .= " groupalbum_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;} try{ $file_info = $database->database_fetch_assoc($database->database_query($album_query)); } //catch exception catch(Exception $e) { if(SE_DEBUG1){echo $album_query."

".$where;} error_log("class_groupalbum.php error line 1046: ".$album_query); } return $file_info["total_files"]; } // END album_files() METHOD // 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_groupmedia LEFT JOIN se_groupalbums ON se_groupmedia.media_album_id=se_groupalbums.groupmedia_groupalbum_id WHERE se_groupalbums.album_user_id='".$user->user_info["user_id"]."'")); $media_order = $max["max"]+1; $consentmarking=$_POST["consent"]; if($consentmarking==1){$marketingdate=time();} // INSERT ROW INTO MEDIA TABLE $database->database_query(" INSERT INTO se_groupmedia ( media_album_id, media_date, media_order, rights, consentgiven ) 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)."' ) "); $media_id = $database->database_insert_id(); wrapup("groupupload_photo"); $pathinfo = pathinfo($_FILES[$file_name]['name']); $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_groupmedia 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_groupmedia 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_groupalbums 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_groupmedia.*, se_groupalbums.groupalbum_id, se_groupalbums.groupalbum_title, se_groupmedia.groupmedia_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_groupmedia LEFT JOIN se_groupalbums ON se_groupalbums.groupalbum_id=se_groupmedia.groupmedia_groupalbum_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_groupmedia.groupmedia_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 .= " groupmedia_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} "; // 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)) { $tags=""; $checkusers=$database->database_query("SELECT * FROM se_groupmediatags WHERE groupmediatag_groupmedia_id='".$database->database_real_escape_string($media_info['groupmedia_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['groupmediatag_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_groupmedia.*, se_groupalbums.groupmedia_groupalbum_id, se_groupalbums.album_user_id, se_groupalbums.album_title, count(se_groupmediacomments.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_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmediacomments.mediacomment_media_id=se_groupmedia.media_id LEFT JOIN se_groupalbums ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.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_groupalbums.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_groupalbums 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_groupmedia 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_groupmedia.*, se_groupalbums.groupmedia_groupalbum_id, se_groupalbums.album_user_id, se_groupalbums.album_title, count(se_groupmediacomments.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_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmediacomments.mediacomment_media_id=se_groupmedia.media_id LEFT JOIN se_groupalbums ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.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_groupalbums.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_groupalbums 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_groupmedia 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 = "se_groupmedia.groupmedia_id DESC", $where = "") { global $database, $url; $delete = $_POST['delete']; if(is_array($delete) && count($delete) == 0) { return; } if(is_array($delete)){$del1=implode(", ", $delete);} else{$del1=$delete;} if($del1==""||$del1==null){$del1=0;} // BEGIN QUERY $media_query = " SELECT se_groupmedia.groupmedia_id, se_groupmedia.groupmedia_ext, se_groupmedia.groupmedia_groupalbum_id, se_groupmedia.groupmedia_filesize FROM se_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmediacomments.groupmediacomment_groupmedia_id=se_groupmedia.groupmedia_id LEFT JOIN se_groupalbums ON se_groupalbums.groupalbum_id=se_groupmedia.groupmedia_groupalbum_id "; // ADD WHERE IF NECESSARY $media_query .= " WHERE se_groupmedia.groupmedia_id IN(".$del1.") "; if($this->user_id!=""&&$this->user_id>0){ $media_query .= " AND se_groupmedia.groupmedia_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 groupmedia_id ORDER BY $sort_by LIMIT $start, $limit"; // RUN QUERY try { $media = $database->database_query($media_query); } //catch exception catch(Exception $e) { error_log($media_query); error_log('PHP FATAL ERROR: class_groupalbum.php line 1587 Message: ' .$e->getMessage()); } // LOOP OVER MEDIA $thumbs = Array(); while($media_info = $database->database_fetch_assoc($media)) { $media_path = str_replace("./", "", get_groupdir($this->group_id).$media_info["groupmedia_id"].".".$media_info["groupmedia_ext"]); $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 = str_replace("./", "", get_groupdir($this->group_id).$media_info["groupmedia_id"]."_thumb.".$media_info["groupmedia_ext"]); //if(file_exists($thumb_path)) { try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "", $thumb_path), ));}catch (Exception $e) {} } $thumbs[] = str_replace("./", "", get_groupdir($this->group_id).$media_info["groupmedia_id"]."_thumb.".$media_info["groupmedia_ext"]); // DECREMENT ALBUM FILES AND SPACE COUNT if( !is_numeric($media_info['groupmedia_filesize']) ){ $media_info['groupmedia_filesize'] = 0;} $database->database_query("UPDATE se_groupalbums SET groupalbum_totalfiles=groupalbum_totalfiles-1, groupalbum_totalspace=groupalbum_totalspace-'{$media_info['groupmedia_filesize']}' WHERE groupalbum_id='{$media_info['groupmedia_groupalbum_id']}' LIMIT 1"); $database->database_query("DELETE FROM se_groupmedia WHERE se_groupmedia.groupmedia_id='".$media_info["groupmedia_id"]."'"); $database->database_query("DELETE FROM se_groupmediacomments WHERE groupmediacomment_groupmedia_id='".$media_info["groupmedia_id"]."'"); $database->database_query("DELETE FROM se_groupmediatags WHERE groupmediatag_groupmedia_id='".$media_info["groupmedia_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_groupmedia, se_groupmediacomments, se_groupmediatags USING se_groupmedia LEFT JOIN se_groupmediacomments ON se_groupmedia.media_id=se_groupmediacomments.mediacomment_media_id LEFT JOIN se_groupmediatags ON se_groupmedia.media_id=se_groupmediatags.mediatag_media_id WHERE se_groupmedia.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_groupmedia.* FROM se_groupmedia LEFT JOIN se_groupalbums ON se_groupmedia.groupmedia_groupalbum_id=se_groupalbums.groupalbum_id WHERE groupmedia_id='$media_id' AND groupmedia_groupalbum_id='".$this->album_id."'"); if($database->database_num_rows($media) != 1) { return; } $media_info = $database->database_fetch_assoc($media); $media_path = group_dir($this->group_id).$media_info["groupmedia_id"].".".$media_info["groupmedia_ext"]; $thumb_path = group_dir($this->group_id).$media_info["groupmedia_id"]."_thumb.".$media_info["groupmedia_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]; */ $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); /*$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_groupalbums.*, se_groupalbums.album_totalfiles AS total_files, se_groupalbums.album_totalspace AS total_space "; // 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_groupalbums "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " , se_users "; // ADD WHERE IF NECESSARY $sql .= " WHERE se_groupalbums.album_user_id=se_users.user_id "; // 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()-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_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_groupmedia 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; // BEGIN QUERY $sql = " SELECT se_groupmedia.*, se_groupalbums.groupmedia_groupalbum_id, se_groupalbums.album_user_id, se_groupalbums.album_title, se_groupmedia.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_groupmedia LEFT JOIN se_groupalbums FORCE INDEX (PRIMARY) ON se_groupalbums.groupmedia_groupalbum_id=se_groupmedia.media_album_id "; // IF NO USER ID SPECIFIED, JOIN TO USER TABLE if( !$this->user_id ) $sql .= " LEFT JOIN se_users ON se_groupalbums.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, $this->album_total()-56); // $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 "; // 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_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; } } ?>