jclarke Posted August 9, 2012 Share Posted August 9, 2012 I'm trying to create a page that lists domain prices based on a given client group/slab. I see that the domain prices are listed in the tblpricing table and the relid points back to the tbldomainpricing table but I'm not able to find a table that links a the records in tblpricing to a given client group. I could just be missing something, has anyone done something similar? Thanks, 0 Quote Link to comment Share on other sites More sharing options...
cenourinha Posted August 9, 2012 Share Posted August 9, 2012 Can't find the querie logic too. 0 Quote Link to comment Share on other sites More sharing options...
jclarke Posted August 9, 2012 Author Share Posted August 9, 2012 Yeah, it is driving me crazy, I can't figure out the logic! 0 Quote Link to comment Share on other sites More sharing options...
cenourinha Posted August 9, 2012 Share Posted August 9, 2012 Maybe is the table "tsetupfee", mine has two results... one with value 0.00 and other with 3.00. The 3.00 has the price for the groupid = 3. oO 1 Quote Link to comment Share on other sites More sharing options...
jclarke Posted August 10, 2012 Author Share Posted August 10, 2012 Maybe is the table "tsetupfee", mine has two results... one with value 0.00 and other with 3.00. The 3.00 has the price for the groupid = 3. oO Yep, that is it, I totally missed that column. It has a 0 for the default slab and the group id otherwise in the tsetupfee column. I guess I never thought it could even be that column Thanks! 1 Quote Link to comment Share on other sites More sharing options...
cenourinha Posted August 10, 2012 Share Posted August 10, 2012 Do you welcome! 0 Quote Link to comment Share on other sites More sharing options...
basic Posted April 23, 2013 Share Posted April 23, 2013 Hi ! I realize this thread is several months old: still, how do I do this (using WHMCS 5.2.3)? How do I display slab Resellers 1 group pricing (as set up for some domain TLDs) in a list? I also am trying to fix an older domainchecker script that doesn't yet have that slab pricing feature in there, and it always wrongly pulls the reduced slab 1 pricing when it should just list the standard/default pricing. Some junk of code would help here. Thanks. John 0 Quote Link to comment Share on other sites More sharing options...
steph.hope Posted February 26, 2020 Share Posted February 26, 2020 Extremely later, but thanks for making this thread, you've saved me from tearing my hair out 🙃 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.