vBaCMPS Most Recent Subscribers Module

This will place a box on your vBa CMPS homepage showing the 10 most recent Paid Subscriptions.

It works by querying the subscriptionlog table for the expiry date of the subscription.

If you want it to show them by expiry date, or change the number shown, instructions are in the .zip.

*edit* They are now.

[kall]

Originally Posted by MarcoH64

In PHP the correct query should be:

PHP Code:

 $getusers = $DB_site->query(" 
SELECT user.userid,username 
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "subscriptionlog as subscriptionlog ON (subscriptionlog.userid = user.userid) 
WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10 
"); 


PS I always use a table prefix on my testsite, tou avoid this kind of problems.

That looks so much like the fix I posted a few lines up, I can't even tell what's different.

But your point is well made. Table Prefixes always end up biting me in the ass.

[mholtum]

Originally Posted by kall

That looks so much like the fix I posted a few lines up, I can't even tell what's different.

But your point is well made. Table Prefixes always end up biting me in the ass.

FROM " . TABLE_PREFIX . "user AS user