| Author |
 Topic  |
|
geunsie
Starting Member
31 Posts |
 Posted - 04 June 2001 : 13:37:40
|
in topic.asp add/replace the red lines
<hr noshade size="<% =strFooterFontSize %>">
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><% =formatStr(rs("R_MESSAGE")) %>
<table valign="bottom" width=100% height=110 border=0>
<td valign="bottom"> <font size=1 color=#8080E0><% =ChkString(rs("M_SIG"),"display") %><TD align="right" valign="bottom">
</font>
<a href="#top"><img src="<%=strImageURL %>icon_go_up.gif" height=15 width=15 border="0" align="right" valign="bottom" alt="Go to Top of Page"></a></font></td></table></td>
</tr>
<%
rs.MoveNext
intI = intI + 1
if intI = 2 then
intI = 0
end if
rec = rec + 1
loop
end if
2 times
and here:
'## Forum_SQL - Get all topicsFrom DB
strSql ="SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_ICQ, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_YAHOO, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_AIM, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_TITLE, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_Homepage, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_LEVEL, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_PMRECEIVE, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_SIG, "
there is only one problem...
i think it is an asp-problem.
the valign function in table or td does not work!!!
maybe someone has a solution for this. for now i just fixed the table height to 110.
strange thing is if you save the page from your browser and open it locally it work like it should work.
I hope i did't forget something.
see an example at:
http://www.crapforum.nl
|
|
|
geunsie
Starting Member
31 Posts |
Posted - 05 June 2001 : 10:45:15
|
oops....i forgot to mension that you have to remove and disable the signature option is post.asp.
|
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 June 2001 : 13:28:46
|
Sorry for asking but, what does this do?
|
|
|
|
geunsie
Starting Member
31 Posts |
Posted - 05 June 2001 : 17:08:05
|
That's okay :)
This mod. changes the way of how the signature is used.
Normally the signature is included/added within the complete message.
This mod. uses the signature dynamically, so if you change your signature in your profile, all your posts will have the new signature. Which also elimenates signatures in quoted messages.
Also with this mod,
you can make your own customized signature look for the complete forum. (font, size, color, etc)
:)
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 05 June 2001 : 17:22:41
|
I took a look at the site, ( pretty nice looking forum you got by the way, even if I can't read more than 2 words on it  ) and it's a pretty cool idea.
I just had NO idea what you were talking about when I was first looking this over and it took me quite a few times of looking through topic.asp to find the code you are referencing.
For future use, either post more of the surrounding non-edited code, or some line numbers to assist those that are too dense ( like me ) to find the code first time around.
http://www.ugfl.net/forums |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 June 2001 : 19:14:02
|
Same here big9erfan, didn't have clue what this mod did.
But the forum on his site looks great.
The reason we don't use the "dynamic" way of getting the signatures is that for every single post, a call would be made to the database for the signature. Can you imagine with 20 topics posts per page, that's a extra 20 hits to the database for every view of that page, not to mention how many users view that page. 20 x 50 users an hour maybe? On a busy forum. it would probably be more. That's an extra 1000 hits on the database each hour.
Compared to just getting the message for each post made, that has the signature already appended to the message.
But it's a great idea geunsie. Don't recommend it for large forums though. 
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 05 June 2001 : 21:33:20
|
Davio,
quote:
The reason we don't use the "dynamic" way of getting the signatures is that for every single post, a call would be made to the database for the signature. Can you imagine with 20 topics posts per page, that's a extra 20 hits to the database for every view of that page, not to mention how many users view that page. 20 x 50 users an hour maybe? On a busy forum. it would probably be more. That's an extra 1000 hits on the database each hour.
That's what I thought at first when I realized what this mod was about, but if you look at the code, it is retreiving the sig at the same time that it is retreiving the Yahoo, AIM, etc from the memebers table, thus it's not creating anymore of a drain on the server than reading replies as normal.
Quite an interesting way of doing it if you ask me.
I'm definately thinking of implementing this as it's pretty cool.
http://www.ugfl.net/forums
Edited by - big9erfan on 05 June 2001 21:35:41 |
|
|
|
simonduz
Junior Member
161 Posts |
Posted - 05 June 2001 : 21:46:34
|
very nice forum.
I like the mod also.
Thanks
http://easyromantic.webbhost.net -[test site]-
yada, yada.
Edited by - simonduz on 05 June 2001 21:47:06 |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 06 June 2001 : 02:57:21
|
Where in the code does it append the signature to the message? I was looking for that today and was unable to locate it. I wanted to add a break (<hr>) above the signature. Could anyone point me to the section of code that does this?
<-- Eric -->
InsideWaco.com |
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 06 June 2001 : 09:35:49
|
Eric,
Edit: real answer
Check in post_info.asp
Around lines 601 and 469...If you do a search for Request.Form("sig") you should find the 2 instances of it.
http://www.ugfl.net/forums
Edited by - big9erfan on 06 June 2001 18:03:15
Edited by - big9erfan on 06 June 2001 18:08:28 |
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 06 June 2001 : 10:00:06
|
geunsie
Having one problem here, and maybe you can help out. People who have picts in their sigs are not showing up, but instead showing up as <img src= ......>
Any ideas?
http://www.ugfl.net/forums |
|
|
|
geunsie
Starting Member
31 Posts |
Posted - 06 June 2001 : 18:25:28
|
quote:
geunsie
Having one problem here, and maybe you can help out. People who have picts in their sigs are not showing up, but instead showing up as <img src= ......>
Any ideas?
http://www.ugfl.net/forums
Try using the [img]picture url[/img ]in the signature ...that will work
and i think HTML must be ON.
Edited by - geunsie on 06 June 2001 18:29:01 |
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 06 June 2001 : 19:00:09
|
They are using the [img] tags in their signatures, but HTML is off....I'll look into turning HTML on, but that's something I don't necessairly want to do as it can cause problems.
Maybe I can find a workaround or 2.
Thanks
http://www.ugfl.net/forums |
|
|
|
Stormis ~§~
Starting Member
USA
3 Posts |
Posted - 15 June 2001 : 09:07:24
|
uhm... could someone translate this mod to stupid-ese for me?
i don't understand how to put it together, really, and I don't want to have to do what I'm doing right now (trying to piece my board back together after screwing something up severely with a mod) again...
but i've had requests for dynamic sigs, a la IkonBlah- er, IkonBoard.
if there are any solutions, dun hesitate to drag me around by my furry tail and show me :)
~SDKal
----
ooh, ****. I broke it...
- :: s d k ::, at 05:11 EDT
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 15 June 2001 : 20:09:50
|
good mod, but I think you need to change this:
<% =ChkString(rs("M_SIG"),"display") %>
to
<% =formatStr(rs("M_SIG")) %>
otherwise your signature with forum coding will get translated to html tags if members are using images.
Dayve |
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 17 June 2001 : 10:24:08
|
quote:
in topic.asp add/replace the red lines
<hr noshade size="<% =strFooterFontSize %>">
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><% =formatStr(rs("R_MESSAGE")) %>
<table valign="bottom" width=100% height=110 border=0>
<td valign="bottom"> <font size=1 color=#8080E0><% =ChkString(rs("M_SIG"),"display") %><TD align="right" valign="bottom">
</font>
<a href="#top"><img src="<%=strImageURL %>icon_go_up.gif" height=15 width=15 border="0" align="right" valign="bottom" alt="Go to Top of Page"></a></font></td></table></td>
</tr>
<%
rs.MoveNext
intI = intI + 1
if intI = 2 then
intI = 0
end if
rec = rec + 1
loop
end if
2 times
didn't you miss < tr> in your table? i think that's why the valign didn't work.
well i got problem:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/testarea/31sr4test_m/topic.asp, line 688
mine looks like this
<table valign="bottom" width=100% height=110 border=0>
<tr>
<td valign="bottom"> <font size=1 color=#8080E0><% =ChkString(rs("M_SIG"),"display") %></font></td>
</tr></table>
---------
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_LEVEL, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, "
'yx21b2: inserted code ################### State/Country Flags Mod Start #########################
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_STATE, "
'yx21b2: end insertion ################### State/Country Flags Mod End #########################
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
'yx40a3: inserted signature mod in the line below ################
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_SIG, "
'yx26d1: added 1 line below ##### avatar 2 mod ##########
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_AVATAR_URL, "
'yx26d1 ######################################
'yx33b: added 1 line below ##### private messages ##########
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_PMRECEIVE, "
'yx33b ######################################
strSql = strSql & strTablePrefix & "REPLY.REPLY_ID, "
when submit a post, after the post info displays, it also try to refresh but says cannot refresh without resubmiting info.
i have some other mod installed as well, don't know why this happens.
I don't know how to
"remove and disable the signature option is post.asp."
I guess the problem is caused by not editing post.asp. any body tell me how?
thanks.
Edited by - bjlt on 17 June 2001 10:28:11
Edited by - bjlt on 17 June 2001 10:53:07 |
|
|
|
Topic |
|
Topic Locked
