%@language=vbscript codepage=936 %> <% dim conn,db Set conn = Server.CreateObject("ADODB.Connection") conn.Open "provider=sqloledb;data source=127.0.0.1;initial catalog=nursewz;user id=runsun-nurse;password=nurse2007!@#" sub CloseConn() conn.close set conn=nothing end sub %> <% dim UserTableType,Conn_User,db_bbs UserTableType = "Dvbbs7.1" ' "Dvbbs6.0" --- 整合动网论坛6.0 Set Conn_User = Server.CreateObject("ADODB.Connection") Conn_User.Open "provider=sqloledb;data source=127.0.0.1;initial catalog=nursebbs;user id=runsun-nurse;password=nurse2007!@#;" sub CloseConn_User() Conn_User.close set Conn_User=nothing end sub 'MY动力与动网论坛共用的用户数据表 Const db_User_Table="[Dv_User]" 'MY动力与动网论坛共用的用户字段名 Const db_User_ID="UserID" '用户ID Const db_User_Name="UserName" '用户名 Const db_User_Sex="UserSex" '性别 Const db_User_Email="UserEmail" 'Email地址 'Const db_User_Homepage="homepage" '主页 'Const db_User_QQ="Oicq" 'QQ 'Const db_User_Icq="icq" 'Icq 'Const db_User_Msn="msn" 'Msn '以上4个字段集中到DV_User中的UserIM字段 Const db_User_IM="UserIM" Const db_User_Password="UserPassword" '密码 Const db_User_Question="UserQuesion" '忘记密码的提示问题 Const db_User_Answer="UserAnswer" '问题答案 Const db_User_Sign="Usersign" '签名 Const db_User_Face="Userface" '头像 Const db_User_FaceWidth="Userwidth" '头像宽度 Const db_User_FaceHeight="Userheight" '头像高度 Const db_User_RegDate="JoinDate" '注册日期 Const db_User_LoginTimes="Userlogins" '登录次数 Const db_User_LastLoginTime="lastlogin" '最后登录时间 Const db_User_LastLoginIP="UserLastIP" '最后登录IP Const db_User_UserClass="userclass" '论坛用户等级(登录时用到) 'MY动力使用的用户字段名 Const db_User_CheckNum="CheckNum" '验证码 Const db_User_LockUser="lockuser" '是否锁定用户 Const db_User_ArticleCount="ArticleCount" '发表文章数 Const db_User_ArticleChecked="ArticleChecked" '已审核文章数 Const db_User_UserLevel="UserLevel" '用户等级(权限) Const db_User_UserPoint="userWealth" '用户点数 Const db_User_ChargeType="ChargeType" '计费方式 Const db_User_BeginDate="BeginDate" '开始日期 Const db_User_Valid_Num="Valid_Num" '有效期数值 Const db_User_Valid_Unit="Valid_Unit" '有效期单位 '动网论坛使用的用户字段名 'Const db_User_BbsType="bbstype" Const db_User_Article="userpost" '原Article字段 Const db_User_UserGroup="UserGroup" Const db_User_UserWealth="userWealth" Const db_User_UserEP="userEP" Const db_User_UserCP="userCP" Const db_User_Title="UserTitle" 'Const db_User_Showre="showre" 'Const db_User_Reann="reann" 'Const db_User_UserCookies="usercookies" Const db_User_Birthday="Userbirthday" Const db_User_UserPhoto="UserPhoto" Const db_User_UserPower="UserPower" Const db_User_UserDel="UserDel" Const db_User_UserIsBest="UserIsBest" Const db_User_UserInfo="UserInfo" Const db_User_UserSetting="UserSetting" Const db_User_UserGroupID="UserGroupID" Const db_User_TitlePic="TitlePic" %> <% Const SiteName="中国护士网" '网站名称 Const SiteTitle="中国护士网" '网站标题 Const SiteUrl="http://www.china-nurse.com" '网站地址 Const LogoUrl="http://www.china-nurse.com/images/logos.gif" 'Logo地址 Const BannerUrl="http://www.china-nurse.com/images/logo468.jpg" 'Banner地址 Const WebmasterName="runsun" '站长姓名 Const WebmasterEmail="nurse@vip.163.com" '站长信箱 Const Copyright="版权所有 Copyright? 2003 <% sub ShowUserLogin() dim strLogin if CheckUserLogined()=False then strLogin="
| " if ShowTotal=true then strTemp=strTemp & "共 " & totalnumber & " " & strUnit & " " end if strUrl=JoinChar(sfilename) if CurrentPage<2 then strTemp=strTemp & "首页 上一页 " else strTemp=strTemp & "首页 " strTemp=strTemp & "上一页 " end if if n-currentpage<1 then strTemp=strTemp & "下一页 尾页" else strTemp=strTemp & "下一页 " strTemp=strTemp & "尾页" end if strTemp=strTemp & " 页次:" & CurrentPage & "/" & n & "页 " strTemp=strTemp & " " & maxperpage & "" & strUnit & "/页" if ShowAllPages=True then strTemp=strTemp & " 转到:" end if strTemp=strTemp & " |
| 名次 | 用户名 | 文章数 |
| " & cstr(i) & " | " & rsTopUser(db_User_Name) & " | " & rsTopUser(db_User_ArticleChecked) & " |
"
end if
strTemp= strTemp & "![]() 没有任何图片文章 | "
else
i=0
do while not rsPic.eof
strPic=strPic & "" call GetPicArticleTitle(TitleLen,ImgWidth,ImgHeight) strPic=strPic & " | " rsPic.movenext i=i+1 if ((i mod Cols=0) and (not rsPic.eof)) then strPic=strPic & "
![]() 没有任何图片文章 | "
else
i=0
do while not rsPic.eof
strPic=strPic & "" call GetPicArticleTitle(TitleLen,ImgWidth,ImgHeight) strPic=strPic & " | " rsPic.movenext i=i+1 if ((i mod Cols=0) and (not rsPic.eof)) then strPic=strPic & "
"
end if
strPic=strPic & "| 错误信息 |
| 产生错误的可能原因:" & errmsg &" |
| << 返回上一页 |
| 恭喜你! |
" & SuccessMsg &" |
"
end if
end sub
sub ShowBanner()
if BannerUrl<>"" then
if lcase(right(BannerUrl,3))="swf" then
Response.Write ""
else
response.Write "没有通告
" else AnnounceCount=rsAnnounce.recordcount if ShowType=1 then do while not rsAnnounce.eof response.Write " " & rsAnnounce("title") & "| "
if rsLink("LogoUrl")="" or rsLink("LogoUrl")="http://" then
strLink=strLink & " |
| " strTemp= strTemp & "| 设"&"为"&"首"&"页 | " strTemp= strTemp & "加"&"入"&"收"&"藏 | " strTemp= strTemp & "联"&"系"&"站"&"长 | " strTemp= strTemp & "友"&"情"&"链"&"接 | " strTemp= strTemp & "版"&"权"&"申"&"明 | " strTemp= strTemp & "管"&"理"&"登"&"录 | " strTemp= strTemp & " |
| "
strTemp= strTemp & Copyright
strTemp= strTemp & " 站长:" & WebmasterName & ""
if ShowRunTime="Yes" then
strTemp= strTemp & " 页"&"面"&"执"&"行"&"时"&"间:" & CStr(FormatNumber((Timer-BeginTime)*1000,2)) & "毫秒"
end if
strTemp= strTemp & " " strTemp= strTemp & " |
| 名次 | 用户名 | 文章数 |
| " & cstr(i) & " | " & rsTopUser(db_User_Name) & " | " & rsTopUser(db_User_ArticleChecked) & " |
| 用户名 | 性别 | 注册日期 | 文章数 | 日记数 | 日记访问量 | ||||||||
| 用户名 | 性别 | 注册日期 | 文章数 | ||||||
| " & rsUser(db_User_Name) & " | " if rsUser(db_User_Sex)="1" then response.write "男" else response.write "女" end if 'response.write " | " & rsUser(db_User_id) & " | " response.write " | " 'if rsUser(db_User_id)<>"" then 'response.write rsUser(db_User_id) 'else 'response.write "未填" 'end if 'response.write "" 'skying 2006_updateBBs Begin 'if rsUser(db_User_Msn)<>"" then ' response.write rsUser(db_User_Msn) 'else ' response.write "未填" 'end if 'response.write " | " 'if rsUser(db_User_Homepage)<>"" and rsUser(db_User_Homepage)<>"http://" then ' response.write "点此访问" 'else ' response.write "未填" 'end if 'skying 2006_updateBBs End response.write " | " & FormatDateTime(rsUser(db_User_RegDate),2) & " | " & rsUser(db_User_ArticleChecked) & " | " response.write "" & rsUser("diaryNum") & " | " & rsUser("diaryVisit") & " |