[Sadie Frost]

It's only with the random quote on the index page where the unapproved quotes show. I have three boards that have used quote it for years with the same problem. I did a clean install of vb and QuoteIt and got the same thing happening.

Here are the quote-related queries on the index page:


SELECT COUNT(*) AS count FROM quotes AS quotes WHERE quotes.average >= 0 AND quotes.rating >= 0

SELECT quotes.*, categories.title AS category, users.username FROM quotes AS quotes
LEFT JOIN user AS users ON quotes.userid = users.userid
LEFT JOIN quotecategories AS categories ON categories.categoryid = quotes.categoryid WHERE quotes.average >= 0 AND quotes.rating >= 0 LIMIT 281, 1

SELECT rating AS yourvote FROM quoteratings WHERE quoteid = 575 AND userid = 6370

Thanks Steve I love QuoteIt, whether regular members see the spam or not