Miscellaneous Hacks - vBulletin and iDevAffiliate Integration

NOTE: I have it installed on 3.7x, I haven't tried earlier versions.

Description: I have been searching around for a plugin to allow vBulletin and iDevIntegration (for affiliate management of vbulletin paid subscriptions) and could not find any.

I contacted iDevAffiliate and their response was that they did not know enough
about vbulletin to create a plugin themselves but they explain what I had to do
on the iDevAffiliate side to make things work.

Thanks to vbulletin.org members Marco van Herwaarden, Dismounted, Delphiprogrammi, Opserty for pointing me in the right direction as this is my first vbulletin plugin.

This mod integrates iDevAffiliate commission tracking.

NOTE: Keep in mind, I assume that you are fairly well versed and comfortable with editing files/templates and following the flow of things.

Installing:

*********************************
STEP 1
*********************************
In payments.php in your forum root find the following code lines:

    /* insert query */
    $db->query_write("
        INSERT INTO " . TABLE_PREFIX . "paymentinfo
            (hash, completed, subscriptionid, subscriptionsubid, userid)
        VALUES
            ('" . $db->escape_string($hash) . "', 0, $subscriptionid, $subscriptionsubid, " . $vbulletin->userinfo['userid'] . ")
    ");

Replace them with the following:

    /* insert query */
    $insertQuery = "INSERT INTO " . TABLE_PREFIX . "paymentinfo
            (hash, completed, subscriptionid, subscriptionsubid, userid";
    $insertQuery .= $vbulletin->options['idevaffiliate_active'] ? ", ipaddress)" : ")";
    $insertQuery .= "VALUES
            ('" . $db->escape_string($hash) . "', 0, $subscriptionid, $subscriptionsubid, " . $vbulletin->userinfo['userid'];
    $insertQuery .= $vbulletin->options['idevaffiliate_active'] ? ", '" . IPADDRESS . "')" : ")";
    $db->query_write($insertQuery);

*********************************
STEP 2
*********************************
In payment_gateway.php file in your forum root find the following code lines:

    
if ($apiobj->type == 1)
{
    $subobj->build_user_subscription($apiobj->paymentinfo['subscriptionid'], $apiobj->paymentinfo['subscriptionsubid'], $apiobj->paymentinfo['userid']);

Add the following code under the above code ( make sure you replace YOURDOMAINNAME with your domain name and YOURIDEVINSTALLATIONFOLDER with your idev installation folder:

if ($vbulletin->options['idevaffiliate_active'] AND function_exists('curl_init') AND $ch = curl_init())
{
    $idevQuery = "idev_saleamt=" . $apiobj->paymentinfo['amount'] . "&ip_address=" . $apiobj->paymentinfo['ipaddress'] . "&idev_ordernum=" . $apiobj->paymentinfo['paymentinfoid'];
    curl_setopt($ch, CURLOPT_URL, "http://www.YOURDOMAINNAME.com/YOURIDEVINSTALATIONFOLDER/sale.php");
    curl_setopt($ch, CURLOPT_TIMEOUT, 15);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDSIZE, 0);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $idevQuery);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_USERAGENT, 'vBulletin via cURL/PHP');

    $result = curl_exec($ch);
    curl_close($ch);
}

*********************************
STEP 3
*********************************
Install the idevaffiliate_integration Product via the Plugin Manager

*********************************
STEP 4
*********************************
Go to AdminCP -> vBulletin Options -> iDevAffiliate Integration Settings and enable use of iDevAffiliate by selecting 'Yes' and saving.

That's it, you are ready to use iDevAffiliate with vBulletin.

Dont Forget To MARK AS INSTALLED
And Also Don't Forget To Visit DNXpert.com

[vb_mp]

Originally Posted by TeelK

tagged.. but i would never edit any original vb files as because when and upgrade comes out you have to do it all again, al wait see if someone can make it so no edit of files is possible.

I could make it so that no original files are edited if they put a hook in the right place (in the payment and payment_gateway files).

Currently, there are no hooks, but I think there is a place around here where I can request hooks for new upgrades so I will do that.

[mambomouth]

fantastic work I can't wait to try this.
Thanks a "vb_mp"

[vb_mp]

Originally Posted by mambomouth

fantastic work I can't wait to try this.
Thanks a "vb_mp"

No probs . Let me know how you go. It's currently live and counting commissions for my affiliates on my site.

[jasculs]

Hey vb_mp have you tested this out with some of your members already getting recorded commissions? If so then you're the best person ever because I've been looking for a paid subscription affiliate system for a very very long time.

[vb_mp]

Yea I have tested it - it is currently working and functional on my forum ( link is above in the original post ). People are spreading the affiliate link around and commissions are being generated on subscription purchases.

The things to note - according to iDevAffiliate they will be releasing a new release that will enable deletion of commissions on payment reversal... currently when a payment is reversed (for example on a refund) you have to manually cancel the subscription in iDevAffiliate... this is not a vBulletin problem though, rather a iDevAffiliate deficiency.

The guys from iDevAffiliate have promised that this payment reversal curl target url will be released in new upgrade, once that's there I will add it to this mod.

[jasculs]

Originally Posted by vb_mp

Yea I have tested it - it is currently working and functional on my forum ( link is above in the original post ). People are spreading the affiliate link around and commissions are being generated on subscription purchases.

The things to note - according to iDevAffiliate they will be releasing a new release that will enable deletion of commissions on payment reversal... currently when a payment is reversed (for example on a refund) you have to manually cancel the subscription in iDevAffiliate... this is not a vBulletin problem though, rather a iDevAffiliate deficiency.

The guys from iDevAffiliate have promised that this payment reversal curl target url will be released in new upgrade, once that's there I will add it to this mod.

Great Thank You!!...I just wanted to be sure before I purchased the software. I know it may be a little off topic, but how do you like the affiliate software?

Also if I have people on recurring billing can I have it work with recurring commissions?

Thanks a lot!!
Jason

[vb_mp]

I like iDevAffiliate, easy to install, works well.

Paypal recurring commissions (I have them on my forum) are treated as individual payments each month - it works quite well.

User signs up - iDevAffiliate records payment information, affiliate gets commission. Next month, PayPal triggers IPN on recurring payment, idevaffiliate checks payment info and credits affiliate with another commission - and so on.

iDevAffiliate has some internal recurring commissions setup - make sure you ignore that - it's some manual recurring commissions crap.

Also, once you install iDevAffiliate, make sure you download this patch that fixes a bug of approving/unapproving commissions:
http://www.idevsupport.com/index.php...temid=16&nav=0

Cheers

[Quarterbore]

You listed some pros in your credits but I likewise really would prefer not install this until it is plugin based. I would rather add a couple queries on the occasion where I get a purchase then to have to risk that there is an upgrade out and I need to deal with hardcoded file edits.

[vb_mp]

Originally Posted by Quarterbore

You listed some pros in your credits but I likewise really would prefer not install this until it is plugin based. I would rather add a couple queries on the occasion where I get a purchase then to have to risk that there is an upgrade out and I need to deal with hardcoded file edits.

That's totally cool with me. I posted this mod to allow the people that have been searching for a mod for this for ages to get it and use it.

I will however fix it to use hooks as soon as some hooks are made available by vBulletin.com

[mambomouth]

I have installed but have not recorded any sales.
Wait traffic site to send a sale .