Snitz Forums 2000 - MOD: Search Log v1.0.1 (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: Search Log v1.0.1 (Snitz v3.4)

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 2

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 21 May 2003 : 12:11:08

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
2391 Posts

Posted - 21 May 2003 : 16:00:11

Thank you OneWayMule! A delightful MOD which will make life easier for many!

Etymon

Heynow
Junior Member

374 Posts

Posted - 21 May 2003 : 16:25:56

Thanks OneWayMule, I'll install once I get home..

Political Forums:::Stay n Chat

Etymon
Advanced Member

United States
2391 Posts

Posted - 21 May 2003 : 16:31:49

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 />

Etymon
Advanced Member

United States
2391 Posts

Posted - 21 May 2003 : 16:36:52

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

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 21 May 2003 : 16:40:31

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

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 21 May 2003 : 16:45:19

inc_searchlog.asp is missing from the zip

The UK MkIVs Forum

Etymon
Advanced Member

United States
2391 Posts

Posted - 21 May 2003 : 18:24:06

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!

scorpswolle
Starting Member

39 Posts

Posted - 21 May 2003 : 18:40:47

missing inc_searchlog.asp too!!!

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 May 2003 : 10:08:41

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!

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 22 May 2003 : 10:36:26

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

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 May 2003 : 10:45:13

Argh

- too bad I can't test on SQL Server

Anyway, thanks David, zip updated again.

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 22 May 2003 : 10:52:01

Cheers, functionality all ok now, just missing "button_search.gif" from the zip.

The UK MkIVs Forum

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 May 2003 : 11:00:42

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

Etymon
Advanced Member

United States
2391 Posts

Posted - 22 May 2003 : 22:55:54

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

Etymon
Advanced Member

United States
2391 Posts

Posted - 23 May 2003 : 05:26:26

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

Page: of 2

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.18 seconds.