How to assign usergroup to users from PHP?

[Genent]

Hi,
I would like to do the following, but it's not exactly clear how (is there a better doc on Data Managers than on vbulletin.com?)

So basically we have a membership based paysite, and we are running a forum on a separate domain for our visitors.

Everyone can register on the forum for free, but we would like to give access to a few extra forums for the paysite members.

We have a completely separate user database for the forum and for the paysite.
On the paysite members will be able to give their forum username and password in their profile, and they should get VIP access to the special forums.

I made a usergroup called "VIP Member" on the forum, and I would like to automatically assign this usergroup to every user that provided his username/password on the paysite. (and remove them from this group when their paysite membership expires)

What I could figure out is that I should use data managers, but there is very little documentation on how to use usergroups for instance.

[Marco van Herwaarden]

Why not use the standard vB Payed Subscriptions for this?

[Genent]

Originally Posted by MarcoH64

Why not use the standard vB Payed Subscriptions for this?

Because we have a system already going on that can't be amended - are billing with other IPSPs, and our billing mechanism is way more complex.
The forum is an extra and represents 5% of the services - it's not the main feature - it should just be an amendment to our current services.

[Genent]

No one is able to tell how to do this?

[Paul M]

If you want the new group to be their primary group then just use a simple sql update query to set the value of usergroupid, for their record in the user table, to your desired value.

[Genent]

Originally Posted by Paul M

If you want the new group to be their primary group then just use a simple sql update query to set the value of usergroupid, for their record in the user table, to your desired value.

Thank you Paul
And If i want to add them additional groups? we have multiple sites - and by subscribing to 2 sites gives them 2 extra group memberships - I guess this can't be done with primary groups

[Paul M]

add them as a comma seperated list to the membergroupids field.

[Genent]

Originally Posted by Paul M

add them as a comma seperated list to the membergroupids field.

Thank you it worked out this way