| Author |
 Topic  |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
 Posted - 25 October 2001 : 01:42:48
|
Download and Demo url's changed
Author: me
Demo: http://ttnetworks.121hosts.net/yap/guestbook.asp
Support: here
Download: http://freeaspcode.net/snitz/details.asp?id=44
Install: Readme.txt included in download
Uprgrade: Readme.txt included in download
Features: Readme.txt included in download
New Stuff/Updates
-Email functionality (auto-email signee a thank you letter, auto-email admin every signature, customizable messages)
-Display update (now uses forum icons and constitutes a 'snitzy' feel
-18 bugfixes (yep I counted them...)
SECURITY FIX NOV 30...
If you downloaded this guestbook before Nov 30; I strongly encourage you to re-download the zip file from the url above, and replace admin_guestbook.asp with the updated version from the file. There are no database changes and I will not go into more details.
Minor enhancements in 3.3.7
Some minor display enhancements and stuff...
Edited by - da_stimulator on 30 November 2001 17:14:54 |
|
|
aston
New Member
Andorra
51 Posts |
Posted - 25 October 2001 : 06:05:18
|
After setup the new tables,when I run the guestbook.asp file ,I got this erro
this line:strGuestbookWelcome = optionrs("G_MESSAGE")
Are you sure this lin is:3
G_MESSAGE#memo#NOT NULL#
memo?
I use SQL 7
______________________
Fly me to the Moon
|
 |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 25 October 2001 : 07:03:04
|
The script should re-name it depending on what Server....
Stand by :P I'll get back to ya with a solution.
----------------
Da_Stimulator
Need a Mod?
My Snitz Test Center
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 25 October 2001 : 07:08:48
|
Ok:
Open up dbs_guestbook.asp and change the following:
Wherever it says 'memo' replace with 'text' and save
Remove the tables the script has already created, and then re-run the setup. (zip file updated with modifications)
----------------
Da_Stimulator
Need a Mod?
My Snitz Test Center
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 25 October 2001 : 10:06:28
|
Update: Before you couldnt enable a optional field, this bug has been fixed. If you downloaded the guestbook before this post date, please re-download and replace admin_guestbook.asp from the one in the zip.
----------------
Da_Stimulator
Need a Mod?
My Snitz Test Center
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 26 October 2001 : 01:15:30
|
GB Upgrade from 3.0 or later to 3.3.5
Adding Column G_V1_REQ...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_V1_REQ int NOT NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_V2_REQ...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_V2_REQ int NOT NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_V3_REQ...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_V3_REQ int NOT NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_PAGECOUNT...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_PAGECOUNT int NOT NULL DEFAULT 10
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_T_MAIL...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_T_MAIL int NOT NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_W_MAIL...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_W_MAIL int NOT NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_T_AUTHOR...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_T_AUTHOR text (150) NOT NULL DEFAULT 'ADMIN'
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_T_REPLYTO...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_T_REPLYTO text (150) NOT NULL DEFAULT 'webmaster@snitz.com'
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
Adding Column G_T_MESSAGE...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_T_MESSAGE memo NOT NULL DEFAULT 'Thank you for signing my Guestbook'
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
--------------------------------------------------------------------------------
Test Site:
http://www.eastpasco.com running on Huw's Code 3.3.09 SQL 2000 |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 26 October 2001 : 01:19:37
|
If your using huwrs forum I recommend not using this mod, as he already has a version of it installed and I honestly dont know what/if any modifications he made to fit into his forum...
----------------
Da_Stimulator
Need a Mod?
My Snitz Test Center
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 26 October 2001 : 08:28:25
|
Yes I am, but this shouldn't have a issue with the setup dbs file with all those errors.
Test Site:
http://www.eastpasco.com running on Huw's Code 3.3.09 SQL 2000 |
|
|
|
samyot
Junior Member
Canada
242 Posts |
Posted - 26 October 2001 : 10:03:30
|
Great MOD!
I was wondering if there's a way to change the 'Sub subgpaging()' function in guestbook.asp to remove the underline and bold the page number that is displayed?
e.g.
Let's say your on page 2, it would look like this:
Pages: 1 | 2 | 3 |
Thank you in advance
Sylvain Amyot
FORUM:http://syltek.dingojunction.com/forum
HOME:http://members.home.net/sylvainamyot/
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 26 October 2001 : 10:15:10
|
Sure, here is the modified Sub
Sub subgpaging()
p_rec = 1
response.write("<tr><td bgcolor=""" & strForumCellColor & """>" & strTempFont & "Pages: " & vbcrlf)
Do until p_rec = strGTotalPages + 1
if p_rec = ipage then
response.write("<b>" & p_rec & "</b> | ")
else
response.write("<a href=""guestbook.asp?page=" & p_rec & """ title=""Page " & p_rec & "&sortby=" & request.querystring("sortby") & """>" & p_rec & "</a> | ")
end if
p_rec = p_rec + 1
Loop
response.write("</font></td></tr>" & vbcrlf)
End Sub
---------------
Da_Stimulator has spoken
Ongoing Project that uses Snitz forums as a backbone for entire website |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 26 October 2001 : 10:21:03
|
Rick, I'm not sure what to tell you, I will see if I can get ahold of Huwr and maybe he knows whats going on.
---------------
Da_Stimulator has spoken
Ongoing Project that uses Snitz forums as a backbone for entire website |
|
|
|
samyot
Junior Member
Canada
242 Posts |
Posted - 26 October 2001 : 10:35:01
|
quote:
Sure, here is the modified Sub
Sub subgpaging()
p_rec = 1
response.write("<tr><td bgcolor=""" & strForumCellColor & """>" & strTempFont & "Pages: " & vbcrlf)
Do until p_rec = strGTotalPages + 1
if p_rec = ipage then
response.write("<b>" & p_rec & "</b> | ")
else
response.write("<a href=""guestbook.asp?page=" & p_rec & """ title=""Page " & p_rec & "&sortby=" & request.querystring("sortby") & """>" & p_rec & "</a> | ")
end if
p_rec = p_rec + 1
Loop
response.write("</font></td></tr>" & vbcrlf)
End Sub
---------------
Da_Stimulator has spoken
Ongoing Project that uses Snitz forums as a backbone for entire website
You're a Genious, thanks!
Sylvain Amyot
FORUM:http://support.mytechsupport.ca
HOME:http://mytechsupport.ca
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 29 October 2001 : 16:47:47
|
quote:
quote:
Sure, here is the modified Sub
Sub subgpaging()
p_rec = 1
response.write("<tr><td bgcolor=""" & strForumCellColor & """>" & strTempFont & "Pages: " & vbcrlf)
Do until p_rec = strGTotalPages + 1
if p_rec = ipage then
response.write("<b>" & p_rec & "</b> | ")
else
response.write("<a href=""guestbook.asp?page=" & p_rec & """ title=""Page " & p_rec & "&sortby=" & request.querystring("sortby") & """>" & p_rec & "</a> | ")
end if
p_rec = p_rec + 1
Loop
response.write("</font></td></tr>" & vbcrlf)
End Sub
---------------
Da_Stimulator has spoken
Ongoing Project that uses Snitz forums as a backbone for entire website
You're a Genious, thanks!
Sylvain Amyot
FORUM:http://support.mytechsupport.ca
HOME:http://mytechsupport.ca
Your welcome :)
Note: Minor bug fix regarding the form in admin_guestbook.asp - Zip updated, thats the only file that needs replacement
---------------
Da_Stimulator has spoken |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 30 October 2001 : 03:27:06
|
Hey Stim, first of all, congratulations on your 1500 posts 
Is this guestbook mod an upgrade or can it be installed without any previous or other guestbook mod already there?
One more thing... on http://www.stormwhispers.com/ss/ there are some links to a Free Script, a Premium Script and the Smile Manager & Guestbook mods for Snitz. However, when I go to the free scripts page I get a message that that page is "under development" as is the page for the premium scripts. When I click on the links for those scripts I either get a similar page or I get a 404 error page. Only the StimList link seems to work although there's no link to it on the Premium Scripts page.
Just thought I'd let you know 
Roland
http://www.frutzle.com |
|
|
|
samyot
Junior Member
Canada
242 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 30 October 2001 : 11:00:13
|
frutzle, the entire site is under construction :) thats one of my projects, along with stimlist... thats my main project for the time being. Some links may not work, thats because I'm still working on it. The links to snitz stuff dont work yet, but if you got to http://stormwhispers.com/ss/snitz.asp download links are available.
samyot, you dont have email enabled on your forum :)
---------------
Da_Stimulator has spoken |
|
|
|
Topic |
|
Topic Locked
