[Guide] How to Delete Inactive Characters

NoFeaR

Well-Known Member
Joined
Feb 1, 2009
Messages
738
Reaction score
291
[Guide] How to Delete Inactive Characters in Aion Online Server:
[Урок] Как да изтрием неактивните герой във своя Айон Сървър:

Code For Query:
Кодът е за Query:


Code:
DELETE FROM `ac_server_ls`.`account_time` WHERE last_active < "[COLOR="Red"]2010-05-30 00:00:00[/COLOR]";
DELETE FROM `ac_server_ls`.`account_data` WHERE id NOT IN (SELECT account_id FROM `ac_server_ls`.`account_time`);
DELETE FROM `ac_server_gs`.`players` WHERE account_id NOT IN (SELECT id FROM `ac_server_ls`.`account_data`);
DELETE FROM `ac_server_gs`.`player_appearance` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_macrosses` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_quests` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_settings` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_skills` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_recipes` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_punishments` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_effects` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`friends` WHERE friend NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`player_titles` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`legion_members` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`abyss_rank` WHERE player_id NOT IN (SELECT id FROM `ac_server_gs`.`players`);
DELETE FROM `ac_server_gs`.`inventory` WHERE itemOwner NOT IN (SELECT id FROM `ac_server_gs`.`players`);

Във червено съм ви отбелязал датата където може да посочите до коя дата са били активни геройте.
Original Script Aion Unique
Moded Script by me for Aion Core
 
Last edited: