| T O P I C R E V I E W |
| skellyx |
Posted - 23 February 2008 : 06:29:28
Hi
excuse me
I search topic rating mod but it does not exist more link to download.
you can help me
Thank and sorry for english< |
| 15 L A T E S T R E P L I E S (Newest First) |
| richfed |
Posted - 01 June 2013 : 11:42:58
That sounds like it might work ... however, I would like it to be applied to any post ... topic OR replies. Can you assist on that matter? |
| m_r |
Posted - 20 January 2010 : 14:41:28
AnonJr ok |
| AnonJr |
Posted - 20 January 2010 : 14:25:44
m_r, you don't need to ask your question in multiple places. You've asked in another thread - keep the discussion there please. |
| m_r |
Posted - 20 January 2010 : 14:12:32
I want some modifications
Make the stars under the title of the topic
And
How |
| Classicmotorcycling |
Posted - 20 June 2009 : 18:28:51
All done and online at: Topic Rating Mod v2
I have tested with a fresh install of Snitz Forum 3.4.07 using MS Access. The original was tested with MS SQL so there is no reason why it would not work with it. I would rate the install as a 7 with 10 being easy and 1 being hard. I have included both the Percentage and the Stars version in the download. I have 2 different readme files which are named accordingly.
I have also included modified base Snitz Forum 3.4.07 files for each of the Percentage and Stars releases. Always remember to backup all the files that you replace with a mod so you can roll back quick and easy. I have a couple of working sites at: Classic Motorcycling Australia and www.VNCommodore.com Support Site (shameful promotion of own sites)
Let us know how you went with installing and enjoy. 
|
| Etymon |
Posted - 20 June 2009 : 07:35:36
Awesome! Thanks David!  |
| Classicmotorcycling |
Posted - 20 June 2009 : 07:30:32
Just doing the documentation and it will be available for release. |
| Etymon |
Posted - 20 June 2009 : 01:57:57
Here! Here! |
| Classicmotorcycling |
Posted - 20 June 2009 : 00:18:46
Hi All,
I am about to repackage this for use with Snitz Forums 3.4.07 as I found a need for it, but a lot of it did not work from the original download package. I now have it working and will package it up if anyone is interested. |
| cripto9t |
Posted - 27 April 2008 : 11:22:38
iTopicID isn't holding a value. Look at the function in the file your calling it from and make sure the variable in the parenthesis has a value
GetTopicRatingAvg( variable with a numeric value )
< |
| Carefree |
Posted - 27 April 2008 : 10:36:51
Well, deleting the apostrophes strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & iTopicID
or to
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & iTopicID & "" changed the error message to
quote:
Syntax error (missing operator) in query expression 'TOPIC_ID ='.
Outputting the strSQL to screen reveals that the iTopicID isn't being filled in:
quote:
SELECT TOPIC_RATING_TOTAL_COUNT, TOPIC_RATING_TOTAL FROM FORUM_TOPICS WHERE TOPIC_ID =
Back to forum.asp, where I found this line in the midst of the iTopic routine:
Topic_ID = arrTopicData(tTOPIC_ID, iTopic)
Now, assuming that iTopicID wasn't being configured, I changed my line to say
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & TOPIC_ID
and the error went away. Now I get to fix the rest of the routines....< |
| cripto9t |
Posted - 27 April 2008 : 08:40:52
quote:
Originally posted by Carefree
I posted about it (with a link to the file in .txt format) in the support, current version forum but my post got deleted again.
It didn't get deleted, it got moved to "help/mod implimentation" forum http://forum.snitz.com/forum/topic.asp?TOPIC_ID=66949< |
| modifichicci |
Posted - 27 April 2008 : 07:14:39
try
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & iTopicID & ""
removing '< |
| Carefree |
Posted - 27 April 2008 : 03:51:54
This routine gives me an "data type mismatch in criteria expression" error:
function GetTopicRatingAvg( iTopicID )
if request("ARCHIVE")="true" then
strActivePrefix = strTablePrefix & "A_"
ArchiveView = "true"
ArchiveLink = "ARCHIVE=true&"
nDays = "0"
else
strActivePrefix = strTablePrefix
ArchiveView = ""
ArchiveLink = ""
end if
strSQL = ""
strSQL = "SELECT TOPIC_RATING_TOTAL, TOPIC_RATING_TOTAL_COUNT "
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = '" & iTopicID & "'"
set rsTopicRating = Server.CreateObject("ADODB.Recordset")
rsTopicRating = my_Conn.Execute( strSQL )
if rsTopicRating("TOPIC_RATING_TOTAL_COUNT") = 0 then
iTopicRating = 0
else
iTopicRating = cint(rsTopicRating("TOPIC_RATING_TOTAL") / rsTopicRating("TOPIC_RATING_TOTAL_COUNT") )
end if
set rsTopicRating = nothing
GetTopicRatingAvg = iTopicRating
end function
I posted about it (with a link to the file in .txt format) in the support, current version forum but my post got deleted again. I can't spot anything wrong with the function, but I've been looking at it too long.< |
| Bassman |
Posted - 26 April 2008 : 13:23:08
Thanks of sharing Skellyx.
I added topic rating to snitzbitz.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=265< |
