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.

[assassingod]

Originally Posted by tamarian

Ah, yes. Thanks for the catch!

No problem

[Cold Steel]

Thanks assassingod and tamarian.

This is my 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'");
}

And this is my error:

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, 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: Column: 'status' in field list is ambiguous

mysql error number: 1052

Date: Sunday 04th of July 2004 02:44:37 PM
Script: http://forums.asiansinc.com/admincp/subscriptions.php
Referer: http://forums.asiansinc.com/admincp/...iptionlogid=12
Username: Webmaster
IP Address:

[tamarian]

Originally Posted by Cold Steel

Thanks assassingod and tamarian.

This is my code:

And this is my error:

O.k., I've made a small change by adding subscriptionlog. prefix, even though it's not ambigious!

Give it another try (just step #2), and let's see how it goes.

[Cold Steel]

Apparently, mysql still can't get it clear:

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 subscriptionlog.status = '1'
ORDER BY subscriptionlog.regdate DESC
LIMIT 5
mysql error: Column: 'status' in field list is ambiguous

[tamarian]

Originally Posted by Cold Steel

Apparently, mysql still can't get it clear:

Let's try this:

PHP Code:

   // ###################### thankyou #######################
      function thankyou(){
            global $DB_site,  $stylevar, $vboptions, $vbphrase;
      
          require_once('./global.php');
      
          $latestcontributers = $DB_site->query("SELECT *
                     FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
                     LEFT JOIN " . TABLE_PREFIX . "user AS user
                     USING ( userid )
                     WHERE user.userid = subscriptionlog.userid
                 AND subscriptionlog.status = '1'
                     ORDER BY subscriptionlog.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]

That worked. Thanks a ton!

BTW I'm a big anti-carb person myself.

[tamarian]

Originally Posted by Cold Steel

That worked. Thanks a ton!

That's great to hear. I'm just curious, what versions of PHP and MySQL do you run?

[Cold Steel]

PHP v4.3.3
MySQL v4.0.18-standard

[RapCheck]

I'm getting these errors when editing subscription users

Warning: Invalid argument supplied for foreach() in /home/sites/site8/web/b/includes/functions.php on line 2878

Warning: Invalid argument supplied for foreach() in /home/sites/site8/web/b/includes/functions.php on line 2878

Warning: Invalid argument supplied for foreach() in /home/sites/site8/web/b/includes/functions.php on line 2878

I see others have had similar, though I have no mySQL error with it, and the everything seems to work fine updating the subscription. I don't have the store hack or cash hack installed...

I'd just like to know what it means, and if it'll affect anything on my board or subscriptions.

nice hack though, btw.

[Bryan Ex]

Did you edit functions.php with dreamweaver by chance? If so it's one of a couple of vB3 files it will mess up by changing code on you.