Topic rating mod ( search)

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/66525?pagenum=1
05 November 2025, 06:50

Topic

skellyx
Topic rating mod ( search)
23 February 2008, 06:29


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<

 

Replies ...

skellyx
16 March 2008, 05:47


Possible ?

nobody has download this mod or knows where to find it dissapprove<
HuwR
16 March 2008, 06:29


have you checked on SnitzBitz.com ?<
modifichicci
16 March 2008, 06:47


Topic rating mod was available on image forum, but no more now. It is default in Image portal 3.06, you can ask him..<
skellyx
19 March 2008, 16:16


Topic rating mod was available on image forum, but no more now. It is default in Image portal 3.06, you can ask him..

Scusa non ho capito è integrato in qualche nuova versione?<
AnonJr
19 March 2008, 16:25


Originally posted by skellyx
Scusa non ho capito è integrato in qualche nuova versione?
Um, while I'm guessing english isn't your first language, this is an english forum...<
skellyx
22 March 2008, 04:38


Thankkkkkkkkkkkkkkk Image
Kiss for you blush
p.s. Sorry AnonJr dissapprove<
Astralis
21 April 2008, 22:50


Could anyone send it to me as well?<
Astralis
22 April 2008, 11:24


Or post it on snitzbitz?<
mdelcour2000
22 April 2008, 22:31


yes, I would like to have it as well....<
Classicmotorcycling
23 April 2008, 22:18


Originally posted by skellyx
Scusa non ho capito è integrato in qualche nuova versione?
Um, while I'm guessing english isn't your first language, this is an english forum... Translation:

Excuse I have not understood is integrated in some new version?
bigsmile wink<
skellyx
25 April 2008, 07:32



smile
http://rapidshare.com/files/110275808/Topic_Rating_v1.1.zip.html<
Bassman
26 April 2008, 13:23


Thanks of sharing Skellyx.

I added topic rating to snitzbitz.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=265<
Carefree
27 April 2008, 03:51


This routine gives me an "data type mismatch in criteria expression" error:
Code:

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.<
modifichicci
27 April 2008, 07:14


try

strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & iTopicID & ""

removing '<
cripto9t
27 April 2008, 08:40


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<
Carefree
27 April 2008, 10:36


Well, deleting the apostrophes
Code:
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
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
Code:

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
27 April 2008, 11:22


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 )
<
Classicmotorcycling
20 June 2009, 00:18


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.
Etymon
20 June 2009, 01:57


Here! Here! bigsmile
Classicmotorcycling
20 June 2009, 07:30


Just doing the documentation and it will be available for release.
Etymon
20 June 2009, 07:35


Awesome! Thanks David! smile
Classicmotorcycling
20 June 2009, 18:28


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. bigsmile
m_r
20 January 2010, 14:12



I want some modifications
Make the stars under the title of the topic

And


How
AnonJr
20 January 2010, 14:25


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
20 January 2010, 14:41


AnonJr ok
richfed
01 June 2013, 11:42


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?
© 2000-2021 Snitz™ Communications