Notifications
Clear all

[SOLVED] Look up members/penname by email?

8 Posts
3 Users
0 Likes
1,877 Views
 QTW
(@qtw)
Posts: 11
Active Member
Topic starter
 

Several people have contacted me because they forgot their penname. I don't know how to look up pennames by email. Is there an easy way to do this?

URL to your eFiction: http://quoth-the-warbler.org
Version of eFiction: 3.5.3
Version of PHP: PHP 5.3
Version of MySQL: ??
Have you searched for your problem: Yes
If so, what terms did you try: "Email" "Member lookup" "Search" "Penname" "Sort"
State the nature of your problem: Trying to figure out how to find a member's penname based on their email
Do you have a test account for us? No

http://quoth-the-warbler.org/

 
Posted : 03/04/2013 8:43 pm
(@jacci)
Posts: 503
Honorable Member
 

I have the same issue on my site, get 10 emails a week, and the members guesses at what it might be are NEVER what it actually is LOL.

THere is no way to do it via the admin section in the script that i can tell, so i usually do my search via the tables in phpmyadmin. Go to the authors table, and in the search, enter the email in the email field and change the like to = and press go. it should give you the member associated with that email, assuming the email they give you is registered on the site

why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 03/04/2013 8:58 pm
 QTW
(@qtw)
Posts: 11
Active Member
Topic starter
 

Thank you so much! But I am really stupid and don't know how to access the tables... πŸ™ Is phpmyadmin a program I need to download, or can I somehow access the files on my own server?

EDIT: ACK!! I figured it out, but I think I did something wrong! The site won't load now and says

A fatal MySQL error was encountered.
ERROR: Failed to connect to the database!

 
Posted : 03/04/2013 9:41 pm
(@jacci)
Posts: 503
Honorable Member
 

OH no,

if it is a fail to connect, did you edit anything by accident?

Failed to connect usually indicates that there is something wrong with your config file. Did you touch that at all?

why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 03/04/2013 10:59 pm
 QTW
(@qtw)
Posts: 11
Active Member
Topic starter
 

Ah I didn't touch the config file, but I did reset the password to the db since I couldn't remember it. I fixed it all now. Thank you so much for your help!

 
Posted : 03/04/2013 11:03 pm
(@jacci)
Posts: 503
Honorable Member
 

All good then  πŸ˜€

Can be nerve wracking poking around in the tables if you are not used to it!

why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 03/04/2013 11:05 pm
 QTW
(@qtw)
Posts: 11
Active Member
Topic starter
 

I was sure not to change any of that, but I didn't realize that even changing the password to GET to it would cause the whole site to crash. XD Lesson learned!

 
Posted : 03/04/2013 11:10 pm
 SJP
(@sjp)
Posts: 66
Trusted Member
 

I recently added this old mod: https://efiction.org/forums/index.php?topic=4890.msg26383 and it seems to work fine with 3.5.3. It makes it so you don't need to go into the database to look up members by email, which makes things much easier.

 
Posted : 10/04/2013 1:29 pm
Share: