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.

Bryan Ex · #12 06-02-2004, 10:12 PM

You're right. I forgot that there was no date references for usergroups. I'll have to come back to this one I guess once I have some time to play around with it. I'm still trying to restore everything after upgrading to 3.0.1.

kall · #13 06-28-2004, 10:48 PM

I'm getting foreach errors also..

One question: when you say 'before the bracket', do you mean 'before the curly bracket' or 'before the round bracket?'

I currently have:

PHP Code:


			
 thankyou(); 

}



// ###################### Start leavesubscription #######################

function delete_user_subscription($subscriptionid, $userid)

{

and

PHP Code:


			
    ");

    }



 thankyou();



}



// ###################### Start getsubscriptionscache #######################

function cache_user_subscriptions()

tamarian · #14 06-28-2004, 11:16 PM

Kall, the "thankyou();" line should be plasced above the quoted code.

The code you posed (the first block) look fine.

If you still have problems, email me the two files and I'll take a look.

tamarian · #15 06-29-2004, 12:53 AM

For those interested, I've had a few emails back and forth with Kall, and he emailed me several of his forum files to investigate.

The conclusion is as follows:

1. The "foreach" warning is a result of another hack, in combination with this hack. The other hack is the "store cash hack". The line numbers reported in the warning is not related to this hack.

2. Despite the warning, both hacks seem to work fine, with no problems, so you can ignore it.

Cold Steel · #16 07-04-2004, 11:17 AM

I'm getting errors, too:

Quote:

Warning: Invalid argument supplied for foreach() in /home/asiansin/public_html/forums/global.php on line 645

Warning: Invalid argument supplied for foreach() in /home/asiansin/public_html/forums/includes/functions.php on line 2895

Warning: Invalid argument supplied for foreach() in /home/asiansin/public_html/forums/includes/functions.php on line 2895

Warning: Invalid argument supplied for foreach() in /home/asiansin/public_html/forums/includes/functions.php on line 2895

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT username, subscriptionlog.userid
FROM subscriptionlog AS subscriptionlog
LEFT JOIN user AS user
USING ( userid )
WHERE user.userid = subscriptionlog.userid
AND STATUS = '1'
ORDER BY regdate DESC
LIMIT 5
mysql error: Column: 'STATUS' in where clause is ambiguous

mysql error number: 1052

Date: Sunday 04th of July 2004 07:16:12 AM
Script: http://forums.asiansinc.com/admincp/subscriptions.php
Referer: http://forums.asiansinc.com/admincp/...iptionlogid=12
Username: Webmaster
IP Address:

I'm unable to edit subscriptions.

I have the ucash/ustore hack installed, as well as the recurring paypal hack.

tamarian · #17 07-04-2004, 11:37 AM

Quote:

Originally Posted by Cold Steel

I'm getting errors, too:

I'm unable to edit subscriptions.

I have the ucash/ustore hack installed, as well as the recurring paypal hack.

The "foreach" error is not a problem, but the mysql error is a problem. I've made an update to the first post.

You just need to re-do step 2 with this code:

PHP Code:


			
    // ###################### thankyou #######################
    function thankyou(){
          global $DB_site,  $stylevar, $vboptions, $vbphrase;
    
        require_once('./global.php');
    
        $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 .= ", ' . fetch_template('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'");
    }

Cold Steel · #18 07-04-2004, 12:19 PM

Thanks for the prompt response. Now I'm getting this error:

Quote:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT username, status, regdate subscriptionlog.userid
FROM subscriptionlog AS subscriptionlog
LEFT JOIN user AS user
USING ( userid )
WHERE user.userid = subscriptionlog.userid
AND STATUS = '1'
ORDER BY regdate DESC
LIMIT 5
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.userid
FROM subscriptionlog AS subscription

mysql error number: 1064

Date: Sunday 04th of July 2004 08:19:39 AM
Script: http://forums.asiansinc.com/admincp/subscriptions.php
Referer: http://forums.asiansinc.com/admincp/...iptionlogid=12
Username: Webmaster
IP Address:

assassingod · #19 07-04-2004, 12:35 PM

PHP Code:


			
       $latestcontributers = $DB_site->query("SELECT username, status, regdate  subscriptionlog.userid

There's a comma missing after regdate, it seems.

tamarian · #20 07-04-2004, 02:29 PM

Quote:

Originally Posted by assassingod

PHP Code:


			
        $latestcontributers = $DB_site->query("SELECT username, status, regdate  subscriptionlog.userid

There's a comma missing after regdate, it seems.

Ah, yes. Thanks for the catch!

tamarian · #21 07-04-2004, 02:32 PM

Quote:

Originally Posted by Cold Steel

Thanks for the prompt response. Now I'm getting this error:

I've just updated the missing comma as pointed out by assassingod. Give it another try and let me know how it goes.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06546 seconds Memory Usage 2,360KB 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 (15)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 (3)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!