Hi, i found this and i dont know what it does or hjow to use it lol, can someone explain, i think its a request line but how does it work?
HTML Code:<?
require('config.php');
require('bar.php');
switch($_GET['act']){
default:
Echo"<center><b>Request Line</b></center>
Use the following form to submit a message (Shoutout/Song Request) to the
DJ which is currently on air. If your message is appropraite, they will read
it. If they have your song, they may play it. Obey the Habbo Way or you
will be banned.<br><br>
<form method='post' action='request.php?act=submit'>
<table>
<tr>
<td>Habbo Name:</td>
<td><input type='text' name='habbo' size='20'></td>
</tr>
<tr>
<td>Song Requested (One Song):</td>
<td><input type='text' name='song' size='20'></td>
</tr>
<tr>
<td>Shoutout/Dedication:</td>
<td><textarea name='shoutout' cols='20' rows='6'></textarea></td>
</tr>
<tr>
<td></td>
<td><input type='submit' name='Submit'></td>
</tr>
</table>
</form>";
break;
case"submit":
$habbo = $_POST['habbo']; $song = $_POST['song']; $shoutout = $_POST['shoutout'];
// Empty
if(empty($habbo)){
Echo"<b>Error:</b> Please fill out the request form, before submitting it.
We do not appreciate spam.<br>
- <a href='request.php'>Back</a>";
exit;
}
// Banned
$bannedQuery = mysql_query("SELECT * FROM banned WHERE IP ='$IP_Address'");
if(mysql_num_rows($bannedQuery) !="0"){
$bannedData = mysql_fetch_array($bannedQuery);
Echo"<b>Error:</b> You have been banned from our request line for the
following reason:<br>
$bannedData[reason]<br>
Use our <a href='contact.php'>Contact Forms</a> to dispute your ban.<br>
- <a href='request.php'>Back</a>";
exit;
}
// Fix Problems
$habbo = htmlspecialchars($habbo);
$song = htmlspecialchars($song);
$shoutout = htmlspecialchars($shoutout);
// Send
mysql_query("INSERT INTO request (habbo,song,shoutout,IP,priority) VALUES ('$habbo','$song','$shoutout','$IP_Address','N')");
mysql_query("INSERT INTO logs (habbo,song,shoutout,IP,deleted,deletedby) VALUES ('$habbo','$song','$shoutout','$IP_Address','N','')");
Echo"<b>Request Submitted Successfully</b>";
break;
}
?>
HTML Code:<?
require('config.php');
require('bar.php');
if($userData[user] =="" || $userData[pass] ==""){
Echo"<b>Error:</b> You are not authorized to access this page.";
exit;
}
if($userData[djname] ==""){
Echo"<b>Attention:</b> Please fill our your DJ name in the following area.
<form method='post' action='requests.php?act=name'>
<table>
<tr>
<td><input type='text' name='djname' value='DJ-' size='20'></td>
<td><input type='submit' value='Submit'></td>
</tr>
</table>
</form>";
}
if($userData[document] =="N"){
mysql_query("UPDATE users SET document ='Y' WHERE user ='$userData[user]'");
Echo"<b>ATTENTION:</b> There is an announcement for you to read:<br>";
$annQuery = mysql_query("SELECT * FROM announcement WHERE active ='Y'");
$annData = mysql_fetch_array($annQuery);
Echo"$annData[announcement]<br>
- <a href='requests.php'>I've read the above.</a>";
exit;
}
switch($_GET['act']){
default:
Echo"<center><b>Request Line</b></center>
<a href='requests.php'>Refresh</a><br><br>
<form method='post' action='requests.php?act=del'>
<table width='100%'>
<tr>
<td>Sender:</td>
<td>Song:</td>
<td>Message:</td>
<td>Del:</td>
</tr>";
$requestsQuery = mysql_query("SELECT * FROM request ORDER BY ID ASC");
if(mysql_num_rows($requestsQuery) =="0"){
Echo"</table> There are no requests.";
exit;
}else{
$button ="<input type='submit' value='Delete'>";
}
$adminReqQuery = mysql_query("SELECT * FROM request WHERE priority ='Admin' ORDER BY ID ASC");
while($adminReqData = mysql_fetch_array($adminReqQuery)){
Echo"
<tr>
<td><a href='requests.php?act=alias&ID=$adminReqData[ID]'>$adminReqData[habbo]</a></td>
<td><font color='red'><b>$adminReqData[song]</b></font></td>
<td><font color='red'><b>$adminReqData[shoutout]</b></font></td>
<td><input type='checkbox' name='del[]' value='$adminReqData[ID]'></td>
</tr>";
}
$headReqQuery = mysql_query("SELECT * FROM request WHERE priority ='HDJ' ORDER BY ID ASC");
while($headReqData = mysql_fetch_array($headReqQuery)){
Echo"
<tr>
<td><a href='requests.php?act=alias&ID=$headReqData[ID]'>$headReqData[habbo]</a></td>
<td><font color='green'><b>$headReqData[song]</b></font></td>
<td><font color='green'><b>$headReqData[shoutout]</b></font></td>
<td><input type='checkbox' name='del[]' value='$headReqData[ID]'></td>
</tr>";
}
$otherReqQuery = mysql_query("SELECT * FROM request WHERE priority ='N' ORDER BY ID ASC");
while($otherReqData = mysql_fetch_array($otherReqQuery)){
Echo"
<tr>
<td><a href='requests.php?act=alias&ID=$otherReqData[ID]'>$otherReqData[habbo]</a></td>
<td>$otherReqData[song]</td>
<td>$otherReqData[shoutout]</td>
<td><input type='checkbox' name='del[]' value='$otherReqData[ID]'></td>
</tr>";
}
Echo"
</table>
<div align='right'>$button</div>";
break;
case"del":
$del = $_POST['del'];
$delQuery = mysql_query("SELECT * FROM request");
$delCount = mysql_num_rows($delQuery);
for($i = 0; $i <= $delCount; $i++){
if($del[$i] !=""){
mysql_query("DELETE FROM request WHERE ID ='$del[$i]' LIMIT 1");
mysql_query("UPDATE logs SET deleted ='Y', deletedby ='$userData[user]' WHERE ID ='$del[$i]'");
}
}
Echo"<b>Deletions Completed Successfully</b><br>
- <a href='requests.php'>Back</a>";
break;
case"alias":
$ID = $_GET['ID'];
if($ID ==""){
Echo"<b>Error:</b> There was an error processing your request. Please click
the back button on your browser.";
exit;
}
// Get Request Information
$requestQuery = mysql_query("SELECT * FROM request WHERE ID ='$ID'");
if(mysql_num_rows($requestQuery) =="0"){
Echo"<b>Error:</b> Somebody has deleted this request. It is not inside
our database.";
exit;
}
$requestData = mysql_fetch_array($requestQuery);
if($userData[rank] =="Admin"){
Echo"<center><b>Alias Checker for ID [$ID] and IP [$requestData[IP]]</b></center>";
}else{
Echo"<center><b>Alias Checker for ID [$ID] and IP [Hidden]</b></center>";
}
Echo"
<a href='requests.php?act=ban&ID=$ID'>Ban this Person</a>
<hr width='100%' height='1' color='#000000' shade='no'>
The below users have sent a request using the same IP address as this request,
however this does not mean that they below persons ARE the submitter of this
message.
<hr width='100%' height='1' color='#000000' shade='no'>";
// Get Alias Data
$aliasQuery = mysql_query("SELECT DISTINCT(habbo) FROM logs WHERE IP ='$requestData[IP]' ORDER BY habbo ASC");
while($aliasData = mysql_fetch_array($aliasQuery)){
Echo"$aliasData[habbo]<br>";
}
break;
case"ban":
if($cmd ==""){
Echo"<center><b>Banning Submitter of Request ID $ID</b></center>
These actions are not revirsable by yourself, and adminsitrator will have
to unban the user. Please, do not abuse this function, and only use if
persons are repeating to break the rules, <i>AFTER</i> necessary reasoning.
<form method='post' action='requests.php?act=ban&cmd=ban&ID=$ID'>
<textarea name='reason' cols='40' rows='3'></textarea><br>
<input type='submit' value='Ban'>
</form>";
}elseif($cmd =="ban"){
$reason = $_POST['reason'];
if($ID ==""){
Echo"<b>Error:</b> There was an error processing your request. Please click
the back button on your browser.";
exit;
}
// Get Request Information
$requestQuery = mysql_query("SELECT * FROM request WHERE ID ='$ID'");
if(mysql_num_rows($requestQuery) =="0"){
Echo"<b>Error:</b> Somebody has deleted this request. It is not inside
our database.";
exit;
}
$requestData = mysql_fetch_array($requestQuery);
mysql_query("INSERT INTO banned (requestID,IP,banner,reason) VALUES ('$requestData[ID]','$requestData[IP]','$userData[user]','$reason')");
Echo"<b>Ban Completed Successfully</b><br>
- <a href='requests.php'>Back</a>";
}
break;
case"name":
$djname = $_POST['djname'];
mysql_query("UPDATE users SET djname ='$djname' WHERE user ='$userData[user]'");
Echo"<b>DJ Name Added Successfully</b> <br>
- <a href='requests.php'>Back</a>";
break;
}
?>
Moved by Reformed (Forum Moderator) from Website Designing, please post in the correct forum next time, Thanks :).
