账号通
    

账号  

密码  

1170

查看

0

回复
主题:提交两个空间的bug,附解决方案 [收藏主题]  
yknet 当前离线

95

主题

0

广播

0

粉丝
添加关注
级别:学前班

用户积分:1290 分
登录次数:73 次
注册时间:2007/12/20
最后登录:2014/10/23
yknet 发表于:2008/8/17 23:42:00   | 只看该作者 查看该作者主题 楼主 
科汛在线商城系统(NET)

1、空间部分审核用户加入自己的圈子时,能够看到所有用户的圈子

 

在user/User_Team.asp的619行找到以下代码  

 

    <%
               If KS.S("page") <> "" Then
                CurrentPage = KS.ChkClng(KS.S("page"))
       Else
          CurrentPage = 1
       End If
         Dim Sql:sql = "select * from KS_TeamUsers where status=2  order by AddDate DESC"
            Call KSUser.InnerLocation("审核申请加入圈子")
   
          %>

将其改为

 

      <%
               If KS.S("page") <> "" Then
                CurrentPage = KS.ChkClng(KS.S("page"))
       Else
          CurrentPage = 1
       End If
         Dim Sql:sql = "select * from KS_TeamUsers where status=2 and teamid="&KS.S("id")&" order by AddDate DESC"
            Call KSUser.InnerLocation("审核申请加入圈子")
   
          %>

 

 

2、我加入的圈子,在列表时,无法正确获得圈子的ID

 

在user/User_Team.asp的407行找到以下代码 

      <%
               If KS.S("page") <> "" Then
                CurrentPage = KS.ChkClng(KS.S("page"))
       Else
          CurrentPage = 1
       End If
                                   
         Dim Param:Param=" Where UserName='"& KSUser.UserName &"'"
         Dim Sql:sql = "select b.username,a.id,b.teamname,b.photourl,b.adddate from ks_teamusers a, ks_team b where a.status=3 and a.teamid=b.id and a.username='" & ksuser.username & "' and b.username<>'" & ksuser.username & "' order by a.Adddate desc"
            Call KSUser.InnerLocation("我加入的圈子")
   
          %>

 

 

将其改为

 

      <%
               If KS.S("page") <> "" Then
                CurrentPage = KS.ChkClng(KS.S("page"))
       Else
          CurrentPage = 1
       End If
                                   
         Dim Param:Param=" Where UserName='"& KSUser.UserName &"'"
         Dim Sql:sql = "select b.username,b.id,b.teamname,b.photourl,b.adddate from ks_teamusers a, ks_team b where a.status=3 and a.teamid=b.id and a.username='" & ksuser.username & "' and b.username<>'" & ksuser.username & "' order by a.Adddate desc"
            Call KSUser.InnerLocation("我加入的圈子")
   
          %>

 

 
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
<上一主题 | 下一主题 >
Powered By KesionCMS Version X1
厦门科汛软件有限公司 © 2006-2016 页面执行1.42969秒 powered by KesionCMS 9.0