iapt-platform
/
mint
kopia lustrzana https://github.com/iapt-platform/mint.git


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
							<!DOCTYPE html>
<html>
<head>
</head>
<body>
<h2>Change DB</h2>
<?php
include "./_pdo.php";
include "./config.php";
include "../app/public.inc";

$dbfile=$_GET["file"];
$from=$_GET["from"];
$to=$_GET["to"];
echo "<h2>$from</h2>";

{
	$db_file = "../appdata/palicanon/translate/$dbfile.db3";
	PDO_Connect("sqlite:$db_file");
	$query="select * from album where 1";
	$Fetch = PDO_FetchAll($query);
	$iFetch=count($Fetch);
	echo "找到album记录 $iFetch<br/>";
	if($iFetch>0){
		for($i=0;$i<$iFetch;$i++){
			$album_id=$Fetch[$i]["id"];
			$book=$Fetch[$i]["book"];
			$guid=$Fetch[$i]["guid"];
			$title=$Fetch[$i]["title"];
			$file=$Fetch[$i]["file"];
			$cover=$Fetch[$i]["cover"];
			$language=$Fetch[$i]["language"];
			$author=$Fetch[$i]["author"];
			$target=$Fetch[$i]["target"];
			$summary=$Fetch[$i]["summary"];
			$publish_time=$Fetch[$i]["publish_time"];
			$update_time=$Fetch[$i]["update_time"];
			$edition=$Fetch[$i]["edition"];
			$edition1=$Fetch[$i]["edition1"];
			$type=$Fetch[$i]["type"];

			$db_file = _FILE_DB_PALITEXT_;
			PDO_Connect("sqlite:$db_file");
	
			$query="select * from pali_text where book = '{$book}' and level > 0 and level < 8";
			$title_data = PDO_FetchAll($query);
			echo  "par count:".count($title_data)."<br>";
			$par_list="";
			foreach($title_data as $oneTitle){
				$par_list .= " , ".$oneTitle["paragraph"]." ";
			}
			$par_list = substr($par_list,3);
			
			$db_file = "../appdata/palicanon/translate/$dbfile.db3";
			PDO_Connect("sqlite:$db_file");
			$query="select * from data where album='$album_id' and paragraph in ($par_list)";
			echo $query."<br>";
			$paragraph_list = PDO_FetchAll($query);
			
			
			
			$db_file =_FILE_DB_RESRES_INDEX_;
			PDO_Connect("sqlite:$db_file");			
			$query="select * from album where guid = '$guid'";
			$search_album = PDO_FetchAll($query);
			if(count($search_album)==0){
				$query="INSERT INTO album (id, 
				guid,	
				title,
				file,
				cover,
				language,
				author,
				target,
				summary,
				publish_time,
				update_time,
				edition,
				edition1,
				type) VALUES (NULL,
				'$guid',
				'".$title."', 
				'$file',
				'',
				'0',
				'$author',
				'',
				'',
				'1',
				'".time()."',
				'1',
				'$edition1',
				'1')";
				
				$stmt = @PDO_Execute($query);
				if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
					$error = PDO_ErrorInfo();
					print_r($error[2]);
					break;
				}
					//获取刚刚插入的索引号
				$album_index=$PDO->lastInsertId();
			}
			else{
				$album_index=$search_album[0]["id"];
				$query="UPDATE album SET title = '$title' ,
				                         file = '$file' ,
										 cover = '$cover' ,
										 language = '$language' ,
										 author = '$author' ,
										 target = '$target' ,
										 summary = '$summary' ,
										 publish_time = '$publish_time' ,
										 update_time = '$update_time' ,
										 edition = '$edition' ,
										 edition1 = '$edition1' ,
										 type = '$type' 
				WHERE guid='$guid' ";
				$stmt = @PDO_Execute($query);
				if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
					$error = PDO_ErrorInfo();
					print_r($error[2]);
					break;
				}
			}
			
			echo "开始更新索引 ".count($paragraph_list)."<br />";
			//开始更新索引
			for($iPar=0;$iPar<count($paragraph_list);$iPar++){
				$oneTitle=$paragraph_list[$iPar];
				$query="select * from 'index' where album = '$album_index' and book='".$book."' and paragraph='".$paragraph_list[$iPar]["paragraph"]."'";
				$search_title = PDO_FetchAll($query);
				$title_en=$oneTitle["text"];

				//找到已有的记录  更新
				if(count($search_title)!=0){
					$query="UPDATE 'index' SET title = '".$oneTitle["text"]."' ,
					                         title_en = '".$title_en."' ,
											 language = '1' ,
											 type = '$type',
											 editor = '1' ,
											 share = '1' ,
											 update_time = '".time()."'
					WHERE id='".$search_title[0]["id"]."' ";
					$stmt = @PDO_Execute($query);
					if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
						$error = PDO_ErrorInfo();
						print_r($error[2]);
						break;
					}
						
				}
				else{/*未找到 插入*/
					if(substr($book,0,1)=="b"){
						$book=substr($book,1);
					}
					$query="INSERT INTO 'index' (id, 
					book,
					paragraph,
					title,
					title_en,
					level,
					type,
					language,
					author,
					editor,
					share,
					edition,
					album,
					update_time) 
					VALUES (NULL,
					   '".$book."',
				       '".$oneTitle["paragraph"]."', 
				       '".$oneTitle["text"]."',
					   '".$title_en."',
					   '".$title_data[$iPar]["level"]."',
					   '$type',
					   '$language',
					   '1',
					   '1',
					   '1',
					   '1',
					   '$album_index',
					   '".time()."')";
				
					$stmt = @PDO_Execute($query);
					if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
						$error = PDO_ErrorInfo();
						print_r($error[2]);
						break;
					}
				}
			}
						
		}
	}
	
	

	echo "insert  ok<br>";	
	

}
if($from>=$to){
	echo "<h2>齐活！功德无量！all done!</h2>";
}
else{
	echo "<script>";
	echo "window.location.assign(\"update_translate.php?from=".($from+1)."&to=".$to."\")";
	echo "</script>";
	echo "正在载入:".($from+1);
}
?>