| Author |
 Topic  |
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
 Posted - 13 December 2005 : 12:14:28
|
hello all
i am trying to install full name mode (http://www.snitzbitz.com/mods/details.asp?Version=All&mid=208)
It all goes well until I edit topic.asp
from:
strSql = strSql & ", M.M_TITLE, M.MEMBER_ID, M.M_HOMEPAGE, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY, M.M_AVATAR_URL"
to:
strSql = strSql & ", M.M_TITLE, M.MEMBER_ID, M.M_HOMEPAGE, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY, M.M_AVATAR_URL, M.M_FIRSTNAME, M.M_LASTNAME"
when I make this change I get the following error on the second post of each topic (topic.asp):
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cLng'
/forum/inc_func_secure.asp, line 50
line 50 is:
strSql = strSql & " WHERE MEMBER_ID = " & cLng(fUser_Number)
any idea?
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 13 December 2005 : 12:33:19
|
Did you make the rest of the changed detailed in the mod's readme? At a guess I'd say this is related to the numbering of the reply array or by you overwriting some SQL you had previosuly pasted in as part of another mod.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 13 December 2005 : 17:40:54
|
if I understand what you mean by "numbering of the reply array"
this confused me:
the readme file said
change
rM_COUNTRY = 11
rREPLY_ID = 12
to
rM_COUNTRY = 11
rM_FIRSTNAME = 12
rM_LASTNAME = 13
rREPLY_ID = 14
etc...
however I had already changed these numbers (for other installed mods) to
rM_COUNTRY = 12
rM_Avatar = 13
rREPLY_ID = 14
etc..
so i don't really know what numbers should be assigned to rM_FIRSTNAME and rM_LASSTNAME
I tried to assign them the first available numbers (25 and 26) but this might not be correct! |
|
|
|
Soar
Junior Member
USA
197 Posts |
Posted - 13 December 2005 : 22:44:46
|
Change that section of code to read as follows:
rM_COUNTRY = 12
rM_Avatar = 13
rM_FIRSTNAME = 14
rM_LASTNAME = 15
rREPLY_ID = 16
and so forth (meaning, increment the remaining lines by one).
Also, I'm assuming that you have this code following closely after:
for iForum = 0 to iReplyCount
Reply_MemberName = arrReplyData(rM_NAME, iForum)
Reply_MemberReceiveEmail = arrReplyData(rM_RECEIVE_EMAIL, iForum)
Reply_MemberAIM = arrReplyData(rM_AIM, iForum)
Reply_MemberICQ = arrReplyData(rM_ICQ, iForum)
Reply_MemberMSN = arrReplyData(rM_MSN, iForum)
Reply_MemberYAHOO = arrReplyData(rM_YAHOO, iForum)
Reply_MemberTitle = arrReplyData(rM_TITLE, iForum)
Reply_MemberID = arrReplyData(rMEMBER_ID, iForum)
Reply_MemberHomepage = arrReplyData(rM_HOMEPAGE, iForum)
Reply_MemberLevel = arrReplyData(rM_LEVEL, iForum)
Reply_MemberPosts = arrReplyData(rM_POSTS, iForum)
Reply_MemberCountry = arrReplyData(rM_COUNTRY, iForum)
Reply_MemberAvatar = arrReplyData(rM_AVATAR, iForum)
Reply_ReplyID = arrReplyData(rREPLY_ID, iForum)
Change it to:
for iForum = 0 to iReplyCount
Reply_MemberName = arrReplyData(rM_NAME, iForum)
Reply_MemberReceiveEmail = arrReplyData(rM_RECEIVE_EMAIL, iForum)
Reply_MemberAIM = arrReplyData(rM_AIM, iForum)
Reply_MemberICQ = arrReplyData(rM_ICQ, iForum)
Reply_MemberMSN = arrReplyData(rM_MSN, iForum)
Reply_MemberYAHOO = arrReplyData(rM_YAHOO, iForum)
Reply_MemberTitle = arrReplyData(rM_TITLE, iForum)
Reply_MemberID = arrReplyData(rMEMBER_ID, iForum)
Reply_MemberHomepage = arrReplyData(rM_HOMEPAGE, iForum)
Reply_MemberLevel = arrReplyData(rM_LEVEL, iForum)
Reply_MemberPosts = arrReplyData(rM_POSTS, iForum)
Reply_MemberCountry = arrReplyData(rM_COUNTRY, iForum)
Reply_MemberAvatar = arrReplyData(rM_AVATAR, iForum)
Reply_MemberFirstName = arrReplyData(rM_FIRSTNAME, iForum)
Reply_MemberLastName = arrReplyData(rM_LASTNAME, iForum)
Reply_ReplyID = arrReplyData(rREPLY_ID, iForum) |
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 14 December 2005 : 03:18:25
|
| thanks I did not realize that those had to be in the same order! |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 December 2005 : 05:40:39
|
For future reference, the important thing here is that, starting from 0, the numbers are in the same order as the item they relate to in the SELECT statement.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
| |
Topic |
|
|
|
Topic Locked
