Change DB
$from";
{
$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
";
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)."
";
$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."
";
$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)."
";
//开始更新索引
for($iPar=0;$iParerrorCode() != 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
";
}
if($from>=$to){
echo "齐活！功德无量！all done!
";
}
else{
echo "";
echo "正在载入:".($from+1);
}
?>