7
Chicks,
The email will come from the Email options in the Admin preferences section. I know this may sound a little crazy, and forgive me if I'm assuming the wrong thing, but the email address in your profile could be different then your main email for the XOOPS site administration.
System email will come fromt he general preferences section, not the user profile, even if you are UID=1 (or admin).
Thats the only realistic thing I can see happening here.
@attoc
I'm not sure why you want to go through the hassle, but yes, it can be done via phpmyadmin. A search through the tables for pending requests will yeild the results your looking for. Although I can't say for sure what table it is, I would have to dig around for that, but it shouldn't be too hard to find.
XOOPS Community Support