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.
نوشته شده در
I think I have a copy at home, will dig it out later<
نوشته شده در
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.
نوشته شده در
نوشته شده در
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.
نوشته شده در
no probs, it's amazing what crap i have on my pc
<
نوشته شده در
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.
آخرین ویرایش توسط
نوشته شده در
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
بارگزاری فایل
If you're having problems uploading, try choosing a smaller image.
پیشنمایش مطلب
Send Topic
Loading...