WHMCS & Wordpress MU (Multisite)

[Yameen]

I just purchased my license and I am thrilled with the decision but I am worried it cannot complete the task I need it to:

 

Once a customer completes the order via WHMCS then it should create a new database line in a database I specify.

 

I do not need it to do anything else but create a new line in a database I specify.

 

Can this be done??

[Yameen]

Anybody have any ideas on how-to accomplish this?

[laszlof]

function add_db_row($params) {
 $db = mysql_connect("dbhost", "dbuser", "dbpass") or die("Error connecting to database.");
 mysql_select_db($dbname, $db) or die("Could not select database.");
 $sql = "INSERT INTO `tablename` (`col1`, `col2`, `col3`) VALUES ('val1', 'val2', 'val3')";
 mysql_query($sql);
}

add_hook("AfterModuleCreate", 1, "add_db_row");

 

http://docs.whmcs.com/Action_Hooks