Easiest way to add user's details to a MySQL Database upon purchase...

[ChrisWood]

I am currently using Action Hooks to try and grab the User's details and add them to an external MySQL database once they have purchased a specific product.

 

Currently used Hooks:

<?php
//I then go on to define vars and add them to my db...

function cwmysql_createaccount($vars) {
$accountid =$vars['params']["accountid"];
$username = $vars['params']["username"];
$password =$vars['params']["password"];
$pid = $vars['params']["pid"];
$domain = $vars['params']["domain"];

//MORE CODE to add to db + $pid checks
}
//My Hooks
add_hook("AfterModuleCreate",1,"cwmysql_createaccount");
add_hook("AfterModuleChangePassword",2,"cwmysql_changepass"); //For password Change
add_hook("AfterModuleChangePackage",3,"cwmysql_changepackage"); //Upon upgrade of package
?>

This will only apply to specific products.

Am I doing this in the best way? Is there a better way to do this? If you have examples, that would be best. It's the best way I learn.

 

I appreciate any info/examples/advice I can get,

Chris Wood

Edited October 24, 2011 by ChrisWood

[ChrisWood]

Edit: I've figured it out, it's way to hard to figure out how to do this stuff. Hopefully I'll get around to making a tutorial...