<%
ser = replace(request.QueryString ("ser"),"'","")
if ser = "" then ser = "新手1"
select case ser
case "天龙3"
new_ser = "天龙2"
case "射鵰3"
new_ser = "射鵰1"
case "白马2"
new_ser = "白马1"
case "鹿鼎3"
new_ser = "鹿鼎2"
case "鹿鼎4"
new_ser = "鹿鼎2"
case "雪山3"
new_ser = "飞狐3"
case "笑傲2"
new_ser = "连城3"
case "飞狐4"
new_ser = "射鵰4"
case "笑傲3"
new_ser = "碧血2"
case "碧血3"
new_ser = "倚天3"
case "雪山4"
new_ser = "连城4"
case "倚天4"
new_ser = "连城4"
case "射鵰5"
new_ser = "天龙5"
case "笑傲4"
new_ser = "天龙5"
case "飞狐5"
new_ser = "倚天5"
case "雪山5"
new_ser = "倚天5"
case "鹿鼎5"
new_ser = "连城5"
case "天龙6"
new_ser = "连城5"
case "射鵰6"
new_ser = "笑傲5"
case "倚天6"
new_ser = "连城6"
case "笑傲6"
new_ser = "飞狐6"
case "书剑3"
new_ser = "书剑2"
case "神鵰4"
new_ser = "神鵰2"
case "侠客3"
new_ser = "侠客2"
case "鸳鸯2"
new_ser = "鸳鸯1"
case "鸳鸯3"
new_ser = "鸳鸯1"
case else
new_ser = ser
end select
set db1 = server.CreateObject ("ADODB.Connection")
db1.open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=0625sa0827;Data Source=211.72.248.84"
SQL = "select top 1 * from jinyonginfo.dbo.总坛状态 where 伺服器名称 = '" & new_ser & "' order by 编号 desc"
set rs1 = db1.Execute (SQL)
if not rs1.eof then
a1_1 = rs1("组织名称1")
a1_2 = rs1("组织人数1")
a1_3 = rs1("开战时间1")
a1_4 = rs1("开战状态1")
if a1_4 = "否" then
a1_4 = "和平"
else
a1_4 = "开战"
end if
a2_1 = rs1("组织名称2")
a2_2 = rs1("组织人数2")
a2_3 = rs1("开战时间2")
a2_4 = rs1("开战状态2")
if a2_4 = "否" then
a2_4 = "和平"
else
a2_4 = "开战"
end if
a3_1 = rs1("组织名称3")
a3_2 = rs1("组织人数3")
a3_3 = rs1("开战时间3")
a3_4 = rs1("开战状态3")
if a3_4 = "否" then
a3_4 = "和平"
else
a3_4 = "开战"
end if
a4_1 = rs1("组织名称4")
a4_2 = rs1("组织人数4")
a4_3 = rs1("开战时间4")
a4_4 = rs1("开战状态4")
if a4_4 = "否" then
a4_4 = "和平"
else
a4_4 = "开战"
end if
a5_1 = rs1("组织名称5")
a5_2 = rs1("组织人数5")
a5_3 = rs1("开战时间5")
a5_4 = rs1("开战状态5")
if a5_4 = "否" then
a5_4 = "和平"
else
a5_4 = "开战"
end if
db1.Close
set rs1 = nothing
set db1 = nothing
end if
%>
(<%=ser%>)
| 总坛 |
组织 |
人数 |
开战时间 |
状态 |
| 破军 |
<%=a1_1%> |
<%=a1_2%> |
<%=a1_3%> |
<%=a1_4%> |
| 贪狼 |
<%=a2_1%> |
<%=a2_2%> |
<%=a2_3%> |
<%=a2_4%> |
| 天魁 |
<%=a3_1%> |
<%=a3_2%> |
<%=a3_3%> |
<%=a3_4%> |
| 艮山 |
<%=a4_1%> |
<%=a4_2%> |
<%=a4_3%> |
<%=a4_4%> |
| 巽风 |
<%=a5_1%> |
<%=a5_2%> |
<%=a5_3%> |
<%=a5_4%> |
|
|
