[711]

Originally Posted by Psionic Vision

It would be an:
AND lastpost >= " . TIMENOW - 86400 . "
Add it right under the row that says WHERE.

I tried that edit, which produces this error:

Database error in vBulletin 3.6.4:

Invalid SQL:
-86400
		AND forumid NOT IN (0)
		ORDER BY views DESC
		LIMIT 10;

MySQL 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 '-86400
		AND forumid NOT IN (0)
		ORDER BY views DESC
		LIMIT 10
Error Number : 1064