Jody Cleveland said: > Hello, > > Well, I've had squirrelmail running for quite a while now, and use a > database for preferences. The problem is, there are about 300 users, and I > need to change their email address in personal information. I'm running > phpmyadmin, but I can't actually see their email addresses in any of the > preference tables. Is this possible to do? >
Jody - Their email addresses are in the table you use for userprefs. The default identity is specified by email_address in the prefkey column with their email address as the value. The user's login will be in the first 'user' column. webmin (my favorite alternate config management tool) will let you execute SQL commands against databases. I ran this against my prefs DB, and this should show you what you want: SELECT user, prefkey, prefval FROM userprefs WHERE prefkey = "email_address"; Hope that helps ;) Erin (ebullient) -- 'Waste of a good apple.' - Samwise Gamgee ICQ: 38670353 ------------------------------------------------------- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ -- squirrelmail-users mailing list List Address: [EMAIL PROTECTED] List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
