get_mail.php

在传统CMS文章内容管理功能基础上

<?
/*
    [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
	  This is NOT a freeware, use is subject to license terms
*/
error_reporting(0);
set_time_limit($timelimit);
if(!function_exists("CheckRequire")){
	exit("Forbidden");
}
extract($_POST);
if(file_exists("./data/userconfig.php")){
	include_once("./data/userconfig.php");
}
if($_GET['action']=="get"){
	if($dbfrom==1){//当前系统数据库
		$db=new DB($hostname,$username,$password,$database);
		$emailSql = "select `$field` from $table";
		$emailRes = $db->query($emailSql,true);
		while ($emailRow = $db->fetch_array($emailRes)) {
			$emailStr.=$emailRow[$field].",";
		}
		$emailStr = substr($emailStr,0,-1);
		Header("Content-type:txt");
		Header("Accept-Ranges: bytes");
		Header("Accept-Length: ".strlen($emailStr));
		Header("Content-Disposition: attachment; filename=".$file.".txt");
		echo $emailStr;
	}elseif ($dbfrom==2){//其他数据库
		extract($_POST);
		if($database=="mysql"){//MYSQL数据库
			$db=new DB($dbhost,$dbuser,$dbpw,$dbname);
			$emailSql = "select `$field` from $table";
			$emailRes = $db->query($emailSql,true);
			while ($emailRow = $db->fetch_array($emailRes)) {
				$emailStr.=$emailRow[$field].",";
			}
			$emailStr = substr($emailStr,0,-1);
			Header("Content-type:txt");
			Header("Accept-Ranges: bytes");
			Header("Accept-Length: ".strlen($emailStr));
			Header("Content-Disposition: attachment; filename=".$file.".txt");
			echo $emailStr;
		}elseif ($database=="mssql"){//MSSQL数据库
			require_once("../class/odbcdb_class.php");
			$db=new ODBCSQL_db($dbhost,$dbuser,$dbpw,$dbname);
			$db->init();
			$emailSql = "select `$field` from $table";
			$emailRes = $db->result_Query($emailSql);
			while ($emailRow = $db->select_query($emailRes)) {
				$emailStr.=$emailRow[$field].",";
			}
			$emailStr = substr($emailStr,0,-1);
			Header("Content-type:txt");
			Header("Accept-Ranges: bytes");
			Header("Accept-Length: ".strlen($emailStr));
			Header("Content-Disposition: attachment; filename=".$file.".txt");
			echo $emailStr;
		}
	}
}else{
	$p=new Template("./template/member");
	$p->set_file("send","get_mail.html");
	$p->parse("out","send");
	$p->p("out");
}
?>