domain slab pricing

[jclarke]

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,

[cenourinha]

Can't find the querie logic too.

[jclarke]

Yeah, it is driving me crazy, I can't figure out the logic!

[cenourinha]

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

[jclarke]

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!

[cenourinha]

Do you welcome!

[basic]

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