Well thanks to all of the contributers, above. I've got the forums filtered by category. Using the same skin, though.
My version of WWF is 7.9, using MSAccess.
My process was:
1. Add the new Categories to the Categories table.
1.5 Oh, and add forums to those Categories.
2. Create a cookie in my own application saving the Category number that the user is going to use. This will be our filter Response.Cookies("COG")("C") = "4", for example
3. As mentioned many times above, changed Default.asp:
- (Line 117?) Obtain filter
intCatShow = Request.Cookies("COG")("C")
- (Line 133?) Apply SQL filter to Categories shown.
strSQL = "SELECT " & strDbTable & "Category.Cat_name, " & strDbTable & "Category.Cat_ID FROM " & strDbTable & "Category WHERE " & strDbTable & "Category.Cat_ID = " & intCatShow & " ORDER BY " & strDbTable & "Category.Cat_order ASC;"
4. Oh, had to change the search function too! See search_form.asp:
- (Line 167?) Add to SQL Where clause our cookie category filter
strSQL = "SELECT " & strDbTable & "Forum.* FROM " & strDbTable & "Forum WHERE " & strDbTable & "Forum.Cat_ID = " & Request.Cookies("COG")("C") & " ORDER BY " & strDbTable & "Forum.Cat_ID ASC, " & strDbTable & "Forum.Forum_Order ASC;"
- (Line 161?) Comment out HTML default "select all" option:
(Better not paste html in here)
- I wreckon I've missed something... Erm, later...
Well that's all folks!
ian_scho
Topic Options
Post Options
Thanks(0)
