DJ Panel not Adding Users ? :S

[Lilian]

Yes my DJ Panel will not add users for so strange reason.

What happens is when you click submit it practially just refreshs the form and doesnt add the user.

Can anyone help?

[Matt,]

What panell are you using?

[Jackboy]

probs radiopanel.co.uk rofl

[Rockstar]

Yes Probely :@ Their Like :eusa_wall

[Matt,]

Lol i nearly brought that gaes ago now im wating for atomicoxide

[D351royer]

Stop Slating tom, just because he can code, and kosmic you don't know what the hell php or mysql is, so you shouldn't buy the panel if you don't think you can use it, and jack stop Trying to slate tom, you may be making apanel, but sureley, you should just keep your gob shut, because people won't buy ures or download it if they think the maker is a ****.

[ScottDiamond]

ROFL AT THE GUY ABOVE.

How about you get your head out your *** and realise what the threads about?

Anyway, You could tell us what panel it is ;)

[D351royer]

The guy above? How long hve u been on this forum for if you had been on it for long enough you would realise i eint just "the guy above" none disses me right? So get ure head sorted out.

[ScottDiamond]

Rofl, what you gonna do? Chuck me into your MySQL Database? Learn that its the internet "the guy above".

Anyway, !Lily, is it a RadioPanel Panel?

[D351royer]

Belive, me. i can do allot. do everyone a favour and **** of coz i am coz i cant be assed to argue with you.

[ScottDiamond]

Lol, here comes the text talk. :l

On-Topic: I recommend getting a different DJ Panel.

[Jackboy]

Lol i nearly brought that gaes ago now im wating for atomicoxide

Good choice :P


Stop Slating tom, just because he can code, and kosmic you don't know what the hell php or mysql is, so you shouldn't buy the panel if you don't think you can use it, and jack stop Trying to slate tom, you may be making apanel, but sureley, you should just keep your gob shut, because people won't buy ures or download it if they think the maker is a ****.

very sorry for "slating tom".

How did i slate Tom?

I said

probs radiopanel.co.uk rofl

Im not personally being mean to him. Im just saying that the radiopanel.co.uk business is not very good

[Lilian]

Lol i aint that cheap...

No its not RadioPanel.co.uk

heres the code it might help:


