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