How to mod $selectspec to exclude a given cagetoryid

Question

I have a category that I want to exclude from question lists. It looks like the selection comes from qa_db_posts_basic_selectspec(). Is this correct?

If so, where would I add arguments like:

WHERE ^posts.categoryid!='1'

 

Answer 1

You can't do this from within qa_db_posts_basic_selectspec(...) but rather one of the more specific functions in qa-db-selects.php that builds on the output of qa_db_posts_basic_selectspec(...)

For example for questions lists, in function qa_db_qs_selectspec(...) you could add the condition immediately after the following SQL:

JOIN (SELECT postid FROM ^posts WHERE

Comments

That worked perfectly. Thanks!