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: Search - Help!  (Read 2751 times)

0 Members and 1 Guest are viewing this topic.

tini

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Search - Help!
« on: June 06, 2007, 08:56:03 pm »
Is there anyway of searching a user by their email address in the gallery? A Hack? Addon? Anything. I really need this feature.
Please let me know  ;)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Search - Help!
« Reply #1 on: June 07, 2007, 12:59:11 pm »
Not that I'm aware of. Use phpMyAdmin as a workaround.
Logged

tini

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Re: Search - Help!
« Reply #2 on: June 08, 2007, 02:28:09 pm »
do you mean like a cpanel? can you please tell me how to do that via phpmyadmin?? is it possible to search for email addresses in the gallery via phpmyadmin??
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Search - Help!
« Reply #3 on: June 08, 2007, 05:24:25 pm »
Code: [Select]
SELECT * FROM `cpg1410_users` WHERE `user_email` LIKE '%tramm%'
ORDER BY `user_name` ASC
would spit out all users that have tramm in their email addy, eg. stramm@hishomeemail.com
(replace tramm with whatever you want to search)
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.016 seconds with 19 queries.