"; echo "

创建新的专辑

"; echo ""; echo ""; } switch ($step) { case 1: if (isset($_GET["filename"])) { $db_file = _FILE_DB_RESRES_INDEX_; PDO_Connect("$db_file"); $album_id = $_GET["id"]; $filename = $_GET["filename"]; $book = $_GET["book"]; $album_type = $_GET["type"]; $album_author = $_GET["author"]; $album_title = $_GET["title"]; $album_lang = $_GET["lang"]; $query = "select * from 'album' where id='{$album_id}'"; $Fetch = PDO_FetchAll($query); $iFetch = count($Fetch); if ($iFetch == 0) { //没有找到专辑guid echo "专辑不存在。请指定专辑后再发布。"; } else //找到专辑guid { echo "

找到专辑

"; if ($Fetch[0]["owner"] == $UID) { //这是自己的专辑 $thisfile = basename(__FILE__); echo "正在发布"; echo ""; } else { echo "

此书属于他人。您没有发布权限

"; } } } else { echo "no file name"; exit; } break; case 3: //选择专辑 $db_file = _FILE_DB_RESRES_INDEX_; PDO_Connect("$db_file"); $album_type = $_GET["album_type"]; $book = $_GET["book"]; $filename = $_GET["filename"]; $query = "select * from 'album' where book='{$book}' and type='{$type[$album_type]}' and owner='{$uid}'"; $Fetch = PDO_FetchAll($query); $iFetch = count($Fetch); if ($iFetch == 0) { //没有找到专辑guid echo "没有找到专辑"; } else { echo "

发布到

"; echo "

{$oneAlbum["title"]}
"; echo "
"; echo "author:{$oneAlbum["author"]} "; echo "Edition:{$oneAlbum["edition"]} "; echo "Update:{$oneAlbum["update_time"]}"; echo "
"; echo "

"; $album_lang = "en"; $album_author = $nickname; $album_edition = ""; $album_title = $Fetch[0]["title"]; $album_id = UUID(); echo "

新建专辑

