| Author |
 Topic  |
|
Traverer
New Member
Malaysia
61 Posts |
 Posted - 05 December 2001 : 03:53:25
|
Title: Sticky Note (or Forum Sticker) MOD for Snitz Forums
Version: 1.05
Snitz Forums: 3.3.03
Database: Access 2000
Description: Add a small sticky note at the top of each forum.
Author: Traverer
E-Mail: traverer@yahoo.com
Demo: http://www10.brinkster.com/snitzdemo/
Download:
Snitz Modfications Resource - http://freeaspcode.net/snitz/default.asp
Ls3k Snitz Exchange - http://www.ls3k.com/snitz/default.asp
Features:
-Support Forum Code and HTML.
-Show Moderator(s) name below the sticker.
-message from topic can be inserted into sticker.
History:
*V1.05*
-Enable topic message to be insert into sticker.
-Add predefined width support for sticker message.
-The horizontal bar will not shown if no sticker message available.
*V1.04*
-Tune the HTML support.
-Fix possible security issue.
-Change database type, current user will not be affected.
*V1.03*
-Change the name from Forum Sticker to Sticky Note
-Now you can hide the sticker from the members.
-You can use HTML in sticker without have to turn on HTML support for the forum.
-Some minor change to the code.
-Add a new file for preview purpose.
*V1.02*
-Fix error when creating new forum.
-If you are using v1.01 or v1.00, download the fix from my download page above.
*V1.01*
-Fix typing error in the text file.
*V1.00*
-Initial release.
FAQ:
1. How do I edit the sticker message ?
-Log in as a admin or moderator, then enter the forum you wish to edit the message.
-You should able to see your sticker message at the top of your forum with a small
EDIT button at the right top corner of it.
-Click the button to edit it.
2. How do I input the topic message into sticker ?
-Log in as a admin or moderator, then go to the topic you want.
-You should able to see a new link "Add to Forum Sticker" below the "New Topic" link.
-Click the link to input the topic message to your sticker editor menu and edit it to
your desired format.
-BEWARE !!! Your previous sticker message will be replaced with the new one you add.
3. I edit a topic message after I add it to sticker but the sticker message does not
updated to meet the change ?
-The sticker display what you add from the topic and not directly from the topic.
-If you want to update the sticker with the change, you have to do it manually by
add the topic to the sticker againt.
4. I log in as a moderator but I do not see any edit button nor link ?
-Sorry, you can only edit sticker and add topic from the forum you moderate.
-You will not see the edit button and link from other forum that not moderated by you.
-If you log in as an admin, you should able to see the button and link from all forums.
5. Can I put Flash, Script and other stuff in the sticker ?
-Sure, the HTML support is always turn on even if you disable HTML feature for you
entire forum.
-If you really want to disable it, you have to change the code manually by editing the
post_sticker_info.asp file.
Thanks for using this Mod. Enjoy 
Edited by - Traverer on 18 February 2002 09:45:31
Edited by - Traverer on 19 February 2002 11:52:44
Edited by - Traverer on 19 February 2002 12:10:59
Edited by - Traverer on 19 April 2002 23:22:14 |
|
|
tcharles
Starting Member
USA
24 Posts |
Posted - 05 December 2001 : 17:51:47
|
Traverer, Thanks for bringing this mod back. Been waiting since the big crash to have this interesting topic (and some others) restored.
Edited by - tcharles on 05 December 2001 17:52:46 |
 |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 05 December 2001 : 18:36:57
