|
W h a t ' s N e w :
|
|
Welcome to the What's New Section of this site. All of the resources listed below have been added or Updated in the last seven days. The most recent additions are listed first, simply click on the link to visit the resource.
|
<%
'Create a recordset with the top level categories in it.
Set objRec2 = CreateObject("ADODB.Recordset")
Set objRec2.ActiveConnection = my_Conn
objRec2.LockType = 2
lastDate = DateToStr(DateAdd("d",-8,strForumTimeAdjust))
dDate = strForumTimeAdjust
'response.write dDate
'response.write "
"
dDate = DateAdd( "d", -15, dDate )
'response.write dDate
'response.write "
"
dDate = DateToStr(dDate)
'response.write dDate
Set objRec2 = Server.CreateObject ("ADODB.Recordset")
If mLev = 4 Then
SQL = "SELECT * FROM " & strTablePrefix & "Site_Links WHERE Added > '" & lastdate & "' ORDER BY Added DESC;"
Else
SQL = "SELECT * FROM " & strTablePrefix & "Site_Links WHERE Added > '" & lastdate & "' AND Validated = 1 ORDER BY Added DESC;"
End If
' response.write SQL
' response.write "
"
objRec2.Open SQL, my_Conn, 3, 3
%>
<% DO UNTIL objRec2.EOF %>
<%
If objRec2("Votes") <> "0" then
Rate = round(objRec2("Score")/objRec2("Votes"))
If Rate = 1 then
Rating = "Very Poor"
ElseIf Rate = 2 then
Rating = "Poor"
ElseIf Rate = 3 then
Rating = "Okay"
ElseIf Rate = 4 then
Rating = "Average"
ElseIf Rate = 5 then
Rating = "Very Good"
Else
Rating = "Excellent"
End If
Else
Rating = "Not Rated"
End If
%>
<%
'Move to the next record in the record set.
objRec2.MoveNext
LOOP %>
<% 'Time to clean up
objRec2.Close
Set objRec2 = Nothing
%>
<%
If Request.Cookies(strUniqueID & "User")("Name") <> "" Then
'ahh, so sorry, members only...
%>
<% End If %>
<% WriteFooter %>