{$lang_cleanup['cleanup_options']}

"; makebutton($lang_cleanup['run_cleanup'], "javascript:do_submit()",100); makebutton($lang_global['back'], "javascript:window.history.back()",100); $output .= "

"; } //######################################################################################################## // make and list list of all acc/chars //######################################################################################################## function run_cleanup(){ global $lang_cleanup, $lang_global, $output, $realm_db, $characters_db, $realm_id, $user_lvl; if( empty($_GET['cleanup_by']) || empty($_GET['cleanup_sign']) ) redirect("cleanup.php?error=1"); $sql = new SQL; $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $cleanup_by = $sql->quote_smart($_GET['cleanup_by']); $cleanup_sign = $sql->quote_smart($_GET['cleanup_sign']); $cleanup_value = $sql->quote_smart($_GET['cleanup_value']); switch ($cleanup_by) { // clean by lvl case "char_lvl": $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); $result = $sql->query("SELECT guid FROM `characters` WHERE level $cleanup_sign $cleanup_value"); $total_chars = $sql->num_rows($result); $output .= ""; if ($total_chars){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= " {$lang_cleanup['chars_id']}: "; $pass_array = ""; while($char = $sql->fetch_row($result)){ $output .= "$char[0], "; $pass_array .= "-$char[0]"; } $output .= ""; $output .= "
{$lang_cleanup['tot_of']} $total_chars {$lang_global['will_be_erased']}

"; $output .= "

"; makebutton($lang_global['yes'], "javascript:do_submit()",120); makebutton($lang_global['no'], "cleanup.php",120); $output .= "

"; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; //last loggin case "last_login": $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $result = $sql->query("SELECT id FROM account WHERE last_login $cleanup_sign '$cleanup_value' AND gmlevel < $user_lvl"); $total_accounts = $sql->num_rows($result); $output .= ""; if ($total_accounts){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= ""; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; //failed loggin attempts case "failed_login": $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $result = $sql->query("SELECT id FROM account WHERE failed_logins $cleanup_sign $cleanup_value AND gmlevel < $user_lvl"); $total_accounts = $sql->num_rows($result); $output .= ""; if ($total_accounts){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= ""; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; //clean banned accounts case "banned": $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $result = $sql->query("SELECT id FROM account_banned"); $total_accounts = $sql->num_rows($result); $output .= ""; if ($total_accounts){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= ""; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; //clean chars with given total time played case "totaltime": $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); $result = $sql->query("SELECT guid FROM `characters` WHERE totaltime $cleanup_sign $cleanup_value"); $total_chars = $sql->num_rows($result); $output .= ""; if ($total_chars){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= ""; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; //clean locked acc case "locked": $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $result = $sql->query("SELECT id FROM account WHERE locked $cleanup_sign $cleanup_value AND gmlevel < $user_lvl"); $total_accounts = $sql->num_rows($result); $output .= ""; if ($total_accounts){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= ""; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; //accounts without chars or specified number of chars case "num_of_char_in_acc": $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $result = $sql->query("SELECT id FROM account WHERE gmlevel < $user_lvl"); $acc_output_array = array(); while($acc = $sql->fetch_row($result)){ $total_chars_in_acc = 0; foreach ($characters_db as $db){ $sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']); $query = $sql->query("SELECT count(*) FROM `characters` WHERE account = '$acc[0]'"); $total_chars_in_acc = $total_chars_in_acc + $sql->result($query, 0); } switch ($cleanup_sign){ case "=": if($total_chars_in_acc == $cleanup_value) array_push($acc_output_array, $acc[0]); break; case "<": if($total_chars_in_acc < $cleanup_value) array_push($acc_output_array, $acc[0]); break; case "<=": if($total_chars_in_acc <= $cleanup_value) array_push($acc_output_array, $acc[0]); break; case ">": if($total_chars_in_acc > $cleanup_value) array_push($acc_output_array, $acc[0]); break; case ">=": if($total_chars_in_acc >= $cleanup_value) array_push($acc_output_array, $acc[0]); break; case "!=": if($total_chars_in_acc <> $cleanup_value) array_push($acc_output_array, $acc[0]); break; default: redirect("cleanup.php?error=1"); } } $output .= ""; if ($acc_output_array){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= ""; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; //guild without chars or specified number of chars case "num_of_char_in_guild": $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); $result = $sql->query("SELECT guildid FROM guild"); $guild_output_array = array(); while($guild = $sql->fetch_row($result)){ $query = $sql->query("SELECT count(*) FROM guild_member WHERE guildid = '$guild[0]'"); $total_chars_in_guild = $sql->result($query, 0); switch ($cleanup_sign){ case "=": if($total_chars_in_guild == $cleanup_value) array_push($guild_output_array, $guild[0]); break; case "<": if($total_chars_in_guild < $cleanup_value) array_push($guild_output_array, $guild[0]); break; case "<=": if($total_chars_in_guild <= $cleanup_value) array_push($guild_output_array, $guild[0]); break; case ">": if($total_chars_in_guild > $cleanup_value) array_push($guild_output_array, $guild[0]); break; case ">=": if($total_chars_in_guild >= $cleanup_value) array_push($guild_output_array, $guild[0]); break; case "!=": if($total_chars_in_guild <> $cleanup_value) array_push($guild_output_array, $guild[0]); break; default: redirect("cleanup.php?error=1"); } } $output .= ""; if ($guild_output_array){ $output .= "

