WHMCS API / database and SolusVM

[gerwim]

Hi there,

 

Currently we have our own billing system and want to switch to WHMCS for various reasons, however one thing which still bothers me is that we have an in-house developed rDNS changer and backup manager. This is done through our current control panel and grab the virtual server id from the database (this ID is inserted into the database upon creating the virtual private server by SolusVM).

 

How can we retrieve the virtual server ID's from a specific client (by client's email address if possible). This information will probably be stored into WHMCS' database, but as I don't know hence my question.

 

Thanks in advance!

[gerwim]

I know the answer. Used the tables "tblhosting" and "tblcustomfieldsvalues".

 

Query:

SELECT * FROM tblhosting as h LEFT JOIN tblcustomfieldsvalues AS cfv ON h.id = cfv.relid WHERE userid='" . (int)$_SESSION['uid'] . "' AND cfv.fieldid = '1' AND h.domainstatus='Active'