用户工具

站点工具


api:pdnovel

差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

两侧同时换到之前的修订记录 前一修订版
后一修订版
前一修订版
api:pdnovel [2020/02/15 19:15]
admin
api:pdnovel [2020/02/16 17:31] (当前版本)
admin
行 44: 行 44:
  
 增加全本小说步骤: 增加全本小说步骤:
-  - 添加书籍:[[http://​bbs.xlongwei.com/​pdnovel.php?​mod=home&​do=novel&​ac=add|发布小说]],获得novelid+  - 添加书籍:[[http://​bbs.xlongwei.com/​pdnovel.php?​mod=home&​do=novel&​ac=add|发布小说]],获得[[http://​cms.xlongwei.com/​demo/​pdnovel.html|novelid]]
   - 分卷上传:卷名+卷序号,volumnid=select max(volumeid)+1 from pre_pdnovel_volume;​ chapterid=select max(chapterid)+1 from pre_pdnovel_chapter;​   - 分卷上传:卷名+卷序号,volumnid=select max(volumeid)+1 from pre_pdnovel_volume;​ chapterid=select max(chapterid)+1 from pre_pdnovel_chapter;​
   - 分卷多次上传:章序号=select max(chapterorder)+1 from pre_pdnovel_chapter where volumeid='​216';​   - 分卷多次上传:章序号=select max(chapterorder)+1 from pre_pdnovel_chapter where volumeid='​216';​
行 50: 行 50:
   - 下载文件,导入{volumnid}.sql,创建书籍目录{novelid}((/​soft/​discuz/​data/​attachment/​pdnovel/​chapter)),上传分卷文件,执行编码转换:unix2dos *.txt   - 下载文件,导入{volumnid}.sql,创建书籍目录{novelid}((/​soft/​discuz/​data/​attachment/​pdnovel/​chapter)),上传分卷文件,执行编码转换:unix2dos *.txt
   - 更新书籍字数:update pre_pdnovel_view set words=(select sum(volumewords) from pre_pdnovel_volume where novelid=7) where novelid=7;   - 更新书籍字数:update pre_pdnovel_view set words=(select sum(volumewords) from pre_pdnovel_volume where novelid=7) where novelid=7;
-  - 合并txt:对于ite需要指定pdnovel.dir地址复制到/​soft/​uploads/​pdnovel +  - 合并txt:[[https://​api.xlongwei.com/​service/​pdnovel/books.json?​type=merge|merge]],/​soft/​uploads/​pdnovel.sh[[https://api.xlongwei.com/service/​pdnovel/​books.json?​type=reload|reload]]
-  - 重新导出书卷章信息:登录mysql命令行导出后复制cp ​/var/lib/mysql/*.txt /soft/​uploads/pdnovel\\ select novelid,​name from pre_pdnovel_view order by novelid into outfile './books.txt' fields terminated by ','​ lines terminated by '​\r\n';​ \\ select novelid,​volumeid,​volumeorder,​volumename from pre_pdnovel_volume order by novelid,​volumeorder into outfile '​./​volumes.txt'​ fields terminated by ','​ lines terminated by '​\r\n';​ \\ select novelid,​volumeid,​chapterid,​chapterorder,​chaptername from pre_pdnovel_chapter order by novelid,​volumeid,​chapterorder into outfile '​./​chapters.txt'​ fields terminated by ','​ lines terminated by '​\r\n';​+
  
  
api/pdnovel.1581765313.txt.gz · 最后更改: 2020/02/15 19:15 由 admin