<? 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($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?><font face="Verdana" size="1">Here
you can add a user. The user will automatically be able to login.<p>

<?

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 = md5($password_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");



echo "<font face=verdana size=1>Account Created";

} else {

echo "<form method=post action=?action=register>

<table border=0>

<tr><td><font face=verdana size=1>Username:</td><td><input name=username_register MAXLENGTH=16></td></tr>

<tr><td><font face=verdana size=1>Email Address:</td><td><input name=email_register></td></tr>

<tr><td><font face=verdanasize=1>Password: <td><input name=password_register></td></tr>

<tr><td><font face=verdana size=1>Level:</td><td><font face=verdana size=1><select name=level_register>

<option value=5>Reporter</option><option value=3>Senior DJ</option>

<option value=2>DJ</option>

<option value=1>Admin</option>

</select></td></tr>

<tr><td></td><td><input type=submit value= Add User accesskey=s></td></tr>

</table>

</form>"; }

} ?>

</font>

[Jackboy]

Replace this:


<?

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 = md5($password_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");



echo "<font face=verdana size=1>Account Created";

} else {

echo "<form method=post action=?action=register>

<table border=0>

<tr><td><font face=verdana size=1>Username:</td><td><input name=username_register MAXLENGTH=16></td></tr>

<tr><td><font face=verdana size=1>Email Address:</td><td><input name=email_register></td></tr>

<tr><td><font face=verdanasize=1>Password: <td><input name=password_register></td></tr>

<tr><td><font face=verdana size=1>Level:</td><td><font face=verdana size=1><select name=level_register>

<option value=5>Reporter</option><option value=3>Senior DJ</option>

<option value=2>DJ</option>

<option value=1>Admin</option>

</select></td></tr>

<tr><td></td><td><input type=submit value= Add User accesskey=s></td></tr>

</table>

</form>"; }

} ?>



With this:



<?

if($_get[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 = md5($password_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");



echo "<font face=verdana size=1>Account Created";

} else {

echo "<form method=post action=?action=register>

<table border=0>

<tr><td><font face=verdana size=1>Username:</td><td><input name=username_register MAXLENGTH=16></td></tr>

<tr><td><font face=verdana size=1>Email Address:</td><td><input name=email_register></td></tr>

<tr><td><font face=verdanasize=1>Password: <td><input name=password_register></td></tr>

<tr><td><font face=verdana size=1>Level:</td><td><font face=verdana size=1><select name=level_register>

<option value=5>Reporter</option><option value=3>Senior DJ</option>

<option value=2>DJ</option>

<option value=1>Admin</option>

</select></td></tr>

<tr><td></td><td><input type=submit value= Add User accesskey=s></td></tr>

</table>

</form>"; }

} ?>

[Lilian]

Parse error: syntax error, unexpected '}' in /home/habbile/public_html/staff/DJ/add_user.php on line 47

[Jackboy]

Just try this:



<? 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($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?><font face="Verdana" size="1">Here
you can add a user. The user will automatically be able to login.<p>

<?

if($_get[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 = md5($password_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");



echo "<font face=verdana size=1>Account Created";

} else {

echo "<form method=post action=?action=register>

<table border=0>

<tr><td><font face=verdana size=1>Username:</td><td><input name=username_register MAXLENGTH=16></td></tr>

<tr><td><font face=verdana size=1>Email Address:</td><td><input name=email_register></td></tr>

<tr><td><font face=verdanasize=1>Password: <td><input name=password_register></td></tr>

<tr><td><font face=verdana size=1>Level:</td><td><font face=verdana size=1><select name=level_register>

<option value=5>Reporter</option><option value=3>Senior DJ</option>

<option value=2>DJ</option>

<option value=1>Admin</option>

</select></td></tr>

<tr><td></td><td><input type=submit value= Add User accesskey=s></td></tr>

</table>

</form>"; }

} ?>

</font>

[Lilian]

Ok its working accept when I try and add users it just doesnt submit this was my first problem i needed help with all it does really is refresh the form!

[Jackboy]

It looks like a well mucked up 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($session_level == "3") { echo "You are not of the required level to access this page."; } else { ?><font face="Verdana" size="1">Here
you can add a user. The user will automatically be able to login.<p>

<?

if($_get[action] == "register") {

include ("dbConfig.php");
$username_register = '$_POST[username_register]';
$password_register = '$_POST[password_register]';
$email_register = '$_POST[email_register]';
$level_register = '$_POST[level_register]';
if(!$username_register || !$password_register) { echo "<br><br><b>You must enter a username and password!</b>"; exit; }

$password_register = md5($password_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");



echo "<font face=verdana size=1>Account Created";

} else {

echo "<form method=post action=?action=register>

<table border=0>

<tr><td><font face=verdana size=1>Username:</td><td><input name=username_register MAXLENGTH=16></td></tr>

<tr><td><font face=verdana size=1>Email Address:</td><td><input name=email_register></td></tr>

<tr><td><font face=verdanasize=1>Password: <td><input name=password_register></td></tr>

<tr><td><font face=verdana size=1>Level:</td><td><font face=verdana size=1><select name=level_register>

<option value=5>Reporter</option><option value=3>Senior DJ</option>

<option value=2>DJ</option>

<option value=1>Admin</option>

</select></td></tr>

<tr><td></td><td><input type=submit value= Add User accesskey=s></td></tr>

</table>

</form>"; }

} ?>

</font>








TRy that ?

[Lilian]

Still doing same thing, its like its not inserting the user into the database.

[Jackboy]

Err

Try putting a space after VALUES in your query.

[Lilian]

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`password` text NOT NULL,
`email` text NOT NULL,
`level` int(1) NOT NULL default '0',
`ban` int(1) NOT NULL default '0',
`lastlogin` varchar(225) NOT NULL default 'never',
`ip` varchar(15) NOT NULL default '',
`avatar` text NOT NULL,
`habboname` text NOT NULL,
UNIQUE KEY `id` (`id`),
FULLTEXT KEY `password` (`password`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=308 ;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` VALUES (284, 'Admin', 'changeme', 'Changeme', 2, 0, 'never', '', '', '');

thats my SQL

[Jackboy]

I meant ur insert query lol

[Lilian]

Lol aint that good at php soo explain *****!

[Jackboy]

The insert query:

INSERT INTO WHATEVER

A space after VALUES

is needed

[Rockstar]

Stop Slating tom, just because he can code, and kosmic you don't know what the hell php or mysql is, so you shouldn't buy the panel if you don't think you can use it, and jack stop Trying to slate tom, you may be making apanel, but sureley, you should just keep your gob shut, because people won't buy ures or download it if they think the maker is a ****.
I Do You NEWB Just That Was Confusing On Most Others It Dead Easy So Shut Your Mouth

[Lilian]

Im so stupid i dont have a clue what your on about :) Sorry!