sixfive Posted Sunday at 11:42 AM Share Posted Sunday at 11:42 AM I've a need to know the config option price on a product where it is charged based on a quantity. In our case it's number of seats @$9.40/seat/month. The Data Feeds return a $0 value for us, because the pricing table has no values https://docs.whmcs.com/system/data-feeds/#Product_Pricing_and_Currency so I am working through how to get this in our own module. What I have so far, by passing in the productID is this: SELECT tblproductconfigoptions.id AS configoptionid, tblproductconfigoptions.optionname, tblpricing.monthly AS monthly_price FROM tblproductconfigoptions JOIN tblproductconfiglinks ON tblproductconfigoptions.gid = tblproductconfiglinks.gid JOIN tblpricing ON tblproductconfigoptions.id = tblpricing.relid WHERE tblproductconfiglinks.pid = 62 AND tblpricing.currency = 1 AND tblpricing.type = 'configoptions'; This is returning 0 in monthly, because the rows returned are NOT the rows where I can see 9.40. When I look for the 9.40 monthly as follows SELECT currency,id,relid,monthly FROM `tblpricing` where monthly = 9.40; It shows me the rows are actually id's that are very different, and the relid is nothing like what I am expecting. The relid = 17 on the admin UI (or cid) The naming matches on cid = 17 in tblproductconfigoptions (see the URL in the popup) But the pricing shows up in relid = 85 What's going on here? 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.