if (isset($_GET['vote']) && $canVote) {
$vote = (int) $_GET['vote'];
if ($vote > 1) {
$vote = 1;
}
if ($vote < -1) {
$vote = -1;
}
$k = FetchResult("select count(*) from uservotes where uid=" . $id . " and voter=" . $loguserid);
if ($k == 0) {
$qKarma = "insert into uservotes (uid, voter, up) values (" . $id . ", " . $loguserid . ", " . $vote . ")";
} else {
$qKarma = "update uservotes set up=" . $vote . " where uid=" . $id . " and voter=" . $loguserid;
}
$rKarma = Query($qKarma);
$user['karma'] = RecalculateKarma($id);
}
$qKarma = "select up from uservotes where uid=" . $id . " and voter=" . $loguserid;
$k = FetchResult($qKarma);
if ($k == -1) {
$karmaLinks = " <small>[<a href=\"profile.php?id=" . $id . "&vote=1\">↑</a>/<a href=\"profile.php?id=" . $id . "&vote=0\">↓</a>]</small>";
} else {
if ($k == 0) {
$karmaLinks = " <small>[<a href=\"profile.php?id=" . $id . "&vote=1\">↑</a>]</small>";
} else {
if ($k == 1) {
$karmaLinks = " <small>[<a href=\"profile.php?id=" . $id . "&vote=0\">↓</a>]</small>";
}
}
}
}
print "<tr class=\"header1\"><th>" . __("Name") . "</th><th>" . __("Actual") . "</th><th>" . __("Reported") . "</th><th> </th></tr>";
print "<tr class=\"header0\"><th colspan=\"4\">" . __("Counting user's posts…") . "</th></tr>";
$qUsers = "select * from users";
$rUsers = Query($qUsers);
while ($user = Fetch($rUsers)) {
$cellClass = ($cellClass + 1) % 2;
print "<tr class=\"cell" . $cellClass . "\">";
print "<td>" . htmlspecialchars($user['name']) . "</td>";
$qPosts = "select count(*) from posts where user="******"<td>" . $posts . "</td><td>" . $user['posts'] . "</td>";
print "<td style=\"background: " . ($posts == $user['posts'] ? "green" : "red") . ";\"></td>";
print "</tr>";
$qUser = "******" . $posts . " where id=" . $user['id'] . " limit 1";
$rUser = Query($qUser);
RecalculateKarma($user['id']);
}
print "<tr class=\"header0\"><th colspan=\"4\">" . __("Counting thread replies…") . "</th></tr>";
$qThreads = "select * from threads";
$rThreads = Query($qThreads);
while ($thread = Fetch($rThreads)) {
$thread['title'] = htmlspecialchars($thread['title']);
$cellClass = ($cellClass + 1) % 2;
print "<tr class=\"cell" . $cellClass . "\">";
print "<td>" . $thread['title'] . "</td>";
$qPosts = "select count(*) from posts where thread=" . $thread['id'];
$posts = FetchResult($qPosts);
print "<td>" . ($posts - 1) . "</td><td>" . $thread['replies'] . "</td>";
print "<td style=\"background: " . ($posts - 1 == $thread['replies'] ? "green" : "red") . ";\"></td>";
print "</tr>";
$qThread = "update threads set replies=" . ($posts - 1) . " where id=" . $thread['id'] . " limit 1";
function Karma()
{
global $userid;
$votes = Query("select uid from {uservotes} where voter={0}", $userid);
if (NumRows($votes)) {
while ($karmaChameleon = Fetch($votes)) {
RecalculateKarma($karmaChameleon['uid']);
}
}
}
LEFT JOIN {users} u2 on u2.id = v.voter
WHERE v.uid = u.id AND u2.powerlevel = 0 ) +
10 * (SELECT COUNT(*) FROM {uservotes} v
LEFT JOIN {users} u2 on u2.id = v.voter
WHERE v.uid = u.id AND u2.powerlevel = 1 OR u2.powerlevel = 2 ) +
15 * (SELECT COUNT(*) FROM {uservotes} v
LEFT JOIN {users} u2 on u2.id = v.voter
WHERE v.uid = u.id AND u2.powerlevel >= 3 )
");
reportFix(__("Counting user's karma…"));
*/
startFix();
$aff = 0;
$users = query("select id from {users}");
while ($user = fetch($users)) {
RecalculateKarma($user["id"]);
$aff += affectedRows();
}
reportFix(__("Counting user's karma…"), $aff);
startFix();
query("UPDATE {threads} t SET replies =\n\t\t\t(SELECT COUNT(*) FROM {posts} p WHERE p.thread = t.id) - 1\n\t\t");
reportFix(__("Counting thread replies…"));
startFix();
query("UPDATE {forums} f SET numthreads =\n\t\t\t(SELECT COUNT(*) FROM {threads} t WHERE t.forum = f.id)\n\t\t");
reportFix(__("Counting forum threads…"));
startFix();
query("UPDATE {forums} f SET numposts =\n\t\t\t(SELECT SUM(replies+1) FROM {threads} t WHERE t.forum = f.id)\n\t\t");
reportFix(__("Counting forum posts…"));
startFix();
//For some reason, this beautiful query will set MySQL to use 100% CPU and never finishes.
/*query("UPDATE {threads} t SET
