Latest Paid Subscribers v1.1

[paul41598]

Latest Paid Subscribers v1.1 (LITE VER) :)

- This Hack Does Use The Usergroups Markup Color For A More Accurate Display Of Subscription Members!! This Hack Has It All!

Description:
This hack is fully functional and flexible allowing you to display the latest [x] subscribers on your forumhome! It also allows you to display a reminder/alert to your users who's subscriptions are expiring.

Features: (Lite Version)
Activate The System (Latest Paid Subscribers)
Select The Number Of Subscribers To Show On ForumHome


Features: (Premium Version Only (http://chugger.homeip.net/myhacks/))
Activate The System (Latest Paid Subscribers)
Select The Number Of Subscribers To Show On ForumHome
Display A Reminder/Alert Window To Warn Subscribers When Their Subscription Is Up
Select The Number Of Days Before That Reminder Shows
Never Show This Again For Reminder Alert!
Allow The Subscriber Info In The Title HoverOver Or Turn It Off
Select A Date Format For That HoverOver


Installation:
1.) 1 Template Edit
2.) 1 Product Upload
3.) Enjoy Release

Bug Fixes:
Allow Subscriber Info In HoverOver Never Worked - FIXED
Activate Latest Paid Subscribers Only Deactivated The Users, Not The Phrases Or Expiry Alert. - FIXED
SQL Bugs. - FIXED

Notes:
- Adds 1 extra query
- Premium Version Of Hacks Found Here (http://chugger.homeip.net/myhacks/)

If you find any bugs, have comments, questions feel free to post them. I'll do my best to accomidate anything.
Disclaimer: Any modification to this hack, must get prior consent/authorization by me first.

[steelerwatch]

Nice - but could you work something up that recognizes recrurring contributors as well? This only displays brand new contributors.

[Distance]

yeah true, its the whole

'special offer to new customers'

thing again

[paul41598]

we'll see, maybe in th next version

[Quarterbore]

I HAD a strange error from vB 3.6.0...

Problem resolved as posted below

[Snake]

Wow that is great!

[rmxs]

Installed and works :)

thanks

[oberheimhaven]

had huge sql error uninstalled!! Ouch

[Quarterbore]

OK, I got help from paul41598 on this but by changing the Latest Paid Subscribers pluggin to as follows this works 100% on my site (tested in 3.6.0. and 3.6.1.)



// plugin by Paul41598

