PHP article calling class code_PHP tutorial

The calling method is as follows:

Copy code The code is as follows:

$Template= '

[{catetitle}]{title|6}{title2|20 }Number of clicks:{hits} Date:{posttime|H:i:s}

';
$Article=new Article();
$Article->Template =$Template;
$Article->CateId=30;
DebugStr('Calling the article based on the template');
DebugStr($Article->getArticleListByCateId());
$Template= '

{title}Number of clicks:{hits} Date:{posttime|Y-m-d H:i:s}

';
$Article->Template=$Template;
$Article->CateId=30;
DebugStr($Article->getArticleListByCateId( $Template, 30));
$Template='{title} Date:{posttime}
';
$Article->Template=$Template;
$Article->CateId=28;
DebugStr($Article->getArticleListByCateId($Template, 28));

The class code is as follows:

Copy the code The code is as follows:

/**
* Article class, convenient for calling article list and content
* Only supports PHP5
*
* Class function list:
* getArticleListByCateId();
*
* @ author Zerolone
* @version 2011-3-14 9:53:42
*
* 2011-1-31 10:11:07 Add static method getCatePreviewUrl getPreviewUrl
*/
class Article {
public $CateId = 0; //Column number 0, can be one column number, or more column. For example: 12, or 12,13
public $Count = 10; //Record number 10
public $TitleCount = 20; //Text display number 20
public $BeginCount = 0; //Start Number of records 0
public $OrderBy = 'id'; //The sorting field is sorted by the id field by default
public $OrderSort = 'DESC'; //The sorting order defaults to DESC, reverse order
public $OrderBy2 = ' '; //Sort field 2
public $OrderSort2 = ''; //Sort order 2
public $Area = 0; //Display area 0, display all
public $Flag = ISSUEFLAG; // Display article status 2, 2 means saved and published
public $Pic = 0; //Only call 0 with pictures, 1 means only call those with pictures
public $Video = 0; //Only call those with pictures 0 and 1 of the video are only calling the video
public $notshowlist= 0; //Do not display 0 that is not in the list, do not display, 1 is displayed
public $AndWhere = ''; //Additional query added
public $Loop = 0; //Loop list 0,
public $Template = ''; //Template
public $IdList = ''; //Id list, used for external calls
//Internally used variables
protected $SqlCateId = ''; //Column Sql statement
protected $SqlCateTitleId = ''; //Column Sql statement
protected $SqlArea = ''; //Display area Sql statement
protected $SqlFlag = ''; //Status
protected $SqlNotShow = ''; //Do not display the list
protected $SqlPic = ''; //Whether to call only pictures
protected $SqlVideo = ''; //Whether to call only videos
protected $SqlOrder = ''; //Sort
protected $SqlLimit = ''; //Display number
protected $SqlWhere = '' ; //Add query
public $SqlStr = ''; //For debugging
/**
* Initialization Sql statement
*
*/
function InitSql(){
//Column number
$CateId =$this->CateId;
if (strpos($CateId, ',')) {
$this->SqlCateId=' AND `cateid` in ('.$CateId.')';
} elseif ($CateId>0) {
$this->SqlCateId=' AND `cateid` ='.$CateId;
}
if ($CateId==0) $this ->SqlCateId='';
/*
$CateId=$this->CateId;
$this->SqlCateTitleId=' AND `id` ='.$CateId;
*/
//Display area
$Area=$this->Area;
if ($Area>0) {
$Area+=0;
$this->SqlArea = ' AND `area'.$Area.'` =1';
}
//Status
$this->SqlFlag= ' AND `flag` = '. $this->Flag ;
//Do not display in the list
$this->SqlNotShow= ' AND `notshowlist` = '. $this->notshowlist;
//Picture
$Pic = $this- >Pic;
if ($Pic==1){
$this->SqlPic= ' AND (`pic1` "" or `pic2`"") ' ;
}else {
$this->SqlPic= '';
}
//Video
$Video = $this->Video;
if ($Video ==1){
$this->SqlVideo= ' AND `isvideo`=1 ';
}else {
$this->SqlVideo= '';
}
//Additional query
$AndWhere = $this->AndWhere;
if ($AndWhere''){
$this->SqlWhere = ' And ' . $AndWhere;
}
//Sort
$this->SqlOrder= ' ORDER BY `'.$this->OrderBy.'' '.$this->OrderSort;
if ($ this->OrderBy2!='') $this->SqlOrder.= ' ,`'.$this->OrderBy2.'' '.$this->OrderSort2;
//Display number
$this->SqlLimit= ' LIMIT '.$this->BeginCount.', '.$this->Count.';';
}
/**
* Clear, set as default
*/
function Clear(){
$this->CateId = 0; //The column number is 0, which can be one column number, or multiple columns.For example: 12, or 12,13
$this->Count = 10; //Record number 10
$this->TitleCount = 20; //Text display number 20
$this-> ;BeginCount = 0; //The starting record number is 0
$this->OrderBy = 'id'; //The sorting field is sorted by the id field by default
$this->OrderSort = 'DESC'; / /The sorting order defaults to DESC, reverse order
$this->Area = 0; //Display area 0, display all
$this->Flag = ISSUEFLAG; //Display article status 2, 2 means saved Published
$this->Pic = 0; //Only call 0 with pictures, 1 means only call 0 with pictures
$this->Video = 0; //Only call 0 with video , 1 is to only call the video
$this->notshowlist = 0; //Do not display 0 that is not in the list, do not display, 1 to display
$this->AndWhere = ''; //Extra Added query
$this->Loop = 0; //Loop list 0,
$this->Template = ''; //Template
}
/**
* Return the article content string
*
* {

{title| 20}{title2|20}Number of clicks:{hits} {memo|20} Date:{posttime|H:i:s y-m-d}

}
* The description is as follows, generate a Loop template, the instructions in {} are as follows
* html link, priority is given to displaying jump links
* title title, add the parameters after the | line: 1. Display limit for the number of words, 2. Whether to display after the word limit Omit the symbol, title is to display title first, title2 is to display title2 first
* hits click rate
* posttime submission time, the following parameters are the date formatting method
* memo call text, add | after the line Parameters: 1. It is the word limit display, 2. It is whether to display the ellipsis symbol after the word limit
* loop loop variable
*
* @return article list
*/
function getArticleListByCateId(){
$this->InitSql();
$Str_Loop = '';
$ReturnString = '';
$Template = $this-> ;Template;
//Article list
$SqlStr = 'SELECT * FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr. =$this->SqlNotShow; //Whether to display the non-displayed
$SqlStr.=$this->SqlCateId; //Column
$SqlStr.=$this->SqlArea; //Area
$SqlStr.=$this->SqlFlag; //Status
$SqlStr.=$this->SqlPic; //Picture
$SqlStr.=$this->SqlVideo; //Video
$SqlStr.=$this->SqlWhere; //Additional query
$SqlStr.=$this->SqlOrder; //Sort
$SqlStr.=$this->SqlLimit; //Display number of items
$this->SqlStr=$SqlStr;
$this->OrderBy2 = '';
$this->OrderSort2 = '';
//Title 1
@preg_match('/{title|([d].+?)}/i', $Template, $matches);
@$title_count = $matches[1];
// Title 2
@preg_match('/{title2|([d].+?)}/i', $Template, $matches);
@$title2_count = $matches[1];
/ /Call text
@preg_match('/{memo|([d].+?)}/i', $Template, $matches);
@$memo_count = $matches[1];
//Time display format
@preg_match('/{posttime|(.+?)}/i', $Template, $matches);
@$posttime_format=$matches[1];
/ /Replace these
$Template = preg_replace('/({title|[d].+?})/i', '{title}', $Template);
$Template = preg_replace('/ ({title2|[d]+.?})/i', '{title2}', $Template);
$Template = preg_replace('/({posttime|.+?})/i', ' {posttime}', $Template);
$Template = preg_replace('/({memo|[d].+?})/i', '{memo}', $Template);
// loop
$loop = $this->Loop;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase-> Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$id = $DB_Record['id'];
$this- >IdList .= $id . ',';
$title = $DB_Record['title'];
$title_full = $title;
$title2 = $DB_Record['title2'];
$titlestrip = strip_tags($title);
$memo = $DB_Record['memo'];
$posttime = $DB_Record['posttime'];
$reurl = $DB_Record['reurl '];
$url = $DB_Record['html'];
$hits = $DB_Record['hits'];
$titlecolor = $DB_Record['titlecolor'];
$catetitle = $DB_Record['catetitle'];
$catedir = $DB_Record['catedir'];
$catedesc = $DB_Record['catedesc'];
$Str_Loop = $Template;
/ /Process each string
//Jump link, if it exists, the article link is a jump link
if ($reurl''){
$html = $reurl;
}else {
$html = SITE_URL . SITE_FOLDER . ARTICLEURL . $url;
}
$pic1 = $DB_Record['pic1'];
$pic2 = $DB_Record['pic2'];
if ($pic2''){
$pic = $pic2;
}else{
$pic = $pic1;
}
//Title length//Call text
if ($title_count) $title = subString($title, $title_count);
if ($title2_count) $title2 = subString($title2, $title2_count) ;
if ($memo_count) $memo = subString($memo, $memo_count);
//Article title color, using Style seems to be higher
if ($titlecolor'') $ title = ''.$title.'';
//Time formatting
if ($posttime_format!= ''){
$posttime=date($posttime_format, $posttime);
}else {
$posttime=date('Y-m-d H:i', $posttime);
}
//Replace each content
//Title
$Arr_Search = array('{id}', '{title_full}', '{title}', '{title2}', '{titlestrip}', '{memo}', '{html}', '{hits}', '{posttime}', '{catetitle}', '{catedir}', '{pic}', '{pic1}', '{ pic2}', '{loop}', '{catedesc}');
$Arr_Replace = array($id, $title_full, $title, $title2, $titlestrip, $memo, $html, $hits, $ posttime, $catetitle, $catedir, $pic, $pic1, $pic2, $loop++, $catedesc);
$Str_Loop=str_replace($Arr_Search, $Arr_Replace, $Str_Loop);
$ReturnString.=$ Str_Loop;
}
}
//Clear after use
$this->Clear();
return $ReturnString;
}
/**
* Return to the html in the column
*/
function DefaultHtml(){
$html='';
$this->InitSql();
//-------------------------- -----0
$SqlStr = 'SELECT `html` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.=$ this->SqlCateId;//Column
$SqlStr.=$this->SqlFlag;//Status
$SqlStr.=$this->SqlOrder;//Sort
$SqlStr.= $this->SqlLimit;//Display number
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ( )) {
$html = $MyDatabase->ResultArr [0][0];
}
return $html;
}
/**
* Get the column address
* @param $id column number
*/
static public function getCateHTML($id){
$html = '';
$SqlStr = 'SELECT `dir` FROM `'.DB_TABLE_PRE . 'article_cate`';
$SqlStr.= ' WHERE `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$html = $MyDatabase->ResultArr [0][0];
}
return $html;
}
/**
* Return to column title
*/
function getCateTitle (){
$CateTitle='';
//-------------------0
$SqlStr = 'SELECT `title` FROM ` '.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.=$this->SqlCateTitleId; //Column
$MyDatabase=Database::Get ();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$CateTitle = $MyDatabase->ResultArr [0][0];
}
return $CateTitle;
}
/**
* Get the article date and return a list link of type 2011-1
*/
function getArticListDate(){
//Column number
$CateId=$this- >CateId;
if (strpos($CateId, ',')) {
$this->SqlCateId=' AND `cateid` in ('.$CateId.')';
} elseif ($CateId>0) {
$this->SqlCateId=' AND `cateid` ='.$CateId;
}
$cateList='';
$intCount=0;
$strSearch=''; //Search year and month
$strMonth=''; //Month name
//Get today's year-month
$year=date("Y", time());
$month=date("m",time());
//This year
$SqlStr = 'SELECT COUNT( * ) from `'.DB_TABLE_PRE . 'view_article`' .' WHERE DATE_FORMAT(`posttime`, '%Y')=''.$year.''';
//Column
$SqlStr.=$this->SqlCateId;
$MyDatabase ->SqlStr = $SqlStr;
$MyDatabase=Database::Get();
if ($MyDatabase->Query ()) {
$intCount = $MyDatabase->ResultArr [0 ][0];
$cateList.='

'.$year.' ('.$intCount. ')

';
}
//Loop this year
for($i=$month;$i>0;$i--){
if (strlen($i)==1){
$strSearch= $year . '-0' . $i;
}else{
$strSearch= $year . '-' . $i ;
}
switch ($i) {
case 1:
$strMonth='January';
break;
case 2:
$strMonth='Two
break;
case 3:
$strMonth='March';
break;
case 4:
$strMonth='April';
break;
case 5:
$strMonth='May';
break;
case 6:
$strMonth='June';
break;
case 7:
$strMonth='July';
break;
case 8:
$strMonth='August';
break;
case 9:
$ strMonth='September';
break;
case 10:
$strMonth='October';
break;
case 11:
$strMonth='November ';
break;
case 12:
$strMonth='December';
break;
}
$SqlStr = 'SELECT COUNT( * ) from `'.DB_TABLE_PRE.'article` WHERE DATE_FORMAT(`posttime`, '%Y-%m')=''.$strSearch.''';
//栏目
$SqlStr.=$this->SqlCateId;
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query () ) {
$DB_Record = $MyDatabase->ResultArr [0];
$intCount = $DB_Record[0];
if($intCount>0){
$cateList.='

'.$strMonth.' ('.$intCount.')

';
}
}
}
//最近9年循环
for($i=$year-1;$i>$year-10;$i--){
$SqlStr = 'SELECT COUNT( * ) from `'.DB_TABLE_PRE.'article` WHERE DATE_FORMAT(`posttime`, '%Y')=''.$i.''';
//栏目
$SqlStr.=$this->SqlCateId;
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query () ) {
$DB_Record = $MyDatabase->ResultArr [0];
$intCount = $DB_Record[0];
if($intCount>0){
$cateList.='

'.$i.' ('.$intCount.')

';
}
}
}
return $cateList;
}
/**
* Return to the column title list based on the upper-level column number.
*
* @param parent ID $parentid
*
*/
function getTitleListByCateId($parentid){
$CateTitleList='';
//-------------------0------1------2
$SqlStr = 'SELECT `title`, `id`, `url` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE parentid=' . $parentid;
$SqlStr.= ' ORDER BY `level` ASC;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
if($DB_Record[2]==''){
$CateTitleList.= ''.$DB_Record[0].' ';
}else{
$CateTitleList.= ''.$DB_Record[0].' ';
}
}
}
return $CateTitleList;
}
/**
* According to the column number, return the column article image and text list.
* @param $cateid superior number
* @param $limit number of items displayed
* @param $prev prefix tag
*/
function getArticlePicListByCateId($cateid, $limit, $prev=''){
$str_return='';
//-------------------0------1------2---------3-------4--------5
$SqlStr = 'SELECT `title`, `id`, `reurl`, `html`, `pic1`, `memo` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `cateid`=' . $cateid;
$SqlStr.= ' AND `flag`=' . ARTICLE_FLAG;
$SqlStr.= ' AND `pic1`!=''';
$SqlStr.= ' ORDER BY `order` ASC, `id` DESC';
$SqlStr.= ' LIMIT ' . $limit;
//echo $SqlStr;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$DB_Record[0] = subString($DB_Record[0], 18);
$DB_Record[5] = subString($DB_Record[5], 56);
$url= $DB_Record[3];
if($DB_Record[2]!='') $url= $DB_Record[2];
$str_return.= '

';
$str_return.= '

';
$str_return.= '

'.$DB_Record[0].''.$DB_Record[5].'查看

';
$str_return.= '

';
}
}
return $str_return;
}
/**
* 根据ID， 返回下级最大分类。
*
* @param 编号 $id
*
*/
function getSIdById($id){
$ReturnContent='';
//------------------0------1
$SqlStr = 'SELECT `id` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `parentid`=' . $id;
$SqlStr.= ' ORDER BY `level` DESC';
// echo $SqlStr;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
}
return $ReturnContent;
}
/**
* Return column title
* @param $id column number
*/
function getCateTitleById($id){
$CateTitle='';
//-------------------0
$SqlStr = 'SELECT `title` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$CateTitle = $MyDatabase->ResultArr [0][0];
}
return $CateTitle;
}
/**
* Return to the upper level column ID
* @param $id column number
*/
function getParentCateIdById($id){
$CateTitle='';
//--------------------0
$SqlStr = 'SELECT `parentid` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$CateTitle = $MyDatabase->ResultArr [0][0];
}
return $CateTitle;
}
/**
* Add a click based on the article number
* @param $id article number
*/
static public function UpdateHits($id){
//-------------------0
$SqlStr = 'UPDATE `' . DB_TABLE_PRE . 'article`';
$SqlStr.= ' SET `hits`=`hits`+1';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
$MyDatabase->ExecuteQuery ();
}
/**
* Return the number of clicks based on the article number
* @param $id article number
*/
static public function GetHits($id){
$ReturnContent='';
//-------------------0
$SqlStr = 'SELECT `hits` FROM `' . DB_TABLE_PRE . 'article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
// var_dump($SqlStr);
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
}
return $ReturnContent;
}
/**
* According to the number, return the content
* @param $id article number
*/
function getContentById($id){
$ReturnContent='';
//-------------------0
$SqlStr = 'SELECT `content` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
}
return $ReturnContent;
}
/**
* According to the number, return address
* @param $id article number
*/
function getUrlById($id){
$ReturnContent='';
//------------------0
$SqlStr = 'SELECT `reurl` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
if($ReturnContent==''){
$ReturnContent='article_details.php?id='.$id;
}
}
return $ReturnContent;
}
/**
* According to the number, return the static page address
* @param $id article number
*/
function getHTMLById($id){
$ReturnContent='';
//------------------0
$SqlStr = 'SELECT `html` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) $ReturnContent = $MyDatabase->ResultArr [0][0];
return $ReturnContent;
}
/**
* According to the number, return to the previous page
* @param number $id
* @param column number $cateid
*/
function getPrevById($id, $cateid){
$ReturnContent='没有文章';
//------------------0
$SqlStr = 'SELECT `title`, `html` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`$SqlStr.= ' AND `cateid`='.$cateid;
$SqlStr.= ' AND `flag`=' . ARTICLE_FLAG;
$SqlStr.= ' ORDER BY `order` ASC, `id` desc';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) $ReturnContent = ''. subString($MyDatabase->ResultArr [0][0], 100) . '';
return $ReturnContent;
}
/**
* According to the number, return to the next page
*
* @param number $id
* @param column number $cateid
*/
function getNextById($id, $cateid){
$ReturnContent='没有文章';
//------------------0
$SqlStr = 'SELECT `title`, `html` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`>'.$id;
$SqlStr.= ' AND `cateid`='.$cateid;
$SqlStr.= ' AND `flag`=' . ARTICLE_FLAG;
$SqlStr.= ' ORDER BY `order` ASC, `id` desc';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) $ReturnContent = ''. subString($MyDatabase->ResultArr [0][0], 100) . '';
return $ReturnContent;
}
/**
* Return navigation information according to level
* @param $level
*/
function getNavByLevel($level){
$ReturnContent=SITE_NAV;
$ReturnContent.=ARTICLE_NAV;
//$level=substr($level, 0, 2);
//$level='01010101';
$level_list='';
$level_len=strlen($level);
for ($i=2; $i$level_list.=substr($level,0,$i) . ',';
}
$level_list.=$level;
// DebugStr( $level_list);
$SqlStr = 'SELECT * FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `level` in (' .$level_list . ')';
$SqlStr.= ' ORDER BY `level` ASC;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$levels = $MyDatabase->ResultArr;
foreach ($levels as $level){
$ReturnContent.=' '.$level['title'].' >';
}
}
return $ReturnContent;
}
/**
* 首页专用调用， 根据一个栏目编号， 返回该栏目下面的文章， 其中包括一张图片。
* @param $cateid
*/
function getPartByCateId($cateid){
$strReturn='

';
$id=0;
$SqlStr = 'SELECT * FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `cateid` =' .$cateid;
$SqlStr.= ' AND `flag` ='.ARTICLE_FLAG;
$SqlStr.= ' AND `pic1` !=''';
$SqlStr.= ' ORDER BY `order` ASC, `id` DESC';
$SqlStr.= ' LIMIT 1;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
// DebugStr($SqlStr);
if ($MyDatabase->Query ()) {
$article = $MyDatabase->ResultArr[0];
$id = $article['id'];
$strReturn.='

';
}
$strReturn.='

';
//文章列表
$SqlStr = 'SELECT * FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `cateid` =' .$cateid;
$SqlStr.= ' AND `flag` ='.ARTICLE_FLAG;
$SqlStr.= ' AND `id` !='.$id;
$SqlStr.= ' ORDER BY `order` ASC, `id` DESC';
$SqlStr.= ' LIMIT 6;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$articles = $MyDatabase->ResultArr;
$i=1;
foreach ($articles as $article){
if ($i==1){
$strReturn.=''.subString($article['title'],34).'';
}else{
$strReturn.=''.subString($article['title'],50).'';
}
$i++;
}
}
$strReturn.='

