1035 lines
51 KiB
PHP
1035 lines
51 KiB
PHP
<?php
|
|
|
|
/* $Id: index.php 8 2009-01-11 06:02:53Z john $ */
|
|
$page="general";
|
|
include("header.php");
|
|
|
|
if ($user->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($_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"]."'");
|
|
}
|
|
|
|
}
|
|
?>
|
|
<div class="favediv">
|
|
<div class="page_header"><span class="faveheader">My Favorites</span></div>
|
|
|
|
<?
|
|
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"]!="")
|
|
{
|
|
?><br />
|
|
<a href="favorites.php">Back to All Favorites</a><br /><br />
|
|
<?
|
|
|
|
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){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><?
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
$user1=new SEUser(Array($row["user_id"], $row["user_username"]));
|
|
|
|
?>
|
|
<div class='favoritesummary'>
|
|
<a href='profile.php?user=<?=$row["user_username"]?>'>
|
|
|
|
|
|
|
|
<?php $profilepicture=$user1->user_photo("./images/nophoto.png");
|
|
echo $user1->userprofiledot($profilepicture, "100px", "100px");?>
|
|
|
|
<?=$user1->user_displayname_short?></a>
|
|
<? if($user1->is_online==1){?><div style='margin-top: 3px;'><!--<img src='./images/icons/online16.gif' border='0' class='icon2'>-->Online</div> <? }?><br />
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" /> </div>
|
|
<?
|
|
}
|
|
|
|
?><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
|
|
|
|
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";?><? }
|
|
?>
|
|
<?php
|
|
|
|
if($page_vars[2] > 1){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><?
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
$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);
|
|
|
|
?><div class="favoritesummary"><a href="album.php?album_id=<?=$row["objectid"]?>&user=<?=$owner->user_info["user_username"]?>">
|
|
<img src="<? if(file_exists($owner->user_directory.$row1["album_cover"].".".$database->database_result($database->database_query("SELECT media_ext FROM se_media WHERE media_id='".$row1["album_cover"]."'"),0))&&$database->database_result($database->database_query("SELECT media_ext FROM se_media WHERE media_id='".$row1["album_cover"]."'"),0)!=""){
|
|
echo $owner->user_directory.$row1["album_cover"].".".$database->database_result($database->database_query("SELECT media_ext FROM se_media WHERE media_id='".$row1["album_cover"]."'"),0);
|
|
}else{echo "/images/nophoto.png";}?>" width="100px" height="100px" /><br />
|
|
<?=$owner->user_info["user_username"]?></a><br />
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" />
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
?><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
elseif($_GET["show"]=="searches")
|
|
{
|
|
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='browse'"),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`='browse' LIMIT ".$page_vars[0].", {$groups_per_page}");
|
|
if($total_groups==0){echo "You have no favorites in this category";?><? }
|
|
?>
|
|
<?php
|
|
|
|
if($page_vars[2] > 1){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><?
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
|
|
|
|
?><div class="col-sm-10" style="margin-bottom:10px;"><a href="<?php echo $row["urlstring"];?>"><?php echo $row["urlstring"];?>
|
|
</a></div><div class="col-sm-1">
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" /></div>
|
|
<div class="clearfix clear"></div>
|
|
<?
|
|
|
|
}
|
|
|
|
?><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
|
|
elseif($_GET["show"]=="videos")
|
|
{?><a href="favorites-videos.php?show=videos">Play All</a><br><br><?php
|
|
$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){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><?
|
|
while($row=$database->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']}' LIMIT 1");
|
|
$row1=$database->database_fetch_array($query1);
|
|
$video = new se_video($row1["video_user_id"], $row1["video_id"]);
|
|
?><div class="favoritesummary"><a href="video.php?video_id=<?=$row["objectid"]?>&user=<?=$owner->user_info["user_username"]?>">
|
|
<img src="<?
|
|
|
|
if(file_exists(".".$video->video_dir().$row1["video_id"]."_thumb.jpg")){
|
|
echo $video->video_dir().$row1["video_id"]."_thumb.jpg";
|
|
}else{echo "./images/nophoto.gif";}?>" width="100px" height="100px" /><br />
|
|
<?=$owner->user_info["user_username"]?></a><br />
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" /></div>
|
|
|
|
<?
|
|
}
|
|
|
|
?><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
|
|
|
|
elseif($_GET["show"]=="pictures")
|
|
{?>
|
|
<a href="favorites-slideshow.php?show=pictures">View slideshow</a><br><br>
|
|
|
|
<?php
|
|
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites, se_users WHERE user='".$user->user_info["user_id"]."' AND (`type`='picture' OR `type`='photo') AND owner=user_id"),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' OR `type`='photo') 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){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><?
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
|
|
|
|
$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);
|
|
|
|
?><div class="favoritesummary"><a href="album_file.php?media_id=<?=$row["objectid"]?>&user=<?=$owner->user_info["user_username"]?>">
|
|
<img src="<? if(file_exists($owner->user_directory.$row1["media_id"].".".$row1["media_ext"])&&$row1["media_ext"]!=""){
|
|
echo $owner->user_directory.$row1["media_id"].".".$row1["media_ext"];
|
|
}else{echo "/images/nophoto.png";}?>" width="100px" height="100px" /><br />
|
|
<?=$owner->user_info["user_username"]?></a><br />
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" />
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
?><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
|
|
|
|
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){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><?
|
|
while($row=$database->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_media WHERE media_id='".$row["objectid"]."'");
|
|
$row1=$database->database_fetch_array($query1);
|
|
|
|
?><div class="favoritesummary"><a href="group.php?group_id=<?=$row["objectid"]?>">
|
|
<img src="<?=$group->group_photo("./images/nophoto.png")?>" width="100px" height="100px" /><br />
|
|
<?=$group->group_info["group_title"]?></a><br />
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" />
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
?><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
|
|
|
|
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){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><?
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
|
|
$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);
|
|
|
|
?><div class="favoritesummary"><a href="event.php?event_id=<?=$row["objectid"]?>">
|
|
<img src="<?=$event->event_photo("./images/nophoto.png")?>" width="100px" height="100px" /><br />
|
|
<?=$event->event_info["event_title"]?></a><br />
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" />
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
?><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
|
|
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";?><? }
|
|
?><br />
|
|
<? if($page_vars[2] > 1){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><table width="100%"><tr><?
|
|
$x=1;
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
$user1=new SEUser(Array($row["user_id"], $row["user_username"]));
|
|
|
|
?><td class="deletecheck"><input type="checkbox" name="delete[]" value="<?=$row["id"]?>" /></td><td><div class=""><a href="blog.php?user=<?=$user1->user_info["user_username"]?>&blogentry_id=<?=$row["objectid"]?>">
|
|
|
|
<?=strtoupper($row["blogentry_title"])?></a></div></td>
|
|
<?
|
|
if($x%2==0){?></tr><tr><? }
|
|
$x++;
|
|
}
|
|
|
|
?></tr></table><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
|
|
|
|
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";?><? }
|
|
?><br />
|
|
<? if($page_vars[2] > 1){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><table width="100%"><tr><?
|
|
$x=1;
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
$user1=new SEUser(Array($row["user_id"], $row["user_username"]));
|
|
|
|
?>
|
|
<td class="deletecheck"><input type="checkbox" name="delete[]" value="<?=$row["id"]?>" /></td><td><div class=""><a href="forum_topic.php?forum_id=<?=$row["owner"]?>&topic_id=<?=$row["objectid"]?>">
|
|
|
|
<?=strtoupper($row["forumtopic_subject"])?></a></div></td>
|
|
<?
|
|
if($x%2==0){?></tr><tr><? }
|
|
$x++;
|
|
}
|
|
|
|
?></tr></table><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
elseif($_GET["show"]=="groupphotos"){
|
|
?>
|
|
<a href="favorites-slideshow.php?show=groupphotos">View slideshow</a><br>
|
|
<br>
|
|
<?php
|
|
$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){?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post">
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?>
|
|
|
|
<?
|
|
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);
|
|
|
|
?><div class="favoritesummary"><a href="group_album_file.php?group_id=<?=$row["owner"]?>&groupmedia_id=<?=$row["objectid"]?>">
|
|
<img src="<? echo $group->group_dir($row["owner"]).$row1["groupmedia_id"].".".$row1["groupmedia_ext"];?>" width="100px" height="100px" /><br />
|
|
<?=$row1["groupmedia_title"]?></a><br /><input type="checkbox" name="delete[]" value="<?=$row["id"]?>" />
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
}
|
|
?>
|
|
<div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form>
|
|
<?php
|
|
}
|
|
elseif($_GET["show"]=="groupvideos")
|
|
{
|
|
?><a href="favorites-videos.php?show=groupvideos">Play All</a><br><br><?php
|
|
$total_groups=$database->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";?><? }
|
|
?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post">
|
|
<? if($page_vars[2] > 1){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?>
|
|
<?
|
|
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);
|
|
|
|
?><div class="favoritesummary"><a href="video_group.php?group_id=<?=$row["owner"]?>&video_id=<?=$row["objectid"]?>">
|
|
<img src="<?=$group->group_dir($row["owner"])?>/video_<?php echo $row["objectid"];?>_thumb.jpg" width="100px" height="100px" /><br />
|
|
<?=$group->group_info["video_title"]?></a><br />
|
|
<input type="checkbox" name="delete[]" value="<?=$row["id"]?>" />
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
}?>
|
|
<div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form>
|
|
<?php
|
|
|
|
}
|
|
elseif($_GET["show"]=="polls")
|
|
{?><br /><?
|
|
$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){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div>
|
|
<?
|
|
}?><form action="favorites.php?show=<?=$_GET["show"]?>" method="post"><table width="100%"><tr><?
|
|
$x=1;
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
$user1=new SEUser(Array($row["user_id"], $row["user_username"]));
|
|
|
|
|
|
$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"]."' AND se_polls.approved=1");
|
|
$row1=$database->database_fetch_array($query1);
|
|
|
|
?><td class="deletecheck"><input type="checkbox" name="delete[]" value="<?=$row["id"]?>" /></td><td><div class=""><a href="poll.php?user=<?=$owner->user_info["user_username"]?>&poll_id=<?=$row["objectid"]?>">
|
|
|
|
<?=strtoupper($row1["poll_title"])?></a></div></td><?
|
|
|
|
if($x%2==0){?></tr><tr><? }
|
|
$x++;
|
|
}
|
|
|
|
?></tr></table><div class="clear"></div><br />
|
|
<input type="submit" value="Delete Selected" name="deletesubmit" /></form><?
|
|
}
|
|
if($page_vars[2] > 1){?>
|
|
<div class='browse_pages'>
|
|
<? if($p != 1){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=1'><span class="white arrow">«</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">‹</span></a><? }else{?><font class='disabled'><span class="white arrow">« ‹</span></font><? }?>
|
|
| <? foreach ($for as $from){?>
|
|
<a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$from?>'><?=$from?></a>
|
|
<? }?> |
|
|
<? if($p != $page_vars[2]){?><a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p+1?>'><span class="white arrow">›</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">»</span></a><? }else{?><font class='disabled'><span class="white arrow">› »</span></font><? }?>
|
|
<br /><span style="font-weight:normal;"><? 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?>
|
|
<? }?></span><div class="clear"></div></div><?
|
|
}
|
|
}
|
|
else{?><div class="col-sm-7"><?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='profile' LIMIT 4");
|
|
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=profiles">PROFILES</a></h3><?
|
|
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"]));
|
|
?><div class="favoritesummary"><a href="profile.php?user=<?=$owner->user_info["user_username"]?>">
|
|
|
|
<?php $profilepicture=$owner->user_photo("./images/nophoto.png");
|
|
echo $owner->userprofiledot($profilepicture, "100px", "100px");?><br />
|
|
<?=$owner->user_info["user_username"]?></a></div>
|
|
<?
|
|
}
|
|
|
|
}?><div class="clear"></div><br />
|
|
<a href="favorites.php?show=profiles">View All</a><br /></div><br />
|
|
<?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='video' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=videos">VIDEOS</a></h3><?
|
|
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"]);
|
|
?><div class="favoritesummary"><a href="video.php?video_id=<?=$row["objectid"]?>&user=<?=$owner->user_info["user_username"]?>">
|
|
<img src="<? if(file_exists(".".$video->video_dir().$row1["video_id"]."_thumb.jpg")){
|
|
echo $video->video_dir().$row1["video_id"]."_thumb.jpg";
|
|
}else{echo "./images/nophoto.gif";}?>" width="100px" height="100px" /><br />
|
|
<?=$owner->user_info["user_username"]?></a></div>
|
|
<?
|
|
}
|
|
|
|
}?><div class="clear"></div><br />
|
|
<a href="favorites.php?show=videos">View All</a></div><br />
|
|
<?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='album' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=albums">ALBUMS</a></h3><?
|
|
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);
|
|
|
|
?><div class="favoritesummary"><a href="album.php?album_id=<?=$row["objectid"]?>&user=<?=$owner->user_info["user_username"]?>">
|
|
<img src="<? if(file_exists($owner->user_directory.$row1["album_cover"].".".$database->database_result($database->database_query("SELECT media_ext FROM se_media WHERE media_id='".$row1["album_cover"]."'"),0))&&$database->database_result($database->database_query("SELECT media_ext FROM se_media WHERE media_id='".$row1["album_cover"]."'"),0)!=""){
|
|
echo $owner->user_directory.$row1["album_cover"].".".$database->database_result($database->database_query("SELECT media_ext FROM se_media WHERE media_id='".$row1["album_cover"]."'"),0);
|
|
}else{echo "/images/nophoto.png";}?>" width="100px" height="100px" /><br />
|
|
<?=$owner->user_info["user_username"]?></a>
|
|
</div>
|
|
<?
|
|
|
|
}}?><div class="clear"></div><br /><a href="favorites.php?show=albums">View All</a></div><br /><?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND (`type`='picture' OR `type`='photo') LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=pictures">PICTURES</a></h3><?
|
|
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"||$row["type"]=="photo")
|
|
{
|
|
|
|
|
|
$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);
|
|
|
|
?><div class="favoritesummary"><a href="album_file.php?media_id=<?=$row["objectid"]?>&user=<?=$owner->user_info["user_username"]?>">
|
|
<img src="<? if(file_exists($owner->user_directory.$row1["media_id"].".".$row1["media_ext"])&&$row1["media_ext"]!=""){
|
|
echo $owner->user_directory.$row1["media_id"].".".$row1["media_ext"];
|
|
}else{echo "/images/nophoto.png";}?>" width="100px" height="100px" /><br />
|
|
<?=$owner->user_info["user_username"]?></a>
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=pictures">View All</a></div><br /><?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='group' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=groups">GROUPS</a></h3><?
|
|
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);
|
|
|
|
?><div class="favoritesummary"><a href="group.php?group_id=<?=$row["objectid"]?>">
|
|
<img src="<?=$group->group_photo("./images/nophoto.png")?>" width="100px" height="100px" /><br />
|
|
<?=$group->group_info["group_title"]?></a>
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=groups">View All</a></div>
|
|
|
|
|
|
<?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupphoto' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=groupphotos">GROUP PHOTOS</a></h3><?
|
|
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);
|
|
|
|
?><div class="favoritesummary"><a href="group_album_file.php?group_id=<?=$row["owner"]?>&groupmedia_id=<?=$row["objectid"]?>">
|
|
<img src="<? echo $group->group_dir($row["owner"]).$row1["groupmedia_id"].".".$row1["groupmedia_ext"];?>" width="100px" height="100px" /><br />
|
|
<?=$row1["groupmedia_title"]?></a>
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=groupphotos">View All</a></div>
|
|
|
|
|
|
<?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='groupvideo' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=groupvideos">GROUP VIDEOS</a></h3><?
|
|
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);
|
|
|
|
?><div class="favoritesummary"><a href="video_group.php?group_id=<?=$row["owner"]?>&video_id=<?=$row["objectid"]?>">
|
|
<img src="<?=$group->group_dir($row["owner"])?>/video_<?php echo $row["objectid"];?>_thumb.jpg" width="100px" height="100px" /><br />
|
|
<?=$group->group_info["video_title"]?></a>
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=groupvideos">View All</a></div>
|
|
|
|
</div><div class="col-sm-4">
|
|
<?
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='event' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=events">EVENTS</a></h3><?
|
|
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);
|
|
|
|
?><div class="favoritesummary"><a href="event.php?event_id=<?=$row["objectid"]?>">
|
|
<img src="<?=$event->event_photo("./images/nophoto.png")?>" width="100px" height="100px" /><br />
|
|
<?=$event->event_info["event_title"]?></a>
|
|
</div>
|
|
<?
|
|
|
|
}
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=events">View All</a></div><br />
|
|
|
|
<?
|
|
|
|
|
|
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='blog' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=blogs">BLOGS</a></h3><?
|
|
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);
|
|
|
|
?><div class="favoritecap"><a href="blog.php?user=<?=$owner->user_info["user_username"]?>&blogentry_id=<?=$row["objectid"]?>">
|
|
|
|
<?=strtoupper($row1["blogentry_title"])?></a></div>
|
|
<?
|
|
}
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=blogs">View All</a></div><br /><?
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='poll' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=polls">POLLS</a></h3><?
|
|
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"]."' AND se_polls.approved=1");
|
|
$row1=$database->database_fetch_array($query1);
|
|
|
|
?><div class="favoritecap"><a href="poll.php?user=<?=$owner->user_info["user_username"]?>&poll_id=<?=$row["objectid"]?>">
|
|
|
|
<?=strtoupper($row1["poll_title"])?></a></div><?
|
|
}
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=polls">View All</a></div><br /><?
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='post' LIMIT 4");
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=posts">FORUM POSTS</a></h3><?
|
|
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);
|
|
?><div class="favoritecap"><a href="forum_topic.php?forum_id=<?=$row["owner"]?>&topic_id=<?=$row["objectid"]?>">
|
|
|
|
<?=strtoupper($row1["forumtopic_subject"])?></a></div><?
|
|
}
|
|
|
|
}?><div class="clear"></div><br /><a href="favorites.php?show=posts">View All</a></div><?
|
|
|
|
|
|
?><div><h3 class="favoritetitles"><a href="favorites.php?show=searches">Searches</a></h3><?php
|
|
$total_groups=$database->database_result($database->database_query("SELECT COUNT(*) FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='browse'"),0);
|
|
|
|
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND `type`='browse' LIMIT 4");
|
|
if($total_groups==0){echo "You have no favorites in this category";?><? }
|
|
|
|
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
|
|
|
|
?><div style="margin-bottom:10px; word-break: break-word;"><a href="<?php echo $row["urlstring"];?>"><?php echo substr($row["urlstring"], 0, 50);?>
|
|
</a></div>
|
|
<div class="clearfix clear"></div>
|
|
<?
|
|
|
|
}?>
|
|
<div class="clear"></div><br /><a href="favorites.php?show=searches">View All</a></div><div class="clear"></div><br />
|
|
<?php
|
|
|
|
|
|
?>
|
|
</div><div class="clearfix clear"></div>
|
|
<? }
|
|
}?></div><? }
|
|
|
|
include("footer.php");
|
|
?>
|