View Full Version : Database user and password fields

December 15th, 2004, 02:56 PM
Hi I am doing a ccbill intigration and need a little help if possible.

Their software will write to my PP database when a user signs up or canceles keeping my database current.

Here is what a ccbill tech wrote:

"There would be a table or multiple tables under the database. I will
need the name of the one that we need to write to for members to gain
access. Also, there will be field names in the table as well, the ones I
need names for are which one are designated for 'username' and 'password.' "

So I need to have them write to pp_users? what about pp_sortmemb? And what would the field names for username and password be in pp_users.

Thanks in advance

Chuck S
December 15th, 2004, 03:26 PM
Why not send a complete insert so he knows how the table is

The password field is simple md5 encryption

INSERT INTO `pp_users` (`userid`, `usergroupid`, `username`, `password`, `email`, `homepage`, `icq`, `aim`, `yahoo`, `joindate`, `posts`, `birthday`, `ipaddress`, `location`, `interests`, `occupation`, `bio`, `site`, `offset`, `views`) VALUES (1, 5, 'SomeUser', 'md5passwordhere', 'someemail@email.net', 'http://', '', '', '', 1099415035, 0, '0000-00-00', '', '', '', '', '', 'My Website', 0, 129);

December 15th, 2004, 03:49 PM
Thanks chuck....Your always great help