Jump to content
  • 0
Sign in to follow this  
Apolokie

PreRE. Moving a character that is stuck on a map. Game crashes during login attempt. [Solved]

Question

Player accessed Geffenia. Loaded the map and crashed. Now that player is stuck. Is there a way to set this players spawn point?

 

Tried logging into an Admin account and jailing the player, but since they can't login, it  just says they can't be found.

 

Any help is appreciated.

Edited by Apolokie

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Answered my own question. Here is how to change a characters spawn location.

 

Launch Open Server. Click on 'Run Server". The flag icon will turn green. Click on the green flag icon and go to Advanced - PhpMyAdmin.

 

A new window will open in your browser. You will need to login with the username: "root" Leave the password blank. Click on the "Go" icon to login.

 

On the left side you will see: New, 4cram, herc, information_schema, etc.

 

You need to access the following: herc -> pre -> herc_pre_db -> char

 

Click on the "char" text. The larger portion of the window will load and show you all the characters of the server.

 

Find the name of the character who is stuck and click on the pencil icon next to their name. The larger portion of the window will load statistics you can edit.

 

Scroll down until you find "last_map". Geffenia is listed for me, but might not for you. Change this to prontera, or izlude, or a safe map of your choosing.

 

Scroll all the way down, you will see three buttons. 'Preview SQL', 'Reset' and 'Go'. Click on 'Go'.

 

Done.

 

Edited by Apolokie

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.   Restore formatting

  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.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

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