($code = $plugins->load('managemembers_start')) ? eval($code) : null;
if ($my->vlogin && $my->p['admin'] == 1) {
$result = $db->query('SELECT * FROM ' . $db->pre . 'user WHERE id = ' . $_GET['id']);
if ($db->num_rows($result) != 1) {
error($lang->phrase('no_id_given'), 'members.php' . SID2URL_1);
}
$user = $gpc->prepare($db->fetch_assoc($result));
($code = $plugins->load('managemembers_prepare')) ? eval($code) : null;
if ($_GET['action'] == 'delete') {
if ($my->id == $user['id']) {
error($lang->phrase('member_delete_yourself_error'));
}
echo $tpl->parse("menu");
echo $tpl->parse("admin/members/delete");
} elseif ($_GET['action'] == 'recount') {
$posts = UpdateMemberStats($user['id']);
$diff = $posts - $user['posts'];
ok($lang->phrase('member_recount_ok'), 'profile.php?id=' . $user['id'] . SID2URL_x);
} elseif ($_GET['action'] == 'delete2') {
if ($my->id == $user['id']) {
error($lang->phrase('member_delete_yourself_error'));
}
// Step 1: Write Data to File with old Usernames
$olduserdata = file_get_contents('data/deleteduser.php');
$olduserdata .= "\n{$user['id']}\t" . $user['name'];
$olduserdata = trim($olduserdata);
file_put_contents('data/deleteduser.php', $olduserdata);
// Step 2: Delete all abos
$db->query("DELETE FROM {$db->pre}abos WHERE mid = '{$user['id']}'");
// Step 4: Delete as mod
$db->query("DELETE FROM {$db->pre}moderators WHERE mid = '{$user['id']}'");
</table>
</form>
<?php
echo foot();
}
elseif ($job == 'recount') {
echo head();
$id = $gpc->get('id', int);
if (is_id($id)) {
$result = $db->query("SELECT id, posts FROM {$db->pre}user WHERE id = '{$id}'");
if ($db->num_rows($result) != 1) {
error('admin.php?action=members&job=manage', $lang->phrase('admin_member_user_not_found'));
}
else {
$user = $db->fetch_assoc($result);
$posts = UpdateMemberStats($id);
$diff = $posts - $user['posts'];
ok('admin.php?action=members&job=manage', $lang->phrase('admin_member_posts_recounted'));
}
}
else {
$confirm = $gpc->get('confirm', int);
if ($confirm > 0) {
$cat_bid_obj = $scache->load('cat_bid');
$boards = $cat_bid_obj->get();
$id = array();
foreach ($boards as $board) {
if ($board['count_posts'] == 0) {
$id[] = $board['id'];
}
<?php
if (defined('VISCACHA_CORE') == false) {
die('Error: Hacking Attempt');
}
global $db, $config, $scache;
if ($config['updatepostcounter'] == 0) {
$jobData = intval($jobData);
$cat_bid_obj = $scache->load('cat_bid');
$boards = $cat_bid_obj->get();
$id = array();
foreach ($boards as $board) {
if ($board['count_posts'] == 0) {
$id[] = $board['id'];
}
}
$result = $db->query("\n\t\tSELECT name\n\t\tFROM {$db->pre}replies\n\t\tWHERE guest = '0' AND date > '{$jobData}'" . iif(count($id) > 0, " AND board NOT IN (" . implode(',', $id) . ")") . "\n\t\tGROUP BY name\n\t");
while ($row = $db->fetch_assoc($result)) {
UpdateMemberStats($row['name']);
}
}
$jobData = time();
