I'm looking for a mod that will allow admin's to change the username for members and will write it to both the pass file and the db so their record still comes up for them. I haven't had much success finding anything in the forums. I'm new to cgi, and I don't want to mess anything up.

I've been downloading the db file and changing it in there manually in the past, but the file is almost a megabyte in size now and it seems like there's gotta be a better way to do it.

Also, when users modify their records, some of the select fields come up blank and they have to be selected again or they end up blank when they are finished. Is there a way to fix that?

Any help would be greatly appreciated!


DBMan SQL Version 1 mods available at:
http://dbmansqlmods.rainbowroomies.com
(Mods based on JPDeni's original mods.)

There is not a mod I know of to change usernames. Since records are associated with the username it's usually not wise to allow them to change their name because as you stated you wind up having to manually change the database itself to do so.

You may want to post a message on the signup form to let registered users know that they should think carefully before choosing a name as it will be associated with their records.

As far as the select field messing up, has this just started happening as the size of your database has become so large?

If it was a new database I would ask you to check that you had the $auth_user_field = 9; set correctly in your .cfg file. And also that your fields are number consecutively.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Thanks for the reply Lois.

As far as the members go, I don't have it set up for them to register. I create the accounts myself. The database holds a profile that goes with their pictures and I set up their accounts as I add them to the website so they have the option of adding their profile if they wish. The website is a fan site of a gaming website, and sometimes people change their player names and ask that they be changed on my website as well. So that is where changing their usernames comes in to play for the database. I need to be able to change that for them without having to d/l the file and manually change it and get it back on the website before someone else makes a change to their profile. IF there's a way to do that through the admin functions, that'd be so much easier.

The select fields have been doing that since I put it up. I'm not sure how many different records there are in there now, but I'm guessing it's around 600-700 with 55 fields. Pretty big database and for the record, I haven't noticed any slowing down with it! If it keeps growing like it is, I imagine I'm gonna have to break down and get the MySQL version. ;)

I checked the cfg file and everything seems to be ok. the $auth_user_field does match the username field, so that should be ok. Everything seems to be numbered right, so not sure what else to look for.

I'm willing to try any suggestions and I appreciate the help! :-)

Shannon


DBMan SQL Version 1 mods available at:
http://dbmansqlmods.rainbowroomies.com
(Mods based on JPDeni's original mods.)

A couple more questions :) How do you have your select fields defined. and are you using for instance:

|; print &build_select_field("Job_Status",$rec{'Job_Status'}");
print qq|

in your add_form? I'm wondering if you select fields might have spaces between the options? If so, this would cause problems.

Can you provide the codes for the select fields or attach a copy of your .cfg file.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Private message sent to ya with the cfg and cgi files attached.

Thanks!


DBMan SQL Version 1 mods available at:
http://dbmansqlmods.rainbowroomies.com
(Mods based on JPDeni's original mods.)