($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();