- Joined
- Feb 1, 2009
- Messages
- 738
- Reaction score
- 291
[Guide] How to Delete Inactive Characters in Aion Online Server:
[Урок] Как да изтрием неактивните герой във своя Айон Сървър:
Code For Query:
Кодът е за Query:
Във червено съм ви отбелязал датата където може да посочите до коя дата са били активни геройте.
Original Script Aion Unique
Moded Script by me for Aion Core
[Урок] Как да изтрием неактивните герой във своя Айон Сървър:
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: