The Arcive of Official vBulletin Modifications Site.

List latest X paid subscribers on Forum Home · **Released**: 05-17-2004

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,

Code:

/*======================================================================*\
|| ####################################################################
|| # 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:

Code:

<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.

Jenta · #42 03-16-2005, 12:45 PM

Quote:

Originally Posted by utlamer

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

i take that back
its still not right
anyone have any luck with this on 3.0.7?

Jenta · #43 03-20-2005, 06:33 PM

heres a simpler solution that works for me every time
its only one user but im sure it can be expanded
https://vborg.vbsupport.ru/showthrea...284#post628284

tamarian · #44 03-20-2005, 06:51 PM

Quote:

Originally Posted by utlamer

heres a simpler solution that works for me every time
its only one user but im sure it can be expanded
https://vborg.vbsupport.ru/showthrea...284#post628284

It is simpler, but it will effect your forum performance, since you add a new query to the index.php page, executed every time the page loads. If your forum does not have heavy traffic, this may not be an issue.

Jenta · #45 03-21-2005, 02:25 AM

yeah i know, my forum is small so it's cool
any chance of looking into why this doesnt work for some
i notice you are running 3.0.1 on ur site
maybe something has changed since then?

tamarian · #46 03-21-2005, 11:23 AM

Quote:

Originally Posted by utlamer

yeah i know, my forum is small so it's cool
any chance of looking into why this doesnt work for some
i notice you are running 3.0.1 on ur site
maybe something has changed since then?

Yes, we haven't upgraded yet, and probably will wait for a major release before we upgrade.

If you're willing to test this, I think it may work

Use this code in functions.php

PHP Code:


			
// ###################### thankyou #######################

function thankyou(){

      global $DB_site;



    $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'");

}

Instead of the code in the first post. It uses a hard-coded template instead of the thanksbit, to avoid dealing with fetch template.

Jenta · #47 03-21-2005, 02:57 PM

awesome
Tested on 3.0.7 and the new code works perfect!

Just to make it more clear, you dont need to create the template thanksbit anymore. Delete it by clicking revert if you have it already made. If you use this updated code, skip that step in the current instructions and only create the blank template name thanks. Correct me if I'm wrong.

Thanks a million!

tamarian · #48 03-21-2005, 03:20 PM

Quote:

Originally Posted by utlamer

awesome
Tested on 3.0.7 and the new code works perfect!

Good to know, I've added the changes to the first post.

Quote:

Just to make it more clear, you dont need to create the template thanksbit anymore. Delete it by clicking revert if you have it already made. If you use this updated code, skip that step in the current instructions and only create the blank template name thanks. Correct me if I'm wrong.

That is correct

jilly · #49 03-23-2005, 01:14 PM

The new code works fine for me now - thanks!!!

oztrack · #50 03-27-2005, 01:06 AM

I want it on my front page as well.

Also when trying to change the colour - i cant get mine to be any different by editing the colour code in functions.php

Please help

jilly · #51 03-30-2005, 04:08 PM

Is there a way to separately show the newest paid subscribers for each level?

For example:

Thanks to the supporting members, here are the newest supporters!
Level A: member1, member2, member3
Level B: member1, member2, member3
Level C: member1, member2, member3

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09544 seconds Memory Usage 2,348KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (11)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!