Snitz Forums 2000 - MOD: Guestbook v3.4 (Snitz v3.4)

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/Code)

MOD: Guestbook v3.4 (Snitz v3.4)

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 2

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 28 August 2004 : 19:20:16

Title: Guestbook
Version: v3.4 for Snitz Forums v3.4
Author: Michael Reisinger (OneWayMule)
Last Update: October 9, 2004

Description:
Adds a guestbook to your forum.

Features:
- Allows your visitors to leave a message without registering
- Edit/delete messages
- Enable/disable 3 additional fields
- Optional Thank You email
- Optional email notification sent to admin
- Secure administration area
- Use Forum Code
- Easy installation
- A file for automatic database upgrade included
- All code done in response.write for Snitz v3.4 compatability

Installation Instructions:
Included in the .zip file and available here.

Support:
If you have problems installing this MOD, either post your questions in the Help: MOD Implementation forum or here.

Download:
Guestbook v3.4 for Snitz Forums v3.4

Demo:
http://www.onewaymule.org/onewayscripts/forums/guestbook.asp

More info available at:
http://www.onewaymule.org/onewayscripts/mods/guestbook/

Feedback:
Suggestions, comments, questions and bug reports are greatly appreciated!

Updates:
- 09-Oct-2004: bug fixes
- 06-Sep-2004: bug fixes, see this post

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz

Edited by - OneWayMule on 09 October 2004 02:57:14

Etymon
Advanced Member

United States
2385 Posts

Posted - 29 August 2004 : 17:02:56

Thank you for the code, OneWayMule!

I am looking forward to opening it up and seeing what you've done!

Thanks again,

Etymon

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 29 August 2004 : 17:25:49

Thanks, Etymon, I hope you like it!

Etymon
Advanced Member

United States
2385 Posts

Posted - 29 August 2004 : 20:57:21

You're welcome, OneWayMule! I think I will!

I was talking to my wife about whether or not to add a guestbook to one of our sites. We weren't sure. You just don't see them on the web too much anymore.

Then I thought about it again, and I remembered, that you write some very nice MODs. So, I said to myself, "I think I'll give it a try." Besides, there are still folks out there who don't want to become a member just to say "Hi" or "Thanks". And there others who don't know much about the web, and a forum is intimidating or mind-boggling. I think a guestbook is a good way to go for these surfers!

Thanks again,

Etymon

finsklapphundkl
Starting Member

47 Posts

Posted - 06 September 2004 : 02:36:55

Followed the readme.html, but the guestbook do not work:
>
>The page cannot be displayed
>There is a problem with the page you are trying to reach and it cannot be displayed.
>
>-----------------------------------------------------------------------
>---------
>
>Please try the following:
>
>Click the Refresh button, or try again later.
>
>Open the www.finsklapphundklubb.org home page, and then look for links
>to the information you want.
>HTTP 500.100 - Internal Server Error - ASP error
>Apache
>
>-----------------------------------------------------------------------
>---------
>
>Technical Information (for support personnel)
>
>Error Type:
>ADODB.Recordset.1 (0x80004005)
>SQLState: S1000 Native Error Code: 1146 [TCX][MyODBC]Table
>'finsklapphundkl.FORUM_GB_OPTIONS' doesn't exist
>inc_header.asp, line 560
>
>Browser Type:
>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
>
>Page:
>GET /Hovedforum/guestbook.asp
>
>Time:
>Friday, September 03, 2004, 3:55:29 PM
>
>More information:
>Sun ONE Active Server Pages Support

finsklapphundkl
Starting Member

47 Posts

Posted - 06 September 2004 : 02:38:13

The problem is that the FORUM_GB_OPTIONS table could not be found in the database. Did you run the MOD Setup (any errors popped up)?

Kind Regards,

OneWayMule

finsklapphundkl
Starting Member

47 Posts

Posted - 06 September 2004 : 02:39:57

Running the MOD-setup:

MOD: Guestbook v3.4

Dropping Table..

Table dropped succesfully
--------------------------------------------------------------------------------

