- 0
-
Posts
-
By SephirothFx · Posted
Tenho interesse por favor envia link do seu discord nao esta ativo o user nao encontrado. -
Hello, I am currently using Mobius 2.8 Seven Signs (Subscriber Version). I have increased the inventory capacity from 80 slots to 500 slots. The problem is that when the number of items exceeds 200, opening the inventory causes a delay of about 1–2 seconds. If the inventory is empty or contains only a small number of items, there is no lag at all, but when the item count goes over 200 or 300, the delay increases accordingly. Is there anyone who could fix this issue? -
Include prices otherwise no point allowing you to have such topic. -
you never replied to the private message -
By Utchiha-Market · Posted
Discord : utchiha_market Telegram : https://t.me/utchiha_market Auto Buy Store : https://utchiha-market.mysellauth.com/ Not sure if we’re legit? Check Our server — real reviews, real buyers https://discord.gg/4EPpYhe2HA | https://campsite.bio/utchihaamkt
-
-
-
-
Topics
-
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