PHP Forum - Extracting Email Lists

Discussion in 'PHP' started by rwilson30, Mar 27, 2010.

  1. #1
    Does anyone know how you can extract an email list from your php forum? I can send a mass email to all members through the ACP, is there a way to extract this list of email addresses, so I can send emails to all members without having to use the PHPboard mass email function>?
     
    rwilson30, Mar 27, 2010 IP
  2. Alex Roxon

    Alex Roxon Active Member

    Messages:
    424
    Likes Received:
    11
    Best Answers:
    7
    Trophy Points:
    80
    #2
    There's no feature in the admin panel? If not, just write a small script.

    <?php
    
    // MySQL conection here
    
    $Result = mysql_query( "SELECT email FROM users" );
    while( $User = mysql_fetch_assoc( $Result ) ) {
        $Out .= $User['email'] . "\n";
    }
    
    file_put_contents("emails.txt", $Out);
    
    ?>
    PHP:
     
    Alex Roxon, Mar 27, 2010 IP
  3. hugsbunny

    hugsbunny Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    hey , rwilson30 , do you want to exchange links with me !? a blogroll for a poker website also .. a decent but new one :) , see links in signature
     
    hugsbunny, Mar 27, 2010 IP
  4. rwilson30

    rwilson30 Peon

    Messages:
    339
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    There's no feature in the admin panel to do this as far as I know or can see.

    That script looks good but it's in a different language to me! Where would I have to add the script?

     
    rwilson30, Mar 28, 2010 IP
  5. rwilson30

    rwilson30 Peon

    Messages:
    339
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The new site looks good hugsbunny. I'll link exchange with you if you can fill me in on how you created that bonus code/room review table on your homepage. I'm currently having my site redesigned and I want to incorporate something similar in the new homepage :)
     
    rwilson30, Mar 28, 2010 IP
  6. hugsbunny

    hugsbunny Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    lol , ok dude , but it could had been better if you asked for it not set it as a condition for exchanging :eek: . anyway,
    u see the background of my table headings ? the blue row ? it's background is 1px X 42px .. it's here :
    http://www.cardtricking.com/images/stories/tm.gif .. you can design your own gradient and cut it into 1px width with the suitable height your need for your table rows ...
    and play with css a little to get this effect :

    <th> or <td style ='background:url(http://www.cardtricking.com/images/stories/tm.gif) repeat-x 0 0; height:42px '> so simple ... any additional help , anytime ( just if you put my link into your website :p )


    Note: your SEO sucksss , you should take care of it much more than this if you wanna get traffic from the big G
     
    Last edited: Mar 29, 2010
    hugsbunny, Mar 29, 2010 IP