Home
Suggestions and new ideas
Postback, SQL and more!
Postback, SQL and more!
3 years ago submited by Rodney
Ok, so most (actually more like 99%) of affiliate networks that I am currently with have SQL and Postback, as well as a few other things. I bought PAP4 hoping that it would be easy to implement these things but, unfortunately it seems that I cannot find a single coder/programmer that is willing to touch it.
I am looking at other affiliate software options but, I love PAP4 overall so I am hoping that there is a way to implement these things, even as an extension to pay extra for would be fine!
Here is how they work:
The Postback URL tool enables your website to send us a link from which to postback lead information. Once you receive a lead, instead of having to log in and manually credit the offer on your website, the Postback URL tool allows you to give us a unique link where we can automatically post the information back for you.
script posts back information to your website the GET variable. For example, lets say you have your postback link saved as "http://YourSite.com/pb/pb-3333.php." Once a lead is generated and applied to your account, our script automatically posts back the information to the following URL: "http://YourSite.com/pb/pb-3333.php?campid=XXXX&campname=XXXX&subid=XXXX&
commission=XXXX&status=X"
By using our Mass SQL insert command, you can add multiple offers to your site at once while sorting and customizing the types of offers added. After filling out all of the following fields, an SQL insert line will be automatically and immediately generated for you to insert into your site's database.
Please note the following variables which are used in the SQL insert function.
Variable Names How They Are Returned
$campaignid$ Campaign ID of the offer, returned as an integer.
$commission$ The commission you are earning on the offer.
$name$ SQL Escaped String, name of the campaign.
$offerurl$ SQL Escaped String, campaign URL.
$imageurl$ SQL Escaped String, image URL, generated as 120x60 by default.
$description$ SQL Escaped String, dampaign description
$instant$ Crediting time, entered as an integer. "1" for a "real time" crediting offer, "0" for anything else.
For example, if your SQL line is entered as:
INSERT INTO fsr_offers (name, added_on, temp_url, temp_imgurl, temp_description, temp_requirements, temp_payout, temp_csv_post_id) VALUES ('$name$', NOW(), '$offerurl$', '$imageurl$', '$description$', '', '$commission$', '$campaignid$');
then our script will return to you the following newly entered variables:
INSERT INTO fsr_offers (name, added_on, temp_url, temp_imgurl, temp_description, temp_requirements, temp_payout, temp_csv_post_id) VALUES ('Your Super Cash', NOW(), 'http://yoursite.com/link.php?cid=172&affl_id=58925&subid=', 'http://yoursite.com/image.php?cid=172&affl_id=58925&subid=', 'Your Super Cash provides your customers with a quick, easy payday loan application. We have taken years to perfect our application process to make it as simple for customers as possible and even better make more conversions for your website traffic. Your Super Cash has no restrictions on keyword usage and we encourage you to use your search engine expertise to drive traffic to this great converting site.', '', '35.00', '5280');
CODING & RECODING
3 years ago
gus
nice to see the interest. we prefer to do our own coding. problem is with upgrade or patch. i notice that the plugins are all 1.0.0 which indicates to me that writing a plugin is the way to go as such measures are generally bust-proof. have you looked into doing that and is this company amenable to providing that 'write your own pluggin' guiddance?