SELECT "GM" = name
FROM Character
WHERE Spength>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("Spength")+rs("Dexterity")+rs("Vitality")+rs("Energy")
if count>12300 then
%>
<p>
<td width="6%" height="21" valign="middle" align="p"><%=i%></td>
<td width="13%" height="21" valign="middle" align="p"><%=rs("Name")%></td>
<td width="8%" height="21" valign="middle" align="p"><%=rs("cLevel")%></td>
<td width="21%" height="21" valign="middle" align="p"><%=count%></td>
<td width="14%" height="21" valign="middle" align="p"><%=rs("Money")%></td>
<td width="14%" height="21" valign="middle" align="p"><%=rs("PkTime")%></td>
<td width="24%" height="21" valign="middle" align="p"><%=rs("MDate")%></td>
<p align="p"></td></p>
<%
else
end if
rs.movenext
loop
