[release]"@changename" fix.

[red7711]

Open PlayerCommand.java:

Find:

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

Add Above:

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

Find:

player.getMap().addPlayer(player);

Add Above::

                                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.

 

[ishan1996]

Re: "@changename" fix.

gj

Will be testing!

 

[dragonsin53]

Re: "@changename" fix.

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

 

[red7711]

Re: "@changename" fix.

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

 

[Moogra]

Re: "@changename" fix.

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

 

[red7711]

Re: "@changename" fix.

no, he stuck the player

 

[Moogra]

Re: "@changename" fix.

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

 

[red7711]

Re: "@changename" fix.

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

i check it...

 

[Moogra]

Re: "@changename" fix.

@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.

 

[TookTook123]

Re: "@changename" fix.

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

 

[Moogra]

Re: "@changename" fix.

it's already there.

 

[TookTook123]

Re: "@changename" fix.

it's already there.

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

 

[Azora]

Nice release
i guess it could be usefull.

 

[Cyberbully]

c.getPlayer().saveToDB();

nuff said?

 

[Mgssidley]

Oh cool thanks, hope it works.

 

[dragonsin53]

Hmm so can anyone of you just post the whole @changename code here??I downloaded sinems repack xD.Dont want to download moogra to find that command.

 

[Pwnnned]

Moogra's your does stuck the player. And will require a server restart, hes works good. Nice job.

 

[red7711]

savetoDB isnt saves name, but you can add name paramter..