| Author |
 Topic  |
|
mfindlay
Junior Member
USA
144 Posts |
 Posted - 25 June 2001 : 01:22:42
|
quote:
what does that code do anyways?
it seeems to work fine without it
The SuperSearch code in Paging() allows the PREV and NEXT search hit icons to appear in posts on other pages when you click on the paging numbers at the top and bottom of every page.
I haven't got the Topic sorting mod installed, but I did download it and look at the topic.asp for it and I think there may be a simple solution.
NOTE: The following is a proposed fix for incorporating SuperSearch mod into the Topic Sorting mod. If you do not have the Topic Sorting mod do not alter the SuperSearch code.
Notice at the top of topic.asp the strQS is built:
strQS = "&sortorder=" & strtopicsortord &_
"&sortfield=" & strtopicsortfld &_
"&days=" & strtopicsortday &_
"&FORUM_ID=" & Request("FORUM_ID") &_
"&CAT_ID=" & Request("CAT_ID") &_
"&Forum_Title=" & ChkString(Request("FORUM_Title"),"urlpath")
'-------------------------------------------
If you take the SuperSearch code out of Paging() and place it just below the strQS= statement, and change all references of ref= to strQS= I think this should make SuperSearch work for you:
'---------------------------- SUPERSEARCH MOD BEGIN 2.1 --------------------------
if bKeywordsPresent then
strQS = strQS & "&SearchStrings=" & strURLSearchStrings & "&SearchType=" & strSearchType
end if
'---------------------------- SUPERSEARCH MOD END 2.1 ----------------------------
'---------------------------- SUPERSEARCH MOD BEGIN -----------------------------
if Request.QueryString("ReplyIDs") <> "" then
strQS = strQS & "&ReplyIDs=" & Request.QueryString("ReplyIDs")
else
strQS = strQS & "&ReplyIDsNotFound=" & "1"
end if
if Request.QueryString("AllReplyIDs") <> "" then
strQS = strQS & "&AllReplyIDs=" & Request.QueryString("AllReplyIDs")
else
strQS = strQS & "&AllReplyIDs=" & "1"
end if
'---------------------------- SUPERSEARCH MOD END -----------------------------
The SuperSearch code is just adding on to the existing link code stored by strQS so when topic.asp is re-entered when selecting one of the paging numbers, the QueryString will contain both the topic sorting code and the SuperSearch code.
Please try this and let me know if it is successful. If it is, I will update SuperSearch
with these instructions for incorporating it into the toipc sorting mod.
Edited by - mfindlay on 25 June 2001 01:35:53 |
 |
