Open PlayerCommand.java:
Find:
Add Above:
Find:
Add Above::
Enjoy, working changename with sql update.
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.
Last edited: