Membership Module Release Candidate - Modules - XOOPS News

XOOPS

News

News World of XOOPS Developers Hacks Themes Archive Submit News

Modules: Membership Module Release Candidate

Posted by: dheltzelOn 2005/5/26 6:46:29 9128 reads

I am about to release 1.0 of my Membership Module. If anyone would like a preview and help be locate any remaining bugs, please download version 0.9.3 and try it out.

This module is an add-on to XOOPS, and is intended to help manage a club's membership. It is also useful for managing Xoops group memberships, as it makes it much easier to move users between groups.

Currently, it can perform the following:

1) Adds a new table with additional fields that the Xoops user table does not have. See the sql/mysql.sql file for details.

2) List members in a table with group level perms to determine which fields from the user table can be viewed.
- This page is very customizable from the preferences in the admin pages

3) Allow a user to easily edit their info on a single page.

4) Admins can edit any user's info.

5) Administer membership in groups with a more powerful interface than the default Xoops admin.

6) Auditing of changes made from this module to the member's information.

7) Allow export of member data to a CSV format for importing into other programs.

Note: This module only works with Xoops 2.0.x. It will not work with the 2.1 or 2.2 versions. Some of the features are incorporated into the Xoops core starting with 2.1, so this will require major changes.

The comments are owned by the author. We aren't responsible for their content.

Re: Membership Module Release Candidate

Published 05/26/2005 9:55 Joined Comments

Nice work .. dheltzel

Resized Image

But i have some notes:
1. some admin pges open in main home page of xoops.
2. (_MI_MEM_ICQ_EMPTY) in add memeber page, look like not found in lang file.
3. How i can edit any member info ?
4. some features not work : export, check db and search.

Re: Membership Module Release Candidate

tedsmith Published 05/26/2005 10:22 Home away from home Joined 06/02/2004 Comments 1151

This is exactly the kind of module I've been looking for! I asked in a forum posting recently whether such a module exists with little response unfortunately. When I get chance I will download this and take a look.

Good job dude

Ted

Re: Membership Module Release Candidate

teibaz Published 05/26/2005 10:28 Not too shy to talk Joined 06/13/2004 Comments 103

sounds great! i was looking for something like that and i was started to write very similar module, but hadn't time to finish..

BUT, you have to make that this Membership Module work with 2.2 - which will be (in my opinion) a new step in xoopsters world

Re: Membership Module Release Candidate

LazyBadger Published 05/26/2005 16:43 Home away from home Joined 06/07/2004 Comments 1187

Template memb_user.html declared, but missing in this version... Must be recovered from 0.9

Re: Membership Module Release Candidate

dheltzel Published 05/26/2005 19:19 Not too shy to talk Joined 01/08/2003 Comments 164

Good catch LazyBadger!
Actually, it's not used, but I forgot to remove it's reference in xoops_version.php. I just removed that reference and the 1.0 will have it right.

Thanks! This is exactly the sort of little annoyances I'm trying to squash.

Dennis

Re: Membership Module Release Candidate

dheltzel Published 05/26/2005 19:23 Not too shy to talk Joined 01/08/2003 Comments 164

You are absolutely right, and I intend to make it work with 2.2, but I needed a solution for production systems right now and Mith will be the first to tell you that 2.1 is too risky to deploy right now. I plan to make whatever bug fixes are needed to the 1.0 line, but start work on a 2.2 compatible version as soon as I can, with the hope that it will be finished shortly after the official release of 2.2.

What I really need are testers and "suggesters" for both versions. Anyone who want to write documentation is welcome too, but those people are usually a bit scarce

Dennis

Re: Membership Module Release Candidate

dheltzel Published 05/26/2005 19:31 Not too shy to talk Joined 01/08/2003 Comments 164

Good suggestions, Mowaffak.

1. some admin pges open in main home page of xoops.
- I've been meaning to fix that. They are sort of an artifact of learning how to do admin pages.

2. (_MI_MEM_ICQ_EMPTY) in add memeber page, look like not found in lang file.
- I'll look into that. I think the fact that yours is a fresh install is why some things are not working quite right. Apparently, I need to test outside my dev environment to see some of the errors you are getting.

