create('invite'); $id = isset($_GET['id']) ? 0 + $_GET["id"] : $CURUSER['id']; $type = unesc($_GET["type"]); if ($CURUSER[id] != $id && get_user_class() < UC_ADMINISTRATOR && !is_valid_id($id)) stderr("Sorry","Permission Denied!"); stdhead("Invites"); $res = sql_query("SELECT invites FROM users WHERE id = ".mysql_real_escape_string($id)) or sqlerr(); $inv = mysql_fetch_assoc($res); if ($inv["invites"] != 1){ $_s = "s"; } else { $_s = ""; } if ($type == 'new'){ if ($CURUSER[invites] <= 0) { stdmsg("Sorry","You have no invites left!"); stdfoot(); die; } $sent = htmlspecialchars($_GET['sent']); if ($sent == 1) $msg = "The invite code has been sent!"; print("

". "$msg". "". "". "". "". "

Invite someone to join $SITENAME ($inv[invites] invitation$_s left)
Email Address	Email Address must be valid. The invite will receive an email about your invite.
Message

"); } else { $rel = sql_query("SELECT COUNT(*) FROM users WHERE invited_by = ".mysql_real_escape_string($id)) or sqlerr(__FILE__, __LINE__); $arro = mysql_fetch_row($rel); $number = $arro[0]; $ret = sql_query("SELECT id, username, email, uploaded, downloaded, status, warned, enabled, donor, email FROM users WHERE invited_by = ".mysql_real_escape_string($id)) or sqlerr(); $num = mysql_num_rows($ret); print("

". ""); if(!$num){ print(""); } else { print(""); if ($CURUSER[id] == $id || get_user_class() >= UC_SYSOP) print(""); print(""); for ($i = 0; $i < $num; ++$i) { $arr = mysql_fetch_assoc($ret); if ($arr[status] == 'pending') $user = ""; else $user = ""; if ($arr["downloaded"] > 0) { $ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3); $ratio = "$ratio"; } else { if ($arr["uploaded"] > 0) { $ratio = "Inf."; } else { $ratio = "---"; } } if ($arr["status"] == 'confirmed') $status = "Confirmed"; else $status = "Pending"; print("$user"); if ($CURUSER[id] == $id || get_user_class() >= UC_SYSOP){ print(""); } print(""); } } if ($CURUSER[id] == $id || get_user_class() >= UC_SYSOP){ print(""); print(""); if ($CURUSER[invites] <= 0) print(""); else print(""); } print("

Current status of invites ($number)
No invites yet.
Username	Email	Uploaded	Downloaded	Ratio	Status	Confirm
$arr[username]	$arr[username]" .($arr["warned"] == "yes" ? " " : "")." " .($arr["enabled"] == "no" ? " " : "")." " .($arr["donor"] == "yes" ? "" : "")."
$arr[email]	" . mksize($arr[uploaded]) . "	" . mksize($arr[downloaded]) . "	$ratio	$status	"); if ($arr[status] == 'pending') print(""); print("

"); $rul = sql_query("SELECT COUNT(*) FROM invites WHERE inviter =".mysql_real_escape_string($id)) or sqlerr(); $arre = mysql_fetch_row($rul); $number1 = $arre[0]; $rer = sql_query("SELECT invitee, hash, time_invited FROM invites WHERE inviter = ".mysql_real_escape_string($id)) or sqlerr(); $num1 = mysql_num_rows($rer); print("". ""); if(!$num1){ print(""); } else { print(""); for ($i = 0; $i < $num1; ++$i) { $arr1 = mysql_fetch_assoc($rer); print(""); } } print("

Current status of sent out invites ($number1)
No invitations sent out at the moment.
Email	Hash	Send Date
$arr1[invitee]	$arr1[hash]	$arr1[time_invited]

"); } stdfoot(); die; ?>