"; } break; case 4: //发布 echo "step 4 正在发布数据"; $album_id = $_GET["album_id"]; $album_type = $_GET["album_type"]; $book = $_GET["book"]; $filename = $_GET["filename"]; echo "album_type:$album_type"; switch ($album_type) { case "wbw": $dbFileName = "../appdata/palicanon/wbw/p" . $book . "_wbw.db3"; PDO_Connect("$dbFileName"); $filename = $_GET["filename"]; $dir = $dir_user_base . $userid . $dir_mydocument; $xml = simplexml_load_file($dir . $filename); $sDataTableName = "p{$book}_wbw_data"; $sInfoTableName = "p{$book}_wbw_info"; $paraList = "("; $dataBlock = $xml->xpath('//block'); foreach ($dataBlock as $block) { if ($block->info->album_id == $album_id) { $paraList .= "'" . $block->info->paragraph . "',"; } } $paraList = mb_substr($paraList, 0, -1, "UTF-8"); $paraList .= ")"; echo "paraList:$paraList"; // 提交更改删除数据表内容 $query = "DELETE FROM '{$sDataTableName}' WHERE album_id='{$album_id}' AND paragraph in {$paraList}"; $stmt = @PDO_Execute($query); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo "delete info table recorders.
"; } // 提交更改删除信息表内容 $query = "DELETE FROM '{$sInfoTableName}' WHERE album_id='{$album_id}' AND paragraph in {$paraList}"; $stmt = @PDO_Execute($query); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo "delete data table recorders.
"; } // 更新infomation表开始一个事务，关闭自动提交 $PDO->beginTransaction(); $query = "INSERT INTO '{$sInfoTableName}' ('id', 'album_id', 'paragraph', 'level', 'language', 'author', 'editor', 'version', 'edition', 'update_time' ) VALUES (NULL,?,?,?,?,?,?,?,?,?)"; $stmt = $PDO->prepare($query); $count = 0; $arrToc = array(); $dataBlock = $xml->xpath('//block'); foreach ($dataBlock as $block) { if ($block->info->album_id == $album_id) { $newData = array( $album_id, $block->info->paragraph, $block->info->level, $sLang["{$block->info->language}"], $block->info->author, $block->info->editor, $block->info->version, $block->info->edition, time(), ); $stmt->execute($newData); $count++; } } // 提交更改 $PDO->commit(); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo " info 表发布成功。提交 {$count} 条数据。
"; } $query = "select id from '{$sInfoTableName}' WHERE album_id='{$album_id}' AND paragraph in {$paraList}"; $arrInfoId = PDO_FetchAll($query); // 开始一个事务，关闭自动提交 $PDO->beginTransaction(); $query = "INSERT INTO '{$sDataTableName}' ('id', 'info_id', 'album_id', 'paragraph', 'sn', 'style', 'enter', 'word', 'real', 'type', 'gramma', 'mean', 'note', 'part', 'partmean' ) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; $stmt = $PDO->prepare($query); $count = 0; $iIndex = 0; $arrToc = array(); $dataBlock = $xml->xpath('//block'); foreach ($dataBlock as $block) { if ($block->info->album_id == $album_id) { $paraText = ""; $toc = ""; foreach ($block->data->children() as $word) { if ($block->info->level > 0 && $block->info->level < 8) { $toc .= $word->pali; } $wordid = str_getcsv($word->id, "-"); if (count($wordid) >= 3) { $sn = $wordid[2]; } else { $sn = 0; } $newData = array($arrInfoId[$iIndex]["id"], $album_id, $block->info->paragraph, $sn, $word->style, $word->enter, $word->pali, $word->real, $word->type, $word->gramma, $word->mean, $word->note, $word->org, $word->om, ); $stmt->execute($newData); $count++; } if ($block->info->level > 0 && $block->info->level < 8) { array_push($arrToc, array("book" => $block->info->book, "para" => $block->info->paragraph, "album_id" => $block->info->album_id, "title" => $toc, "level" => $block->info->level, "author" => $block->info->author, "editor" => $block->info->editor, "edition" => $block->info->edition, "lang" => $block->info->language, "type" => $block->info->type, )); } $iIndex++; } } // 提交更改 $PDO->commit(); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo " data 发布成功。提交 {$count} 条数据。
"; } //更新索引表 $db_file = _FILE_DB_RESRES_INDEX_; PDO_Connect("$db_file"); echo "开始更新索引 ", count($arrToc), "
"; //开始更新索引 foreach ($arrToc as $oneTitle) { $query = "select * from 'index' where album = '$album_id' and book='" . $oneTitle["book"] . "' and paragraph='" . $oneTitle["para"] . "'"; $search_title = PDO_FetchAll($query); $title_en = pali2english($oneTitle["title"]); //找到已有的记录更新 if (count($search_title) != 0) { $sCurrLang = $oneTitle["lang"]; $query = "UPDATE 'index' SET title = '{$oneTitle["title"]}' , title_en = '{$title_en}', author = '{$oneTitle["author"]}' , editor = '{$oneTitle["editor"]}' , 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 { echo "更新索引表成功"; } } else { /*未找到插入*/ $currType = $oneTitle["type"]; $currLang = $oneTitle["lang"]; $icurrType = $type["{$currType}"]; $icurrLang = $sLang["{$currLang}"]; echo "type:$currType lang:$currLang
"; $book = $oneTitle["book"]; 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, create_time, update_time) VALUES (NULL, '{$book}', '{$oneTitle["para"]}', '{$oneTitle["title"]}', '{$title_en}', '{$oneTitle["level"]}', '{$icurrType}', '{$icurrLang}', '{$oneTitle["author"]}', '{$oneTitle["editor"]}', '1', '{$oneTitle["edition"]}', '{$album_id}', '" . time() . "', '" . time() . "')"; $stmt = @PDO_Execute($query); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); print_r($error[2]); } else { echo "新建索引记录成功"; } } } break; case "translate": $dbFileName = "../appdata/palicanon/" . $album_type . "/p" . $book . "_" . $album_type . ".db3"; PDO_Connect("$dbFileName"); $filename = $_GET["filename"]; $dir = $dir_user_base . $userid . $dir_mydocument; $xml = simplexml_load_file($dir . $filename); $sDataTableName = "p{$book}_translate_data"; $sInfoTableName = "p{$book}_translate_info"; $paraList = "("; $dataBlock = $xml->xpath('//block'); foreach ($dataBlock as $block) { if ($block->info->album_id == $album_id) { $paraList .= "'" . $block->info->paragraph . "',"; } } $paraList = mb_substr($paraList, 0, -1, "UTF-8"); $paraList .= ")"; echo "paraList:$paraList"; // 提交更改删除数据表内容 $query = "DELETE FROM '{$sDataTableName}' WHERE album_id='{$album_id}' AND paragraph in {$paraList}"; $stmt = @PDO_Execute($query); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo "delete recorders."; } // 提交更改删除信息表内容 $query = "DELETE FROM '{$sInfoTableName}' WHERE album_id='{$album_id}' AND paragraph in {$paraList}"; $stmt = @PDO_Execute($query); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo "delete recorders."; } // 更新infomation表开始一个事务，关闭自动提交 $PDO->beginTransaction(); $query = "INSERT INTO '{$sInfoTableName}' ('id', 'album_id', 'paragraph', 'level', 'language', 'author', 'editor', 'version', 'edition', 'update_time' ) VALUES (NULL,?,?,?,?,?,?,?,?,?)"; $stmt = $PDO->prepare($query); $count = 0; $arrToc = array(); $dataBlock = $xml->xpath('//block'); foreach ($dataBlock as $block) { if ($block->info->album_id == $album_id) { $newData = array( $album_id, $block->info->paragraph, $block->info->level, $sLang["{$block->info->language}"], $block->info->author, $block->info->editor, $block->info->version, $block->info->edition, time(), ); $stmt->execute($newData); $count++; } } // 提交更改 $PDO->commit(); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo " info 表发布成功。提交 {$count} 条数据。
"; } $query = "select id from '{$sInfoTableName}' WHERE album_id='{$album_id}' AND paragraph in {$paraList}"; $arrInfoId = PDO_FetchAll($query); // 开始一个事务，关闭自动提交 $PDO->beginTransaction(); $query = "INSERT INTO '{$sDataTableName}' ('id', 'info_id', 'album_id', 'paragraph', 'begin', 'end', 'text' ) VALUES (NULL,?,?,?,?,?,?)"; $stmt = $PDO->prepare($query); $count = 0; $iIndex = 0; $arrToc = array(); $dataBlock = $xml->xpath('//block'); foreach ($dataBlock as $block) { if ($block->info->album_id == $album_id) { $paraText = ""; $toc = ""; foreach ($block->data->children() as $sen) { if (isset($sen->begin)) { $sent_begin = $sen->begin; } else { $sent_begin = ""; } if (isset($sen->end)) { $sent_end = $sen->end; } else { $sent_end = ""; } if (isset($sen->text)) { $paraText = $sen->text; if ($block->info->level > 0 && $block->info->level < 8) { $toc .= $sen->text; } } $newData = array($arrInfoId[$iIndex]["id"], $album_id, $block->info->paragraph, $sent_begin, $sent_end, $paraText, ); $stmt->execute($newData); $count++; } if ($block->info->level > 0 && $block->info->level < 8) { array_push($arrToc, array("book" => $block->info->book, "para" => $block->info->paragraph, "album_id" => $block->info->album_id, "title" => $toc, "level" => $block->info->level, "author" => $block->info->author, "editor" => $block->info->editor, "edition" => $block->info->edition, "lang" => $block->info->language, "type" => $block->info->type, )); } $iIndex++; } } // 提交更改 $PDO->commit(); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo " data 发布成功。提交 {$count} 条数据。
"; } //更新索引表 $db_file = _FILE_DB_RESRES_INDEX_; PDO_Connect("$db_file"); echo "开始更新索引 ", count($arrToc), "
"; //开始更新索引 foreach ($arrToc as $oneTitle) { $query = "select * from 'index' where album = '$album_id' and book='" . $oneTitle["book"] . "' and paragraph='" . $oneTitle["para"] . "'"; $search_title = PDO_FetchAll($query); $title_en = pali2english($oneTitle["title"]); //找到已有的记录更新 if (count($search_title) != 0) { $sCurrLang = $oneTitle["lang"]; $query = "UPDATE 'index' SET title = '{$oneTitle["title"]}' , title_en = '{$title_en}', author = '{$oneTitle["author"]}' , editor = '{$oneTitle["editor"]}' , 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 { echo "更新索引表成功"; } } else { /*未找到插入*/ $currType = $oneTitle["type"]; $currLang = $oneTitle["lang"]; echo "type:$currType lang:$currLang
"; $book = $oneTitle["book"]; 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, create_time, update_time) VALUES (NULL, '{$book}', '{$oneTitle["para"]}', '{$oneTitle["title"]}', '{$title_en}', '{$oneTitle["level"]}', '{$type["{$currType}"]}', '{$sLang["{$currLang}"]}', '{$oneTitle["author"]}', '{$oneTitle["editor"]}', '1', '{$oneTitle["edition"]}', '{$album_id}', '" . time() . "', '" . time() . "')"; $stmt = @PDO_Execute($query); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); print_r($error[2]); } else { echo "新建索引记录成功"; } } } break; case "note": break; } break; }