Exporting email addresses.

[anothervenue]

The systems mass email function isn't strong enough for me to do a newsletter. Is there a way to export all my users email addresses so I can use a newsletter program?

[Paul H.]

Create a php file in your root directory with these contents:

<?php
define("IN_MYBB",1);
include("global.php");
$result = $db->query("SELECT * FROM ".TABLE_PREFIX."users")

while ($row = $db->fetch_array($result, MYSQLI_NUM)) {
echo $row['email']."<br />";
}
?>

Excecute it and it should echo all email addresses.

[dthiago]

Create a php file in your root directory with these contents:

<?php
define("IN_MYBB",1);
include("global.php");
$result = $db->query("SELECT * FROM ".TABLE_PREFIX."users")

while ($row = $db->fetch_array($result, MYSQLI_NUM)) {
echo $row['email']."<br />";
}
?>

Excecute it and it should echo all email addresses.

Parse error: syntax error, unexpected T_WHILE in /home/bf4br419/public_html/forum/email.php on line 6

[.m.]

^ add a semicolon at end of line 4 , that is after $result = $db->query("SELECT * FROM ".TABLE_PREFIX."users")

[dthiago]

^ add a semicolon at end of line 4 (after $result = $db->query("SELECT * FROM ".TABLE_PREFIX."users"))

---

<?php
define("IN_MYBB",1);
include("global.php");
$result = $db->query("SELECT * FROM ".TABLE_PREFIX."users"))

while ($row = $db->fetch_array($result, MYSQLI_NUM)) {
echo $row['email']."<br />";
}
?>

Like this?



Another error

Parse error: syntax error, unexpected ')' in /home/bf4br419/public_html/forum/email.php on line 4

[.m.]

^

<?php
define("IN_MYBB",1);
include("global.php");
$result = $db->query("SELECT * FROM ".TABLE_PREFIX."users");

while ($row = $db->fetch_array($result, MYSQLI_NUM)) {
echo $row['email']."<br />";
}
?>

[caygri]

I copy and create the file but it's white page, it's normal?

[.m.]

oh! you can use code like below

<?php
define("IN_MYBB",1);
include("global.php");
$result = $db->query("SELECT * FROM ".TABLE_PREFIX."users");
while ($row = $db->fetch_array($result)) {
echo $row['email']."<br />";
}
?>

[caygri]

just replace it?

[.m.]

^ yes. you can use that code in a php file, upload it to your MyBB files server (where you have global.php file) & execute it