Paid subscriptions

[dahamsta]

I'm creating vB users with the a data manager, however I need to set these users up as subscribers too. I tried using the paid subscriptions class, but it throws an SQL error (the last field isn't entered into the query by vB) so I wrote a query myself. My only problem now is that subscriptions aren't expiring.

Is anyone familiar with how paid subscriptions work in vB, and if so could you share it with me?

Thanks,
adam

[Marco van Herwaarden]

What code did you use when trying to use the datamanager, and what is the exact error?

[dahamsta]

Originally Posted by MarcoH64

What code did you use when trying to use the datamanager, and what is the exact error?

Hi Marco,

I have no problem using the data manager - users are being set up fine - however there's no data manager for paid subscriptions (that I'm aware of). I had a problem using vB_PaidSubscription->build_user_subscription(), however there's no point in going into that now because I need to offset some of the subscriptions, because they're backdated. So if I could get an idea of what the fields meant, and how subs are expired, that'd be very handy.

For example, presumably subscriptionlogid is just a tracking id, however is subscriptionid the id of the subscription in the table subscription? Presumably pusergroupid is "previous user group id", however what's status? And why is vB ignoring the regdate if I set it to a few minutes into the future? How are subs actually expired?

On vB_PaidSubscription->build_user_subscription(), what are $subscriptionid and $subid, how are $regdate and $expirydate used (are they unix timestamps?), and is the previous usergroupid for these users set to their exising group?

Thanks,
adam

[dahamsta]

For the record, you need to include global.php, then the Paid Subscriptions class. Example:

chdir('/path/to/vbulletin');
require_once('global.php');
require('includes/class_paid_subscription.php');
$sub = new vB_PaidSubscription($vbulletin);
$sub->build_user_subscription(1, 0, $userid);

Where 1 is the subscriptionid, which you can get by going to the Subscription Manager and mousing over Active or Total; and 0 is the cost identifier, starting from 0 and working down.

HTH,
adam