[HELP] Saving name color into Database.

[luk19as]

Hello guys, i really need help saving the color i chose into the database.

I made a color manager where I can choose colors, but after i chose for example red it wont save after i do restart (relog).

 

This is the Java code in L2PcInstance:

public void saveName(int color){//
  Connection con = null;
  
try
  {

   con = L2DatabaseFactory.getInstance().getConnection(false);
   PreparedStatement statement;
   statement = con.prepareStatement("UPDATE characters SET name_color=?"+color+" WHERE account_name='"+_accountName+"'");
   statement.setString(1, StringToHex(Integer.toHexString(color).toUpperCase()));
   statement.execute();
   statement.close();
   statement = null;
   getAppearance().setNameColor(color);

   broadcastUserInfo();
  }
  catch(Exception e){}
  finally
  {
   CloseUtil.close(con);
con = null;
  }

}

 

This is the code for one color in python .py file:

if event == "1":
           if st.getQuestItemsCount(57) > 250000:
                st.takeItems(57,250000)
                st.getPlayer().getAppearance().setNameColor(0x009900)
	st.getPlayer().broadcastUserInfo();
                return "1.htm"
            if st.getQuestItemsCount(57) <= 250000:
                return "Announcements: No Enought Adena To Select Color!"
            st.exitQuest(0)

 

How can i make my name color to save after i do restart?

Please answer.

[xdem]

create a L2PcInstance method which will get the color and save it into the db for example: go to L2PcInstance and create a void like this:

public void storeTittleColor(int color)

{

    //store it in the database

}

 

the go to your py file and add this st.getPlayer.storeTittleColor(the color you want ex:0x009900)

 

[Tryskell]

- "= null" stuff is pointless.

- your statement sucks : "UPDATE characters SET name_color=?"+color+" WHERE account_name='"+_accountName+"'", parameters should be applied following regular use.

- you create a method named saveName, but don't even use it on your python script. How do you want it works ?

[xdem]

- "= null" stuff is pointless.

- your statement sucks : "UPDATE characters SET name_color=?"+color+" WHERE account_name='"+_accountName+"'", parameters should be applied following regular use.

- you create a method named saveName, but don't even use it on your python script. How do you want it works ?

 

he also uses "where aacountId" this sucks he has to do it by player OID"

[luk19as]

Can you give me the proper code for:

{

    //store it in the database

}

 

I tried but my one didn't work :D

 

Thanks in advance.

[xdem]

i dont know man , every pack connects with your DB diffrent I dont know how your works, if you have h5 i will do this for you when I got free time, but if you dont h5 I won't even try ...

[luk19as]

Okay I have remade the code a little and the python file as well.

 

Java Code:

 

	private static final String UPDATE_CHAR_COLOR = "UPDATE character_color SET name_color=?, WHERE charId=?";
public void saveNameColor(int color){

	Connection con = null;
	PreparedStatement statement = null;

	  
	try
	  {

	   con = L2DatabaseFactory.getInstance().getConnection(false);
	   statement = con.prepareStatement(UPDATE_CHAR_COLOR);
	   statement.setString(1, StringToHex(Integer.toHexString(color).toUpperCase()));
	   statement.setInt(2, getObjectId());
	   getAppearance().setNameColor(color);
	   broadcastUserInfo();
	   statement.execute();
	   statement.close();
	  }
	   catch(Exception e){}
	   finally
	   {
	    CloseUtil.close(con);
	   }
}

 

 

Python Code:

        if event == "1":
            if st.getQuestItemsCount(57) > 250000:
                st.takeItems(57,250000)
                st.saveNameColor(0x009900)
                return "1.htm"
            if st.getQuestItemsCount(57) <= 250000:
                return "Announcements: No Enought Adena To Select Color!"
            st.exitQuest(0)

 

But still no luck ://