Subscription Expiry Notification on Forumhome

Hack Name: Subscription Expiry Notification on Forumhome
Hack Version: 2.1
Hack Author: Kall
Release: 20 April 2005
Description: Shows date of Subscription Expiry (and days remaining) on Forumhome to members with Active Subscriptions.
Requested by: Mike Warner.
Thanks to: MarcoH64 (big thanks to Marco), Mike Warner and The_Realist for help on day one ironing out the bugs.

Files modified: 1 (root/index.php)
Templates Modified: 1 (FORUMHOME)
New templates: 1 (forumhome_nzb_exprydatebit)


By default, this will show to people with under 30 days remaining on their Subscription and the next 5 subscriptions to expire.

To change the days, change the 30 at the start of the last PHP edit to the number of days you want to show in advance.
To change the number, change the 5 at the end of the sql query.

This is my first hack that includes either a joining of tables or a new template or a template that can be called more than once, so I apologise in advance if a string of runaway queries turns your server into swiss cheese.

New features in v2.1: Optimised query to only be run for non-guests and tidied up a lot. (thanks to Marco). To upgrade, simply replace the final index.php edit with the one inside the new .txt file.


Updates - Fixed query thanks to MarcoH64.
Extended message thanks to The_Realist.
Tidied message up, XHTML-wise and gave it a nice little box.
v2.0 Released. Thanks to MarcoH64 for shaming me into making it a bit more functional with his first post.

[The Realist]

Yep works perfect

Originally Posted by kall

Oh bugger. It's because of the way we are displaying our dates.

Err...

<if condition="$remaining > 0 AND $remaining < 20 AND $bbuserinfo[userid] != '0'">

How's that?

[The Realist]

Works great M8 and does what it says on the bottle

Edited mine a bit to:

<if condition="$remaining > 0 AND $remaining < 90 AND $bbuserinfo[userid] != '0'">
<div align="center"><font color="#FF0000">$bbuserinfo[username]!</font> Your Subscription 
	Here Expires On The <font color="#FF0000">$expirydate</font>. You Have $remaining 
	Days Remaining.<br />Please Click <a href="$vboptions[bburl]/subscriptions.php" title="Renew Subscription">here</a> 
	And Renew Your Subscription And Continue Your Support Of YOUR FORUMS NAME Forums.</div></if>

Clicks install

[kall]

Sweet!

Nice message....I'll stick that in the install.

[The Realist]

Well thank you.

[kall]

Originally Posted by The Realist

Well thank you.

And with a bit of tidying, it's XHTML compliant.

[MikeGK]

can this be done in user's profile as well? thank you

[kall]

Probably.

It could probably be done on every page, by using the query in php_include_start..

Optimised version will be out later today, thanks to the help of MarcoH64.

[MikeWarner]

Good job with the update.

I want to show this just below the bit that says "You last visited: Today at xx:xx". I can handle the template changes no problem, but the hack is designed to only show on the forumhome (index.php). How would I make it so that it showed on all pages? Do I need to change global.php - if so, how?

Many thanks.

[kall]

2.1 Update out today.

(Sorry, I don't know about putting it in global.php ... it might work...)

[LloydSev]

Works like an absolute charm for me. Thanks very much.