<?php
session_start();

/*########################################*\
||    MINI-I.FM HELP TOOL SCRIPT BETA     ||
||   Developed by Invent! of Habbo UK     ||
\*########################################*/

include("../includes/config.php");
include("../includes/functions.php");

if($_GET["action"] == "logout" && isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin")
{

	session_destroy();
	header("location: index.php");
	exit;
	die;

}

if($_GET["action"] == "login" && $_POST["username"] && $_POST["password"])
{

$username = $_POST["username"];
$password = $_POST["password"];

$username = clean($username, "sql");
$password = encrypt($password, "sql");

if(empty($username) || empty($password))
{
	header("location: index.php?error=empty");
}
else
{

	$query = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."'") or die("Could not perform SQL Action, error: ".mysql_error());
	
	if(mysql_num_rows($query) <= "0")
	{
	
		header("location: index.php?error=no_user");
	
	}
	else
	{
	
	/* user exists */
	
	while($r = mysql_fetch_array($query))
	{
		
		$real_user = $r["username"];
		$real_pass = $r["password"];
	
	}
	
	if($password != $real_pass)
	{
		header("location: index.php?error=wrong_pass");
	}
	else
	{
	
		/* Correct password! */
		
		$_SESSION["admin_username"] = $real_user;
		$_SESSION["admin_level"] = "admin";
		header("location: index.php");
		exit;
	
	}
}
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 <meta http-equiv="content-type" content="text/html;charset=utf-8" />
 <title><?php echo("".$site_name.""); ?> Help Tool - Administration</title>
 <link href="../style.css" type="text/css" rel="stylesheet"/>
 <link href="../style-iot.css" type="text/css" rel="stylesheet"/>
</head>
<body>

 <div id="">
  <table id="" border="0" cellpadding="0" cellspacing="0" width="720">
   <tr>
    <td style="background: url(../images/top_left.gif) no-repeat; width: 8px; height: 77px;">&nbsp;</td>
    <td style="background: url(../images/top_mid.gif) repeat-x;" valign="top"><div style="margin: 0; padding: 10px 0 0 27px; height: 67px;"><img src="../content3/images/top_bar/habbo_logo_uk.gif"/></div></td>
    <td style="background: url(../images/top_header_left.gif) no-repeat; width: 3px; height: 77px;"></td>
    <td style="background: url(../images/top_header_mid.gif) repeat-x; height: 77px;"><div style="height: 43px; padding: 31px 0 0 4px; margin: 0; color: #fff; text-transform: uppercase; font-weight: bold; display: block;"><?php echo("".$site_name.""); ?> Help Tool</div></td>
    <td style="background: url(../images/top_header_mid.gif) repeat-x; height: 54px; padding: 23px 0 0 0;" align="right" valign="top"></td>

<td style="background: url(../images/top_right.gif) no-repeat; width: 26px; height: 77px;">&nbsp;</td>
   </tr>				
  </table>    		
 </div>    
 <div id="main-content-process">		
  <div style="height: 4px;"></div>
  <div style="height: 18px; padding: 0 0 0 12px;">&nbsp;</div>	
  <div class="portlet">
   <div class="portlet-top-process"><div class="portlet-process-header">&nbsp;</div></div>
   <div class="portlet-body-process">
   <div class="imaindiv">
<?php
if(!isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] != "admin")
{
?>
<form method="post" action="?action=login"><table border="0" cellspacing="0" cellpadding="0" class="ihead">

	<tr>
		<td class="icon"><img src="../images/1.gif" alt=" " width="47" height="37" /></td>
		<td class="text">
			<h2>enter your username and password</h2>
			
		</td>
		
		</tr>
</table>
<br>

	<table border="0" cellspacing="0" cellpadding="0" class="content-table">

		<tr>
			<td valign="middle" align="left" style="width: 300px;">
				<div class="iinfodiv">
					<strong>Username:</strong><br>
				    <label>
				    <input type="text" name="username" id="username" />
				    </label>
				    <br />
				    <br />
				    <strong>Password:</strong><br />
                    <label>
                    <input name="password" type="password" id="password" value="" />
                    </label>
<br />
				    <br />
				    <label>
				    <input type="submit" name="button" id="button" value="Login" />
			      </label>
                <?php
				if($_GET["error"] == "no_user")
				{
					echo("<br /><br /><font color='red'><strong>Error:</strong> That username doesn't exist!");
				}
				elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["error"] == "empty")
				{
					echo("<br /><br /><font color='red'><strong>Error:</strong> Please fill in all the forms.");
				}
				elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["error"] == "wrong_pass")
				{
					echo("<br /><br /><font color='red'><strong>Error:</strong> That password is incorrect!");
				}
				else
				{
				
				}
				?>
				</div>			</td>
		</tr>
	</table>
