Jump to content
  • 0
Sign in to follow this  
Almond Snicker

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

Question

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 by Almond Snicker

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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 by TheKingDino

Share this post


Link to post
Share on other sites
  • 0
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!

Share this post


Link to post
Share on other sites
  • 0

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)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.