Request Title Color

[Guesswho777]

Greetings l2j developers

 

I have got a problem:

I am using l2jserver and title color after restart becomes white.

 

Can anyone help me solve this issue?

[xdem]

ah, just noticed you are talking about characters table. You are right, sorry

 

np, ur welcome 

[SweeTs]

Index: aCis_gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminEditChar.java
===================================================================
--- aCis_gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminEditChar.java    (revision 203)
+++ aCis_gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminEditChar.java    (working copy)
@@ -343,7 +343,8 @@
                 else
                     return false;
                 
-                player.getAppearance().setNameColor(Integer.decode("0x"+val));
+                //player.getAppearance().setNameColor(Integer.decode("0x"+val));
+                player.setNameColor(val);
                 player.sendMessage("Your name color has been changed by a GM.");
                 player.broadcastUserInfo();
             }
@@ -366,7 +367,8 @@
                 else
                     return false;
                 
-                player.getAppearance().setTitleColor(Integer.decode("0x" + val));
+                //player.getAppearance().setTitleColor(Integer.decode("0x" + val));
+                player.setTitleColor(val);
                 player.sendMessage("Your title color has been changed by a GM.");
                 player.broadcastUserInfo();
             }
Index: aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java
===================================================================
--- aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java    (revision 203)
+++ aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java    (working copy)
@@ -246,8 +246,8 @@
 
     // Character SQL String Definitions:
     private static final String INSERT_CHARACTER = "INSERT INTO characters (account_name,obj_Id,char_name,level,maxHp,curHp,maxCp,curCp,maxMp,curMp,face,hairStyle,hairColor,sex,exp,sp,karma,pvpkills,pkkills,clanid,race,classid,deletetime,cancraft,title,accesslevel,online,isin7sdungeon,clan_privs,wantspeace,base_class,newbie,nobless,power_grade,last_recom_date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
-    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,sex=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,punish_level=?,punish_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=? WHERE obj_id=?";
-    private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, punish_level, punish_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level FROM characters WHERE obj_id=?";
+    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,sex=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,punish_level=?,punish_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=?,name_color=?,title_color=? WHERE obj_id=?";
+    private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, punish_level, punish_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level,name_color,title_color FROM characters WHERE obj_id=?";
     
     // Character Subclass SQL String Definitions:
     private static final String RESTORE_CHAR_SUBCLASSES = "SELECT class_id,exp,sp,level,class_index FROM character_subclasses WHERE char_obj_id=? ORDER BY class_index ASC";
@@ -641,6 +641,30 @@
     private double _mpUpdateDecCheck = .0;
     private double _mpUpdateInterval = .0;
 
+    //===================================
+    // EarthLii Custom's
+
+    private String _nameColor;
+    private String _titleColor;
+    public void setNameColor(String _color){
+        _nameColor = _color;
+        getAppearance().setNameColor(Integer.decode("0x"+_nameColor));
+        broadcastUserInfo();
+    }
+    public String getNameColor(){
+        return _nameColor;
+    }
+    public void setTitleColor(String _color){
+        _titleColor = _color;
+        getAppearance().setTitleColor(Integer.decode("0x"+_titleColor));
+        broadcastUserInfo();
+    }
+    public String getTitleColor(){
+        return _titleColor;
+    }
+
+    //===================================
+
     /** Char Coords from Client */
     private int _clientX;
     private int _clientY;
@@ -6183,6 +6207,9 @@
                 player.setNewbie(rset.getInt("newbie")==1);
                 player.setNoble(rset.getInt("nobless")==1);
 
+                player.setNameColor(rset.getString("name_color"));
+                player.setTitleColor(rset.getString("title_color"));
+
                 player.setClanJoinExpiryTime(rset.getLong("clan_join_expiry_time"));
                 if (player.getClanJoinExpiryTime() < System.currentTimeMillis())
                     player.setClanJoinExpiryTime(0);
@@ -6653,7 +6680,9 @@
             statement.setLong(48, getClanCreateExpiryTime());
             statement.setString(49, getName());
             statement.setLong(50, getDeathPenaltyBuffLevel());
-            statement.setInt(51, getObjectId());
+            statement.setString(51, getNameColor());
+            statement.setString(52, getTitleColor());
+            statement.setInt(53, getObjectId());
 
             statement.execute();
             statement.close();
Index: aCis_gameserver/java/net/sf/l2j/gameserver/network/clientpackets/EnterWorld.java
===================================================================
--- aCis_gameserver/java/net/sf/l2j/gameserver/network/clientpackets/EnterWorld.java    (revision 203)
+++ aCis_gameserver/java/net/sf/l2j/gameserver/network/clientpackets/EnterWorld.java    (working copy)
@@ -157,6 +157,9 @@
         if (Config.PLAYER_SPAWN_PROTECTION > 0)
             activeChar.setProtection(true);
 
+        activeChar.setNameColor(activeChar.getNameColor());
+        activeChar.setTitleColor(activeChar.getTitleColor());
+
         activeChar.spawnMe(activeChar.getX(), activeChar.getY(), activeChar.getZ());
         
         // buff and status icons
 

Found that somewhere in 'garbage' @ aCis forum. Maybe not perfect, but you got the point :troll:

 

For name && title, so you can take what you need, blah blah. OR simply do what others said.

Edited December 5, 2013 by SweeTs

[vampir]

acis have title_color column too? Why? :O

[SweeTs]

acis have title_color column too? Why? :o

It doesn't.. :P

[Guesswho777]

Greetings once again Developers.

 

After trying it again and again I have fixed this issue. Thank you all for your help.

 

However, I have got 1 problem remaining: Clan title color is White by default. Is there any way to change it to retail like?

[Guesswho777]

bump