Whats name of the table that stored all purchased products ?

[vladka]

Hello.

 

I need to get all client that bought product with id = 15.

And i can't find connection between tblproducts and tblclients.

 

Also i can't find WHMCS database scheme, and i think its a big minus for WHMCS as a commercial product.

 

Can anyone tells me how does i can get all client that bought some product ?

 

Thank you

[Alistair]

Hello.

 

I need to get all client that bought product with id = 15.

And i can't find connection between tblproducts and tblclients.

 

Also i can't find WHMCS database scheme, and i think its a big minus for WHMCS as a commercial product.

 

Can anyone tells me how does i can get all client that bought some product ?

 

Thank you

 

Hi

 

You can search the database from your WHMCS Admin panel by going to:

 

Clients > Products/Services > -Other Services > Click on the "Search/Filter" Tab

 

A search box will open and you can then set your criteria. For example, you can search for all clients who have an active order for a particular product by specifying the "Product/Service" from the list and then set the "Status" search option to "Active".

 

This will generate a list of active clients who have ordered and paid for that product.

[jclarke]

The tblhosting table contains all of the purchased products/services. The foreign key to tblclients is userid and the foreign key for tblproducts is packageid.

 

To see a list of client ids who bought the product with the ID 15 and is currently active, the query would be:

 

SELECT DISTINCT(userid) from tblhosting where packageid = 15 and domainstatus = 'Active';