story_add_content_action.php
3.89 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
/**
* @version $Id: story_add_content_action.php 1 9:02 2010年9月25日Z 蓝色随想 $
* @package DedeCMS.Module.Book
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once(dirname(__FILE__). "/config.php");
require_once(DEDEINC. "/oxwindow.class.php");
require_once(DEDEROOT. '/book/include/story.func.php');
if( empty($chapterid)
|| (!empty($addchapter) && !empty($chapternew)) )
{
if(empty($chapternew))
{
ShowMsg("由于你发布的内容没选择章节，系统拒绝发布！", "-1");
exit();
}
$row = $dsql->GetOne("SELECT * FROM #@__story_chapter WHERE bookid='$bookid' ORDER BY chapnum desc");
if(is_array($row))
{
$nchapnum = $row['chapnum']+1;
}
else
{
$nchapnum = 1;
}
$query = "INSERT INTO `#@__story_chapter`(`bookid`,`catid`,`chapnum`,`mid`,`chaptername`,`bookname`)
VALUES ('$bookid', '$catid', '$nchapnum', '0', '$chapternew','$bookname');";
$rs = $dsql->ExecuteNoneQuery($query);
if($rs)
{
$chapterid = $dsql->GetLastID();
}
else
{
ShowMsg("增加章节失败，请检查原因！","-1");
exit();
}
}
//获得父栏目
$nrow = $dsql->GetOne("SELECT * FROM #@__story_catalog WHERE id='$catid' ");
$bcatid = $nrow['pid'];
$booktype = $nrow['booktype'];
if(empty($bcatid))
{
$bcatid = 0;
}
if(empty($booktype))
{
$booktype = 0;
}
$addtime = time();
//处理上传的缩略图
//$litpic = GetDDImage('litpic',$litpicname,0);
$adminID = $cuserLogin->getUserID();
//本章最后一个小说的排列顺次序
$lrow = $dsql->GetOne("SELECT sortid From #@__story_content WHERE bookid='$bookid' AND chapterid='$chapterid' ORDER BY sortid DESC");
if(empty($lrow))
{
$sortid = 1;
}
else
{
$sortid = $lrow['sortid']+1;
}
$inQuery = "
INSERT INTO `#@__story_content`(`title`,`bookname`,`chapterid`,`catid`,`bcatid`,`bookid`,`booktype`,`sortid`,
`mid`,`bigpic`,`body`,`addtime`)
VALUES ('$title','$bookname', '$chapterid', '$catid','$bcatid', '$bookid','$booktype','$sortid', '0', '' , '', '$addtime');";
if(!$dsql->ExecuteNoneQuery($inQuery))
{
ShowMsg("把数据保存到数据库时出错，请检查！".$dsql->GetError().$inQuery,"-1");
$dsql->Close();
exit();
}
$arcID = $dsql->GetLastID();
WriteBookText($arcID,$body);
//更新图书的内容数
$row = $dsql->GetOne("Select count(id) AS dd FROM #@__story_content WHERE bookid = '$bookid' ");
$dsql->ExecuteNoneQuery("UPDATE #@__story_books SET postnum='{$row['dd']}',lastpost='".time()."' WHERE bid='$bookid' ");
//更新章节的内容数
$row = $dsql->GetOne("SELECT count(id) AS dd FROM #@__story_content WHERE bookid = '$bookid' AND chapterid='$chapterid' ");
$dsql->ExecuteNoneQuery("UPDATE #@__story_chapter SET postnum='{$row['dd']}' WHERE id='$chapterid' ");
//生成HTML
//$artUrl = MakeArt($arcID,true);
if(empty($artcontentUrl)) $artcontentUrl = '';
if($artcontentUrl=="") $artcontentUrl = $cfg_cmspath."/book/story.php?id=$arcID";
require_once(DEDEROOT.'/book/include/story.view.class.php');
$bv = new BookView($bookid, 'book');
$artUrl = $bv->MakeHtml();
$bv->Close();
//返回成功信息
$msg = "
请选择你的后续操作：
<a href='story_add_content.php?bookid={$bookid}'><u>继续发布</u></a>
<a href='$artUrl' target='_blank'><u>预览小说</u></a>
<a href='$artcontentUrl' target='_blank'><u>预览内容</u></a>
<a href='story_list_content.php?bookid={$bookid}'><u>管理所有内容</u></a>
<a href='story_books.php'><u>管理所有图书</u></a>
";
$wintitle = "成功发布文章！";
$wecome_info = "连载管理::发布文章";
$win = new OxWindow();
$win->AddTitle("成功发布文章：");
$win->AddMsgItem($msg);
$winform = $win->GetWindow("hand"," ",false);
$win->Display();
//ClearAllLink();