</form>
<?php
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && !$_GET["action"] == "read" || !$_GET["action"] == "delete" || !$_GET["action"] == "do_delete" && !$_GET["action"] == "change_pword" && !$_GET["action"] == "do_pword" && !$_GET["action"] == "reply" && !$_GET["action"] == "do_reply" && !$_GET["action"] == "add_acc" && !$_GET["action"] == "del_acc" && !$_GET["action"] == "do_acc" && !$_GET["action"] == "do_del" && !$_GET["id"])
{
?>
<table border="0" cellspacing="0" cellpadding="0" class="ihead">

	<tr>
		<td class="icon"><img src="../images/1.gif" alt=" " width="47" height="37" /></td>
		<td class="text">
			<h2>Administration Panel</h2>
			
		</td>
		
		</tr>
</table>
<br>

	<table border="0" cellspacing="0" cellpadding="0" class="content-table">

		<tr>
			<td valign="middle" align="left" style="width: 500px;">
				<div class="iinfodiv">
					Welcome to the Administration Panel <strong><?php echo("". $_SESSION["admin_username"].""); ?></strong>!
                    <br /><br />
                    - <a href="?action=logout">Logout</a>
                    <br />
                    - <a href="?action=change_pword">Change password</a>
               
                    
                    <br />
                    - <a href="?action=add_acc">Add an account</a><br />
                    - <a href="?action=del_acc">Delete an account</a><br />
                    <br /><hr /><br />
                    
                    <?php
                    
						$query = mysql_query("SELECT * FROM `help_tool`") or die("Could not perform SQL Action, error: ".mysql_error());
						
						if(mysql_num_rows($query) <= "0")
						{
						
							echo ("<strong>Note:</strong><br />You currently have <strong>0</strong> messages!");
						
						}
						
						while($r = mysql_fetch_array($query))
						{
						
							echo("<strong>Habbo Name:</strong> ". $r["username"] ."<br /><strong>Email Address:</strong> ". $r["email"] ."<br /><br /><a href=\"?action=read&id=". $r["id"] ."\">Read Message</a><br /><br /><hr /><br />");
						
						}					
					
					?></div>			</td>
		</tr>
	</table>
<?php
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "read" && !empty($_GET["id"]))
{
?>
<table border="0" cellspacing="0" cellpadding="0" class="ihead">

	<tr>
		<td class="icon"><img src="../images/1.gif" alt=" " width="47" height="37" /></td>
		<td class="text">
			<h2>Administration Panel</h2>
			
		</td>
		
		</tr>
</table>
<br>

	<table border="0" cellspacing="0" cellpadding="0" class="content-table">

		<tr>
			<td valign="middle" align="left" style="width: 500px;">
				<div class="iinfodiv">
					Welcome to the Administration Panel <strong><?php echo("". $_SESSION["admin_username"].""); ?></strong>!
                    
                                        <br /><br /><hr /><br />

<?php

	$id = $_GET["id"];
	$id = clean($id, "sql");
	
	$query = mysql_query("SELECT * FROM `help_tool` WHERE `id` = '".$id."'") or die("Could not perform SQL Action, error: ".mysql_error());
	
	while($r = mysql_fetch_array($query))
	{
	
		echo("<strong>Habbo Name:</strong><br /> ". $r["username"] ."<br /><br /><strong>Email Address:</strong><br />". $r["email"] ."<br /><br /><strong>Message:</strong><br />". ($r["message"]) ."<br /><br /><a href=\"index.php?\">Go Back</a> | <a href=\"?action=delete&id=". $r["id"] ."\">Delete Message</a> | <a href=\"?action=reply&id=". $r["id"] ."\">Reply</a><br /><br /><hr /><br />");
	
	}
	?>
    </div>			</td>
		</tr>
	</table>
    <?php
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "delete" && !empty($_GET["id"]))
{

	$id = $_GET["id"];
	$id = clean($id, "sql");
	
	$query = mysql_query("SELECT * FROM `help_tool` WHERE `id` = '".$id."'") or die("Could not perform SQL Action, error: ".mysql_error());

	if(mysql_num_rows($query) <= "0")
	{
	
		echo("<strong>Error:</strong> A message with that id (".$id.") doesn't exist sorry!");
		
	}
	else
	{

		echo("<strong>Note:</strong><br />Are you <strong>sure</strong> you want to delete this message? (ID: ".$id.")<br /><br /><a href=\"index.php?\">No</a> | <a href=\"?action=do_delete&id=". $id ."\">Yes</a>");
	
	}
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "do_delete")
{

	$id = $_GET["id"];
	$id = clean($id, "sql");

	$query = mysql_query("DELETE FROM `help_tool` WHERE `id` = '".$id."'") or die("Could not perform SQL Action, error: ".mysql_error());
	
		echo("<strong>Thank you!</strong><br /><br />The message with the ID of ".$id." has been successfully deleted!<br /><br /><a href=\"index.php?\">Go back</a>");
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "change_pword")
{

	echo('<form action="?action=do_pword" method="post"><strong>Current Password:</strong><br /><input type="password" name="curpass" id="curpass" /><br /><br /><strong>New Password:</strong><br /><input type="password" name="newpass" id="newpass" /><br /><br ><input type="submit" value="Change Password" /></form>');

}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "do_pword" && $_POST["curpass"] && $_POST["newpass"])
{

	$old_pass = encrypt($_POST["curpass"], "sql");
	$new_pass = encrypt($_POST["newpass"], "sql");
	
	$query = mysql_query("SELECT * FROM `users` WHERE `username` = '".$_SESSION["admin_username"]."'") or die("Could not perform SQL Action, error: ".mysql_error());
	
	while($r = mysql_fetch_array($query))
	{
	
		$real_pass = $r["password"];
	
	}
	
	if($old_pass != $real_pass)
	{
	
		echo("<strong>Error:</strong><br />The old password you entered does not match your password, please go back and correct this.<br /><br /><a href=\"?action=change_pword\">Go back</a> echo ".$old_pass." - ".$real_pass."");
		
	}
	else
	{
	
		/* Password matches, w000t!!! */
		
		$query = mysql_query("UPDATE `users` SET `password` = '".$new_pass."'") or die("Could not perform SQL Action, error: ".mysql_error());
		
		echo("<strong>Thank you!</strong><br /><br />Your password has been successfully changed!<br /><br /><a href=\"index.php?\">Go back</a>");
			
	}
	
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "reply" && !empty($_GET["id"]))
{

	$id = $_GET["id"];
	$id = clean($id, "sql");
	
	$query = mysql_query("SELECT * FROM `help_tool` WHERE `id` = '".$id."'") or die("Could not perform SQL Action, error: ".mysql_error());

	if(mysql_num_rows($query) <= "0")
	{
	
		echo("<strong>Error:</strong> A message with that id (".$id.") doesn't exist sorry!");
		
	}
	else
	{
	while($r = mysql_fetch_array($query))
	{
	?>
    <table border="0" cellspacing="0" cellpadding="0" class="ihead">

	<tr>
		<td class="icon"><img src="../images/1.gif" alt=" " width="47" height="37" /></td>
		<td class="text">
			<h2>Reply to a message</h2>
			
		</td>
		
		</tr>
</table>
<br>

	<table border="0" cellspacing="0" cellpadding="0" class="content-table">

		<tr>
			<td valign="middle" align="left" style="width: 500px;">
				<div class="iinfodiv">
					Fill in the form below and hit "Reply" to reply to the message.<br />Upon replying, the message will be deleted!
                    
                                        <br /><br /><hr /><br />
<?php
	echo("<form action=\"?action=do_reply\" method=\"post\"><input type=\"hidden\" name=\"id\" value=\"".$r["id"]."\" id=\"id\" /><input type=\"hidden\" name=\"email\" value=\"".$r["email"]."\" id=\"email\" /><strong>Message:</strong><br /><textarea name=\"message\" id=\"message\" cols=\"60\" rows=\"5\">Hello ".$r["username"].",\n\nThanks for your message, change the text here...\n\nThanks again!,\n\n- ".$_SESSION["admin_username"]."\n- ".$site_name." Support Team Staff\n\nNote: Please do NOT reply to this message!\n\n/*======================================\*\nOriginal message:\n>".$r["message"]."\n\*======================================*/</textarea><br /><br /><input type=\"submit\" value=\"Reply\"></form></div>			</td>
		</tr>
	</table>");
	}
	}	
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "do_reply" && $_POST["message"] && $_POST["email"] && $_POST["id"])
{

	
	$to = $_POST["email"];	
	$subject = "Reply to your ".$site_name." support request";
	$message = $_POST["message"];
	$message= nl2br($message);
	$message = str_replace("\r", "", $message);
	$message = str_replace("\n", "", $message);
	$message = str_replace("<br />", "\n", $message);
	$message = wordwrap($message, 70);
	$headers = 'From: '.$from_email.'' . "\r\n" .
		'Reply-To: '.$from_email.'' . "\r\n" .
		'X-Mailer: PHP/' . phpversion();

	mail($to, $subject, $message, $headers);
	
	$id = clean($_POST["id"], "sql");
	
	$query = mysql_query("DELETE FROM `help_tool` WHERE `id` = '".$id."'") or die("Could not perform SQL Action, error: ".mysql_error());

	
		echo("<strong>Thank you!</strong><br /><br />Your reply has been sent (and the message has been deleted (ID ".$id."))!<br /><br /><a href=\"index.php?\">Go back</a>");

}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "add_acc")
{
?>
    <table border="0" cellspacing="0" cellpadding="0" class="ihead">

	<tr>
		<td class="icon"><img src="../images/1.gif" alt=" " width="47" height="37" /></td>
		<td class="text">
			<h2>Create an account</h2>
			
		</td>
		
		</tr>
</table>
<br>

	<table border="0" cellspacing="0" cellpadding="0" class="content-table">

		<tr>
			<td valign="middle" align="left" style="width: 500px;">
				<div class="iinfodiv">
					Fill in the forms below and hit "Create" to create an account!
                    
                                        <br /><br /><hr /><br />
                    
                    <form action="?action=do_acc" method="post">
                                                          
                    <strong>Username:</strong>
                    <br />
                    <input type="text" name="username" id="username" />
                    
                    <br /><br />
                    
                    <strong>Password:</strong>
                    <br />
                    <input type="password" name="password" id="password" />
                    
                    <br  /><br  />
                    
                    <input type="submit" value="Create" />
                    
                    </form>
<?php


?>
</div>			</td>
		</tr>
	</table>
<?php
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "do_acc" && $_POST["username"] && $_POST["password"])
{

	$username = $_POST["username"];
	$password = $_POST["password"];
	
	$username = clean($username, "sql");
	
	if(empty($username) || empty($password))
	{
	
		echo("<strong>Error:</strong><br />One or more fields were left blank!<br /><br />Please go <a href=\"index.php?action=add_acc\">back</a> and fix this.");
	
	}
	else
	{
	
		$query = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."'");
		
		if(mysql_num_rows($query) >= "1")
		{
		
			echo("<strong>Error:</strong><br />An account with that username already exists!<br /><br />Please go <a href=\"index.php?action=add_acc\">back</a> and fix this.");	
		
		}
		else
		{
	
		$password = encrypt($password);
		
		$query = mysql_query("INSERT INTO `users` (`username`, `password`) VALUES ('".$username."', '".$password."')") or die("Could not perform SQL Action, error: ".mysql_error());
		
		echo("<strong>Thanks!</strong><br /><br />The account with the username ".$username." has been created successfully!<br /><br /><a href=\"index.php?\">Go back</a>");
		
		}
	
	}
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "del_acc")
{
?>
    <table border="0" cellspacing="0" cellpadding="0" class="ihead">

	<tr>
		<td class="icon"><img src="../images/1.gif" alt=" " width="47" height="37" /></td>
		<td class="text">
			<h2>Delete an account</h2>
			
		</td>
		
		</tr>
</table>
<br>

	<table border="0" cellspacing="0" cellpadding="0" class="content-table">

		<tr>
			<td valign="middle" align="left" style="width: 500px;">
				<div class="iinfodiv">
					From the list of users below, to delete a user just click "Delete" below their username!
                    
                                        <br /><br /><hr /><br />
                    
					<?php
                    
						$query = mysql_query("SELECT * FROM `users` WHERE `username` != '".$root_user."'") or die("Could not perform SQL Action, error: ".mysql_error());
						
						while($r = mysql_fetch_array($query))
						{
						
							echo("<strong>Username:</strong><br />".$r["username"]."<br /><br /><strong>Action:</strong><br /><a href=\"?action=do_del&id=".$r["id"]."\">Delete</a><br /><br /><hr /><br />");
						
						
						}
                    
                    ?>
</div>			</td>
		</tr>
	</table>
<?php
	
}
elseif(isset($_SESSION["admin_username"]) && $_SESSION["admin_level"] == "admin" && $_GET["action"] == "do_del" && !empty($_GET["id"]))
{

	$id = $_GET["id"];
	$id = clean($id, "sql");

	$query = mysql_query("SELECT * FROM `users` WHERE id = '".$id."'") or die("Could not perform SQL Action, error: ".mysql_error());
	
	if(mysql_num_rows($query) <= "0")
	{
	
			echo("<strong>Error:</strong><br />An account with that id doesn't exist!<br /><br />Please go <a href=\"index.php?action=del_acc\">back</a> and fix this.");	
			
	}
	else
	{
	
		$query = mysql_query("SELECT * FROM `users` WHERE `username` = '".$root_user."'") or die("Could not perform SQL Action, error: ".mysql_error());
		
		while($lol = mysql_fetch_array($query))
		{
		
			$root_id = $lol["id"];		
		
		}
		
		if($id == $root_id)
		{
		
			echo("<strong>Error:</strong><br />You can't delete the root administrator's account!<br /><br />Please go <a href=\"index.php?action=del_acc\">back</a> and fix this.");	

		}
		else
		{
		
			$query = mysql_query("DELETE FROM `users` WHERE id = '".$id."'") or die("Could not perform SQL Action, error: ".mysql_error());
			
		echo("<strong>Thanks!</strong><br /><br />The account with the id ".$id." has been successfully deleted!<br /><br /><a href=\"index.php?\">Go back</a>");
		
		}	
	}	
}

?>

<br /><hr /><br />
<center>

	<a href="index.php?">Home</a><br />
    <br />
    <strong>Powered by the <a href="http://www.mini-i.fm/helptool">Mini-I Help Tool</a></strong>

</center>
   </div>
   </div>
   <div class="portlet-bottom-process"></div>
  </div>
 </div>

 <div id="footer-process">
  <div id="footer-top-process" style="font-size:8px"
>&nbsp;</div>
  <div id="footer-body-process">
   <table border="0" width="100%" cellpadding="0" cellspacing="0">
    <tr><td align="center">© 2006 Sulake Corporation Ltd. HABBO is a registered trademark of Sulake Corporation Oy in the European Union, the USA, Japan, the People's Republic of China and various other jurisdictions. All rights reserved.</td></tr>
   </table>
  </div>
  <div id="footer-bottom-process">&nbsp;</div>

 </div>