MySQL query to get total Thread Views?

[cheesegrits]

Well, it depends whether you have the 'threadviewslive' option set or not. So to account for either case, you'd need something like:

$totviews = 0;
if ($vbulletin->options['threadviewslive'])
{
        $query = "
                SELECT SUM(views) AS totviews
                FROM " . TABLE_PREFIX . "thread
                WHERE forumid = $forumid
        ";
}
else
{
        $query = "
                SELECT COUNT(*) AS totviews
                FROM " . TABLE_PREFIX . "threadviews AS threadviews
                INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = threadviews.threadid)
                WHERE thread.forumid = $forumid
        ";           
}
if ($result = $vbulletin->query_first_slave($query))
{
        $totviews = $result['totviews'];
}

This assumes that the forumid you want is in $forumid.

Untested. If the inner join doesn't work try a right join, I always get confused between those two. :erm:

-- hugh