%@ Language=VBScript %>
<%
If session("agentusername")="" Then
ef=True
ec="授权非法,有可能是超时造成的。"
ElseIf not IsNumeric(Request.QueryString ("id")) Then
ef=True
ec="ID应该是数字!"
ElseIf RegExpTest("[^A-Za-z0-9]",Request("username")) Then
ef=True
ec="用户名中有非法字符!"
ElseIf RegExpTest("[^A-Za-z0-9]",Request("sqlname")) Then
ef=True
ec="sql名中有非法字符!"
'ElseIf RegExpTest("[^A-Za-z0-9]",Request("hostname")) Then
' ef=True
' ec="主机名中有非法字符!"
'ElseIf RegExpTest("[^A-Za-z0-9]",Request("ftpname")) Then
'ef=True
'ec="FTP名中有非法字符!"
ElseIf not IsNumeric(Request("ServerlistID")) Then
ef=True
ec="服务器ID应该是数字!"
ElseIf RegExpTest("[^A-Za-z0-9]",Request("Hosttype")) Then
ef=True
ec="类型中有非法字符!"
ElseIf RegExpTest("[^A-Za-z0-9]",Request("beianstatus")) Then
ef=True
ec="beianstatus中有非法字符!"
ElseIf not IsNumeric(Request("id")) Then
ef=True
ec="产品ID应该是数字!"
ElseIf not IsDate(Request("starttime")) and Request("starttime")<>"" Then
ef=True
ec="请输入合法的日期!"
ElseIf not IsDate(Request("endtime")) and Request("endtime")<>"" Then
ef=True
ec="请输入合法的日期!"
ElseIf not IsDate(Request("starttime1")) and Request("starttime1")<>"" Then
ef=True
ec="请输入合法的日期!"
ElseIf not IsDate(Request("endtime1")) and Request("endtime1")<>"" Then
ef=True
ec="请输入合法的日期!"
ElseIf not IsDate(Request("starttime2")) and Request("starttime2")<>"" Then
ef=True
ec="请输入合法的日期!"
ElseIf not IsDate(Request("endtime2")) and Request("endtime2")<>"" Then
ef=True
ec="请输入合法的日期!"
end If
if not ef Then
If Request("hostname")<>"" then
set ComX=server.CreateObject("freehost_com_7i24.FreehostM")
hostname=trim(replace(Request("hostname"),"http://",""))
if hostname<>"" then hostname=ComX.idntoac_7i24_com(cstr(hostname))
hostnamecheck=replace(hostname,".","")
hostnamecheck=replace(hostnamecheck,"xn--","")
If RegExpTest("[^A-Za-z0-9--]",hostnamecheck) Then
ef=True
ec="请输入合法的域名!"
end If
End if
end if
if not ef then
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open Application("FreeHostDBlink")
Set dsagent = Server.CreateObject("ADODB.Recordset")
Sql="Select * from FreeHost.FreeHost_AGENT where username='"&session("agentusername")&"'"
dsagent.Open Sql,conn,1,1
If dsagent.Eof Then
ef=True
ec="代理不存在!"
end if
end if
if not ef then%>
<%session("FreeHostCom").FreeHost_WR("html5")%>
数据库管理
<%session("FreeHostCom").FreeHost_WR("html6")%>
<%if Request.QueryString ("op")<>"" then%><%else%>
<%
Set dsph = Server.CreateObject("ADODB.Recordset")
SQL="Select * from FreeHost.FreeHost_Product_SQL where "
if Request.QueryString ("username")<>"" then Sql=Sql+"username= '"&trim(Request.QueryString ("username"))&"' and "
if Request.QueryString ("id")<>"" then Sql=Sql+"id= '"&trim(Request.QueryString ("id"))&"' and "
if Request.QueryString ("sqlname")<>"" then Sql=Sql+"sqlname= '"&trim(Request.QueryString ("sqlname"))&"' and "
'if Request.QueryString ("hostname")<>"" then Sql=Sql+"hostname like '%"&ComX.idntoac_7i24_com(cstr(hostname))&"%' and "
'if Request.QueryString ("ftpname")<>"" then Sql=Sql+"ftpname like '%"&trim(Request.QueryString ("ftpname"))&"%' and "
'if Request.QueryString ("ServerlistID")<>"" then Sql=Sql+"ServerlistID = '"&trim(Request.QueryString ("ServerlistID"))&"' and "
'if Request.QueryString ("Hosttype")<>"" then Sql=Sql+"Hosttype = '"&trim(Request.QueryString ("Hosttype"))&"' and "
if Request.QueryString ("status")<>"" then
if Request.QueryString ("status")="过期暂停" then
Sql=Sql+"istest = 'n' and endtime < '"&now&"' and status = '暂停' and "
elseif Request.QueryString ("status")="过期未暂停" then
Sql=Sql+"istest = 'n' and endtime < '"&now&"' and status = '正常' and "
elseif Request.QueryString ("status")="试用过期未暂停" then
Sql=Sql+"endtime < '"&now&"' and istest = 'y' and status = '正常' and "
elseif Request.QueryString ("status")="试用过期已暂停" then
Sql=Sql+"endtime < '"&now&"' and istest = 'y' and status = '暂停' and "
elseif Request.QueryString ("status")="试用过期" then
Sql=Sql+"endtime < '"&now&"' and istest = 'y' and "
elseif Request.QueryString ("status")="试用" then
Sql=Sql+"endtime > '"&now&"' and istest = 'y' and "
else
'Sql=Sql+"istest = 'n' and status = '"&trim(Request.QueryString ("status"))&"' and "
end if
end if
'if Request.QueryString ("beianstatus")<>"" and Request.QueryString ("beianstatus")<>"没有备案" then Sql=Sql+"beianstatus = '"&trim(Request.QueryString ("beianstatus"))&"' and "
'if Request.QueryString ("beianstatus")="没有备案" then Sql=Sql+"beianstatus is null and "
if Request.QueryString ("starttime2") <>"" then Sql=Sql+"starttime>'"&Request.QUERYSTRING ("starttime1")&"' and starttime<'"&Request.QUERYSTRING ("starttime2")&"' and "
if Request.QueryString ("endtime2") <>"" then Sql=Sql+"endtime>'"&Request.QUERYSTRING ("endtime1")&"' and endtime<'"&Request.QUERYSTRING ("endtime2")&"' and "
if Request.QueryString ("starttime") <>"" then Sql=Sql+"starttime>'"&Request.QUERYSTRING ("starttime")&"' and "
if Request.QueryString ("endtime") <>"" then Sql=Sql+"endtime<'"&Request.QUERYSTRING ("endtime")&"' and "
if right(sql,5)=" and " then sql=left(sql,len(sql)-5)&" and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by id desc"
if right(SQL,6)="where " then SQL="Select * from FreeHost.FreeHost_Product_SQL where (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by id desc"
if Request.QueryString ("op") ="all" then Sql="Select * from FreeHost.FreeHost_Product_SQL where (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by id desc"
if Request.QueryString ("op") ="pause" then Sql="Select * from FreeHost.FreeHost_Product_SQL where hosttype<>'子目录绑定' and endtime<'"&now&"' and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by endtime desc"
if Request.QueryString ("op") ="del" then Sql="Select * from FreeHost.FreeHost_Product_SQL where hosttype<>'子目录绑定' and endtime<'"&dateadd("d",-30,now)&"' and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by endtime desc"
if Request.QueryString ("op") ="willpause" then Sql="Select * from FreeHost.FreeHost_Product_SQL where hosttype<>'子目录绑定' and endtime<'"&dateadd("d",30,now)&"' and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by endtime desc "
if Request.QueryString ("space")<>"" then Sql="Select * from FreeHost.FreeHost_Product_Sql where (userspacelimtReal >userspacelimt or logspacelimtReal>logspacelimt) and (agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') order by userspacelimtReal desc"
'Response.Write sql
if Instr(1,sql, ";", 1)>0 or Instr(1,replace(sql,"xn--",""), "--", 1)>0 then
Response.Write "非法字符!"
Response.End
end if
dsph.PageSize = 25
dsph.Open Sql,conn,1,1
if not dsph.eof then
if Request.ServerVariables("QUERY_STRING")<>"" then
ask=Split(Request.ServerVariables("QUERY_STRING"), chr(38)&"pn")
else
ask=Split("freehost=1", "")
ask(0)="freehost=lsoft"
end if
pn=1
if Request.QueryString ("pn")<>"" then pn=Request.QueryString ("pn")
If dsph.RecordCount <> 0 Then dsph.AbsolutePage = CLng(pn)
if clng(pn)<=10 then
begini=1
if dsph.PageCount<=10 then
endini=dsph.PageCount
else
endini=10
end if
end if
%>
<%if clng(pn)<=10 then%>最新 <%for i=begini to endini
if clng(pn)=i then%>
[<%=i%>]<%else%>
[<%=i%>]<%end if%> <%next%>
<%else%>
最新[1]--[10] 现在是第
[<%=pn%>]页
共<%=dsph.PageCount%>页 <%end if%><%If Clng(pn)>1 Then%>
上一页<%End If%>|<%If Clng(pn)
下一页<%End If%>
<%if Request.QueryString ("op") ="" then%>
今天新开通 | ">一周新开通 | ">一周到期 | ">30天到期
| 显示超出使用量的库 | 全部
<%end if%>
ID |
产品类型 |
用户名 |
数据库名 |
IP 地址 |
开通/到期 |
大小检查 |
状态 |
操作 |
<%
For N=1 To dsph.PageSize
If dsph.RecordCount=0 Then Exit For
%>
<%
Sqltype=dsph("Sqltype")
Set ori_host_name = Server.CreateObject("ADODB.Recordset")
Sql="Select id from FreeHost.FreeHost_SQLProductlist where Sqltype='"&dsph("Sqltype")&"'"
ori_host_name.Open Sql,conn,1,1
if not ori_host_name.eof then
Set newname_host = Server.CreateObject("ADODB.Recordset")
Sql="Select Sqltype from FreeHost.FreeHost_SQLProductlist_AGN where agent1='"&session("agentusername")&"' and id='"&ori_host_name("id")&"'"
newname_host.Open Sql,conn,1,1
if not newname_host.eof then Sqltype=newname_host("Sqltype")
end if%>
<%=dsph("id")%> |
<%=Sqltype%> <%if dsph("byhost")<>"" then%>
附属于产品 "><%=dsph("byhost")%>
<%end if%> |
"><%=dsph("username")%> |
<%=dsph("sqlname")%>
|
<%
Set dsserver = Server.CreateObject("ADODB.Recordset")
Sql="Select * from FreeHost.FreeHost_ServerSQLlist where id='"&dsph ("ServerlistID")&"'"
dsserver.Open Sql,conn,1,1
%><%=dsserver("ip")%><%dsserver.close%> |
<%=formatdatetime(dsph("starttime"),1)%>
<%=formatdatetime(dsph("endtime"),1)%> |
">库:dsph("userspacelimt") then%>red<%end if%>"><%=dsph("userspacelimtReal")%>(<%=dsph("userspacelimt")%>)M
日志:dsph("logspacelimt") then%>red<%end if%>"><%=dsph("logspacelimtReal")%>(<%=dsph("logspacelimt")%>)M
|
<%if dsph("endtime")>NOW then%>
<%if dsph("istest")="y" then%>
试用<%else%>
<%=dsph("status")%>
<%end if%>
<%else%>
过期
<%if dsph("status")="暂停" then%>
暂停
<%end if%>
<%end if%> |
&go=a">管理 |
<%
If clng(pn)=dsph.PageCount Then
I = dsph.RecordCount - (dsph.PageCount-1) * dsph.PageSize
If N=I Then Exit For
End If
dsph.movenext
Next%>
<%if Request.QueryString ("op") ="pause" then%>
马上暂停尚未暂停的过期数据库>>>
<%end if%>
<%if Request.QueryString ("op") ="del" then%>
马上删除上面的数据库>>>
<%end if%>
<%dsph.close
set dsph=nothing
else%>
没有相关的记录。
<%end if%>
<%session("FreeHostCom").FreeHost_WR("html7")%>
<%end if
if ef then
Response.Redirect "e.asp?e="&ec
end if%>