Hello - We use Comminity Builder and CBSubs to manage the membership in the United States Billiard Association (
www.usba.net
)
For paid members in good standing we provide a membership list with search capability. Tournament Directors can look up a member to see if they are in good standing. We would like to display the "Expiration Date" of the member in the list. Presently the only field that is available in List Management is "Last Renewal" which is a bit misleading since we have members in different plans (1-year, 3-year, Life). The actual expiration date would be better information for a tournament director.
Can someone advise if it is possible to add the field "Expiration Date" from CBSubs into the feature List Management in CB. I know that there is some connection between CBSubs expiration date and CB member profile, because in My Profile on the Subscription tab I can see that date. I just cannot get to it in the List Management feature to permit display in a member list.
Thank you in advance for any assistance you can render.
You'd need to use a CB Query Field to query the database and grab the expiration date of their subscription. Example as follows.
Code:
SELECT `expiry_date` FROM `#__cbsubs_subscriptions` WHERE `user_id` = '[user_id]' AND `status` = 'A' AND `plan_id` = PLAN_ID_HERE
Replace PLAN_ID_HERE with the id of the plan you want to check for an expiration date of.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
"CB MySQL Field plugin" is not the same as "CB Query Field". Please ensure you've installed "CB Query Field". We did not develop "CB MySQL Field plugin".
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Thank you... just to be clear... we are using the correct plug in (now!)... CB Query Field... Still looking to change the display format to date only (no time). Sorry for my earlier error.
krileon