3. How i can edit any member info ?
- If you give a group (like webmasters) all rights in "Edit Permission Settings", including the box called "Edit any user - CAUTION!" , then you should be able to edit all the fields for any user. Don't give this perm to "Registered Users" or "Anonymous" for obvious reasons.

4. some features not work : export, check db and search.
- Can you be more specific about how they aren't working? Are you getting errors accessing the page, or doesn't it do what you expect? If you have a chance to turn on PHP debugging and send me any errors, that would be a huge help. The line numbers in the PHP errors have really cut down my debug time.

Thanks for your time looking for these and pointing them out.

Dennis

Re: Membership Module Release Candidate

LazyBadger Published 05/26/2005 19:32 Home away from home Joined 06/07/2004 Comments 1187

Just two more catched problems:
1a I see unchanged mysql dump, but - admin side shows two new fields without title, which are missing on "edit-user as admin" side
1b These two fields also haven't string constants in lang-files
2. (minor) "Check DB" will move you to site frontend

Re: Membership Module Release Candidate

dheltzel Published 05/26/2005 20:12 Not too shy to talk Joined 01/08/2003 Comments 164

Quote:

1a I see unchanged mysql dump, but - admin side shows two new fields without title, which are missing on "edit-user as admin" side
1b These two fields also haven't string constants in lang-files

Are these the UID and password fields? I added them last. You might try going into the preferences page and click "go" to save the field names.

Quote:

2. (minor) "Check DB" will move you to site frontend

I just fixed that in CVS. Also the Export and Audit pages now stay in the admin page. I still have "Manage Group Membership" going back to the main page. I'm not sure what I want to do with this, I think it might belong in the themed front end, but maybe not.

Re: Membership Module Release Candidate

LazyBadger Published 05/26/2005 20:22 Home away from home Joined 06/07/2004 Comments 1187

Quote:

Are these the UID and password fields? I added them last. You might try going into the preferences page and click "go" to save the field names.

Yes, I forgot update my lang-file also... Mea culpa

Re: Membership Module Release Candidate

dheltzel Published 05/26/2005 20:32 Not too shy to talk Joined 01/08/2003 Comments 164

I put out a new release: Membership 0.9.4.

This fixes a number of minor bug fixes and changes suggested by Mowaffak and LazyBadger.

Any more testing help or suggestions for improvement are welcome.

Dennis

Re: Membership Module Release Candidate

davidthomas1 Published 05/27/2005 0:34 Quite a regular Joined 11/05/2004 Comments 384

Does Membership 1.0 let you add custom fields to the user profile / registration page?

I know you can modify the existing registration form labels but I need to add new fields to it.

looking good though, well done.

Re: Membership Module Release Candidate

dheltzel Published 05/27/2005 5:18 Not too shy to talk Joined 01/08/2003 Comments 164

Quote:

Does Membership 1.0 let you add custom fields to the user profile / registration page?

That is really more for XOOPS 2.2, which should be out in about a month.

What fields do you want added? If they are of general use, I might go ahead and add them for you. You can easily re-purpose existing fields including the 15 new fields I already added.

Dennis

Re: Membership Module Release Candidate

Published 05/28/2005 11:14 Joined Comments

Hi dheltzel,

1. When i click on Check DB Integrity, i'm just get this :
Checking for orphaned UID's:

Checking for orphaned GroupID's:

Checking for duplicate links:

with no results !

2. About Export, it's not working if u select "Send results via email"

3. I give webmaster all rights in "Edit Permission Settings", including the box called "Edit any user - CAUTION!" , but when i click on "Manage Group Membership" i'm just see Add member or Remove member, i think u must add Modify member

4. Serach Problem; PHP debug turn on and i got this messege:
SQL Error: SELECT DISTINCT u.uid,u.uname,u.name,u.email,u.url,u.user_icq,u.user_aim,u.user_yim,u.user_msnm,u.user_from,u.user_occ,u.user_intrest,m.member_id,m.title,m.firstname,m.lastname,m.addr1,m.addr2,m.city,m.state,m.zip,m.country,m.home_phone,m.work_phone,m.join_date,m.renew_date,m.member_status FROM extranet_users u LEFT JOIN extranet_membership_info m ON u.uid = m.uid WHERE LIKE '%root%' ORDER by uname

Good Luck

Re: Membership Module Release Candidate

carnuke Published 05/28/2005 13:26 Home away from home Joined 11/05/2003 Comments 1955

Installing Membership

Invalid default value for 'time_changed'

Unable to install membership. Error(s):
Back to Module Administration page

any ideas?

Re: Membership Module Release Candidate

tedsmith Published 05/31/2005 18:02 Updated 05/31/2005 18:30 Home away from home Joined 06/02/2004 Comments 1151

I've created a new user group in System Admin, then gone to the modules module admin and the group is listed under 'Manage Group Membership'. And I can add or remove members from it..no problem.

However, when I access the module itself from the main home page as a webmaster (without first logging out), under the 'Select Group to Search' drop down menu the new group is not listed? It just has (all groups), Webmasters and Registered Users. I've checked the permissions (View Permission Settings -Listing, View Permission Settings - Detail, and Edit Permission Settings) for all three groups and made them all the same? But when I log out as webmaster and then back in as a standard Registered User I get 'Registered Users' and my new group in the drop down menu? Then, if I log back in as Webmaster, all are now showing. In other words, it seems that the user has to log out before changes to the modules groups can be seen?

Also, I notice there are no blocks? I was expecting blocks that would, for example, display the latest member along with certain details about him or her or the organisation. From what I can gather so far it seems to be a module that just allows users to search for members but not a lot else?

My last point...am I correct in assuming that the user accounts that are added to the Membership module are totally seperate from the XOOPS user system? i.e. A user is created, he is added to the Membership module. After that, any changes in made in the Membership module are not mirrored [it seems] in the XOOPS user system? This strikes me as having the potential for confusion by the users. They may update their details in Membership, but then go into 'View Account' from their user menu and see that the details they entered earlier are not showing? Obviously we as webmasters know why that is, but the users won't.

I am not been critical - I'm just trying to understand what the module does exactly. From the few minutes I've spent looking at it and the points above in the News announcement, is seems no different really from the Xoopsmembers module except it has more infomation fields and is more customisable? But it's basically a search facility for members...yes?

I'm Back

dheltzel Published 05/31/2005 18:31 Not too shy to talk Joined 01/08/2003 Comments 164

OK, I'm back from the holiday weekend and working on the module some more.

Mowaffak, here's the best answers I have at the moment:
1) That's actually all is does. If it finds orphaned or dup records, the out put is more verbose as it fixes them. This was a quick "utiility" page I wrote to clean up problems in my test DB. It probably doesn't even belong in this module.
2) If you don't check the box, does it start a download? I have it working in my test system with email, but there are a lot of possible failure pints when sending email.
3) That's a mis-understanding that I need to document better. That function is simply to add or remove users from a group, to modify the user info, you need to look them up in the search function and then click on their login name. I hope that's a clear enough explanation of why there is no modify button there.
4) I'm lost on this one. If you paste that SQL into a mysql session, does it work? If not, what error does the DB give you?

carnuke, what version of mysql are you using? I use 3.23 for development, perhaps you have a different version and they changed the syntax for the default value of a timestamp field.

tedsmith, you hit a subtle security feature! Really! I think that the problem is that you did not put yourself into the group you are trying to select for the search. I did not want to allow a user to search a group that he is not a member of. I guess I could assume that anyone in the webmaster group could see any group, but the code doesn't have that assumption it it (yet).

You are right in your general assessment. I wrote this to help maintain a special group on an XOOPS site that would define paid members of an organization and allow them special privs. Managing groups with large numbers of memebers via the normal XOOPS admin facility is cumbersome, so I wrote the admin page of this module to help with that. Then I added the search and the extra fields to meet a specific need for my organization.

Block may come later as needs arise (either in my organization or from other XOOPS users).

My main priority now is to get a 1.0 release out the door and start figuring out what it will take to make this work with XOOPS 2.2.

I apologize for the delays the past few days, I will be putting out at least one more "release candidate" involving some significant changes in the next day or 2. I'll post here when it's out and ask for more feedback.

Thanks for everyone's interest and help!
Dennis

Re: I'm Back

tedsmith Published 05/31/2005 18:38 Updated 05/31/2005 19:34 Home away from home Joined 06/02/2004 Comments 1151

I think I was editing my earlier post at the same time as you were writing your reply...not sure if what I have written above makes a bit more sense now with regard to the logging in and logging out.

Can you confirm the issues of non-duplication in the user account area? i.e. that by updating details in Membership they will not be seen in the standard 'View Account' section. If this is the case, are there any plans to change this?

Laslty, I notice that if you create a custom block and select it as showing only in the membership module, it only shows up with the results of the search, not from the point the user clicks 'Membership' in the menu panel. In my case, I created a block saying "This area allows you to search through the members database. Select this and that....blah blah blah". But it doesn't show up at the first screen....you press 'Select' to do the search then it appears with the results.

Lastly, when the results are displayed, can the order in which the individual fields are shown be adjusted? For example, making the ICQ, MSN etc appear more to the right in favour of things like First Name, last name, etc?

Re: I'm Back

dheltzel Published 06/01/2005 1:20 Updated 06/01/2005 1:22 Not too shy to talk Joined 01/08/2003 Comments 164

I made a new release, 0.9.5. The biggest change is that the Manage Groups and Export pages are moved from the admin page to a submenu on the main page. These only show up for users with the "admin any user" permission.

Here is the changelog:
v0.9.5
- Moved Group Mgmt page to a submenu of the user page
- Moved Export page to a submenu of the user page
- Protected Group Mgmt and Export pages with the "edit any user" permission
- Removed unneeded fields for the export
- Added birth_date and notes columns to the member_info table

Re: I'm Back

dheltzel Published 06/01/2005 1:30 Not too shy to talk Joined 01/08/2003 Comments 164

tedsmith, I'm not sure why the log in/out makes it display differently. Could it be a browser cache issue?

The confusion over which fields get updated is because some fields are part of XOOPS (Realname, email, URL) and they will show up in all places. Other fields (Firstname, Lastname, member ID) are only in the membership module and adding them into the standard XOOPS pages requires modding the core pages, something I'm not prepared to do. The intent is to only use some of the fields, and perhaps to replace the XOOPS user view/edit pages with the ones from this module.

I don't know why the custom blocks appear erratic, I haven't tried that.

It is certainly possible to re-order the fields by editing the source code, but there is no provision to do that in the admin pages, just turning them on and off. It's really not that hard to adjust them yourself (but I do remember hating when developers said that ).

Dennis

Re: Membership Module Release Candidate

LazyBadger Published 06/01/2005 2:35 Home away from home Joined 06/07/2004 Comments 1187

Dennis, I created two (draft) variations of admin-icons for you module. You have choice...
Resized Image

Re: Membership Module Release Candidate

dheltzel Published 06/01/2005 5:21 Not too shy to talk Joined 01/08/2003 Comments 164

Thanks LazyBadger!

Where are they?
Which one do you like better?

Dennis

Re: Membership Module Release Candidate

LazyBadger Published 06/01/2005 6:44 Home away from home Joined 06/07/2004 Comments 1187

hhttp://xoops-modules.jungles.net.ru/uploads/icons/logo1.png
First
http://xoops-modules.jungles.net.ru/uploads/icons/logo2.png
Second

Must be (probably) reduced in filesize...

I used first icon, but second seems more logical for "Members Club"

Re: Membership Module Release Candidate

davidthomas1 Published 06/01/2005 12:00 Updated 06/01/2005 12:02 Quite a regular Joined 11/05/2004 Comments 384

sorry, just replying a little late to a response to my earlier question about adding custom fields.

I need to add about 20 new fields, most of them checkboxes, also radio buttons and a couple of drop down boxes. It's for an organisation of some 4000 English teachers in Japan. I need to add Special Interest Groups, Nationality Groups, Language Groups etc... for subscription / sign-up.

It's quite a complicated profile but one I hope the new XOOPS 2.2 version will allow via Extended Profiles.

In the meantime, I've been developing a separate section to enable users to create, edit and administrate profiles via custom PHP / MySQL. Ideally, I'd like to have it integrated directly into XOOPS.

The Membership module is great for it's purpose and I hope that it's not to difficult to adapt in for XOOPS 2.2

That way, one can have the customisable fields and the powerful search and member admin features of the Membership module.

Re: Membership Module Release Candidate

dheltzel Published 06/02/2005 16:17 Not too shy to talk Joined 01/08/2003 Comments 164

I just added the 2 logos to CVS and they will be in the next release (I hope that was your intent, otherwise let me know and I'll remove them). I added you to the Changelog file for this release.

I made the 1st one the default as it looks more like the "standard" modules and I don't want to add any confusion.

Thanks for your contribution!
Dennis

Re: Membership Module Release Candidate

dheltzel Published 06/02/2005 16:18 Not too shy to talk Joined 01/08/2003 Comments 164

I haven't looked at the 2.1/2.2 stuff at all, but I suspect you will still need some custom module coding to get what you want done. The best approach is to "wait and see" if you have that luxury.

Dennis

New release - Membership 0.9.6

dheltzel Published 06/03/2005 16:16 Updated 06/03/2005 16:21 Not too shy to talk Joined 01/08/2003 Comments 164

Membership 0.9.6

I hate to do this to everyone, but the date fields needed re-working and I decided to do it now, before releasing 1.0.

This version contains a major change to the database table. You should uninstall and then re-install to mske it work properly. If you really need to save your existing data, you will need to backup the date fields and then restore them. Contact me *before* you start for help. Hopefully no one is that reliant on this module yet.

The change is to use the mysql date type instead of the integer type on the date columns. This avoids the nasty issue of the UNIX dates needing to be between 1970 and 2038. Now you can put in dates from 0000 to 9999.

You can also enter the word "LIFE" to designation a lifetime member. This gets converted internally to 9999-12-31 and stored in the DB that way, but always displays as the word LIFE to designate a lifetime member.

Re: New release - Membership 0.9.6

LazyBadger Published 06/04/2005 4:57 Home away from home Joined 06/07/2004 Comments 1187

Just one idea - use style
$modversion['version'] = "0.96";
otherwise on modules admin page only data before second dot is show
"0.96" will be shown as is
"0.9.6" will be truncated to 0.9

Re: Membership Module Release Candidate

Published 06/04/2005 8:18 Joined Comments

Hi,

Nice logos ... LazyBadger
and i think "0.9" geting from another file not xoops_version.php

Re: Membership Module Release Candidate

gtop00 Published 06/04/2005 17:55 Updated 06/04/2005 23:45 Friend of XOOPS Joined 11/13/2004 Comments 498

Dear All,

I am trying to make "Membership" module to work without success.
When I update the module I get 30 times the following notice:
Quote:

Notice [PHP]: Undefined index: description in file C:\...\htdocs\portal\modules\system\admin\modulesadmin\main.php line 551

and this is the line 551: Quote:

551 $confobj->setVar('conf_desc', $config['description'], true);

What am I doing wrong?

Edit1: XOOPS V2.07, Membership V0.9.6
Edit2: ...Will be posted to the forum

Re: Membership Module Release Candidate

tedsmith Published 06/04/2005 18:20 Updated 06/04/2005 18:25 Home away from home Joined 06/02/2004 Comments 1151

Hi dheltzel

Firslty, well done on your continued efforts with this mod. Good man!

A couple of extra issues for you that perhaps you can address before version 1...

The e-mail address field is too short. I was unable, for example, to put my Yahoo address in there. I could not get the .uk in at the end. You may want to make this longer to allow for people with long e-mail addresses, or make it non-fixed.

Secondly, I think it would be a major asset to the module to allow the re-ordering of the fields in the admin section. I appreciate that you can show or hide certain one's (which is great) but there will be people that will want to move the ordering of these. It strikes me that you could add numeric fields to the right of each field listed in the ''Preferences' page of the module admin. That way, people could rename each field as they needed, and then add '1', '2', '3' or whatever to dictate where abouts in the list they want those fields to be displayed. And then just click submit and it's done? Just a thought.

Re: Membership Module Release Candidate

dheltzel Published 06/05/2005 21:48 Not too shy to talk Joined 01/08/2003 Comments 164

Quote:

The e-mail address field is too short. I was unable, for example, to put my Yahoo address in there. I could not get the .uk in at the end. You may want to make this longer to allow for people with long e-mail addresses, or make it non-fixed.

The field allows 60 characters, which is the size of the email field in the users table (set by xoops, not this module). Making it longer would seem bad because I would have to truncate it to 60 to store it anyway.

Quote:

Secondly, I think it would be a major asset to the module to allow the re-ordering of the fields in the admin section. I appreciate that you can show or hide certain one's (which is great) but there will be people that will want to move the ordering of these. It strikes me that you could add numeric fields to the right of each field listed in the ''Preferences' page of the module admin. That way, people could rename each field as they needed, and then add '1', '2', '3' or whatever to dictate where abouts in the list they want those fields to be displayed. And then just click submit and it's done? Just a thought.

I'd really like to make the order configurable in the admin side, but frankly, it's more work than I want to undertake for this version. I plan to do almost a full re-write for version 2 so it works with the new user profiles in XOOPS 2.2. That's when I'll add something like this (if XOOPS doesn't do this part already).

In the mean time, it's really trivially easy to change the order of the fields.
1) To change the order in the listing screen, edit the file "templates/memb_listings.html" and rearrange the order of the table columns. The headers and the data rows need to be kept in sync, so you need to move a set of lines in 2 places.
2) To change the order of the fields in the detail form, edit the file "include/memb_edit-form.inc.php" and rearrange the order of the fields. No headers here, so this is even easier.

