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
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
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!
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
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!
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
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!
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.