subscription.class.php

来自「Phpcms2008 是一款基于 PHP+Mysql 架构的网站内容管理系统」· PHP 代码 · 共 35 行

<?php
class subscription
{
	var $db = '';
	var $mail_table = '';
	var $t_table = '';
	var $lang ;
    var $mail = '';

	function subscription()
	{
		global $db ,$LANG;
		$this->lang = $LANG;
		$this->db = $db;
		$this->table_mail = DB_PRE.'mail';
		$this->table_t = DB_PRE.'mail_email_type';
	}

	function get_list($condition = null, $page = 1, $pagesize )
	{
		$page = max(intval($page), 1);
		$offset = $pagesize*($page-1);
		$arg['where'] = $this->_make_condition($condition);
		$subscriptions = array();
		$subscriptions['num'] = $this->db->get_one("SELECT COUNT(*) AS number FROM `$this->table_mail` WHERE 1 {$arg['where']}");
		$subscriptions['pages'] = pages($subscriptions['num']['number'], $page, $pagesize);
		$sql = "SELECT * FROM `$this->table_mail` WHERE 1  {$arg['where']} ORDER BY `mailid` DESC limit $offset,$pagesize";
		$result = $this->db->query($sql);
		$mailtype = subtype('mail');
        $api = load('member_api.class.php','member','api');
		while($r = $this->db->fetch_array($result))
		{
			if(!$r['sendtime'])
			{
				$r['sendtime'] = '鏈