查询、删除被修改出的BT人物脚本

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