Hi,
I am looking for someone to create a script that does the following…
I need a php script to connect to CCBill data manager and pull data like the following from their system using CURL.
“NEW”,”91634″,”0005″,”0108500301000000001″,”20041201105542″,”John”,”Doe”,”juser”,”passwd”,”220 E. Nowhere Blvd.”,”Testville”,”FL”,”03345″,”USA”,”jdoeatnoserver.com”,”141414″,”N”,”1.09″,”30″,”2.09″,”30″,”0″,”VISA”
“NEW”,”91634″,”0005″,”0108500301000000002″,”20041201100542″,”Jane”,”Doe”,”jnuse”,”psswd2″,”999 N. Anywhere Rd.”,”Testopolis”,”NY”,”09245″,”USA”,”jndoeatnoserver.com”,”266599″,”Y”,”2.09″,”30″,”1.09″,”30″,”0″,”MASTERCARD”
“NEW”,”91634″,”0005″,”0208500301000000003″,”20041201105542″,”Jesse”,”James”,”jmister”,”psswd6″,”445 W. Nowhere Blvd.”,”Testville”,”CA”,”03347″,”USA”,”jjamesatnoserver.com”,”145914″,”Y”,”1.34″,”30″,”3.19″,”30″,”0″,”DISCOVER”
“REBILL”,”91634″,”0005″,”0108500301000000001″,”20041201105542″,”1777444488″,”1.99″
“REBILL”,”91634″,”0005″,”0108500301000000002″,”20041201100542″,”1098754326″,”4.32″
“REBILL”,”91634″,”0005″,”0208500301000000003″,”20041201105542″,”1098702398″,”2.90″
“REFUND”,”91634″,”0005″,”0108500301000000001″,”20041201105542″,”1.99″
“REFUND”,”91634″,”0005″,”0108500301000000002″,”20041201100542″,”4.32″
“REFUND”,”91634″,”0005″,”0208500301000000003″,”20041201105542″,”2.90″
“CHARGEBACK”,”91634″,”0005″,”0108500301000000001″,”20041201105542″,”1.99″
“CHARGEBACK”,”91634″,”0005″,”0108500301000000002″,”20041201100542″,”4.32″
“CHARGEBACK”,”91634″,”0005″,”0208500301000000003″,”20041201105542″,”2.90″
I will need to run the script 3/4 times a day to check for new entries and store them in a mysql database…
The data I need stored in the database is…
transaction id
transaction timestamp
Transaction type (refund,chargeback,new sale, rebill)
site id
affiliate id
purchase price
membership length
user id (this needs to be retrieved from my vbulletin database by matching transactions ids)
The script will need to be run a few days by cron and check for new sales/refunds etc and update the database as necessary.