My Login PHP Script... [Sticky Please!]

[corvanus]

first take out the ' s at 'account' they are unneeded and generally through syntax errors there same with 'name' only after the equals do you need them second add a semo colon after '" . $_POST[username] . '"' after the last singel quote and remove the single quotes at 'username' well you get the idea you have a ton of quotes where you dont need them so my guess is that is part of your errors right there then again you could always just use the premade pequpdater script and solve all your problems lol

[fault]

Originally Posted by corvanus

first take out the ' s at 'account' they are unneeded and generally through syntax errors there same with 'name' only after the equals do you need them second add a semo colon after '" . $_POST[username] . '"' after the last singel quote and remove the single quotes at 'username' well you get the idea you have a ton of quotes where you dont need them so my guess is that is part of your errors right there then again you could always just use the premade pequpdater script and solve all your problems lol

uh this is the *premade updater*

[corvanus]

odd i use the peq updater and havent had any issues with it at all worked like a charm after a couple quick edits

[corvanus]

what version of mysql and php are you using and have you double checked the db settings?

[corvanus]

come to think of it why dont you drop in a line to show the query and results that way you can see precisly what the error is mysql is returning

[Theeper]

There is a couple small errors in this script I noticed.

1. There is a variable declaration near line 22 that is missing an equals sign.

$server_name "Name of Your Server"; //set the name of your server here

.. should be ..

$server_name = "Name of Your Server"; //set the name of your server here

Also, the form is pointing to index.php, although the script is called peq_updater.php. Change
this line ..

<form id="form1" name="form1" method="post" action="index.php">

.. to ..

<form id="form1" name="form1" method="post" action="<?=$_SERVER[PHP_SELF]; ?>">

Other than that, it seems to work.

[quadroplex]

This is a pretty killer tool right here, but i have one question...

Would it not be better if the script saved the passwords as MD5 encrypted passwords, I ask because that is how the worldserver accesses the passwords for other things (telnet command line client and Web interface) and so forth...

I could throw together an example of this if you need it, I just thought it would be a better way to store the passwords then plaintext as then you would need to go in and MD5 the GM passwords by hand, where as if everyones password is MD5 encrypted once you flag the acct it can then use those other tools with no further effort on the Server Admin's part