<%@language=vbscript codepage=936 LCID=2052 %> <% option explicit response.buffer=true dim conn,connstr dim master dim i dim objET set objET=new clsExeTime Set Conn=Server.CreateObject("ADODB.Connection") 'Connstr="DBQ="+server.mappath("public/ly.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;" 'connstr="DBQ=" & server.mapPath("public/global.asa") & ";DRIVER={Microsoft Access Driver (*.mdb)};" connstr ="Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="& Server.MapPath("db/global.mdb") Conn.Open connstr master=getMaster dim theUser set theUser=new users sub connclose conn.close set conn=nothing end sub sub rsclose rs.close set rs=nothing end sub function encodestr(str) str=trim(str) str=replace(str,"<","<") str=replace(str,">",">") str=replace(str,"'","""") str=replace(str,vbCrLf&vbCrlf,"

") str=replace(str,vbCrLf,"
") str=Replace(str,"&#","&#") encodestr=replace(str," ","กก") end function function validEmail(email) dim length, atIndex, dotIndex length=len(email) atIndex=instr(email,"@") dotIndex=instrrev(email,".") if length<6 then validEmail=false exit function end if if atIndex<0 or dotIndex<0 or length-dotIndex<2 or dotIndex-atIndex<3 then validEmail=false exit function end if validEmail=true end function function getMaster() dim rs, sql,str,LF LF=chr(10) sql="select username from [user] where gbuserClass>0" set rs=conn.execute(sql) if not (rs.eof and rs.bof ) then str=rs(0) rs.movenext do until rs.eof str=str & LF & rs(0) rs.movenext loop end if getMaster=split(str,LF) 'response.write str end function function isMaster(name) isMaster=false for i=0 to ubound(master) if master(i)=name then isMaster=true exit function end if next end function function isLikeMasterName(name) isLikeMasterName=false for i=0 to ubound(master) if instr(name,master(i))>0 then isLikeMasterName=true exit function end if next end function class users dim id, name,pass,reged,master,male,face,email,qq,url,icq,msn,admin private sub class_initialize() dim rs,sql name=request.cookies("gbook")("username") if name<>"" then name=replace(vbunescape(name),"'","") end if pass=replace(request.cookies("gbook")("password"),"'","") reged=false master=false admin=false male=true id=0 if name<>"" and pass<>"" then sql="select top 1 userid, username,userpassword,useremail,sex,GBface,oicq,icq,msn,homepage,gbuserclass from [user] where username='"&name&"' " set rs=conn.execute(sql) if (not rs.eof) then if pass=rs("userpassword") then reged=true id=rs("userid") if rs("sex")="1" then male=true else male=false end if face=rs("GBface") email=rs("useremail") qq=rs("oicq") icq=rs("icq") msn=rs("msn") url=rs("homepage") if rs("gbuserclass")>0 then master=true if rs("gbuserclass")=2 then admin=true else admin=false end if else master=false admin=false end if end if end if rs.close end if end sub end class class clsExeTime dim t1,t2 private sub class_initialize() t1=timer end sub public function read() t2=timer read=formatnumber((t2-t1)*1000,2,-1) end function end class %>