???PHP Code:if($action == "register") {
include ("dbConfig.php");
if(!$username_register || !$password_register) { echo "<br><br><b>You must enter a username and password!</b>"; exit; }
$password_register = ($password_register);
$username_register = ($username_register);
$query = mysql_query("INSERT INTO `staff` (`username`, `password`, `email`, `level`) VALUES('$username_register', '$password_register', '$email_register', '$level_register')") or die("<br><b><font face=verdana size=1>Error: User not added to database.</b><br>
You have got this error becuase the name you have chosen is being used by a current member or we cannot connect to the database, please try a different name or try again later");
Results 11 to 14 of 14
-
10-01-2007, 04:56 PM #11
-
PHP Code:
$action = $_GET[action];
if($action == "register") {
include ("dbConfig.php");
$password_register = $_POST[password_register];
$username_register= $_POST[username_register];
if(!$username_register || !$password_register) { echo "<br><br><b>You must enter a username and password!</b>"; exit; }
$password_register = ($password_register);
$username_register = ($username_register);
$query = mysql_query("INSERT INTO `staff` (`username`, `password`, `email`, `level`) VALUES('$username_register', '$password_register', '$email_register', '$level_register')") or die("<br><b><font face=verdana size=1>Error: User not added to database.</b><br>
You have got this error becuase the name you have chosen is being used by a current member or we cannot connect to the database, please try a different name or try again later");
-
PHP Code:
$action = $_GET[action];
if($action == "register") {
include ("dbConfig.php");
$password_register = $_POST[password_register];
$username_register= $_POST[username_register];
if(!$username_register || !$password_register) { echo "<br><br><b>You must enter a username and password!</b>"; exit; }
$password_register = ($password_register);
$username_register = ($username_register);
$query = mysql_query("INSERT INTO `staff` (`username`, `password`, `email`, `level`) VALUES('$username_register', '$password_register', '$email_register', '$level_register')") or die("<br><b><font face=verdana size=1>Error: User not added to database.</b><br>
You have got this error becuase the name you have chosen is being used by a current member or we cannot connect to the database, please try a different name or try again later");
-
Thanks so much ! - It actaully works now...
Dont suppose you could fix ther next 100 too
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
Another that wont work...Code:<? 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>"; } ?>
habboname.php
Another that wont work...Code:<? 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>"; } ?>
cemail.php
Another that wont work...Code:<? 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>"; } ?>
missaslot.php
Another that wont work...Code:<? 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>"; } ?>
alerts.php
Another that aint working...Code:<? 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; } ?>
addhellos.php
Another that aint working...Code:<? 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> <? } ?>
banasong.php
Another that aint working...Code:<? 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>"; } } ?>
addnews.php
Another that aint working..Code:<? 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> <? } ?>
editpass.php
another that aint working - lol ? - Bored yet ?Code:<? 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>"; } ?><? } ?>
editlevel.php
Another not working - Lmao. SorryCode:<? 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>"; } ?> <? } ?>
editemail.php
Another not working...Code:<? 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>"; } ?><? } ?>
changehabbo.php
And another not working... Thanks if youve done this farCode:<? 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>"; } ?><? } ?>
addtopnotice.php
Another not working , sorryCode:<? 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>
addofficialdj.php
AnotherCode:<? 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> <? } ?>
addradioinfo.php
Nearlly ended now...Code:<? 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> <? } ?>
addsitenews.php
Last one...Code:<? 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"); } ?>
unban.php
Thats about ti for the standard pannel, however the timetable is completely annihalated tooCode:<? 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>"; } ?><? } ?>
an example of the timetable code, so maybe you can suggest why
adminmonday.php
Whenever i click the links to book slots, it simply refreshes the same and doesnt book the spots. Help would be appreictaed.Code:<? 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"; } }?>
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
Hosting / Shoutcast / Domains / Web Design
VPS / Dedis / Gaming Servers(Coming Soon)
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts