Version: 1.00, by paul41598
Developer Last Online: Jun 2013
Version: 3.5.4
Rating:
Released: 08-22-2006
Last Update: 02-24-2007
Installs: 21
Uses Plugins Template Edits
No support by the author.
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
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
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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
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.
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
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?