Dropping Table..
DROP TABLE FORUM_GB_OPTIONS
-2147467259 | SQLState: S1000 Native Error Code: 1051 [TCX][MyODBC]Unknown table 'FORUM_GB_OPTIONS'

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_NAME varchar (50) NULL , G_EMAIL varchar (100) NULL , G_WEBSITE varchar (100) NULL , G_ICQ varchar (30) NULL , G_MESSAGE text NOT NULL , G_DATE varchar (50) NOT NULL , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL ,KEY FORUM_GUESTBOOK_G_ID(G_ID))
CREATE TABLE FORUM_GUESTBOOK( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_NAME varchar (50) NULL , G_EMAIL varchar (100) NULL , G_WEBSITE varchar (100) NULL , G_ICQ varchar (30) NULL , G_MESSAGE text NOT NULL , G_DATE varchar (50) NOT NULL , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL ,KEY FORUM_GUESTBOOK_G_ID(G_ID))
9 | Subscript out of range

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL , G_V1_SWITCH int NULL , G_V2_SWITCH int NULL , G_V3_SWITCH int NULL , G_MESSAGE text NULL , G_V1_REQ int NOT NULL DEFAULT 0, G_V2_REQ int NOT NULL DEFAULT 0, G_V3_REQ int NOT NULL DEFAULT 0, G_PAGECOUNT int NOT NULL DEFAULT 0, G_T_MAIL int NOT NULL DEFAULT 0, G_W_MAIL int NOT NULL DEFAULT 0, G_T_AUTHOR varchar (150) NOT NULL DEFAULT 0, G_T_REPLYTO varchar (150) NOT NULL DEFAULT 0, G_T_MESSAGE text NOT NULL DEFAULT 0,KEY FORUM_GB_OPTIONS_G_ID(G_ID))
CREATE TABLE FORUM_GB_OPTIONS( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL , G_V1_SWITCH int NULL , G_V2_SWITCH int NULL , G_V3_SWITCH int NULL , G_MESSAGE text NULL , G_V1_REQ int NOT NULL DEFAULT 0, G_V2_REQ int NOT NULL DEFAULT 0, G_V3_REQ int NOT NULL DEFAULT 0, G_PAGECOUNT int NOT NULL DEFAULT 0, G_T_MAIL int NOT NULL DEFAULT 0, G_W_MAIL int NOT NULL DEFAULT 0, G_T_AUTHOR varchar (150) NOT NULL DEFAULT 0, G_T_REPLYTO varchar (150) NOT NULL DEFAULT 0, G_T_MESSAGE text NOT NULL DEFAULT 0,KEY FORUM_GB_OPTIONS_G_ID(G_ID))
-2147467259 | SQLState: S1000 Native Error Code: 1101 [TCX][MyODBC]BLOB column 'G_T_MESSAGE' can't have a default value

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_GB_OPTIONS (G_VARFIELD1, G_VARFIELD2, G_VARFIELD3, G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_MESSAGE, G_V1_REQ, G_V2_REQ, G_V3_REQ, G_PAGECOUNT, G_T_MAIL, G_W_MAIL, G_T_AUTHOR, G_T_REPLYTO, G_T_MESSAGE) VALUES ('State', 'Country', 'Age', 1, 1, 1, 'Thank you for signing my Guestbook', 0, 0, 0, 10, 0, 0, 'Admin', 'you@yourdomain.com', 'Thank you for signing my Guestbook')
INSERT INTO FORUM_GB_OPTIONS (G_VARFIELD1, G_VARFIELD2, G_VARFIELD3, G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_MESSAGE, G_V1_REQ, G_V2_REQ, G_V3_REQ, G_PAGECOUNT, G_T_MAIL, G_W_MAIL, G_T_AUTHOR, G_T_REPLYTO, G_T_MESSAGE) VALUES ('State', 'Country', 'Age', 1, 1, 1, 'Thank you for signing my Guestbook', 0, 0, 0, 10, 0, 0, 'Admin', 'you@yourdomain.com', 'Thank you for signing my Guestbook')
-2147467259 | SQLState: S1000 Native Error Code: 1146 [TCX][MyODBC]Table 'finsklapphundkl.FORUM_GB_OPTIONS' doesn't exist

--------------------------------------------------------------------------------

If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 06 September 2004 : 02:59:19

I'll take a look at it, thanks.

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 06 September 2004 : 03:23:17

