Remitur Posted February 25, 2017 Share Posted February 25, 2017 Hello. looking for fixing a little issue in a script (see https://forum.whmcs.com/showthread.php?119130-WHMCS-v7-explore-domain-TLDs ), i got confused trying to understand the database schema used to manage domain pricing slab... That's to say: - for each TLD you can have different prices (one for each slab) - in tblpricing, for each TLD you have a different record for each slab - so, i.e., if you have two slabs, for a certain TLD you can find in tblpricing two different records: one referred to the default slab, the second referred to your second slab The issue is: the only difference between the two records is (obviously) record id and prices. No detail about what of the two records is the "default slab" and what the second slab... Nor did I was able to find elsewhere any index or reference to it... so, how WHMCS can sort the different records, selecting those of each slab? Link to comment Share on other sites More sharing options...
Remitur Posted February 25, 2017 Author Share Posted February 25, 2017 Answering myself: the field I was looking for is in tblpricing, and it's tsetupfee ... 2 Link to comment Share on other sites More sharing options...
Recommended Posts