Files
Testing/favorites.php

1035 lines
51 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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">&#171;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$p-1?>'><span class="white arrow">&#8249;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#171; &#8249;</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">&#8250;</span></a> <a href='favorites.php?show=<?=$_GET["show"]?>&p=<?=$page_vars[2]?>'><span class="white arrow">&#187;</span></a><? }else{?><font class='disabled'><span class="white arrow">&#8250; &#187;</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"]?>&amp;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"]?>&amp;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"]?>&amp;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"]?>&amp;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"]?>&amp;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"]?>&amp;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"]?>&amp;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");
?>