Which tables are affected by UC roles? In other words, if someone purchases membership at my website, which tables get updated?

1) user_roles -- a new uid and rid pair gets inserted
2) uc_roles_expirations -- a new expiration date gets inserted

What else?

The reason why I ask is that I had a 100+ users that had their roles expire prematurely (I don't know why -- the expiration date is set to 1/1/2011), and I need to reinstate those roles.

Thanks!

Comments

univate’s picture

univate commented
Status: Active » Fixed

uc_role_products is also written to via uc_roles - although this is just used to store what roles to assign on which products.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.