E-Mails in database?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
camoit
Registered User
Posts: 52
Joined: Mon Aug 23, 2010 7:58 pm

E-Mails in database?

Post by camoit »

Where would I find or where should I look to find a list of member e-mail addresses in the database?
If it is there what type of search term should I use?
Thanks.
User avatar
AmigoJack
Registered User
Posts: 5842
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: E-Mails in database?

Post by AmigoJack »

If your table prefix is phpbb_ then you can query this:

Code: Select all

SELECT user_email FROM phpbb_users
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
camoit
Registered User
Posts: 52
Joined: Mon Aug 23, 2010 7:58 pm

Re: E-Mails in database?

Post by camoit »

Thanks for your help. It was set up diferantly. There is 7 databases with this thing. I used search and looked for my own e-mail address. Once i found it then I just browsed the hole thing. There was 637 I found. Out of thoes only 30 came back bad address. Looks like we might be able to salvage this mess after all.
User avatar
AmigoJack
Registered User
Posts: 5842
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: E-Mails in database?

Post by AmigoJack »

camoit wrote:There is 7 databases with this thing
How? A phpBB installation can only access one database, not several parallely.
camoit wrote:I used search
Which search? Board search?
camoit wrote:then I just browsed the hole thing
Thing = what?
camoit wrote:came back bad address
What came back and why is it a bad address?
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
Locked

Return to “[3.0.x] Support Forum”