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.

[steven s]

This worked very well, thanks.

But shouldn't 'subscribers_bit' be 'adv_portal_subsribers_bit' to conform with the other templates?

[alkatraz]

/me clicks install

thx!

[steven s]

Is it possible to sort by username?

[steven s]

Again, is it possible to sort by username and is it possible to make this block run in 2 columns?

[4number8]

if there is anything I could do to help you out in any way id be more than willing to my friend, thanks you once again for beiing such a great person you are, please If I run into troule would you be willing to help me out? I can ususally figure it out on my won but nothing like good company to keep you entertained, many thanks once again m8 and hope you and your familay are doing great, talk with you later on, take care and hope to hear from you soon

[kall]

Originally Posted by 1996 328ti

Again, is it possible to sort by username and is it possible to make this block run in 2 columns?

Probably.

Change

PHP Code:

WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10
    "); 


to

PHP Code:

WHERE subscriptionlog.status = '1' ORDER BY username DESC LIMIT 10
    "); 


That's just me looking at it and doing the completely obvious thing of swapping regdate for username...I haven't tested it, but as I say, it's obvious, so it should work.

Just in case it crops up, swap DESC to ASC if you want the order reversed and LIMIT 10 to LIMIT * (where * is the number you want to display).

As for the columns, I wouldn't know. HTML is the devil.

[steven s]

Thanks but that doesn't work either.
The choices in subscription.status are

subscriptionlogid
subscriptionid
pusergroupid
regdate
expirydate

[kall]

Originally Posted by 1996 328ti

Thanks but that doesn't work either.
The choices in subscription.status are

subscriptionlogid
subscriptionid
pusergroupid
regdate
expirydate

You are wrong. Doing as I said does work. Either you did not do as I said, or you are looking at a cached version, or something else strange is happening because that does work.

The choices you mention have nothing to do with what was asked, which was 'can we sort them by username?' As username was already being called from the db, it would seem really obvious that simply substituting regdate for username would work. And it does.

*shakes head* All you had to do was replace one word with another, and you couldn't manage it?

Examples below.

[steven s]

Originally Posted by kall

*shakes head* All you had to do was replace one word with another, and you couldn't manage it?

No need for sarcasim. :ermm:

Did you edit your original post?
In the email that vB sent me you clearly said to change regdate to userid.

In the text below the change you mention username.
I tried username and naturally it works. Thank you.

[kall]

Originally Posted by 1996 328ti

No need for sarcasim. :ermm:

Did you edit your original post?
In the email that vB sent me you clearly said to change regdate to userid.

In the text below the change you mention username.
I tried username and naturally it works. Thank you.

Yes, I did edit that post..within seconds of posting it, but yours was posted over 2 hours after mine.

From that, I would have assumed that you would have *read* the post prior to trying the changes.

Also, given the total lack of a tick in the 'Supported' box above, you should be a little more appreciative of the support.

As it was such a simple change, may I suggest you take the time to learn a little about how mySQL queries work? If you had done this prior, it would have saved you a lot of time, and me having to post to point out that the table is already included, and all you have to do is change the name of the one it is sorted by.