$search = trim($_GET['search']);
$query = "username = "******"{$search}") . " AND status='confirmed'";
$res = sql_query("SELECT * FROM users WHERE {$query} ORDER BY username") or sqlerr(__FILE__, __LINE__);
$num = mysqli_num_rows($res);
if ($num < 1) {
echo $search . " - No such user, please try again.";
}
if ($num > 0) {
$arr = mysqli_fetch_assoc($res);
$id = isset($arr['id']) ? 0 + $arr['id'] : 0;
$seedingbonus = isset($arr['seedbonus']) ? (int) $arr['seedbonus'] : '';
$username = htmlsafechars($arr['username']);
if (isset($_GET['func']) && $_GET['func'] == "stats") {
$ratio = $arr["downloaded"] > 0 ? $arr["uploaded"] / $arr["downloaded"] : "0.00";
$lastseen = htmlsafechars($arr["last_access"]);
echo htmlsafechars($arr['username']) . " - Uploaded: (" . mksize($arr['uploaded']) . ") - Downloaded: (" . mksize($arr['downloaded']) . ") - Ratio: (" . number_format($ratio, 2) . ") - Invites: (" . (int) $arr['invites'] . ") - Joined: (" . get_date($arr["added"], 'DATE', 0, 1) . "" . ") - Online time: (" . time_return($arr["onlinetime"]) . ") - Last Seen: (" . get_date($lastseen, 'DATE', 0, 1) . ")";
} elseif (isset($_GET['func']) && $_GET['func'] == "check") {
echo htmlsafechars($arr['username']) . " - Seedbonus: (" . number_format($arr['seedbonus'], 1) . ")";
} elseif (isset($_GET['func']) && $_GET['func'] == "ircbonus") {
$ircbonus = !empty($arr['irctotal']) ? number_format($arr["irctotal"] / ($INSTALLER09['autoclean_interval'] * 4), 1) : '0.0';
echo $arr['username'] . " - IRC Bonus: (" . $ircbonus . ")";
} elseif (isset($_GET['func']) && $_GET['func'] == "irctotal") {
$irctotal = !empty($arr['irctotal']) ? calctime($arr['irctotal']) : $arr['username'] . ' has never been on IRC!';
echo $arr['username'] . " - IRC Total: (" . $irctotal . ")";
} elseif (isset($_GET['func']) && $_GET['func'] == "connectable") {
$res5 = sql_query("SELECT connectable FROM peers WHERE userid=" . sqlesc($arr['id'])) or sqlerr(__FILE__, __LINE__);
if ($row = mysqli_fetch_row($res5)) {
$connect = $row[0];
if ($connect == "yes") {
$connectable = "Yes - " . $username . " is connectable";
} else {
if ($arr['hash1'] != '') {
$HTMLOUT .= "<tr><td class='rowhead'>Login Link<br /><a href='createlink.php?action=reset&id=" . $CURUSER['id'] . "' target='_blank'>Reset Link</a></td><td align='left'>{$INSTALLER09['baseurl']}/pagelogin.php?qlogin="******"</td></tr>";
} else {
$HTMLOUT .= "<tr><td class='rowhead'>Login Link</td><td align='left'><a href='createlink.php?id=" . $CURUSER['id'] . "' target='_blank'>Create link</a></td></tr>";
}
}
//==End
/* Flush all torrents mod */
if ($CURUSER['class'] >= UC_STAFF) {
$un = $user["username"];
$HTMLOUT .= "<tr><td class='rowhead' width='1%'>{$lang['userdetails_flush']}</td><td align='left' width='99%'>" . ("{$lang['userdetails_flush1']}<a href='{$INSTALLER09['baseurl']}/staffpanel.php?tool=flush&action=flush&id={$id}'><b>" . htmlspecialchars($un) . "</b></a>\n") . "</td></tr>";
}
$HTMLOUT .= "<tr><td class='rowhead' width='1%'>{$lang['userdetails_joined']}</td><td align='left' width='99%'>{$joindate}</td></tr>\r\n <tr><td class='rowhead'>{$lang['userdetails_seen']}</td><td align='left'>{$lastseen}</td></tr>";
//== Online time
//if($user['onlinetime'] > 0)
$onlinetime = time_return($user['onlinetime']);
//else
//$onlinetime = "This user has no online time recorded";
$HTMLOUT .= "<tr><td class='rowhead' width='1%'>Total Online</td><td align='left' width='99%'>{$onlinetime}</td></tr>";
// end
$member_reputation = get_reputation($user, 'users');
$HTMLOUT .= "<tr><td class='rowhead' valign='top' align='right' width='1%'>{$lang['userdetails_rep']}</td><td align='left' width='99%'>{$member_reputation}<br />\r\n </td></tr>";
//==09 Birthday mod
$age = $birthday = '';
if ($user['birthday'] != "0000-00-00") {
$current = gmdate("Y-m-d", time());
list($year2, $month2, $day2) = explode('-', $current);
$birthday = $user["birthday"];
$birthday = date("Y-m-d", strtotime($birthday));
list($year1, $month1, $day1) = explode('-', $birthday);
if ($month2 < $month1) {
function getStats($user, $forced = false)
{
global $_settings, $countries;
if (!file_exists($_settings . $user . ".set") || !is_array($var = unserialize(file_get_contents($_settings . $user . ".set")))) {
return false;
}
$query = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT u.id, u.irctotal, u.last_login, u.onlinetime, u.reputation, u.hits, u.uploaded, u.downloaded, u.country, u.browser, count(p.id) as posts ,count(c.id) as comments FROM users as u LEFT JOIN posts as p ON u.id = p.user_id LEFT JOIN comments as c ON c.user = u.id WHERE u.username = "******" GROUP BY u.id") or sqlerr(__FILE__, __LINE__);
//or die('Error Error Error! 1');
if (mysqli_num_rows($query) != 1) {
die('Error Error Error! 2');
}
$a = mysqli_fetch_assoc($query);
$ops = array($var['line1']['value'], $var['line2']['value'], $var['line3']['value']);
$i = 1;
foreach ($ops as $op) {
switch ($op) {
case 1:
$var['line' . $i]['value_p'] = $a['posts'] . " post" . ($a['posts'] > 1 ? "s" : "");
break;
case 2:
//$var['line'.$i]['value_p'] = mksize($a['downloaded']) . " - " . mksize($a['uploaded']);
$var['line' . $i]['value_p'] = mksize($a['downloaded']) . " - " . mksize($a['uploaded']);
break;
case 3:
list($days, $hours, $mins) = explode(",", calctime($a['irctotal']));
$var['line' . $i]['value_p'] = "{$days} - {$hours}";
//$var['line'.$i]['value_p'] = "not yet";
break;
case 4:
$var['line' . $i]['value_p'] = $a['reputation'] . " point" . ($a['reputation'] > 1 ? "s" : "");
break;
case 5:
foreach ($countries as $c) {
if ($c['id'] == $a['country']) {
$var['line' . $i]['value_p'] = $c;
}
}
break;
case 6:
$var['line' . $i]['value_p'] = $a['comments'] . " comment" . ($a['comments'] > 1 ? "s" : "");
break;
case 7:
$var['line' . $i]['value_p'] = $a['browser'];
break;
case 8:
$var['line' . $i]['value_p'] = $a['hits'] . " hit" . ($a['hits'] > 1 ? "s" : "");
break;
/*
case 9:
$lapsetime = ((($lapsetime = time() - sql_timestamp_to_unix_timestamp($a["last_login"])) / 3600) % 24) . ' h ' . (($lapsetime / 60) % 60) . ' min ' . ($lapsetime % 60) . ' s';
$var['line'.$i]['value_p'] = $lapsetime;
break;
*/
/*
case 9:
$lapsetime = ((($lapsetime = time() - sql_timestamp_to_unix_timestamp($a["last_login"])) / 3600) % 24) . ' h ' . (($lapsetime / 60) % 60) . ' min ' . ($lapsetime % 60) . ' s';
$var['line'.$i]['value_p'] = $lapsetime;
break;
*/
case 9:
$var['line' . $i]['value_p'] = time_return($a['onlinetime']);
break;
}
$i++;
}
if (is_writable($_settings . $user . ".set")) {
file_put_contents($_settings . $user . ".set", serialize($var));
} else {
exit("Can't write user setting");
}
if (file_exists($_settings . $user . ".png")) {
unlink($_settings . $user . ".png");
}
return $var;
}