If you look at those 2 files for at least a minute and can't figure it out, let me know what order you want them and I'll email you the files with the correct order.

Dennis

Re: Membership Module Release Candidate

dheltzel Published 06/05/2005 21:53 Not too shy to talk Joined 01/08/2003 Comments 164

Quote:

What am I doing wrong?

Edit1: XOOPS V2.07, Membership V0.9.6
Edit2: ...Will be posted to the forum

gtop00,
I am using XOOPS 2.0.10 and the only thing I can suggest is that 2.0.7 might have some sort of bug in the configuration settings. 2.0.7 is pretty old and you might want to upgrade just for the security fixes. I can't guarantee that will fix it, but I have no way to test on 2.0.7 to see if I can reproduce the problem you are having.

Dennis

Re: Membership Module Release Candidate

Mithrandir Published 06/05/2005 22:24 XOOPS is my life! Joined 06/21/2003 Comments 6320

Quote:

if XOOPS doesn't do this part already

It does

Re: Membership Module Release Candidate

gtop00 Published 06/06/2005 0:58 Friend of XOOPS Joined 11/13/2004 Comments 498

Dennis thanks a lot.

I do not have much time or experience so I am very carefull in every step. It will take me some time to go to 2.0.10 and later to 2.2 which is the target for this year.
Meanwhile, I'd like to test it before I install it on the live site.

Re: Membership Module Release Candidate

dheltzel Published 06/06/2005 4:13 Not too shy to talk Joined 01/08/2003 Comments 164

Thanks Mith,
I haven't really looked too much at 2.1, but I expect that this module will be much simpler after I rewrite it for 2.2. I'm excited by this because I can focus on adding value that is more specific and let XOOPS do more of the heavy lifting.

It would have been easier to wait until 2.2 came out to write this, but I needed a solution earlier than that. I decided that making it more broadly available might help some others in a similar situation and give me more ideas to consider for the 2.2 compatible version. It cerainly has done that.

The final "cleanup" I've been doing has made me a better module developer as well.

Dennis

Re: Membership Module Release Candidate

dheltzel Published 06/06/2005 15:36 Not too shy to talk Joined 01/08/2003 Comments 164