|
|
Freeman II
Junior Member
232 Posts |
Posted - 25 June 2001 : 02:15:58
|
good job mfindlay
it works like a charm 
|
|
|
|
mfindlay
Junior Member
USA
144 Posts |
Posted - 25 June 2001 : 02:26:30
|
quote:
good job mfindlay
it works like a charm
Thanks, I'll update the download with this info.
|
|
|
|
Freeman II
Junior Member
232 Posts |
Posted - 25 June 2001 : 02:38:26
|
mfindlay i got a question for you:
im making a mod for supersearch that you can choose to search locked topics only.
i need to know where the code is on what line in search.asp
im gonna add somehting like this
strSql = strSql & " WHERE "&something&" = '" & something
<% if Request.QueryString("mode") = "locked" then%>
strSql = strSql & "," F_STATUS= '" & 1(or whatever is for locked topic)
<% end if%>
thanks
|
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 25 June 2001 : 05:20:30
|
how about a quick "search in this forum" icon in forum.asp?
will help in sites with a lot of forums.
|
|
|
|
mfindlay
Junior Member
USA
144 Posts |
Posted - 25 June 2001 : 13:40:43
|
quote:
mfindlay i got a question for you:
im making a mod for supersearch that you can choose to search locked topics only.
i need to know where the code is on what line in search.asp
im gonna add somehting like this
strSql = strSql & " WHERE "&something&" = '" & something
<% if Request.QueryString("mode") = "locked" then%>
strSql = strSql & "," F_STATUS= '" & 1(or whatever is for locked topic)
<% end if%>
thanks
I would suggest you look at Search.asp the function BuildForumIDs(). This is where the forum qualifiers are built when the user selects one or more forums to narrow the search on. Notice at the top is a flag which indicates whether the user selected any specific forums or not.
You might want to put a checkbox on the search form "Search only locked topics" or something like that. Then if that checkbox is checked, bypass the flag checking at the top of BuildForumIDs() and qualify the forum search by "Locked" type.
|
|
|
|
Freeman II
Junior Member
232 Posts |
Posted - 25 June 2001 : 16:02:46
|
i tried this but it didn;t work
----------------
function BuildForumIDs()
BuildForumIDs=""
if bSearchByForums=false then
exit function
end if
BuildForumIDs = BuildForumIDs & " AND ("
strTmp=""
for nForumIndex = 0 to nForumIDTopIndex
if strTmp <> "" then
strTmp = strTmp & " OR "
end if
' don't write FORUMID of 0 since there is no such forum. zero represents all forums.
' It should never appear due to the edit check we have above but just to be safe....
if arrForumIDs(nForumIndex) <> "0" then
strTmp = strTmp & strTablePrefix & "FORUM.FORUM_ID = " & arrForumIDs(nForumIndex)
end if
next
if (Request.Form("locked") = "locked") then
strTmp = strTmp & strTablePrefix & TOPICS.T_STATUS = 0
end if
BuildForumIDs = BuildForumIDs & strTmp & ") "
end function
-----------at the very end of the page i have this
<input type="checkbox" value="locked" name="locked">
----------
please tell me if you see anything wrong
thanks =)
|
|
|
|
mfindlay
Junior Member
USA
144 Posts |
Posted - 25 June 2001 : 17:22:45
|
quote:
i tried this but it didn;t work
----------------
function BuildForumIDs()
BuildForumIDs=""
if bSearchByForums=false then
exit function
end if
.
.
.
Is your code executing at all? Note that bSearchByForums is only set to TRUE (and thus only allows processing to continue in that function) when the user has selected at least 1 forum.
I would suggest you move your check for "locked" above this point and if present, set the bSearchByForums to TRUE. Also, be sure in your testing to turn on the "Display Query" checkbox on the search form so you can see exactly what queries are being generated.
|
|
|
|
Freeman II
Junior Member
232 Posts |
Posted - 25 June 2001 : 19:27:34
|
i got it working
thanks for you help mfindlay
|
|
|
|
Freeman II
Junior Member
232 Posts |
Posted - 06 July 2001 : 20:12:59
|
mfindlay
i got another question for you
i installed the poll mod, i want it to display [Poll] after the subject if the topic is a poll, where should i add the code?
thanks
|
|
|
|
mfindlay
Junior Member
USA
144 Posts |
Posted - 07 July 2001 : 03:08:28
|
quote:
mfindlay
i got another question for you
i installed the poll mod, i want it to display [Poll] after the subject if the topic is a poll, where should i add the code?
thanks
I'll check it out and get back to you.
|
|
|
|
rrabago
Starting Member
4 Posts |
Posted - 07 July 2001 : 12:09:39
|
Hello:
I'm new to this great MOD and would like to utilize it for my forum. After reading most of the replies and the FAQ it's my understanding that the SuperSearch MOD is not supported for SQL DB.
When I attempt to run the SUPERSEARCH_search.asp it sits and spins and returns an ASP timeout error. Does anyone have it working while using SQL DB as the backend?
Thanks!
-Ricardo |
|
|
|
mfindlay
Junior Member
USA
144 Posts |
Posted - 07 July 2001 : 12:40:10
|
quote:
Hello:
I'm new to this great MOD and would like to utilize it for my forum. After reading most of the replies and the FAQ it's my understanding that the SuperSearch MOD is not supported for SQL DB.
When I attempt to run the SUPERSEARCH_search.asp it sits and spins and returns an ASP timeout error. Does anyone have it working while using SQL DB as the backend?
Thanks!
-Ricardo
What reply gave you the impression it is not supported for SQL DB? I don't know of any incompatibilities.
Its SQL is the same as the Snitz SQL used, just reorganized for better performance. For example, the original Snitz search returned every row in the topic when a single posting had a search hit. Given a topic with 1000 posts this returned 1000 records, only 1 of which actually had the hit. Multiply that times the number of topics and forums and a search with only a few hits could return thousands of rows. Supersearch only returns those rows with the actual hits.
SUPERSEARCH_search.asp is just a MODEL file that contains the code you need to transfer to your actual search.asp. It is not intended to run "as is" since it also contains other non-related code from other mods etc. You need to scan for all the commented code and transfer the code into your own search.asp.
You will need to do the same for the SUPERSEARCH_topic.asp before attempting to test it. You can not just run SUPERSEARCH_search.asp or SUPERSEARCH_topic.asp on their own. They are meant for documentation purposes only.
Edited by - mfindlay on 08 July 2001 18:12:49 |
|
|
|
rrabago
Starting Member
4 Posts |
Posted - 07 July 2001 : 12:57:38
|
Hello mfindlay:
Thanks for the reply. It's my error I misunderstood the section below in the supersearch_documentation.htm file while reading it early this AM.
"This mod was tested with Access 2000 only. If you run into SQL issues with other database systems, please note that I will not be able to assist you very much with it since I don't have the other databases installed (and don't plan to :) "
O.K. that clears it up.
Thanks!
-Ricardo |
|
|
|
samyot
Junior Member
Canada
242 Posts |
|
|
Topic |
|
Topic Locked
