- Posts: 24
- Thank you received: 3
Membership Pro version 2.6.0 released
- Mark Bogart
- Offline
- Junior Member
I understand your logic.
In our case it is a problem for 2 reasons:
1. The Subscriptions tab is more useful to our membership team for a number of reasons and because they are not tech savvy, it is a never ending source of confusion to have multiple subscriptions. As I said before, we only need to know if they are active or not so that we can send them our magazine.
2. We derive our mailing list via an SQL query based on an active subscription. As it stands now, if a member renews 3 months early, he will have 2 active subscriptions for 3 months. I'm sure we can find a way around this but I can't help thinking others may have similar difficulties.
Is there a way to keep the new subscription "pending" (...or other than active published=1) until the old one expires ?
Thanks for your consideration and past support.
Cheers
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Topic Author
- Offline
- Administrator
No, it is not possible. However, you can look at administrator/com_osmembership/model/report.php to see how we can query the database
Here is a simple query which could be used
SELECT * FROM #__osmembership_subscribers WHERE plan_main_record = 1 AND plan_subscription_status = 1
(That would give you unique list of active subscription record). In your example, he will have 2 subscription records, but only first record has plan_main_record set to 1. The plan_subscription_status will be status of his whole subscription (in this case, he has active subscription of the plan, so plan_subscription_status will be set to 1)
Hope it gives you some clues/helps
Tuan
Please Log in or Create an account to join the conversation.
- Mark Bogart
- Offline
- Junior Member
- Posts: 24
- Thank you received: 3
That helps a lot...!
Mark.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Topic Author
- Offline
- Administrator
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Mark Bogart
- Offline
- Junior Member
- Posts: 24
- Thank you received: 3
I have a bug to report that you may want to consider.
We have members that have been in the system since we installed Membership Pro back at the beginning of the year when we installed 2.2.1. Since then in 2.6.4, I believe you have added several fields such as:
plan_main_record
plan_subscription_status
plan_subscription_to_date
For the older members who have not been updated, those fields remain in the default null or zero.
Because of that, they do not show up on the Subscribers Report tab even though published=1
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Topic Author
- Offline
- Administrator
Not sure how you updated the extension but when you updated, the extension supposed to calculate and update data for these subscribers, too
Maybe you should re-trigger that process by accessing to this URL to have the data calculated and updated properly:
yoursite.com/administrator/index.php?opt...atamigration.process
of course yoursite.com needs to be replaced with the actual domain of your site
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Thomas Handler
- Offline
- New Member
- Posts: 4
- Thank you received: 0
is there a way to totally hide an article depending on time ...
1. Added System - Membership Schedule Content plugin
People usually call it Drip-Feed Content feature. Basically, it allows you schedule releasing content (Joomla articles) to your subscribers based on how long he has subscribed for your subscription plan. For example, the first article will be release to subscribers 2 days after he subscribed for your plan, the second article will be released 3 days after he subscribed for your plan and so on....
I want that the article appears when the timeframe is reached and could not be seen by the members before with the "locked" marker so that the member could not see how many articles are coming in the future.
Does this also work that the article is totally invisible and appears after (in example) 3 days after subscription in the normal joomla blog layout?
Or only in the "User Profile" or "User schedule content"
regards Thomas
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Topic Author
- Offline
- Administrator
We could not control Joomla core code, so it is not possible to totally hide an article depending on time. For that, it would requires Joomla core hack / override and quite difficult.
In case you really need it, we would have to charge you as a custom development to implement this override, sorry (It is actually quite hard to change code of Joomla core to have it works like that, just so you know)
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.