[Crispin Proctor]

I've been using your mod for a while now and it's been working well (www.landcruiserclub.net)

One issue I had was that I charge members to have their banners there. This was turning into a pain in the backside for me to manage who paid for what period etc. so, I made a small mod.

I optionally attached a banner to a user. I then changed your select where you grab the active banners to do a left outer to the subscription and subscriptionlog tables to ensure that the user has a valid and active subscription. If there was none then the record was excluded.

Now my banners are active only while the user has a valid subscription and as soon as that expires, the join removes the banners from the results.
Because it is a left outer, the need for a user is optional and if there is no link then your mod works as usual.


I don't want to take your code with my change and call it mine so can email you the change details if you would / could include it in your next release. It took me all of 15 minutes to do so not a big deal at all.


Thanks again for the mod.


Cheers,
Crispin