具體教程可以參考
下面是優化章節名，當章節名只有第XX章時，使用summary的部分內容，作為後續的章節名，這樣看起來更好看。
下面是觸發器代碼，當插入數據時，同步插入數據到分表中，並且處理新的章節名，使用php批量生成
<?php
// PHP 腳本用於生成完整的插入觸發器，適用於 99 個分表
// 表名模式和列名列表
$table_columns = [
'chapterid', 'siteid', 'sourceid', 'sourcecid', 'sourcecorder', 'articleid', 'articlename', 'volumeid', 'posterid', 'poster', 'postdate', 'lastupdate',
'chaptername', 'chapterorder', 'size', 'saleprice', 'salenum', 'totalcost', 'attachment', 'summary', 'isimage', 'isvip', 'pages', 'chaptertype', 'power', 'display'
];
// 開始生成觸發器的 SQL 腳本
$trigger_sql = "DELIMITER $$\n\n";
$trigger_sql .= "CREATE TRIGGER after_insert_jieqi_article_chapter\n";
$trigger_sql .= "AFTER INSERT ON jieqi_article_chapter\n";
$trigger_sql .= "FOR EACH ROW\n";
$trigger_sql .= "BEGIN\n";
// 1. 處理 chaptername 和 summary 字段
$trigger_sql .= " DECLARE modified_summary TEXT;\n";
$trigger_sql .= " DECLARE modified_chaptername TEXT;\n";
$trigger_sql .= " DECLARE cut_position INT;\n";
// 2. 判斷 chaptername 第一個字是 '第'，最後一個字是 '章' 或者最後一個字是 '頁'
$trigger_sql .= " IF (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '章') OR (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '頁') THEN\n";
// 3. 過濾掉 summary 中與 chaptername 對應的內容
$trigger_sql .= " SET modified_summary = REPLACE(NEW.summary, NEW.chaptername, '');\n";
// 4. 過濾掉 summary 中的換行符、空格和中文引號
$trigger_sql .= " SET modified_summary = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(modified_summary, '\\n', ''), '\\r', ''), '“', ''), '”', ''), ' ', '');\n"; // 刪除換行符、回車符、中文引號和空格
// 5. 清除 summary 前後多餘的空格
$trigger_sql .= " SET modified_summary = TRIM(modified_summary);\n"; // 去掉前後空格
// 6. 過濾掉 summary 中與 chaptername 對應的內容
$trigger_sql .= " SET modified_summary = REPLACE(modified_summary, NEW.chaptername, '');\n";
// 7. 從第一個字符開始截取，直到遇到第一個非中文、非英文、非數字字符
$trigger_sql .= " SET cut_position = LOCATE(REGEXP_SUBSTR(modified_summary, '[^\\\\p{Han}a-zA-Z0-9]'), modified_summary);\n";
$trigger_sql .= " IF cut_position > 0 THEN\n";
$trigger_sql .= " SET modified_summary = SUBSTRING(modified_summary, 1, cut_position - 1);\n";
$trigger_sql .= " END IF;\n";
// 8. 截取最多 20 個字符
$trigger_sql .= " SET modified_summary = SUBSTRING(modified_summary, 1, 20);\n"; // 截取最多 20 個字符
// 9. 合併 chaptername 和處理後的 summary，中間加上空格
$trigger_sql .= " SET modified_chaptername = CONCAT(NEW.chaptername, ' ', modified_summary);\n";
$trigger_sql .= " ELSE\n";
$trigger_sql .= " SET modified_chaptername = NEW.chaptername;\n";
$trigger_sql .= " END IF;\n";
// 10. 開始處理第一個表的數據插入
$trigger_sql .= " IF NEW.articleid BETWEEN 1 AND 10000 THEN\n";
$trigger_sql .= " INSERT INTO jieqi_article_chapter_1 (" . implode(', ', $table_columns) . ")\n";
$trigger_sql .= " VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);\n";
// 為 99 個分表動態生成插入語句
for ($i = 2; $i <= 99; $i++) {
// 確定每個表的 articleid 範圍
$start_articleid = ($i - 1) * 10000 + 1;
$end_articleid = $i * 10000;
// 為每個表準備插入語句
$trigger_sql .= " ELSEIF NEW.articleid BETWEEN $start_articleid AND $end_articleid THEN\n";
$trigger_sql .= " INSERT INTO jieqi_article_chapter_$i (" . implode(', ', $table_columns) . ")\n";
$trigger_sql .= " VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);\n";
}
// 關閉觸發器 SQL
$trigger_sql .= " END IF;\n";
$trigger_sql .= "END $$\n";
$trigger_sql .= "DELIMITER ;\n";
// 輸出生成的觸發器 SQL
echo $trigger_sql;
?>
生成後的代碼如下：
DELIMITER $$
CREATE TRIGGER after_insert_jieqi_article_chapter
AFTER INSERT ON jieqi_article_chapter
FOR EACH ROW
BEGIN
DECLARE modified_summary TEXT;
DECLARE modified_chaptername TEXT;
DECLARE cut_position INT;
IF (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '章') OR (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '頁') THEN
SET modified_summary = REPLACE(NEW.summary, NEW.chaptername, '');
SET modified_summary = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(modified_summary, '\n', ''), '\r', ''), '“', ''), '”', ''), ' ', '');
SET modified_summary = TRIM(modified_summary);
SET modified_summary = REPLACE(modified_summary, NEW.chaptername, '');
SET cut_position = LOCATE(REGEXP_SUBSTR(modified_summary, '[^\\p{Han}a-zA-Z0-9]'), modified_summary);
IF cut_position > 0 THEN
SET modified_summary = SUBSTRING(modified_summary, 1, cut_position - 1);
END IF;
SET modified_summary = SUBSTRING(modified_summary, 1, 20);
SET modified_chaptername = CONCAT(NEW.chaptername, ' ', modified_summary);
ELSE
SET modified_chaptername = NEW.chaptername;
END IF;
IF NEW.articleid BETWEEN 1 AND 10000 THEN
INSERT INTO jieqi_article_chapter_1 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 10001 AND 20000 THEN
INSERT INTO jieqi_article_chapter_2 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 20001 AND 30000 THEN
INSERT INTO jieqi_article_chapter_3 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 30001 AND 40000 THEN
INSERT INTO jieqi_article_chapter_4 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 40001 AND 50000 THEN
INSERT INTO jieqi_article_chapter_5 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 50001 AND 60000 THEN
INSERT INTO jieqi_article_chapter_6 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 60001 AND 70000 THEN
INSERT INTO jieqi_article_chapter_7 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 70001 AND 80000 THEN
INSERT INTO jieqi_article_chapter_8 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 80001 AND 90000 THEN
INSERT INTO jieqi_article_chapter_9 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 90001 AND 100000 THEN
INSERT INTO jieqi_article_chapter_10 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 100001 AND 110000 THEN
INSERT INTO jieqi_article_chapter_11 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 110001 AND 120000 THEN
INSERT INTO jieqi_article_chapter_12 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 120001 AND 130000 THEN
INSERT INTO jieqi_article_chapter_13 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 130001 AND 140000 THEN
INSERT INTO jieqi_article_chapter_14 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 140001 AND 150000 THEN
INSERT INTO jieqi_article_chapter_15 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 150001 AND 160000 THEN
INSERT INTO jieqi_article_chapter_16 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 160001 AND 170000 THEN
INSERT INTO jieqi_article_chapter_17 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 170001 AND 180000 THEN
INSERT INTO jieqi_article_chapter_18 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 180001 AND 190000 THEN
INSERT INTO jieqi_article_chapter_19 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 190001 AND 200000 THEN
INSERT INTO jieqi_article_chapter_20 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 200001 AND 210000 THEN
INSERT INTO jieqi_article_chapter_21 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 210001 AND 220000 THEN
INSERT INTO jieqi_article_chapter_22 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 220001 AND 230000 THEN
INSERT INTO jieqi_article_chapter_23 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 230001 AND 240000 THEN
INSERT INTO jieqi_article_chapter_24 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 240001 AND 250000 THEN
INSERT INTO jieqi_article_chapter_25 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 250001 AND 260000 THEN
INSERT INTO jieqi_article_chapter_26 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 260001 AND 270000 THEN
INSERT INTO jieqi_article_chapter_27 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 270001 AND 280000 THEN
INSERT INTO jieqi_article_chapter_28 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 280001 AND 290000 THEN
INSERT INTO jieqi_article_chapter_29 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 290001 AND 300000 THEN
INSERT INTO jieqi_article_chapter_30 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 300001 AND 310000 THEN
INSERT INTO jieqi_article_chapter_31 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 310001 AND 320000 THEN
INSERT INTO jieqi_article_chapter_32 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 320001 AND 330000 THEN
INSERT INTO jieqi_article_chapter_33 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 330001 AND 340000 THEN
INSERT INTO jieqi_article_chapter_34 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 340001 AND 350000 THEN
INSERT INTO jieqi_article_chapter_35 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 350001 AND 360000 THEN
INSERT INTO jieqi_article_chapter_36 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 360001 AND 370000 THEN
INSERT INTO jieqi_article_chapter_37 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 370001 AND 380000 THEN
INSERT INTO jieqi_article_chapter_38 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 380001 AND 390000 THEN
INSERT INTO jieqi_article_chapter_39 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 390001 AND 400000 THEN
INSERT INTO jieqi_article_chapter_40 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 400001 AND 410000 THEN
INSERT INTO jieqi_article_chapter_41 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 410001 AND 420000 THEN
INSERT INTO jieqi_article_chapter_42 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 420001 AND 430000 THEN
INSERT INTO jieqi_article_chapter_43 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 430001 AND 440000 THEN
INSERT INTO jieqi_article_chapter_44 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 440001 AND 450000 THEN
INSERT INTO jieqi_article_chapter_45 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 450001 AND 460000 THEN
INSERT INTO jieqi_article_chapter_46 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 460001 AND 470000 THEN
INSERT INTO jieqi_article_chapter_47 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 470001 AND 480000 THEN
INSERT INTO jieqi_article_chapter_48 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 480001 AND 490000 THEN
INSERT INTO jieqi_article_chapter_49 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 490001 AND 500000 THEN
INSERT INTO jieqi_article_chapter_50 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 500001 AND 510000 THEN
INSERT INTO jieqi_article_chapter_51 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 510001 AND 520000 THEN
INSERT INTO jieqi_article_chapter_52 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 520001 AND 530000 THEN
INSERT INTO jieqi_article_chapter_53 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 530001 AND 540000 THEN
INSERT INTO jieqi_article_chapter_54 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 540001 AND 550000 THEN
INSERT INTO jieqi_article_chapter_55 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 550001 AND 560000 THEN
INSERT INTO jieqi_article_chapter_56 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 560001 AND 570000 THEN
INSERT INTO jieqi_article_chapter_57 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 570001 AND 580000 THEN
INSERT INTO jieqi_article_chapter_58 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 580001 AND 590000 THEN
INSERT INTO jieqi_article_chapter_59 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 590001 AND 600000 THEN
INSERT INTO jieqi_article_chapter_60 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 600001 AND 610000 THEN
INSERT INTO jieqi_article_chapter_61 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 610001 AND 620000 THEN
INSERT INTO jieqi_article_chapter_62 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 620001 AND 630000 THEN
INSERT INTO jieqi_article_chapter_63 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 630001 AND 640000 THEN
INSERT INTO jieqi_article_chapter_64 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 640001 AND 650000 THEN
INSERT INTO jieqi_article_chapter_65 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 650001 AND 660000 THEN
INSERT INTO jieqi_article_chapter_66 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 660001 AND 670000 THEN
INSERT INTO jieqi_article_chapter_67 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 670001 AND 680000 THEN
INSERT INTO jieqi_article_chapter_68 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 680001 AND 690000 THEN
INSERT INTO jieqi_article_chapter_69 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 690001 AND 700000 THEN
INSERT INTO jieqi_article_chapter_70 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 700001 AND 710000 THEN
INSERT INTO jieqi_article_chapter_71 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 710001 AND 720000 THEN
INSERT INTO jieqi_article_chapter_72 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 720001 AND 730000 THEN
INSERT INTO jieqi_article_chapter_73 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 730001 AND 740000 THEN
INSERT INTO jieqi_article_chapter_74 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 740001 AND 750000 THEN
INSERT INTO jieqi_article_chapter_75 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 750001 AND 760000 THEN
INSERT INTO jieqi_article_chapter_76 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 760001 AND 770000 THEN
INSERT INTO jieqi_article_chapter_77 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 770001 AND 780000 THEN
INSERT INTO jieqi_article_chapter_78 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 780001 AND 790000 THEN
INSERT INTO jieqi_article_chapter_79 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 790001 AND 800000 THEN
INSERT INTO jieqi_article_chapter_80 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 800001 AND 810000 THEN
INSERT INTO jieqi_article_chapter_81 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 810001 AND 820000 THEN
INSERT INTO jieqi_article_chapter_82 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 820001 AND 830000 THEN
INSERT INTO jieqi_article_chapter_83 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 830001 AND 840000 THEN
INSERT INTO jieqi_article_chapter_84 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 840001 AND 850000 THEN
INSERT INTO jieqi_article_chapter_85 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 850001 AND 860000 THEN
INSERT INTO jieqi_article_chapter_86 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 860001 AND 870000 THEN
INSERT INTO jieqi_article_chapter_87 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 870001 AND 880000 THEN
INSERT INTO jieqi_article_chapter_88 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 880001 AND 890000 THEN
INSERT INTO jieqi_article_chapter_89 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 890001 AND 900000 THEN
INSERT INTO jieqi_article_chapter_90 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 900001 AND 910000 THEN
INSERT INTO jieqi_article_chapter_91 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 910001 AND 920000 THEN
INSERT INTO jieqi_article_chapter_92 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 920001 AND 930000 THEN
INSERT INTO jieqi_article_chapter_93 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 930001 AND 940000 THEN
INSERT INTO jieqi_article_chapter_94 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 940001 AND 950000 THEN
INSERT INTO jieqi_article_chapter_95 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 950001 AND 960000 THEN
INSERT INTO jieqi_article_chapter_96 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 960001 AND 970000 THEN
INSERT INTO jieqi_article_chapter_97 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 970001 AND 980000 THEN
INSERT INTO jieqi_article_chapter_98 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 980001 AND 990000 THEN
INSERT INTO jieqi_article_chapter_99 (chapterid, siteid, sourceid, sourcecid, sourcecorder, articleid, articlename, volumeid, posterid, poster, postdate, lastupdate, chaptername, chapterorder, size, saleprice, salenum, totalcost, attachment, summary, isimage, isvip, pages, chaptertype, power, display)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, modified_chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
END IF;
END $$
DELIMITER ;
下面是更新數據時更新新的章節名，這樣更好看
php一鍵生成程序
<?php
// PHP 腳本用於生成完整的更新觸發器，適用於 99 個分表
// 表名模式和列名列表
$table_columns = [
'chapterid', 'siteid', 'sourceid', 'sourcecid', 'sourcecorder', 'articleid', 'articlename', 'volumeid', 'posterid', 'poster', 'postdate', 'lastupdate',
'chaptername', 'chapterorder', 'size', 'saleprice', 'salenum', 'totalcost', 'attachment', 'summary', 'isimage', 'isvip', 'pages', 'chaptertype', 'power', 'display'
];
// 開始生成觸發器的 SQL 腳本
$trigger_sql = "DELIMITER $$\n\n";
$trigger_sql .= "CREATE TRIGGER after_update_jieqi_article_chapter\n";
$trigger_sql .= "AFTER UPDATE ON jieqi_article_chapter\n";
$trigger_sql .= "FOR EACH ROW\n";
$trigger_sql .= "BEGIN\n";
// 1. 處理 chaptername 和 summary 字段
$trigger_sql .= " DECLARE modified_summary TEXT;\n";
$trigger_sql .= " DECLARE modified_chaptername TEXT;\n";
$trigger_sql .= " DECLARE cut_position INT;\n";
// 2. 判斷 chaptername 第一個字是 '第'，最後一個字是 '章' 或者最後一個字是 '頁'
$trigger_sql .= " IF (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '章') OR (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '頁') THEN\n";
// 3. 過濾掉 summary 中與 chaptername 對應的內容
$trigger_sql .= " SET modified_summary = REPLACE(NEW.summary, NEW.chaptername, '');\n";
// 4. 過濾掉 summary 中的換行符、空格和中文引號
$trigger_sql .= " SET modified_summary = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(modified_summary, '\\n', ''), '\\r', ''), '“', ''), '”', ''), ' ', '');\n"; // 刪除換行符、回車符、中文引號和空格
// 5. 清除 summary 前後多餘的空格
$trigger_sql .= " SET modified_summary = TRIM(modified_summary);\n"; // 去掉前後空格
// 6. 過濾掉 summary 中與 chaptername 對應的內容
$trigger_sql .= " SET modified_summary = REPLACE(modified_summary, NEW.chaptername, '');\n";
// 7. 從第一個字符開始截取，直到遇到第一個非中文、非英文、非數字字符
$trigger_sql .= " SET cut_position = LOCATE(REGEXP_SUBSTR(modified_summary, '[^\\\\p{Han}a-zA-Z0-9]'), modified_summary);\n";
$trigger_sql .= " IF cut_position > 0 THEN\n";
$trigger_sql .= " SET modified_summary = SUBSTRING(modified_summary, 1, cut_position - 1);\n";
$trigger_sql .= " END IF;\n";
// 8. 截取最多 20 個字符
$trigger_sql .= " SET modified_summary = SUBSTRING(modified_summary, 1, 20);\n"; // 截取最多 20 個字符
// 9. 合併 chaptername 和處理後的 summary，中間加上空格
$trigger_sql .= " SET modified_chaptername = CONCAT(NEW.chaptername, ' ', modified_summary);\n";
$trigger_sql .= " ELSE\n";
$trigger_sql .= " SET modified_chaptername = NEW.chaptername;\n";
$trigger_sql .= " END IF;\n";
// 10. 開始處理第一個表的數據更新
$trigger_sql .= " IF OLD.articleid BETWEEN 1 AND 10000 THEN\n";
$trigger_sql .= " UPDATE jieqi_article_chapter_1 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;\n";
// 為 99 個分表動態生成更新語句
for ($i = 2; $i <= 99; $i++) {
// 確定每個表的 articleid 範圍
$start_articleid = ($i - 1) * 10000 + 1;
$end_articleid = $i * 10000;
// 為每個表準備更新語句
$trigger_sql .= " ELSEIF OLD.articleid BETWEEN $start_articleid AND $end_articleid THEN\n";
$trigger_sql .= " UPDATE jieqi_article_chapter_$i SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;\n";
}
// 關閉觸發器 SQL
$trigger_sql .= " END IF;\n";
$trigger_sql .= "END $$\n";
$trigger_sql .= "DELIMITER ;\n";
// 輸出生成的觸發器 SQL
echo $trigger_sql;
?>
生成的數據如下
DELIMITER $$
CREATE TRIGGER after_update_jieqi_article_chapter
AFTER UPDATE ON jieqi_article_chapter
FOR EACH ROW
BEGIN
DECLARE modified_summary TEXT;
DECLARE modified_chaptername TEXT;
DECLARE cut_position INT;
IF (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '章') OR (LEFT(NEW.chaptername, 1) = '第' AND RIGHT(NEW.chaptername, 1) = '頁') THEN
SET modified_summary = REPLACE(NEW.summary, NEW.chaptername, '');
SET modified_summary = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(modified_summary, '\n', ''), '\r', ''), '“', ''), '”', ''), ' ', '');
SET modified_summary = TRIM(modified_summary);
SET modified_summary = REPLACE(modified_summary, NEW.chaptername, '');
SET cut_position = LOCATE(REGEXP_SUBSTR(modified_summary, '[^\\p{Han}a-zA-Z0-9]'), modified_summary);
IF cut_position > 0 THEN
SET modified_summary = SUBSTRING(modified_summary, 1, cut_position - 1);
END IF;
SET modified_summary = SUBSTRING(modified_summary, 1, 20);
SET modified_chaptername = CONCAT(NEW.chaptername, ' ', modified_summary);
ELSE
SET modified_chaptername = NEW.chaptername;
END IF;
IF OLD.articleid BETWEEN 1 AND 10000 THEN
UPDATE jieqi_article_chapter_1 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 10001 AND 20000 THEN
UPDATE jieqi_article_chapter_2 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 20001 AND 30000 THEN
UPDATE jieqi_article_chapter_3 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 30001 AND 40000 THEN
UPDATE jieqi_article_chapter_4 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 40001 AND 50000 THEN
UPDATE jieqi_article_chapter_5 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 50001 AND 60000 THEN
UPDATE jieqi_article_chapter_6 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 60001 AND 70000 THEN
UPDATE jieqi_article_chapter_7 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 70001 AND 80000 THEN
UPDATE jieqi_article_chapter_8 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 80001 AND 90000 THEN
UPDATE jieqi_article_chapter_9 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 90001 AND 100000 THEN
UPDATE jieqi_article_chapter_10 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 100001 AND 110000 THEN
UPDATE jieqi_article_chapter_11 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 110001 AND 120000 THEN
UPDATE jieqi_article_chapter_12 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 120001 AND 130000 THEN
UPDATE jieqi_article_chapter_13 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 130001 AND 140000 THEN
UPDATE jieqi_article_chapter_14 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 140001 AND 150000 THEN
UPDATE jieqi_article_chapter_15 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 150001 AND 160000 THEN
UPDATE jieqi_article_chapter_16 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 160001 AND 170000 THEN
UPDATE jieqi_article_chapter_17 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 170001 AND 180000 THEN
UPDATE jieqi_article_chapter_18 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 180001 AND 190000 THEN
UPDATE jieqi_article_chapter_19 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 190001 AND 200000 THEN
UPDATE jieqi_article_chapter_20 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 200001 AND 210000 THEN
UPDATE jieqi_article_chapter_21 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 210001 AND 220000 THEN
UPDATE jieqi_article_chapter_22 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 220001 AND 230000 THEN
UPDATE jieqi_article_chapter_23 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 230001 AND 240000 THEN
UPDATE jieqi_article_chapter_24 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 240001 AND 250000 THEN
UPDATE jieqi_article_chapter_25 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 250001 AND 260000 THEN
UPDATE jieqi_article_chapter_26 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 260001 AND 270000 THEN
UPDATE jieqi_article_chapter_27 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 270001 AND 280000 THEN
UPDATE jieqi_article_chapter_28 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 280001 AND 290000 THEN
UPDATE jieqi_article_chapter_29 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 290001 AND 300000 THEN
UPDATE jieqi_article_chapter_30 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 300001 AND 310000 THEN
UPDATE jieqi_article_chapter_31 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 310001 AND 320000 THEN
UPDATE jieqi_article_chapter_32 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 320001 AND 330000 THEN
UPDATE jieqi_article_chapter_33 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 330001 AND 340000 THEN
UPDATE jieqi_article_chapter_34 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 340001 AND 350000 THEN
UPDATE jieqi_article_chapter_35 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 350001 AND 360000 THEN
UPDATE jieqi_article_chapter_36 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 360001 AND 370000 THEN
UPDATE jieqi_article_chapter_37 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 370001 AND 380000 THEN
UPDATE jieqi_article_chapter_38 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 380001 AND 390000 THEN
UPDATE jieqi_article_chapter_39 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 390001 AND 400000 THEN
UPDATE jieqi_article_chapter_40 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 400001 AND 410000 THEN
UPDATE jieqi_article_chapter_41 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 410001 AND 420000 THEN
UPDATE jieqi_article_chapter_42 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 420001 AND 430000 THEN
UPDATE jieqi_article_chapter_43 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 430001 AND 440000 THEN
UPDATE jieqi_article_chapter_44 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 440001 AND 450000 THEN
UPDATE jieqi_article_chapter_45 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 450001 AND 460000 THEN
UPDATE jieqi_article_chapter_46 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 460001 AND 470000 THEN
UPDATE jieqi_article_chapter_47 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 470001 AND 480000 THEN
UPDATE jieqi_article_chapter_48 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 480001 AND 490000 THEN
UPDATE jieqi_article_chapter_49 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 490001 AND 500000 THEN
UPDATE jieqi_article_chapter_50 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 500001 AND 510000 THEN
UPDATE jieqi_article_chapter_51 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 510001 AND 520000 THEN
UPDATE jieqi_article_chapter_52 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 520001 AND 530000 THEN
UPDATE jieqi_article_chapter_53 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 530001 AND 540000 THEN
UPDATE jieqi_article_chapter_54 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 540001 AND 550000 THEN
UPDATE jieqi_article_chapter_55 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 550001 AND 560000 THEN
UPDATE jieqi_article_chapter_56 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 560001 AND 570000 THEN
UPDATE jieqi_article_chapter_57 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 570001 AND 580000 THEN
UPDATE jieqi_article_chapter_58 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 580001 AND 590000 THEN
UPDATE jieqi_article_chapter_59 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 590001 AND 600000 THEN
UPDATE jieqi_article_chapter_60 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 600001 AND 610000 THEN
UPDATE jieqi_article_chapter_61 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 610001 AND 620000 THEN
UPDATE jieqi_article_chapter_62 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 620001 AND 630000 THEN
UPDATE jieqi_article_chapter_63 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 630001 AND 640000 THEN
UPDATE jieqi_article_chapter_64 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 640001 AND 650000 THEN
UPDATE jieqi_article_chapter_65 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 650001 AND 660000 THEN
UPDATE jieqi_article_chapter_66 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 660001 AND 670000 THEN
UPDATE jieqi_article_chapter_67 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 670001 AND 680000 THEN
UPDATE jieqi_article_chapter_68 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 680001 AND 690000 THEN
UPDATE jieqi_article_chapter_69 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 690001 AND 700000 THEN
UPDATE jieqi_article_chapter_70 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 700001 AND 710000 THEN
UPDATE jieqi_article_chapter_71 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 710001 AND 720000 THEN
UPDATE jieqi_article_chapter_72 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 720001 AND 730000 THEN
UPDATE jieqi_article_chapter_73 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 730001 AND 740000 THEN
UPDATE jieqi_article_chapter_74 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 740001 AND 750000 THEN
UPDATE jieqi_article_chapter_75 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 750001 AND 760000 THEN
UPDATE jieqi_article_chapter_76 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 760001 AND 770000 THEN
UPDATE jieqi_article_chapter_77 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 770001 AND 780000 THEN
UPDATE jieqi_article_chapter_78 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 780001 AND 790000 THEN
UPDATE jieqi_article_chapter_79 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 790001 AND 800000 THEN
UPDATE jieqi_article_chapter_80 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 800001 AND 810000 THEN
UPDATE jieqi_article_chapter_81 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 810001 AND 820000 THEN
UPDATE jieqi_article_chapter_82 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 820001 AND 830000 THEN
UPDATE jieqi_article_chapter_83 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 830001 AND 840000 THEN
UPDATE jieqi_article_chapter_84 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 840001 AND 850000 THEN
UPDATE jieqi_article_chapter_85 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 850001 AND 860000 THEN
UPDATE jieqi_article_chapter_86 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 860001 AND 870000 THEN
UPDATE jieqi_article_chapter_87 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 870001 AND 880000 THEN
UPDATE jieqi_article_chapter_88 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 880001 AND 890000 THEN
UPDATE jieqi_article_chapter_89 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 890001 AND 900000 THEN
UPDATE jieqi_article_chapter_90 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 900001 AND 910000 THEN
UPDATE jieqi_article_chapter_91 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 910001 AND 920000 THEN
UPDATE jieqi_article_chapter_92 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 920001 AND 930000 THEN
UPDATE jieqi_article_chapter_93 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 930001 AND 940000 THEN
UPDATE jieqi_article_chapter_94 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 940001 AND 950000 THEN
UPDATE jieqi_article_chapter_95 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 950001 AND 960000 THEN
UPDATE jieqi_article_chapter_96 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 960001 AND 970000 THEN
UPDATE jieqi_article_chapter_97 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 970001 AND 980000 THEN
UPDATE jieqi_article_chapter_98 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 980001 AND 990000 THEN
UPDATE jieqi_article_chapter_99 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = modified_chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
END IF;
END $$
DELIMITER ;
到此為止。
發布者：彬彬筆記，轉載請註明出處：https://www.binbinbiji.com/zh-hant/jianzhanjiaoliu/3661.html
