down.class.php

采用模块化开发

<?php 
defined('IN_PHPCMS') or exit('Access Denied');

class down
{
	var $channelid;
	var $downid;
	var $db;
	var $table_down;
	function down($channelid)
    {
		global $db;
		$this->channelid = $channelid;
		$this->downid = 0;
		$this->db = &$db;
		$this->table_down = channel_table('down', $channelid);
		register_shutdown_function(array(&$this, '__destruct'));
    }

	function __destruct()
	{
		unset($this->channelid);
		unset($this->downid);
		unset($this->db);
		unset($this->table_down);
	}
	function add($down)
	{
		$sql1 = $sql2 = $s = "";
		foreach($down as $key=>$value)
		{
			$sql1 .= $s.$key;
			$sql2 .= $s."'".$value."'";
			$s = ",";
		}
		$this->db->query("INSERT INTO ".$this->table_down." ($sql1) VALUES($sql2) ");
		if(!$this->db->affected_rows()) return FALSE;
		$downid = $this->db->insert_id();
		if(!$down['islink'])
		{
			$linkurl = item_url('url', $down['catid'], $down['ishtml'], $down['urlruleid'], $down['htmldir'], $down['prefix'], $downid, $down['addtime']);
			$this->db->query("UPDATE ".$this->table_down." SET linkurl='$linkurl' WHERE downid=$downid ");
		}
		return $downid;
	}

	function edit($down)
	{
		$downid = $this->downid;
		if(!$down['islink'])
		{
			$down['linkurl'] = item_url('url', $down['catid'], $down['ishtml'], $down['urlruleid'], $down['htmldir'], $down['prefix'], $downid, $down['addtime']);
		}
		$sql = $s = "";
		foreach($down as $key=>$value)
		{
			$sql .= $s.$key."='".$value."'";
			$s = ",";
		}
		$this->db->query("UPDATE ".$this->table_down." SET $sql WHERE downid=$downid ");
		return TRUE;
	}

	function delete($downids, $file = 0)//File涓