Fields Required when Inserting new Users to database

[Zantox]

Hello,

I've created my own global registration system, that registers to other services I offer, such as Mantis Bug Tracker.
I'm curious as to what fields need to be inserted to have a new user show up and what tables.
I assumed it was the 'user' table, and inserted a 'username' 'email' and 'password' but it didn't seem to work.
I feel like it needs to be inserted into other places as well?

Please Advise.

[kh99]

I know there should be a row in userfield and usertextfield (with matching userids of course), but I'm not sure if that's all you need.

[Zantox]

Originally Posted by kh99

I know there should be a row in userfield and usertextfield (with matching userids of course), but I'm not sure if that's all you need.

Well the table user also seems to be quite relevant. It contains the user data such as 'username' and 'password'

[kh99]

Originally Posted by Zantox

Well the table user also seems to be quite relevant. It contains the user data such as 'username' and 'password'

Yeah, sorry, I meant those other two in addition to the user table. You should insert a row into user, then get the userid of the inserted row and use it to insert rows into userfield and usertextfield. But like you said, the important information is in the user table so I'm not sure how important those others are (although I don't think the user shows up in the admincp if there aren't records in the other tables).

If you were using vbulletin code you could use the datamanager to add a user. Even if you aren't, you could look at includes/class_dm_user and see what it's doing.

Edit: And after reading Lynne's response below I realize that I was kind of assuming that you set all the important fields in the user table, but maybe that was your question - it could be that you didn't set something that's needed. I'm not sure which article Lynne means, but I found this one: www.vbulletin.org/forum/showthread.php?t=82836 It talks about using the datamanager, but it also has a list of fields with descriptions. And the example seems to say that you need username, email, password, and usergroupid at a minimum.

[Lynne]

There is an article (although it is in the vb3 article forum) that outlines the information needed to be input into the database when a user is registered. It's an article about creating users. So, take a look at that and see what is there. You can also look at the registration.php file and see what is needed.

[Zantox]

I read over that article and it didn't seem to be too specific as to what and where things need to be inserted.

[Lynne]

Perhaps a better place for you to look is this page admincp/user.php?do=add . That is the page called when you want to add a user via the admincp.

[Zantox]

After reading it over, it looks like the user table usertextfield and userfield.
But I'm not quite sure how to code that form.

[Lynne]

You aren't sure how to code a form? Try here for the basics - http://www.w3schools.com/html/html_forms.asp

[Zantox]

No I know how I'm going to do the form.
I'm talking about the php for inserting the fields and how to make it insert corresponding userid's in numerous tables.