global $ses;
$whoisloggedin = $ses["user_id"];
if($whoisloggedin == '1') { ?>
<%include:box_admin%>
} if ($whoisloggedin) {?>
<%include:box_loggedin%>
} ?>
include 'tower.php'; ?><%include:box_networksites%> <%include:box_linktous%> |
include 'leaderboard.php'; ?>
if (!$ses[user_id]) { ?>
You must be logged in to add files to your File Cart. Registration is completely free.
Click here to login
Click here to register
} else {
if($add_fav)
{
$addsql = "INSERT INTO inl_fav (user_id, link_id) values ($ses[user_id], $add_fav)";
$addresult = mysql_query($addsql);
if (!$addresult)
{
die("SQL result failed - File Not Added");
}
else
{
echo "
File successfully added to your cart ";
}
}
if($remove_fav)
{
$sql = "DELETE FROM inl_fav WHERE link_id = '$remove_fav' and user_id = '".$ses["user_id"]."'";
$result = mysql_query($sql);
if (!$result)
{
die("SQL result failed - Favorite Not Removed");
}
else
{
echo "
File successfully removed from your cart ";
}
}
$howmany = 50;
$sqlquery = "SELECT inl_links.link_id, link_name, link_pick, link_desc, link_date, link_hits, link_rating, link_votes, link_numrevs, link_image, cust1, cust2, cust3, cust4, cust5, cust6, cust7, link_user, link_url, cat_id, link_vis, user_name, email, link_modified, link_expires, link_views FROM inl_fav, inl_links LEFT JOIN inl_lc ON inl_lc.link_id = inl_links.link_id LEFT JOIN inl_custom ON inl_links.link_cust = inl_custom.cust_id LEFT JOIN inl_users ON inl_links.link_user = inl_users.user_id WHERE inl_fav.user_id='".$ses["user_id"]."' AND inl_fav.link_id=inl_links.link_id group by link_name order by link_hits desc limit $howmany";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
$count = 1;
if ($number < 1) {
echo "You currently don't have any files in your cart, you can add a favorite by clicking \"Add to Cart\" on a product details page, such as this one. ";
}
else { ?>
| |
Product |
License |
Downloads |
 |
 |
 |
 |
while ($number > $i) {
$id = mysql_result($result,$i,"link_id");
$pulledcat = mysql_result($result,$i,"cat_id");
$product = mysql_result($result,$i,"link_name");
$desc = mysql_result($result,$i,"link_desc");
$license = mysql_result($result,$i,"cust1");
$downloads = mysql_result($result,$i,"link_hits");
$downloads = number_format($downloads);
$version = mysql_result($result,$i,"cust7");
$fproduct = ereg_replace(' ','_',$product);
$fproduct = ereg_replace('\'','',$fproduct);
$count = $i + 1;
?>
| echo ++$start; ?>. |
=$product?> =$version?> |
=$license?> |
=$downloads?> |
 |
| =$desc?> |
REMOVE FROM CART |
$i++;
}?>
}}?>
|