mychannel_add.php
6.96 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
125
126
127
128
129
130
131
132
133
<?php
/**
* 自定义频道
*
* @version $Id: mychannel_add.php 1 14:46 2010年7月20日Z tianya $
* @package DedeCMS.Administrator
* @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");
CheckPurview('c_New');
require_once(DEDEINC."/dedetag.class.php");
if(empty($ismake)) $ismake = 0;
if(empty($isdel)) $isdel = 0;
if(empty($action)) $action = '';
if($action=='add')
{
//检查输入
if(empty($id) || preg_match("#[^0-9-]#", $id))
{
ShowMsg("<font color=red>'频道id'</font>必须为数字！","-1");
exit();
}
if(preg_match("#[^a-z0-9]#i", $nid) || $nid == "")
{
ShowMsg("<font color=red>'频道名字标识'</font>必须为英文字母或与数字混合字符串！","-1");
exit();
}
if($addtable == "")
{
ShowMsg("附加表不能为空！","-1");
exit();
}
$trueTable2 = str_replace("#@__",$cfg_dbprefix,$addtable);
if($issystem == -1 && $id>0) $id = $id * -1;
//检查id是否重复
$row = $dsql->GetOne("SELECT * FROM #@__channeltype WHERE id='$id' OR nid LIKE '$nid' OR addtable LIKE '$addtable'");
if(is_array($row))
{
ShowMsg("可能‘频道id’、‘频道名称标识’、‘附加表名称’在数据库已存在，不能重复使用！","-1");
exit();
}
$mysql_version = $dsql->GetVersion();
//创建附加表
if($trueTable2!='')
{
$istb = $dsql->IsTable($trueTable2);
if(!$istb || $isdel==1)
{
//是否需要摘要字段
$dsql->ExecuteNoneQuery("DROP TABLE IF EXISTS `{$trueTable2}`;");
if($issystem != -1)
{
$tabsql = "CREATE TABLE `$trueTable2`(
`aid` int(11) NOT NULL default '0',
`typeid` int(11) NOT NULL default '0',
`redirecturl` varchar(255) NOT NULL default '',
`templet` varchar(30) NOT NULL default '',
`userip` char(15) NOT NULL default '',
";
}
else
{
$tabsql = "CREATE TABLE `$trueTable2`(
`aid` int(11) NOT NULL default '0',
`typeid` int(11) NOT NULL default '0',
`channel` SMALLINT NOT NULL DEFAULT '0',
`arcrank` SMALLINT NOT NULL DEFAULT '0',
`mid` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
`click` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`title` varchar(60) NOT NULL default '',
`senddate` int(11) NOT NULL default '0',
`flag` set('c','h','p','f','s','j','a','b') default NULL,
`litpic` varchar(60) NOT NULL default '',
`userip` char(15) NOT NULL default '',
`lastpost` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`scores` MEDIUMINT( 8 ) NOT NULL DEFAULT '0',
`goodpost` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
`badpost` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
";
}
if($mysql_version < 4.1)
{
$tabsql .= " PRIMARY KEY (`aid`), KEY `typeid` (`typeid`)\r\n) TYPE=MyISAM; ";
}
else
{
$tabsql .= " PRIMARY KEY (`aid`), KEY `typeid` (`typeid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=".$cfg_db_language."; ";
}
$rs = $dsql->ExecuteNoneQuery($tabsql);
if(!$rs)
{
ShowMsg("创建附加表失败!".$dsql->GetError(),"javascript:;");
exit();
}
}
}
$listfields = $fieldset = '';
if($issystem == -1)
{
$fieldset = "<field:channel itemname=\"频道id\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"10\" page=\"\"></field:channel>
<field:arcrank itemname=\"浏览权限\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"5\" page=\"\"></field:arcrank>
<field:mid itemname=\"会员id\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"8\" page=\"\"></field:mid>
<field:click itemname=\"点击\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"10\" page=\"\"></field:click>
<field:title itemname=\"标题\" autofield=\"0\" notsend=\"0\" type=\"text\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"60\" page=\"\"></field:title>
<field:senddate itemname=\"发布时间\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"10\" page=\"\"></field:senddate>
<field:flag itemname=\"推荐属性\" autofield=\"0\" notsend=\"0\" type=\"checkbox\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"10\" page=\"\"></field:flag>
<field:litpic itemname=\"缩略图\" autofield=\"0\" notsend=\"0\" type=\"text\" isnull=\"true\" islist=\"0\" default=\"\" maxlength=\"60\" page=\"\"></field:litpic>
<field:userip itemname=\"会员IP\" autofield=\"0\" notsend=\"0\" type=\"text\" isnull=\"true\" islist=\"0\" default=\"0\" maxlength=\"15\" page=\"\"></field:userip>
<field:lastpost itemname=\"最后评论时间\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"10\" page=\"\"></field:lastpost>
<field:scores itemname=\"评论积分\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"8\" page=\"\"></field:scores>
<field:goodpost itemname=\"好评数\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"8\" page=\"\"></field:goodpost>
<field:badpost itemname=\"差评数\" autofield=\"0\" notsend=\"0\" type=\"int\" isnull=\"true\" islist=\"1\" default=\"0\" maxlength=\"8\" page=\"\"></field:badpost>\r\n";
$listfields = 'channel,arcrank,mid,click,title,senddate,flag,listpic,lastpost,scores,goodpost,badpost';
}
$inQuery = "INSERT INTO `#@__channeltype`(id,nid,typename,addtable,addcon,mancon,editcon,useraddcon,usermancon,usereditcon,fieldset,listfields,issystem,issend,arcsta,usertype,sendrank,needdes,needpic,titlename,onlyone,dfcid)
VALUES ('$id','$nid','$typename','$addtable','$addcon','$mancon','$editcon','$useraddcon','$usermancon','$usereditcon','$fieldset','$listfields','$issystem','$issend','$arcsta','$usertype','$sendrank','$needdes','$needpic','$titlename','$onlyone','$dfcid');";
$dsql->ExecuteNoneQuery($inQuery);
ShowMsg("成功增加一个频道模型！", "mychannel_edit.php?id=".$id);
exit();
}
$row = $dsql->GetOne("SELECT id FROM `#@__channeltype` ORDER BY id DESC LIMIT 0,1 ");
$newid = $row['id'] + 1;
if($newid < 10) $newid = $newid+10;
require_once(DEDEADMIN."/templets/mychannel_add.htm");