happylog.php

<?php
/**
 *   http://btdev.net:1337/svn/test/Installer09_Beta
 *   Licence Info: GPL
 *   Copyright (C) 2010 BTDev Installer v.1
 *   A bittorrent tracker source based on TBDev.net/tbsource/bytemonsoon.
 *   Project Leaders: Mindless,putyn.
 **/
require_once(dirname(__FILE__).DIRECTORY_SEPARATOR.'include'.DIRECTORY_SEPARATOR.'bittorrent.php');
require_once(INCL_DIR.'user_functions.php');
require_once(INCL_DIR.'pager_functions.php');
require_once(INCL_DIR.'html_functions.php');
dbconn();
loggedinorreturn();
$lang = array_merge( load_language('global') );
$HTMLOUT='';
$id = (isset($_GET["id"]) ? 0 + $_GET["id"] : "0");
if ($id == "0")
    stderr("Err", "I dont think so!");

$ur = sql_query("SELECT username from users WHERE id=".sqlesc($id)."");
$user = mysql_fetch_array($ur) or stderr("Error", "No user found");

$count = get_row_count("happylog", "WHERE userid=$id ");
$perpage = 30;
$pager = pager($perpage, $count, "happylog.php?id=$id&amp;");

$res = sql_query("SELECT h.userid, h.torrentid, h.date, h.multi , t.name FROM happylog as h LEFT JOIN torrents AS t on t.id=h.torrentid WHERE h.userid=".sqlesc($id)." ORDER BY h.date DESC ".$pager['limit']." ") or sqlerr();

$HTMLOUT .= begin_main_frame();
$HTMLOUT .= begin_frame("Happy hour log for " . htmlspecialchars($user["username"]) . "");

if (mysql_num_rows($res) > 0) {
    $HTMLOUT .= $pager['pagertop'];
    $HTMLOUT .="<table class='main' border='1' cellspacing='0' cellpadding='5'>
    <tr><td class='colhead' style='width:100%'>Torrent Name</td>
    <td class='colhead'>Multiplier</td>
    <td class='colhead' nowrap='nowrap'>Date started</td></tr>";
    while ($arr = mysql_fetch_assoc($res)) {
    $HTMLOUT .="<tr><td><a href='details.php?id=" .htmlspecialchars($arr["torrentid"]). "'>" .htmlspecialchars($arr["name"]) . "</a></td>
    <td>" . $arr["multi"] . "</td>
    <td nowrap='nowrap'>" . get_date($arr["date"], 'LONG',1,0) . "</td></tr>";
    }
    $HTMLOUT .="</table>";
    $HTMLOUT .= $pager['pagerbottom'];
} else {
    $HTMLOUT .="No torrents downloaded in happy hour!";
}
$HTMLOUT .= end_frame();
$HTMLOUT .= end_main_frame();
print stdhead("Happy hour log for " . htmlspecialchars($user["username"]) . "") . $HTMLOUT . stdfoot();
?>