user_info['user_level_id'] != 2&&$user->user_info['user_level_id'] != 7) :
header("Location: /premium.php?premiumonly=1");
exit;
endif;
function general()
{ global $user, $url, $database;
if($_GET["show"]==""){$_GET["show"]="videos";}
?>
My Favorites
if($user->user_info["user_id"]>0){
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
?> Back to All Favorites
if($_GET["show"]=="videos")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='video'"),0);
$query=$database->database_query("SELECT * FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND `type`='video' AND owner=user_id");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
Title: Favorites
Type: HTML
Description: Favorited Videos
database_fetch_array($query))
{
$user1=new SEUser(Array($row["user_id"], $row["user_username"]));
$owner=new SEUser(Array($row["owner"]));
$query1=$database->database_query("SELECT * FROM se_videos WHERE video_id='".$row["objectid"]."' AND video_user_id='{$owner->user_info['user_id']}' AND se_videos.video_is_converted='1' AND
(CASE
WHEN se_videos.video_user_id='{$user->user_info['user_id']}'
THEN TRUE
WHEN ((se_videos.video_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_videos.video_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_videos.video_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_videos.video_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
"/*THEN TRUE
WHEN ((se_videos.video_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_videos.video_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))*/
." THEN TRUE
WHEN ((se_videos.video_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id 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_videos.video_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' "/*AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}'*/." LIMIT 1))
THEN TRUE
ELSE FALSE
END) LIMIT 1");
$row1=$database->database_fetch_array($query1);
$video = new se_video($row1["video_user_id"], $row1["video_id"]);
?>
}
elseif($_GET["show"]=="groupvideos")
{
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupvideo'");
?>
Title: Favorites
Type: HTML
Description: Favorited Group Videos
database_fetch_array($query))
{
$owner=new SEUser(Array($row["owner"]));
$group = new se_group($user->user_info['user_id'], $row["objectid"]);
$owner->user_directory=$url->url_userdir($owner->user_info['user_id']);
$query1=$database->database_query("SELECT * FROM se_group_videos WHERE video_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="groupvideo")
{
$owner=new SEUser(Array($row["owner"]));
$group = new se_group($user->user_info['user_id'], $row["objectid"]);
$owner->user_directory=$url->url_userdir($owner->user_info['user_id']);
$query1=$database->database_query("SELECT * FROM se_group_videos WHERE video_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>