happylog.php

<?php
/**
 *   https://github.com/Bigjoos/
 *   Licence Info: GPL
 *   Copyright (C) 2010 U-232 v.3
 *   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 = mysqli_fetch_array($ur) or stderr("Error", "No user found");
$count = get_row_count("happylog", "WHERE userid=".sqlesc($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(__FILE__, __LINE__);
$HTMLOUT.= begin_main_frame();
$HTMLOUT.= begin_frame("Happy hour log for ".htmlsafechars($user["username"])."");
if (mysqli_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 = mysqli_fetch_assoc($res)) {
        $HTMLOUT.= "<tr><td><a href='details.php?id=".(int)$arr["torrentid"]."'>".htmlsafechars($arr["name"])."</a></td>
    <td>".(int)$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();
echo stdhead("Happy hour log for ".htmlsafechars($user["username"])."").$HTMLOUT.stdfoot();
?>