Author |
Topic  |
|
aviv
Junior Member
 
474 Posts |
Posted - 19 May 2002 : 17:24:10
|
can someone help me with the forum.asp file? i'm having some problem with adding the proper line's for it. this is my forum.asp file(igonre the the strange font-it's hebrew) http://www.hunggarkungfu.com/dcforum/User_files/3ce815c327ea30d4.txt
and this is from the readme file of the message icon: **************** Modify FORUM.ASP ****************
Look for this code: (at approx line #163)
'## Forum_SQL - Get all topics from DB strSql ="SELECT " & strActivePrefix & "TOPICS.T_STATUS, " & strActivePrefix & "TOPICS.CAT_ID, " strSql = strSql & strActivePrefix & "TOPICS.FORUM_ID, " & strActivePrefix & "TOPICS.TOPIC_ID, " strSql = strSql & strActivePrefix & "TOPICS.T_VIEW_COUNT, " & strActivePrefix & "TOPICS.T_SUBJECT, " strSql = strSql & strActivePrefix & "TOPICS.T_AUTHOR, " strSql = strSql & strActivePrefix & "TOPICS.T_REPLIES, " & strActivePrefix & "TOPICS.T_LAST_POST, " strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST_AUTHOR, "
Replace with this:
strSql ="SELECT " & strActivePrefix & "TOPICS.T_STATUS, " strSql = strSql & strActivePrefix & "TOPICS.CAT_ID, " strSql = strSql & strActivePrefix & "TOPICS.FORUM_ID, " strSql = strSql & strActivePrefix & "TOPICS.TOPIC_ID, " strSql = strSql & strActivePrefix & "TOPICS.T_VIEW_COUNT, " strSql = strSql & strActivePrefix & "TOPICS.T_SUBJECT, " strSql = strSql & strActivePrefix & "TOPICS.T_AUTHOR, " strSql = strSql & strActivePrefix & "TOPICS.T_REPLIES, " strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST, " strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST_AUTHOR, " strSql = strSql & strActivePrefix & "TOPICS.T_MSGICON, "
**************************
Look for this code: (at approx line #329)
<td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"> </font></b></td> <td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Topic</font></b></td> <td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Author</font></b></td>
replace it with this code:
<td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>"> </font></b></td> <td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>"> </font></b></td> <td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Topic</font></b></td> <td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Author</font></b></td>
**************************
Look for this code: (at approx line #348)
<td colspan="7" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><b>No Topics Found</b></font></td>
Replace it with this code:
<td colspan="8" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><b>No Topics Found</b></font></td>
**************************
Look for this code: (at approx line #370)
<td bgcolor="<% =strForumCellColor %>" valign="center" align="left"> <font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><a href="topic.asp?<%= ArchiveLink %>TOPIC_ID=<% =Topic_ID %>"><% =ChkString(left(rs("T_SUBJECT"), 50),"display") %></a> </font>
Replace it with this code:
<td bgcolor="<% =strForumCellColor %>" valign="center" align="center"><img src='icon_mi_<% =rs("T_MSGICON") %>.gif' height=15 width=15 border=0 hspace=0></td> <td bgcolor="<% =strForumCellColor %>" valign="center" align="left"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><a href="topic.asp?<%= ArchiveLink %>TOPIC_ID=<% =Topic_ID %>"><% =ChkString(left(rs("T_SUBJECT"), 50),"display") %></a> </font>
*********************** That's it for FORUM.ASP *********************** ------------------------------
ThanX Aviv
|
|
Intrepidone
Average Member
  
Canada
515 Posts |
Posted - 19 May 2002 : 18:56:58
|
Aviv,
I gave it a shot, you can try this file here. I think you had chopped off some of your Forum code in one spot with the sticky topic MOD, and I made some changes to your sticky topic between line 614 and 628.
I can't guarantee it will work because all your MODs installed, but try it.
I also changed your sticky topic MOD a little (because I was trying to follow my forum.asp to make your changes). What I did was place an icon so the members can see a sticky topic in the far left column. I think the MOD tells you to put text [Sticky Topic] or an image in the Topics column.

Intrepidone
Edited by - Intrepidone on 19 May 2002 19:23:31 |
 |
|
aviv
Junior Member
 
474 Posts |
Posted - 20 May 2002 : 09:06:34
|
Randy is that you? thanx for trying but i'm getting thid error: ------------- Microsoft VBScript runtime error '800a000d' Type mismatch: 'GetTopicRatingAvg'
/test33/forum.asp, line 413 --------------
ThanX Aviv
|
 |
|
aviv
Junior Member
 
474 Posts |
Posted - 20 May 2002 : 09:08:26
|
i think you added somthing witch i didn't installed on my forum-the Rated mod.
ThanX Aviv
|
 |
|
aviv
Junior Member
 
474 Posts |
Posted - 21 May 2002 : 16:01:30
|
some one please?
ThanX Aviv
Edited by - aviv on 21 May 2002 16:02:32 |
 |
|
Um
Junior Member
 
222 Posts |
Posted - 21 May 2002 : 16:11:41
|
when you are insatlling the MOD, you must enter ONLY the lines whitch are writted in readme.txt file.
|
 |
|
Intrepidone
Average Member
  
Canada
515 Posts |
Posted - 21 May 2002 : 22:06:26
|
quote:
Microsoft VBScript runtime error '800a000d' Type mismatch: 'GetTopicRatingAvg'
/test33/forum.asp, line 413
I'll try again tommorrow night if I have a minute aviv,
I checked your file and can't find any reference to GetTopicRatingAvg, but I will double check.
Intrepidone |
 |
|
aviv
Junior Member
 
474 Posts |
Posted - 22 May 2002 : 08:41:09
|
thanx-i also checked it and couldent find it,but when i uplaoded the file it showes after the "READ" ---> "RATED"
ThanX Aviv
|
 |
|
aviv
Junior Member
 
474 Posts |
Posted - 25 May 2002 : 18:52:56
|
up
ThanX Aviv
|
 |
|
aviv
Junior Member
 
474 Posts |
Posted - 29 May 2002 : 04:14:15
|
up again please?
ThanX Aviv
|
 |
|
MaD2ko0l
Senior Member
   
United Kingdom
1053 Posts |
Posted - 03 June 2002 : 06:25:03
|
hey aviv can u send me ur forum.asp file to me plz???
MaddMartin@hotmail.com send it there and i will have a look at it for u.
MaD2ko0l
© 1999-2002 MaD2ko0l -=[ Life Is So Easy When You Are Evil ]=- |
 |
|
MaD2ko0l
Senior Member
   
United Kingdom
1053 Posts |
Posted - 09 June 2002 : 08:24:12
|
hey aviv have u got an english version of ur forum.asp file plz???? cos i carnt understand the language.
send it to MaddMartin@hotmail.com
thankx
MaD2ko0l
© 1999-2002 MaD2ko0l -=[ Life Is So Easy When You Are Evil ]=- |
 |
|
MaD2ko0l
Senior Member
   
United Kingdom
1053 Posts |
Posted - 09 June 2002 : 13:52:20
|
thankx aviv.
i sent u an email with the forum.asp in it.
try it see if it works.
© 1999-2002 MaD2ko0l -=[ Life Is So Easy When You Are Evil ]=- |
 |
|
aviv
Junior Member
 
474 Posts |
Posted - 10 June 2002 : 03:41:17
|
ThanX a LoT men!!!  it works now.
ThanX Aviv
|
 |
|
|
Topic  |
|