Files
Testing/include/functions_album.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

907 lines
30 KiB
PHP

<?php
/* $Id: functions_album.php 42 2009-01-29 04:55:14Z john $ */
defined('SE_PAGE') or exit();
//
// THIS FILE CONTAINS ALBUM-RELATED FUNCTIONS
//
// FUNCTIONS IN THIS CLASS:
//
// search_album()
// mediatag_album()
// deleteuser_album()
// site_statistics_album()
//
function tag_albums(){
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results, $type, $id;
// CONSTRUCT QUERY
$type=1;
if($type==1){
$album_query = "
(
SELECT
'1' AS sub_type,
se_media.media_album_id AS album_id,
se_media.media_title AS title,
se_albums.album_datecreated,
se_media.media_desc AS description,
se_media.media_id AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_media,
se_albums,
se_users,
bateworldcom_zips.mediainteresttagged
WHERE
se_media.approved=1 AND se_media.shadowbanned=0 AND
se_media.media_album_id=se_albums.album_id AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
media_id=bateworldcom_zips.mediainteresttagged.user_id AND bateworldcom_zips.mediainteresttagged.interest_id='".$database->database_real_escape_string($id)."'
)
";
//echo $album_query; exit;
}elseif($type==2){
$album_query = "
(
SELECT
'2' AS sub_type,
se_albums.album_id AS album_id,
se_albums.album_title AS title,
se_albums.album_datecreated,
se_albums.album_desc AS description,
se_albums.album_cover AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_albums,
se_users,
se_levels,
se_media
WHERE
se_media.approved=1 AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
se_albums.album_cover=se_media.media_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_albums.album_title, se_albums.album_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_albums.album_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_albums.album_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)";
}
else{
$album_query = "
(
SELECT
'1' AS sub_type,
se_media.media_album_id AS album_id,
se_media.media_title AS title,
se_albums.album_datecreated,
se_media.media_desc AS description,
se_media.media_id AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_media,
se_albums,
se_users,
se_levels
WHERE
se_media.approved=1 AND
se_media.media_album_id=se_albums.album_id AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_media.media_title, se_media.media_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_media.media_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_media.media_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)
UNION ALL
(
SELECT
'2' AS sub_type,
se_albums.album_id AS album_id,
se_albums.album_title AS title,
se_albums.album_datecreated,
se_albums.album_desc AS description,
se_albums.album_cover AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_albums,
se_users,
se_levels,
se_media
WHERE
se_media.approved=1 AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
se_albums.album_cover=se_media.media_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_albums.album_title, se_albums.album_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_albums.album_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_albums.album_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)";
}
// GET TOTAL RESULTS
$total_albums = $database->database_num_rows($database->database_query($album_query." LIMIT 201"));
// IF NOT TOTAL ONLY
if($t == "" || $t == "album")
{
// MAKE ALBUM PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page+1;
// SEARCH ALBUMS
$albums = $database->database_query($album_query." ORDER BY album_id DESC LIMIT $start, $limit");
while($album_info = $database->database_fetch_assoc($albums)) {
// CREATE AN OBJECT FOR USER
$profile = new se_user();
$profile->user_info['user_id'] = $album_info['user_id'];
$profile->user_info['user_username'] = $album_info['user_username'];
$profile->user_info['user_fname'] = $album_info['user_fname'];
$profile->user_info['user_lname'] = $album_info['user_lname'];
$profile->user_info['user_photo'] = $album_info['user_photo'];
$profile->user_displayname();
// RESULT IS A MEDIA
if($album_info["sub_type"] == 1) {
$text="Photo: ";
$result_url = $url->url_create('album_file', $album_info['user_username'], $album_info['album_id'], $album_info['media_id']);
$result_name = 1000119;
$result_desc = 1000121;
// RESULT IS AN ALBUM
} else {
$text="Album: ";
$result_url = $url->url_create('album', $album_info['user_username'], $album_info['album_id']);
$result_name = 1000120;
$result_desc = 1000122;
}
// SET THUMBNAIL, IF AVAILABLE
switch($album_info['media_ext']) {
case "jpeg": case "jpg": case "gif": case "png": case "bmp": case "JPEG": case "JPG": case "GIF": case "PNG": case "BMP":
//$thumb_path = IMAGECDN1. str_replace("./", "", $url->url_userdir($album_info['user_id']).$album_info['user_photo']);
$thumb_path = IMAGECDN1. str_replace("./", "", $url->url_userdir($album_info['user_id']).$album_info['media_id']."_thumb.".$album_info['media_ext']);
break;
case "mp3": case "mp4": case "wav":
$thumb_path = "./images/icons/audio_big.gif";
break;
case "mpeg": case "mpg": case "mpa": case "avi": case "swf": case "mov": case "ram": case "rm":
$thumb_path = "./images/icons/video_big.gif";
break;
default:
$thumb_path = "./images/icons/file_big.gif";
}
//if(!file_exists($thumb_path)) { $thumb_path = "./images/icons/file_big.gif"; }
// IF NO TITLE
if($album_info['title'] == "") { SE_Language::_preload(589); SE_Language::load(); $album_info['title'] = SE_Language::_get(589); }
// IF DESCRIPTION IS LONG
if(strlen($album_info['description']) > 150) { $album_info['description'] = substr($album_info['description'], 0, 147)."..."; }
$results[] = Array('result_url' => $result_url,
'result_icon' => $thumb_path,
'result_name' => $result_name,
'result_name_1' => $text.$album_info['title'],
'time' => $album_info['album_datecreated'],
'result_desc' => $result_desc,
'result_desc_1' => $url->url_create('profile', $album_info['user_username']),
'result_desc_2' => $profile->user_displayname,
'result_desc_3' => $album_info['description']);
}
// SET TOTAL RESULTS
$total_results = $total_albums;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(1000118, 1000119, 1000120, 1000121, 1000122);
if($total_albums > 200) { $total_albums = "200+"; }
$search_objects[] = Array('search_type' => 'album',
'search_lang' => 1000118,
'search_total' => $total_albums);
}
function search_album_new() {
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results, $type;
// CONSTRUCT QUERY
if($type==1){
$album_query = "
(
SELECT
'1' AS sub_type,
se_media.media_album_id AS album_id,
se_media.media_title AS title,
se_albums.album_datecreated,
se_media.media_desc AS description,
se_media.media_id AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_media,
se_albums,
se_users,
se_levels
WHERE
se_media.approved=1 AND
se_media.media_album_id=se_albums.album_id AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_media.media_title, se_media.media_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_media.media_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_media.media_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)
";
}elseif($type==2){
$album_query = "
(
SELECT
'2' AS sub_type,
se_albums.album_id AS album_id,
se_albums.album_title AS title,
se_albums.album_datecreated,
se_albums.album_desc AS description,
se_albums.album_cover AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_albums,
se_users,
se_levels,
se_media
WHERE
se_media.approved=1 AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
se_albums.album_cover=se_media.media_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_albums.album_title, se_albums.album_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_albums.album_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_albums.album_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)";
}
else{
$album_query = "
(
SELECT
'1' AS sub_type,
se_media.media_album_id AS album_id,
se_media.media_title AS title,
se_albums.album_datecreated,
se_media.media_desc AS description,
se_media.media_id AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_media,
se_albums,
se_users,
se_levels
WHERE
se_media.approved=1 AND
se_media.media_album_id=se_albums.album_id AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_media.media_title, se_media.media_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_media.media_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_media.media_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)
UNION ALL
(
SELECT
'2' AS sub_type,
se_albums.album_id AS album_id,
se_albums.album_title AS title,
se_albums.album_datecreated,
se_albums.album_desc AS description,
se_albums.album_cover AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_albums,
se_users,
se_levels,
se_media
WHERE
se_media.approved=1 AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
se_albums.album_cover=se_media.media_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_albums.album_title, se_albums.album_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_albums.album_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_albums.album_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)";
}
// GET TOTAL RESULTS
$total_albums = $database->database_num_rows($database->database_query($album_query." LIMIT 201"));
// IF NOT TOTAL ONLY
if($t == "" || $t == "album")
{
// MAKE ALBUM PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page+1;
// SEARCH ALBUMS
$albums = $database->database_query($album_query." ORDER BY album_id DESC LIMIT $start, $limit");
while($album_info = $database->database_fetch_assoc($albums)) {
// CREATE AN OBJECT FOR USER
$profile = new se_user();
$profile->user_info['user_id'] = $album_info['user_id'];
$profile->user_info['user_username'] = $album_info['user_username'];
$profile->user_info['user_fname'] = $album_info['user_fname'];
$profile->user_info['user_lname'] = $album_info['user_lname'];
$profile->user_info['user_photo'] = $album_info['user_photo'];
$profile->user_displayname();
// RESULT IS A MEDIA
if($album_info["sub_type"] == 1) {
$text="Photo: ";
$result_url = $url->url_create('album_file', $album_info['user_username'], $album_info['album_id'], $album_info['media_id']);
$result_name = 1000119;
$result_desc = 1000121;
// RESULT IS AN ALBUM
} else {
$text="Album: ";
$result_url = $url->url_create('album', $album_info['user_username'], $album_info['album_id']);
$result_name = 1000120;
$result_desc = 1000122;
}
// SET THUMBNAIL, IF AVAILABLE
switch($album_info['media_ext']) {
case "jpeg": case "jpg": case "gif": case "png": case "bmp": case "JPEG": case "JPG": case "GIF": case "PNG": case "BMP":
//$thumb_path = IMAGECDN1. str_replace("./", "", $url->url_userdir($album_info['user_id']).$album_info['user_photo']);
$thumb_path = IMAGECDN1. str_replace("./", "", $url->url_userdir($album_info['user_id']).$album_info['media_id']."_thumb.".$album_info['media_ext']);
break;
case "mp3": case "mp4": case "wav":
$thumb_path = "./images/icons/audio_big.gif";
break;
case "mpeg": case "mpg": case "mpa": case "avi": case "swf": case "mov": case "ram": case "rm":
$thumb_path = "./images/icons/video_big.gif";
break;
default:
$thumb_path = "./images/icons/file_big.gif";
}
//if(!file_exists($thumb_path)) { $thumb_path = "./images/icons/file_big.gif"; }
// IF NO TITLE
if($album_info['title'] == "") { SE_Language::_preload(589); SE_Language::load(); $album_info['title'] = SE_Language::_get(589); }
// IF DESCRIPTION IS LONG
if(strlen($album_info['description']) > 150) { $album_info['description'] = substr($album_info['description'], 0, 147)."..."; }
$results[] = Array('result_url' => $result_url,
'result_icon' => $thumb_path,
'result_name' => $result_name,
'result_name_1' => $text.$album_info['title'],
'time' => $album_info['album_datecreated'],
'result_desc' => $result_desc,
'result_desc_1' => $url->url_create('profile', $album_info['user_username']),
'result_desc_2' => $profile->user_displayname,
'result_desc_3' => $album_info['description']);
}
// SET TOTAL RESULTS
$total_results = $total_albums;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(1000118, 1000119, 1000120, 1000121, 1000122);
if($total_albums > 200) { $total_albums = "200+"; }
$search_objects[] = Array('search_type' => 'album',
'search_lang' => 1000118,
'search_total' => $total_albums);
} // END search_album() FUNCTION
// THIS FUNCTION IS RUN DURING THE SEARCH PROCESS TO SEARCH THROUGH ALBUMS AND MEDIA
// INPUT:
// OUTPUT:
function search_album() {
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results;
// CONSTRUCT QUERY
$album_query = "
(
SELECT
'1' AS sub_type,
se_media.media_album_id AS album_id,
se_media.media_title AS title,
se_albums.album_datecreated,
se_media.media_desc AS description,
se_media.media_id AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_media,
se_albums,
se_users,
se_levels
WHERE
se_media.approved=1 AND
se_media.media_album_id=se_albums.album_id AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_media.media_title, se_media.media_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_media.media_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_media.media_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)
UNION ALL
(
SELECT
'2' AS sub_type,
se_albums.album_id AS album_id,
se_albums.album_datecreated,
se_albums.album_title AS title,
se_albums.album_desc AS description,
se_albums.album_cover AS media_id,
se_media.media_ext AS media_ext,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_albums,
se_users,
se_levels,
se_media
WHERE
se_media.approved=1 AND
se_albums.album_user_id=se_users.user_id AND
se_users.user_enabled=1 AND
se_users.user_level_id=se_levels.level_id AND
se_albums.album_cover=se_media.media_id AND
(
se_albums.album_search='1' OR
se_levels.level_album_search='0'
)
AND ( MATCH(se_albums.album_title, se_albums.album_desc) AGAINST('".$database->database_real_escape_string($search_text)."') )
AND
(
se_albums.album_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_albums.album_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
)
)";
// GET TOTAL RESULTS
$total_albums = $database->database_num_rows($database->database_query($album_query." LIMIT 201"));
// IF NOT TOTAL ONLY
if($t == "album")
{
// MAKE ALBUM PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page+1;
// SEARCH ALBUMS
$albums = $database->database_query($album_query." ORDER BY album_id DESC LIMIT $start, $limit");
while($album_info = $database->database_fetch_assoc($albums)) {
// CREATE AN OBJECT FOR USER
$profile = new se_user();
$profile->user_info['user_id'] = $album_info['user_id'];
$profile->user_info['user_username'] = $album_info['user_username'];
$profile->user_info['user_fname'] = $album_info['user_fname'];
$profile->user_info['user_lname'] = $album_info['user_lname'];
$profile->user_info['user_photo'] = $album_info['user_photo'];
$profile->user_displayname();
// RESULT IS A MEDIA
if($album_info["sub_type"] == 1) {
$result_url = $url->url_create('album_file', $album_info['user_username'], $album_info['album_id'], $album_info['media_id']);
$result_name = 1000119;
$result_desc = 1000121;
// RESULT IS AN ALBUM
} else {
$result_url = $url->url_create('album', $album_info['user_username'], $album_info['album_id']);
$result_name = 1000120;
$result_desc = 1000122;
}
// SET THUMBNAIL, IF AVAILABLE
switch($album_info['media_ext']) {
case "jpeg": case "jpg": case "gif": case "png": case "bmp": case "JPEG": case "JPG": case "GIF": case "PNG": case "BMP":
$thumb_path = IMAGECDN1. str_replace("./", "", $url->url_userdir($album_info['user_id']).$album_info['user_photo']);
break;
case "mp3": case "mp4": case "wav":
$thumb_path = "./images/icons/audio_big.gif";
break;
case "mpeg": case "mpg": case "mpa": case "avi": case "swf": case "mov": case "ram": case "rm":
$thumb_path = "./images/icons/video_big.gif";
break;
default:
$thumb_path = "./images/icons/file_big.gif";
}
//if(!file_exists($thumb_path)) { $thumb_path = "./images/icons/file_big.gif"; }
// IF NO TITLE
if($album_info['title'] == "") { SE_Language::_preload(589); SE_Language::load(); $album_info['title'] = SE_Language::_get(589); }
// IF DESCRIPTION IS LONG
if(strlen($album_info['description']) > 150) { $album_info['description'] = substr($album_info['description'], 0, 147)."..."; }
$results[] = Array('result_url' => $result_url,
'result_icon' => $thumb_path,
'result_name' => $result_name,
'result_name_1' => $album_info['title'],
'time' => $album_info['album_datecreated'],
'result_desc' => $result_desc,
'result_desc_1' => $url->url_create('profile', $album_info['user_username']),
'result_desc_2' => $profile->user_displayname,
'result_desc_3' => $album_info['description']);
}
// SET TOTAL RESULTS
$total_results = $total_albums;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(1000118, 1000119, 1000120, 1000121, 1000122);
if($total_albums > 200) { $total_albums = "200+"; }
$search_objects[] = Array('search_type' => 'album',
'search_lang' => 1000118,
'search_total' => $total_albums);
} // END search_album() FUNCTION
// THIS FUNCTION IS RUN WHEN RETRIEVING PHOTOS OF A USER
// INPUT:
// OUTPUT:
function mediatag_album() {
global $photo_query, $tag_query, $owner, $user;
if($photo_query != "") { $photo_query .= " UNION ALL "; }
$photo_query .= "(SELECT 'media' AS type,
'media_id' AS type_id,
'' AS type_prefix,
mediatag_media_id AS media_id,
mediatag_date AS mediatag_date,
CONCAT('album.php?user=', user_username, '&album_id=[media_parent_id]') AS media_parent_url,
media_album_id AS media_parent_id,
album_title AS media_parent_title,
album_user_id AS owner_user_id,
user_id AS user_id,
user_username AS user_username,
user_fname AS user_fname,
user_lname AS user_lname,
CONCAT('./uploads_user/', user_id+999-((user_id-1)%1000), '/', user_id, '/') AS media_dir,
media_date AS media_date,
media_title AS media_title,
media_desc AS media_desc,
media_ext AS media_ext,
media_filesize AS media_filesize,
CASE
WHEN ((se_albums.album_tag & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_albums.album_tag & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_albums.album_tag & @SE_PRIVACY_SELF) AND se_albums.album_user_id='{$user->user_info['user_id']}')
THEN TRUE
WHEN ((se_albums.album_tag & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_albums.album_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
"./*WHEN ((se_albums.album_tag & @SE_PRIVACY_SUBNET) AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}')
THEN TRUE*/"
WHEN ((se_albums.album_tag & @SE_PRIVACY_FRIEND2)"./* AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}'*/" AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_albums.album_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE
ELSE FALSE
END
AS allowed_to_tag,
CASE
WHEN ((se_albums.album_comments & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_albums.album_comments & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_albums.album_comments & @SE_PRIVACY_SELF) AND se_albums.album_user_id='{$user->user_info['user_id']}')
THEN TRUE
WHEN ((se_albums.album_comments & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_albums.album_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
"./*WHEN ((se_albums.album_comments & @SE_PRIVACY_SUBNET) AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}')
THEN TRUE*/"
WHEN ((se_albums.album_comments & @SE_PRIVACY_FRIEND2)"./* AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}'*/" AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_albums.album_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE
ELSE FALSE
END
AS allowed_to_comment
FROM se_mediatags
LEFT JOIN se_media
ON se_mediatags.mediatag_media_id=se_media.media_id
LEFT JOIN se_albums
ON se_media.media_album_id=se_albums.album_id
LEFT JOIN se_users
ON se_albums.album_user_id=se_users.user_id
WHERE se_mediatags.mediatag_user_id='{$owner->user_info['user_id']}'
)";
$tag_query['media'] = "SELECT se_mediatags.*, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_mediatags LEFT JOIN se_users ON se_mediatags.mediatag_user_id=se_users.user_id WHERE mediatag_media_id='[media_id]' ORDER BY mediatag_id ASC";
} // END mediatag_album() FUNCTION
// THIS FUNCTION IS RUN WHEN A USER IS DELETED
// INPUT: $user_id REPRESENTING THE USER ID OF THE USER BEING DELETED
// OUTPUT:
function deleteuser_album($user_id) {
global $database, $user;
$database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user_id}', time='".time()."', action='deleteuser_album function has been run'");
$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
]);
$query = $database->database_query("SELECT album_id FROM se_media WHERE media_album_user_id='".$user_id."'");
while($row=$database->database_fetch_assoc($query)){
$media = $database->database_query("SELECT media_id, media_ext FROM se_media WHERE media_album_id='".$database->database_real_escape_string($row["album_id"])."'");
// LOOP OVER MEDIA
while($media_info = $database->database_fetch_assoc($media)) {
$media_path = $url->url_userdir($user_id).$media_info["media_id"].".".$media_info["media_ext"];
if(file_exists($media_path)) { unlink($media_path); }
$thumb_path = $url->url_userdir($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("./", "",str_replace("../", "",$media_path)),
));
}catch (Exception $e) {}
try {
$client->deleteObject(array(
'Bucket'=>'bateworld',
'Key' => str_replace("./", "",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 their album'");
}
}
// DELETE ALBUMS, MEDIA, AND COMMENTS
$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_user_id='{$user_id}'");
// DELETE TAGS OF USER
$database->database_query("UPDATE se_mediatags SET mediatag_user_id='0' WHERE mediatag_user_id='{$user_id}'");
// DELETE STYLE
//$database->database_query("DELETE FROM se_albumstyles WHERE albumstyle_user_id='{$user_id}'");
}
// END deleteuser_album() FUNCTION
// THIS FUNCTION IS RUN WHEN GENERATING SITE STATISTICS
// INPUT:
// OUTPUT:
function site_statistics_album(&$args)
{
global $database;
$statistics =& $args['statistics'];
// NOTE: CACHING WILL BE HANDLED BY THE FUNCTION THAT CALLS THIS
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(album_id) AS total FROM se_albums"));
$statistics['albums'] = array(
'title' => 1000174,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
/*
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(media_id) AS total FROM se_media"));
$statistics['media'] = array(
'title' => 1000175,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(mediacomment_id) AS total FROM se_mediacomments"));
$statistics['mediacomments'] = array(
'title' => 1000176,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(mediatag_id) AS total FROM se_mediatags"));
$statistics['mediatags'] = array(
'title' => 1000177,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
*/
}
// END site_statistics_album() FUNCTION
?>