Server Module

[Gav]

I need to know if it's possible to get the hostingid of a service to use in the 'suspendaccount' function?

 

There are some variables listed like this:

 

$serverip = $params["serverip"];

$serverusername = $params["serverusername"];

 

...etc but is there one for hosting ID? $params["hostingid"] doesn't work.

 

I need it to get a value from tblcustomfieldvalues so that I can suspend and unsuspend accounts automatically.

 

Thanks

[Gav]

just for anyone else that wants to do this, heres the code I have used based on an old cast control module:

 

$id_query = mysql_query("SELECT tblcustomfieldsvalues.value

FROM tblcustomfieldsvalues, tblcustomfields

WHERE

tblcustomfields.fieldname='id'

AND tblcustomfieldsvalues.fieldid = tblcustomfields.id

AND tblcustomfieldsvalues.relid=".$params['accountid']);

 

if ( mysql_num_rows( $id_query ) == 0 )

{

$return ='ERROR: The account has not been suspended';

return $return;

}

$suspend_id = mysql_result($id_query, 0, 'value');