|
I think I remember this being a mod before but do you have a demo link?
____________
dayve
http://forum.nineinchnailz.com |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 December 2001 : 20:35:36
|
There is another simple way of adding the Sticker without any modification to the database:
Create a text file and write the message you want to display for the forum.
The messages should be in sequence 1,2,3,4...
forumsticker.txt
""[Tab]This is forum with id 1[Tab]comments Forum ID 1
""[Tab]This is forum with id 2[Tab]comments Forum ID 2
....
Insert the following where you want to display the forum sticker in forum.asp
Set NextLink = Server.CreateObject ("MSWC.NextLink")
Response.write NextLink.GetNthDescription("/forum/forumsticker.txt", ForumID)
GauravBhabu - It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 December 2001 : 20:44:43
|
Another alternate is as below:
The case statements can really grow. But I use Forum description to display the Message.
Add the code below to the end of forum.asp
<%
Sub ForumSticker(fForumID)
if fForumId = "" then exit sub
Response.Write vbNewLine & _
"<Img src =""" & strImageURL & "icon_mi_9.gif" & """>" & vbNewLine
Select Case fForumID
Case 1
Response.Write vbNewLine & _
"MESSAGE<br>" & vbNewLine
Case 2 Response.Write vbNewLine & _
"MESSAGE<br>" & vbNewLine
Case else
Response.Write rsFStatus("F_DESCRIPTION") & "<br>" & vbNewLine
end select
end sub%>
Then add this code below the Folder Navigation Menu in forum.asp
<%
Response.write vbNewLine & _
"<tr>" & vbCrLf & _
" <td Class=HeadFooter align=""left"" colspan=""3"">" & vbCrLf
Call ForumSticker(Request.QueryString("FORUM_ID"))
Response.write vbNewLine & _
"<Img src =""" & strImageURL & "icon_edit_mod.gif" & """>" & vbNewLine & _
" </td>" & vbCrLf & _
"</tr>" & vbCrLf
%>
You will need to change the statements in red as per the formatting of columns in your forum.asp
GauravBhabu - It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 05 December 2001 21:09:21 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 05 December 2001 : 21:55:45
|
Adding Column F_STICKER...
Column added successfully
--------------------------------------------------------------------------------
Adding Column S_STICKER...
ALTER TABLE FORUM_FORUM ADD S_STICKER ntext NULL DEFAULT 0
-2147217913 | [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: int is incompatible with ntext
Test Site:
EastPasco Huw's Code 3.3.10 SQL 2000
Snitz Mod Resource
Email |
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 05 December 2001 : 23:07:09
|
I followed the instruction, and have everything setup sucessfully. But I can't find any places to set a topic as a sticky topic. :/ It there a button, or a check to check when we post a new topic???
In these days of computer viruses, asking if you may put your disk into someone's computer is the technological equivalent of unsafe sex. |
|
|
|
Traverer
New Member
Malaysia
61 Posts |
Posted - 06 December 2001 : 03:39:26
|
Thanks for all your comments and I really appreciate it .
So far I just test this mod with Access 2000 only and I do not know whether it works with MS SQL and My SQL or not. If it works, please tell me.
I have no online demo site yet but I have put up a screenshot link in my download page, you can go there and see.
GauravBhabu, thanks for your suggestion about sticker idea but I would like to make the sticky message could be edited easily online without have to edit it manually.
Kenno, you need to login as admin first then search for the edit button on the top right side of your forum. This mod does not give you the ability to create sticky topic but enable you to write a sticky message on top of all forum topic. Please go the the screenshot link above and you will know what I mean.
rick7165, do you use MS SQL ? I never try MS SQL but below is my dbs_sticky_note.asp code :
Sticky Note Mod
[ALTER]
FORUM
ADD#F_STICKER#memo#NULL##
[END]
[ALTER]
FORUM
ADD#S_STICKER#memo#NULL#0#
[END]
Hope anyone who know MS SQL will identify the problem for you or maybe there is an error in my code above
Try to change the 0 above to 1 and update it againt...
Traverer is here.
Edited by - Traverer on 06 December 2001 03:43:56 |
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 06 December 2001 : 04:06:47
|
Thanks, I firgured out how to work it now.
In these days of computer viruses, asking if you may put your disk into someone's computer is the technological equivalent of unsafe sex. |
|
|
|
Morten
Junior Member
Denmark
251 Posts |
Posted - 06 December 2001 : 05:08:05
|
Thanks, this mod works great. Absolut excellent readme file, are you a student of Richard Kinser ?
Morten
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
|
|
Traverer
New Member
Malaysia
61 Posts |
Posted - 06 December 2001 : 09:49:49
|
I do not have MS SQL so I can not test it for you but you could try to replace the code in dbs_sticky_note.asp with below and update it againt:
Sticky Note Mod
[ALTER]
FORUM
ADD#F_STICKER#memo#NULL##
[END]
[ALTER]
FORUM
ADD#S_STICKER#memo#NOT NULL#0#
[END]
If not success, try this:
Sticky Note Mod
[ALTER]
FORUM
ADD#F_STICKER#memo#NULL##
[END]
[ALTER]
FORUM
ADD#S_STICKER#varchar(100)#NULL#0#
[END]
or
Sticky Note Mod
[ALTER]
FORUM
ADD#F_STICKER#memo#NULL##
[END]
[ALTER]
FORUM
ADD#S_STICKER#varchar(100)#NOT NULL#0#
[END]
Hope you do not mind
Traverer is here. |
|
|
|
AdamS
Starting Member
22 Posts |
Posted - 06 December 2001 : 11:01:46
|
[quote]
I followed the instruction, and have everything setup sucessfully. But I can't find any places to set a topic as a sticky topic. :/ It there a button, or a check to check when we post a new topic???
I'd like to know this too. i cant figure it out either
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 06 December 2001 : 11:38:14
|
Sorry... I got it to work but didn't post back here yet... For SQL it's:
Sticky Note Mod
[ALTER]
FORUM
ADD#F_STICKER#memo#NULL##
[END]
[ALTER]
FORUM
ADD#S_STICKER#varchar(100)#NULL#0#
[END]
Test Site:
EastPasco Huw's Code 3.3.10 SQL 2000
Snitz Mod Resource
Email |
|
|
|
Traverer
New Member
Malaysia
61 Posts |
Posted - 06 December 2001 : 11:54:04
|
Thanks,Morten. I take other mod readme file as reference when I write one for this mod.
AdamS, you need to login as admin first then search for the edit button on the top right side of your forum. This mod does not give you the ability to create sticky topic but enable you to write a sticky message on top of all forum topic. Please go the the screenshot link above and you will know what I mean.
Thanks rick7165, I will try it with Access and may finally swicth the data type from memo to varchar for S_STICKER .
Traverer is here. |
|
|
|
AdamS
Starting Member
22 Posts |
Posted - 06 December 2001 : 12:06:48
|
ok, can u explain it to someone like me who doesn;t know about code, and just copies and pastes? I'm usng access for my database.
can u tell me what i need to copy and paste, and into where, so that i can use the sticky feature when making a post?
|
|
|
|
Topic |
|
Topic Locked
