<?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;
}
?>