This idea was from GanjaFreak, i made it.
Tested and works.
<?php
@include_once(DIRNAME(__FILE__) .'/globals.php');
//Made by Danny696
//Idea by GngajaFreak
//I Rock!
if(isset($_GET['action']))
{
switch($_GET['action'])
{
case'unfed': un_fed(); break;
case'editfed': edit_fed(); break;
default: fedd(); break;
}
}
else { fedd(); }
function fedd()
{
global $db, $ir;
$getfed = sprintf("SELECT f.*,u.username,u2.username AS jailer
FROM fedjail f
LEFT JOIN users u ON f.fed_userid=u.userid
LEFT JOIN users u2 ON f.fed_jailedby=u2.userid ORDER BY f.fed_days ASC");
$fusers = $db->query($getfed);
echo'[b]Federal Jail[/b]
If you ever cheat the game your name will become a permanent part of this list...
<table cellspacing=1 class="table" width="50%">
<tr style="background:gray">
<th>Who</th>
<th>Days</th>
<th>Reason</th>
<th>Jailer</th>';
if($ir['user_level'] >= 2)
{
echo'<th>Options</th>';
}
echo'</tr>';
while($r = $db->fetch_row($fusers))
{
echo'<tr>';
echo sprintf("<td>[url='%s']%s[/url]</td>", 'viewuser.php?u='.$r['fed_userid'].'', $r['username']);
echo sprintf("<td>%s</td>", number_format($r['fed_days']));
echo sprintf("<td>%s</td>", $r['fed_reason']);
echo sprintf("<td>[url='%s']%s[/url]</td>", 'viewuser.php?u='.$r['fed_jailedby'].'', $r['jailer']);
if($ir['user_level'] >= 2)
{
echo sprintf("<td>
[url='%s']<span style='color:%s'>Remove</span>[/url]
[url='%s']<span style='color:%s;'>Edit</span>[/url]", '?action=unfed&ID='.$r['fed_userid'].'', 'green', '?action=editfed&ID='.$r['fed_userid'].'', 'blue');
}
echo'</tr>';
}
echo'</table>';
$getmailB = sprintf("SELECT * FROM users WHERE mailban>0 ORDER BY mailban ASC");
$mB = $db->query($getmailB);
echo'[b]Mail Bann[/b]</center>
If you ever do bad things at your mail, your name will become a permanent part of this list...
<table width="100%" cellspacing="1" class="table">
<tr style="background:gray">
<th>Who</th>
<th>Days</th>
<th>Reason</th>
</tr>';
while($r = $db->fetch_row($mB))
{
echo'<tr>';
echo sprintf("<td>[url='%s']%s[/url]</td>", 'viewuser.php?u='.$r['userid'].'', $r['username']);
echo sprintf("<td>%s</td>", number_format($r['mailban']));
echo sprintf("<td>%s</td>", $r['mb_reason']);
echo'</tr>';
}
echo'</table>';
}
function un_fed()
{
global $db, $ir, $userid;
$user = sprintf("UPDATE users SET fedjail=%u WHERE userid=%u", '0', $_GET['ID']);
$fedjail = sprintf("DELETE FROM fedjail WHERE fed_userid=%u", $_GET['ID']);
$jaillog = sprintf("INSERT INTO unjaillogs VALUES('',%u,%u,unix_timestamp())", $userid, $_GET['ID']);
$db->query($user);
$db->query($fedjail);
$db->query($jaillog);
echo'User unjailed.
[url="fedjail.php"]Back[/url]';
stafflog_add("Unfedded user ID {$_GET['ID']}");
}
function edit_fed()
{
global $db,$userid;
if(isset($_POST['change']) == 1)
{
$delete = sprintf("DELETE FROM fedjail WHERE fed_userid=%u", $_GET['ID']);
$re_insert = sprintf("INSERT INTO fedjail VALUES('',%u,%u,%u,'%s')", $_GET['ID'], $_POST['days'], $userid, $_POST['reason']);
$db->query($delete);
$db->query($re_insert);
$addlog = sprintf("INSERT INTO jaillogs VALUES('',%u,%u,%u,'%s',unix_timestamp())", $userid, $_GET['ID'], $_POST['days'], $_POST['reason']);
$db->query($addlog);
echo'User\'s sentence edited.
[url="fedjail.php"]Back[/url]';
stafflog_add("Edited user ID {$_GET['ID']}'s fedjail sentence");
}
else
{
$getinfo = sprintf("SELECT * FROM fedjail WHERE fed_userid=%u", $_GET['ID']);
$fed = $db->fetch_row($db->query($getinfo));
echo'<form action="fedjail.php?action=editfed&ID='.$_GET['ID'].'" method="post">
<input type="hidden" name="change" value="1" />
Days: <input type="text" name="days" value="'.$fed['fed_days'].'" />
Reason: <input type=" text" name="reason" value="'.$fed['fed_reason'].'" />
<input type="submit" value="Submit" />
</form>';
}
}
$h->endpage();
?>
[paypal]
[email protected][/paypal]
