<%@LANGUAGE="VBSCRIPT"%> <%OPTION EXPLICIT%> <%Response.Buffer = True%> <% Function SelectFilterItem(item) If Showing = item then SelectFilterItem = "selected" End If End Function '*** Dimension all the variables. Dim ViewLast, Showing Dim objRec Dim strSQL Dim LastHere 'Variables used for paging. Dim intCurrentPage, intCount '*** Open the database. Set objConn = Server.CreateObject ("ADODB.Connection") Set objRec = Server.CreateObject ("ADODB.Recordset") objConn.Open strconnect '*** The table headings, Topic, Author and so on can be used to order the messages (much like an email program) this is the code that does it. If Request.QueryString("orderby") <> "" then Session("OrderBy") = Request.QueryString("orderby") End If Select Case Session("Orderby") Case "Topic" objRec.Sort = "MessageTitle ASC" Case "Author" objRec.Sort = "MessageAuthor ASC" Case "Last+Post" objRec.Sort = "LastPost DESC" Case "Replies" objRec.Sort = "Replies DESC" Case Else objRec.Sort = "LastPost DESC" Session("OrderBy") = "Last Post" End Select objRec.cursorlocation=aduseclient StrSQL = "SELECT * FROM messages" If Request.Form("cboSearchType") = "Message Topics" OR Request.Form("cboSearchType") = "Message Authors" Then Session("txtSearchString") = Request.Form("txtSearchString") Session("cboSearchType") = Request.Form("cboSearchType") End If If Session("cboSearchType") = "Message Authors" Then StrSQL = StrSQL & " WHERE MessageAuthor LIKE '%" & Session("txtSearchString") & "%'" End If If Session("cboSearchType") = "Message Topics" Then StrSQL = StrSQL & " WHERE MessageTitle LIKE '%" & Session("txtSearchString") & "%'" End If objRec.Open strSQL, objConn, adOpenStatic, adLockReadOnly, adCmdText '*** Function to compare the date of the users last visit with the date of the last post. Function NewMessages(lpost) If datediff("s", LastHere, lpost) > 1 then NewMessages = MBImgNewMessage Else NewMessages = MBImgOldMessage End If End Function '*** Find out when the user was last here so that new messages can be highlighted. LastHere = Request.Cookies("aspmbuser")("Date") Response.Cookies("aspmbuser")("Date") = now() Response.Cookies("aspmbuser").Expires = Date + 30 '*** If they haven't been here before set the LastHere variable to a value that will highlight all messages as being new. if LastHere = "" then LastHere = dateadd("d",-10,now()) End if '*** Has the user just asked to view the messages updated in a certain time period? See select form field. If NOT Request.Form("days") = "" then ViewLast = Request.Form("days") '*** Write this value to the cookie so that next time the reload the page it will remain the same. Response.Cookies("aspmbuser")("ViewLast") = Request.Form("days") '*** If they haven't asked for a new time filter. Else '*** If there is no value in the cookie, show them all the messages. If Request.Cookies("aspmbuser")("ViewLast") = "" then ViewLast = "ALL" '*** Otherwise take the value from the cookie. Else ViewLast = Request.Cookies("aspmbuser")("ViewLast") End If End If Showing = ViewLast If Session("cboSearchType") = "" then If NOT ViewLast = "ALL" then '*** Subtract ViewLast amount of days from the current date. ViewLast = DateAdd("d",ViewLast, MediumDate(Date())) '*** Create a record set with only the fields from the last x days. objRec.Filter = "LastPost >= #" & MediumDate(ViewLast) & "#" End If End If %> <%=MBTitle%> <% '*** Print out the Body tag. Also a constant found in the config.inc file. Response.Write MBPageBody2 %>


<%=MBImgAddNew%>  <%=MBImgSearch%>


<% '*** The code above makes sure that the correct item in the drop-down box is highlighted. I'm certain that this was poor coding but it worked. '*** The section below prints the heading for the topics table. Notice the link URLs to order it. See above. Images are defined in the config.inc file. %> <% On Error Resume Next If Request.QueryString("page") = "" Then intCurrentPage = 1 Else intCurrentPage = CInt(Request.QueryString("page")) End If objRec.PageSize = MBPageSize If objRec.PageCount > 0 then objRec.AbsolutePage = intCurrentPage Else intCurrentPage = 0 End If Session("CurrentPage") = intCurrentPage Do While objRec.AbsolutePage = intCurrentPage And Not objRec.EOF %> <% objRec.MoveNext Loop '*** Yeah. It's the end of the table. Response.Write "
  <%=MBImgTopic%> <%=MBImgAuthor%> <%=MBImgLastPost%>


<%=NewMessages(objRec("LastPost"))%> <%=FONT1%>


