This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..
Question
Kzah
Hello,
After the installation of Dressme : http://pastebin.com/5AYHVPit
All passes correctly, except that the GS grumbles a little :
Here are the concerned codes :
private void restoreVisualArmors() { try { Connection con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT * FROM character_visual_armors WHERE charId=?"); statement.setInt(1, getObjectId()); ResultSet rset = statement.executeQuery(); if (rset.next()) { isUsingVisualArmors(rset.getBoolean("isUsingVisual")); setVisualArmor(VisualArmors.Armor, rset.getInt("armor")); setVisualArmor(VisualArmors.Legs, rset.getInt("leggings")); setVisualArmor(VisualArmors.Feet, rset.getInt("feet")); setVisualArmor(VisualArmors.Gloves, rset.getInt("gloves")); setVisualArmor(VisualArmors.LHand, rset.getInt("lHand")); setVisualArmor(VisualArmors.Sword, rset.getInt("sword")); setVisualArmor(VisualArmors.Bow, rset.getInt("bow")); setVisualArmor(VisualArmors.Pole, rset.getInt("pole")); setVisualArmor(VisualArmors.Dual, rset.getInt("dualWeapons")); setVisualArmor(VisualArmors.BigSword, rset.getInt("bigSword")); } rset.close(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Could not restore " + getObjectId() + " visual armors data " + e.getMessage(), e); } }private void storeVisualArmors() { if (!checkIfExist()) { insertVisualArmors(); } // UPDATE characters SET vitality_points=?,language=? WHERE charId=?"; try { Connection con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("UPDATE character_visual_armors SET isUsingVisual=?,armor=?,leggings=?,feet=?,gloves=?,sword=?,bow=?,pole=?,dualWeapons=?,bigSword=?,lHand=? WHERE charId=?"); statement.setInt(1, isUsingVisualArmors() ? 1 : 0); statement.setInt(2, getVisualArmor(VisualArmors.Armor, true) == null ? 0 : getVisualArmor(VisualArmors.Armor, true).getItemId()); statement.setInt(3, getVisualArmor(VisualArmors.Legs, true) == null ? 0 : getVisualArmor(VisualArmors.Legs, true).getItemId()); statement.setInt(4, getVisualArmor(VisualArmors.Feet, true) == null ? 0 : getVisualArmor(VisualArmors.Feet, true).getItemId()); statement.setInt(5, getVisualArmor(VisualArmors.Gloves, true) == null ? 0 : getVisualArmor(VisualArmors.Gloves, true).getItemId()); statement.setInt(6, getVisualArmor(VisualArmors.Sword, true) == null ? 0 : getVisualArmor(VisualArmors.Sword, true).getItemId()); statement.setInt(7, getVisualArmor(VisualArmors.Bow, true) == null ? 0 : getVisualArmor(VisualArmors.Bow, true).getItemId()); statement.setInt(8, getVisualArmor(VisualArmors.Pole, true) == null ? 0 : getVisualArmor(VisualArmors.Pole, true).getItemId()); statement.setInt(9, getVisualArmor(VisualArmors.Dual, true) == null ? 0 : getVisualArmor(VisualArmors.Dual, true).getItemId()); statement.setInt(10, getVisualArmor(VisualArmors.BigSword, true) == null ? 0 : getVisualArmor(VisualArmors.BigSword, true).getItemId()); statement.setInt(11, getVisualArmor(VisualArmors.LHand, true) == null ? 0 : getVisualArmor(VisualArmors.LHand, true).getItemId()); statement.setInt(12, getObjectId()); statement.execute(); } catch (Exception e) { _log.log(Level.WARNING, "Could not store character " + getObjectId() + " visual armors data: ", e); } }private boolean checkIfExist() { try { Connection con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT charId FROM character_visual_armors WHERE charId=?"); statement.setInt(1, getObjectId()); try (ResultSet rset = statement.executeQuery()) { if (rset.next()) { return true; } } } catch (Exception e) { _log.log(Level.WARNING, "Could not restore " + getObjectId() + " visual armors data " + e.getMessage(), e); } return false; }How to solve these problems?
Thank You.
4 answers to this question
Recommended Posts