picture.class.php

phpcms2007很好的cms内容管理系统,操作方便

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

class picture
{
	var $channelid;
	var $pictureid;
	var $db;
	var $table_picture;

	function picture($channelid)
    {
		global $db;
		$this->channelid = $channelid;
		$this->pictureid = 0;
		$this->db = &$db;
		$this->table_picture = channel_table('picture', $channelid);
		register_shutdown_function(array(&$this, '__destruct'));
    }

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

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

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