if ($vbulletin->options['latest_paid_subscribers_reminder_on'])
{
if ($vbulletin->userinfo['userid'] AND !$_COOKIE['lpscookie']) {
$alertdays = $vbulletin->options['latest_paid_subscribers_warndays'];
$day1 = (TIMENOW + ($alertdays * 86400));
$getexpirers = $vbulletin->db->query_read("
SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog, " . TABLE_PREFIX . "subscription AS subscription
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = ".$vbulletin->userinfo['userid']." AND subscriptionlog.expirydate < $day1
ORDER BY subscriptionlog.expirydate ASC LIMIT 5");


while($getexpirer = $vbulletin->db->fetch_array($getexpirers))
{
$expiryremaining = round((($getexpirer['expirydate'] - TIMENOW)/86400),2);
$expirytitle = $getexpirer['title'];
$expirydate = vbdate('F jS, Y', $getexpirer['expirydate']);
eval('$expiryalert .= "' . fetch_template('expirydatebits') . '";');
}
}
}

if ($vbulletin->options['latest_paid_subscribers_on'])
{
$show['subscribers'] = true;
$max = $vbulletin->options['latest_paid_subscribers'];

$getsubscribers = $vbulletin->db->query_read("
SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
usergroup.usergroupid, usergroup.title,
groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
LEFT JOIN " . TABLE_PREFIX . "user as user ON (subscriptionlog.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, $max");


if ($vbulletin->db->num_rows($getsubscribers) > 0)
{
$count = 0;
while($getsubscriber = $vbulletin->db->fetch_array($getsubscribers))
{

$getsubscriber['opentag'] = $getsubscriber['opentagb'] ? $getsubscriber['opentagb'] : $getsubscriber['opentaga'];
$getsubscriber['closetag'] = $getsubscriber['closetagb'] ? $getsubscriber['closetagb'] : $getsubscriber['closetaga'];

if ($vbulletin->options['latest_paid_subscribers_dateselect'])
{
$expireson = vbdate($vbulletin->options['latest_paid_subscribers_dateselect'], $getsubscriber['expirydate']);
}
else {
$expireson = vbdate($vbulletin->options['dateformat'], $getsubscriber['expirydate']);
}

if ($vbulletin->options['latest_paid_subscribers_hoverover']) {
$subscribers[$count] .= "<a href=\"member.php?" . $vbulletin->options[sessionurl] . "u=$getsubscriber[userid]\" title='$getsubscriber[username] Subscription Expires On: $expireson'>";
$subscribers[$count] .= $getsubscriber['opentag'].$getsubscriber['username'].$getsubscriber['closetag']."</a>";
$count++;
}
else {
$subscribers[$count] .= "<a href=\"member.php?" . $vbulletin->options[sessionurl] . "u=$getsubscriber[userid]\" title='$getsubscriber[title]'>";
$subscribers[$count] .= $getsubscriber['opentag'].$getsubscriber['username'].$getsubscriber['closetag']."</a>";
$count++;
}

}

$showsubscribers = implode(", ", $subscribers);
unset($count, $getsubscriber, $max);
@mysql_free_result($getsubscribers);
}
}


The difference is in these TWO lines of code!


LEFT JOIN " . TABLE_PREFIX . "user as user ON (subscriptionlog.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid)


My site uses PHP 4.4.1. and MySQL 4.1.21 in case that helps debug this... but it works 100% with those two "As" terms included!

Oh yea, did you mean to have you help link in your hack go to Google (as opposed to here?)?

[jgommel]

Not sure if this a 3.6.2 issue, but I just intalled and now I'm getting database errors. If I deactivate the hack, I'm back to normal. I checked my Template edits... all there and correct according to the documentation.

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
usergroup.usergroupid, usergroup.title,
groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb_subscriptionlog AS subscriptionlog
LEFT JOIN vb_user ON (subscriptionlog.userid = user.userid)
LEFT JOIN vb_usergroup ON(user.usergroupid = usergroup.usergroupid)
LEFT JOIN vb_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, 5;

MySQL Error : Unknown table 'user' in field list
Error Number : 1109
Date : Tuesday, October 10th 2006 @ 03:35:33 PM
Script : http://www.website.com/vb/
Referrer : http://www.website.com/index.php
IP Address : xx.xx.xx.xx
Username : xxxxxxxx
Classname : vb_database

and

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
usergroup.usergroupid, usergroup.title,
groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb_subscriptionlog AS subscriptionlog
LEFT JOIN vb_user ON (subscriptionlog.userid = user.userid)
LEFT JOIN vb_usergroup ON(user.usergroupid = usergroup.usergroupid)
LEFT JOIN vb_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, 5;

MySQL Error : Unknown table 'user' in field list
Error Number : 1109
Date : Tuesday, October 10th 2006 @ 03:36:30 PM
Script : http://www.website.com/index.php
Referrer : http://www.website.com/index.php
IP Address : xx.xx.x.xx
Username : xxxxxx
Classname : vb_database

Site Stats:
Apache Server 1.3.37 (Unix)
PHP 4.4.4
MySQL 4.1.21
vBulletin 3.6.2
vBadvanced CMPS 2.2.0

[Quarterbore]

Not sure if this a 3.6.2 issue, but I just intalled and now I'm getting database errors. If I deactivate the hack, I'm back to normal. I checked my Template edits... all there and correct according to the documentation.



Try the changes I needed... (they are posted)

I am curious if this code is on the correct hook?

This looks like a lot of work to be attached to Global start!

I moved mine to ForumHome_start and it works fine and this code is not getting executed with every page view on the site anymore!

[jgommel]

Thanks for the suggestion Quarterbore, but that didn't work. I'll just uninstall it for now and watch the thread for future releases, ot other solutions.

Thanks again!

[Anarchy]

Yes it's not working in 3.6.2

I get the same error.

[paul41598]

Ok, I've done some major troubleshooting tonight folks.

It seems as though by making the changes that jgommel & I have come up with, it does solve ALL issues. I actually did a series of tests.


Installed 3.6.2 vbulletin WITH NO TABLE PREFIXES (Fresh Install), then installed the hack. Worked flawlessly.

Installed 3.6.2 vbulletin WITH TABLE PREFIXES (Fresh Install), then installed the hack, and got database errors.


So the issue lies with all you guys who have table prefixes configured in your database, via the config.php file.

I then made the above changes to my XML product, reimported and it worked fine. This hack WILL work on 3.6.1 & 3.6.2. If it's not, you have some sort of special case, which I can examine further via PM.

Thanks again! ;)

[Quarterbore]

I'll ask again... Why do you have this hooked off Global Start? This is only used on ForumHome, right? It seems crazy to run this on every page users visit when it is only needed on that one page!

It works fine on my site relocated to ForumHome_start!

[paul41598]

I'll ask again... Why do you have this hooked off Global Start? This is only used on ForumHome, right? It seems crazy to run this on every page users visit when it is only needed on that one page!

It works fine on my site relocated to ForumHome_start!
seems as though that might be a small bug. If it works on forumhome_start then that should be the preferred method. I'll have to update the zip file

[Lionel]

I had the same problem with everybody, but changing it as per the post fixes it

Since it's at global, I can use it on a vbadvanced page right, providing I put the variable in the vba globals?

[paul41598]

Ok everyone,

I've updated the XML file with the SQL bug fixes, and put it a more suitable hook location.

Please download the above zip file ( latest paid subscribers 1.1 update.zip )

[Lionel]

how would I go to make message appears on vbadvanced?

[paul41598]

how would I go to make message appears on vbadvanced?
Now I've never created a vbadvanced module before, so bare with me. However, below is the module I created. I've tested and it seems to work on my forums. Just follow the directions and hopefully it will work for you too. ;)

[rmxs]

Maybe for the Reminder to dispayed in all pages

[jgommel]

Okay, this time around it installed just fine. Thanks for the update paul41598. I hope you don't mind, but because I'm meticulous about appearance and placement. I decided to code this into it's own FORUMHOME "What's Going On" box and remove it from within the "Currently Active Users" box.

For those who want to do the same, here's what I did...

Disregard Step 1 (Edit Templates) in paul41598's instructions and instead, do this...

Template Name: forumhome

Find:
<!-- end logged-in users -->
</if>

Add below:
<!-- Latest Paid Subscribers -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('paid_subscribers')"><img id="collapseimg_paid_subscribers" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_paid_subscribers].gif" alt="" border="0" /></a>
<phrase 1="$show[subscribers]">$vbphrase[last_paid_subscribers_display]</phrase>
</tr>
</tbody>
<tbody id="collapseobj_paid_subscribers" style="$vbcollapse[collapseobj_paid_subscribers]">
<tr>
<td class="alt2"><img src="$stylevar[imgdir_misc]/whos_online.gif" alt="Paid Subscribers" border="0" /></td>
<td class="alt1" width="100%"><div class="smallfont">$showsubscribers</div></td>
</tr>
</tbody>

Find:
$navbar

Add Below:
<if condition="$show['subscribers']">$expiryalert</if>

Continue with Step 2 (Load The Product)

I'm going to look at your vBAdvanced module too and see if there's anything else I can do to it as well.

Thanks!

[whitetigergrowl]

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM vb_subscriptionlog AS subscriptionlog, vb_subscription AS subscription
LEFT JOIN vb_user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 1 AND subscriptionlog.expirydate < 1163203283
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 07:01:23 PM
Script : http://www.mywebsite.com/community/index.php
Referrer : http://www.mywebsite.com/community/admincp/index.php?do=head
IP Address : *********
Username : ********
Classname : vB_Database

Sensite info blocked out. I have followed this to a T and this is the sql error I recieve. I use php and sql 5+.

[jgommel]

Did you download 'latest paid subscribers 1.1.zip' or 'latest paid subscribers 1.1 update.zip'

Uninstall the one on your vBulletin board and then Download the 'latest paid subscribers 1.1 update.zip' from here and install this one.

[Lionel]

Now I've never created a vbadvanced module before, so bare with me. However, below is the module I created. I've tested and it seems to work on my forums. Just follow the directions and hopefully it will work for you too. ;)

Thanks. I kept it at global hook and simply put the variable in vbadavanced global

[whitetigergrowl]

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM vb_subscriptionlog AS subscriptionlog, vb_subscription AS subscription
LEFT JOIN vb_user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 1 AND subscriptionlog.expirydate < 1163215075
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 10:17:55 PM
Script : http://www..com/community/index.php
Referrer : http://www..com/community/admincp/index.php?do=head
IP Address :
Username :
Classname : vB_Database

Tried both. This is the error with the update one. (Minus sensitive info)

[TVNettet]

Tried both your files, got db error on vb3.6.2 Read about your fresh install, unfortunately have too much stuff already installed to go through all of those again, but nice try all the same.
Had a similar product working in earleir vB version and it was gr8!!
I'll keep an eye out for any updates you release...

[Quarterbore]

If you don't mind... I would like some help changing the hover from the "Subscription Expires On DATE" to a message that says "Subscription to "SUBSCRIPTION NAME" on DATE"

For new subscribers, it isn't urgent that they resubscribe... but I would like to recognize them for their contribution as I have several levels of contributor!

Also, I tried to move the pluggin code for the subscription expiring to a new pluggin and I hooked it to global_start. Then I used the template change and added the notification to SHOWTHREAD template.

It works for a base install but it will not work on my site because of the way I use vbAdvanced (my site is linked below). I'll figure it out one of these days...

