Hallo Jung & Mädels ,weiß einer wie ich Charakter von meinen Server löschen kann, die sich nicht abgemeldet haben ?
Charakter als Serveradmin löschen
-
Was verstehst du unter löschen? Löschen im Sinne von allen Bauten entfernen oder den Spieler einfach bannen?
-
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
Alles anzeigen.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 -
pippi mod kanns auch
-
Nein Pippi geht auch nicht , schon versucht , die Funktion hat keine Wirkung.
Habe im Discord gefragt warum, sagte einer das diese Funktion sie nur zum Neustart zwingt , aber nicht entfernt.
-
Conan ist leider sehr weit hinten nach, was benutzerfreundlichkeit für Admins (und Entwickler) betrifft. Da hat Ark einigen Vorsprung.
Aber das Script von Lisa ist gut gemacht. Zur Erklärung:
Das sucht die User -ID vom User über die SteamID, die müsstest du ersetzen. Weil so werden die Spieler In die Datenbank geschrieben.
Das kannst du natürlich auch manuell machen (mit SQLite Programm z.B.).
würde auf jedenfall in beiden Fällen ein Backup vorher speichern.
Jetzt mitmachen!
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!