具体教程可以参考
下面是优化章节名，当章节名只有第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) IN ('章', '页') 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) IN ('章', '页') 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) IN ('章', '页') 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) IN ('章', '页') 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/jianzhanjiaoliu/3661.html
