PHP - How do Paid Subscriptions work?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • JamesStPattrick
    New Member
    • Oct 2016
    • 11

    PHP - How do Paid Subscriptions work?

    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
  • JamesStPattrick
    New Member
    • Oct 2016
    • 11

    #2
    The cost is like this saved in DB:
    PHP Code:
    a:1:{i:0;a:6:{s:4:"cost";a:5:{s:3:"usd";s:5:"10.00";s:3:"gbp";s:4:"0.00";s:3:"eur";s:4:"0.00";s:3:"aud";s:4:"0.00";s:3:"cad";s:4:"0.00";}s:6:"length";i:30;s:5:"units";s:1:"D";s:11:"ccbillsubid";s:0:"";s:18:"twocheckout_prodid";s:0:"";s:9:"recurring";i:0;}} 
    How can I get the the first value the most efficient way in PHP? (the 10.00 usd)

    Comment

    • Mark.B
      vBulletin Support
      • Feb 2004
      • 24286
      • 6.0.X

      #3
      Hi

      This is outside of the scope of official support....you'd probably get more help on our peer-to-peer modification and customisation site, www.vbulletin.org.

      They have a vB3 Programming Discussions forum there, which would be a better place to ask as people with the necessary programming skills frequent that site.
      MARK.B
      vBulletin Support
      ------------
      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

      Comment

      • arik999
        New Member
        • Feb 2016
        • 2
        • 4.2.x

        #4
        hey JamesStPattrick, how did u end up handling this?

        Comment

        • arik999
          New Member
          • Feb 2016
          • 2
          • 4.2.x

          #5
          found it, it's a serialized format of php, see http://www.phpinternalsbook.com/clas...alization.html

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73981

            #6
            This discussion belongs over at www.vbulletin.org.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...