Announcement

Collapse
No announcement yet.

Subscription Question - Previous Usergroup field?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Subscription Question - Previous Usergroup field?

    I am doing a migration of paid subscriptions and stumbled upon 2 fields in the database regarding the subscriptions that i have a question with:

    1. There is a "pusergroupid" (previous usergroup id) field in "subscriptionlog" but how does it work? What if the subscription is only adding a secondary membergroup, how will if effect the primary one at the end of subscription if primamry has changed since then?
      • What if primary group was being changed, would all promotions or chnages in the usergroup be lost and reverted back to the one in "pusergroupid" when subscription expires?

    2. In the "paymentinfo" table, what is the "hash" filed? is that field auto-generated or is that somewhere from the paypal information i can pull out?


    PS - What if some fields (like "hash") that have to do with payments are left blank? Would that just effect statistics, also does it have to be NULL or can just be left blank?


    Thanks!
    Last edited by moddis; Sun 5 Feb '12, 6:50am.

  • #2
    Anyone ever have experience with this?

    Comment


    • #3
      It returns the user to their previous primary usergroup when the subscription expires. If you're only adding secondary groups for your subscriptions, the field really has no relevance. People can be in multiple secondary groups at once and when the subscription expires it simply removes the one they no longer have access to.

      Hashes are generated by vBulletin in various places to make sure things aren't duplicated.

      You really shouldn't be messing with the database directly unless directed to by support staff here. Should just let the software do its job. If you're doing custom programming then you need to ask over at www.vbulletin.org.
      Translations provided by Google.

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

      Comment


      • #4
        Thanks. I have no choice but do this because I made a mistake of using a subscription mod now I'm trying to migrate all those subscriptions and payments to the default vb subscription system.

        If those are auto generated, can I just generate something that size (does it have to be that lenght) when doing a payment import since the mod I was using did not have a hash on payments? I guess I could just leave those empty but I would rAther have a complete database.

        Anyway, i'll go ahead and make a vb.org thread about this.

        Thanks again!
        Last edited by moddis; Tue 7 Feb '12, 5:13am.

        Comment


        • #5
          You can leave them empty. It wouldn't affect the completeness of your import.
          Translations provided by Google.

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

          Comment


          • #6
            Thanks.

            One last thing to confirm... There are only 3 tables related to the paid subscriptions and payments right (paymentinfo, paymenttransaction, subscriptionlog)? or am i missing osmething?

            Comment


            • #7
              As far as I am aware that is correct. MIght be something in the user table as well.
              Translations provided by Google.

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

              Comment


              • #8
                Originally posted by Wayne Luke View Post
                As far as I am aware that is correct. MIght be something in the user table as well.
                Well it does have the usergroupid and membergroupid but i would hope they get updated after the payment is recieved....(or imported)

                Comment

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