📄 join.asp
字号:
<%@ LANGUAGE = VBScript%>
<%
id=1
%>
<!-- #include file=../database.asp -->
<%
Set rs = Server.CreateObject("ADODB.Recordset")
function CheckPassword()
sql="select * from ourusers where Ltrim(Rtrim(username))='supervisor'"
rs.open sql,conn,1,1
if not rs.eof then
if trim(rs("pass"))<>session("pass") then
response.write "<br>错误的密码!"
rs.close
set rs=nothing
conn.close
set conn=nothing
response.end
else
rs.close
end if
else
response.write "错误:用户不存在!"
rs.close
set rs=nothing
conn.close
set conn=nothing
response.end
end if
end function
checkPassword()
%>
<!-- Design and Edit By QianFengyun 2000-5-20 -->
<!-- #include file=../fenlei/makehtmfile.asp -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0041)http://www.china114net.com 中国114网 -->
<html>
<head>
<title><%=titlename%></title>
<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>
<link rel="stylesheet" type="text/css" href="../html/style.css">
</head>
<%
id=request("id")
if isNumeric(id)=0 or id="" then
response.write "操作失败!"
conn.close
set conn=nothing
response.end
end if
if id<0 then
response.write "操作失败!!"
conn.close
set conn=nothing
response.end
end if
sql = "select * from templink where id="&id
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.write "找不到记录!"
rs.close
set rs=nothing
conn.close
set conn=nothing
response.end
end if
url=trim(rs("url"))
sitename=trim(rs("sitename"))
username=trim(rs("username"))
ndatetime=rs("ndatetime")
jiji=trim(rs("jiji"))
fenleiid=rs("fenleiid")
response.write "fenleiid:"&fenleiid
rs.close
sql = "select mail from ourusers where username='"&replace(username,"'","''")&"'"
response.write sql
rs.open sql,conn,1,1
if rs.eof then
response.write "<br>此用户已经被删除，已经没有电子邮件地址了！！<br>"
else
tomail=trim(rs("mail"))
end if
rs.close
sql = "select * from fenlei where id="&fenleiid
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.write "要加入的这个网站的分类不存了,可能是这个分类已经删除!"
rs.close
set rs=nothing
conn.close
set conn=nothing
response.end
else
fenleiid=rs("id")
fatherid=rs("father")
end if
expediency=rs("expediency")
tempStr="总分类 "
for i=1 to expediency
tempStr=tempStr & " > <a href=../join/chooseassort.asp?id="&id&"&fid="&rs(10+i)&">"&trim(rs(i))&"</a>"
next
rs.close
do while right(url,1)="/" or right(url,1)="\"
url=left(url,len(url)-1)
loop
sql = "select * from linking where url='"&replace(url,"'","''")&"'"
rs.open sql,conn,1,1
if not rs.eof then
response.write "网址已经存在,不用再添加了!!此网站已经加在<a href=../navigate.asp?fid="&rs("fenleiid")&">此分类</a>里了."
rs.close
set rs=nothing
conn.close
set conn=nothing
response.end
end if
rs.close
set rs=nothing
if ndatetime="" or isNull(ndatetime) then ndatetime=Cstr(date)
conn.Execute " INSERT INTO linking " _
& "(username,sitename,url,jiji,fenleiid,fen,ndatetime) VALUES " _
& "('"&replace(username,"'","''")&"','"&replace(sitename,"'","''")&"','"&replace(url,"'","''")&"','"&replace(jiji,"'","''")&"',"&fenleiid&",0,'"&ndatetime&"');"
%>
<BODY vlink=0000ff leftmargin="0" topmargin="10" marginwidth="0" marginheight="0" bgcolor="#FFFFFF">
<%
response.write "<br>加入成功!!资料如下:<br>网站名称:"&sitename&"<br>网站地址:"&url&"<br>网站简介:"&jiji&"<br>所在分类:"&tempStr&"<br>."
if request("flag")=1 then
response.write "<p>现在开始删除在临时表中的刚加入网址表的网站.....<br>"
conn.Execute "delete * from templink where id="&id
response.write "<p>删除成功!!!<br>"
end if
function sentokemail(email)
dim objCDOMail
Set objCDOMail = Server.CreateObject("CDONTS.NewMail")
objCDOMail.From ="qianfengyun@163.net" '发信人的EMAIL
objCDOMail.To = email '收信人的EMAIL
objCDOMail.Subject ="新站天天有已经处理好你的网站" 'EMAIL的标题
'EMAL的内容
sendstr=username&"：您好！"&chr(13)&chr(13)&" 新站天天有已经处理好你的网站!"&chr(13)&" 网站名称："&sitename&chr(13)&" 网站地址："&url&chr(13)&" 网站简介："&jiji&chr(13)&" 欢迎到http://findlink.yeah.net再次登记你的其它网站！"
objCDOMail.Body = sendstr
'response.write sendstr
'发送
objCDOMail.Send
Set objCDOMail = Nothing
response.write "<br>邮件已经成功发送到登记用户换邮箱里了！"
end function
conn.Execute "UPDATE fenlei " _
& "SET num = num+1 " _
& "WHERE id ="&fenleiid
response.write "<br>现在正在更新加入的分类的html代码页........."
if writeFenleiFiles(getfenleidirecttrue(fenleiid),fenleiid)=0 then
response.write "<br>建立分类HTM文件失败!"
else
response.write "<br>建立分类HTM文件成功!"
end if
response.write "<br>现在正在更新加入的分类的上一级分类的html代码页........."
if int(fatherid)=0 then
response.write "<br>正在建总分类......<br>"
strFenleiDirect=server.mapPath("/asphouse/search/navigate/")
response.write strFenleiDirect
if writeFenleiFiles(strFenleiDirect,0)=0 then
response.write "<br>建立分类HTM文件失败!"
else
response.write "<br>建立分类HTM文件成功!"
end if
else
if writeFenleiFiles(getfenleidirecttrue(fatherid),fatherid)=0 then
response.write "<br>建立分类HTM文件失败!"
else
response.write "<br>建立分类HTM文件成功!"
end if
end if
conn.close
set conn=nothing
if emailflag=1 and tomail<>"" and inStr(tomail,"@")>0 then sentokemail(tomail)
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -