Hello,
I have a little problem using vBSEO RC 6 with the following hack:
Code:// ##### BEGIN New Threads ##### $dstatstarttime = mktime(0, 0, 0, date('m'), date('d'), date('Y')); $todaythreads = $DB_site->query_first(" SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "thread AS thread WHERE dateline >= $dstatstarttime AND thread.forumid IN(" . implode(', ', $dstatforumids) . ") AND thread.visible = '1' "); eval('$threadstoday .= "' . (vb_number_format($todaythreads['count'])) . '";'); // ##### END New Threads ##### // ##### BEGIN New Postings ##### $todayposts = $DB_site->query_first(" SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post AS post LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON post.threadid = thread.threadid WHERE post.dateline >= $dstatstarttime AND thread.forumid IN(" . implode(', ', $dstatforumids) . ") AND thread.visible = '1' "); eval('$poststoday .= "' . (vb_number_format($todayposts['count'])) . '";'); // ##### END New Postings ##### // ##### BEGIN New Members ##### $todayuser = $DB_site->query_first(" SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE joindate >= $dstatstarttime "); eval('$userstoday .= "' . (vb_number_format($todayuser['count'])) . '";'); // ##### END New Members ##### }
I get only a New Threads: , New Posts: , New Members:
No facts any longer. I`m sure ya can fix that problem.![]()
Yours, Silmarillion


LinkBack URL
About LinkBacks






