Mysql Add user to Paid Subscription
 

I have a store and if someone purchases from my store I want to add them to the paid subscriptions usergroup for x amount of days I found the subscription log and tried inserting the information into there however that did not update their account.

To go in manually takes way to long so I was looking for a way to streamline this. is there a table I am missing or a vbulletin script that can help with this ?

$insert_array = array('subscriptionid' => 1,
'userid' => 128003,
'pusergroupid' => 52,
'status' => 1,
'regdate' => strtotime('now'),
'expirydate' => strtotime('+2 months'));
$sql2->insert($insert_array,'subscriptionlog');

any help is appreciated.

Have you look at the files which actually process a subscription? If you haven't - this is a good place to start.

Better to use the DataManagers so you don't need to think about the underlying structure.

I looked at the files that process the requests when you are adding a user but I could find no insert or updates taking place.

What do you mean by data managers ?

I looked through the subscription code but do not see any data managers in use I dont see any inserts or usergroup updates taking place.

Paid Subscriptions actually doesn't use a Data Manager per se. Have a look at class_paid_subscription.php.