WordPress.org

1. Rasheed Bydousi
   Member
   Posted 5 years ago #

   Hi ...

   I wnat to collect all the emails from my wp database.

   I am intending to send a newsletter concerning my blog to these emails.

   I don't have neither authors nor users in my blog. These emails are shown in my database through the comments.

   I tried with success to extract these emails (after i downloaded my database and converted it to a doc file) using some softwares , but the problem i can't collect all these emails in one file because these softwares are a demo version.

   I have about 900 emails in my database.

   Is there any method to extract these emails in one file ?

   THANKS

2. pizdin_dim
   Member
   Posted 5 years ago #

   Running this query in your favourite MySQL client will do it:

   select distinct comment_author_email from comments

   However, I think you need to careful here and make sure your email to them isn't interpreted as spam, which I'm sure they won't appreciate, even if there is a hint of "marketing" in the contents.

3. Rasheed Bydousi
   Member
   Posted 5 years ago #

   thanks pizdin

   i found a solutions finally-

   Title : Extract Emails
   Target OS : All Windows
   Copyright : Ixis Research, Ltd
   Email Address: info@getfreefile.com
   Home Page: http://www.getfreefile.com/mailhunt.html
   Download Program: http://www.getfreefile.com/download/mailhunt.zip
   Software Type: Freeware

   hope this help others

   with regards

4. whooami
   Member
   Posted 5 years ago #

   Just one more example of a reason not to use real emails OR register on sites. sigh.

5. pizdin_dim
   Member
   Posted 5 years ago #

   What if the comment form is clearly telling people that they may get a one-off mailing? Which it should do, of course.

6. vkaryl
   Member
   Posted 5 years ago #

   "Which it should do, of course."

   You expect this to happen? Yeah right.

7. pizdin_dim
   Member
   Posted 5 years ago #

   "You expect this to happen?"

   Yes, absolutely. You obviously have a different set of experiences, and that's ok.

8. vkaryl
   Member
   Posted 5 years ago #

   ? Yeah. My experience is that those who rape databases for email addys not only don't say that up front, they don't say that anywhere.

   YOU obviously have a different set of experiences - from 99% of the email-addy providing world. Which is why I use one umbrella email on one domain of my own for everything which is likely to drop spam unrelenting - 99.99% of anything I do anywhere, including here.

9. pizdin_dim
   Member
   Posted 5 years ago #

   Some seemingly concrete numbers there, vkaryl. Where did you get that 99% figure from? It seems rather extreme but I'd love to read up on it.

10. Chris_K
    Member
    Posted 5 years ago #

    So who's is bigger?

11. pizdin_dim
    Member
    Posted 5 years ago #

    Who's is bigger what? If you're talking about the percentages, I doubt we can get any bigger than 99%, can we?

12. whooami
    Member
    Posted 5 years ago #

    "So who's is bigger?" thats a hint to you two, i think -- typically that would be asked of 2 men that were comparing .. ermm, ya knows.

    Ill pipe in though and say that I have NEVER come across a blog site that was up front about any harvesting of emails, if such harvesting ever occurred.

    I'll say one other thing pizdin, also -- I dont believe people are generally honest about much, if they can get away with being dishonest. Given that there isnt enough reward in telling a casual blog commenter that their email might be fished out of the db at a later time, the typical dishonest site owner is just going to grab them without telling you/me/us. The email addy is the reward they want, after all.

    I dont like that, and I believe it goes on. more than we realize. email addresses are GOLD to marketers, after all.

    ---

    heres an interesting thread:

    http://wordpress.org/support/topic/70826?replies=17

13. Chris_K
    Member
    Posted 5 years ago #

    Pizdin_dim - "Who's is bigger" was a direct quote from another thread you were involved in yesterday.

14. pizdin_dim
    Member
    Posted 5 years ago #

    "typically that would be asked of 2 men that were comparing .. ermm, ya knows."

    I'm offended. You're have obviously assumed I'm a man. How presumptuous of you!

15. pizdin_dim
    Member
    Posted 5 years ago #

    "'Who's is bigger' was a direct quote from another thread you were involved in yesterday."

    A direct quote? Huh? I've scoured my threads from yesterday and I can't find the words "who's is bigger" anywhere. Are you confusing me with someone else perhaps?

    EDIT: I've just done a forum search and can't find it, although a search for "bigger" DID produce over 600 results. Which one were you talking about?

16. vkaryl
    Member
    Posted 5 years ago #

    *sigh* pizdin_dim, here: http://wordpress.org/support/topic/83831

    I posted that because the sniping was all too much like what whooami indicated above. If you're not male, fine. How about not doing the "mine's bigger than yours" stuff, then? Just make your points without a lot of hot air and blather, okay? Then no one will assume you're a very young male who's peacocking.... and I use that term advisedly.

    [Edit: as far as percentages, I'm not about to reveal sources. I don't see any point in helping rapers to the goal. YOU figure it out.

    And thanks whoo....]

17. pizdin_dim
    Member
    Posted 5 years ago #

    "I'm not about to reveal sources."

    Then as far as I'm concerned, you're lying.

18. Rasheed Bydousi
    Member
    Posted 5 years ago #

    Ok guys ...

    It is not a spam. just a newsletter with unsubscribe option. it is ok. i send 500 mails and till now no one requested unsubscibtion.

    Pizdin ... didn't you think to use gmail ?

19. pizdin_dim
    Member
    Posted 5 years ago #

    "didn't you think to use gmail?"

    I don't use gmail anyway ... but for what? I don't understand the question.

20. pizdin_dim
    Member
    Posted 5 years ago #

    Whooami,

    From that thread you mentioned, Dgold makes a completely sensible point:

    "If someone doesn't want to get an email from a site-op, they shouldn't type their email address on your Comments/Registration. The site-op OWNS and operates the site. The commenters voluntarily submitted their email address. The blogger has every right to email someone who has posted a comment on the blogger's own site and voluntarily entered their email address."

    I couldn't have possibly said it better.

21. thugparlay
    Member
    Posted 5 years ago #

    wow @ spam request.

Topic Closed

This topic has been closed to new replies.