vBaCMPS Recent Subscribers PLUS Donate Button Module

[kall]

This is a port of this one (http://www.vbulletin.org/forum/showthread.php?t=69141) for 3.0.x.
What's that Kall? You are actually porting one of your hacks?
Yes, yes I am.

Anyway...

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.

[Stember]

Doesan't work for me when there are no Recent Subscribers

[hutsonhawk1]

Nice, I think Ill give this one a try! Thank you very much! :D

[Tungsten]

Is there any reason why the form submit code in the subscribers.php file points directly to PayPal rather than directing the user to the vBulletin "payments.php" screen?

[Slayne]

Invalid SQL:

SELECT user.userid,username
FROM vb_user
LEFT JOIN vb_subscriptionlog as subscriptionlog ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10;


Error I get. I'm guessing because I currently have no subscribers? Was hoping I could set this up as donation feature. Am I using it incorrectly?

[1996 328ti]

Is anyone having a problem with this block?
I recently had a member subscribe using paypal.
His username was in the subscriber block and subscription manager but he was not changed to the proper primary and additional usergroup. I ran the scheduled task script. Waited for it to run automatically. I ended up changing the user to the appropriate usergroups myself.

[Morrow]

Just installed and received the following:

Fatal error: Call to a member function on a non-object in /www/d/dcabarle/htdocs/vBulletin/modules/subscribers.php on line 15

Line 15: $getusers = $db->query("

[goblues]

Error I get. I'm guessing because I currently have no subscribers? Was hoping I could set this up as donation feature. Am I using it incorrectly?
Same problem and I Do have subscribers. Wondering if we could get a guru to help us?

[divided_by_fear]

i guess no one has had luck with this?

[goblues]

i guess no one has had luck with this?

not I. :(

[goblues]

Copy this into your subscribers.php file instead of what is in there currently and see if that works.

<?php

$phrasegroups = array();
$specialtemplates = array();
// pre-cache templates used by all actions
$globaltemplates = array(
'adv_portal_subscribers',
'subscribers_bit'
);

// pre-cache templates used by specific actions
$actiontemplates = array();

// query active subscriptions
$getusers = $db->query_read("
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
");

// do the template goodness
while ($subscribers = $db->fetch_array($getusers))
{
eval('$subscribers_bit .= "' . fetch_template('subscribers_bit') . '";');
}

eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_portal_subscribers') . '";');
?>

Got mine to work this way!

[ncangler]

The module works on my vb 3.5/CMPS 2.0 site as downloaded. However, I have a handful of subscribers that did not want to use PayPal and they sent me a check. I manually added them to the additional usergroup and changed their title. But since they did not go through the 'subscriber' system they do not show up in the 'subscriber.php' module. Can anyone tell me where the 'subscriber.log' is located and can I manually edit it to add those users that are manually added to the subscriber system? thanks for any input.

Followup...All I had to do was go to the "Paid Subscriptions" section of the vB Admin and add a new subscriber there manually. :)

Randy

[1996 328ti]

Slight problem in this block.
I have three paid subscriptions.
If a person has two paid subscriptions they are listed twice.
I really need them to be listed only once.

[ncangler]

This module has been working great on two of my sites where I installed vBulletin 3.5.4 with no prefix "vb_". I just created a new site and for some reason I installed with the prefix "vb_". This module doesn't work now. I get this error:
Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT user.userid,username
FROM vb_user
LEFT JOIN vb_subscriptionlog as subscriptionlog ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10;
MySQL Error : Unknown table 'user' in field list
Error Number : 1109

I'm assuming there is a bit of the code that does not have the " . TABLE_PREFIX . " code added to since the module is looking for the table "user" instead of "vb_user". But I can't locate what I need to change. Any suggestions? Thanks for any help!

[ncangler]

I've noticed that new subscriptions show up in the Latest Subcribers module with no problem but current subscribers that renew their subscription do not show up. Any idea on how I could modify the script to pick up new and Renewed subscriptions? Thanks!

[geo1]

why does paypal payment page show it as admin@yousite.com?anyway to change that?

[buggyglint]

Can somebody tell me how to split the paypal donate and the latest subscribers into two separate modules?

I already got the paypal donate part separated but can't figure out how to separate the subscribers.

Seen Here - http://www.keybase.org

Thanks :)