vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   vbulletin subscriptions (https://vborg.vbsupport.ru/showthread.php?t=285832)

ohadpartuck 07-22-2012 10:55 AM

vbulletin subscriptions
 
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?

:D

Fergal C 07-24-2012 12:51 PM

Quote:

Originally Posted by ohadpartuck (Post 2350397)
...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?

:D

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 07-24-2012 01:44 PM

Quote:

Originally Posted by ohadpartuck (Post 2350397)
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.


Quote:

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?:D

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.


All times are GMT. The time now is 01:27 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01117 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete