hameed123456 Posted September 18, 2013 Share Posted September 18, 2013 Hi All, From the Whmcs tables 1.How are the clients related to the products. 2.How are the orders related to the products . Can any one please explain me the relations for the above tables . Thanks in advance 0 Quote Link to comment Share on other sites More sharing options...
SoluteDNS Posted September 18, 2013 Share Posted September 18, 2013 1. In 'tbldomains' and 'tblhosting' you will find the 'userid' where the domain/product is assigned to. 2. In the same tables you will also find the 'orderid' of the order where the domain/product is related to. 0 Quote Link to comment Share on other sites More sharing options...
v1ktor Posted September 19, 2013 Share Posted September 19, 2013 I was researching this too. Apparantely, tblhosting table is used for ALL orders, hosting or not. This is "tblorders" table in disguise really. All order information you need is in this table. packageid = product id This is exactly what one needs to match clients with products with orders using SQL helper functions (thanks to SoluteDNS for telling me about those): http://docs.whmcs.com/SQL_Helper_Functions 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.