text.php

来自「php 开发的内容管理系统」· PHP 代码 · 共 142 行

<?php
/**
 * Article management
 *
 * @copyright	The XOOPS project http://www.xoops.org/
 * @license		http://www.fsf.org/copyleft/gpl.html GNU public license
 * @author		Taiwen Jiang (phppp or D.J.) <[e-mail]>
 * @since		1.00
 * @version		$Id$
 * @package		module::article
 */
 
if (!defined("XOOPS_ROOT_PATH")) {
	exit();
}
include_once dirname(dirname(__FILE__))."/include/vars.php";
mod_loadFunctions("parse", $GLOBALS["artdirname"]);

if(!class_exists("Text")){
class Text extends ArtObject
{
    //var $db;
    //var $table;

    function Text($id = null)
    {
	    $this->ArtObject();
        //$this->db =& Database::getInstance();
        $this->table = art_DB_prefix("text");
        $this->initVar("text_id", XOBJ_DTYPE_INT, null, false);
        $this->initVar("art_id", XOBJ_DTYPE_INT, 0, true);
        $this->initVar("text_title", XOBJ_DTYPE_TXTBOX, "");
        $this->initVar("text_body", XOBJ_DTYPE_TXTAREA, "", true);

        $this->initVar("dohtml", XOBJ_DTYPE_INT, 1);
        $this->initVar("dosmiley", XOBJ_DTYPE_INT, 1);
        $this->initVar("doxcode", XOBJ_DTYPE_INT, 1);
        $this->initVar("doimage", XOBJ_DTYPE_INT, 1);
        $this->initVar("dobr", XOBJ_DTYPE_INT, 0);
    }
}
}

art_parse_class('
class [CLASS_PREFIX]TextHandler extends ArtObjectHandler
{
    function [CLASS_PREFIX]TextHandler(&$db) {
        $this->ArtObjectHandler($db, art_DB_prefix("text", true), "Text", "text_id", "text_title");
    } 

    function &getByArticle($art_id, $page = 0, $tags=false)
    {
		$text = false;
	    $page = intval($page);
	    if(is_array($tags) && count($tags)>0) {
		    if(!in_array("text_id",$tags)) $tags[] = "text_id";
		    $select = implode(",", $tags);
	    }
	    else $select = "*";

	    if($page){
	        $sql = "SELECT $select FROM " . art_DB_prefix("text") . " WHERE art_id = ". intval($art_id) ." ORDER BY text_id";
	        $result = $this->db->query($sql,1, $page-1);
	        if($result && $myrow = $this->db->fetchArray($result)){
	            $text =& $this->create(false);
	            $text->assignVars($myrow);
	            return $text;
	        }else{
		        xoops_error($this->db->error());
        		return $text;
    		}
        }else{
	        $sql = "SELECT $select FROM " . art_DB_prefix("text") . " WHERE art_id = ". intval($art_id) ." ORDER BY text_id";
	        $result = $this->db->query($sql);
	        $ret = array();
	        while ($myrow = $this->db->fetchArray($result)) {
	            $text =& $this->create(false);
	            $text->assignVars($myrow);
	            $ret[$myrow["text_id"]] = $text;
	            unset($text);
	        }
	        return $ret;
        }
    }

    function &getIdByArticle($art_id, $page = 0)
    {
	    $page = intval($page);
	    if($page){
	        $sql = "SELECT text_id FROM " . art_DB_prefix("text") . " WHERE art_id = ". intval($art_id) ." ORDER BY text_id LIMIT ".(intval($page)-1).", 1";
	        $result = $this->db->query($sql);
	        while ($myrow = $this->db->fetchArray($result)) {
	            $ret = $myrow["text_id"];
	            return $ret;
	        }
	        $ret = false;
        	return $ret;
        }else{
	        $sql = "SELECT text_id FROM " . art_DB_prefix("text") . " WHERE art_id = ". intval($art_id) ." ORDER BY text_id";
	        $result = $this->db->query($sql);
	        $ret = array();
	        while ($myrow = $this->db->fetchArray($result)) {
	            $ret[] = $myrow["text_id"];
	            unset($text);
	        }
	        return $ret;
        }
    }

    function getForPDF(&$text)
    {
	    return $text->getBody(true);
    }

    function getForPrint(&$text)
    {
	    return $text->getBody();
    }

    function deleteByArticle($art_id)
    {
        $sql = "DELETE FROM ".art_DB_prefix("text")." WHERE art_id = ".intval($art_id);
        if (!$result = $this->db->queryF($sql)) {
		  	xoops_error($this->db->error());
            return false;
        }
        return true;
    }

    /**
     * clean orphan text from database
     * 
     * @return 	bool	true on success
     */
    function cleanOrphan()
    {
	    return parent::cleanOrphan(art_DB_prefix("article"), "art_id");
    }
}
'
);
?>