The Mudcat Café TM
Thread #42970   Message #625773
Posted By: Jon Freeman
11-Jan-02 - 10:55 AM
Thread Name: BS: What annoys me about mudcat
Subject: RE: BS: What annoys me about mudcat
Norton, here is a quick off the top of my head one.

Ask that the BS prefix was used. There will always be a slight bit of a grey area but it should work most of the time.

In the membership, add a checkbox to indicate the preference to exclude BS threads and make the change to the table...

For the main forum page, there is likely to be some SQL going something along the lines of "SELECT * FROM THREADS" (it will be a bit more complicated than that). The main forum page checks the member table (it must do to show your user name in the post box) for logged on members. Just do something like

If Member wants BS then
SQL=SELECT * FROM THREADS
else
SQL=SELECT * FROM THREADS WHERE TITLE NOT LIKE %BS:%

and use the SQL - in the same normal page - the only difference is the records returned - one excludes BS.

Maybe there are complications I am not aware of but my guess is that, for under 2 hrs programming we would have a main page that automatically filters for those members who don't like BS.

Jon