I just released Membership Module 1.0.
I submitted a new news item, but wanted to put a note here in the mean time.

Dennis

Re: Membership Module Release Candidate

Shelia Published 07/04/2005 18:58 Updated 07/04/2005 19:01 Not too shy to talk Joined 06/22/2003 Comments 140

Interesting!
Is it possible to use this module as a stand alone (not intergrated with XOOPS membership)? I want to add members myself for a group that uses my site that maynot be XOOPS members.

I would like to edit the preference fields to suit my needs.....is this possible? If not would you consider adding this feature?

Re: Membership Module Release Candidate

technigrafa Published 05/30/2006 19:18 Not too shy to talk Joined 07/01/2005 Comments 164

First I'd like to say that this is a very useful module, especially since the 2.2 release isn't stable yet so I can't use the extended profiles feature.

I am having the same problem that Mowaffak mentioned above. When I search for a user, the "Select Field to Search" drop-down field is blank, and searching without putting anything in the fields results in a blank page. If you put something in to search by, I get this error:

 SQL Error: SELECT DISTINCT u.uid,u.uname,u.name,u.email,u.url,u.user_icq,u.user_aim,u.user_yim,u.user_msnm,u.user_from,u.user_occ,u.user_intrest,m.member_id,m.title,m.firstname,m.lastname,m.addr1,m.addr2,m.city,m.state,m.zip,m.country,m.home_phone,m.work_phone,m.join_date,m.renew_date,m.member_status,m.birth_date,m.notes FROM xoops_users u LEFT JOIN xoops_membership_info m ON u.uid = m.uid LEFT JOIN xoops_groups_users_link g ON u.uid = g.uid WHERE g.groupid = 1 AND LIKE '%test%' ORDER by uname

With PHP Debug on I get:

 Notice [PHP]: Use of undefined constant _MEMB_VIEW_PERM_LIST_NAME - assumed '_MEMB_VIEW_PERM_LIST_NAME' in file modules/membership/include/search-form.inc.php line 45 
Notice [PHP]: Use of undefined constant _MEMB_DATE_LIFE - assumed '_MEMB_DATE_LIFE' in file modules/membership/memb_listings.php line 158 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 159 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 160 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 161 
Notice [PHP]: Use of undefined constant _MEMB_DATE_LIFE - assumed '_MEMB_DATE_LIFE' in file modules/membership/memb_listings.php line 158 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 159 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 160 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 161 
Notice [PHP]: Use of undefined constant _MEMB_DATE_LIFE - assumed '_MEMB_DATE_LIFE' in file modules/membership/memb_listings.php line 158 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 159 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 160 
Notice [PHP]: Use of undefined constant _MEMB_DATE_BLANK - assumed '_MEMB_DATE_BLANK' in file modules/membership/memb_listings.php line 161

What's really odd is I am also running this module on another site on the same server with same XOOPS version (2.0.13.2), and it works just fine.

Re: Membership Module Release Candidate

dheltzel Published 08/19/2006 16:51 Not too shy to talk Joined 01/08/2003 Comments 164

Unfortunately, I don't have the time or interest to do any more with this module. Anyoen is free to pick up the development and continue doing bugfixes, etc.

Dennis

Re: Membership Module Release Candidate

LarryAaron Published 12/20/2006 0:54 Just popping in Joined 04/12/2006 Comments 2

This module does not work with 2.0.16 it give the error of " Invalid default value for 'time_changed'

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

Modules: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

I'm Back

Re: I'm Back

Re: I'm Back

Re: I'm Back

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

New release - Membership 0.9.6

Re: New release - Membership 0.9.6

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Re: Membership Module Release Candidate

Login

Search

Recent Comments

Re: New Admin Theme for XOOPS (Beta)

Sanford Pharmacy: Exceptional Pharmacy Services Tailored to You

Re: New Admin Theme for XOOPS (Beta)

Re: XOOPS 2.5.12 Beta-2 available for Testing

Re: XOOPS 2.5.12 Beta-2 available for Testing

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

Archives

News archives