How to keep chars on specific map and delete the rest?

[Gouki]

Hi,

Is it possible to run a SQL script to delete all characters  except for a specific map?

EX:
Keep all characters inside Prontera, rest of Ragnarok delete.

Edited September 1, 2020 by Almond Snicker

[TheKingDino]

This request is kind of confusing. Do you want the player's characters to be deleted(outside Prontera)? Or do you just want all the NPCs?

There is a way to do both. You may want a way to automate it if you're deleting a lot of characters. But there's a column named "last_map" within your char table. You could hit the last_map button above it and it'll sort the rows then manually delete every character that isn't on "prontera"

Edited September 2, 2020 by TheKingDino

[Gouki]

18 hours ago, TheKingDino said:

This request is kind of confusing. Do you want the player's characters to be deleted(outside Prontera)? Or do you just want all the NPCs?

There is a way to do both. You may want a way to automate it if you're deleting a lot of characters. But there's a column named "last_map" within your char table. You could hit the last_map button above it and it'll sort the rows then manually delete every character that isn't on "prontera"

yup characters, ahh yea, that's a way by sorting the database. okay thank you so much!

[Emistry]

shut down the server and run the SQL query

DELETE FROM `char` WHERE `last_map` <> 'prontera'

if you want a cleaner database, then you should remove records that stored in other table, whichever that are related with char info. (mostly consists of the char_id column in it)