Latest Paid Subscribers v1.0

Brought to you by myself with credits to Kaezul as well
From the guys who brought you "Incomplete Profile Fields"


We Bring To You:
Latest Paid Subscribers v1.0

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:

• 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

Notes:
- Adds 1 extra query
- Advanced Options (if you see fit to use)


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.


This is now a premium hack only, available through myself

[dennisuello]

I received a DB error when I installed this. I promptly uninstalled it, as to not keep my forum down.

Invalid SQL:

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

MySQL Error : Unknown column 'user.userid' in 'field list'

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscription.title, 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 < 1159026430
GROUP BY subscription.title
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'

Invalid SQL:

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

MySQL Error : Unknown column 'user.userid' in 'field list'

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscription.title, 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 < 1159026435
GROUP BY subscription.title
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'

[Bad Bunny]

This is pretty cool. If I start using subscriptions I would love to see this for 3.6! This really would be a great default feature.

[rmxs]

Cool Installed

[bada_bing]

Originally Posted by bada_bing

thats because the phrase still remains in the template when the system is turned off.
OK how do I make it so that when I turn the hack off the phrase is also disabled? this makes more sense to me.

Not on my system. When turned off, it will show their default markup title. Seems to be working as designed.
This is not happening on my system!

Any help please before I uninstall

[paul41598]

Originally Posted by bada_bing

Any help please before I uninstall

Noone else seems to be having the same issues as you, so I'd either reinstall the product, or let me investigate personally on your site. Also what version of VB do you run?

[bada_bing]

Originally Posted by paul41598

Noone else seems to be having the same issues as you, so I'd either reinstall the product, or let me investigate personally on your site. Also what version of VB do you run?

Ive reinstalled twice I am running vb 3.5.3

[MUDERCOOL]

I have the same problems with bada_bing and I have 3.5.3, too

[paul41598]

one of you two will have to PM me, so I can get on ur forums and investigate. Might be incompatible with 3.5.3, not sure.

[rmxs]

Plzzz help me i get this on the Reminder

I change it to m-d-Y Byt i get


subscription expires on F jS,

EDIT: this apeard only with greek lang with all other langs its Ok



How can i corect this??

[paul41598]

Not entirely sure. Try %d-%m-%y