happylog.php

<?php
/**
 * -------   U-232 Codename Trinity   ----------*
 * ---------------------------------------------*
 * --------  @authors U-232 Team  --------------*
 * ---------------------------------------------*
 * -----  @site https://u-232.duckdns.org/  ----*
 * ---------------------------------------------*
 * -----  @copyright 2020 U-232 Team  ----------*
 * ---------------------------------------------*
 * ------------  @version V6  ------------------*
 */
require_once(__DIR__.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 = $ur->fetch_array(MYSQLI_ASSOC)) || 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'])) || sqlerr(__FILE__,
    __LINE__);
$HTMLOUT .= begin_main_frame();
$HTMLOUT .= begin_frame("Happy hour log for ".htmlsafechars($user["username"])."");
if ($res->num_rows > 0) {
    $HTMLOUT .= $pager['pagertop'];
    $HTMLOUT .= "<table class='table table-bordered'>
    <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 = $res->fetch_assoc()) {
        $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();
?>