2066 lines
63 KiB
PHP
2066 lines
63 KiB
PHP
<?php
|
|
|
|
/* $Id: class_album.php 293 2010-01-21 01:16:21Z phil $ */
|
|
|
|
|
|
defined('SE_PAGE') or exit();
|
|
|
|
use Aws\S3\S3Client;
|
|
|
|
//
|
|
// THIS CLASS CONTAINS ALBUM ENTRY-RELATED METHODS
|
|
//
|
|
// METHODS IN THIS CLASS:
|
|
//
|
|
// se_album()
|
|
// album_total()
|
|
// album_list()
|
|
// album_space()
|
|
// album_delete()
|
|
// album_delete_selected()
|
|
// album_files()
|
|
// album_media_upload()
|
|
// album_media_list()
|
|
// album_media_update()
|
|
// album_media_delete()
|
|
// album_media_rotate()
|
|
//
|
|
|
|
|
|
|
|
|
|
class se_clubalbum
|
|
{
|
|
// INITIALIZE VARIABLES
|
|
var $is_error; // DETERMINES WHETHER THERE IS AN ERROR OR NOT
|
|
|
|
var $club_id; // CONTAINS THE USER ID OF THE USER WHOSE ALBUM WE ARE EDITING
|
|
|
|
var $album_id;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
// THIS METHOD SETS INITIAL VARS
|
|
// INPUT: $user_id (OPTIONAL) REPRESENTING THE USER ID OF THE USER WHOSE ALBUMS WE ARE CONCERNED WITH
|
|
// OUTPUT:
|
|
|
|
function __construct($club_id = 0)
|
|
{
|
|
$this->club_id = $club_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_clubalbums
|
|
";*/
|
|
$sql = "
|
|
SELECT
|
|
COUNT(*) as cnt
|
|
FROM
|
|
se_clubalbums
|
|
";
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
/*if( !$this->club_id ) $sql .= "
|
|
LEFT JOIN
|
|
se_clubs
|
|
ON
|
|
se_clubalbums.clubalbum_club_id=se_clubs.club_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->club_id ) $sql .= "
|
|
AND clubalbum_club_id='{$this->club_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_clubalbums.*,
|
|
se_clubalbums.clubalbum_totalfiles AS total_files,
|
|
se_clubalbums.clubalbum_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_clubalbums
|
|
";
|
|
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
/*if( !$this->user_id ){$sql .= "
|
|
LEFT JOIN
|
|
se_clubs
|
|
ON se_clubalbums.album_user_id=se_users.user_id
|
|
";
|
|
|
|
|
|
}*/
|
|
// ADD WHERE IF NECESSARY
|
|
|
|
$sql .= "WHERE clubalbum_totalfiles!='jijjoijsoijiojsdfiofiosjisjrfoijf' ";
|
|
if( $this->club_id ) $sql .= "
|
|
AND clubalbum_club_id='{$this->club_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 clubmedia_id, clubmedia_ext FROM se_clubmedia WHERE clubmedia_id='{$album_info['clubalbum_cover']}' AND clubmedia_clubalbum_id='{$album_info['clubalbum_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['clubmedia_id'];
|
|
$album_cover_ext = $album_cover_array['clubmedia_ext'];
|
|
}
|
|
}
|
|
else{
|
|
$album_cover_query = $database->database_query("SELECT clubmedia_id, clubmedia_ext FROM se_clubmedia WHERE clubmedia_clubalbum_id='{$album_info['clubalbum_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['clubmedia_id'];
|
|
$album_cover_ext = $album_cover_array['clubmedia_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['clubalbum_space'] = $album_space_mb;
|
|
$album_info['clubalbum_privacy'] = user_privacy_levels($album_info['clubalbum_privacy']);
|
|
$album_info['clubalbum_cover_id'] = $album_cover_id;
|
|
$album_info['clubalbum_cover_ext'] = $album_cover_ext;
|
|
$album_info['clubalbum_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_clubmedia.media_filesize) AS total_space";
|
|
|
|
// CONTINUE QUERY
|
|
$album_query .= " FROM se_clubalbums LEFT JOIN se_clubmedia ON se_clubalbums.clubalbum_id=se_clubmedia.clubmedia_clubalbum_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 .= " clubalbum_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 clubmedia_id, clubmedia_ext FROM se_clubmedia WHERE clubmedia_clubalbum_id='$album_id'");
|
|
|
|
// LOOP OVER MEDIA
|
|
while($media_info = $database->database_fetch_assoc($media)) {
|
|
|
|
$media_path = get_clubdir($this->club_id).$media_info["clubmedia_id"].".".$media_info["clubmedia_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_clubdir($this->club_id).$media_info["clubmedia_id"]."_thumb.".$media_info["clubmedia_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_clubalbums, se_clubmedia, se_clubmediacomments, se_clubmediatags USING se_clubalbums LEFT JOIN se_clubmedia ON se_clubalbums.clubalbum_id=se_clubmedia.clubmedia_clubalbum_id LEFT JOIN se_clubmediacomments ON se_clubmedia.clubmedia_id=se_clubmediacomments.clubmediacomment_clubmedia_id LEFT JOIN se_clubmediatags ON se_clubmedia.clubmedia_id=se_clubmediatags.clubmediatag_clubmedia_id WHERE se_clubalbums.clubalbum_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_clubalbums.*, count(se_clubmedia.media_id) AS total_files, sum(se_clubmedia.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_clubalbums LEFT JOIN se_clubmedia ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.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_clubalbums.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 club BY, ORDER, AND LIMIT CLAUSE
|
|
$album_query .= " club 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_clubmedia.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_clubmedia
|
|
LEFT JOIN
|
|
se_clubalbums
|
|
ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.media_album_id
|
|
";
|
|
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
if( !$this->user_id ) $sql .= "
|
|
LEFT JOIN
|
|
se_users
|
|
ON se_clubalbums.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 club 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("<br>", "\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]."<br />";
|
|
//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_clubmedia.*,
|
|
se_clubalbums.clubmedia_clubalbum_id,
|
|
se_clubalbums.album_user_id,
|
|
se_clubalbums.album_title,
|
|
se_clubmedia.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_clubmedia FORCE INDEX (PRIMARY)
|
|
LEFT JOIN
|
|
se_clubalbums
|
|
ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.media_album_id
|
|
";
|
|
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
if( !$this->user_id ) $sql .= "
|
|
LEFT JOIN
|
|
se_users
|
|
ON se_clubalbums.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 club 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("<br>", "\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_clubmedia.*,
|
|
se_clubalbums.clubmedia_clubalbum_id,
|
|
se_clubalbums.album_user_id,
|
|
se_clubalbums.album_title,
|
|
se_clubmedia.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_clubmedia FORCE INDEX (PRIMARY)
|
|
LEFT JOIN
|
|
se_clubalbums
|
|
ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.media_album_id
|
|
";
|
|
if( !$this->user_id ) $sql .= "
|
|
LEFT JOIN
|
|
se_users
|
|
ON se_clubalbums.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 club 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("<br>", "\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_clubmedia.clubmedia_id) AS total_files";
|
|
|
|
// CONTINUE QUERY
|
|
$album_query .= " FROM se_clubmediatags, se_clubalbums LEFT JOIN se_clubmedia ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.clubmedia_clubalbum_id";
|
|
|
|
// ADD WHERE IF NECESSARY
|
|
$album_query .= " WHERE se_clubmediatags.clubmediatag_media_id=se_clubmedia.clubmedia_id AND clubmediatag_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_clubmedia.*,
|
|
se_clubalbums.clubmedia_clubalbum_id,
|
|
se_clubalbums.album_user_id,
|
|
se_clubalbums.album_title,
|
|
se_clubmedia.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_clubmediatags, se_clubmedia
|
|
LEFT JOIN
|
|
se_clubalbums
|
|
ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.media_album_id
|
|
";
|
|
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
$sql .= "
|
|
LEFT JOIN
|
|
se_users
|
|
ON se_clubalbums.album_user_id=se_users.user_id
|
|
";
|
|
|
|
// ADD WHERE IF NECESSARY
|
|
$sql .= "
|
|
WHERE se_clubmediatags.mediatag_media_id=se_clubmedia.media_id AND mediatag_user_id='".$user->user_info["user_id"]."'
|
|
";
|
|
|
|
|
|
|
|
|
|
|
|
// ADD club 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_clubmediatags WHERE clubmediatag_clubmedia_id='".$database->database_real_escape_string($media_info['clubmedia_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['clubmediatag_user_id'])."'");
|
|
$rowuser=$database->database_fetch_array($thisuser);
|
|
|
|
if($tags==""){
|
|
$tags=$rowuser["user_username"]."<br>";}
|
|
else{$tags.=$rowuser["user_username"]."<br>";}
|
|
}
|
|
$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("<br>", "\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_clubalbums
|
|
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_clubmedia.media_id) AS album_totalfiles FROM se_clubmedia";
|
|
}
|
|
|
|
$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_clubmedia.clubmedia_id) AS total_files";
|
|
|
|
// CONTINUE QUERY
|
|
$album_query .= " FROM se_clubalbums LEFT JOIN se_clubmedia ON se_clubalbums.clubalbum_id=se_clubmedia.clubmedia_clubalbum_id";
|
|
|
|
// ADD WHERE IF NECESSARY
|
|
if($this->club_id != 0 || $album_id != 0 || $where != "") { $album_query .= " WHERE"; }
|
|
|
|
// ENSURE USER ID IS NOT EMPTY
|
|
if($this->club_id != 0) { $album_query .= " clubalbum_club_id='".$this->club_id."'"; }
|
|
|
|
// INSERT AND IF NECESSARY
|
|
if($this->club_id != 0 && ($album_id != 0 || $where != "")) { $album_query .= " AND"; }
|
|
|
|
// SPECIFY ALBUM IF NECESSARY
|
|
if($album_id != 0) { $album_query .= " clubalbum_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."<br>
|
|
<br>
|
|
".$where;}
|
|
error_log("class_clubalbum.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_clubmedia LEFT JOIN se_clubalbums ON se_clubmedia.media_album_id=se_clubalbums.clubmedia_clubalbum_id WHERE se_clubalbums.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_clubmedia (
|
|
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("clubupload_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_clubmedia 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_clubmedia 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_clubalbums 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_clubmedia.*,
|
|
se_clubalbums.clubalbum_id,
|
|
|
|
se_clubalbums.clubalbum_title,
|
|
se_clubmedia.clubmedia_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_clubmedia
|
|
LEFT JOIN
|
|
se_clubalbums
|
|
ON se_clubalbums.clubalbum_id=se_clubmedia.clubmedia_clubalbum_id
|
|
";
|
|
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
if( !$this->user_id ) $sql .= "
|
|
LEFT JOIN
|
|
se_users
|
|
ON se_clubmedia.clubmedia_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 .= "
|
|
clubmedia_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 club 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_clubmediatags WHERE clubmediatag_clubmedia_id='".$database->database_real_escape_string($media_info['clubmedia_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['clubmediatag_user_id'])."'");
|
|
$rowuser=$database->database_fetch_array($thisuser);
|
|
|
|
if($tags==""){
|
|
$tags=$rowuser["user_username"]."<br>";}
|
|
else{$tags.=$rowuser["user_username"]."<br>";}
|
|
}
|
|
$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("<br>", "\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_clubmedia.*, se_clubalbums.clubmedia_clubalbum_id, se_clubalbums.album_user_id, se_clubalbums.album_title, count(se_clubmediacomments.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_clubmedia LEFT JOIN se_clubmediacomments ON se_clubmediacomments.mediacomment_media_id=se_clubmedia.media_id LEFT JOIN se_clubalbums ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.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_clubalbums.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 club BY, ORDER, AND LIMIT CLAUSE
|
|
$media_query .= " club 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", "<br>", $_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_clubalbums 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_clubmedia 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_clubmedia.*, se_clubalbums.clubmedia_clubalbum_id, se_clubalbums.album_user_id, se_clubalbums.album_title, count(se_clubmediacomments.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_clubmedia LEFT JOIN se_clubmediacomments ON se_clubmediacomments.mediacomment_media_id=se_clubmedia.media_id LEFT JOIN se_clubalbums ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.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_clubalbums.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 club BY, ORDER, AND LIMIT CLAUSE
|
|
$media_query .= " club 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", "<br>", $_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_clubalbums 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_clubmedia 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_clubmedia.clubmedia_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_clubmedia.clubmedia_id,
|
|
se_clubmedia.clubmedia_ext,
|
|
se_clubmedia.clubmedia_clubalbum_id,
|
|
se_clubmedia.clubmedia_filesize
|
|
FROM
|
|
se_clubmedia
|
|
LEFT JOIN
|
|
se_clubmediacomments
|
|
ON se_clubmediacomments.clubmediacomment_clubmedia_id=se_clubmedia.clubmedia_id
|
|
LEFT JOIN
|
|
se_clubalbums ON se_clubalbums.clubalbum_id=se_clubmedia.clubmedia_clubalbum_id
|
|
";
|
|
|
|
// ADD WHERE IF NECESSARY
|
|
$media_query .= "
|
|
WHERE
|
|
se_clubmedia.clubmedia_id IN(".$del1.")
|
|
|
|
";
|
|
|
|
if($this->user_id!=""&&$this->user_id>0){
|
|
$media_query .= " AND se_clubmedia.clubmedia_user_id='{$this->user_id}'";
|
|
}
|
|
// ADD WHERE CLAUSE IF NECESSARY
|
|
if($where != "") { $media_query .= " AND $where"; }
|
|
|
|
// ADD club BY, ORDER, AND LIMIT CLAUSE
|
|
//$media_query .= " club BY clubmedia_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_clubalbum.php line 1587 Message: ' .$e->getMessage());
|
|
}
|
|
|
|
|
|
// LOOP OVER MEDIA
|
|
$thumbs = Array();
|
|
while($media_info = $database->database_fetch_assoc($media))
|
|
{
|
|
|
|
|
|
|
|
$media_path = str_replace("./", "", get_clubdir($this->club_id).$media_info["clubmedia_id"].".".$media_info["clubmedia_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_clubdir($this->club_id).$media_info["clubmedia_id"]."_thumb.".$media_info["clubmedia_ext"]);
|
|
//if(file_exists($thumb_path))
|
|
{
|
|
|
|
try {
|
|
$client->deleteObject(array(
|
|
'Bucket'=>'bateworld',
|
|
'Key' => str_replace("./", "", $thumb_path),
|
|
|
|
));}catch (Exception $e) {}
|
|
}
|
|
$thumbs[] = str_replace("./", "", get_clubdir($this->club_id).$media_info["clubmedia_id"]."_thumb.".$media_info["clubmedia_ext"]);
|
|
|
|
|
|
// DECREMENT ALBUM FILES AND SPACE COUNT
|
|
if( !is_numeric($media_info['clubmedia_filesize']) ){ $media_info['clubmedia_filesize'] = 0;}
|
|
|
|
$database->database_query("UPDATE se_clubalbums SET clubalbum_totalfiles=clubalbum_totalfiles-1, clubalbum_totalspace=clubalbum_totalspace-'{$media_info['clubmedia_filesize']}' WHERE clubalbum_id='{$media_info['clubmedia_clubalbum_id']}' LIMIT 1");
|
|
|
|
$database->database_query("DELETE FROM se_clubmedia WHERE se_clubmedia.clubmedia_id='".$media_info["clubmedia_id"]."'");
|
|
|
|
$database->database_query("DELETE FROM se_clubmediacomments WHERE clubmediacomment_clubmedia_id='".$media_info["clubmedia_id"]."'");
|
|
|
|
$database->database_query("DELETE FROM se_clubmediatags WHERE clubmediatag_clubmedia_id='".$media_info["clubmedia_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_clubmedia, se_clubmediacomments, se_clubmediatags USING se_clubmedia LEFT JOIN se_clubmediacomments ON se_clubmedia.media_id=se_clubmediacomments.mediacomment_media_id LEFT JOIN se_clubmediatags ON se_clubmedia.media_id=se_clubmediatags.mediatag_media_id WHERE se_clubmedia.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_clubmedia.* FROM se_clubmedia LEFT JOIN se_clubalbums ON se_clubmedia.clubmedia_clubalbum_id=se_clubalbums.clubalbum_id WHERE clubmedia_id='$media_id' AND clubmedia_clubalbum_id='".$this->album_id."'");
|
|
|
|
if($database->database_num_rows($media) != 1) { return; }
|
|
$media_info = $database->database_fetch_assoc($media);
|
|
|
|
$media_path = club_dir($this->club_id).$media_info["clubmedia_id"].".".$media_info["clubmedia_ext"];
|
|
$thumb_path = club_dir($this->club_id).$media_info["clubmedia_id"]."_thumb.".$media_info["clubmedia_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_clubalbums.*,
|
|
se_clubalbums.album_totalfiles AS total_files,
|
|
se_clubalbums.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_clubalbums
|
|
";
|
|
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
if( !$this->user_id ) $sql .= "
|
|
,
|
|
se_users
|
|
|
|
";
|
|
|
|
// ADD WHERE IF NECESSARY
|
|
$sql .= "
|
|
WHERE se_clubalbums.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_clubmedia 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_clubmedia.*,
|
|
se_clubalbums.clubmedia_clubalbum_id,
|
|
se_clubalbums.album_user_id,
|
|
se_clubalbums.album_title,
|
|
se_clubmedia.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_clubmedia
|
|
LEFT JOIN
|
|
se_clubalbums FORCE INDEX (PRIMARY)
|
|
ON se_clubalbums.clubmedia_clubalbum_id=se_clubmedia.media_album_id
|
|
";
|
|
|
|
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
|
|
if( !$this->user_id ) $sql .= "
|
|
LEFT JOIN
|
|
se_users
|
|
ON se_clubalbums.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("<br>", "\r\n", $media_info['media_desc']);
|
|
|
|
// CREATE ARRAY OF MEDIA DATA
|
|
$media_array[] = $media_info;
|
|
|
|
unset($media_info, $author);
|
|
}
|
|
|
|
// RETURN ARRAY
|
|
return $media_array;
|
|
}
|
|
|
|
}
|
|
?>
|