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

[rmxs]

it works

I change to this also the plugin

$expirydate = vbdate('%d-%m-%y', $getexpirer['expirydate']);

ANd its Ok now



Byt how can i get The month insted of numbers?

[paul41598]

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

[ChurchMedia]

I'm getting the same message -- running 3.5.2

Database error in vBulletin 3.5.2:

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 = 1 AND subscriptionlog.expirydate < 1159150769
GROUP BY subscription.title
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

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

[paul41598]

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

[upsetter]

cool, awsome hack, thank you... installed

[VTXCafe.com]

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>

[rmxs]

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

[rmxs]

No support HERE???

[paul41598]

Originally Posted by rmxs

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

[rmxs]

Originally Posted by paul41598

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