Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 MOD: Search Log v1.0.1 (Snitz v3.4)
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 21 May 2003 :  12:11:08  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Title: Search Log MOD
Version: v1.0.1 for Snitz Forums v3.4
Author: OneWayMule
Last Update: May 22, 2003

Description:
Logs searches performed in your Snitz Forum and displays statistics such as top keywords, queries and searches.

Features:
- Turn on/off logging
- Statistics show up on searchlog.asp
- Configure which users have access to the search log statistics (all, moderators and admins, or admins only)
- Configure which statistics are displayed
- Set the number of top/last keywords, queries etc. displayed
- Bad word filter
- Secure administration area
- Easy installation - you only have to modify 4 files
- A file for automatic database upgrade included
- All code done in response.write for Snitz v3.4 compatability

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

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:
Search Log v1.0.1 for Snitz Forums v3.4

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

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

Last Update: May 22, 2003: zip file updated (1.0.1)

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 22 May 2003 10:05:32

Etymon
Advanced Member

United States
2383 Posts

Posted - 21 May 2003 :  16:00:11  Show Profile  Visit Etymon's Homepage
Thank you OneWayMule! A delightful MOD which will make life easier for many!

Etymon
Go to Top of Page

Heynow
Junior Member

374 Posts

Posted - 21 May 2003 :  16:25:56  Show Profile  Visit Heynow's Homepage  Send Heynow an AOL message  Send Heynow a Yahoo! Message
Thanks OneWayMule, I'll install once I get home..


Political Forums
:::Stay n Chat
Go to Top of Page

Etymon
Advanced Member

United States
2383 Posts

Posted - 21 May 2003 :  16:31:49  Show Profile  Visit Etymon's Homepage
Small typo in the readme.html file.

Line 208

<button type="button" onClick="javascript:this.form.t13.focus();this.form.13.select();">Select All</button><br />

should be:

<button type="button" onClick="javascript:this.form.t13.focus();this.form.t13.select();">Select All</button><br />

Go to Top of Page

Etymon
Advanced Member

United States
2383 Posts

Posted - 21 May 2003 :  16:36:52  Show Profile  Visit Etymon's Homepage
Request:

Might there be a way that on search.asp that there could be a drop down called My Recent Searches and in the drop down would be the list of recent searches by that member? That might be a separate MOD however.

Just a thought. Definitley still appreciate the MOD!

Etymon

Edited by - Etymon on 21 May 2003 16:38:21
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 21 May 2003 :  16:40:31  Show Profile
error using SQL Server

Microsoft OLE DB Provider for SQL Server (0x80040E14)
The text, ntext, and image data types cannot be used in an ORDER BY clause.
/forum/searchlog.asp, line 557

The UK MkIVs Forum
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 21 May 2003 :  16:45:19  Show Profile
inc_searchlog.asp is missing from the zip

The UK MkIVs Forum
Go to Top of Page

Etymon
Advanced Member

United States
2383 Posts

Posted - 21 May 2003 :  18:24:06  Show Profile  Visit Etymon's Homepage
Yes,


			if CInt(strSLDoLog) = 1 then
			  Call AddSearchToDB()
			  Call AddKeywordsToDB()
			  Call AddQueriesToDB()
			end if


is ineffective in search.asp ... needing inc_searchlog.asp

Looking good though!



Go to Top of Page

scorpswolle
Starting Member

39 Posts

Posted - 21 May 2003 :  18:40:47  Show Profile
missing inc_searchlog.asp too!!!
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 May 2003 :  10:08:41  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
I've updated the zip file.

- inc_searchlog is now included ()
- SQL Server error *should* be fixed
- readme corrected and updated

Please re-download and follow the installation/upgrade instructions from the readme.

Version is now v1.0.1.

Thanks a lot everyone for the feedback & bug reports.

Etymon: Thanks for your suggestion, I will think about releasing a MOD Add-On for this. Nice idea!

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
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 22 May 2003 :  10:36:26  Show Profile
got this error using the dbs upgrade on sql server


quote:
MOD: Search Log Upgrade v1.0 -> v1.0.1

Adding Column SLS_QUERY...
ALTER TABLE FORUM_SEARCHLOG_SEARCHES ALTER COLUMN SLS_QUERY nvarchar (255) NULL
ALTER TABLE FORUM_SEARCHLOG_SEARCHES ALTER COLUMN SLS_QUERY nvarchar (255) NULL
-2147217900 | Cannot alter column 'SLS_QUERY' because it is 'ntext'.

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

Creating table(s)...
CREATE TABLE FORUM_SEARCHLOG_QUERIES( ALTER#SLQ_QUERY#VARCHAR (255)#NULL# int IDENTITY (1, 1) PRIMARY KEY NOT NULL )

Creating table(s)...
CREATE TABLE FORUM_SEARCHLOG_KEYWORDS( SLK_KEYWORD#VARCHAR (255)#NULL# int IDENTITY (1, 1) PRIMARY KEY NOT NULL )

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

The UK MkIVs Forum
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 May 2003 :  10:45:13  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Argh - too bad I can't test on SQL Server

Anyway, thanks David, zip updated again.

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
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 22 May 2003 :  10:52:01  Show Profile
Cheers, functionality all ok now, just missing "button_search.gif" from the zip.

The UK MkIVs Forum
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 May 2003 :  11:00:42  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
It's not meant to be in the zip; I've updated the zip with a corrected version of searchlog.asp.

Thank you, QA Tester No. 1

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
Go to Top of Page

Etymon
Advanced Member

United States
2383 Posts

Posted - 22 May 2003 :  22:55:54  Show Profile  Visit Etymon's Homepage

Hi OneWayMule,

Could you please start a topic in the Help: MOD Implementation for this MOD? I have a couple of questions to ask.

Thanks,

Etymon
Go to Top of Page

Etymon
Advanced Member

United States
2383 Posts

Posted - 23 May 2003 :  05:26:26  Show Profile  Visit Etymon's Homepage

Finally found the problem.

In the dbs_searchlog.asp and the dbs_searchlog2.asp files, I found an error in the Data Type field.

SEARCHLOG_SEARCHES
SLS_ID
SLS_QUERY#varchar (255)#NULL#
SLS_DATE#varchar (14)#NULL#
SLS_MEMBER#int#NULL#
SLS_METHOD#int#NULL#
SLS_FORUM#int#NULL#
SLS_IN#int#NULL#
SLS_ARCHIVE#int#NULL#
SLS_SEARCHDATE#int#NULL
SLS_BYMEMBER#int#NULL#
[END]

Should be:

SEARCHLOG_SEARCHES
SLS_ID
SLS_QUERY#varchar (255)#NULL#
SLS_DATE#varchar (14)#NULL#
SLS_MEMBER#int#NULL#
SLS_METHOD#varchar (10)#NULL#
SLS_FORUM#int#NULL#
SLS_IN#int#NULL#
SLS_ARCHIVE#int#NULL#
SLS_SEARCHDATE#int#NULL
SLS_BYMEMBER#int#NULL#
[END]

I think the three options for the ( ) value in varchar could be:

and = (3)
or = (2)
phrase = (6)

but I placed (10) just to be safe.

NOTE: I am using Snitz 3.3.05, so perhaps for Snitz 3.4.03 the SLS_METHOD could work fine with the Data Type as int. I'm not sure how the search.asp is setup for 3.4.03.

I had to make several code modifications for this to work on 3.3.05, but this Data Type error may be of significance to 3.4.03 users.

Thanks again for the MOD OneWayMule! It's been a lot of fun installing and will help my users greatly.


Cheers,

Etymon


Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07