Sounds good. I changed the call to the main menu on I think it was line 393
so that it sends me back to the users. Will save me a lot of time tomorrow,
appreciate the help and the tip on the indexing.
Thanks,
Green Onyx
-----Original Message-----
From: inter7 [mailto:inter7]On Behalf Of Ken Jones
Sent: Friday, July 13, 2001 1:01 AM
To: [EMAIL PROTECTED]
Subject: Re: Change Password Flow
Bill Shupp wrote:
>
> on 7/12/01 11:48 PM, Green Onyx at [EMAIL PROTECTED] spake:
>
> > Does anyone know a way that when you hit Change Password on the mod_user
> > screen you can make it go back to the user listing instead of the main
menu.
> > I've hit a few situations where I'm changing numerous passwords and once
and
> > it would be nice to be able to hit change password and be right back in
the
> > user listing where I was.
>
> You have to modify the source. Not sure what version you are running, but
> on 0.60pre4, around line 474 of user.c, change it to call show_users()
> instead of moduser(). Then recompile.
The new moduser code I have does that. You modify a user and
it takes you right back to the same place. Not back to any
other page. Once I'm back on the job with qmailadmin I can
review all the pages and have them keep you on the same page.
On a separate topic, I was looking over the sql queries in
vpopmail and qmailadmin for optimization. Most queries use
user/domain so the mysql index on user/domain works well.
All except the show users page. I was watching people use
qmailadmin and that is the page they look at most. So I
tested creating a new index on the table.
create index domain_idx on vpopmail ( pw_domain(10) );
Results:
vpopmail has 159,197 records
before the index, display user page takes 4.5 seconds to render
after the index, display user page takes 1.5 seconds.
I'd say we should probably include the new index in future
vpopmail versions for mysql.
Ken Jones
