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