Email List Extraction

[geewhiz]

Does someone have a simple utility that can easily extract the *validated* user names & email address from 4Images?

We would like to generate a mail out that is HTML and as such find that the embedded process does not work for us.

Thanks,

[V@no]

create a .php file with this code:

Code: [Select]

<?php
define&#40;'ROOT_PATH', './4images/'&#41;;
include&#40;ROOT_PATH.'global.php'&#41;;
$sql = "SELECT user_name, user_email, user_allowemails
        FROM ".USERS_TABLE." c
        WHERE user_allowemails <> 0
        ORDER BY user_name ASC";
$result = $site_db->query&#40;$sql&#41;;
$users = array&#40;&#41;;
while &#40;$row = $site_db->fetch_array&#40;$result&#41;&#41; &#123;
$users[&#93; = array&#40;$row['user_name'&#93;, $row['user_email'&#93;&#41;;
&#125;
foreach &#40;$users as $key => $val&#41; &#123;
echo $val[0&#93;." - ".$val[1&#93;."<br />";
&#125;
?>
then, change ROOT_PATH .
this wont show users/emails who set "do not receive emails from admin" to yes.

[geewhiz]

Thanks V@no, I will give it a try and let you know.

[edit]
Works like a charm!  

Thanks again.

[Caelestis]

If phpbb is intergrated... just as v@no's change the rootpath but this one show all users

Code: [Select]

<?php 
define&#40;'ROOT_PATH', './'&#41;; 
include&#40;ROOT_PATH.'global.php'&#41;; 
$sql = "SELECT username, user_email 
        FROM ".USERS_TABLE." c 
        ORDER BY username ASC"; 
$result = $site_db->query&#40;$sql&#41;; 
$users = array&#40;&#41;; 
while &#40;$row = $site_db->fetch_array&#40;$result&#41;&#41; &#123; 
   $users[&#93; = array&#40;$row['username'&#93;, $row['user_email'&#93;&#41;; 
&#125; 
foreach &#40;$users as $key => $val&#41; &#123; 
   echo $val[0&#93;." - ".$val[1&#93;."<br />"; 
&#125; 
?>

[geewhiz]

If phpbb is intergrated...

I wish it was   but not at this time, however thanks for the code I will hang on to it for that "very day".

Thanks