Das geht nur direkt über die Datenbank. Ich habe hier ein Script, das du dann eben noch auf deine Bedürfnisse anpassen müsstest. Verwendung auf eigene Gefahrt
Code
.open game.db
delete from buildable_health where object_id in (select distinct object_id from buildings where owner_id in (select id from characters where playerid in (SteamID64))) or object_id in (select distinct object_id from buildings where owner_id in (GuildID));
delete from building_instances where object_id in (select distinct object_id from buildings where owner_id in (select id from characters where playerid in (SteamID64))) or object_id in (select distinct object_id from buildings where owner_id in (GuildID));
delete from properties where object_id in (select distinct object_id from buildings where owner_id in (select id from characters where playerid in (SteamID64))) or object_id in (select distinct object_id from buildings where owner_id in (GuildID));
delete from actor_position where id in (select distinct object_id from buildings where owner_id in (select id from characters where playerid in (SteamID64))) or id in (select distinct object_id from buildings where owner_id in (GuildID));
delete from properties where object_id in (select id from characters where playerid in (SteamID64)) or object_id in (GuildID);
delete from buildings where owner_id in (select id from characters where playerid in (SteamID64)) or owner_id in (GuildID);
delete from item_properties where owner_id in (select id from characters where playerid in (SteamID64)) or owner_id in (GuildID);
delete from item_inventory where owner_id in (select id from characters where playerid in (SteamID64)) or owner_id in (GuildID);
delete from actor_position where id in (select id from characters where playerid in (SteamID64)) or id in (GuildID);
delete from character_stats where char_id in (select id from characters where playerid in (SteamID64));
delete from characters where playerid in (SteamID64);
delete from guilds where guildid in (GuildID);
delete from buildable_health where object_id in (select distinct object_id from buildings where owner_id not in (select id from characters) and owner_id not in (select guildid from guilds));
delete from building_instances where object_id in (select distinct object_id from buildings where owner_id not in (select id from characters) and owner_id not in (select guildid from guilds));
delete from properties where object_id in (select distinct object_id from buildings where owner_id not in (select id from characters) and owner_id not in (select guildid from guilds));
delete from actor_position where id in (select distinct object_id from buildings where owner_id not in (select id from characters) and owner_id not in (select guildid from guilds));
delete from item_properties where owner_id in (select distinct owner_id from buildings where owner_id not in (select id from characters) and owner_id not in (select guildid from guilds));
delete from properties where object_id in (select distinct object_id from properties where name like '%Player%') and object_id not in (select id from characters) and object_id not in (select guildid from guilds);
delete from item_inventory where owner_id in (select distinct owner_id from buildings where owner_id not in (select id from characters) and owner_id not in (select guildid from guilds));
delete from buildings where owner_id not in (select id from characters) and owner_id not in (select guildid from guilds);
delete from account where user not in (select playerid from characters);
VACUUM;
REINDEX;
ANALYZE;
pragma integrity_check;
.quit
Alles anzeigen