How to Server/Addon Module connected to WHMCS Database ?

[RstsTeam]

Hello guys,

I'm working on custom module and i have created Server Module to test things out. Basically  i have created database outside of WHMCS  to visualize and test data and where i was pulling values to create client service.

 

So i got everything working as i wanted with the above example. 

 

With the following test code i have managed to create new table and input values in it. 

 Capsule::table('tblmhipsips')
            ->where('ipid', '=', $params["userid"])
            ->where('vpsid', '=', $vpsname)
            ->update(array(
                'ip' => $vpsip,
                'mac_addr' => $mac_addr,
                'note' => 'assigned',
            ));

Now i want to build the same logic into WHMCS Addon Module where you could Add/Edit/Delete Values and Server Module should pull data from WHMCS Addon Database 

And here is where I'm stuck and i need guideline or small 2 value example on how to do this.

Any help is highly appreciated !!

Thanks

 

Edited May 2 by RstsTeam