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.

[The Realist]

Works fine with 3.0.7.

Installed.

[sunnycher]

tamarian! I love this, thanks so much!

[sunnycher]

Mine is linking each member but when you click on them it goes to a Page Not Found. How do I correct this? TIA!

[tamarian]

Originally Posted by sunnycher

Mine is linking each member but when you click on them it goes to a Page Not Found. How do I correct this? TIA!

Check the links themselse, and make sure this has the correct link to member.php. It might be due to a portal page? Is that where you're displaying the list?

You probably can display it on a different page, but a small mod may be required. The default is this:

PHP Code:

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


For yours you might need to change it to this:

PHP Code:

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


[sunnycher]

thanks! which file do I change this in?

[tamarian]

In include/functions.php within the same chunk of code that was added in step #2

[sunnycher]

I found it, sorry about that.

This is what I see.
This is the link to one of the newest contributors
http://www.littlegreenphotographers.com/"member.php?u=424\" See "s? and the \?
Now if I click on a member that is online this is the link I get without the " and \
http://www.littlegreenphotographers....ember.php?u=71

you think that this is affecting it?

[tamarian]

Originally Posted by sunnycher

I found it, sorry about that.

This is what I see.
This is the link to one of the newest contributors
http://www.littlegreenphotographers.com/"member.php?u=424\" See "s? and the \?
Now if I click on a member that is online this is the link I get without the " and \
http://www.littlegreenphotographers....ember.php?u=71

you think that this is affecting it?

Double-check to make sure you have made the edits correctly. Also check in your vb options in the admincp, is the forum URL set correctly?

[sunnycher]

I see where the problem is.
First, it has the " and the \ in there but it is also not adding the \community\
in there.
I wouldn't of changed that at all, I just did the cut and pasting.
Is there a place to correct this?

[tamarian]

Originally Posted by sunnycher

I see where the problem is.
First, it has the " and the \ in there but it is also not adding the \community\
in there.
I wouldn't of changed that at all, I just did the cut and pasting.
Is there a place to correct this?

Yes, from the admin panel, for the forum URL setting. If for some reason (due to the portal for example), you do not want to add the /community/ portion to the forum URL, then you can try another modification, change the same line to:

PHP Code:

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