List latest X paid subscribers on Forum Home

There's also a vB 3.5 version here: https://vborg.vbsupport.ru/showthrea...threadid=99049

What this hack does: This hack will list and instantly refresh (when a new subscription is made) a list of the latest X paid subscribers to your forum. It's a nice way of recognizing members who help pay the the forum bills, and encourages others to join.

Demo: http://forum.lowcarber.org

PHP edits:
1. 2 edits in index.php
2. 1 edit in includes/functions.php
3. 2 edits in includes/functions_subscriptions.php

Template edits:
1. 1 new template: thanks
2. 1 edit in FORUMHOME

Installation:

1. In index.php

Find:

PHP Code:

'FORUMHOME', 


Add after:

PHP Code:

'thanks', 


Find:

PHP Code:

// ### TODAY'S BIRTHDAYS 


Add before:

PHP Code:

$thanks = $templatecache['thanks']; 


2. In include/functions.php

At the end of the file, just before the end/footer stuff,

/*======================================================================*\
|| ####################################################################
|| # Downloaded: Thu Apr 15th 2004
|| # CVS: $RCSfile: functions.php,v $ - $Revision: 1.967 $
|| ####################################################################
\*======================================================================*/
?>

add before:

PHP Code:

// ###################### thankyou #######################
function thankyou(){
      global $DB_site;

    // This is the template for usernames
    $thanksbit = ' <a href=\"member.php?$session[sessionurl]u=$contributer[userid]\"><font color=\"#228E8E\"><b>$contributer[username]</b></font></a>';

    $latestcontributers = $DB_site->query("SELECT username, status,regdate,  subscriptionlog.userid
                FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
                LEFT  JOIN " . TABLE_PREFIX . "user AS user
                USING ( userid )
                WHERE user.userid = subscriptionlog.userid
                AND STATUS = '1'
                ORDER  BY  regdate  DESC
                LIMIT 5");

    $latest_str = '';
    while ($contributer = $DB_site->fetch_array($latestcontributers))
    {
        eval("\$latest_str .= ', ' . \"$thanksbit\";");
    }
    $latest_str = substr($latest_str , 2);
    $latest_str = addslashes($latest_str);
    $DB_site->query("UPDATE " . TABLE_PREFIX . "template SET template=\"$latest_str\", template_un=\"$latest_str\"  WHERE title='thanks'");
} 


Note 1: Change "LIMIT 5" to any number. By default, it will show the latest 5 paid subscribers. If you want to show the latest 3, simply change to "LIMIT 3".
Note2 The template for usernames is in the code. To change the style and colour, edit this line from the code you added to functions.php:

PHP Code:

    $thanksbit = ' <a href=\"member.php?$session[sessionurl]u=$contributer[userid]\"><font color=\"#228E8E\"><b>$contributer[username]</b></font></a>'; 


3. In includes/functions_subscriptions.php

Find:

PHP Code:

}
      
      // ###################### Start leavesubscription #######################
      
      function delete_user_subscription($subscriptionid, $userid) 


Add before (before the bracket):

PHP Code:

thankyou(); 


Find:

PHP Code:

}
      
      // ###################### Start getsubscriptionscache #######################
      function cache_user_subscriptions() 


Add before (before the bracket:

PHP Code:

thankyou(); 


4. Create a new template: thanks

Leave the new template empty

5. Edit the FORUMHOME template

Add $thanks where you want the list of members to appear.

For example, I use this in the stats area of FORUMHOME:

<div>Thanks latest <a href="subscriptions.php">contributing members</a>: $thanks</div>

6. First run To auto fill the list for the first time, you just need to edit an existing subscription, or just wait for the next subscription to arrive.

To auto fill it right now: Simply go to your admin control panel, click on subscriptions, view list, edit any existing subscription, for example, add 1 day to the subscription of a member, and save. You can re-edit to subtract the 1 day if you want.

[RapCheck]

oops, forget to check back

No, I use edit plus

I just upgraded to 3.0.3 and reapplied the hack, and still get the 3 errors when editing subcriptions.

[scottct1]

I am also getting

Warning: Invalid argument supplied for foreach() in /home/satellit/public_html/includes/functions.php on line 2854

Warning: Invalid argument supplied for foreach() in /home/satellit/public_html/includes/functions.php on line 2854

Any ideas?

[nonet]

Has anyone been able to get this to work with vbadvanced CMPS?

[mikeB]

can someone please explain where exaclty "just before the footer stuff" is?

[mikeB]

well Im getting no errors and Im also getting no subscribers to appear heh

[tamarian]

Originally Posted by mikeB

can someone please explain where exaclty "just before the footer stuff" is?

Meaning just before this at the bottom functions.php

/*======================================================================*\
 || ####################################################################
 || # Downloaded: Thu Apr 15th 2004
 || # CVS: $RCSfile: functions.php,v $ - $Revision: 1.967 $
 || ####################################################################
 \*======================================================================*/
 ?>

[lasto]

Originally Posted by mikeB

well Im getting no errors and Im also getting no subscribers to appear heh

same ere - all seems to be working but nothing shows - weird

[Jenta]

Originally Posted by lasto

same ere - all seems to be working but nothing shows - weird

Originally Posted by mikeB

well Im getting no errors and Im also getting no subscribers to appear heh

me too, maybe not compatible with 3.0.7?

if thankyou(); is in functions_subscriptions.php u get a blank screen when after editing a subscribtion though it does actually write the change to the database

so it seems to me that the thankyou function is hanging somehow and ive double and triple checked everything

[Jenta]

ok its working now!
what happened was since its set to 5, it takes 5 subscriptions for it to kick in
at least thats what i think made it kick on

[Mokster]

nice hack, could you change it so it shows the lastest new registered users?