Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Finding a user by email?  (Read 2598 times)

0 Members and 1 Guest are viewing this topic.

diorgirly

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Finding a user by email?
« 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...
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Finding a user by email?
« Reply #1 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
Pages: [1]   Go Up
 

Page created in 0.027 seconds with 20 queries.