[scottct1]

How do I set the message shown to users when there subscription is about to expire.

I searched for the phrase expiryalert and did not find anything.

[paul41598]

How do I set the message shown to users when there subscription is about to expire.

I searched for the phrase expiryalert and did not find anything.
Its in the template "expirydatebits"

[Robbed]

The link to edit the phrase doesn't work.

[us44ever]

paul41598
what about 3.5.4 ?
there is no support or any assistance and still have the same problem in the databese.
please i need this hack , could you help me with that .
with regards

[sunnycher]

Installed! THANK YOU!!

Now if I could just figure out how to get my what's going on box at top instead of the bottom! lol

[dennisuello]

Tried both. This is the error with the update one. (Minus sensitive info)

I get the same errorDatabase error in vBulletin 3.6.4:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM vb3_subscriptionlog AS subscriptionlog, vb3_subscription AS subscription
LEFT JOIN vb3_user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 1 AND subscriptionlog.expirydate < 1167247465
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Monday, November 27th 2006 @ 11:24:25 AM
Script : http://www.reno4x4.com/forum/
Referrer : http://www.reno4x4.com/
IP Address : ******
Username : ******
Classname : vB_Database

[dennisuello]

I selected No for the "Display Reminder Window for Subscribers (ForumHome)?" option, and now forumhome works. But I would like the reminder to work too.

[Bounce]

The link to edit the phrase doesn't work.

Yip same here..Running 3.6.4 ... also if you have more than 5 selected it takes the width of the forums way beyond what it should be and you need to scroll instead of starting a new line?

Great Hack thou ..

*Installed*

Installed! THANK YOU!!

Now if I could just figure out how to get my what's going on box at top instead of the bottom! lol

http://www.vbulletin.com/forum/showpost.php?p=1240702&postcount=4

AdminCP => Styles & Templates => Style Manager => <>

Then choose the FORUMHOME template, which you'll find under Forum Home Templates.

There, search for the code that indicates the begininng & end of the What's Going on box. It should begin like this:

