Outline:
Sign up on our website to collect persons e-mail to automatiacally create a new entry in a MySQL database, configured correctly, and we would like to use paypal IPN’s to automatically update those entries as specified.
Firstly Upon a person signing up on our website, we want a new entry automatically created, configured as follows.
(the only information gathered from the sign up submission is their e-mail address)
e-mail from signup page to go to ClientID field.
License text a defult text code (that we will provide later)
ExpiryDate set to 1 month after current date.
Refresh set to 1
see image attached.
Secondly paypal IPN’s should update the following fields.
License text (one of 3 options)
ExpiryDate automatically updates. X many months after current date. (1 = 30, 2 = 60, 3 = 90…)
Refresh set to 1
PS. I have created a paypal ‘buy now’ button that seems to work. There are 3 variables:
1 item (should effect which license text to be entered, one of three text codes)
2 amount (should effects the amout of months / expiry date)
3 Client ID (identifies wich entry to be update).
Refresh needs to be set from 0 to 1.
Thirdly it is worth mentioning that there are 2 databases,
1 is the old database. We have used to collect signup information in the past, and currently when people sign up, the entry comes up there.
2 is our new database. We want the future signup submissions to automtacilly create a new entry in this database, configured as stated in this project.
I’m not sure if syncing is required, or if it is possible to automatically create a new entry based on a new entry being created in the other database?
MySQL fields:
ClientID
HardwareID N/A
License
HardwareChanges N/A
ExpiryDate
PHP Version 5.2.9
MySQL version 5.1
Drupal website content managment system
