forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: diorgirly on February 28, 2006, 12:37:07 am

Title: Finding a user by email?
Post by: diorgirly on February 28, 2006, 12:37:07 am

Hi there. I hope this is the right forum to post this.

I have a bit of a situation on my board. There's a girl that is stealing photographs from my gallery, but I only know her email address. Is there a way I can search my user database with the email and find her profile? I would really appreciate any help.

Thanks in advance...

Title: Re: Finding a user by email?
Post by: Stramm on February 28, 2006, 09:10:15 am

in phpmyadmin (if you have it) click the database name on the leftside menu. Now in topmenu SQL
enter in the box

Code: [Select]

SELECT * FROM `prefix_users` WHERE `user_email`='search@me.com';

change 'prefix' to the db prefix you're using