Subscription Question - Previous Usergroup field?

[moddis]

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!

[moddis]

Anyone ever have experience with this?

[Wayne Luke]

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.

[moddis]

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!

[Wayne Luke]

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

[moddis]

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?

[Wayne Luke]

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

[moddis]

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)