 | ||||
| ||||
| | ||||
| ||||
| Moderated by: martin_wynne |
|
||||||||||||||
| Finding Member Name by Email | Rate Topic |
| Author | Post |
|---|
| Posted: Wed Mar 9th, 2011 12:50 am |
|
1st Post |
|
TVDinner Go UCONN! 
|
I have a member who can not remember his Member Name, but is receiving the mass emails we send through the system to a certain email address. So we know the email he signed up with, but not the member name. Is there a SQL I can run with that email address to find the user name? Thanks.
|
||||||||||||||
| |||||||||||||||
| Posted: Wed Mar 9th, 2011 01:38 am |
|
2nd Post |
|
Jim 127.0.0.1 
|
Just a guess, SELECT user_name FROM wowbb_users WHERE user_email='email@host.bla'
|
|||||||||||||
| ||||||||||||||
| Posted: Wed Mar 9th, 2011 01:43 am |
|
3rd Post |
|
TVDinner Go UCONN!
|
That did not bring back any results. Any other thoughts
|
||||||||||||||
| |||||||||||||||
| Posted: Wed Mar 9th, 2011 01:46 am |
|
4th Post |
|
Jim 127.0.0.1
|
Did you use the single quotes? PM me the guys e-mail address. I did just try that query and it works.
|
|||||||||||||
| ||||||||||||||
| Posted: Wed Mar 9th, 2011 01:54 am |
|
5th Post |
|
TVDinner Go UCONN!
|
PM sent
|
||||||||||||||
| |||||||||||||||
| Posted: Wed Mar 9th, 2011 01:55 am |
|
6th Post |
|
martin_wynne Licence Holder 
|
As an alternative to using MySql, you can go to Admin > Advanced > Backup and Restore > Export table. Select wowbb_users in the drop-down list and click Export. This gives you a file of your user's settings saved on your own computer which you can refer to at any time, search, etc., without any risk at all to your online database. Of course you need to export it again, say once a week, to keep your copy fully up to date. More recent new members in each group can be found by doing CTRL-F at Admin > Users > click a line > User List. regards, Martin.
|
|||||||||||||
| ||||||||||||||
| Posted: Wed Mar 9th, 2011 02:35 am |
|
7th Post |
|
TVDinner Go UCONN!
|
Jim wrote: Just a guess, This worked perfectly once I had the correct email address. Thanks Jim.
|
||||||||||||||
| |||||||||||||||
| Posted: Sun Jun 19th, 2011 06:35 pm |
|
8th Post |
|
sw23185 License Holder
|
What I would like to see would be the ability in the Admin Panel to sort the user lists by e-mail address - ideally you would do this by clicking on the column header just like you do to sort Topics by rating, replies, views, started by, etc. Same net effect as the manual SQL search Jim describes above for an e-mail address, but a lot more user friendly!
|
|||||||||||||
| ||||||||||||||
| Current time is 10:08 am | |
| UltraBB Forums > UltraBB > Software Assistance > Finding Member Name by Email | Top |
 |
