php lan reg

hesketh

I need some help with a LAN registration page.

http://fru.tasgamers.com/lans.php

If you follow the instructions and try to register you get an error and I have no idea why.

This is the code, so that you can see whats happening...

<?php

define('IN_PHPBB', true);

$phpbb_root_path = '../phpBB2/';

include($phpbb_root_path.'extension.inc');

include($phpbb_root_path.'common.'.$phpEx);

if(isset($HTTP_POST_VARS['submit']))

{

$username = isset($HTTP_POST_VARS['username']) ? $HTTP_POST_VARS['username'] : '';

$password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : '';



$sql = "SELECT user_id, username, user_password, user_active, user_level

    FROM " . USERS_TABLE . "

    WHERE username = '" . str_replace("\'", "''", $username) . "'";



if(!($result = $db->sql_query($sql)) )

{

    message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql);

}



if($row = $db->sql_fetchrow($result))

{

    if(md5($password) == $row['user_password'])

    {

        $sql = "INSERT INTO lan VALUES('".$username."')";



        if(!($result = $db->sql_query($sql)) )

        {

            message_die(GENERAL_ERROR, 'Error in inserting userdata', '', __LINE__, __FILE__, $sql);

        }

    }

}

}

<html>

<head>

<title>LAN Registration</title>

</head>

<h1>Register</h1>

<h4>* You must be a forum member to register <a href="http://fru.tasgamers.com/phpBB2/profile.php?mode=register" target="_blank">Click here to sign up</a></h4>

<form action="<?php print $_SERVER['PHP_SELF']; ?>" method="post">

<table>

<tr>

<td>Username</td>

<td><input type="text" name="username"></td>

</tr>

<tr>

<td>Password</td>

<td><input type="password" name="password"></td>

</tr>

<tr>

<td><input type="submit" name="submit" value="Register"></td>

</tr>

</table>

</form>

<hr>

<table>

<tr>

    <td><h4>Current list of people registered...</h4></td>

</tr>

<tr>

    <td>

    <ul>



    <?php



    $sql = "SELECT * FROM lan";



    if(!($result = $db->sql_query($sql)) )

    {

        message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql);

    }



    while($row = $db->sql_fetchrow($result)) print "<li>".$row['username']."</li>\n";



    ?>



    </ul>

    </td>

</tr>

</table>

</body>

</html>

This uses your user name and password from the phpbb2 LAN forums on the site.

If you know how I can fix this, please help me.

stuartc1

tryed to follow the register link from the page you supplied and got a '404 page not found', are you sure you have the proper link address ?? Its not even getting the page, so theres no point in checking your code.

hesketh

:eek: whoops, sorry about that.

The page is there now, but the error remains aswell 🙁

stuartc1

I just completed the registration and got no errors !! please explain were you are getting the errors and what the error is.

hesketh

If you successfully registered for the LAN, why is your name not on the
'Current list of people registered...'

I get this error when I try to register...

General Error

Error in inserting userdata

Weedpacket

I take it that the table 'lan' only contains one column?

hesketh

Weedpacket: yes

Does no one know why the hell this is stuffed??

inCogNeatO

when the page loads the error is undefined function right?

phpdefine();

with the code you posted it would suggest your server is ignoring your line breaks, try placing an echo in above your define and see if it errors with phpecho();

if so it looks as if you may want to change your file format of the file you are working on (mac - pc - unix) so it recognises the line breaks in your code. Hope this helps

hesketh

inCogNeatO: I don't know what was going on there, but I've fixed the page, now I get this error again...

General Error

Error in inserting userdata

(try it for yourself)

Weedpacket

Have you tried echoing your $sql query before sending it into the database; to make sure it is what you think it is?

mrbrush

You should try to get the error message from the server. Whichever db handler you use, there should be a function for querying the error message (mysql: mysql_error()).
Print that out - you'll know much more about the cause of the error.

prune

try in your insert code

$sql = "INSERT INTO lan VALUES('".$username."')";

change to

$sql = "INSERT INTO lan (username) VALUES('".$username."')";

Weedpacket

Since the table "lan" only has one column, this wouldn't have any effect.