Adding Members to my site

[magnetica]

Hi

 

I am trying to design a members feature to add to my site. So that they can do all the usual (register, login, leave comments etc).

 

I would like to ask what I would need to store in the database, like username, their id's, ip addresses etc

 

Any contribution is appreciated

[lightningstrike]

I recommend storing the ip they register with as a Unsigned Long Value as well as the most recent login IP as a long as well.

e.g.

//long ip unsigned

$ip = sprintf("%u",ip2long($_SERVER["REMOTE_ADDR"]));

 

Also the users gender, country, email address, member group or access level (permission to use different functions), registration date as a timestamp (use time function).

 

Perhaps you might want their Given/First Name for reasons of addressing them etc.