<!-- what's going on box -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
<td class="tcat" colspan="2">$vbphrase[whats_going_on]</td>
</tr>
</thead>
<if condition="$show['loggedinusers']">
<!-- logged-in users -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_activeusers')"><img id="collapseimg_forumhome_activeusers" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_activeusers].gif" alt="" border="0" /></a>
<a href="online.php$session[sessionurl_q]" rel="nofollow">$vbphrase[currently_active_users]</a>: $totalonline (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_activeusers" style="$vbcollapse[collapseobj_forumhome_activeusers]">
<tr>
<td class="alt2"><a href="online.php$session[sessionurl_q]" rel="nofollow"><img src="$stylevar[imgdir_misc]/whos_online.gif" alt="$vbphrase[view_whos_online]" border="0" /></a></td>
<td class="alt1" width="100%">
<div class="smallfont">
<div style="white-space: nowrap"><phrase 1="$recordusers" 2="$recorddate" 3="$recordtime">$vbphrase[most_users_ever_online_was_x_y_at_z]</phrase></div>
<div>$activeusers</div>
</div>
</td>
</tr>
</tbody>
<!-- end logged-in users -->
</if>
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_stats')"><img id="collapseimg_forumhome_stats" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_stats].gif" alt="" border="0" /></a>
<phrase 1="$vboptions">$vbphrase[x_statistics]</phrase>
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_stats" style="$vbcollapse[collapseobj_forumhome_stats]">
<tr>
<td class="alt2"><img src="$stylevar[imgdir_misc]/stats.gif" alt="<phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase>" border="0" /></td>
<td class="alt1" width="100%">
<div class="smallfont">
<div>
$vbphrase[threads]: $totalthreads,
$vbphrase[posts]: $totalposts,
$vbphrase[members]: $numbermembers<if condition="$show['activemembers']">,
<span title="<phrase 1="$vboptions[activememberdays]">$vbphrase[within_the_last_x_days]</phrase>">$vbphrase[active_members]: $activemembers</span>
</if>
</div>
<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
</div>
</td>
</tr>
</tbody>
<if condition="$show['birthdays']">
<!-- today's birthdays -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_birthdays')"><img id="collapseimg_forumhome_birthdays" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_birthdays].gif" alt="" border="0" /></a>
$vbphrase[todays_birthdays]
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_birthdays" style="$vbcollapse[collapseobj_forumhome_birthdays]">
<tr>
<td class="alt2"><a href="calendar.php?$session[sessionurl]do=getday&amp;day=$today&amp;sb=1"><img src="$stylevar[imgdir_misc]/birthday.gif" alt="$vbphrase[view_birthdays]" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$birthdays</div></td>
</tr>
</tbody>
<!-- end today's birthdays -->
</if>
<if condition="$show['upcomingevents']">
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_events')"><img id="collapseimg_forumhome_events" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_events].gif" alt="" border="0" /></a>
<if condition="$show['todaysevents']">$vbphrase[todays_events]<else /><phrase 1="$vboptions[showevents]">$vbphrase[upcoming_events_for_the_next_x_days]</phrase></if>
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
<tr>
<td class="alt2"><a href="calendar.php$session[sessionurl_q]"><img src="$stylevar[imgdir_misc]/calendar.gif" alt="$vbphrase[calendar]" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$upcomingevents</div></td>
</tr>
</tbody>
</if>
</table>
<br />
<!-- end what's going on box -->
Cut that code at of your FORUMHOME template & put right under $navbar.

</head>
<body>
$header
$navbar

[B]PUT IT HERE

<!-- main -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
My What's Going On box is modified so yours might not look the same, but be sure to copy all code between <!-- what's going on box --> &<!-- end what's going on box --> comments.

[Caerydd]

This looks like a great hack, but is there any update on those sql errors and such like, and also the issue about a forumhome only query? I don't need this to be a global call.

And yes, I am aware of the previous discussion, but subsequent posts also report errors, and I prefer to work from the main installation post knowing that it is a relatively stable hack.

[paul41598]

the updated zip file has the hook location at forumhome. The hack works.

b.t.w, for those who cant edit the phrase directly through the hyperlink, you can fix it by editing the phrase: (setting_latest_paid_subscribers_desc)

and change:

&e[1]

to:

&e[global]

[bada_bing]

Does this hack work with vb 3.6.4 ?

[Raptor]

works great on 3.6.4

[afmarko99]

the updated zip file has the hook location at forumhome. The hack works.

b.t.w, for those who cant edit the phrase directly through the hyperlink, you can fix it by editing the phrase: (setting_latest_paid_subscribers_desc)

and change:

&e[1]

to:

&e[global]


Where do I find these codes? FORUMHOME template? I looked there but didnt find these.

Also how would I go about changing the color of the usernames?

[jdebler]

Its in the template "expirydatebits"

Thanks for the clarification!

Question...
When modifying that template, if I have two different subscriptions and I want to display one of two different expiration warning messages that depends on the subscription they are currently on, how would I do that?

I tried the following based on the usergroup that my subscriptions put the user in:

<if condition="is_member_of($post, 1)">
<div align="center" class="tborder" style="padding: 2px;">
(Expiration warning message to Subscription level 1)</span></div>
</div>
</if>

<if condition="is_member_of($post, 2)">
<div align="center" class="tborder" style="padding: 2px;">
(Expiration warning message to Subscription level 2)</span></div>
</div>
</if>


But that didn't work, neither message shows up. What did I miss? Also, is there a specific if condition that I should use that is based on current subscription instead of current usergroup?

[paul41598]

Where do I find these codes? FORUMHOME template? I looked there but didnt find these.

Also how would I go about changing the color of the usernames?

