很简单，原始的ASP，给不会代码的朋友用用。

1. 
   
2. <!--#include file="../module/config.asp" -->
   
3. <%
   
4. set rs=conn.execute("select level,struserid,dex,intel,cha,strong,points from userdata")
   
5. do while not rs.eof
   
6.         t=0
   
7.         t=rs("strong")+rs("dex")+rs("intel")+rs("cha")+rs("points")
   
8.         if t>577 then
   
9.                 response.write rs("struserid") &"----->"&rs("level")&"--->"&t
   
10.                 response.write("<font color=red>ERROR</font>")
    
11.                 response.write "<br />"
    
12.         end if
    
13.         rs.movenext
    
14. loop
    
15. rs.close
    
16. closeconn()
    
17. %>
    

复制代码

功能说明：将能力点总和大于577的号列出来，即如果80级属性点不正常的，那就可以用它穷举出来。

一条SQL 可以解决的问题.才这么长啊...

select * from (
select level,struserid,dex,intel,cha,strong,points ,( cast(dex as int)+cast(intel as int) +cast(cha as int)+cast(strong as int)+ cast (points as int))  as sum1  from userdata
) as a where sum1>=577

再加个条件80级
select * from (
select level,struserid,dex,intel,cha,strong,points ,( cast(dex as int)+cast(intel as int) +cast(cha as int)+cast(strong as int)+ cast (points as int))  as sum1  from userdata
) as a where sum1>=577 and level=80

值得学习学习

謝謝樓主分享~~~

我明白了什么叫“丢砖引玉”...

都是高手啊

学习了。