<% ' ################# TOPIC RATING MOD ###################### ' %>
<% '## Forum_SQL - Find Topic Author
strSql = "SELECT " & strTablePrefix & "TOPICS.T_AUTHOR " 
strSql = strSql & " FROM " & strTablePrefix & "TOPICS "
strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.QueryString("TOPIC_ID")
 
set rsRating = my_Conn.Execute (StrSql) %>

<% if strDBNTUserName <> "" Then %>
	<% if ( getMemberID(strDBNTUserName) = rsRating("T_AUTHOR") ) then %>
		<table border="0" width="100%" cellspacing="0" cellpadding="0" align="center">
		<tr>
			<td bgColor="<% =strPageBGColor %>" align=left <%= strColspan %>>
			<font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small>You Cannot Rate your own Topic: </small></font>
			</td>
		</tr>
		<table>

	<% Else %>

	<% iTopicRating = GetTopicRating( getMemberID(strDBNTUserName), rs("TOPIC_ID") )

		if iTopicRating <> -1 Then %>
			<table border="0" width="100%" cellspacing="0" cellpadding="0" align="center">
			<tr>
			<td bgColor="<% =strPageBGColor %>" align=left <%= strColspan %>>
			<font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small>You Rated this Topic: <%=iTopicRating %></small></font>
			</td>
			</tr>
			<table>

		<% else %>

			<form action="pop_topic_rating.asp?mode=goRate&id=<%=rsTopic("TOPIC_ID")%>" method="Post" id=Form1 name=Form1>
			<SELECT NAME="rating">
			<OPTION value=''>Rate Topic
			<OPTION value='10'>10: Highest Rating
			<OPTION value='9'>9
			<OPTION value='8'>8
			<OPTION value='7'>7
			<OPTION value='6'>6
			<OPTION value='5'>5
			<OPTION value='4'>4
			<OPTION value='3'>3
			<OPTION value='2'>2
			<OPTION value='1'>1: Lowest Rating
			</SELECT> <INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Rate">
			</form>
		<%end if%>
	<% end if%>
<% end if %>
<% rsRating.Close
set rsRating = nothing %>

<% ' ################# END TOPIC RATING MOD ###################### ' %>

quote:

---

Azaniah,

Using your concept for topic.asp I had a go at implementing it in forum.asp such that if rating is turned off for the forum the rate column will not be shown at forum.asp.

I had a slightly different system of showing the stars therefore my forum.asp will not be relevant here. You may want to take a look and if you choose to you may want to update your forum.asp

see here

Anyway thanks for the great work to make forum selection possible for rating.

---

quote:

---

anyone have a link with this working on 3.1SR4?

---