[SOLVED] Coupons use case question.

CB Privacy it self is public and published. Everything is up to date.

Any other ideas?

News that might be helpful about this situation.

2 different plugins

a) cb_invites tab
privacy works pretty fine here. Each member can see his own invites!

b) cb_coupon field that shows alone in a new created tab named "coupons"
privacy does not work! Each member can see all created coupons from everyone.

Both tabs have exactly the same privacy settings!

So... this problem can not be related to privacy plugin. There must be something wrong with with the cb_coupons field, or the plan, or something.

I remind you that everything has been created according to the following tutorial...

www.joomlapolis.com/documentation/283-cb-paid-subscriptions/tutorials/18407-purchasing-discount-coupons

I don't think your issue has anything to do with CB Privacy. Your cb_coupon field is a query field that's querying for those coupon codes. The query you're using likely is not specific to the user. If you review the tutorial carefully you'll see that 172474 is the example user id. You need to adjust it to make that dynamic. Should just be a matter of replacing 172474 with [user_id]. That tutorial is an extremely rough usecase. We don't officially have a means of generating coupons for users and it's just utilizing direct database queries to do so.

Yes... changing to [user_id] / [username] fixes the issue of creating the record with the right user_id in the #__cbsubs_promotions table.

Now i guess there is also a miss in the query field that is also created according to the tutorial. For some reason (just a guess...) the query field is not getting the user_id of the member that created the coupon, and this is why it still shows all the promotion coupons that exist in the database to everyone.

Here is the query field provided from the tutorial...
SELECT p.`coupon_code`, p.`max_uses_total`, ( SELECT COUNT(*) FROM `#__cbsubs_promotions_uses` AS c WHERE c.`promotion_id` = p.`id` ) AS count, ( SELECT group_concat(d.`user_id` separator ', ') FROM `#__cbsubs_promotions_uses` AS d WHERE d.`promotion_id` = p.`id` ) AS idlist FROM `#__cbsubs_promotions` AS p WHERE p.`coupon_code` REGEXP '^48706-'

Can you please advise?

Thank you.

Ok i got it!

Thank you for your help. I did put the user-id in the created coupon code and changed the last part of the above selection to WHERE p.`coupon_code` REGEXP '^[user_id]-'

Now everything is working fine. Thank you again.