Adsense Reveune Sharing Hack

This hack will allow you to offer Google Adsense revenue sharing to your vbulletin board users. Revenue sharing is a great way to reward your board members for their loyalty and adds a feeling of ownership in the board and it's success.

Add a User Profile Field with these settings:

Profile Field Type: Single-Line Text Box
Title: (your choice)
Description: (your choice)
Field Editable By User: Yes
Private Field: Yes
Field Searchable On Memers List: No
Show On Members List: No
(I have only specified settings for the fields you will need to change from their defaults.)


In the php_include_start template, add this code:

PHP Code:

srand();
$random_number = rand(0, 1);
$ga_adsenseid = 'ENTER_YOUR_ADSENSE_ID_HERE';
if ($random_number == 1)
{
    if (THIS_SCRIPT == 'showthread')
    {
        if (!empty($_REQUEST['t']))
        {
            $ga_threadid = $_REQUEST['t'];
        }
        else
        {
            $ga_threadid = $_REQUEST['threadid'];
        }
        $ga_thread = $DB_site->query_first("
            SELECT postuserid
            FROM ".TABLE_PREFIX."thread
            WHERE threadid = $ga_threadid
        ");
        $ga_user = $DB_site->query_first("
            SELECT field7 AS adsenseid
            FROM userfield
            WHERE userid = $ga_thread[postuserid]
        ");
    }
    elseif (THIS_SCRIPT == 'showpost')
    {
        if (!empty($_REQUEST['p']))
        {
            $ga_postid = $_REQUEST['p'];
        }
        else
        {
            $ga_postid = $_REQUEST['postid'];
        }
        $ga_post = $DB_site->query_first("
            SELECT userid
            FROM ".TABLE_PREFIX."thread
            WHERE postid = $ga_postid
        ");
        $ga_user = $DB_site->query_first("
            SELECT field7 AS adsenseid
            FROM userfield
            WHERE userid = $ga_post[userid]
        ");
    }
    if (!empty($ga_user['adsenseid']))
    {
        $ga_adsensecode = $gauser['adsenseid'];
    }
} 


Then, where ever you have your AdSense display code, find the spot where you specify your AdSense ID and replace it with $ga_adsenseid . Also make sure in the above code that you enter YOUR AdSense ID in the spot above where it says "ENTER_YOUR_ADSENSE_ID_HERE".

[Deaths]

Is it correct that this code adds 2 queries to every page?

[artonex]

Im not sure, i paid someone to code this hack for me. I have seen a few ppl wanted it so i decided to share it with all

[Deaths]

Hmm, ok.

Well, I've looked through it, and it adds 2 queries to showthread.

[Lionel]

I saw that hack at hotscripts. The guy wanted 150.00 dollars for that???

point with such a hack is that 99% of boards users don't even know about AdSense, so i don't see why you'd be asked to pay for such a hack...

and adding the field in the users table would speed up the treatment and cut a query...

[Guy G]

Originally Posted by nexialys

point with such a hack is that 99% of boards users don't even know about AdSense, so i don't see why you'd be asked to pay for such a hack...

and adding the field in the users table would speed up the treatment and cut a query...

Yes but what if your board related to webhosting and such? like DigitalPoint... That hack would work great in there.

[Lionel]

That would fall into the remaining 1% :-)
Nexy's hack to insert ad randomly in thread is best.

[T3MEDIA]

The guy is offerning to share... lets not chop him down.

BUT good looking out on the extra load it produces.

[artonex]

Originally Posted by Lionel

That would fall into the remaining 1% :-)
Nexy's hack to insert ad randomly in thread is best.

Where can i find that hack ?