Smf üyelerin mail adreslerini listelemek

04-06-2010, 22:32:42

arkadaşlar mybb de vardı php kod ile mybb sitenizin veritabanından üyelerin sadece mail adreslerini listeliyordu smf de böyle birşey varmı ?

MYBB deki kod aşağıdakidir

<?PHP
$dbname = "";
$dbuser = "";
$dbpwd  = "";
$dbhost = "";
$tablo = "mybb_users";
$veri = "email";
$format = '{MAIL}<br>';
// ayarlar bitti
mysql_connect($dbhost, $dbuser, $dbpwd);
mysql_select_db($dbname);
$sql = mysql_query("SELECT * FROM `".$tablo."`");
while($row = mysql_fetch_array($sql)) {
echo str_replace("{MAIL}", $row[$veri], $format);
flush();
}
mysql_close();
?>

05-06-2010, 01:22:57

#2

KeLKuN

SMF 2.0:

<?php
require_once('SSI.php');
echo '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
	<title>Email</title>
</head>
<body>';

	$request = $smcFunc['db_query']('', '
		SELECT email_address, id_member
		FROM {db_prefix}members
		ORDER BY id_member',
		array()
	);
	$members = array();
	while ($row = $smcFunc['db_fetch_assoc']($request))
	{
		// Build the array.
		$members[] = array(
			'email' => $row['email_address']
		);
	}
	$smcFunc['db_free_result']($request);
	foreach ($members as $member)
	{
		echo $member['email'], '<br />';
	}
	echo '
</body>
</html>';

?>

SMF 1.x:

<?php
require_once('SSI.php');
echo '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
	<title>Email</title>
</head>
<body>';

	$request = db_query("
		SELECT emailAddress, id_member
		FROM {$db_prefix}members
		ORDER BY ID_MEMBER", __FILE__, __LINE__);
	$members = array();
	while ($row = mysql_fetch_assoc($request))
	{
		// Build the array.
		$members[] = array(
			'email' => $row['emailAddress']
		);
	}
	mysql_free_result($request);
	foreach ($members as $member)
	{
		echo $member['email'], '<br />';
	}
	echo '
</body>
</html>';

?>

05-06-2010, 11:40:54

#3

sekiL

Teşekkür ederim arkadaşım. Bende biraz uğraştım aşağıdaki gibi yaptım oldu

<?PHP
$dbname = "dbadi";
$dbuser = "dbuser";
$dbpwd  = "dbpass";
$dbhost = "localhost";
$tablo = "smf_members";
$veri = "email_address";
$format = '{MAIL}<br>';
// ayarlar bitti
mysql_connect($dbhost, $dbuser, $dbpwd);
mysql_select_db($dbname);
$sql = mysql_query("SELECT * FROM `".$tablo."`");
while($row = mysql_fetch_array($sql)) {
echo str_replace("{MAIL}", $row[$veri], $format);
flush();
}
mysql_close();
?>