They're in the phrases. Can't change the color of the usernames, thats why this hack focus's on usergroup markup colors. Theres another subscription hack on here, that will allow you to change the colors, but its not nearly as advanced as mine.

Thanks for the clarification!

Question...
When modifying that template, if I have two different subscriptions and I want to display one of two different expiration warning messages that depends on the subscription they are currently on, how would I do that?

I tried the following based on the usergroup that my subscriptions put the user in:

<if condition="is_member_of($post, 1)">
<div align="center" class="tborder" style="padding: 2px;">
(Expiration warning message to Subscription level 1)</span></div>
</div>
</if>

<if condition="is_member_of($post, 2)">
<div align="center" class="tborder" style="padding: 2px;">
(Expiration warning message to Subscription level 2)</span></div>
</div>
</if>


But that didn't work, neither message shows up. What did I miss? Also, is there a specific if condition that I should use that is based on current subscription instead of current usergroup?
Try $bbuserinfo instead of $post in those conditions ;)

[jdebler]

Try $bbuserinfo instead of $post in those conditions ;)

BAH! I knew it was something like that. It worked, thanks!

Nice car. :cool:

[KipLarson]

Just what I was looking for... I'm going to possibly come back and let you know how it works in 3.61

[jdebler]

Works fine on 3.6.4

[sunnycher]

I installed this on my new site but it seems to stretch the 'whats going on box' (current activity). Any fix to this?

Thank yoU!!

[mandy71480]

This is great and will really help out woth my boards now that I'm offering paid memberships

[T_Richardson]

Works great on 3.6.4

One question, does anyone know how i can add the amount they paid along side?

Thanks.

[T_Richardson]

Anyone?
For example;

Thankyou to our latest contributing members: Memername Feb, 10 2007, $10.00, Membername2 Feb, 09 2007, $5.00

or have it in a table ;

Memername $10.00 | Feb, 10 2007
Membername2 $5.00 | Feb, 09 2007

I would do it myself, but getting data from mysql is beyond me.

[es-league.com]

stretches the box for me too, would be great
If this could be made into a module for vbadvanced ....
Is it possible ??

[Bounce]

I installed this on my new site but it seems to stretch the 'whats going on box' (current activity). Any fix to this?


stretches the box for me too, would be great




Reduce the number on display to 4 :D

[mandy71480]

I had to uninstall it because of the same problems with the stretching and also people getting confused in the who's online thinking they were listed twice. I hope to be able to install it again later if that gets fixed or if I get unlazy enough to figure it out on my own :p

[paul41598]

I had to uninstall it because of the same problems with the stretching and also people getting confused in the who's online thinking they were listed twice. I hope to be able to install it again later if that gets fixed or if I get unlazy enough to figure it out on my own :p
for stretching reduce # to 4 for now.. and for people getting confused, just move the template code to somewhere else less confusing. Not hard...

[T_Richardson]

for stretching reduce # to 4 for now.. and for people getting confused, just move the template code to somewhere else less confusing. Not hard...
Exactly! I put the code in the Welcome Panel (https://vborg.vbsupport.ru/showthread.php?t=100672), fits nicely.

Would be nice if it showed the amount they donated, but it'll do.

[winpro19]

Hmm, I dont see any files ? :S

[Tom_S]

Me either. Where exactly is the download?

[T_Richardson]

The author must have taken it out for some reason.

[Tom_S]

I see the author online so maybe he will shed some light on the subject.

[winpro19]

Maybe....please help us out here Mr. Author. Thanks

[paul41598]

updated

[dbirosel]

I will be installing this soon, but was wondering, if it's possible to have a seperate page, to show all those kind people that donated?

This is how mine looks right now, and i have to update it every single time...

http://www.caraudiojunkyard.com/forum/showthread.php?t=87

[dbirosel]

And also, i am really interested in paying if that is possible. for the pro version + my suggesiton.

[paul41598]

I think I can swing that & the ability to show how much the user paid as an option. Maybe I'll work on Version 2.0 now...

[dbirosel]

I think I can swing that & the ability to show how much the user paid as an option. Maybe I'll work on Version 2.0 now...
Sweet, please PM me when it's up and running. Like i said i will pay for the premium.:D Thanks

[Tom_S]

Great job on this mod ;)
Installed!

[paul41598]

The new "addon" will look something like below.

Taking some time to write, lotsa tricky code, but its just about near completion and will be put along side the premium version

[beano33]