{$lang_global['are_you_sure']}

"; $output .= ""; } else { $output .= "

{$lang_global['err_no_records_found']}

"; $output .= "

"; makebutton($lang_global['go_back'], "cleanup.php",120); $output .= "

"; } $output .= "
"; break; default: redirect("Location: cleanup.php?error=1"); } $sql->close(); unset($sql); } //################################################################################################ // DO CLEANUP //################################################################################################ function docleanup(){ global $lang_cleanup, $lang_global, $output, $realm_db, $characters_db, $realm_id, $user_lvl, $tab_del_user_characters, $tab_del_user_characters_trinity, $tab_del_user_realmd; if ($server_type) $tab_del_user_characters = $tab_del_user_characters_trinity; if (!isset($_POST['type']) || $_POST['type'] === '') redirect("cleanup.php?error=1"); $sql = new SQL; $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $type = $sql->quote_smart($_POST['type']); if(isset($_POST['check']) && $_POST['check'] != '') { $check = $sql->quote_smart($_POST['check']); $check = explode('-',$check); } else redirect("cleanup.php?error=1"); $deleted_acc = 0; $deleted_chars = 0; $deleted_gulds = 0; require_once("./libs/del_lib.php"); switch ($type){ //we deleting account array case "acc": for ($i = 1; $i < count($check); $i++) { if ($check[$i] != "" ) { list($flag,$del_char) = del_acc($check[$i]); if ($flag) { $deleted_acc++; $deleted_chars += $del_char; } } } break; //we deleting character array case "char": for ($i = 1; $i < count($check); $i++) { if ($check[$i] != "" ) { if (del_char($check[$i], $realm_id)) $deleted_chars++; } } break; //cleaning guilds case "guild": for ($i = 1; $i < count($check); $i++) { if ($check[$i] != "" ) { if (del_guild($check[$i], $realm_id)) $deleted_gulds++; } } break; //cleaning arena teams case "arenateam": for ($i = 1; $i < count($check); $i++) { if ($check[$i] != "" ) { if (del_arenateam($check[$i], $realm_id)) $deleted_arenateams++; } } break; default: redirect("cleanup.php?error=1"); } $sql->close(); unset($sql); $output .= ""; if ($type == "guild") { if (!$deleted_gulds) $output .= "

{$lang_cleanup['no_guilds_del']}

"; else $output .= "

{$lang_cleanup['total']} $deleted_gulds {$lang_cleanup['guilds_deleted']}

"; } else { if ($type == "arenateam") { if (!$deleted_arenateams) $output .= "

{$lang_cleanup['no_arenateams_del']}

"; else $output .= "

{$lang_cleanup['total']} $deleted_arenateams {$lang_cleanup['arenateams_deleted']}

"; } else { if (($deleted_acc+$deleted_chars) == 0) $output .= "

{$lang_cleanup['no_acc_chars_deleted']}

"; else { $output .= "

{$lang_cleanup['total']} $deleted_acc {$lang_cleanup['accs_deleted']}

"; $output .= "

{$lang_cleanup['total']} $deleted_chars {$lang_cleanup['chars_deleted']}

"; } } } $output .= "

"; $output .= "

"; makebutton($lang_cleanup['back_cleaning'], "cleanup.php", 200); $output .= "

"; } //######################################################################################################################## // MAIN //######################################################################################################################## $err = (isset($_GET['error'])) ? $_GET['error'] : NULL; $output .= "

"; switch ($err) { case 1: $output .= "

{$lang_global['empty_fields']}

"; break; default: //no error $output .= "

{$lang_cleanup['clean_db']}

"; } $output .= "

"; $action = (isset($_GET['action'])) ? $_GET['action'] : NULL; switch ($action) { case "run_cleanup": run_cleanup(); break; case "docleanup": docleanup(); break; default: cleanup(); } require_once("footer.php"); ?>