if (!$category['display']) {
continue;
}
$navpath .= $category['categoryname'] . " » ";
}
while (list(, $board) = each($a_board[$category['categoryid']])) {
if (isset($a_lastvisited[$board['boardid']]) && $board['boardlastpost'] > $a_lastvisited[$board['boardid']] && $a_lastvisited[$board['boardid']] != 0) {
$imagepath = './templates/' . $style['styletemplate'] . '/images/board_new.png';
} else {
$imagepath = './templates/' . $style['styletemplate'] . '/images/board.png';
}
eval($Tboard->GetTemplate("INDEXROWS"));
}
}
}
$stats = "Das Forum hat <b>" . getusercount() . "</b> registrierte Benutzer, davon sind <b>" . getactiveusers() . "</b> aktiv.";
$r_post = thwb_query("SELECT count(postid) AS postcount FROM " . $pref . "post");
$posts = mysql_result($r_post, 0);
$r_thread = thwb_query("SELECT count(threadid) AS threadcount FROM " . $pref . "thread");
$threads = mysql_result($r_thread, 0);
$stats .= '<br><b>' . $threads . '</b> Threads | <b>' . $posts . '</b> Posts';
$newthreads = '<a href="' . build_link("search.php?startsearch=1&searchfor=today") . '">Aktive Themen von Heute anzeigen</a> || ';
$servertime = 'Serverzeit: ' . form_date(time(), 0) . '.';
$r_pm = thwb_query("SELECT count(pmid) AS pmcount FROM " . $pref . "pm WHERE pmtoid={$g_user['userid']} AND pmflags=1");
$r_pms = thwb_query("SELECT COUNT(pmid) AS pmcount FROM {$pref}pm WHERE pmtoid={$g_user['userid']}");
$pms = mysql_result($r_pm, 0);
$allpms = mysql_result($r_pms, 0);
$pmquotawarning = '';
$javascript = '';
if (!isset($g_user['usernoding'])) {
$g_user['usernoding'] = '0';
query("DELETE FROM\n {$pref}" . "thread\n WHERE\n threadlink IN ({$ids})");
// and finally get rid of the posts in those threads
query("DELETE FROM\n {$pref}" . "post\n WHERE\n threadid IN ({$ids})");
// optimize tables afterwards
// isn't always supported, that's why we put an @ in front
@mysql_query("OPTIMIZE TABLE {$pref}" . "thread");
@mysql_query("OPTIMIZE TABLE {$pref}" . "post");
foreach ($a_boardids as $b) {
updateboard($b);
}
}
print "Deleting ... successful";
}
} elseif ($action == "postcount") {
if (!isset($do) || !$do) {
print ' Do you want to continue correcting the postcount of ' . getusercount() . ' users?<BR>
<a href="mysql.php?session=' . $session . '&action=postcount&do=1">Yes</a> || <a href="mysql.php?session=' . $session . '">No</a>';
exit;
}
print "Postcount is being checked ... please wait ...<BR><BR>";
$r_user = query(" SELECT user.userid, user.userposts, count(post.userid) AS postcount\n FROM " . $pref . "user AS user\n INNER JOIN " . $pref . "post AS post\n ON post.userid = user.userid\n GROUP BY user.userid");
$a_user = array();
$corrected = 0;
$checked = 0;
$wrong = 0;
while ($a_user = mysql_fetch_array($r_user)) {
if ($a_user['userposts'] != $a_user['postcount']) {
query("UPDATE " . $pref . "user SET userposts = '" . $a_user['postcount'] . "' WHERE userid = '" . $a_user['userid'] . "'");
$corrected++;
if ($a_user['userposts'] > $a_user['postcount']) {
$wrong += $a_user['userposts'] - $a_user['postcount'];
