Snitz Forums 2000 - need help with avatar mod in 3.3

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

need help with avatar mod in 3.3

New Topic

Topic Locked

Printer Friendly

Author

Topic

jburris
Starting Member

40 Posts

Posted - 30 July 2001 : 13:36:39

I'm getting this error msg in topic.asp

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'rs'

/forum_3_3/topic.asp, line 540

in relation to this section of code that I added

<br><% if Trim(rs("M_AVATAR_URL")) <> "" and lcase(rs("M_AVATAR_URL")) <> "noavatar.gif" and (IsNull(rs("M_AVATAR_URL")) = false) then %>
<% '## Forum_SQL - Get Avatar Settings from DB
strSql = "SELECT " & strTablePrefix & "AVATAR2.A_WSIZE"
strSql = strSql & ", " & strTablePrefix & "AVATAR2.A_HSIZE"
strSql = strSql & ", " & strTablePrefix & "AVATAR2.A_BORDER"
strSql = strSql & " FROM " & strTablePrefix & "AVATAR2"

set rsav = my_Conn.Execute (strSql) %>
<img src="<% =rs("M_AVATAR_URL") %>" align="absmiddle" width=<% =rsav("A_WSIZE") %> height=<% =rsav("A_HSIZE") %> border=<% =rsav("A_BORDER") %> hspace="0" ><% set rsav = nothing %><% end if %>

thanks in advance for any help yall can offer with this problem.

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 30 July 2001 : 13:48:58

you'll need to change all rs to either rsTopic or rsReplies depending on the section you are working with.

The code that is in the sub GetFirst() will be rsTopic and the other will be rsReplies

Markp
New Member

54 Posts

Posted - 30 July 2001 : 14:09:31

Richard

I have downloaded this It appears to be working correctly, but I would like it to look for the images in the folder images. It is curently looking in my forum folder. Can you tell me how to change the path. Thanks (I got the forum code from eastpasco, thanks eastpasco)

Appreciate ya.