/xoops_trust_path/modules/pico/class/PicoAutoRegisterWraps.class.php

<?php



class PicoAutoRegisterWraps {



var $mydirname = '' ;

var $config = array() ;

var $wrap_base = '' ;





// constructor

function PicoAutoRegisterWraps( $mydirname , $config )

{

	$this->mydirname = $mydirname ;

	$this->config = $config ;

	$this->wrap_base = XOOPS_TRUST_PATH._MD_PICO_WRAPBASE.'/'.$mydirname ;

}





// public

function updateContent( $content_id , $vpath )

{

	$db =& Database::getInstance() ;

	$content_id = intval( $content_id ) ;

	$file_info = $this->getFileInfo( $vpath ) ;



	// check the file is newer than the contents

	$sql = "SELECT modified_time FROM ".$db->prefix($this->mydirname."_contents")." WHERE content_id=$content_id" ;

	list( $modified_time ) = $db->fetchRow( $db->query( $sql ) ) ;



	if( $modified_time < $file_info['mtime'] ) {

		// make backup

		require_once dirname(dirname(__FILE__)).'/include/transact_functions.php' ;

		pico_transact_backupcontent( $this->mydirname , $content_id ) ;



		// update the content

		$set4subject = $file_info['subject'] ? "`subject`='".mysql_real_escape_string($file_info['subject'])."'," : '' ;

		$sql = "UPDATE ".$db->prefix($this->mydirname."_contents")." SET $set4subject `modified_time`={$file_info['mtime']},body_cached='',for_search='',`last_cached_time`=0,modifier_uid=0,modifier_ip='' WHERE content_id=$content_id" ;

		$db->queryF( $sql ) ;

		return $db->getAffectedRows() ;

	}

	return 0 ;

}





// protected

function getRegisteringWeight( $cat_id , $vpath )

{

	$db =& Database::getInstance() ;



	list( $weight ) = $db->fetchRow( $db->query( "SELECT MAX(weight) FROM ".$db->prefix($this->mydirname."_contents")." WHERE `cat_id`=$cat_id" ) ) ;



	return $weight + 1 ;

}





// protected

function getInsertSQL( $cat_id , $vpath )

{

	$weight = $this->getRegisteringWeight( $cat_id , $vpath ) ;

	$file_info = $this->getFileInfo( $vpath ) ;



	return "SET `cat_id`=$cat_id,`vpath`='".mysql_real_escape_string($vpath)."',`subject`='".mysql_real_escape_string($file_info['subject_alt'])."',`body`='".mysql_real_escape_string($file_info['body'])."',`created_time`={$file_info['mtime']},`modified_time`={$file_info['mtime']},expiring_time=0x7fffffff,poster_uid=0,modifier_uid=0,poster_ip='',modifier_ip='',use_cache=0,weight=$weight,filters='wraps',show_in_navi=1,show_in_menu=1,allow_comment=0,visible=1,approval=1,htmlheader='',htmlheader_waiting='',body_waiting='',body_cached='',tags='',extra_fields='',for_search=''" ;

}





// public

function registerContent( $cat_id , $vpath )

{

	$db =& Database::getInstance() ;



	$cat_id = intval( $cat_id ) ;



	// insert a new record into the category

	$sql = "INSERT INTO ".$db->prefix($this->mydirname."_contents")." ".$this->getInsertSQL( $cat_id , $vpath ) ;



	// dare to ignore duplicate key error

	// if( ! $db->queryF( $sql ) ) die( _MD_PICO_ERR_SQL.__LINE__.__CLASS__ ) ;

	if( $db->queryF( $sql ) ) {

		$content_id = $db->getInsertId() ;



		// rebuild category tree

		require_once dirname(dirname(__FILE__)).'/include/transact_functions.php' ;

		pico_sync_cattree( $this->mydirname ) ;



		return $content_id ;

	} else {

		return false ;

	}

}





// protected

function removeContent( $content_id )

{

	// delete transaction

	require_once dirname(dirname(__FILE__)).'/include/transact_functions.php' ;

	pico_delete_content( $this->mydirname , $content_id ) ;



}





// public

function syncCatvpath( $cat_id , $cat_vpath , $wrap_dir )

{

	$content_handler = new PicoContentHandler( $this->mydirname ) ;

	$registered_vpaths = array_flip( $content_handler->getAutoRegisteredContents( $cat_id ) ) ;

	$removal_vpaths = $registered_vpaths ;



	$affected_rows = 0 ;



	$dh = opendir( $wrap_dir ) ;

	$additional_vpaths = array() ;

	while( ( $file = readdir( $dh ) ) !== false ) {

		if( preg_match( _MD_PICO_AUTOREGIST4PREGEX , $file ) ) {

			$vpath = $cat_vpath . '/' . $file ;

			if( isset( $removal_vpaths[ $vpath ] ) ) {

				// already registered

				unset( $removal_vpaths[ $vpath ] ) ;

				$affected_rows += $this->updateContent( $registered_vpaths[ $vpath ] , $vpath ) ;

			} else {

				// to be registered

				$additional_vpaths[ $vpath ] = 0 ;

			}

		}

	}

	closedir( $dh ) ;



	// remove

	foreach( $removal_vpaths as $vpath => $content_id ) {

		$this->removeContent( $content_id ) ;

		$affected_rows ++ ;

	}



	// register

	foreach( $additional_vpaths as $vpath => $content_id ) {

		if( $this->registerContent( $cat_id , $vpath ) ) {

			$affected_rows ++ ;

		}

	}



	return $affected_rows ;

}





// public

function registerByCatvpath( $category_row )

{

	$cat_id = intval( $category_row['cat_id'] ) ;

	$cat_vpath = str_replace( '..' , '' , $category_row['cat_vpath'] ) ;

	$wrap_dir = $this->wrap_base . $cat_vpath ;

	$affected_rows = 0 ;

	// trigger: mtime of the directory

	if( is_dir( $wrap_dir ) && filemtime( $wrap_dir ) > $category_row['cat_vpath_mtime'] ) {

		// do sync between the_category/contents and cat_vpath/files

		$affected_rows = $this->syncCatvpath( $cat_id , $cat_vpath , $wrap_dir ) ;



		// touch `cat_vpath_mtime`

		$categoryHandler = new PicoCategoryHandler( $this->mydirname ) ;

		$categoryHandler->touchVpathMtime( $cat_id ) ;

	}



	return $affected_rows ;

}





// protected

function getFileInfo( $vpath )

{

	$wrap_full_path = $this->wrap_base . $vpath ;



	ob_start() ;

	include $wrap_full_path ;

	$full_content = pico_convert_encoding_to_ie( ob_get_contents() ) ;

	ob_end_clean() ;



	// file name

	$filename = substr( strrchr( $wrap_full_path , '/' ) , 1 ) ;



	// parse full_content (get subject, body etc.)

	if( preg_match( '/\<title\>([^<>]+)\<\/title\>/is' , $full_content , $regs ) ) {

		$subject = pico_common_unhtmlspecialchars( $regs[1] ) ;

	} else {

		$subject = false ;

	}

	if( preg_match( '/\<body[^<>]*\>(.*)\<\/body\>/is' , $full_content , $regs ) ) {

		$body = $regs[1] ;

	} else {

		$body = $full_content ;

	}



	return array(

		'mtime' => intval( @filemtime( $wrap_full_path ) ) ,

		'subject' => $subject ,

		'subject_alt' => $subject ? $subject : $filename ,

		'filename' => $filename ,

		'body' => $body ,

	) ;

}





}



?>