iapt-platform
/
mint
şunun yansıması https://github.com/iapt-platform/mint.git


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
							<?php
/*
get xml doc from db
*/
require_once "../path.php";
require_once "../public/_pdo.php";
require_once "../public/function.php";

if(isset($_POST["book"])){
	$book=$_POST["book"];
}
else{
	echo "error: no book id";
	exit;
}

if(isset($_POST["para"])){
	$paralist=explode(",",$_POST["para"]);
}
else{
	exit;
}

if(isset($_POST["channal"])){
	$channal=$_POST["channal"];
}
else{
	exit;
}

	echo '<?xml version="1.0" encoding="UTF-8"?>';
	echo "<set>\n";
	echo "    <head>\n";
	echo "        <type>pcdsset</type>\n";
	echo "        <mode>package</mode>\n";
	echo "        <ver>1</ver>\n";
	echo "        <toc></toc>\n";
	echo "        <style></style>\n";
	echo "        <title>{$book}-{$para}</title>\n";
	echo "    </head>\n";
	echo "\n<dict></dict>\n";
	echo "<message></message>\n";
	echo "<body>\n";
	
	$dh_wbw = new PDO("sqlite:"._FILE_DB_USER_WBW_, "", "",array(PDO::ATTR_PERSISTENT=>true));
    $dh_wbw->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
	
	foreach($paralist as $para){

				$albumId = UUID::v4();
				$query="SELECT * FROM wbw_block WHERE channal=? AND book = ? AND paragraph = ?  ";
				$stmt = $dh_wbw->prepare($query);
				$stmt->execute(array($channal,$book,$para));
				$FetchBlock = $stmt->fetch(PDO::FETCH_ASSOC);
				if($FetchBlock){
					echo "\n<block>";
					echo "<info>\n";
					
					echo "<type>wbw</type>";
					echo "<book>{$book}</book>";
					echo "<paragraph>{$para}</paragraph>";
					echo "<level>100</level>";
					echo "<title></title>";
					echo "<album_id>{$block->channal}</album_id>";
					echo "<album_guid>{$block->channal}</album_guid>";
					echo "<author>{$FetchBlock["owner"]}</author>";
					echo "<language>{$FetchBlock["lang"]}</language>";
					echo "<version>1</version>";
					echo "<edition>1</edition>";
					echo "<id>{$FetchBlock["id"]}</id>";
					echo "</info>\n";		

					echo "<data>\n";
					$block_id = $FetchBlock["id"];
					$query="select * from wbw where block_id= ? ";
					$stmt = $dh_wbw->prepare($query);
					$stmt->execute(array($block_id));
					$wbw_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
					foreach($wbw_data as $word){
						echo $word["data"];	
						echo "\r\n";	
					}
					echo "</data>";
					echo "</block>\n";
				}

	}
				
	echo "</body>\n";
	echo "</set>";


?>