user_info['user_level_id'] != 2) :
header("Location: /premium.php?premiumonly=1");
exit;
endif;
function general()
{ global $user, $url, $database;
if($_POST["deletesubmit"]=="Delete Selected"){
foreach($_POST["delete"] as $del){
$database->database_query("DELETE FROM favorites WHERE id='".$database->database_real_escape_string($del)."' AND user='".$user->user_info["user_id"]."'");
}
}
?>
if($user->user_info["user_id"]>0){
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
if($_GET["show"]!="")
{
?>
Back to All Favorites
if($_GET["show"]=="profiles")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='profile'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites LEFT JOIN se_users ON favorites.owner=se_users.user_id WHERE user='".$user->user_info["user_id"]."' AND `type`='profile' LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_GET["show"]=="albums")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='album'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND `type`='album' AND owner=user_id LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_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);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND `type`='video' AND owner=user_id LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_GET["show"]=="pictures")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='picture'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND `type`='picture' AND owner=user_id LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_GET["show"]=="groups")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='group'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND `type`='group' AND user=user_id LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_GET["show"]=="events")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='event'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND `type`='event' AND owner=user_id LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_GET["show"]=="blogs")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='blog'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_blogentries WHERE user='".$user->user_info["user_id"]."' AND `type`='blog' AND blogentry_id=objectid LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_GET["show"]=="posts")
{
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='post'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_forumtopics WHERE user='".$user->user_info["user_id"]."' AND `type`='post' AND forumtopic_id=objectid LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
elseif($_GET["show"]=="groupphotos"){
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupphoto'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupphoto' LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
if($page_vars[2] > 1){?>
database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupvideo'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupvideo' LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='poll'"),0);
$groups_per_page = 40;
$page_vars = make_page($total_groups, $groups_per_page, $p);
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
{
if(($page_vars[1]+10)==$x)
{break;}
$for[$y]=$x;
$y++;
}
$query=$database->database_query("SELECT * FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND `type`='poll' AND owner=user_id LIMIT ".$page_vars[0].", {$groups_per_page}");
if($total_groups==0){echo "You have no favorites in this category";?> }
?>
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}?>
}
if($page_vars[2] > 1){?>
if($p != 1){?>
« ‹ }else{?>
« ‹ }?>
| foreach ($for as $from){?>
=$from?>
}?> |
if($p != $page_vars[2]){?>
› » }else{?>
› » }?>
if (($page_vars[0]+1) == ($page_vars[0]+$database->database_num_rows($query))){?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}else{?>
viewing results =$page_vars[0]+1?>-=$page_vars[0]+$database->database_num_rows($query)?> of =$total_groups?>
}?>
}
}
else{?>
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='profile' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="profile")
{
$owner=new SEUser(Array($row["owner"]));
?>
}
}?>
View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='video' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="video")
{
$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']}' LIMIT 1");
$row1=$database->database_fetch_array($query1);
$video = new se_video($row1["video_user_id"], $row1["video_id"]);
?>
}
}?>
View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='album' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="album")
{
$owner=new SEUser(Array($row["owner"]));
$album = new se_album($owner->user_info['user_id']);
$owner->user_directory=$url->url_userdir($owner->user_info['user_id']);
$query1=$database->database_query("SELECT * FROM se_albums WHERE album_id='".$row["objectid"]."' AND album_user_id='{$owner->user_info['user_id']}'");
$row1=$database->database_fetch_array($query1);
?>
}}?> View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='picture' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="picture")
{
$owner=new SEUser(Array($row["owner"]));
$album = new se_album($owner->user_info['user_id']);
$owner->user_directory=$url->url_userdir($owner->user_info['user_id']);
$query1=$database->database_query("SELECT * FROM se_media WHERE media_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
}
}?> View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='group' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="group")
{
$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_media WHERE media_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
}
}?> View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupphoto' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="groupphoto")
{
$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_groupmedia WHERE groupmedia_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
}
}?> View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupvideo' LIMIT 4");
?>
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);
?>
}
}?> View All
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='event' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="event")
{
$owner=new SEUser(Array($row["owner"]));
$event = new se_event($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_media WHERE media_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
}
}?> View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='blog' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="blog")
{
$owner=new SEUser(Array($row["owner"]));
$blog = new se_blog($owner->user_info['user_id'], $row["objectid"]);
$owner->user_directory=$url->url_userdir($owner->user_info['user_id']);
$query1=$database->database_query("SELECT * FROM se_blogentries WHERE blogentry_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
}
}?> View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='poll' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="poll")
{$owner=new SEUser(Array($row["owner"]));
$blog = new se_poll($owner->user_info['user_id'], $row["objectid"]);
$owner->user_directory=$url->url_userdir($owner->user_info['user_id']);
$query1=$database->database_query("SELECT * FROM se_polls WHERE poll_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
}
}?> View All
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='post' LIMIT 4");
?>
if($database->database_num_rows($query)==0){?>You have no favorites in this category }
while($row=$database->database_fetch_array($query))
{
if($row["type"]=="post")
{
$query1=$database->database_query("SELECT * FROM se_forumtopics WHERE forumtopic_id='".$row["objectid"]."'");
$row1=$database->database_fetch_array($query1);
?>
}
}?> View All
?>
|
}
}?>
}
include("footer.php");
?>