Where's the docs?

[gascione]

I am trying to develop some site specific reports and find myself hacking throught the DB tables and fields trying to gain an understanding of how the fields interact and where data is stored. I asked whmcs if there was documentation available that describes the tables and fields in the DB. They said no.

 

So how is everyone else getting their information, or is everyone just hacking their way through the tables like I am right now?

 

GA

[Matt]

I wouldn't call it hacking, but looking at the tables yes! Once you've added a few sample orders you should be able to see fairly easily how it all relates to each other.

 

Matt

[gascione]

Thats what I have been doing. It's a tedious process. It would seem that since you have a method to create custom reports the documentation should be provided. One problem I noticed is that there is insconsistent use of field names. The "id" field in one table is not the same as the id in another table. I have run across similar issues as I go.

 

Thank you for your response.

 

GA

[JasonO]

Well that depends on what the ID is for?

 

Invoice, client, order, ticket etc

[Nick]

`id` on the `tblclients` table is referred to as `userid` everywhere else. Seems quite logical to me. Other tables which contain things needing identifying (all of them, basically) will refer to their items with `id` as well.