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