[release]"@changename" fix.

Open PlayerCommand.java:

Find:

Code:

---

import net.sf.odinms.net.channel.ChannelServer;

---

Add Above:

Code:

---

import net.sf.odinms.database.DatabaseConnection;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

---

Find:

Code:

---

player.getMap().addPlayer(player);

---

Add Above::

Code:

---

                                try {
                  Connection con = DatabaseConnection.getConnection();
                  PreparedStatement ps;
                 
                    String newname = StringUtil.joinStringFrom(splitted, 1);
                    ps = con.prepareStatement("UPDATE characters SET name = ? WHERE id = ?");
                    ps.setString(1, newname);
                    ps.setInt(2, player.getId());
                    ps.executeUpdate();
                        } catch (SQLException e) {
            mc.dropMessage("Some errors in mysql.");
        }

---

Enjoy, working changename with sql update.

gj :drool:

Will be testing!

Erm can i ask you where is the change name command link??I cant find it in the release section

you can found it on Moogra repack.
if you need help just pm me.

this makes it so you have to be logged off. Plus, mine works I think

no, he stuck the player

no... it reloads the player, you're missing methods

its not update the sql
so you have two players
one stuck with no sql data
and one that cant connect

i check it...

@changename changes 1 person's name. It changes your own name. I've checked. It updates when you log off. I checked. It goes through maplecharacter.java's savetodb. I checkd.

Quote:

---

Originally Posted by red7711

its not update the sql
so you have two players
one stuck with no sql data
and one that cant connect

i check it...

---

oo, there is a simple fix for it...
go to maplecharacter.java
in saveToDB Function
add ,name = ?
before WHERE id = ?
then few lines under that
ps.setString(xx, name); //change xx to the next number it should be..
after
ps.setInt(xx, id); // xx is id positon
it should be after if (update) {
look for it...

it's already there.

Quote:

---

Originally Posted by Moogra

it's already there.

---

dependent in what repack you use..
guess hes repack doesnt include that..

Nice release :)
i guess it could be usefull.

c.getPlayer().saveToDB();

nuff said?

Oh cool thanks, hope it works.