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)
 SQL Server full-text searching
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

therookery
Starting Member

29 Posts

Posted - 31 August 2004 :  09:57:23  Show Profile  Visit therookery's Homepage
Fantastic. Did that and have just installed it on my forums, converted the new pages to Speedball and it's working REALLY well. At last, our users can find things without having to worry about timeouts.

quote:
Originally posted by nickw

Also, try save to disk as opposed to open. Winzip sometimes gives the effect of no data.

Go to Top of Page

nickw
Junior Member

Ireland
193 Posts

Posted - 31 August 2004 :  12:05:34  Show Profile
Brillaint! Thank YOU!

Nick
Go to Top of Page

sr_erick
Senior Member

USA
1318 Posts

Posted - 06 September 2004 :  17:25:22  Show Profile  Visit sr_erick's Homepage  Send sr_erick a Yahoo! Message
Finally got to messing around with the code. I LOVE Full Text search. Wow what a difference. Thanks!

Some initial results are:

Search for "Fusion" got me roughly the same amount of topics

Old Execution Time: 17.28 seconds
New Execution Time: 0.69 seconds


Search for "Alerus Center" got me the same exact results on both searches.

Old Execution Time: 18.2 seconds
New Execution Time: 0.45 seconds


I swear be enabling this, it speeds up the forum.asp loading time when you have selected "Show All Topics". It seems that is used to take about a second on average, now it's down to below 20 ms.

http://beta.snowmobilefanatics.com/forum/default.asp






Erick
Snowmobile Fanatics


Edited by - sr_erick on 06 September 2004 19:03:59
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 08 September 2004 :  04:20:32  Show Profile  Visit HuwR's Homepage
FullText searching is now enabled here.
Go to Top of Page

sr_erick
Senior Member

USA
1318 Posts

Posted - 13 September 2004 :  00:12:43  Show Profile  Visit sr_erick's Homepage  Send sr_erick a Yahoo! Message
I think i've found a bug in the code Gary. From the profile of a person, when you click "search for all non-archived posts by this person" you get an error saying you must enter keywords and you are redirected back to the profile. It is a link like this:

search.asp?mode=DoIt&MEMBER_ID=6096




Erick
Snowmobile Fanatics

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 September 2004 :  10:00:21  Show Profile  Visit HuwR's Homepage
look in the search.asp file for this line (about line 235)

if Request.Form("Search") <> "" or intSearchMember <> 0 then

and change it to

if Request.Form("Search") <> "" or intSearchMember <> 0 or Request.QueryString("MEMBER_ID") <> "" then
Go to Top of Page

therookery
Starting Member

29 Posts

Posted - 13 September 2004 :  10:56:39  Show Profile  Visit therookery's Homepage
It's not returning the correct links for archived topics returned by the search. It should put the &archive=True in the link to the archived topic...is there an easy fix to this?
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 September 2004 :  11:20:03  Show Profile  Visit HuwR's Homepage
Did you actually click on the links ?

if you did you will find that they still work without the ARCHIVE=True being set
Go to Top of Page

therookery
Starting Member

29 Posts

Posted - 13 September 2004 :  11:21:46  Show Profile  Visit therookery's Homepage
Yes I did - they just send me to the forum homepage but it I add the archive bit in the querystring then it shows the correct topic.

quote:
Originally posted by HuwR

Did you actually click on the links ?

if you did you will find that they still work without the ARCHIVE=True being set

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 September 2004 :  11:23:28  Show Profile  Visit HuwR's Homepage
it works fine for me, I go straight to the archived topic.
Go to Top of Page

therookery
Starting Member

29 Posts