I have successfully tested the installation with MySQL, in a Windows enviroment only though, without any problems.
As soon as I have more info about this problem, I'll let you know.

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 06 September 2004 : 05:06:04

Zip file updated with 2 bug fixes (more info here and here).
Please redownload and replace your admin_guestbook.asp and guestbook.asp with the files from the zip.

finsklapphundkl
Starting Member

47 Posts

Posted - 06 September 2004 : 05:54:32

Done that, same errormessage.

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 06 September 2004 : 05:56:46

quote:
Originally posted by finsklapphundkl

Done that, same errormessage.

I don't have a fix for your problem yet, sorry.
Will let you know as soon as I have.

tribaliztic
Senior Member

Sweden
1532 Posts

Posted - 07 September 2004 : 04:34:29

Would it be much work to make this "one user only"-guestbook? Like a blog, that a user can have in the user profile. The user should be the only one able to write, but all users should be able to read.
I was thinking of doing this with the "old" guestbook, but your updated seems better =)

/Tribaliztic
- www.gotlandrace.se -

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 07 September 2004 : 04:38:35

Hmm, I don't think it would be a good idea to use the Guestbook code for a Blog MOD.

I already thought about a Blog MOD, and it would actually be fairly easy to do, by simply using the standard Snitz topics code (something like the News Forum MOD).

tribaliztic
Senior Member

Sweden
1532 Posts

Posted - 07 September 2004 : 04:46:26

yeah, I thought about that too, but don't it require a forum or a topic to work?
If each user could automatically have a topic they could add an answer to each time they want to update the blog it would be pretty easy. BUT, those topic's should only be visible in their profiles and nowhere else...

/Tribaliztic
- www.gotlandrace.se -

Image
Average Member

Canada
574 Posts

Posted - 10 September 2004 : 17:08:52

In GuestBook

Add Tag </font>

				"                 <td bgcolor=""" & strHeadCellColor & """ align=""left"" colspan=""2"" class=""header""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strCategoryFontColor & """>" & vbNewLine & _
				"		  <b>Signatures</b>" & vbNewLine & _
				"		  </font>" & vbNewLine & _
				"		  </td>" & vbNewLine & _

					"                  <font color=""" & strCategoryFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b><span class=""spnMessageText"">" & ChkString(strTempName,"display") & "</span></b></font>" & vbNewLine & _

Line 372 replace
If strGBField1Req = 1 Then

With
If strGBField3Req = 1 Then

In sub DropDownPaging
Delete

				"                <input name=""FORUM_ID"" type=""hidden"" value=""" & Forum_ID & """>" & vbNewLine & _

Replace

If strGBField1Req = 1 and trim(strFormField1) = "" Then
		Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
	End If
        If strGBField2Req = 1 and trim(strFormField2) = "" Then
		Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
	End If
        If strGBField3Req = 1 and trim(strFormField3) = "" Then
		Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
	End If

With

If strGBField1Req = 1 and trim(strFormField1) = "" Then
		Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
	End If
        If strGBField2Req = 1 and trim(strFormField2) = "" Then
		Err_Msg = Err_Msg & "<li>Please enter your " & strGBField2 & "</li>" & vbNewLine
	End If
        If strGBField3Req = 1 and trim(strFormField3) = "" Then
		Err_Msg = Err_Msg & "<li>Please enter your " & strGBField3 & "</li>" & vbNewLine
	End If

In Admin guestbook

Replace

	If strGBField1Req = 1 and trim(strFormField1) = "" Then
			Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
		End If
	        If strGBField2Req = 1 and trim(strFormField2) = "" Then
			Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
		End If
        	If strGBField3Req = 1 and trim(strFormField3) = "" Then
			Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
		End If

With

	If strGBField1Req = 1 and trim(strFormField1) = "" Then
			Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
		End If
	        If strGBField2Req = 1 and trim(strFormField2) = "" Then
			Err_Msg = Err_Msg & "<li>Please enter a " & strGBField2 & "</li>" & vbNewLine
		End If
        	If strGBField3Req = 1 and trim(strFormField3) = "" Then
			Err_Msg = Err_Msg & "<li>Please enter a " & strGBField3 & "</li>" & vbNewLine
		End If

And Big Bug With Edit and Delete onclick icon

I dont have these bug on my version

Page: of 2

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.28 seconds.