It didn't work for me on 3.6.4 doing a clean install. I got the same sql error that's been mentioned by others in this thread. I was hoping to use the reminder feature only. I'm using MySQL Version 5.0.33-log.

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM subscriptionlog AS subscriptionlog, subscription AS subscription
LEFT JOIN user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 171 AND subscriptionlog.expirydate < 1175637844
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Sunday, March 4th 2007 @ 04:04:04 PM

[paul41598]

I believe thats due to the mysql version 5

[dbirosel]

Premium hack been updated yet?

[paul41598]

Premium hack been updated yet?
in terms of?

[Bounce]

I believe thats due to the mysql version 5


correct , will this hack be either updated or released for workingf on mysql 5 ?

I've had to remove it because of this :( great add on :)

[Derekclarke]

I updated to the latest version yesterday, and it has put the screen resolution of my forum out.

meaning you always have to scroll left to right to view the forum home page.

If i disable the plugins for this, the forum goes back to Normal.

Is it just me, or do others have this issue too.

and can it be fixed?

Many Thanks
Derek

[paul41598]

correct , will this hack be either updated or released for workingf on mysql 5 ?

I've had to remove it because of this :( great add on :)


Not unless Someones gets me a test server with mysql 5 on it, lol


I updated to the latest version yesterday, and it has put the screen resolution of my forum out.

meaning you always have to scroll left to right to view the forum home page.

If i disable the plugins for this, the forum goes back to Normal.

Is it just me, or do others have this issue too.

and can it be fixed?

Many Thanks
Derek

Yes either limit the number of paid subscribers from 5 to 3 or 4. Or just move that bit completey somewhere else.

[dbirosel]

in terms of?
The listing of paid subscribers and stuff.

[Bounce]

Not unless Someones gets me a test server with mysql 5 on it, lol





it could be arranged paul :up:

[toonysnn]

Not unless Someones gets me a test server with mysql 5 on it, lol
That can be arranged, if you want MySQL Version 5.0.18 that is :p

I can provide you with a test 'hosting' account (Still working on the host cpanel thing [windows hosting]). If you want, that is. PHP is version 5.1.2 and apache 2.2.0. Though, the download speed is slow, the upload speed should be fast, as it should be up to 300 KB/s I think.

BTW, awesome hack!

[paul41598]

The listing of paid subscribers and stuff.

If you were the one I talked to one AIM, I think we discussed the addon already :rolleyes:


For everyone else responding about mysql, if you do have something available, just PM me about it, and I'll play with it once I have a bit of time.

[tarionyx]

Any updates regarding MySQL 5? I'm running 5.0.22

[DieselMinded]

Where do i change Thankyou to our latest contributing members:

In the Vb Options it says To edit the phrase for this message click here (enter your custom text in the translation box

Well I clicked here and keep getting No Phrases Matched Your Query

[DieselMinded]

Better Yet how do i get this to show under the Newest members in Vbtrends

www.dieselbombers.com

[DieselMinded]

I got it there had to put the code directly above <--end vb trends--> in the forum home template but the Font size is different how can i edit this

Thanks

DM

[DieselMinded]

I just went into the xml and changed it <phrasetype name="GLOBAL" fieldname="global">
<phrase name="last_paid_subscribers_display">
<![CDATA[A Big Thank You To Our Latest Supporters:]]></phrase>
</phrasetype>

Now How do i Fix the Font ?

[networktemple]

cant download the link

[DieselMinded]

I just went into the xml and changed it

Now How do i Fix the Font ?

Anyone?

[winpro19]

Any fix for MySql version 5...? Great plug in I must say!

[webhost]

Any fix for MySql version 5.0.45

[rmxs]

what about mysql 5 errors?

[Raptor]

works great

[rmxs]

FIXED:...

I dont know if the coder wont to get my litlle piece of code byt the code its here :)

[rmxs]

I make it work also with mysql5

[beano33]

I make it work also with mysql5
What did you do to fix it?

[SVTCobraLTD]

Installed 3.6.8 pl2

[rmxs]

What did you do to fix it?

mysql5 have change some varriables...

i edit one little part of code and its ok now!

If i get permission to post the fix its ok!!!

[ccaldwell]

When do you think you will have a fix for mySQL Version 5? This is a great hack and I would like to use it if possible.

If anyone does have a fix can they please post it?

[rmxs]

paul41598 can i export my product and sent it to you?

i thing many people interesting