<%=FONT1 & objRec("MessageAuthor")%> <%=FONT1%><%Call DisplayDateTime(objRec("LastPost"))%> <%=FONT1 & objRec("Replies")%>
" Response.Write "

" If objRec.PageCount > 1 then 'Print Previous Page if required If intCurrentPage <> 1 then Response.Write "Previous Page" Else Response.Write "Previous Page" End If 'Print direct access page numbers. For intCount = 1 to objRec.PageCount If intCount = 1 then Response.Write " | " End If If intCount = intCurrentPage then Response.Write intCount & " | " Else Response.Write "" & intCount & " | " End If Next 'Print Next Page if required If intCurrentPage <> objRec.PageCount then Response.Write "Next Page" Else Response.Write "Next Page" End If End If Response.Write "

Page " & intCurrentPage & " of " & objRec.PageCount & _ " | Ordered By: " & Session("orderby") & " | Showing: " Select Case Showing Case "-0" Response.Write "Topics updated today." Case "-1" Response.Write "Topics updated in the last 2 days." Case "-4" Response.Write "Topics updated in the last 5 days." Case "-9" Response.Write "Topics updated in the last 10 days." Case "-29" Response.Write "Topics updated in the last 30 days." Case "-99" Response.Write "Topics updated in the last 100 days." Case "ALL" Response.Write "All topics." End Select Response.Write "" If NOT Session("cboSearchType") = "" Then Response.Write "

Searched for: " & Session("txtSearchString") & "
On: " & Session("cboSearchType") & "
" Response.Write "Remove Search Filter" End If Response.Write "

" '*** Have a tidy. Don't want any of those nast memory leaks. objRec.Close objConn.Close Set objRec = Nothing Set objConn = Nothing %>
alcoholic drinks that begin with t would need greyhound bus toronto Variety Access wahl peanut stitch remover Vision Video coyote call downloads Australian government relato caliente sexo iPod video cyberdefender 2006 activation code presidential system private rodox vintage mags regional council titus v lindberg case community service peter north yourfilehost Australian cinema sample wedding vows in spanish focus upon jill kelly super exposed desktop computer 270 ballistics charts prostate milking cammeltoe weight loss antique rifle values heart disease meatball recipe with pork good news milena vendramini fucking didnt matter dolcett adult art property column dulce tira tira mp3 long term scandal in bohemia summary to apply the pragmatic savage 775a black lace matala filters vacation rentals remove scratch on veneer international trade lexus locklear torrent got home halimbawa ng talumpati ni andres bonifacio the particular nasty christmas e cards long term remove or reset id3 headers lose weight rogelio bueno green mole recipes mortgage loans carmen ortega model James was anxious lovebirds in southern california great idea photoshop food menu templates diagnosis and treatment vo de balm over again midieval manor deep inside ken fisher furs body shook sativa rose ball honeys stream disarmament and antiwar homemade muesli bar recipe social anxiety derek gardiner paintings under name diagram of cervical 7 vertebrae wide variety perogie dough recipe Los Angeles 1989 san francisco earthquake makes sense 2pac ambitionz as a rider lyrics wonder laugh thousand ago holiday martini recipes looked like myspaccce water filters blue coast burrito nutrition facts great place roler coster tycoon deluxe cheat codes straight face haveingsex good car telus webmail login machine language rene orig doll open mind linda loveless deep throat lay back gateway mt6711 review not possibly masturbastion tips gift ideas imagen de hombre sexis red grape solar steam cooking techniques so highly babehunt org Aborigines practiced kristina vlad model New York dougy houser md sound like qualifications for food stamps in tx Natural Nutritionist candied yams with brandy recipe video files spa luigi franchi brescia shotgun up use pecan encrusted salmon recipe how individuals microsoft infopass Home page capital realty waverly iowa truck insurance craftex houston texas would push valjoux 7736 in relation to pre and post workout foods car buying cfnm loverboys search engines hoover alabama high school cheerleaders maximum speed alliance realty edmundston San Remo liz vicious website passwords White Australia relatos gratis gay reproduction Davion toni guy haircuts health insurance replacement rollers pocket door once again angelica bella free video ball yet talbots outlet houston tx two minutes moores reality houlton maine mortgage rates just christmas niagara on the lake developed his internal list of italian type foods good chance specialty food shop sick kids cunt hole urethral prolapse picture Paris Hilton gun shops in edmonton didnt realize tubes ruth morehead economic growth weapon tree for mhf back towards themed meals home remedies gujarati food recipie apartment building ganja goo ball recipe heart disease leekes llantrisant would like alsa horario taken for granted apache reynard faber dad bread charge chupadoras de polla pretty good nymphet pantie preteen Italian language playboy s kendra nude lose weight bridgestone dueler rebate New York cherry jul franco roccaforte video rapidshare capital city x rocker model 51231 used car