vbulletin subscriptions

[ohadpartuck]

Hi,
I have a few questions concerning the subscriptions system.
I want to sell other products(courses, private lessons and etc') via my site.

I have set up the products in the 'add new subscription' in the 'subscriptions' tab.
My questions aer
1. What are the tables responsible (so far, I have found paymentapi, paymentinfo and paymenttransaction). and what table contains the connection between the id of the product and the title of the product that I have set up in the 'subscriptions' tab.

2. Some of my costumers want to buy subscriptions on the phone and not online.
How can insert the transaction into the DB with an "INSERT" query?

[Fergal C]

Originally Posted by ohadpartuck

...2. Some of my costumers want to buy subscriptions on the phone and not online.
How can insert the transaction into the DB with an "INSERT" query?

I don't know how to do that exactly, however when I receive subscription payments that are not purchased via the forum system, I simply add the member to the relevant Usergroup via the ACP and make a note of when their subscription expires.

[kh99]

Originally Posted by ohadpartuck

Hi,
I have a few questions concerning the subscriptions system.
I want to sell other products(courses, private lessons and etc') via my site.

I have set up the products in the 'add new subscription' in the 'subscriptions' tab.
My questions aer
1. What are the tables responsible (so far, I have found paymentapi, paymentinfo and paymenttransaction). and what table contains the connection between the id of the product and the title of the product that I have set up in the 'subscriptions' tab.

Two other tables are subscription and subscriptionlog (but I'm not sure if those are the only two). Subscription has the info from the subscription manager, and subscriptionlog contains the info about subscribed users.

2. Some of my costumers want to buy subscriptions on the phone and not online.
How can insert the transaction into the DB with an "INSERT" query?

I think you could add something to the subscriptionlog table, as well as making any changes to the user to reflect their subscription. There's also a class_paid_subscription.php that you could use to do it if you were writing a php script. But if you just want to add someone manually, I think you just need to go to the subscription manager (under Paid Subscriptions in the adminCP) and choose "Add User" from the Controls drop-down.

Edit: reading the above again, maybe what you want is to be able to enter their credit card info for them? I don't know if there's a way to do that except maybe by logging in as that user.