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

Thanks , very usefull.
Any chance to make image border "0" when i have icons before usernames ?

see attached picture

edit: ok when i disable Allow Subscriber Info In HoverOver? it looks quite good :)

thanks

Excellent! I'm lovin' it!

Great addon! Did anybody check this with 3.6? Would be exactly what I need!

Where do i edit the announcement background color ? ITs all dark at my site.

TIA

Template: expirydatebits

installed but found a couple bugs

When you turn the hack off it still displays the title but only the members disapear. The title and members need to disapear or this will be a bit discouraging.

Next if you disable Allow Subscriber Info In HoverOver? it still show up when you hover.

Please fix

Also how do you change the member alert message? Whould be nice to change that within the hack

thats because the phrase still remains in the template when the system is turned off.

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


Look above.

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!

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

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.

Cool Installed :)

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?

Ive reinstalled twice I am running vb 3.5.3

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

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.

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??

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

:) it works

I change to this also the plugin

ANd its Ok now

:)

Byt how can i get The month insted of numbers?

Um... heres a wild guess. %F %js, %Y

I'm getting the same message -- running 3.5.2

sounds like a pre 3.5.4 issue. I'd suggest upgrading

cool, awsome hack, thank you... installed :)

I installed and it seems to be working but it's throwing the forums off center. The names keep going to the left off the screen, is there a way to make it on the next line?

Edit: I changed the way it was layed out, kept the forum inline:

<div style="white-space: nowrap"><phrase 1="$recordusers" 2="$recorddate" 3="$recordtime">$vbphrase[most_users_ever_online_was_x_y_at_z]</phrase>
<div>$activeusers</div>
$vbphrase[last_paid_subscribers_display]
$showsubscribers</div>

i updgade to 3.6.0 and doesnt work :(

Invalid SQL:

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

MySQL Error : Unknown column 'subscription.title' in 'field list'
Error Number : 1054

No support HERE???

This hack is for 3.5.4, so I don't presume it works on 3.6. I would suggest putting back on 3.5 if you want to continue using this hack

:) good idea.. lol

its not possible to update the mod to 3.6.x??

i try to make it to work byt nothing..happent

guys my forums gone !!!
there is no forum anymore
please any help ?
this is the msg
Database error in vBulletin 3.5.4:

now the forum working fine , i restart the machine .
thanks

found bugs ..
when i cheak on yes on this option
Display Reminder Window for Subscribers (ForumHome)?
Select yes to show a reminder message to your subscribers with their subscription info on forumhome Yes No
the forum said when anyone login

any help ?
thanks

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 vbsubscriptionlog AS subscriptionlog
LEFT JOIN vbuser ON (subscriptionlog.userid = user.userid)
LEFT JOIN vbusergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vbusergroup 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 : Saturday, October 7th 2006 @ 11:21:16 AM

is it possible to show the length of subscription and ending time? on forumhome?
that would be great for the members

i had a little chuckle over this
yes i want to disable? yes I want to enable?

anyway, thanks for the plugin!

I am having issues with the sql too...but i know the problem. He is aliasing the tables with their full name but not using the table prefix on them

SELECT [prefix here]subscriptionlog.userid, [prefix here]subscriptionlog.status, [prefix here]subscriptionlog.regdate, [prefix here]subscriptionlog.expirydate,
[prefix here]user.userid, [prefix here]user.username, [prefix here]user.usergroupid,

I am going to fix this and do a new XML file for everyone.

sorry, thought it was that easy, but it isn't. Looks like the subscription titles are now stored as phrases in 3.6. kinda weird, but i guess they have their reasons. not sure if i will fix it. maybe there is a 3.6 version?

us4ever please pm me with a link to your forums. I'll have to investiage myself