The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Anyone have the code for the Full Text Search Mod - http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=54214
The code isn't downloadable from the topic above (unless I've missed something).<
The code isn't downloadable from the topic above (unless I've missed something).<
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
Postet den
I think I have a copy at home, will dig it out later<
Postet den
Thanks.<
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
Postet den
Postet den
Thanks HuwR.<
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
Postet den
no probs, it's amazing what crap i have on my pc
<
Postet den
Line 29 of search_mssqlft.asp should be(missing comma after T.T_DATE)<
Code:
strSql = strSql & ", T.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_DATE, T.T_STATUS, T.T_LAST_POST"Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
Sist redigert av
Postet den
Actually I think that whole block should be<
Code:
If keycnt > -1 or intSearchMember <> 0 Then
'## Forum_SQL - Find all records with the search criteria in them
strSql = "SELECT DISTINCT C.CAT_STATUS, C.CAT_SUBSCRIPTION, C.CAT_NAME, C.CAT_ORDER"
strSql = strSql & ", F.F_ORDER, F.FORUM_ID, F.F_SUBJECT, F.CAT_ID"
strSql = strSql & ", F.F_SUBSCRIPTION, F.F_STATUS"
strSql = strSql & ", T.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_DATE, T.T_STATUS, T.T_LAST_POST"
strSql = strSql & ", T.T_LAST_POST_AUTHOR, T.T_LAST_POST_REPLY_ID, T.T_REPLIES, T.T_UREPLIES, T.T_VIEW_COUNT"
strSql = strSql & ", M.MEMBER_ID, M.M_NAME, M1.M_NAME AS LAST_POST_AUTHOR_NAME"
strSql = strSql & ", F.F_PRIVATEFORUMS, F.F_PASSWORD_NEW, T.T_STICKY"
strSql2 = " FROM ((((" & strTablePrefix & "FORUM F "
strSql2 = strSql2 & "INNER JOIN " & strActivePrefix & "TOPICS T ON F.FORUM_ID = T.FORUM_ID) "
strSql2 = strSql2 & "LEFT JOIN " & strActivePrefix & "REPLY R ON T.TOPIC_ID = R.TOPIC_ID) "
strSql2 = strSql2 & "INNER JOIN " & strMemberTablePrefix & "MEMBERS M ON T.T_AUTHOR = M.MEMBER_ID) "
strSql2 = strSql2 & "INNER JOIN " & strTablePrefix & "CATEGORY C ON T.CAT_ID = C.CAT_ID) "
strSql2 = strSql2 & "LEFT JOIN " & strMemberTablePrefix & "MEMBERS M1 ON T.T_LAST_POST_AUTHOR = M1.MEMBER_ID "
strSql2 = strSql2 & "LEFT JOIN (SELECT TOPIC_ID, R_AUTHOR FROM "& strActivePrefix & "REPLY GROUP BY TOPIC_ID, R_AUTHOR "
if MemberID > 0 then strSql2 = strSql2 & "HAVING (R_AUTHOR = " & MemberID & ")"
strSql2 = strSql2 & ") AS RD ON T.TOPIC_ID = RD.TOPIC_ID "
strSql2 = strSql2 & "WHERE T.TOPIC_ID IN ("Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
Email Member
Message Member
Post Moderation
Filopplasting
If you're having problems uploading, try choosing a smaller image.
Forhåndsvis post
Send Topic
Loading...