| Author |
 Topic  |
|
Aaron Cake
Starting Member
Canada
16 Posts |
 Posted - 21 March 2001 : 21:34:58
|
I'm using the Access 97 string. Sorry, should have mentioned it.
Jet 4 is not installed on my system as my mail server relies on version 3 and I don't want to break it. Can I work around the problem by manually modifying the database?
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 March 2001 : 22:58:26
|
The Message Icons MOD comes with 2 different setup scripts.
When you run the mod_dbsetup.asp file choose this one in the dropdown box:
Message Icons Mod for Access97 Connectstring |
|
|
|
Aaron Cake
Starting Member
Canada
16 Posts |
Posted - 22 March 2001 : 11:05:26
|
I did.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 March 2001 : 11:27:54
|
| Manually modifying the database would be the best solution for you then. |
|
|
|
Aaron Cake
Starting Member
Canada
16 Posts |
Posted - 22 March 2001 : 16:40:15
|
OK. What do I need to do? :)
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 March 2001 : 20:42:18
|
In the FORUM_TOPICS table add a new field named T_MSGICON of type Number with a default of 1
In the FORUM_REPLY table add a new field named R_MSGICON of type Number with a default of 1 |
|
|
|
zodc
Starting Member
Japan
16 Posts |
Posted - 24 March 2001 : 05:31:18
|
I've installed your message icon mod, Thank You!
All went well except one thing...
When I "reply" to a message, the icon file name always ends with 0 (zero).
When I "post" a message, the appropriate one shows.
Can you help ???
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 March 2001 : 05:58:18
|
In post_info.asp:
change this code:
strSql = strSql & ", R_MSGICON"
strSql = strSql & ", R_MAIL"
strSql = strSql & ", R_MESSAGE"
to this:
strSql = strSql & ", R_MAIL"
strSql = strSql & ", R_MSGICON"
strSql = strSql & ", R_MESSAGE"
|
|
|
|
zodc
Starting Member
Japan
16 Posts |
Posted - 24 March 2001 : 10:24:39
|
Thank You for the quick reply, and solution!
 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 March 2001 : 13:58:58
