Forum Home Enhancements - Latest Paid Subscribers v1.1

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)

• 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

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.

[Quarterbore]

Originally Posted by 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.

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]

Originally Posted by 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!

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]

Originally Posted by Lionel

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.