<?
set_time_limit(0);
include("../../inc/config.inc.php");
include("./_conf.php");

$svdt=floor($svdt);
$limitnum=floor($limitnum);
if ($limitnum<10) {
	$limitnum=10;
}
function local_implode($a) {
	@reset($a);
	while (list($k,$v)=each($a)) {
		$retVal[$k]=$v;
	}
	//printr($retVal);
	return serialize($retVal);
}
	///chkcompatible cli
		//µéͧä»á¡éä¢ä¿Åì addnewDBBook.php ãËéÍѾഷ¿ÔÅ´ì¹Õé´éÇÂ
		$s=tmq("show columns from media where Field ='lastdt' ");
		if (tmq_num_rows($s)==0) {
			tmq("ALTER TABLE  media ADD  lastdt DOUBLE NOT NULL ;");
		}
		//$s=tmq_fetch_array($s);printr($s);
	///chkcompatible end

if ($cmd=="clearlasttime" && $svdt==0) {
	tmq("update media set lastdt='0';");
	echo "clearlasttime done.";
	die;
}
if ($cmd=="generalfetch" && $svdt!=0) {
	$truetime_diff=time()-$svdt;
	//echo $truetime_diff;
	$truetime=time()+$truetime_diff;
	$index=explode(";",$data);
	//printr($index);
	$sql="";
	@reset($index);
	while (list($k,$v)=each($index)) {
			$sql.=",trim($v),':--:' ";
	}
	$sql=trim($sql,',');
	$sql=trim($sql,',');

	$now=time();
	$sql="select  ID,trim(concat($sql)) as hashes,$now as dt from media where lastdt>'$truetime' or lastdt=0 limit $limitnum";
	$s=tmq($sql);
	$c=tmq_num_rows($s);
	while ($r=tmq_fetch_array($s)) {
		$MARCDATA=tmq("select * from media where ID='$r[ID]' ");
		$MARCDATA=tmq_fetch_array($MARCDATA);
		//$MARCDATA=arr_filter_remnull($MARCDATA);
		$MARCDATA=local_implode($MARCDATA,"[recsplit]");
		unset($r[0]);
		unset($r[1]);
		unset($r[2]);
		unset($r[3]);
		$r[hashes]=base64_encode(trim($r[hashes]));
		//printr($r);
		$r[MARCDATA]=(base64_encode($MARCDATA));
		echo serialize($r);
		echo "$newline";
		tmq("update media set lastdt='$truetime' where ID='$r[ID]' ");
	}
	$last=Array();
	$last[counted]=$c;
	echo serialize($last);
	die;
}
if ($cmd=="generalfetch" && $svdt!=0) {

}
?>