Clicking Flag as Spammer does not unapprove posts/comments in IPContent. Any spam I get is IPC comment spam, it's like they know the weak spot! The "Unapprove" actions should extend to the whole suite, but firstly IPC ;)
I would really like to see this in a future release if possible.
First Query says
#1054 - Unknown column 'p.post_id' in 'on clause'[/quote]
Second Query causes this error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(if p.queued='1', '0', '1') as comment_approved from ibf_ccs_custom_data' at line 11[/quote]