PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > General Discussion

General Discussion General use discussion forum for PhotoPost products.

Reply
 
Thread Tools Rate Thread Display Modes
Old December 15th, 2004, 02:56 PM   #1
Bap
Member
Verified Customer
 
Join Date: Apr 2004
Posts: 38
Database user and password fields

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
Bap
Bap is offline   Reply With Quote
Old December 15th, 2004, 03:26 PM   #2
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,555
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', '68.44.160.126', '', '', '', '', 'My Website', 0, 129);
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old December 15th, 2004, 03:49 PM   #3
Bap
Member
Verified Customer
 
Join Date: Apr 2004
Posts: 38
Thanks chuck....Your always great help
Bap is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What about XMB user database? Snowfall Before You Buy 3 January 24th, 2005 11:07 AM
Photopost 4.8.1 additional fields in user albums mitchjaz2 General Discussion 2 October 3rd, 2004 09:07 PM
User database name? nf71 Before You Buy 2 October 2nd, 2004 12:21 AM


All times are GMT -5. The time now is 10:23 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.