<?php
//获取书的单词信息
require_once "../path.php";
require_once "../public/_pdo.php";

$get_book=$_GET["book"];
$get_par_begin=$_GET["begin"];
$get_par_end=$_GET["end"];

$db_file = _DIR_PALICANON_TEMPLET_."/p".$get_book."_tpl.db3";
	
		//open database
	PDO_Connect("sqlite:$db_file");
	if($get_par_end==-1 || ($get_par_end-$get_par_begin)>500){
		echo "0,0,0,0";
		exit;
	}
	else{
		$query1="SELECT count(*) FROM \"main\" WHERE paragraph BETWEEN $get_par_begin AND $get_par_end";
		$query2="select count(*) from (SELECT count() FROM \"main\" WHERE (paragraph BETWEEN $get_par_begin AND $get_par_end ) group by real ) T";

		$query3="SELECT sum(length(real)) FROM \"main\" WHERE paragraph BETWEEN $get_par_begin AND $get_par_end";
		$query4="select sum(length(real)) from (SELECT count(),real FROM \"main\" WHERE (paragraph BETWEEN $get_par_begin AND $get_par_end ) group by real ) T";
		
		$allword=PDO_FetchOne($query1);
		$allword_token=PDO_FetchOne($query2);
		$allwordLen=PDO_FetchOne($query3);
		$allword_tokenLen=PDO_FetchOne($query4);

		echo $allword.",".$allword_token.",".$allwordLen.",".$allword_tokenLen;	
	}

	

?>