Thanks so much ! - It actaully works now...
Dont suppose you could fix ther next 100 too xD
Im useless at php.
I emailed the host to install php 5 " We do not want to install this on our servers yet"
Weird...
Someone change these like Dentarfice has changed the previous...
password.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<?
$action = $_GET[action];
if($action == "change") {
if(!$password_cng) { echo "<b>You must enter your New Password!</b>"; exit; }
$password_cng = ($password_cng);
$user = $_SESSION['session_username'];
$query = mysql_query("UPDATE `staff` SET password='$password_cng' WHERE username='$user'") or die(mysql_error());
echo "<font face=verdana size=1>Password Changed";
} else {
echo "
<form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">
<tr><td><font size=\"1\" face=\"Verdana\">Password: <td><input name=\"password_cng\"></td></tr>
<tr><td></td><td><input type=submit value=\"Change Password\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?>
Another that wont work...
habboname.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<?
if($action == "change") {
if(!$habboname_cng) { echo "<b>You must enter your Habbo Name!</b>"; exit; }
$habboname_cng = ($habboname_cng);
$user = $_SESSION['session_username'];
$query = mysql_query("UPDATE `staff` SET habboname='$habboname_cng' WHERE username='$user'") or die(mysql_error());
echo "<font face=verdana size=1>Habbo Name Changed";
} else {
echo "
<form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">
<tr><td><font size=\"1\" face=\"Verdana\">Habbo Name: <td><input name=\"habboname_cng\"></td></tr>
<tr><td></td><td><input type=submit value=\"Change Habbo Name\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?>
Another that wont work...
cemail.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<?
if($action == "change") {
if(!$email_cng) { echo "<b>You must enter your New Email!</b>"; exit; }
$email_cng = ($email_cng);
$user = $_SESSION['session_username'];
$query = mysql_query("UPDATE `staff` SET email='$email_cng' WHERE username='$user'") or die(mysql_error());
echo "<font face=verdana size=1>Email Changed";
} else {
echo "
<form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">
<tr><td><font size=\"1\" face=\"Verdana\">Email: <td><input name=\"email_cng\"></td></tr>
<tr><td></td><td><input type=submit value=\"Change Email\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?>
Another that wont work...
missaslot.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
die("Error!!!"); }
include("online.php");?>
<font face="Verdana" size="1">
<b>Miss a Slot</b><br>Can't you make a slot? Do you need someone to cover? Well make sure you send a notice in using this form, 24 hours before you are going to need a cover.<br>Thank You!<p>
<?
$result = mysql_query("SELECT * FROM `staff`");
while($worked = mysql_fetch_array($result)) {
$names = $worked["username"];
$IP = "$REMOTE_ADDR";
$Username = "$session_username";
} if($action == "add") {
$add = mysql_query("INSERT INTO `missslot` ( `Username`, `Time`, `Day`, `Reason`, `Cover`, `ip` ) VALUES ('$Username', '$Time', '$Day', '$Reason', '$Cover', '$IP')");
echo "Thank you $Username - Ashy will now try and find a suitable replacement/cover for your slot...";
} elseif($action == "delete") {
$delete = mysql_query("TRUNCATE TABLE `missslot`");
echo "All requests in the system have been deleted.";
} else {
if($level == "1") { echo "<a href=\"$PHP_SELF?action=delete\">Delete all requests...</a><br>"; }
if($Day == "Choose Day...") { echo "You need to choose a day..."; }
if($Time == "Choose Time...") { echo "You need to choose a time..."; }
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Your DJ Name:</td><td><font face=\"Verdana\" size=\"1\">$Username<input type=\"hidden\" value=\"Username\"></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">Usual Slot Day:</td><td><select size=\"1\" name=\"Day\">
<option value=\"Choose Day...\">Choose Day...</option>
<option value=\"Monday\">Monday</option>
<option value=\"Tuesday\">Tuesday</option>
<option value=\"Wednesday\">Wednesday</option>
<option value=\"Thursday\">Thursday</option>
<option value=\"Friday\">Friday</option>
<option value=\"Saturday\">Saturday</option>
<option value=\"Sunday\">Sunday</option>
</select></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">Usual Slot Time:</td><td><select size=\"1\" name=\"Time\">
<option value=\"Choose Time...\">Choose Time...</option>
<option value=\"9-10 AM\">9-10 AM</option>
<option value=\"10-11 AM\">10-11 AM</option>
<option value=\"11-12 AM\">11-12 AM</option>
<option value=\"12-1 PM\">12-1 PM</option>
<option value=\"1-2 PM\">1-2 PM</option>
<option value=\"2-3 PM\">2-3 PM</option>
<option value=\"3-4 PM\">3-4 PM</option>
<option value=\"4-5 PM\">4-5 PM</option>
<option value=\"5-6 PM\">5-6 PM</option>
<option value=\"6-7 PM\">6-7 PM</option>
<option value=\"7-8 PM\">7-8 PM</option>
<option value=\"8-9 PM\">8-9 PM</option>
<option value=\"9-10 PM\">9-10 PM</option>
<option value=\"10-11 PM\">10-11 PM</option>
<option value=\"11-12 PM\">11-12 PM</option>
<option value=\"12-1 MIDNIGHT HOUR\">12-1 MIDNIGHT</option>
</select></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">Reason:</td><td><textarea rows=\"9\" name=\"Reason\" cols=\"29\"></textarea>
<tr><td><font face=\"Verdana\" size=\"1\">Suggested DJ Cover: <i><br>(Only if they have agreed)</i></td><td><input type=\"text\" name=\"Cover\" size=\"20\">
<tr><td></td><td><input type='submit' name='submit' value='Miss my Slot!'></td></tr>
</form>";
}
?>
Another that wont work...
alerts.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
die("Hmm I Wonder Why You Have Ended Up Here :S"); }
include("online.php");
switch($_GET['act']){
default:
// Alert Data
$alertQuery = mysql_query("SELECT * FROM alert WHERE active='Y'");
$alertData = mysql_fetch_array($alertQuery);
if($alertData[message] !=""){
$Var ="<u>Current Active Alert</u>: $alertData[message] [<a href='alert.php?act=deactivate'>Deactivate</a>]";
}
Echo"
$Var
<form method='post' action='alert.php?act=create'>
<table>
<tr>
<td>Message:</td>
<td><textarea name='message' cols='30' rows='6'></textarea></td>
</tr>
<tr>
<td></td>
<td><input type='submit' value='Create'></td>
</form>";
break;
case"create":
$message = $_POST['message'];
if(empty($message)){
Echo"<b>Error:</b> Please fill out the message.";
exit;
}
mysql_query("UPDATE alert SET active ='N'");
mysql_query("INSERT INTO alert (message,name,active) VALUES ('$message', '$_SESSION[session_username]', 'Y')");
Echo"<b>Alert Added Sucessfully</b><br>
All other alerts have been deactivated. All users will recieve this alert
once, until you deactivate it.";
break;
case"deactivate":
mysql_query("UPDATE alert SET active ='N'");
Echo"<b>Alerts Deactivated</b><br>
All previous alerts have been deactivated.";
break;
}
?>
Another that aint working...
addhellos.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<font face="verdana" size="1"><b>Here You Can Add Someone's Name To The Hellos List Which Is Located On The
Homepage !</b>
<? if($session_level == "9") { echo "You are not of the required level to access this page."; } else { ?>
<?
$ip = "$REMOTE_ADDR";
$message = "$message";
$action = $_GET[action];
if($action == "add") {
$add = mysql_query("INSERT INTO `hellos` ( `message`, `ip`) VALUES ('$message', '$ip')");
echo "Thank You $session_username. $message Has Been Added To The Hellos List !";
} else {
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Name:</td><td><input type='text' name='message' class='button' size='25'></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Say Hello !'></td></tr>
</form>";
}
?>
</font></P>
</font></font></font></font></font>
<? } ?>
Another that aint working...
banasong.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
die("Hmm I Wonder Why You Have Ended Up Here :s"); }
include("online.php");?>
<? if($_SESSION['session_level'] == "1") { ?>
<b><font face="Verdana" size="1">Submit a banned song</font></b><font face="Verdana" size="1"><br>
Here, you can submit a banned song for the DJ's to see.<p>
<?
$today = date("F j, Y");
if($action == "add") {
$add = mysql_query("INSERT INTO `banned_songs` ( `Song`, `From`, `Long`) VALUES ('$Song', '$today', '$Long')");
echo "The banned song has been added to the system";
} elseif($action == "delete") {
$delete = mysql_query("TRUNCATE TABLE `banned_songs`");
echo "All Banned Songs have been DELETED!";
} else {
if($Long == "Choose One...") { echo "You must choose the amount of time you want it to be banned for..."; }
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Song:</td><td><font face=\"Verdana\" size=\"1\"><input type=\"text\" name=\"Song\" size=\"20\"></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">Banned For:</td><td><select size=\"1\" name=\"Long\">
<option value=\"Choose One...\">Choose One...</option>
<option value=\"1 Day\">1 Day</option>
<option value=\"2 Days\">2 Days</option>
<option value=\"3 Days\">3 Days</option>
<option value=\"4 Days\">4 Days</option>
<option value=\"5 Days\">5 Days</option>
<option value=\"6 Days\">6 Days</option>
<option value=\"1 Week\">1 Week</option>
<option value=\"2 Weeks\">2 Weeks</option>
<option value=\"3 Weeks\">3 Weeks</option>
<option value=\"1 Month\">1 Month</option>
<option value=\"2 Months\">2 Months</option>
<option value=\"3 Months\">3 Months</option>
<option value=\"Forever\">Forever</option>
</select></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Ban This Song'></td></tr>
</form>";
}
} ?>
Another that aint working...
addnews.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<font face="verdana" size="1">
<? if($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?>
<?
$IP = "$REMOTE_ADDR";
$NoticeUsername = "$session_username";
if($action == "add") {
$add = mysql_query("INSERT INTO `news` ( `NoticeUsername`, `NoticeMessage`, `IP`, `NoticeDAT`, `NoticeTitle`) VALUES ('$NoticeUsername', '$NoticeMessage', '$IP', '$NoticeDAT', '$NoticeTitle')");
echo "Thank you $session_username. Your notice has been posted.";
} else {
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Poster Name:</td><td><font face=\"verdana\" size=\"1\">$session_username</td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">News Title:</td><td><input type='text' name='NoticeTitle' class='button' size='25'></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">News Date:</td><td><input type='text' name='NoticeDAT' class='button' size='25'></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">News Message:</td><td><input type='text' name='NoticeMessage' class='button' size='25'></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Post'></td></tr>
</form>";
}
?>
</font></P>
</font></font></font></font></font>
<? } ?>
Another that aint working..
editpass.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "An Error Has Occured. Please log in again or contact your webmaster.";
exit; } ?>
<? if($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?>
<font size="1" face="Verdana">Here You Can Edit Any Users Password By Typing In Their Name And A NEW Password.</font>
<?
if($action == "change") {
if(!$username) { echo "<b>You must enter a username!</b>"; exit; }
$password = ($password);
$username = ($username);
$query = mysql_query("UPDATE `staff` SET password='$password' WHERE username='$username'") or die(mysql_error());
echo "<font face=verdana size=1><br><br>The users account has been edited.";
} else {
echo "
<p align=`centre`><form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">
<tr><td><font size=\"1\" face=\"Verdana\">Username:<td><input name=\"username\"></td></tr>
<tr><td><font size=\"1\" face=\"Verdana\">New Password:<td><input name=\"password\"></td></tr>
<tr><td></td><td><input type=submit value=\"Edit Password\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?><? } ?>
another that aint working - lol ? - Bored yet ?
editlevel.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "An Error Has Occured. Please log in again or contact your webmaster.";
exit; } ?>
<? if($_SESSION['session_level'] == "1") { ?>
<?
if($action == "change") {
if(!$username) { echo "<b>You must enter a username!</b>"; exit; }
$level_cng = ($level_cng);
$username = ($username);
$query = mysql_query("UPDATE `staff` SET level='$level_cng' WHERE username='$username'") or die(mysql_error());
echo "<font face=verdana size=1><br><br>The users account has been edited.";
} else {
echo "
<p align=`centre`><form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">
<tr><td><font size=\"1\" face=\"Verdana\">Username:<td><input name=\"username\"></td></tr>
<tr><td><font face=\"verdana\" size=\"1\">Set Lock:</td><td><font face=\"verdana\" size=\"1\"><select name=\"level_cng\">
<option value=\"4\">Pixel Artist</option>
<option value=\"3\">Senior DJ</option>
<option value=\"2\">DJ</option>
<option value=\"1\">Administrator</option>
<tr><td></td><td><input type=submit value=\"Edit User Level\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?>
<? } ?>
Another not working - Lmao. Sorry xD
editemail.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "An Error Has Occured. Please log in again or contact your webmaster.";
exit; } ?>
<? if($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?>
<font size="1" face="Verdana">Here You Can Edit A Users Email Address By Typing Their Username And A New Email Address !</font>
<?
if($action == "change") {
if(!$username) { echo "<b>You must enter a username!</b>"; exit; }
$email = ($email);
$username = ($username);
$query = mysql_query("UPDATE `staff` SET email='$email' WHERE username='$username'") or die(mysql_error());
echo "<font face=verdana size=1><br><br>The users account has been edited.";
} else {
echo "
<p align=`centre`><form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">
<tr><td><font size=\"1\" face=\"Verdana\">Username:<td><input name=\"username\"></td></tr>
<tr><td><font size=\"1\" face=\"Verdana\">New Email:<td><input name=\"email\"></td></tr>
<tr><td></td><td><input type=submit value=\"Edit email\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?><? } ?>
Another not working...
changehabbo.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "An Error Has Occured. Please log in again or contact your webmaster.";
exit; } ?>
<? if($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?>
<font size="1" face="Verdana">Here You Can Edit Any Users Habbo Name By Typing In Their Name And A NEW Habbo Name.</font>
<?
if($action == "change") {
if(!$username) { echo "<b>You must enter a username!</b>"; exit; }
$habboname = ($habboname);
$username = ($username);
$query = mysql_query("UPDATE `staff` SET habboname='$habboname' WHERE username='$username'") or die(mysql_error());
echo "<font face=verdana size=1><br><br>The users Habbo Name has been edited";
} else {
echo "
<p align=`centre`><form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">
<tr><td><font size=\"1\" face=\"Verdana\">Username:<td><input name=\"username\"></td></tr>
<tr><td><font size=\"1\" face=\"Verdana\">New Habbo Name:<td><input name=\"habboname\"></td></tr>
<tr><td></td><td><input type=submit value=\"Edit Habbo Name\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?><? } ?>
And another not working... Thanks if youve done this far :)
addtopnotice.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<font face="verdana" size="1">
<? if($_SESSION['session_level'] == "1") { ?>
<font size="1" face="Verdana">Here You Can Add A Notice To The Top Of The Staff Panel (Note: Please Use This Appropriately Or Your Account Will Be Suspended)</font>
<?
$IP = "$REMOTE_ADDR";
if($action == "add") {
$add = mysql_query("INSERT INTO `topnotices` ( `NoticeMessage`, `IP`) VALUES ('$NoticeMessage', '$IP')");
echo "<br><br>Thank you $session_username. Your notice has been posted.";
} else {
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Notice Message:</td><td><input type='text' name='NoticeMessage' class='button' size='25'></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Post Notice'></td></tr>
</form>";
}
?>
</font></P>
</font>
<? } ?>
<font size="1" face="Verdana"><b>Only 3 Announcements Should Display At Once So Please Click Remove Notice To Remove One Of Them Before You Post A New One !</b></font>
<br><br><br>
Another not working , sorry :(
addofficialdj.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<font face="verdana" size="1">
<? if($_SESSION['session_level'] == "1") { ?>
<font size="1" face="Verdana">Here You Can Add A DJ To The Official List (Normally Trialests If They Pass Their Trial)</font>
<?
$IP = "$REMOTE_ADDR";
if($action == "add") {
$add = mysql_query("INSERT INTO `officialdjs` ( `NoticeMessage`, `IP`) VALUES ('$NoticeMessage', '$IP')");
echo "<br><br>Thank You $session_username. Your Official DJ Has Been Added.";
} else {
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Official DJ Name:</td><td><input type='text' name='NoticeMessage' class='button' size='25'></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Add Official DJ'></td></tr>
</form>";
}
?>
</font></P>
</font>
<? } ?>
Another :(
addradioinfo.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<font face="verdana" size="1"><b>Here You Can Update The Radio Information For Winamp/Shoutcast/SAM2</b><br>(Please Be Sure To Delete The Old Radio Information Before Adding The New Radio Information !)
<? if($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?>
<?
$Radio_IP = "$Radio_IP";
$Radio_Port = "$Radio_Port";
$Radio_Password = "$Radio_Password";
if($action == "add") {
$add = mysql_query("INSERT INTO `radioinfo` ( `Radio_IP`, `Radio_Port`, `Radio_Password`) VALUES ('$Radio_IP', '$Radio_Port', '$Radio_Password')");
echo "<br><br>The Radio Information Has Been Updated !";
} else {
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Radio IP:</td><td><input type='text' name='Radio_IP' class='button' size='25'></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">Radio Port:</td><td><input type='text' name='Radio_Port' class='button' size='25'></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">Radio Password:</td><td><input type='text' name='Radio_Password' class='button' size='25'></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Update'></td></tr>
</form>";
}
?>
</font></P>
</font></font></font></font></font>
<? } ?>
Nearlly ended now...
addsitenews.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "ERROR!!!";
exit; } ?>
<font face="verdana" size="1">
<? if($session_level == "1" or $session_level == "3") { ?>
<?
$IP = "$REMOTE_ADDR";
$NoticeUsername = "$session_username";
if($action == "add") {
$add = mysql_query("INSERT INTO `sitenews` ( `NoticeUsername`, `NoticeMessage`, `IP`, `NoticeDAT`, `NoticeTIM`, `NoticeTitle`) VALUES ('$NoticeUsername', '$NoticeMessage', '$IP', '$NoticeDAT', '$NoticeTIM', '$NoticeTitle')");
echo "Thank you $session_username. Your notice has been posted.";
} else {
$date = date("d.m.y - H:i:s");
$today = date("m/d/y");
$time = date("g:i A");
echo "<form method='post' action='$PHP_SELF?action=add'>
<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">
<tr><td><font face=\"Verdana\" size=\"1\">Poster Name:</td><td><font face=\"verdana\" size=\"1\">$session_username</td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">News Title:</td><td><input type='text' name='NoticeTitle' class='button' size='25'></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">News Date:</td><td><input type='text' name='NoticeDAT' class='button' size='25' value='$today'></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">News Time:</td><td><input type='text' name='NoticeTIM' class='button' size='25' value='$time'></td></tr>
<tr><td><font face=\"Verdana\" size=\"1\">News Message:</td><td><textarea rows=\"7\" name=\"NoticeMessage\" class=\"button\" cols=\"20\"></textarea></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Post'></td></tr>
</form>";
}
?>
</font></P>
</font></font></font></font></font>
<? }else{
echo ("Im Sorry, You are not either an administrator or a Reporter! Please Leave");
}
?>
Last one...
unban.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
echo "An Error Has Occured. Please log in again or contact your webmaster.";
exit; }
$result = mysql_query("SELECT * FROM `staff`");
$worked = mysql_fetch_array($result);
$username9 = $worked["username"];
?>
<? if($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?>
<font size="1" face="Verdana">Here You Can Unban A User If They Are Banned Or After A Suspension Has Expired !</font>
<?
if($action == "change") {
if(!$username) { echo "<b>You must enter a username!</b>"; exit; }
$kick = ($kick);
$username = ($username);
$query = mysql_query("UPDATE `users_online` SET kick='$kick' WHERE username='$username'") or die(mysql_error());
echo "<font face=verdana size=1><br><br>The users account has been edited.";
} else {
echo "
<p align=`centre`><form method=post action=\"$PHP_SELF?action=change\">
<table border=\"0\">";
?><font size="1" face="Verdana">Username:</font><?
echo "<font size=\"1\" face=\"Verdana\"><select size='1' name='username'>
<option selected>Choose Your Name</option>";
include('dbConfig.php');
$result = mysql_query("SELECT * FROM `staff`");
while($worked = mysql_fetch_array($result)) {
$username = $worked["username"];
echo "<option value=$username>DJ $username</option></font>";
}
mysql_close(); ?><?
echo"
<tr><td><font size=\"1\" face=\"Verdana\">Ban level:<td><input name=\"Ban Level\"></td></tr>
<tr><td></td><td><input type=submit value=\"Unban\" accesskey=\"s\"></td></tr>
</table>
</form>"; }
?><? } ?>
Thats about ti for the standard pannel, however the timetable is completely annihalated too :(
an example of the timetable code, so maybe you can suggest why
adminmonday.php
<? session_start();
include 'dbConfig.php';
$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user
if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {
//if the username is not set or the session username is empty or the ip does not match the session ip log them out
session_unset(); //clears firefox
session_destroy(); //clears IE
die("Error!!!"); }
include("online.php");?>
<? if($_SESSION['session_level'] == "1") { ?>
<?php
include ("dbConfig.php");
$query = "SELECT * FROM monday";
$result = mysql_query($query);
$update = $_GET['update'];
$num = mysql_numrows($result);
$user = $_SESSION['session_username'];
$i = 0;
while($i < $num){
$a = mysql_result($result,$i,"a");
$b = mysql_result($result,$i,"b");
$c = mysql_result($result,$i,"c");
$d = mysql_result($result,$i,"d");
$e = mysql_result($result,$i,"e");
$f = mysql_result($result,$i,"f");
$g = mysql_result($result,$i,"g");
$x = mysql_result($result,$i,"x");
$h = mysql_result($result,$i,"h");
$ti = mysql_result($result,$i,"i");
$j = mysql_result($result,$i,"j");
$k = mysql_result($result,$i,"k");
$l = mysql_result($result,$i,"l");
$m = mysql_result($result,$i,"m");
$n = mysql_result($result,$i,"n");
$o = mysql_result($result,$i,"o");
$p = mysql_result($result,$i,"p");
$q = mysql_result($result,$i,"q");
$r = mysql_result($result,$i,"r");
$s = mysql_result($result,$i,"s");
$t = mysql_result($result,$i,"t");
$u = mysql_result($result,$i,"u");
$v = mysql_result($result,$i,"v");
$w = mysql_result($result,$i,"w");
$i++;
}
$update = $_GET['update'];
$delete = $_GET['delete'];
?>
<html>
<head><title>radio habbo Staff Control Panel: Slot Booking</title>
<script language="JavaScript">
function confirm_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=clear';
}
}
function unbooka_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=ra';
}
}
function unbookb_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rb';
}
}
function unbookc_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rc';
}
}
function unbookd_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rd';
}
}
function unbooke_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=re';
}
}
function unbookf_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rf';
}
}
function unbookg_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rg';
}
}
function unbookx_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rx';
}
}
function unbookh_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rh';
}
}
function unbooki_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=ri';
}
}
function unbookj_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rj';
}
}
function unbookk_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rk';
}
}
function unbookl_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rl';
}
}
function unbookm_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rm';
}
}
function unbookn_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rn';
}
}
function unbooko_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=ro';
}
}
function unbookp_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rp';
}
}
function unbookq_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rq';
}
}
function unbookr_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rr';
}
}
function unbooks_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rs';
}
}
function unbookt_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rt';
}
}
function unbooku_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=ru';
}
}
function unbookv_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rv';
}
}
function unbookw_prompt(text) {
if (confirm(text)) {
window.location = 'adminmonday.php?update=rw';
}
}
</script>
</head>
<link href="../staff/style.css" rel="stylesheet" type="text/css">
<body>
<p align="left" class="heading"><font face="Verdana" size="1"><u><b>Book Your Monday Shows</b></u></p></font>
<p align="left" class="main"><font face="Verdana" size="1">This Is Where You Can Book Your Slots For The Day Listed Above.<br>To Book A Slot Please Just Click Book Under A Slot You Can Make.<br><br><b>If You Can't Make Your Slot Then Click On Your Name On The Slot You Booked And It Will Automatically Unbook It.<br>If You Don't Unbook Your Slot You Will Be Warned !</b><br><br><? echo "$user"; ?> As A Member Of The Management Team You Have The Power To Clear The Whole Day After It Has Been Done But Please ONLY Clear The Whole Day At The End Of Each Week By Clicking Clear At The Bottom.<br>You Also Have The Power To Remove Other DJ's Slots !<br>
<br>
</font>
<center>
<font face="Verdana" size="1">
<a href="#" onClick="window.history.go(-1)">Go Back ?</a> ~ <a href="javascript:location.reload(true)">Refresh ?</a>
</font>
<table border="1" bordercolor="#000000" width="45%" class="main"
cellpadding="2" cellspacing="0">
<tr>
<td width=100 align="center"><font face="Verdana" size="1">00:00 - 01:00</font></td>
<td><font face="Verdana" size="1"><?php if($a == ''){
echo"<a href=adminmonday.php?update=a> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"a");
$i++;
}
echo "<a href=\"\" onclick=\"unbooka_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $a</a>";
}
?>
</font>
</td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">01:00 - 02:00</font></td>
<td><font face="Verdana" size="1"><?php if($b == ''){
echo"<a href=adminmonday.php?update=b> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"b");
$i++;
}
echo "<a href=\"\" onclick=\"unbookb_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $b</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">02:00 - 03:00</font></td>
<td><font face="Verdana" size="1"><?php if($c == ''){
echo"<a href=adminmonday.php?update=c> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"c");
$i++;
}
echo "<a href=\"\" onclick=\"unbookc_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $c</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">03:00 - 04:00</font></td>
<td><font face="Verdana" size="1"><?php if($d == ''){
echo"<a href=adminmonday.php?update=d> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"d");
$i++;
}
echo "<a href=\"\" onclick=\"unbookd_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $d</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">04:00 - 05:00</font></td>
<td><font face="Verdana" size="1"><?php if($e == ''){
echo"<a href=adminmonday.php?update=e> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"e");
$i++;
}
echo "<a href=\"\" onclick=\"unbooke_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $e</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">05:00 - 06:00</font></td>
<td><font face="Verdana" size="1"><?php if($f == ''){
echo"<a href=adminmonday.php?update=f> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"f");
$i++;
}
echo "<a href=\"\" onclick=\"unbookf_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $f</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">06:00 - 07:00</font></td>
<td><font face="Verdana" size="1"><?php if($g == ''){
echo"<a href=adminmonday.php?update=g> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"g");
$i++;
}
echo "<a href=\"\" onclick=\"unbookg_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $g</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">07:00 - 08:00</font></td>
<td><font face="Verdana" size="1"><?php if($x == ''){
echo"<a href=adminmonday.php?update=x> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"x");
$i++;
}
echo "<a href=\"\" onclick=\"unbookx_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $x</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">08:00 - 09:00</font></td>
<td><font face="Verdana" size="1"><?php if($h == ''){
echo"<a href=adminmonday.php?update=h> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"h");
$i++;
}
echo "<a href=\"\" onclick=\"unbookh_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $h</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">09:00 - 10:00</font></td>
<td><font face="Verdana" size="1"><?php if($ti == ''){
echo"<a href=adminmonday.php?update=i> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"i");
$i++;
}
echo "<a href=\"\" onclick=\"unbooki_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $ti</a>";
}
?></font></td>
</tr>
<tr>
<td width="100" align="center"><font face="Verdana" size="1">10:00 - 11:00</font></td>
<td><font face="Verdana" size="1"><?php if($j == ''){
echo"<a href=adminmonday.php?update=j> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"j");
$i++;
}
echo "<a href=\"\" onclick=\"unbookj_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $j</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">11:00 - 12:00</font></td>
<td><font face="Verdana" size="1"><?php if($k == ''){
echo"<a href=adminmonday.php?update=k> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"k");
$i++;
}
echo "<a href=\"\" onclick=\"unbookk_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $k</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">12:00 - 13:00</font></td>
<td><font face="Verdana" size="1"><?php if($l == ''){
echo"<a href=adminmonday.php?update=l> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"l");
$i++;
}
echo "<a href=\"\" onclick=\"unbookl_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $l</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">13:00 - 14:00</font></td>
<td><font face="Verdana" size="1"><?php if($m == ''){
echo"<a href=adminmonday.php?update=m> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"m");
$i++;
}
echo "<a href=\"\" onclick=\"unbookm_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $m</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">14:00 - 15:00</font></td>
<td><font face="Verdana" size="1"><?php if($n == ''){
echo"<a href=adminmonday.php?update=n> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"n");
$i++;
}
echo "<a href=\"\" onclick=\"unbookn_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $n</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">15:00 - 16:00</font></td>
<td><font face="Verdana" size="1"><?php if($o == ''){
echo"<a href=adminmonday.php?update=o> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"o");
$i++;
}
echo "<a href=\"\" onclick=\"unbooko_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $o</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">16:00 - 17:00</font></td>
<td><font face="Verdana" size="1"><?php if($p == ''){
echo"<a href=adminmonday.php?update=p> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"p");
$i++;
}
echo "<a href=\"\" onclick=\"unbookp_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $p</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">17:00 - 18:00</font></td>
<td><font face="Verdana" size="1"><?php if($q == ''){
echo"<a href=adminmonday.php?update=q> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"q");
$i++;
}
echo "<a href=\"\" onclick=\"unbookq_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $q</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">18:00 - 19:00</font></td>
<td><font face="Verdana" size="1"><?php if($r == ''){
echo"<a href=adminmonday.php?update=r> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"r");
$i++;
}
echo "<a href=\"\" onclick=\"unbookr_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $r</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">19:00 - 20:00</font></td>
<td><font face="Verdana" size="1"><?php if($s == ''){
echo"<a href=adminmonday.php?update=s> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"s");
$i++;
}
echo "<a href=\"\" onclick=\"unbooks_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $s</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">20:00 - 21:00</font></td>
<td><font face="Verdana" size="1"><?php if($t == ''){
echo"<a href=adminmonday.php?update=t> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"t");
$i++;
}
echo "<a href=\"\" onclick=\"unbookt_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $t</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">21:00 - 22:00</font></td>
<td><font face="Verdana" size="1"><?php if($u == ''){
echo"<a href=adminmonday.php?update=u> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"u");
$i++;
}
echo "<a href=\"\" onclick=\"unbooku_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $u</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">22:00 - 23:00</font></td>
<td><font face="Verdana" size="1"><?php if($v == ''){
echo"<a href=adminmonday.php?update=v> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"v");
$i++;
}
echo "<a href=\"\" onclick=\"unbookv_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $v</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center"><font face="Verdana" size="1">23:00 - 00:00</font></td>
<td><font face="Verdana" size="1"><?php if($w == ''){
echo"<a href=adminmonday.php?update=w> Book this Slot</a>";
}
else{
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"w");
$i++;
}
echo "<a href=\"\" onclick=\"unbookw_prompt('Are you SURE you want to unbook this slot?'); return false;\"> $w</a>";
}
?></font></td>
</tr>
<tr>
<td width=100 align="center">
<font face="Verdana" size="1">
<?php
echo "<a href=\"\" onclick=\"confirm_prompt('Are you SURE you want to Clear all slots?'); return false;\">Clear</a>";
?>
</font>
</td>
<td> </td>
</tr>
</table></center>
</body>
<?php
if ($update == a){
$check = mysql_query("SELECT a FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET a='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == b){
$check = mysql_query("SELECT b FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET b='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == c){
$check = mysql_query("SELECT c FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET c='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == d){
$check = mysql_query("SELECT d FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET d='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == e){
$check = mysql_query("SELECT e FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET e='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == f){
$check = mysql_query("SELECT f FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET f='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == g){
$check = mysql_query("SELECT g FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET g='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == x){
$check = mysql_query("SELECT x FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET x='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == h){
$check = mysql_query("SELECT h FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET h='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == i){
$check = mysql_query("SELECT i FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET i='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == j){
$check = mysql_query("SELECT j FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET j='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == k){
$check = mysql_query("SELECT k FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET k='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == l){
$check = mysql_query("SELECT l FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET l='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == m){
$check = mysql_query("SELECT m FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET m='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == n){
$check = mysql_query("SELECT n FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET n='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == o){
$check = mysql_query("SELECT o FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET o='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == p){
$check = mysql_query("SELECT p FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET p='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == q){
$check = mysql_query("SELECT q FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET q='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == r){
$check = mysql_query("SELECT r FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET r='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == s){
$check = mysql_query("SELECT s FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET s='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == t){
$check = mysql_query("SELECT t FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET t='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == u){
$check = mysql_query("SELECT u FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET u='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == v){
$check = mysql_query("SELECT v FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET v='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == w){
$check = mysql_query("SELECT w FROM monday WHERE id='1'");
if (!$check == ''){
mysql_query("UPDATE monday SET w='$user'");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
else{
echo "Sorry, This has already been booked";
}
}
elseif ($update == ra){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"a");
$i++;
}
mysql_query("UPDATE monday SET a=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rb){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"b");
$i++;
}
mysql_query("UPDATE monday SET b=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rc){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"c");
$i++;
}
mysql_query("UPDATE monday SET c=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rd){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"d");
$i++;
}
mysql_query("UPDATE monday SET d=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == re){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"e");
$i++;
}
mysql_query("UPDATE monday SET e=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rf){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"f");
$i++;
}
mysql_query("UPDATE monday SET f=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rx){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"x");
$i++;
}
mysql_query("UPDATE monday SET x=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rg){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"g");
$i++;
}
mysql_query("UPDATE monday SET g=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rh){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"h");
$i++;
}
mysql_query("UPDATE monday SET h=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == ri){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"i");
$i++;
}
mysql_query("UPDATE monday SET i=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rj){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"j");
$i++;
}
mysql_query("UPDATE monday SET j=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rk){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"k");
$i++;
}
mysql_query("UPDATE monday SET k=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rl){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"l");
$i++;
}
mysql_query("UPDATE monday SET l=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rm){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"m");
$i++;
}
mysql_query("UPDATE monday SET m=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rn){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"n");
$i++;
}
mysql_query("UPDATE monday SET n=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == ro){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"o");
$i++;
}
mysql_query("UPDATE monday SET o=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rp){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"p");
$i++;
}
mysql_query("UPDATE monday SET p=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rq){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"q");
$i++;
}
mysql_query("UPDATE monday SET q=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rr){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"r");
$i++;
}
mysql_query("UPDATE monday SET r=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rs){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"s");
$i++;
}
mysql_query("UPDATE monday SET s=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rt){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"t");
$i++;
}
mysql_query("UPDATE monday SET t=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == ru){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"u");
$i++;
}
mysql_query("UPDATE monday SET u=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rv){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"v");
$i++;
}
mysql_query("UPDATE monday SET v=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == rw){
$num = mysql_numrows($result);
$i = 0;
while($i < $num){
$check = mysql_result($result,$i,"w");
$i++;
}
mysql_query("UPDATE monday SET w=''");
echo "<script language=\"javascript\">
<!--
location.replace(\"adminmonday.php\");
-->
</script>";
}
elseif ($update == clear){
$get = mysql_query("SELECT * FROM permmonday");
$i = 0;
$num = mysql_num_rows($get);
while ($i < $num){
$a = mysql_result($get,$i,"a");
$b = mysql_result($get,$i,"b");
$c = mysql_result($get,$i,"c");
$d = mysql_result($get,$i,"d");
$e = mysql_result($get,$i,"e");
$f = mysql_result($get,$i,"f");
$g = mysql_result($get,$i,"g");
$h = mysql_result($get,$i,"h");
$ti = mysql_result($get,$i,"i");
$j = mysql_result($get,$i,"j");
$k = mysql_result($get,$i,"k");
$l = mysql_result($get,$i,"l");
$m = mysql_result($get,$i,"m");
$n = mysql_result($get,$i,"n");
$o = mysql_result($get,$i,"o");
$p = mysql_result($get,$i,"p");
$q = mysql_result($get,$i,"q");
$r = mysql_result($get,$i,"r");
$s = mysql_result($get,$i,"s");
$t = mysql_result($get,$i,"t");
$u = mysql_result($get,$i,"u");
$v = mysql_result($get,$i,"v");
$w = mysql_result($get,$i,"w");
$x = mysql_result($get,$i,"x");
mysql_query("UPDATE monday SET a='$a',b='$b',c='$d',d='$d',e='$e',f='$f',g='$g',h ='$h',i='$ti',j='$j',k='$k',l='$l',m='$m',n='$n',o ='$o',p='$p',q='$q',r='$r',s='$s',t='$t',u='$u',v= '$v',w='$w',x='$x'");
$i++;
}
echo "Cleared";
}
}?>
Whenever i click the links to book slots, it simply refreshes the same and doesnt book the spots. Help would be appreictaed.
I knwo the size of the task is extensive, any help would be repped in return. Thankyou, especially dentifrice ! Your a star...
Thanks any who help :)