So basically, I'm writing an external "plugin" that grabs the paid subscriptions and outputs them in a list.
However I am stuck, where is the Subscription title/name?
I can't seem to locate the subscription title/name?
In what table is it?
Thanks!
EDIT:
After doing some DB searching the sub title is saved in `vb_phrase` as `sub1_title` and sub2 for each subscription respectively.
I can loop through `vb_subscription` to grab subscription id's and replace the 1 in sub1_title with the subscription id, but this is a very nasty way.
Anyways this is the solution.
Enjoy
However I am stuck, where is the Subscription title/name?
I can't seem to locate the subscription title/name?
In what table is it?
Thanks!
EDIT:
After doing some DB searching the sub title is saved in `vb_phrase` as `sub1_title` and sub2 for each subscription respectively.
I can loop through `vb_subscription` to grab subscription id's and replace the 1 in sub1_title with the subscription id, but this is a very nasty way.
Anyways this is the solution.
Enjoy
Comment