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

[us44ever]

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

PHP Code:

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

MySQL Error  : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date         : Monday, September 25th 2006 @ 01:13:08 AM
Script       : ........
Referrer     : ..........
IP Address   : ..............
Username     : ............
Classname    : vB_Database_MySQLi 


[us44ever]

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

[us44ever]

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

PHP Code:

There seems to have been a problem with the ....... database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience. 


[us44ever]

any help ?
thanks

[Konstantinos]

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

[MUDERCOOL]

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

[ImportPassion]

i had a little chuckle over this

Select yes or no if you want to enable or disable the system

yes i want to disable? yes I want to enable?

anyway, thanks for the plugin!

[ImportPassion]

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.

[ImportPassion]

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?

[paul41598]

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