Either registration or login works, but not both.

So, I tried to add fields to the user table that could only be filled out while the user was logged in -- i.e., they don't appear in the registration form, but they do appear in useredit.

This broke the registration form. It couldn't figure out how to add stuff to the user table. So, I did the sensible thing, and specified the fields to process during registration.
From:

Code:

 $q = "INSERT INTO ".TBL_USERS." VALUES ('$username', '$password', '0', $ulevel, '$email', $time)";

To:

Code:

$q = "INSERT INTO ".TBL_USERS." (username, password, userid, userlevel, email, timestamp) VALUES ('$username', '$password', '0', $ulevel, '$email', $time)";

So, then registration worked just fine, but no one could log in, because the form kept insisting that the usernames were not in the table -- including my admin username which had been there since install, long before I started screwing with the tables and forms. I changed back the registration query, and login worked again, but no one could register.

I'm sure this is just me being a total dumbass, but can someone give me a clue?

Forgive me if this doesn't help at all but I'm answering this from my blackberry and its not correctly displaying all your code. These tips are just ideas from the top of my head. Hopefully they help.

I have a feeling that you edited your database to accommodate for your new fields but in the registration function in session.php you may have forgot to add those fields to the query that adds a new row to the database. If this is the case this may lead to an unstable population of your database (forgive me if that sounds too technical...ha!). This could also cause your script to think the user names or passwords aren't correct when they really are.

So check out the session.php page and the useredit.php page and make sure you are adding the same column names for both. If you don't want users to add certain information until users are registered then the column values for those fields should be left blank or NULL.

Let me know if you are following me and if any of this helps.