Latest Paid Subscribers v1.0

[paul41598]

Brought to you by myself with credits to Kaezul (https://vborg.vbsupport.ru/member.php?u=78279) 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

[sensimilla]

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

[Snake]

Excellent! I'm lovin' it!

[Nachtfalke]

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

[sensimilla]

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

TIA

[paul41598]

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

TIA
Template: expirydatebits

[bada_bing]

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

[bada_bing]

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

[paul41598]

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.

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


Next if you disable Allow Subscriber Info In HoverOver? it still show up when you hover.
Not on my system. When turned off, it will show their default markup title. Seems to be working as designed.


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

[bada_bing]

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!

[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]

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]

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]

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

[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]

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]

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

[us44ever]

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

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

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

[paul41598]

update attached for this hack with latest bug fixes. Non-tested though

[Konstantinos]

tested in 3.5.4 and works cool so far and no sql errors

[paul41598]

tested in 3.5.4 and works cool so far and no sql errors
Cool ;)

[us44ever]

here is the msg after adding the product
Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO product
(productid, title, description, version, active)
VALUES
('Latest Paid Subscribers v1.1',
'Latest Paid Subscribers',
'Display The Latest Subscribers v1.1',
'1.1',
1);

MySQL Error : Duplicate entry 'Latest Paid Subscribers v' for key 1
Error Number : 1062
Date : Friday, October 20th 2006 @ 11:28:40 PM
Script : ******
Referrer : ******
do=productadd
IP Address : ******
Username : bokhalaf
Classname : vB_Database_MySQLi

[paul41598]

here is the msg after adding the product
Database error in vBulletin 3.5.4:
hopefully you uninstalled the old one..and then reinstalled the new one "overwrite" selected to YES

[us44ever]

hopefully you uninstalled the old one..and then reinstalled the new one "overwrite" selected to YES
now i uninstall the old one and install the update version
this proeblem has bees fixed " erorr while install it"
but still the same Erorr in database, when i keep you hack enable i face this erorr when i turn it off everything working fine.
btw i install new vbulletin on my machine and install the hack , also i face the same problem .

Database error in vBulletin 3.5.4:

Invalid SQL:

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

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Saturday, October 21st 2006 @ 03:05:54 AM
Script : http://******
Referrer : http://******
IP Address : ********
Username : bokhalaf
Classname : vB_Database_MySQLi

thanks in advance

[paul41598]

I'm sorry, I cannot go further unless I gain access to your forums with an administrator password for your admincp

[Konstantinos]

does it work in 3.6.4 ?

[paul41598]

<a href="https://vborg.vbsupport.ru/showthread.php?t=128735" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=128735</a>

[BraindGee]

For the ppl getting the SQL errors, ive amended the xml file. adding VB3_ before the user tables, works a treat on my site now.

*Clicks install.

[zygote]

Will this work on v3.8.X ?

[SVTCobraLTD]

No luck on a 3.8.x version yet?