%
'=====================================================================
'安全校验码
dim vercode
vercode="" '此处取值请自行修改,必须与发布规则的参数取值中vercode参数一致
if vercode<>trim(request("vercode")) then
response.Write("[err]vercode错误[/err]")
response.End()
end if
'=====================================================================
sub echomsg(str)
response.Write("[err]"&str&"[/err]")
response.End()
End sub
sub login
dim UserName,Password,sql,code,Rs,atype
UserName = filterPara(getForm("username","post"))
Password = md5(getForm("password","post"),16)
' User UserGroup
' LoginName
'Password
'GroupID
'IsAdmin
sql = "select count(*) from {prefix}User where LoginName = '"& UserName &"' and Password='"&Password&"'"
Dim rsObj : Set rsObj=Conn.Exec(sql,"r1")
if rsObj(0)=1 then
Set rsObj=Conn.Exec("select IsAdmin, GroupStatus,GroupName, UserStatus, UserID, GroupMenu,GroupSort, LanguageID,adminrand from {prefix}User as a, {prefix}UserGroup as b where LoginName='"&UserName&"' and a.GroupID=b.GroupID","r1")
if not rsObj.Eof Then
if rsObj("IsAdmin")<>1 then echomsg"对不起,你不是管理员!"
if rsObj("GroupStatus")<>1 then echomsg"对不起,您所在用户组已被禁用!"
if rsObj("UserStatus")<>1 then echomsg"对不起,您的账号已被禁用!"
Session("adminName")=UserName
Session("GroupName")=rsObj("GroupName")
'wCookie"adminpwd",getForm("Password","post")
Session("adminpwd") = getForm("Password","post")
Session("adminId")=rsObj("UserID")
Session("groupMenu")=repnull(rsObj("GroupMenu"))
Session("GroupSort")=repnull(rsObj("GroupSort"))
'查找
dim LanguageID
LanguageID=rsObj("LanguageID")
if isnul(LanguageID) then
set rs=conn.exec("select LanguageID,LanguagePath,Alias from {prefix}Language where IsDefault=1","exe")
if rs.eof then
echomsg "没有设置默认语言"
else
LanguageID=rs(0)
end if
else
set rs=conn.exec("select LanguageID,LanguagePath,Alias from {prefix}Language where LanguageID="&LanguageID,"exe")
LanguageID=rs(0)
end if
randomize
dim randnum
randnum=clng(rnd*99999999)
Conn.Exec"update {prefix}User set adminrand='"& randnum &"' where UserID="&rsObj("UserID"),"exe"
Session("adminrand")=rsObj("adminrand")
Session("languageID")=LanguageID
Session("LanguagePath")=rs("LanguagePath")
Session("LanguageAlias")=rs("Alias")
rs.close : set rs=nothing
end if
else
echomsg "用户名或密码错误!"
end if
rsObj.Close() : set rsObj=Nothing
End sub
login()
'die debugmode
dim zzmakelist,zzmakeindex
dim action : action=getForm("action","get")
dim ContentID, LanguageID, SortID, GroupID, Exclusive, Title, Title2, TitleColor, IsOutLink, OutLink, Author, ContentSource, ContentTag, Content, ContentStatus, IsTop, IsRecommend, IsImageNews, IsHeadline, IsFeatured, ContentOrder, IsGenerated, Visits, AddTime, ImagePath, IndexImage, DownURL, PageTitle, PageKeywords, PageDesc, PageFileName, spec, EditTime,DownGroupID,IsNoComment,Star,Timeing,TimeStatus,VideoGroupID,CHvalue,SpecCategory
'SpecCategory用于判断是哪个类型的自定义参数
dim sortType, keyword, page, psize, order, ordsc, sortTypeName
sortType=getForm("sortType","post")
if isnul(sortType) then sortType="2 "
sortid=getForm("sortid","post")
if isnul(sortid) then sortid="1"
keyword=getForm("keyword","post")
DownGroupID=getForm("DownGroupID","post")
VideoGroupID=getForm("VideoGroupID","post")
if not isnum(sortType) then response.Write("[err]内容类型sortType错误[/err]"):response.End()
select case sortType
case "2"
sortTypeName ="文章"
SpecCategory = "C"
case "3"
sortTypeName ="产品"
SpecCategory = "P"
case "4"
sortTypeName ="下载"
SpecCategory = "DL"
case "5"
sortTypeName ="招聘"
SpecCategory = "HR"
case "6"
sortTypeName ="相册"
SpecCategory = "FO"
case "8"
sortTypeName = "视频"
SpecCategory = "VI"
end select
'单篇1,文章2,产品3,下载4,招聘5,相册6,链接7,视频8
SortID=getForm("SortID", "post")
if not isnum(SortID) or SortID="0" then response.Write("[err]请选择分类(SortID)[/err]"):response.End()
Title=getForm("Title", "post")
if isnul(Title) then response.Write("[err]请填写标题[/err]"):response.End()
Sub addContent
Dim sql
LanguageID=cint(session("languageID"))
GroupID=getForm("GroupID", "post")
Exclusive=getForm("Exclusive", "post")
TitleColor=getForm("TitleColor", "post")
Title2=getForm("Title2", "post")
Author=getForm("Author", "post")
ContentSource=getForm("ContentSource", "post")
Content=getForm("Content", "post")
PageTitle=getForm("PageTitle", "post")
PageKeywords=getForm("PageKeywords", "post")
PageDesc=getForm("PageDesc", "post")
OutLink=getForm("OutLink", "post")
IsOutLink=getCheck(getForm("IsOutLink", "post"))
ContentStatus=getForm("ContentStatus", "post")
if isnul(ContentStatus) then ContentStatus=1
IsTop=getCheck(getForm("IsTop", "post"))
IsRecommend=getCheck(getForm("IsRecommend", "post"))
IsHeadline=getCheck(getForm("IsHeadline", "post"))
IsFeatured=getCheck(getForm("IsFeatured", "post"))
IsGenerated=getCheck(getForm("IsGenerated", "post"))
IsNoComment=getCheck(getForm("IsNoComment", "post"))
IsNoComment=getCheck(getForm("IsNoComment", "post"))
TimeStatus=getCheck(getForm("TimeStatus", "post"))
Timeing=getForm("Timeing", "post")
Star=getForm("Star", "post")
ContentOrder=getForm("ContentOrder", "post")
Visits=getForm("Visits", "post")
AddTime=getForm("AddTime", "post")
EditTime=now()
ImagePath=getForm("ImagePath", "post")
ImagePath=replace(ImagePath,vbCrLf,"|")
IndexImage=getForm("IndexImage", "post")
IsImageNews=getForm("IsImageNews", "post")
if isnul(IsImageNews) then
if IndexImage<>"" then
IsImageNews=1
else
IsImageNews=0
end if
end if
DownURL=getForm("DownURL", "post")
PageFileName=getForm("PageFileName", "post")
spec=split(getForm("spec","post"),",")
DownGroupID=getForm("DownGroupID","post")
if DownGroupID = "" then DownGroupID=2
VideoGroupID=getForm("VideoGroupID","post")
if VideoGroupID = "" then VideoGroupID=2
dim specStr : specStr=""
dim specValue : specValue=""
dim valueStr : valueStr=""
dim i :i=0
dim rsObj
sql = "select SpecName,SpecCategory+'_'+SpecField,SpecControlType,SpecOptions from {prefix}SpecSet where SpecCategory = '"&SpecCategory&"' order by SpecOrder,SpecID"
sql = "select SpecCategory+'_'+SpecField,SpecControlType from {prefix}SpecSet order by SpecOrder,SpecID"
Set rsObj=Conn.Exec(sql,"r1")
'0 文本,1 数字,2 编辑器,3 附件,4 日期,5 颜色,6 单选,7 多选
Do While not rsObj.Eof
specStr = specStr&","&rsObj(0)
if rsObj(1) = 2 then
valueStr = valueStr & ",'" &encode(getForm(rsObj(0),"post")) & "'"
else
valueStr = valueStr & ",'" &getForm(rsObj(0),"post") & "'"
end if
'if ubound(spec,1) < i then i = ubound(spec,1)
'echo ubound(spec,1) &"=" &i & "[" &spec(5) & "]"
'valueStr = valueStr&",'"&trim(spec(i))&"'"
i=i+1
rsObj.MoveNext
Loop
rsObj.Close : set rsObj=Nothing
if not isnum(LanguageID) then LanguageID=1
if not isnum(ContentOrder) then ContentOrder=0
if not isnum(Visits) then Visits=0
if not isdate(AddTime) then AddTime=now()
if not isdate(Timeing) then Timeing=now()
if not isnum(star) then star=1
if not isnum(GroupID) then GroupID=2
ContentTag=addTags(replace(replace(getForm("ContentTag", "post")," ",","),",",","))
'die specStr
sql = "insert into {prefix}Content(VideoGroupID,DownGroupID, LanguageID, SortID, GroupID, Exclusive, TitleColor, Title, Title2, Author, ContentSource, [Content], ContentTag, PageTitle, PageKeywords, PageDesc, OutLink, IsOutLink, ContentStatus, IsTop, IsRecommend, IsImageNews, IsHeadline, IsFeatured, IsGenerated, ContentOrder, Visits, AddTime, EditTime, ImagePath, IndexImage, DownURL"&specStr&", PageFileName, IsNoComment, Star,TimeStatus,Timeing) values("&VideoGroupID&","&DownGroupID&","&LanguageID&", "&SortID&", "&GroupID&", '"&Exclusive&"', '"&TitleColor&"', '"&Title&"', '"&Title2&"', '"&Author&"', '"&ContentSource&"', '"&Content&"', '"&ContentTag&"', '"&PageTitle&"', '"&PageKeywords&"', '"&PageDesc&"', '"&OutLink&"', "&IsOutLink&", "&ContentStatus&", "&IsTop&", "&IsRecommend&", "&IsImageNews&", "&IsFeatured&", "&IsFeatured&", "&IsGenerated&", "&ContentOrder&", "&Visits&", '"&AddTime&"', '"&EditTime&"', '"&ImagePath&"', '"&IndexImage&"', '"&DownURL&"' "&valueStr&", '"&PageFileName&"', "&IsNoComment&", "&Star&", "&TimeStatus&", '"&Timeing&"')"
'die sql
conn.exec sql,"exe"
response.Write("[ok]")
End Sub
Function addTags(tags)
dim sql,rs,tag,tagIDs
tags=split(tags,",")
for each tag in tags
if not isnul(tag) then
sql="select TagID from {prefix}Tag where TagName='"&tag&"'"
set rs=conn.exec(sql,"r1")
if not rs.eof then
tagIDs=tagIDs&"{"&rs(0)&"}"
else
sql="insert into {prefix}Tag(TagName, TagCount, SortType, SortID, TagVisits, LanguageID, AddTime) values('"&tag&"',0,"&SortType&","&SortID&",0,"&LanguageID&",'"&now()&"')"
conn.exec sql,"exe"
tagIDs=tagIDs&"{"&conn.exec("select @@identity","r1")(0)&"}"
end if
end if
next
addTags=tagIDs
End Function
'生成内容页
Sub makenewContent
dim rs,sql
sql="select TOP 1 * from {prefix}Content where ContentStatus=1 and GroupID<3 and LanguageID="&cint(session("languageID"))&" and SortID="&SortID&" order by ContentID desc"
set rs=conn.Exec(sql,"r1")
Do While not rs.Eof
'echo "生成"""&rs("ContentID")&"""成功
"
makeContent rs("ContentID"), 1, 1
rs.movenext
Loop
rs.close : set rs =nothing
End Sub
'按条件生成列表页
Sub makeListBySort()
dim rs,sql
sql="select SortID,SortType,SortName from {prefix}Sort where SortType<>1 and SortType<>7 and GroupID<3 and LanguageID="&cint(session("languageID"))&" and SortID = "&SortID&" order by SortID"
set rs=conn.Exec(sql,"r1")
Do While not rs.Eof
makeList( rs("SortID"))
'echo "生成"""&rs("SortName")&"""成功
"
rs.movenext
Loop
rs.close : set rs =nothing
End Sub
'生成首页
Sub makeIndex
dim templateobj,templatePath : set templateobj = new TemplateClass
templatePath=sitePath&"/"&"templates/"&setting.defaultTemplate&"/"&setting.htmlFilePath&"/index.html"
'die templatePath
if not CheckTemplateFile(templatePath) then echomsg "首页模板未找到,无法生成首页"
with templateObj
.content=loadFile(templatePath)
.parseHtml()
.parseCommon
createTextFile .content, sitePath&setting.LanguagePath&"index"&FileExt,""
end with
set templateobj =nothing
End Sub
addContent
if runmode=1 then
makenewContent
zzmakelist=getCheck(getForm("zzmakelist", "post"))
zzmakeindex=getCheck(getForm("zzmakeindex", "post"))
if zzmakelist=1 then
makeListBySort
end if
if zzmakeindex=1 then
makeIndex
end if
end if
%>