Changing plan programatically

Hi,
Is there any documentation on changing plans programmatically?
I want to write a script to change all users who sign up and have a certain email address from a regular user to an annual subscriber. So I would need in the DB to add 2 new records, the main plan, the child plan and then update the original plan to U and change the access levels of the user that are associated with the plan.
Is there a programmatic way to do this through an API or is it just a matter of doing the database changes?

Thanks in advance


Phil

Best approach is to use the CBSubs Import functionality. If you need a filtered list of users you can query for that on your database directly then supply a file with a list of user ids to CBSubs Import to limit who the import applies to. I do not recommend altering the database; it is very easy to break CBSubs by doing that.