Need help: what whmcs variable to use to populate remote server?

[xauen]

Hi,

 

I would like to connect to a remote mysql server once module "create" is initiated but im having problem what variable (in color red) to use to populate the username, password, email and service in my remote server with the client values in his/her whmcs.

 

Please check the code below. please

 

 
function sample_CreateAccount($params) {
$dbhost = 'fake';
$dbuser = 'fake';
$dbpass = 'fake';
$dbname = 'fake';

$conn = mysql_connect($GLOBALS['db_host'], $GLOBALS['db_username'], $GLOBALS['db_password']);
mysql_select_db($GLOBALS['db_name']);

mysql_query("INSERT INTO users (username, password, email, service) VALUES ('[color="red"]I dont know what variable name to use??[/color]')", $conn);
mysql_close($conn);

if ($successful) {
	$result = "Client Provisioning Successful";
} else {
	$result = "Client Provisioning Failed";
}
return $result;

}

 

Hope my explanation is clear sorry for my not so good english.

 

Thank you in advance to anyone who can help me,

[bradh]

Hi

 

Have you had a look at the action hooks? Should be fairly easy to get your code to work

 

http://docs.whmcs.com/Action_Hooks

 

<?php

function hook_create_forum_account($vars) {

   $firstname = $vars['firstname'];
   $lastname = $vars['lastname'];
   $email = $vars['email'];

   # Run code to create remote forum account here...

}

add_hook("ClientAdd",1,"hook_create_forum_account");

?>

[xauen]

Hi Bradh,

 

Thank you for the reply. However, I need this as a provisioning module.

I think im getting the hang of it already.

 

thank you again!