[tp214]

nevermind!

this is the correct code...

error_reporting(E_ALL & ~E_NOTICE); 

if (!is_object($DB_site)) 
{ 
        exit; 
} 

$DB_site->query("INSERT INTO ". TABLE_PREFIX ."threadviewsaggregate SELECT threadid , COUNT(*) AS views FROM " . TABLE_PREFIX . "threadviews GROUP BY threadid"); 
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "threadviews"); 

$DB_site->query( 
        "UPDATE " . TABLE_PREFIX . "thread,". TABLE_PREFIX ."threadviewsaggregate 
        SET ". TABLE_PREFIX ."thread.views = ". TABLE_PREFIX ."thread.views + ".TABLE_PREFIX."threadviewsaggregate.views 
        WHERE ". TABLE_PREFIX ."thread.threadid = ". TABLE_PREFIX ."threadviewsaggregate.threadid"); 
$DB_site->query("DELETE FROM ". TABLE_PREFIX ."threadviewsaggregate"); 

log_cron_action('Thread Views Updated', $nextitem);