';
return $strReturn;
}
/**
* According to the number, return Level
* @param $id
*/
function getLevelById($id){
$ReturnContent='';
$SqlStr = 'SELECT `Level` FROM `'.DB_TABLE_PRE . 'article_cate`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) $ReturnContent = $MyDatabase->ResultArr [0][0];
return $ReturnContent;
}
/**
* Display article status status
*
* @param integer $flag
* @return status string
*/
public static function printFlag ( $flag = 0 ){
switch ( $flag ){
case 0:
return "未存 未发";
case 1:
return "已存 未发";
case 2:
return "已存 已发";
default:
return "未知状态";
}
}
/**
* Display HTML generation status
*
* @param integer $flag
* @return status string
*/
public static function printHtmlFlag ( $flag= 0 ){
switch ( $flag ){
case 0:
return "未生";
case 1:
return "已生";
default:
return "未知状态";
}
}
/**
* Display video status
*
* @param integer $flag
* @return status string
*/
public static function printVideoFlag ( $flag= 0 ){
switch ( $flag ){
case 1:
return '视';
default:
return '';
}
}
/**
* Display review status
*
* @param integer $flag
* @return status string
*/
public static function printIssueFlag ( $flag = 0 ){
switch ( $flag ){
case 1:
return "未审";
case 2:
return "已审";
default:
return "未知状态";
}
}
/**
* Returns whether the folder can be created
*
* @param $dir folder name
* @param $cateid column number
*/
public static function canCreateDir($dir, $cateid){
$can=true;
//文件夹为空， 肯定不能添加的
if ($dir==''){
$can=false;
}
//系统定义不能创建的目录
if (strpos(CANTDIR, '|'. $dir . '|')){
$can=false;
}
//文章系统文件夹文件夹分类中是否已存在该文件夹
//-------------------0
$SqlStr = 'SELECT `dir` FROM `'.DB_TABLE_PRE . 'article_cate`' ;
$SqlStr.= ' WHERE `dir`='' . $dir . ''';
$SqlStr.= ' AND `id`'' . $cateid . ''';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) $can=false;
//返回值
return($can);
}
/**
* Get the column preview address through the column number
* @param $cateid
*/
public static function getCatePreviewUrl($cateid){
$template_url ='';
$SqlStr = ' SELECT `template_url`';
$SqlStr.= ' FROM `'.DB_TABLE_PRE.'view_articlecate` ';
$SqlStr.= ' WHERE `id`='.$cateid;
$SqlStr.= ' LIMIT 1';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()){
$template_url = $MyDatabase->ResultArr [0][0];
}
return($template_url);
}
/**
* Get the article preview address through the article number
* @param $cateid
*/
public static function getPreviewUrl($id){
$template_url ='';
$SqlStr = ' SELECT `template_url`';
$SqlStr.= ' FROM `'.DB_TABLE_PRE.'view_articlelist` ';
$SqlStr.= ' WHERE `id`='.$id;
$SqlStr.= ' LIMIT 1;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()){
$template_url = $MyDatabase->ResultArr [0][0];
}
return($template_url);
}
/**
* Update HTML file name
* @param $id id, no default value, must be specified
* @param $posttime submission time, default value is current
*
* @return Updated address
*/
function UpdateHTML($id, $posttime=''){
//如果没有日期，则获取当前时间
if ($posttime==''){
$posttime=time();
}else{
$posttime=strtotime($posttime);
}
$ArticlePath = date("ym",$posttime) . '/'. date("d",$posttime);
if (createFolder(ARTICLEPATH, $ArticlePath)){
$html = ARTICLEURL . $ArticlePath . '/' . date( "His", time() ) . rand( 1000, 9999 ) . '.html';
$MyDatabase=Database::Get();
$ArrField=array('html');
$ArrValue=array($html);
$MyDatabase->Update('article', $ArrField, $ArrValue, '`id`='.$id);
return($html);
}
}
/**
* Generate HTML file
* @param $id
*/
function HTML($id){
}
/**
* Get the column name
*
* @param $id article column number
*/
function getCate($cateid){
$level = $this->getLevelById($cateid);
$level_len= strlen($level) / 2 ;
//level列表
$level_str='0';
for ($i=1;$i$level_str.= ','.substr($level,0, 2*$i);
}
$navbar = '首 页 >';
$SqlStr = ' SELECT * ';
$SqlStr.= ' FROM `'. DB_TABLE_PRE . 'article_cate`';
$SqlStr.= ' WHERE `level` in ('.$level_str.')';
$SqlStr.= ' ORDER BY `level` ASC';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$html = $DB_Record['id'];
if ($DB_Record['url']!='') $html=$DB_Record['url'];
$navbar.=' '. $DB_Record['title'] .' >';
}
}
return $navbar;
}
}
?>

