create a frontend list of all active CBsubs users?
krileon
- ONLINE
- Posts: 68609
- Thanks: 9108
- Karma: 1434
9 years 14 hours ago #264688
by krileon
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.
Replied by krileon on topic create a frontend list of all active CBsubs users?
Yes, if the key doesn't match the URL access will be denied.
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.
Please Log in or Create an account to join the conversation.
- ThePiston
- OFFLINE
- Posts: 863
- Thanks: 31
- Karma: 1
9 years 13 hours ago #264694
by ThePiston
CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X
Replied by ThePiston on topic create a frontend list of all active CBsubs users?
why would my key be different now than a few years back when I installed CBsubs?
CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X
Please Log in or Create an account to join the conversation.
- ThePiston
- OFFLINE
- Posts: 863
- Thanks: 31
- Karma: 1
8 years 11 months ago #265553
by ThePiston
CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X
Replied by ThePiston on topic create a frontend list of all active CBsubs users?
How would I include this "curr_yr" variable into this query like below?
$curr_yr = date('Y') ;
$query = "SELECT COUNT(`id`)
from j17_cbsubs_subscriptions
WHERE id!=62
and id !=299
and expiry_date < '"$curr_yr"-12-31 23:59:58'
AND status='A'";
$curr_yr = date('Y') ;
$query = "SELECT COUNT(`id`)
from j17_cbsubs_subscriptions
WHERE id!=62
and id !=299
and expiry_date < '"$curr_yr"-12-31 23:59:58'
AND status='A'";
CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X
Please Log in or Create an account to join the conversation.
- krileon
- ONLINE
- Posts: 68609
- Thanks: 9108
- Karma: 1434
8 years 10 months ago #266437
by krileon
dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html
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.
Replied by krileon on topic create a frontend list of all active CBsubs users?
I've no idea. I guess the code for generating it has changed or if it's using Joomla secret key then it'd be different per Joomla install.why would my key be different now than a few years back when I installed CBsubs?
With the SQL function YEAR(). See the below MYSQL documentation for date function usage.How would I include this "curr_yr" variable into this query like below?
dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html
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.
Please Log in or Create an account to join the conversation.
Moderators: beat, nant, krileon
