327379 CCbill/curl data retrieval
N/A
Pago na entrega
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","[url removed, login to view]","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","[url removed, login to view]","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","[url removed, login to view]","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.
ID do Projeto: #2073186