数据库

复制代码 代码如下:

--
-- Table structure `mc_article`
--
CREATE TABLE IF NOT EXISTS `mc_article` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Number',
`comment` tinyint(3) unsigned NOT NULL COMMENT 'Whether to leave a message',
`comments` tinyint(3) unsigned NOT NULL COMMENT 'Number of messages',
`commentcheck` tinyint(3) unsigned NOT NULL COMMENT 'Reply to review',
`posttime` int(10) unsigned NOT NULL COMMENT 'Submit time',
`title` varchar(255) NOT NULL COMMENT 'Title',
`title2` varchar(255) default NULL COMMENT 'Title2',
`content` text COMMENT 'Content',
`flag` tinyint(1) NOT NULL default '0' COMMENT 'flag',
`cateid` int(10) unsigned NOT NULL default '0' COMMENT 'column number',
`sourceid` mediumint(8) unsigned NOT NULL default '0',
`reurl` varchar(255) default NULL COMMENT 'jump address',
`hits` mediumint(8) unsigned NOT NULL default '0' COMMENT 'number of hits',
`author` varchar(255) default NULL COMMENT 'author',
`from` varchar(255) default NULL COMMENT 'source',
`keyword` varchar(255) default NULL COMMENT 'keyword',
`order` tinyint(4) unsigned NOT NULL default '99 ' COMMENT 'Sequence',
`memo` text COMMENT 'Introduction',
`pic1` varchar(255) default NULL COMMENT 'Picture 1',
`pic2` varchar(255) default NULL COMMENT ' Picture 2',
`userid` int(10) unsigned NOT NULL default '0' COMMENT 'user number',
`html` varchar(255) default NULL COMMENT 'address',
`ishtml` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Whether to generate',
`area` int(10) unsigned NOT NULL default '0' COMMENT 'Display area',
`custom1` varchar(255) default NULL COMMENT 'Custom 1',
`custom2` varchar(255) default NULL COMMENT 'Custom 2',
`custom3` varchar(255) default NULL COMMENT 'Custom 3',
`custom4` varchar(255) default NULL COMMENT 'Custom 4',
`custom5` varchar(255) default NULL COMMENT 'Custom 5',
`res_id` int(10) unsigned NOT NULL default ' 0',
`special` varchar(255) default NULL,
`area1` tinyint(1) unsigned NOT NULL default '0',
`area2` tinyint(1) unsigned NOT NULL default '0 ',
`area3` tinyint(1) unsigned NOT NULL default '0',
`area4` tinyint(1) unsigned NOT NULL default '0',
`area5` tinyint(1) unsigned NOT NULL default '0',
`isvideo` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Whether it is a video program',
`notshowlist` tinyint(4) NOT NULL default '0' COMMENT 'Do not display In list',
`titlecolor` varchar(7) default NULL COMMENT 'Title color',
`url` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE =MyISAM DEFAULT CHARSET=utf8 COMMENT='Article' AUTO_INCREMENT=87 ;
--
-- Transfer the data in the table `mc_article`
--
INSERT INTO `mc_article` (`id `, `comment`, `comments`, `commentcheck`, `posttime`, `title`, `title2`, `content`, `flag`, `cateid`, `sourceid`, `reurl`, `hits`, `author`, `from`, `keyword`, `order`, `memo`, `pic1`, `pic2`, `userid`, `html`, `ishtml`, `area`, `custom1`, `custom2 `, `custom3`, `custom4`, `custom5`, `res_id`, `special`, `area1`, `area2`, `area3`, `area4`, `area5`, `isvideo`, `notshowlist`, `titlecolor`, `url`) VALUES
(1, 0, 0, 0, 0, 'School Introduction', '', '

rn

rn

< ;FONT style="BACKGROUND-COLOR: #0000ff" color=#800000>[Test modification]Chongqing Manxiang Culture Communication Co., Ltd. is a collection of originals> ; Animation and entertainment product development, modern animation culture development, promotion, planning and production company that provides multimedia production and uses television and network communication as platforms. In April 2008, it settled in the Chongqing Animation Base in the Northern New Area of ​​Chongqing High-tech Development Zone.
Manxiangzu Company has established the largest paperless animation production base in Southwest China through its many years of management and operation, and has assembled a team of the best elites in the industry. It has established good cooperative relationships with many domestic film and television institutions, publishing houses, digital art manufacturers, and multimedia platforms to achieve complementary advantages and resource sharing, and has formed a broad and far-reaching influence in the industry and market.
Currently, the company is mainly engaged in the development of original TV animations, original film animations and other brand products. It also involves business areas such as CD publishing, book production and distribution, advertising production, game development and cultural product licensing. Manxiangzu Company has always firmly believed in the line of quality first, strives to contribute quality products to society, and strives to develop the Chinese animation market. Manxiangzu Company has always firmly believed in the line of quality first, strives to contribute quality products to society, and strives to develop the Chinese animation market. Manxiangzu Company has always firmly believed in the line of quality first, strives to contribute quality products to society, and strives to develop the Chinese animation market.

rn

', 0, 28, 0, '', 2, '', '', '', 255, '', ' ', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(2, 0, 0, 0, 0, 'Company Profile', '', 'Company Profile Company Profile Company Profile Company Profile Company Profile Company Profile Company Profile Company Profile Company Profile Company Profile', 1, 28, 0, '' , 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0 , 0, 0, 0, 0, '', NULL),
(3, 0, 0, 0, 0, 'Latest News', '', '

Put the image here to display the mixed image. Click to copy the image. Address. Delete the original picture.

rn

Then the pictures are mixed.

', 0, 28, '', 0, '', '', '', 255 , '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL ),
(4, 0, 0, 0, 0, 'Illustration Daily Class', '', '

rn

rn

Illustration Daily Class This course will start from the current game art production Based on the latest technological development, the art production specifications of game companies and other actual needs, it systematically and comprehensively introduces the essence of various technical connotations of game art, focusing on cultivating students' game art theory and practical application capabilities. It strives to enable students to master various technologies and necessary qualities that art designers in game development companies must master. It combines actual industry resources to train students through a large number of actual project operations, strengthen students' execution capabilities, shorten workplace training time, and guide them. Complete mature work.

\r\n

', 1, 28, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(5, 0, 0, 0, 0, '游戏人设周末班', '', '游戏人设周末班游戏人设周末班游戏人设周末班游戏人设周末班游戏人设周末班游戏人设周末班', 1, 28, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(6, 0, 0, 0, 0, '时尚插画名师班', '', '时尚插画名师班时尚插画名师班时尚插画名师班时尚插画名师班时尚插画名师班', 1, 28, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(7, 0, 0, 0, 0, '周末插画名师班', '', '周末插画名师班周末插画名师班周末插画名师班周末插画名师班', 1, 28, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(8, 0, 0, 0, 0, '无纸插画日常班', '', '

无纸插画日常班无纸班无纸班无纸班无纸班无纸班无纸班无纸班无纸班无纸班无纸班无纸

\r\n

\r\n

\r\n

插画日常班无纸插画日常班

', 1, 28, 0, '', 9, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(9, 0, 0, 0, 0, 'QQ群列表', '', '

\r\n
• 建模群：15874233
\r\n
• 材质群：17068255
\r\n
• 动画群：15874233
\r\n
• 动力学群：17068255
\r\n
• realflow群：15874233

', 1, 28, 0, '', 1, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(73, 0, 0, 0, 1277028682, '沙发杀毒范德萨发', '', '', 2, 30, 0, '', 3, '', '', '', 99, '', '', '', 1, '/article//1006/20/1811352579.html', 1, 0, '青云谱', '12121', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(74, 0, 0, 0, 1277028699, '杀毒范德萨发啥', '', '', 2, 31, 0, '', 0, '', '', '', 99, '', '', '', 1, '/article//1006/20/1811471203.html', 1, 0, '沙发的撒', '12312321', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(76, 0, 0, 0, 1277118129, 'testestestestestestestestestestestestestestestestestestestestestestestestestestestestestestestestestestestestestes', '', 'testestetseteste', 2, 39, 0, '', 4, '', '', '', 99, '中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试中文测试', '', '', 0, '/article//1006/21/1902177805.html', 1, 0, '', '', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(77, 0, 0, 0, 1277131621, 'Enterprise service single-page call demonstration', '', 'Enterprise service single-page call demonstrationEnterprise service single-page call demonstrationEnterprise service single-page call demonstrationEnterprise service single-page call demonstrationEnterprise service Single page call demonstration enterprise service single page call demonstration enterprise service single page call demonstration enterprise service single page call demonstration enterprise service single page call demonstration enterprise service single page call demonstration enterprise service single page call demonstration enterprise service single page call demonstration enterprise service single page Call demonstration enterprise service single-page call Demonstration enterprise service single-page call Demonstration enterprise service single-page call Demonstration enterprise service single-page call Demonstration enterprise service single-page call Demonstration enterprise service single-page call Demonstration enterprise service single-page call Demonstration enterprise service single-page call Demonstration of a single page call to enterprise services Demonstration of a single page call to enterprise services Demonstration of a single page call to enterprise services Demonstration of a single page call to enterprise services Demonstration of a single page call to enterprise services Demonstration of a single page call to enterprise services Demonstration of a single page call to enterprise services Demonstration of a single page call to enterprise services Demo enterprise Service single page call demonstration Enterprise service single page call demonstration Enterprise service single page call demonstration Enterprise service single page call demonstration Enterprise service single page call demonstration Enterprise service single page call demonstration Enterprise service single page call demonstration ', 1, 28, 0, ' ', 0, 'Zerolone', 'Network', '', 99, '', '', '', 1, '/article//1006/21/2247453051.html', 0, 0, '', ' ', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(72, 0, 0, 0, 1277028648, ' sadfsadfsadfdas', '', '', 2, 30, 0, '', 0, '', '', '', 99, '', '', '', 1, '/article//1006/20 /1811205532.html', 1, 0, '东湖区', '10000', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL ),
(14, 0, 0, 0, 0, 'Silly sofa', '', 'Send antivirus', 1, 35, 0, '', 0, '', '', '' , 255, '', '/article_pic/0912/04/0844078459.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(15, 0, 0, 0, 0, 'Ahhhh', '', 'What is the antivirus sending', 1, 35, 0, ' ', 0, '', '', '', 255, '', '/article_pic/0912/04/0844164124.bmp', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(16, 0, 0, 0, 0, 'Do not do', '', '

Aston Flying

', 1, 35, 0, '', 0, '', '', '', 255, '', '/article_pic/0912/04/0844291726. jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(17, 0, 0, 0, 0, 'Cao Chaochao', '', '

Aston Flying etc

', 1, 35, 0, '', 0, '' , '', '', 255, '', '/article_pic/0912/04/0844416262.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(18, 0, 0, 0, 0, 'Da Da Da', '', '

Da Da Da

', 1, 35, 0, '', 0, '', '', '', 255, '', '/article_pic/0912/04/0844532108.jpg', '', 1 , NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(19, 0, 0 , 0, 0, 'Goose goose', '', '

Goose goose

', 1, 35, 0, '', 2, '', '', '', 255 , '', '/article_pic/0912/04/0845122279.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(20, 0, 0, 0, 0, 'peasy', '', '

over and over again

', 1, 35, 0, '', 46, '', '', '', 255, '', '/article_pic/0912/04/1431094003.jpg', '/article_pic/0912/04/1431094003.jpg' , 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(21, 0 , 0, 0, 0, '高高 hang', '', '

高高 hang

', 1, 34, 0, '', 2, '', '', '' , 255, '', '/article_pic/0912/04/0913295177.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(22, 0, 0, 0, 0, 'Environment 1', '', 'Spread', 1, 16, 0, '' , 22, '', '', '', 255, '', '/article_pic/0912/04/1401331809.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL , 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(23, 0, 0, 0, 0, 'Environment 12', '', 'Safei Where to sprinkle it', 1, 16, 0, '', 0, '', '', '', 255, '', '/article_pic/0912/04/1401463623.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(24, 0, 0, 0, 0, 'Environment 3', '', '

Aston Flying

', 1, 16, 0, '', 1, '', '', '', 255, '' , '/article_pic/0912/04/1402003098.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0 , 0, '', NULL),
(25, 0, 0, 0, 0, 'Environment 4', '', '

Ah extra full front outer

', 1 , 16, 0, '', 3, '', '', '', 255, '', '/article_pic/0912/04/1402126768.jpg', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(26, 0, 0, 0, 0, 'Asafa Satan's Law', '', '

Astephan Satan's Law

', 1, 36, 0, '', 0, '', '', '', 255, '', '/ article_pic/0912/04/1415452249.jpg', '/article_pic/0912/04/1415548027.jpg', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(27, 0, 0, 0, 0, 'Free trial', '', 'Manxiangzu Company has always firmly believed in the high-quality product first. We strive to contribute quality products to society and develop the Chinese animation market.In terms of business products, the company is currently one of the best animation suppliers for Tencent and the only game supplier for MSN China. It also cooperates with China Mobile, Shanghai Electric Power, Patriot, Samsung, ViewSonic, BenQ, GE, China Search, etc. We have cooperated with many influential business partners in China to develop and produce various market hot products including Tencent QQ Pet Show, Tencent QQ Show, MSN Games, etc.
In terms of original animation, the company has successively planned and developed high-quality animation series such as "Momo", "Xiaqiao Street", "Hami Paradise", "Luoluozhou", and "Moore Manor". Among them, "Momo" was piloted on Chongqing TV Children's Channel at the end of July 2008, and was broadcast on CCTV Children's Channel during prime time on July 9, 2009. Compared with similar domestic products, its outstanding quality and excellent market performance have attracted widespread attention in the industry and market.
In 2008, Manxiangzu was awarded the title of "Wacom Digital Art Authorized Classroom" by the world's top digital art equipment manufacturer "Wacom Company", and began to build a domestic animation elite training brand.
Chongqing Manxiangzu Culture Communication Co., Ltd. is a modern animation culture development, promotion, planning and production company that integrates original animation and entertainment product development, provides multimedia production, and uses television and Internet communication as platforms. In April 2008, it settled in the Chongqing Animation Base in the Northern New Area of ​​Chongqing High-tech Development Zone.
', 1, 28, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(28, 0, 0, 0, 0, '图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2', '', '

图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2图文调用2

', 1, 28, 0, '', 2, '', '', '', 255, '图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2图文调用文字2', '/upload/1006/15/1134514548.png', '', 1, '/article//1006/15/1134525311.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(29, 0, 0, 0, 1276572840, '图文新闻调用1图文新闻调用1图文新闻调用1图文新闻调用1图文新闻调用1', '', '

测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容

', 2, 28, 0, '', 6, '', '', '', 255, '测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容测试调用内容', '/upload/1006/15/1133493635.png', '', 1, '/article//1006/15/1134008735.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(30, 0, 0, 0, 0, '入学必读', '', '

入学必读入学必读入学必读入学必读入学必读入学必读

', 2, 28, 0, '', 1, '', '', '', 255, '', '', '', 1, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(31, 0, 0, 0, 0, '付款方式', '', '

付款方式付款方式付款方式付款方式付款方式

', 2, 28, 0, '', 1, '', '', '', 255, '', '', '', 1, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(32, 0, 0, 0, 0, '教学环境', '', '

教学环境教学环境教学环境教学环境教学环境教学环境教学环境教学环境

', 2, 28, 0, '', 1, '', '', '', 255, '', '', '', 1, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(33, 0, 0, 0, 0, '学习设施', '', '

学习设施学习设施学习设施学习设施学习设施学习设施学习设施学习设施学习设施学习设施

', 2, 28, 0, '', 1, '', '', '', 255, '', '', '', 1, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(34, 0, 0, 0, 0, '交通指南', '', '

交通指南交通指南交通指南交通指南交通指南交通指南交通指南交通指南交通指南

', 2, 28, 0, '', 2, '', '', '', 255, '', '', '', 1, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(35, 0, 0, 0, 1276572301, 'surrounding environment', '', '

surrounding environment surrounding environment surrounding environment surrounding environment surrounding environment

', 2, 28, 0, '', 2, '', '', '', 255, '', '', '', 1, '/article//1006/15/1125011128.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(36, 0, 0, 0, 1276571931, 'AllArticle display in mixed Chinese and English Review', '', '

Promotions Promotions Promotions Promotions Promotions Promotions Promotions Promotions

', 1, 28, 0, '111111111', 3, 'Panshi', 'China ', '', 1, '', '', '', 1, '/article//1006/15/1118525811.html', 1, 0, '', '', '', '', '' , 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(37, 0, 0, 0, 0, 'Introduction to university cooperation', '', 'University Introduction to cooperation. Introduction to cooperation. Introduction to cooperation. Introduction to cooperation. Introduction to cooperation. Introduction to cooperation. Introduction to cooperation. Introduction to cooperation. Introduction to cooperation. ', 1, 7, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL) ,
(38, 0, 0, 0, 0, 'school-enterprise cooperation model', '', 'school-enterprise cooperation model school-enterprise cooperation model school-enterprise cooperation model school-enterprise cooperation model school-enterprise cooperation model school-enterprise cooperation model School-enterprise cooperation model School-enterprise cooperation model', 1, 7, 0, '', 2, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL , NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(39, 0, 0, 0, 0, 'Success College Case', '', 'Successful university caseSuccessful university caseSuccessful university caseSuccessful university caseSuccessful university caseSuccessful university caseSuccessful university caseSuccessful university case', 1, 7, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(40, 0, 0, 0, 0, 'Free trial', '', '', 1, 5, 0, '/lyrics.php', 0, '', ' ', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(41, 0, 0, 0, 0, 'Preferential method', '', 'Preferential methodPreferential methodPreferential methodPreferential methodPreferential methodPreferential methodPreferential methodPreferential method' , 1, 5, 0, '', 0, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(42, 0, 0, 0, 0, 'Registration Payment', '', 'Registration Payment Registration Payment Registration Payment Registration Payment Registration Payment Registration Payment Registration Payment', 1, 5, 0, '', 4, '', '', '', 255, '', '', '', 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(84, 0, 0, 0, 1277559750, 'Test article test article test article test article test article test article test article test article test article test article test article test article test article', '', '

Test a simple article

rn

Test a simple article Test a simple article Test a simple article Test a simple article Test a simple article Test a simple article Test a simple article Test a simple article Test one A simple article to test A simple article to test A simple article to test

rn

rn

A simple article to test A simple article to test A simple Article test A simple article test A simple article test A simple article test A simple article test A simple article test A simple article test

rn

rn

A simple article to test a simple article to test a simple

rn

Article to test a simple article to test a simple article to test a simple article Article test A simple article test A simple article test A simple article test 1111111111 A simple article

rn

Test a simple article Test a simple 222222222222222222 Article test one A simple article to test A simple article to test A simple article to test A simple article to test A simple article

rn

rn

It is a simple article 33333333.

', 1, 39, 0, '', 27, 'Zerolone', 'Us', 'aaaa', 99, '', '', '', 0, '/article//1006262142309349.html', 1, 0, '', '', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(48, 0, 0, 0, 1277132550, '测试3', '', '

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

\r\n

测试3

', 2, 28, 0, 'aaa.php', 1, '', '', '', 255, '测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3测试3', '', '', 1, '/article//1006/21/2302306528.html', 1, 0, '', '', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(49, 0, 0, 0, 1277132514, '常见问题', '', '

常见问题常见问题常见问题常常见问题常见问题常常见问题常见问题常见问题常见问

\r\n

题常见问题常见问题常见问题常见问题常见问题常见问题

', 2, 1, 0, '', 11, '', '', '', 255, '', '', '', 1, '/article//1006/21/2301543267.html', 1, 0, '', '', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(50, 0, 0, 0, 1277132501, '大类2', '', '大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2大类2', 2, 1, 0, '', 6, '', '', '', 255, '', '', '', 1, '/article//1006/21/2301418250.html', 1, 0, '', '', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(51, 0, 0, 0, 1277132482, 'Category 1', '', 'Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major category 1 major Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1 Category 1', 2 , 1, 0, '', 18, '', '', '', 255, '', '', '', 1, '/article//1006/21/2301226130.html', 1, 0, '', '', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(53, 0, 0, 0 , 1276570387, 'Students must readStudents must readStudents must readStudents must readStudents must readStudents must readStudents must read', '', 'Students must readStudents must readStudents must readStudents< ;/FONT>Must read for studentsMust readMust read for students', 2, 28, 0, '', 0, '', '', '', 2, '', '' , '', 1, '/article//1006/15/1049558883.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(75, 0, 0, 0, 1277041879, 'Picture News', '', 'Ah, the anti-virus and blockade fees are assasafasa', 2, 38, 0, '', 0, '', '', '', 99, '', '/upload/1006/20/2151417687.jpg', '', 1, '/article//1006/20/2151438545. html', 1, 0, '', '', '', '', '', 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
( 57, 0, 0, 0, 1276567102, '1. Preparations before buying a new house', '', '

1. Preparations before buying a new house

rn

A>

', 2, 38, 0, '', 12, 'Zerolone', 'China', '', 1, '', '', '', 1, '/article//1006 /15/0958238672.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
( 58, 1, 10, 0, 1276091400, 'Can comment-review-display 10 tests', '', ' ', 2, 39, 0, '', 3, 'Rock', 'China', '', 255, '', '', '', 1, '/article//1006/09/2156568810.html' , 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(59, 0, 0, 0 , 1276092641, 'Cannot comment-test', '', 'Can comment-not review-display 5 tests that can comment-not review-display 5 tests that can comment-not review-display 5 tests that can comment-not review- Showing 5 tests', 2, 39, 0, '', 0, '', '', '', 255, '', '', '', 1, '/article//1006/09/2211306069. html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, '', NULL),
(60, 1, 3 , 1, 1276092641, 'Can comment - no review - display 3 tests', '', 'Can comment - no review - display 3 tests Can comment - no review - display 3 tests Can comment - no review - display 3 Tests can be commented - no review - 3 tests can be commented - no review - 3 tests can be commented - no review - 3 tests can be displayed ', 2, 39, 0, '', 2, '', '' , '', 255, '', '', '', 1, '/article//1006/09/2211373089.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0 , 0, 0, 0, 0, 0, 0, '', NULL),
(61, 1, 11, 1, 1276567135, '2. Select an area and choose a house', '', '2. Select the area and house', 2, 38, 0, '', 0, 'Rock', ' China', '', 2, '', '', '', 1, '/article//1006/15/0959101794.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL , 0, 0, 0, 0, 0, 0, 0, '', NULL),
(62, 1, 3, 1, 1276567135, '3. Sign the house purchase contract', '', '3. Sign the house purchase contract ', 2, 38, 0, '', 2, '', '' , '', 3, '', '', '', 1, '/article//1006/15/0959241646.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0 , 0, 0, 0, 0, 0, 0, '', NULL),
(63, 0, 0, 0, 1276567135, '4. Payment', '', '4. Payment', 2, 38, 0, '', 0, '', '', '', 4, '', '', '' , 1, '/article//1006/15/1003181891.html', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL,