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

[fionix]

Yes it works perfectly on V.3.8

Only little probolem is if you want to customize the code to have different comissions, don't know how to do that. Any help?

In the video it says you have to put this code on the line: &idev_commission=XX

[CRP]

Just tested on V3.8.1 and it worked great. Well, I have to charge tax and it calculated commission on gross, but I can live with that for now.

I had bought Idevaffiliate for another part of my site, and still not able to get it working with software that was supposed to be already integrated with each other. But, this one worked perfect first try. Thanks so much for doing this.

Installed.

[forumguy1]

will this work with vb 4.0?

[benative]

ya seriously!!! does it work with vbulletin 4.0??????

[forumguy1]

Can any shed some light on this and let us know if it works with vb 4.0?

I am willing to pay someone as well to port it over if necessary.

[benative]

There's

Standard Edition
Gold Edition
Platinum Edition

on http://www.idevdirect.com

what should I purchase to get this working???

[forumguy1]

Either will work fine from those 3. Were just not sure it if works with VB 4.0.

[benative]

Please let us know if it works with VB 4.0

[MichaelaS]

I'm running 3.8.3 and I've been using this mod for a year with my forum. The tracking is not working properly for me at all. It's dropping commissions on active (paying) members, double paying occasionally, and all sorts of random issues. Nothing consistent at all so as to troubleshoot and track down where the problem is occurring.

Since I get an Order Number in iDev, with no association to the actual forum user or username, I've had to track every single one back to orders by the date & timestamp - to figure out what kind of issues I was having in the first place. It's a real mess. I had iDev support look into it with me, but have no choice but to close my affiliate program at this point.

Anyone else had these tracking issues (that you know of) - and/or know a solution I can try?

Thank you