Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/59318?pagenum=1
05 November 2025, 03:13
Topic
OneWayMule
MOD: Guestbook v3.6 (Snitz v3.4)
05 September 2005, 19:01
Title: Guestbook Version: v3.6 for Snitz Forums v3.4 Author: Michael Reisinger (OneWayMule) Last Update: November 1, 2005
New In This Version:
- Antispam Confirmation (optional via admin area) - Admins can now approve/delete all unmoderated entries with one click
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 - Optional Moderation - IP Logging - Optional Antispam Confirmation (new!)
- 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.6 for Snitz Forums v3.4 Live 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! <
Replies ...
AnonJr
05 September 2005, 21:45
Looks good. Now I've got another MOD to add... and glad for it! <
Classicmotorcycling
06 September 2005, 07:03
Real easy to put online. Had to take the old one offline as I was being spammed on it. Love the new features OWM.. Great work again.<
OneWayMule
06 September 2005, 08:05
Originally posted by Classicmotorcycling Real easy to put online. Had to take the old one offline as I was being spammed on it. Love the new features OWM.. Great work again.
Thanks, David, glad you like it. <
Classicmotorcycling
07 September 2005, 02:01
Yes, always like your mods.
Just on a fresh install I did notice that after the dbs_guestbook.asp was ran, I needed to run the dbs_guestbook_v34-to-v35.asp.
Also there was no install instructions in the zip.<
Nertz
07 September 2005, 08:57
upgrade from 3.4 to 3.5 works well. Moderation feature is great, but I'd like to change when the thank you email is sent. Right now it's sent when the guest submits the entry (before moderation), and I'd like sent when entry is accepted (after moderation and only to those whose entries are accepted).
cheers, Nat<
OneWayMule
07 September 2005, 12:06
Originally posted by Nertz upgrade from 3.4 to 3.5 works well. Moderation feature is great, but I'd like to change when the thank you email is sent. Right now it's sent when the guest submits the entry (before moderation), and I'd like sent when entry is accepted (after moderation and only to those whose entries are accepted).
cheers, Nat
Good idea, will be added to the code later today.<
Classicmotorcycling
07 September 2005, 18:10
That is a great idea...
Originally posted by Nertz Moderation feature is great, but I'd like to change when the thank you email is sent. Right now it's sent when the guest submits the entry (before moderation), and I'd like sent when entry is accepted (after moderation and only to those whose entries are accepted).
This sort of guestbook function makes it gold... <
OneWayMule
07 September 2005, 18:27
OK, DBS file (dbs_guestbook.asp) corrected, and changed the code to send an email notification on approval (thanks Nat).
For those who already have v3.5 installed, simply overwrite your admin_guestbook.asp and guestbook.asp files.
Thanks for the feedback everyone! <
Classicmotorcycling
08 September 2005, 04:19
I do not know if it is me, but the approval is not working in the code for some reason. Sorry OWM...
<
OneWayMule
08 September 2005, 07:08
What exactly isn't working?
Do you get any errors?<
Classicmotorcycling
09 September 2005, 05:28
Sorry dude, Everytime I go to click on the link to approve new entries where it states "((how many) entries awaiting approval)" I click on the link and it does a refresh of the page with the call in the URL (forum/guestbook.asp?action=view&method=approve).
Originally posted by OneWayMule What exactly isn't working?
Do you get any errors?
There is no errors shown or anything, just like a refresh of the page. Is there something different in the new code?<
navigatore
09 September 2005, 09:40
Hello.
I have translated this MOD in Italian. This is the topic for the download:
Originally posted by Classicmotorcycling Sorry dude, Everytime I go to click on the link to approve new entries where it states "((how many) entries awaiting approval)" I click on the link and it does a refresh of the page with the call in the URL (forum/guestbook.asp?action=view&method=approve).
There is no errors shown or anything, just like a refresh of the page. Is there something different in the new code?
The link "x entries awaiting approval" lists all unapproved entries...
To approve entries, you have to click the icon and confirm the approval.
I'll post an update soon, with the HTML fix Image posted (thanks) and additional moderation features (approve all/delete all unapproved entries).<
Classicmotorcycling
09 September 2005, 16:59
OK, after some investigations from me, I have worked out why I am getting the error I am. It appears that the Guestbook requires at least 1 viewable entry in it before moderation is enabled. Once the first entry is in from a fresh install, the guestbook works great.<
OneWayMule
09 September 2005, 17:36
OK, thanks for the info, David.<
Nertz
13 September 2005, 13:21
Since re-activating the guestbook on our church site with OWM's new ver. 3.5, I've been getting several guestbook posts pending approval with objectionable material posted. These of course were deleted immediately, but checking the IP addresses from the posts at www.dnsstuff.com revealed most came from hosts on banned lists known to run automated scripts for creating spam. Wonder if anyone else who's installed guestbook 3.5 have run into this situation?
If these were indeed created by automated scripts, and only time will tell, I thought to adapt RGrund's Anti-Spam Registration mod to the guestbook... demo here, no registration required.
If anyone is interested, I'll post the code after I'm done testing and had a chance to sanitize it.
cheers, Nat <
OneWayMule
13 September 2005, 16:53
If these were indeed created by automated scripts, and only time will tell, I thought to adapt RGrund's Anti-Spam Registration mod to the guestbook... demo here, no registration required.
If anyone is interested, I'll post the code after I'm done testing and had a chance to sanitize it.
Definately interested, it won't harm to add it as an optional feature. I haven't found the time to work on the update (as I said above) yet, and I think the Anti-Spam MOD is a nice addition.
Thanks, Nat. <
OneWayMule
23 September 2005, 13:34
I'll do some work for the update (v3.5.1) this weekend, so if anyone has additional requests or suggestions, let me know.<
Scottie
26 October 2005, 15:37
Hi Michael, Great MOD.
In what table is the guestbook data stored?
Thanks! <
OneWayMule
26 October 2005, 16:00
FORUM_GUESTBOOK contains the guestbook entries (message, author, etc.) FORUM_GB_OPTIONS contains the configuration data
(FORUM_ is the default table prefix)<
OneWayMule
31 October 2005, 21:45
A new version (v3.6) is now available.
It includes the following new features: - Optional Antispam Confirmation (based on Robert Grunds Antispam Registration MOD) - Admins can now approve/delete all unmoderated entries with one click
Upgrade instructions from v3.4 and v3.5 of the MOD are included in the readme.
Enjoy.
Edit: Forgot to mention, includes the bug fixed posted here and here.<
dcwebman
03 November 2005, 08:48
My other guestbook program has been getting spammed lately so this looks like a great addition. I did see a couple things. I signed the demo guestbook with garbage for an email address and was thinking it might do some kind of validity checking. No big deal since it has moderation. The other thing is that I got the moderation message and then went to look at all the forums. In the guestbook Last Post column it showed my name even though it hadn't been approved yet. It might be a good idea to only put the last post that was approved in this column.<
OneWayMule
03 November 2005, 14:35
Originally posted by dcwebman My other guestbook program has been getting spammed lately so this looks like a great addition. I did see a couple things. I signed the demo guestbook with garbage for an email address and was thinking it might do some kind of validity checking. No big deal since it has moderation. The other thing is that I got the moderation message and then went to look at all the forums. In the guestbook Last Post column it showed my name even though it hadn't been approved yet. It might be a good idea to only put the last post that was approved in this column.
Thanks for your comments, Jeff.
I haven't updated the code on my forum main page yet, it still shows the info of all guestbook entries in the database, whether they are approved or not.
Since I plan to release the code as a tiny snippet for the users of this MOD I'll update the code then.<
Zaphod616
07 November 2005, 21:13
Hi, just want to say great mod and super easy to install cleanly. I have noticed one small issue though and not sure if its just something that I might be missing or what the problem is. If I have the anti-spam feature turned on, I dont get any display of the numbers to enter in the field provided. I've tried in both Firefox 1.7, IExplorer 5.5, both logged in as admin and as a general guest. In Firefox, I can see at least a few boxes where the numbers would be, but in Explorer I'm not seeing anything at all showing up. I dont have any other mod installed that would be using random numbers like that, so is there a prerequisite mod other then the guestbook mod that this would be reading from?
Thanks in advance for all your hard work. I've very seldom had to actually post questions because I can usually find the answers here already. Regards, Joe<
modifichicci
08 November 2005, 01:45
If you have MySql db try to change strGBAntispam = 1 to strGBAntispam = "1" in guestbook.asp (all the recurrences)<
richfed
08 November 2005, 06:17
Originally posted by Zaphod616 Hi, just want to say great mod and super easy to install cleanly. I have noticed one small issue though and not sure if its just something that I might be missing or what the problem is. If I have the anti-spam feature turned on, I dont get any display of the numbers to enter in the field provided. I've tried in both Firefox 1.7, IExplorer 5.5, both logged in as admin and as a general guest. In Firefox, I can see at least a few boxes where the numbers would be, but in Explorer I'm not seeing anything at all showing up. I dont have any other mod installed that would be using random numbers like that, so is there a prerequisite mod other then the guestbook mod that this would be reading from?
Thanks in advance for all your hard work. I've very seldom had to actually post questions because I can usually find the answers here already. Regards, Joe
Had the same problem ... you probably have your images in an image folder? If so, change line 58 on guestbook.asp to this:
Response.Redirect "images/" & ImageP & ".gif"<
Rocket468
08 November 2005, 09:50
If you move the include config file up you can use
Response.Redirect strImageUrl & ImageP & ".gif"
/guestbook.asp?action=sign is the search term these bots have been using on google, and yahoo. Might be other search engines too, buth these where used on my spaming.
Would it be worth the time to change the guestbook to action=post and then make action=sign redirect the ip to ipgate if installed?<
Zaphod616
08 November 2005, 10:35
Originally posted by richfed Had the same problem ... you probably have your images in an image folder? If so, change line 58 on guestbook.asp to this:
Response.Redirect "images/" & ImageP & ".gif"
Thanks Rich, that did it! I was starting to feel like an idiot because usually I can find whatever problem I seem to be having on here. As Shaggy says, "Search is your friend" lol. I'm not a real .asp jockey by any stretch so I going nuts trying to figure out the problem was. Thanks again for your help, I appreciate it! - Joe<
OneWayMule
08 November 2005, 14:06
Originally posted by modifichicci If you have MySql db try to change strGBAntispam = 1 to strGBAntispam = "1" in guestbook.asp (all the recurrences)
Umm.. haven't tested v3.6 on MySQL yet for some reason, will do that ASAP. Thanks for the info.<
Rocket468
08 November 2005, 14:14
I did not notice any problems with v3.6 under mysql.<
modifichicci
08 November 2005, 14:37
It depends on what version of MySql is running.
The strGBAntispam is memorized as an int and the right would be = 1, but in my mysql with that value I don't dispay the antispam table.
So I changed it to = "1" and all is working That is an issue I have noticed before, and in some topics on this forum, but I don't know why.
<
OneWayMule
08 November 2005, 14:38
OK, will take a look at it.
What MySQL version are you using, modifichicci?<
modifichicci
08 November 2005, 14:51
MySql 4.0.25 driver 3.51 I have also some other difficult with the admin_sigImage, with the functions that seem don't take the value of the rst.execute...
And with active users where I have had to redefine the value of ua before the function for the OS recognize..
<
navigatore
10 November 2005, 14:38
Hello.
I have translated the version 3.6 of this MOD in Italian.
This is the topic for the download:
How about adding something like this function below. I still get lots of spam to my guestbook. The anti-bot mod does not seem to help. Maybe it is smart enought to see the image name of the .gif and fill in the box.
dim hrefcount, MaxHref hrefcount = ubound(split(strMessage, "<a href", -1, 1)) If lngLoggedInUserID = 2 then MaxHref = 0 else MaxHref = 10 If hrefcount > MaxHref then strReturnCode = "maxH" strMessage = lngTopicID & "|" & intForumID & "|" & hrefcount & "|" & strMessage lngTopicID = 79 intForumID = 26 strMode = "reply" End If
<
tribaliztic
21 November 2005, 06:52
Hmm..
There's something not compatible with your mods and my server OWM =) Remember I had some problems with the FAQ administration mod? The same error appear here =) I get an error:
Kompileringsfel i Microsoft VBScript fel '800a0400'
Programsats förväntas.
/admin_guestbook.asp, line 439
Case "options_info" ^
Sorry it's in swedish but I suppose you understand anyways. I think the english version should be "Expected Statement". I also found this, but it won't help me:
I am still getting so much spam in my guestbook. It is a pain even to delete the un-approved messages from moderation function. I wonder if we should allow only logged in users to post to the guestbook?<
Classicmotorcycling
22 November 2005, 19:48
Then that defeats the purpose of a guestbook if only registered members can sign it...
Try playing with the code and the graphics. I am going to have the code need to be an odd ammount of numbers, I am also going to change the images to look like it is one big image and not be able to tell the numbers easy as I have change the numbers on Classic Motorcycling Australia and reduced some of it, but need to go further and change the required numbers and the images need to be done a little different and I am sure I can get it to almost none of that .nl and .de url posted spam..
<
Nertz
23 November 2005, 07:44
Originally posted by Classicmotorcycling Then that defeats the purpose of a guestbook if only registered members can sign it...
Try playing with the code and the graphics. I am going to have the code need to be an odd ammount of numbers, I am also going to change the images to look like it is one big image and not be able to tell the numbers easy as I have change the numbers on Classic Motorcycling Australia and reduced some of it, but need to go further and change the required numbers and the images need to be done a little different and I am sure I can get it to almost none of that .nl and .de url posted spam..
David, I'd be interested in what you do to improve the mod. I already have increased the number of numbers to 9, but it didn't improve on the amount of spam. One thing I did find though, you need to expire the anti-spam code. If you save the form page to your local drive, with a slight modification of the form element in the HTML you could resubmit the form with the identical anti-spam code over and over and it will post. It should only be used once and within a reasonable time.
cheers, Nat<
tribaliztic
29 November 2005, 04:17
I did some more googling on my error and found that it could be the script engines on the server that's not up to date. What version are you running on your win2k servers?
<
tribaliztic
29 November 2005, 06:26
I'm running JScript Version 5.6.8513 and the latest is 5.6.0.8825. Is this the problem?
(maybe I should start a new thread? =)) <
OneWayMule
02 December 2005, 10:09
I have to say that the Antispam works very well on my site, I've been getting down from 50+ entries per day to 1 or 2 per week.
I'll take a look at to fix that form-resubmission-glitch as soon as I find the time.
tribaliztic, I'll take a look at your issue as well, but next time please use the Help: MOD Implementation forum for bug reports and support requests as stated in the original post. Thanks.<
tribaliztic
03 December 2005, 02:47
Sorry!
Since I'm using SHN code I've posted over there also..
<
Sonic
03 December 2005, 05:11
for users who use the antispam code on ver. 3.6 please read --> http://forum.snitz.com/forum/topic.asp?TOPIC_ID=60349<
rjeffres
23 December 2005, 17:56
Was this mod changed to send the Notification Email only after signaures are approved? I'd like to send the email only after approved but it still sends out the email before approval.<
eauxvives
28 December 2005, 10:30
Just a small suggestion: apparently this mod does not use the tag rel="nofollow" on hyperlinks that google recommends to limit content spam; see http://googleblog.blogspot.com/2005/01/preventing-comment-spam.html maybe it would be a good addition<
BushyTea
05 February 2006, 23:54
Hey, I have it in place and most of the features work so far that I can tell.
Only things that won't work are the edit and delete functions. For some reason I click them and it just basically refreshes the page.
Any ideas would be great
Thanks, Mike<
OneWayMule
06 February 2006, 03:10
Only things that won't work are the edit and delete functions. For some reason I click them and it just basically refreshes the page.
Any ideas would be great
Which version of the MOD are you using?
Also, as noted in the first post of this thread, I prefer answering support questions in the "Help: MOD Implementation" forum. Thank you.<
AaronHorrocks
04 March 2008, 17:25
The download link no longer works... The #downloads secion has a script error. I REALLY need this MOD since my guestbook is flooded with spam, and is only getting worse!<
AaronHorrocks
05 March 2008, 11:34
Here's the script error that I see reguardless of the machine I'm on:
Microsoft JET Database Engine error '80004005'
'W:\Clients\MReis\db\ows.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/onewayscripts/forums/inc_mymods.asp, line 186
<
AnonJr
05 March 2008, 12:59
Have you tried to e-mail OneWayMule via the forum to let him know that there is a problem? Its not like we can fix it...<
AaronHorrocks
06 March 2008, 13:53
He disabled the email forum due to spam.
I sent him a PM... I don't know if he checks it anymore. I'm praying that someone around here has downloaded his mod and can email it to me. <
Shaggy
07 March 2008, 04:27
Nothing to do with OWM's code; everything you need to know about the problem and how to fix it is in the error message.
<
AnonJr
09 March 2008, 10:19
At the time he'd posted, OWM's site was giving an error when you followed the download link in the OP. Seems fine now.<
AaronHorrocks
10 March 2008, 12:45
His website is still showing an error...
Luckily someone was nice enough to email me the MOD. Looks like I'm FINALLY in business today!
It took quite a bit of troubleshooting once I installed the MOD. I couldn't edit inc_header.asp at all, since I already had a Guestbook. Also I had to significantly change the line of code on admin_guestbook.asp that was provided it in.<
pierretopping
26 January 2009, 17:54
Hello All,
I've been using this great mod for a few years years now, and I was wondering if anybody knows how to add the number of post's in the guestbook to the total number of posts for the forum ?
Also, does anybody know how if somebody makes a post in the guestbook, it will appear in the active topics ?
Thanks people :o)
Pierre<
daveo
18 October 2012, 21:22
Does anyone have this running, so I can share a sample with my community before we try? The developer is now off line.
bobby131313
18 October 2012, 22:40
Had it running for about a month. When I realized it should be renamed from "GuestBook" to "SpamMagnet," I removed it.
daveo
18 October 2012, 23:48
Thanks. That is an issue. I am on the board of a Non Profit and we had the same experience with our previous guest book.
Maxime
20 October 2012, 04:49
Hello,
I have a problem with my guestbook. I Lorque administered with an email address to receive notification that my guestbook to receive a message. I am receiving an error saying my email address is not valid. And that since the installation of the 3407 version of forum
<
<
icon and confirm the approval.
<
<
It took quite a bit of troubleshooting once I installed the MOD. I couldn't edit inc_header.asp at all, since I already had a Guestbook. Also I had to significantly change the line of code on admin_guestbook.asp that was provided it in.<