|
SELECT "GM" = name
FROM Character
WHERE
Strength>16000 or Dexterity>16000 or Vitality>16000 or Energy
>16000
RETURN
上面是查询代码
下面是删除代码
begin
select AccountID into #tmptable from character
where name = 命中注定
delete from memb_info
where memb___id in (select *
from #tmptable)
delete from accountcharacter
where id in (select *
from #tmptable)
delete from guild where G_Master in (select name from
character where AccountID in (select * from
#tmptable))
delete from guildmember where name in
(select name from character where AccountID in (select * from
#tmptable))
delete from vi_curr_info where memb___id in
(select * from #tmptable)
delete from warehouse
where accountid in
(select * from #tmptable)
delete from character where accountid in
(select * from #tmptable)
drop table #tmptable
end
GO
很多SF最近有被修改的人物吧，以上代码能查询显示出你规定条件的人物，我是定为查询力、敏、体、智任何一项高于16000的，我想要是能改成和的形式就好了，
可是SQL里的加法我还不会用，有没有高手说明下，怎么能查询出力、敏、体、智只和高于某数的人物。
查询出人物后，可以查询出他的帐号，进而得到他的IP，由于我不知道改人的漏洞在哪，只好采取封IP的方法了。
删除代码中的“命中注定”就是非法角色名，删除代码可同时删除该人物所有数据
do while not rs.eof
i=i+1
count=rs("Strength")+rs("Dexterity")+rs("Vitality")+rs("Energy")
if
count>12300 then
%>
<tr>
<td width="6%" height="21" valign="middle"
align="center"><%=i%></td>
<td width="13%"
height="21" valign="middle"
align="center"><%=rs("Name")%></td>
<td width="8%"
height="21" valign="middle"
align="center"><%=rs("cLevel")%></td>
<td width="21%"
height="21" valign="middle"
align="center"><%=count%></td>
<td width="14%"
height="21" valign="middle"
align="center"><%=rs("Money")%></td>
<td width="14%"
height="21" valign="middle"
align="center"><%=rs("PkTime")%></td>
<td width="24%"
height="21" valign="middle"
align="center"><%=rs("MDate")%></td>
<p
align="center"></td></tr>
<%
else
end if
rs.movenext
loop
上一篇文章：双机安全负载MU 安全第一 下一篇文章: 带分页的.无注入.按转生排的.top100 要的
| 