ProFile.Asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:6k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <!--#include file="Inc/SysConfig.Asp"-->
  2. <%
  3. Dim UserName,NoShow
  4. UserName=Request.QueryString("name")
  5. If YxBBs.FoundUser Then
  6. If Trim(UserName)="" Then UserName=YxBBs.MyName
  7. If Lcase(UserName)<>lCase(YxBBs.MyName) Then If Cint(YxBBs.ClassSetting(0))=0 Then YxBBs.Error("您没有权限查看其他人资料!")
  8. Else
  9. If Trim(UserName)="" Then YxBBs.Error("缺少用户参数!")
  10. If Cint(YxBBs.ClassSetting(0))=0 Then YxBBs.Error("您没有权限查看其他人资料!")
  11. End If
  12. If Not YxBBs.Fun.CheckName(UserName) then YxBBs.Error("错误的地址栏参数,请不要手动去更改地址栏参数!")
  13. If Lcase(UserName)=lCase(YxBBs.MyName) Then
  14. Call YxBBs.Head("查看本人资料")
  15. Else
  16. Call YxBBs.Head("查看『 "&UserName&" 』的资料")
  17. End If
  18. NoShow=YxBBs.NoShowTopic()
  19. ShowUserInfo()
  20. ShowUserBBS()
  21. YxBBs.Footer()
  22. Set YxBBs=Nothing
  23. Sub ShowUserInfo()
  24. Dim Caption,Content
  25. Dim Rs,Grade,UserPic,UserSex,RegIP,LastIP,rs1
  26. SET Rs=YxBBs.Execute("Select Name,Sex,Birthday,Mail,Home,TimeSum,IsQQpic,QQ,Pic,Pich,Picw,RegIp,Gradenum,LastIp,EssayNum,GoodNum,Mark,Coin,BankSave,RegTime,LastTime,IsShow,LoginNum,Honor,Sign From[YX_user]where Name='"&UserName&"'")
  27. SET Rs1=YxBBs.Execute("Select GradeName,GradePic From [YX_UserGrade] where GradeNum="&Rs("Gradenum")&"")
  28. If Rs.eof then YxBBs.Error("该用户不存在或者已经被删除!")
  29. If Rs("IsQQpic") Then
  30. UserPic="<img src='http://qqshow-user.tencent.com/"&Rs("QQ")&"/10/'>"
  31. Else
  32. UserPic="<img src="&YxBBs.Fun.GetSqlStr(Rs("pic"))&" width="&Rs("picw")&" height="&Rs("pich")&" >"
  33. End If
  34. IF Rs("Sex") Then UserSex="帅哥" Else UserSex="美女"
  35. IF YxBBs.ClassID<=2 or Lcase(YxBBs.MyName)=Lcase(UserName) Then
  36. RegIP=YxBBs.Fun.GetSqlStr(Rs("RegIp"))
  37. LastIP=YxBBs.Fun.GetSqlStr(Rs("LastIp"))
  38. Else 
  39. RegIP=YxBBs.Fun.GetIp(Rs("RegIp"),2)
  40. LastIP=YxBBs.Fun.GetIp(Rs("LastIp"),2)
  41. End If
  42. Caption="用户信息"
  43. Content="<table border=0 cellpadding=8 cellspacing=0 style='border-collapse: collapse' width='100%'><tr>"&_
  44. "<td width='70%'>"&_
  45. "<table width='100%'  border='0' cellspacing='0' cellpadding='0'>"&_
  46. "<tr><td height='190'><table border='0' width='100%'><tr><td>登陆次数: </td><td>"&Rs("LoginNum")&" </td></tr>"&_
  47. "<tr><td>注册时IP: </td><td>"&RegIP&" </td></tr>"&_
  48. "<tr><td>最后访问IP: </td><td>"&LastIP&" </td></tr>"&_
  49.     "<tr><td>注册时间: </td><td>"&Rs("RegTime")&" </td></tr>"&_
  50.     "<tr><td>最后访问: </td><td>"&Rs("LastTime")&" </td></tr>"&_
  51.     "<tr><td>在线时长: </td><td><b>"&YxBBs.Fun.DateToSting(Rs("TimeSum"))&"</b> </td></tr>"&_
  52. "<tr><td colspan='2'><hr noshade align='left' size='0' width='80%' class=a2></td></tr>"&_
  53. "<tr><td>发帖总数: </td><td>"&Rs("EssayNum")&" </td></tr>"&_
  54.     "<tr><td>精华帖数: </td><td>"&Rs("GoodNum")&" </td></tr>"&_
  55.     "<tr><td>用户金钱: </td><td>"&Rs("Coin")&" </td></tr>"&_
  56.     "<tr><td>用户存款: </td><td>"&Rs("BankSave")&" </td></tr>"&_
  57.     "<tr><td>用户"&YxBBs.BBSSetting(23)&": </td><td>"&Rs("Mark")&" </td></tr>"&_
  58.     "<tr><td colspan='2'><hr align='left' noshade size='0' width='80%'></td></tr>"&_
  59.     "<tr><td>QQ: </td><td>"&YxBBs.Fun.GetSqlStr(Rs("QQ"))&" </td></tr>"&_
  60.     "<tr><td>网站: </td><td><a href="&YxBBs.Fun.GetSqlStr(Rs("Home"))&">"&YxBBs.Fun.GetSqlStr(Rs("Home"))&"</a></td></tr>"&_
  61.     "<tr><td>邮箱: </td><td>"&YxBBs.Fun.GetSqlStr(Rs("Mail"))&"</td></tr>"&_
  62.     "</table></td><td width='30%' valign=top>"&_
  63. "<table width='80%' border='1' style='border-collapse: collapse' cellpadding='2' cellspacing='5' ><tr><td colspan='2'><b><font color=blue>"&UserName&"</font></b> </td></tr><tr>"&_
  64. "<td align='center' colspan='2'>"&UserPIc&"</td></tr><tr><td>性别: </td><td>"&UserSex&" </td></tr>"&_
  65. "<tr><td>生日: </td><td>"&Rs("Birthday")&" </td></tr><tr><td>头街: </td><td>"&YxBBs.Fun.GetSqlStr(Rs("Honor"))&" </td></tr>"&_
  66. "<tr><td>等级: </td><td><img src='"&Rs1(1)&"' alt="&Rs1(0)&" vAlign=middle></td></tr><td align='center' colspan='2'><a href='Sms.Asp?Action=write&Name="&UserName&"'>[发短消息]</a></td></tr></table></td></tr></table></td></tr></table>"
  67. Rs.Close
  68. Call YxBBs.ShowTable(Caption,Content)
  69. End Sub 
  70. Sub ShowUserBBS()
  71. Dim Rs,I,SysInfo,ReplyInfo
  72. Set Rs=YxBBs.Execute("select Face,BoardID,Caption,AddTime,TopicID,Name,SqlTableID from  [YX_Topic] where name='"&UserName&"' And IsDel=False order by AddTime desc")
  73.  Do While not Rs.Eof
  74. If InStr(","&NoShow&",",","&Rs("BoardID")&",")=0 or (Lcase(UserName)=Lcase(YxBBs.MyName) or YxBBs.ClassID=1) Then
  75. i=i+1
  76. SysInfo=SysInfo& "<tr height='24'><td width='65%'>&nbsp;<img src='Images/bullet.gif' align='absmiddle'><a href=Show.Asp?ID="&Rs("TopicID")&">"&YxBBs.Fun.StrLeft(Rs("Caption"),50)&"</a></td><td width='15%'>"&Rs("name")&"<td width='20%'> "&Rs("AddTime")&"</td></tr>"
  77. End If
  78. IF i=5 Then Exit Do
  79. Rs.MoveNext
  80.  Loop
  81. Rs.Close
  82. SysInfo="<table align='center' width='100%' border='0' cellpadding='0' cellspacing='3'><tr><td height='25' colspan=3 align='left' bgcolor='#E8E8E8'>&nbsp;<b>+=最近发表=+</b></td></tr>"&SysInfo&"</table>"
  83. i=0
  84. Set Rs=YxBBs.Execute("select Face,BoardID,Caption,LastTime,TopicID,Name,SqlTableID from [YX_Topic] where Name<>'"&UserName&"' And IsDel=False and TopicID in (Select ReplyTopicID from [YX_Bbs"&YxBBs.TB&"] where name='"&UserName&"') order by LastTime desc")
  85.  Do While not Rs.Eof
  86. If InStr(","&NoShow&",",","&Rs("BoardID")&",")=0 or (Lcase(UserName)=Lcase(YxBBs.MyName) or YxBBs.ClassID=1) Then
  87. i=i+1
  88. ReplyInfo=ReplyInfo& "<tr height='24'><td width='65%'><img src='Images/bullet.gif' align='absmiddle'><a href=Show.Asp?ID="&Rs("TopicID")&">"&YxBBs.Fun.StrLeft(Rs("Caption"),50)&"</a></td><td width='15%'>"&Rs("name")&"<td width='20%'> "&Rs("LastTime")&"</td></tr>"
  89. End If
  90. IF i=5 Then Exit Do
  91. Rs.MoveNext
  92.  Loop
  93. Rs.Close
  94. ReplyInfo="<table align='center' width='100%' border='0' cellpadding='0' cellspacing='3'><tr><td height='25'   align='left' bgcolor='#E8E8E8' colspan=3>&nbsp;<b>+=最近回复=+</b></td></tr>"&ReplyInfo&"</table>"
  95. Call YxBBs.ShowTable(UserName&" 帖子信息",SysInfo&ReplyInfo)
  96. End Sub
  97. %>