Posted - 13 September 2004 :  11:26:27  Show Profile  Visit therookery's Homepage
Hmmmm - is there a change to topic.asp that I should have on the forums? I thought I had the latest version of everything (it's showing v3.4.04 in the comments at the top of the source).

quote:
Originally posted by HuwR

it works fine for me, I go straight to the archived topic.


Edited by - therookery on 13 September 2004 11:28:04
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 September 2004 :  11:32:40  Show Profile  Visit HuwR's Homepage
the format of the search results for this MOD is exactly the same as a standard Snitz search resultpage, so it is not the search causing your problems.

The Snitz version is not written in any of the comments at the top of the source, in fact the version is not mentioned anywhere in the source, it is stored in the DB
Go to Top of Page

therookery
Starting Member

29 Posts

Posted - 13 September 2004 :  11:38:15  Show Profile  Visit therookery's Homepage
Hmmm...that's odd. Here's the start of my topic.asp which clearly shows it reading in the archive querystring:


<%
'#################################################################################
'## Snitz Forums 2000 v3.4.04
'#################################################################################
'## Copyright (C) 2000-04 Michael Anderson, Pierre Gorissen,
'##                       Huw Reddick and Richard Kinser
'##
'## This program is free software; you can redistribute it and/or
'## modify it under the terms of the GNU General Public License
'## as published by the Free Software Foundation; either version 2
'## of the License, or (at your option) any later version.
'##
'## All copyright notices regarding Snitz Forums 2000
'## must remain intact in the scripts and in the outputted HTML
'## The "powered by" text/logo with a link back to
'## http://forum.snitz.com in the footer of the pages MUST
'## remain visible when the pages are viewed on the internet or intranet.
'##
'## This program is distributed in the hope that it will be useful,
'## but WITHOUT ANY WARRANTY; without even the implied warranty of
'## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
'## GNU General Public License for more details.
'##
'## You should have received a copy of the GNU General Public License
'## along with this program; if not, write to the Free Software
'## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
'##
'## Support can be obtained from our support forums at:
'## http://forum.snitz.com
'##
'## Correspondence and Marketing Questions can be sent to:
'## manderson@snitz.com
'##
'#################################################################################

%>
<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_lastread.asp"-->
<%

qsTopicID = Request.QueryString("TOPIC_ID")

pageTopicID = Request.QueryString("TOPIC_ID")

If Session("TopicID") <> "" Then
	qsTopicID = Session("TopicID")
	pageTopicID = Session("TopicID")
	Session("TopicID") = ""
End If

frmMethodType = Request.Form("Method_Type")
qsSearchTerms = Request.QueryString("SearchTerms")
if (qsTopicID = "" or IsNumeric(qsTopicID) = False) and frmMethodType <> "login" and frmMethodType <> "logout" then
	Response.Redirect "default.asp"
	Response.End
else
	Topic_ID = cLng(pageTopicID)
end if 
Dim ArchiveView, ArchiveLink, CColor
'###### Poll Mod ######
Dim vPercent(100)
Dim vAnswers(15)
Dim vCount(15)
Dim mpoll, nMaxValue, nMaxWidth
Dim nTotal, nTotal2, nThisVal
'######################
if request("ARCHIVE") = "true" then
	strActivePrefix = strTablePrefix & "A_"
	ArchiveView = "true"
	ArchiveLink = "archive=true&"

elseif request("ARCHIVE") <> "" then



quote:
Originally posted by HuwR

the format of the search results for this MOD is exactly the same as a standard Snitz search resultpage, so it is not the search causing your problems.

The Snitz version is not written in any of the comments at the top of the source, in fact the version is not mentioned anywhere in the source, it is stored in the DB


Edited by - therookery on 13 September 2004 11:38:51
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 September 2004 :  11:55:03  Show Profile  Visit HuwR's Homepage
yes, but it is NOT reading it from the query string. when you enable the "search archives" checkbox, this sets the forms ARCHIVE field to true. The code in topic.asp request("ARCHIVE") checks for either the querystring or the form element, which is why it does not need it in the querystring
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 September 2004 :  11:55:29  Show Profile  Visit HuwR's Homepage
does your forum work with a standard search.asp ?
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | 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.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07