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
%>
|
