Announcement

Collapse
No announcement yet.

Subscription Question - Previous Usergroup field?

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

  • moddis
    replied
    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)

    Leave a comment:


  • Wayne Luke
    replied
    As far as I am aware that is correct. MIght be something in the user table as well.

    Leave a comment:


  • moddis
    replied
    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?

    Leave a comment:


  • Wayne Luke
    replied
    You can leave them empty. It wouldn't affect the completeness of your import.

    Leave a comment:


  • moddis
    replied
    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.

    Leave a comment:


  • Wayne Luke
    replied
    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.

    Leave a comment:


  • moddis
    replied
    Anyone ever have experience with this?

    Leave a comment:


  • moddis
    started a topic Subscription Question - Previous Usergroup field?

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X