With Member Care System you can:
- You can write your custom email subject and message in the configuration form.
- You can provide a form, the same as the 'Lost Your Password?' form, for the inactive users to get their activation emails, whenever they want without any action from you (see README.txt)
- You can list the members who didn't login to your site for the previous x days, where x ranges from 1 to 30, and you can order the list by absence days, never logged in members, username, name, register date or last visit date.
23 comments:
Great component! But I would love to see a function, to send the "reminder-mail" to all users (e.g. > 30 days) at once. I've got about 3000 Users on my website. Now, I can only send 50 mails at once ;-)
Very nice component. This kind of feature should be part of the Joomla core.
The only problem I found was that when you set the configuration for the first time it returns a sql warning "Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/yoursite/public_html/mysite/includes/database.php on line 406" However it still saves the configuration information correctly and does not display the error once there is data in the table.
My feature requests:
1. Add a menu for the component on each of the admin pages so you do't have to keep going back to the Joomla component list to access other options.
2. Allow the admin to set the maximum number of days in the configuration. Some people may want more than 30.
3. Add a filter in the member list to filter out users that have been sent a reminder in X number of days.
4. Add a delete members option. This would allow an admin to easily clean up their user database if needed. The delete should be compatible with Community Builder as well.
5. Add a filter to show only users who have never logged in.
It seems that the feature of allowing the admin to set the maximum number of days in the configuration is strongly requierd, so I will add it as soon as possible.
Thanks for all
Looking forward to using this but upload failed. Can you direct a newbie to where this error can be corrected?
SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 9 SQL=CREATE TABLE `joomlatest_mcs` ( `id` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `reminders` tinyint(4) NOT NULL default 0, `invites` tinyint(4) NOT NULL default 0, `lastReminderDate` datetime NOT NULL default '0000-00-00 00:00:00', `lastInviteDate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM
SQL =
CREATE TABLE `joomlatest_mcs` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL,
`reminders` tinyint(4) NOT NULL default 0,
`invites` tinyint(4) NOT NULL default 0,
`lastReminderDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastInviteDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
حتى تقدم
seo
متين ..ويؤدي الغرض..الشرط
الأول
الألمام التام بمحركات البحث..
أتمنى لك التوفيق ياملك جوملا
http://www.kingjoomla.com/
التنافس حلو
.....
أخوك
رب جوملا
Regarding "SQL Error DB function failed with error number 1064"
perhaps you you have old MySql version, can you tell me what mysql version you have?
لا أفهم ماذا تقصد يا أخى الكريم؟
ما علاقة ماكتبت بالموضوع؟
أرجوك وضح كلامك أكثر
I am using 3.23.58 version ... without realising it is old.. that will be the problem will it?
Brilliant idea with this component.
But after installing, i get this error:
Fatal error: Call to undefined function: josgetarrayints() in /home/telline/public_html/dansk/administrator/components/com_mcs/admin.mcs.php on line 23
How can i solve this problem.
Regards
Boris
Denmark
I am using 3.23.58 version ... without realising it is old.. that will be the problem will it?
Yes, it is an old version, but if you can't upgrade your version tell me, I will search for a solution.
Boris Dollerup:
regarding your error, this is due to old joomla version, so you need to upgrade to the last version, which is 1.0.12 till now.
or you can write this function to its place as following:
copy this code:
/*
* Function to handle an array of integers
* Added 1.0.11
*/
function josGetArrayInts( $name, $type=NULL ) {
if ( $type == NULL ) {
$type = $_POST;
}
$array = mosGetParam( $type, $name, array(0) );
mosArrayToInts( $array );
if (!is_array( $array )) {
$array = array(0);
}
return $array;
}
to the end of this file: /includes/joomla.php
it should work fine now.
It works perfect now, thank you very mouch. Look forward to use it.
It works perfect now, thank you very mouch.
Regards
Boris
I have over 1200 members, some who have been disabled because they need to pay their annual renewal fee. Will this send email to disabled users? or only active users?
It should send emails, as long as the users were active and then disabled, they will be listed in the Absent Members.
Inactive members, who did not activated their membership after registeration will be listed in the Inactive Members.
I hope its clear now!
Great Component!
Is it possible to delete any listed member in Inactive member. I have for some users enabled manuall their accont, but they shows in inactive member list. (or do I see wrong??)
deleting a member is not included in the current release, its planned to be included in the coming release.
Regarding the question you asked, tell me whether you use community builder or not!
I am told that my host will not upgrade MYSQL from 3.23.58 because it involves so many customers being affected so I would be very grateful if you could provide a solution.
Hi KingZizo !
I get this error in the backend (admin):
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/conexion/public_html/includes/database.php on line 403
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conexion/public_html/includes/database.php on line 406
The component works ok... (send all the e-mails etc)
How I can fix this issue?
Many thanks
Alex
Hi all,
please, keep posting your comments about MCS, and be patient until I can launch the web site which will host my extensions and provide support for all in a better way.
all of your comments and emails are important and considered, even if I haven't the time to reply, sorry for that.
The new web site will have a forum for support and everything related to MCS.
hi!..i'm new to joomla and i have a problem..this error message appears when i click absent members in the component menu "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(CURDATE(),a.registerDate) ELSE DATEDIFF(CURDATE(),a.lastvisitD SQL=SELECT a.*, m.invites, m.lastInviteDate, CASE a.lastvisitDate WHEN a.lastvisitDate IS NULL THEN DATEDIFF(CURDATE(),a.registerDate) ELSE DATEDIFF(CURDATE(),a.lastvisitDate) END AS absentDays , CASE a.lastvisitDate WHEN a.lastvisitDate IS NULL THEN 1 ELSE 0 END As neverLogIn FROM jos_users AS a INNER JOIN jos_mcs AS m ON a.id = m.userid WHERE a.activation = '' AND ((a.lastvisitDate >= a.registerDate AND DATEDIFF(CURDATE(),a.lastvisitDate) < 30 ) OR (a.lastvisitDate < a.registerDate AND DATEDIFF(CURDATE(),a.registerDate) < 30 ))ORDER BY absentDays ASC, a.id ASC LIMIT 50"..i don't have any idea how to solve this problem..
Database Version: 4.0.20a
PHP Version: 4.3.11
Web Server: Apache/2.0.50 (Win32) PHP/4.3.11
Joomla! Version: Joomla! 1.0.12 Stable
Brilliant idea with this component.
But after installing, i get this error:
Fatal error: Call to undefined function: josgetarrayints() in /home/telline/public_html/dansk/administrator/components/com_mcs/admin.mcs.php on line 23
How can i solve this problem.
Regards
Boris
Denmark
joomlasoft.blogspot.com
thanx for sharing
Post a Comment