|
you're welcome  |
|
|
|
Aaron Cake
Starting Member
Canada
16 Posts |
Posted - 26 March 2001 : 10:06:02
|
quote:
In the FORUM_TOPICS table add a new field named T_MSGICON of type Number with a default of 1
In the FORUM_REPLY table add a new field named R_MSGICON of type Number with a default of 1
Thanks! Worked great.
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 31 March 2001 : 13:03:22
|
Hi Richard,
Thanks for another easy to implement mod... finally got around to installing and it worked without difficulties (on my heavy moded sr2 forum)
One question though. I'm building a tech support forum and it would be cool to have another half dozen or so icons for things like: Bug Notification, Bug Fix, New Release Announcement, Downloadable item, New Feature Idea (COuld use the Idea Light)... anyway you get the picture....
It seems that one could do this easily, by adding a few more icons and changing the code in post.asp, at this section:
<% ' *** MESSAGE ICONS MODIFICATION *** START
if strRqMethod = "Reply" or _
strRqMethod = "ReplyQuote" or _
strRqMethod = "Topic" or _
strRqMethod = "TopicQuote" then
%>
<tr>
<td bgColor="<% =strPopUpTableColor %>" noWrap vAlign="top" align="right"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><b>Message Icon:</b></font></td>
<td bgColor="<% =strPopUpTableColor %>" vAlign="top"><input type="radio" class="radio" name="strMessageIcon" value="1" <% Response.Write(" checked") %>> <img src="icon_mi_1.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="2"> <img src="icon_mi_2.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="3"> <img src="icon_mi_3.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="4"> <img src="icon_mi_4.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="5"> <img src="icon_mi_5.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="6"> <img src="icon_mi_6.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="7"> <img src="icon_mi_7.gif" border="0"><br>
<input type="radio" class="radio" name="strMessageIcon" value="8"> <img src="icon_mi_8.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="9"> <img src="icon_mi_9.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="10"> <img src="icon_mi_10.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="11"> <img src="icon_mi_11.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="12"> <img src="icon_mi_12.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="13"> <img src="icon_mi_13.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="14"> <img src="icon_mi_14.gif" border="0"></td>
</tr>
<% end if ' *** MESSAGE ICONS MODIFICATION *** END %>
Could I just add a few more of:
<input type="radio" class="radio" name="strMessageIcon" value="15"> <img src="icon_mi_15.gif" border="0">
15, 16, 17 etc...
I took a quick look at the code... this should do it right? Have I forgotten anything?
Also, an idea for a "version 2" would be to put the icons in a db, add an admin page, and let people manage (add and give names), the topic icons so that different forums can have different topic icons. I have to imagine that a topic icon for a gaming forum is going to be totally different then a tech support site, or a music related forum.
Thanks again!
Cheers!
Rob Poretti 
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 31 March 2001 : 13:11:23
|
Hey Rob... That's right.
I've added more to one of my sites
Mine looks like this:
if strRqMethod = "Reply" or _
strRqMethod = "ReplyQuote" or _
strRqMethod = "Topic" or _
strRqMethod = "TopicQuote" then
%>
<tr>
<td bgColor="<% =strPopUpTableColor %>" noWrap vAlign="top" align="right"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><b>Message Icon:</b></font></td>
<td bgColor="<% =strPopUpTableColor %>" vAlign="top"><input type="radio" class="radio" name="strMessageIcon" value="1" <% Response.Write(" checked") %>> <img src="<% =strImageURL %>icon_mi_1.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="2"> <img src="<% =strImageURL %>icon_mi_2.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="3"> <img src="<% =strImageURL %>icon_mi_3.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="4"> <img src="<% =strImageURL %>icon_mi_4.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="5"> <img src="<% =strImageURL %>icon_mi_5.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="6"> <img src="<% =strImageURL %>icon_mi_6.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="7"> <img src="<% =strImageURL %>icon_mi_7.gif" border="0"><br>
<input type="radio" class="radio" name="strMessageIcon" value="8"> <img src="<% =strImageURL %>icon_mi_8.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="9"> <img src="<% =strImageURL %>icon_mi_9.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="10"> <img src="<% =strImageURL %>icon_mi_10.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="11"> <img src="<% =strImageURL %>icon_mi_11.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="12"> <img src="<% =strImageURL %>icon_mi_12.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="13"> <img src="<% =strImageURL %>icon_mi_13.gif" border="0"> <input type="radio" class="radio" name="strMessageIcon" value="14"> <img src="<% =strImageURL %>icon_mi_14.gif" border="0"><br>
<input type="radio" class="radio" name="strMessageIcon" value="15"> <img src="<% =strImageURL %>icon_mi_15.gif" border="0"><input type="radio" class="radio" name="strMessageIcon" value="16"> <img src="<% =strImageURL %>icon_mi_16.gif" border="0"><input type="radio" class="radio" name="strMessageIcon" value="17"> <img src="<% =strImageURL %>icon_mi_17.gif" border="0"><input type="radio" class="radio" name="strMessageIcon" value="18"> <img src="<% =strImageURL %>icon_mi_18.gif" border="0"><input type="radio" class="radio" name="strMessageIcon" value="19"> <img src="<% =strImageURL %>icon_mi_19.gif" border="0"><input type="radio" class="radio" name="strMessageIcon" value="20"> <img src="<% =strImageURL %>icon_mi_20.gif" border="0"></td>
</tr>
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 31 March 2001 13:14:31 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 31 March 2001 : 13:17:45
|
quote:
I took a quick look at the code... this should do it right? Have I forgotten anything?
No, you haven't forgotten anything. Just use the existing code as an example and add as many more as you like.
quote:
Also, an idea for a "version 2" would be to put the icons in a db, add an admin page, and let people manage (add and give names), the topic icons so that different forums can have different topic icons. I have to imagine that a topic icon for a gaming forum is going to be totally different then a tech support site, or a music related forum.
I was trying to keep this as simple as possible. All that is needed to use different icons is to just name them icon_mi_##.gif where ## is a unique #, and overwrite (or add to) the current icons. That way the images are already customizable. |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 31 March 2001 : 18:16:06
|
Yes true, simpler is better! Changing icon names to customize is really trivial...
Thanks again for a great mod
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960
BTW, does anyone know What has been going on with the Snitz Forum???!!! The other day it seemed that it was down for the better part of the afternoon and today I had some trouble making a earlier post. It would time out.
Edited by - Rob Poretti on 31 March 2001 18:18:55 |
|
|
|
Topic |
|
Topic Locked
