| Author |
 Topic  |
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
 Posted - 09 November 2001 : 05:46:16
|
Another small bug.
In the updated zip file I included some gifs. These are named incorrectly. They should be topic_rating_1.gif etc.
Sorry about that.
Cheers Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
 |
|
|
extrafree
New Member
54 Posts |
Posted - 09 November 2001 : 05:53:39
|
quote:
Extrafree,
I'm a little bit confused.
The "only" error you get is when you open a locked topic? is that correct?
Cheers Az
-------
Eagles fly!, but weasels don't get sucked into jet engines.
Dear Azaniah,
yes, the error your mode gave me is the same i'm going to write you above:
error '80020009'
Exception occurred.
/testforum/inc_functions.asp, line 36
my line 36:
strSQL = strSQL & "TOPIC_RATINGS Where RATINGS_BYMEMBER_ID =" & iTopicRatingID & " AND RATINGS_TOPIC_ID =" & iTopicRatedID
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 09 November 2001 : 09:04:15
|
Is the only place to download the latest code for this mod in the first post?
I'm curious why it has become "vogue" to have to join everyone's personel forum to make a download?  I don't think it's neccessary for Snitz members...
My two cents...
Rob Poretti 
Sascom Marketing Group ~ Toronto
Cube-Tec Forums
vox.905.825.5373 fax.905.825.5960 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 09 November 2001 : 10:06:19
|
Hey Rob.... Look in my Sig. :)
Test Site:
EastPasco running on Huw's Code 3.3.10 SQL 2000
Need a Snitz MOD? Click Here: Snitz Mod Resource |
|
|
|
Raichelle
Junior Member
370 Posts |
Posted - 09 November 2001 : 10:26:01
|
hello extrafree
what version of the topic rating mod are you using?
looks like you are using the other version someone worked on again with the pop up window. I tested yours but no error. Im asking because I noticed you are using snitz 3.1 SR4.
maybe I should try and see if I install the 0.90 updated one I didn't wanted to since I have to mess with the post and postinfo scripts don't want error end up showing because lot users be online using the forum.
Edited by - raichelle on 09 November 2001 10:28:48 |
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 09 November 2001 : 10:38:51
|
Extrafree,
You are using version 3.1 if think.
If you could send me your topic.asp and inc_functions.asp
to azaniah@hotmail.com.
Thanks Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 09 November 2001 : 10:42:13
|
Questions for people.
I've just finished updating this MOD to allow a user to allow rating or not when they create or edit (?) a topic, depending on if the forum allows ratings.
Is there anything else (I'm still trying to find those half stars), that you guys think it should have?
Might as well try and do them all at once, rather than little bits here and there.
Thanks Az
If any has any "half" stars gifs, let me know..
-------
Eagles fly!, but weasels don't get sucked into jet engines.
Edited by - azaniah on 09 November 2001 11:16:46 |
|
|
|
extrafree
New Member
54 Posts |
Posted - 09 November 2001 : 10:44:21
|
well, i had dowloaded this mod from here
http://www.yishunmethodist.org/home/forum.asp?FORUM_ID=24
than I've add your code in topic.asp this code:
<% ' ################# 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 %>
<td bgColor="<% =strPageBGColor %>" align=left <%= strColspan %>>
<font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small>Non puoi votare i Topic creati da te: </small></font>
</td>
<% Else %>
<% iTopicRating = GetTopicRating( getMemberID(strDBNTUserName), rs("TOPIC_ID") )
if iTopicRating <> -1 Then %>
<font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><i>Hai votato questo topic: </i></small></font> <img src="<%= iTopicRating %>stars.gif">
<% else %>
<font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><i><a href="JavaScript:openWindow8('rate1.asp?id=<%=rs("TOPIC_ID")%>')">Vota questo Topic </a></i></font>
<%end if%>
<% end if%>
<% end if %>
<% rsRating.Close
set rsRating = nothing %>
<% ' ################# END TOPIC RATING MOD ###################### ' %>
it works very good but when I see a topic locked it give me this error:
error '80020009'
Exception occurred.
/testforum/inc_functions.asp, line 36
my line 36:
strSQL = strSQL & "TOPIC_RATINGS Where RATINGS_BYMEMBER_ID =" & iTopicRatingID & " AND RATINGS_TOPIC_ID =" & iTopicRatedID
this is my forumtest
htt://www.extrafree.it/testforum
thanks
Edited by - extrafree on 09 November 2001 10:51:13 |
|
|
|
suhern
Junior Member
186 Posts |
Posted - 09 November 2001 : 10:59:51
|
extrafree,
Sorry I don't quite understand your problem of locked. Do you enter the error after u locked the topic or the forum or what? I tried locking both topic and forum and I did not encounter any problem. Please enlighten.
|
|
|
|
Raichelle
Junior Member
370 Posts |
Posted - 09 November 2001 : 11:00:10
|
works fine for me
maybe the error don't show but guest but i tried to register on your forum am getting this error
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/testforum/register.asp, line 262
|
|
|
|
suhern
Junior Member
186 Posts |
Posted - 09 November 2001 : 11:11:46
|
quote:
extrafree,
Sorry I don't quite understand your problem of locked. Do you enter the error after u locked the topic or the forum or what? I tried locking both topic and forum and I did not encounter any problem. Please enlighten.
I also notice that in one of your topic your average star is more than five and therefore u r getting a broken image for star display. Did you change the function in anyway?
|
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 09 November 2001 : 11:15:11
|
Extrafree,
I had a look on your site, http://www.extrafree.it/testforum/FORUM.asp?FORUM_ID=30&CAT_ID=9&Forum_Title=Find the Song.
I could vote for locked topic - 15th Song, and I could view all the other locked topics apart from, IL Vinitore!
That gave me the error.
Can you tell me what function line 28 is? and what the line says?
Thanks Az.
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
extrafree
New Member
54 Posts |
Posted - 09 November 2001 : 11:20:16
|
good now it work perfectly
I'm sorry but when I try this mod I gone here :
http://www.extrafree.it/TESTforum/topic.asp?TOPIC_ID=609&FORUM_ID=31&CAT_ID=1&Topic_Title=Perch%C3%A8 non fare una sezione del forum dedicata a%2E&Forum_Title=Collabora con noi%21%21
as you can see give error........ but in the other topic locked it's work... I dont' know why is it possible but this strange thing are confused me!
SORRY SORRY SORRY !!! 
THANKS VERY VERY MUCH EVERY BODY FOR YOUR HELP!!
THANKS AGAIN!!!
-------------------------------------------------------------------
i DONT' UNDESTAND BECOUSE IN A TOPIC WORK AND IN AN OTHER NOT!!!????
MY LINE 28 IS THIS
strSQL = strSQL & "TOPIC_RATINGS Where RATINGS_BYMEMBER_ID =" & iTopicRatingID & " AND RATINGS_TOPIC_ID =" & iTopicRatedID
Edited by - extrafree on 09 November 2001 11:24:37 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 November 2001 : 12:06:36
|
quote:
Dayve,
Yep - It's pretty much big9er's code - just moved about a bit.
Seemed to do everything you needed for a topic rating just needed to point it to different fields.
Cheers Az.
-------
Eagles fly!, but weasels don't get sucked into jet engines.
cool, I was thinking of transitioning that code as well to topic rating like UBB6 has. so now that I don't have to do all that work, is this mod bug free yet and is the download bug free with all updates? thanks.
Dayve |
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 09 November 2001 : 12:12:17
|
Dayve,
It's more or less there in 3.3 - I've just added restriction by topic (ie topic author can decide if they want it rated or not).
I'm having a few problems with 3.1.
I'll let you know - I'll be working on it this weekend.
Cheers Az
-------
Eagles fly!, but weasels don't get sucked into jet engines. |
|
|
|
Topic |
|
Topic Locked
