<% Set Conn = Server.CreateObject("ADODB.Connection") conn.CursorLocation = 3 conn.open s_connectionstring '___________________________________________________tekstreplace_________________________________ function toSQLString(tekst) toSQLString = replace(tekst,"'","''") end function function forumToHTML(tekst) tekst = replaceTag("B","b",tekst) tekst = replaceTag("U","u",tekst) tekst = replaceTag("I","i",tekst) tekst = replace(tekst,vbcrlf,"
") tekst = replace(tekst,"[/URL]","") tekst = replace(tekst,"[URL","") tekst = replace(tekst,"[Q]","

") tekst = replace(tekst,"[/Q]","

") tekst = replace(tekst,"[FONT]","") tekst = replace(tekst,"[/FONT]","") tekst = replace(tekst,":D","") tekst = replace(tekst,":shocked:","") tekst = replace(tekst,":cool:","") tekst = replace(tekst,":dry:","") tekst = replace(tekst,":huh:","") tekst = replace(tekst,":laugh:","") tekst = replace(tekst,":mad:","") tekst = replace(tekst,":mellow:","") tekst = replace(tekst,":ohmy:","") tekst = replace(tekst,":ph34r:","") tekst = replace(tekst,":rolleyes:","") tekst = replace(tekst,":(","") tekst = replace(tekst,":)","") tekst = replace(tekst,":P","") tekst = replace(tekst,":unsure:","") tekst = replace(tekst,":wacko:","") tekst = replace(tekst,";)","") forumToHTML = tekst end function function replaceTag(forum,html,detekst) detekst = replace(detekst,"[" & forum & "]","<" &html&">") detekst = replace(detekst,"[/" & forum & "]","") replaceTag = cstr(detekst) end function '_________________________________tijd___________________________________________ function toontijdstip(tijdstip) if tijdstip <> "" then maanden_naam = array(+1,"januari","februari","maart","april","mei","juni","juli","augustus","september","oktober","november","december") dagen_naam = array(+1,"zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag") if day(tijdstip)=day(date()-1) and month(tijdstip)=month(date()-1) and year(tijdstip)=year(date()-1) then response.Write("gisteren ") else if day(tijdstip)=day(date()) and month(tijdstip)=month(date()) and year(tijdstip)=year(date()) then 'houd geen rekening met het einde van de maand response.Write("vandaag ") else response.Write(dagen_naam(weekday(tijdstip))&" "&day(tijdstip)&" "&maanden_naam(month(tijdstip))&" "&year(tijdstip)) end if end if response.Write(" "&hour(tijdstip)&":"&Right("00" & CStr(minute(tijdstip)), 2)) end if end function function huidige_datetime() huidige_datetime = year(now)&"-"& month(now)& "-"&day(now) &" "&hour(now)&":"&minute(now)&":"&second(now) end function '________________________________breadcrumb________________________________________ function build_breadcrumb(Cat) do while Cat <> 0 q = "SELECT title,parentid,categorieid FROM categorie WHERE categorieid ="&Cat set catRS = conn.execute(q) breadcrumb = "
" & cstr(catRS("title")) & " =>" & breadcrumb Cat = cstr(catRS("parentid")) loop end function '___________________________________users en profiel _________________________________ function existUsername(uname) if session("loginid") = "" then q = "select username from users where username = '" & replace(uname,"'","''") & "'" else q = "select username from users where userid!="&session("loginid")&" AND username = '" & replace(uname,"'","''") & "'" end if set rs = conn.execute(q) existusername = (not rs.eof) end function '______________________________________timestamp________________________________________ function timestamp() vN = Now() vTyear = Year(vN) If Len(vTyear) = 1 then vTyear= "0" & vTyear end if vTmon = Month(vN) If Len(vTmon) = 1 then vTmon= "0" & vTmon end if vTday = Day(vN) If Len(vTday) = 1 then vTday = "0" & vTday end if vThour = Hour(vN) If Len(vThour) = 1 then vThour = "0" & vThour end if vTmin = Minute(vN) If Len(vTmin) = 1 then vTmin = "0" & vTmin end if vTsec = Second(vN) If Len(vTsec) = 1 then vTsec = "0" & vTsec end if timestamp = vTyear & vTmon & vTday & vThour & vTmin & vTsec end function %>