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

[Apolokie 0]

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 June 5, 2023 by Apolokie

[Apolokie 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 June 5, 2023 by Apolokie

[IndieRO 33]

bro u must use old geffenia file to avoid crash

[Apolokie 0]

6 hours ago, IndieRO said:

bro u must use old geffenia file to avoid crash

Do you know if there is a thread/guide for installing that file?