C6 Clan crest

[phanie]

I think I found a bug. When I delete the crest from the clan and execute the server restart, the crest comes back next.

[G-hamsteR]

I just confirmed it. The bug is there.

[G-hamsteR]

You can try this:

Code: [Select]

diff --git a/java/org/l2jmobius/gameserver/network/clientpackets/RequestSetPledgeCrest.java b/java/org/l2jmobius/gameserver/network/clientpackets/RequestSetPledgeCrest.java
index 7985986..1088700 100644
--- a/java/org/l2jmobius/gameserver/network/clientpackets/RequestSetPledgeCrest.java
+++ b/java/org/l2jmobius/gameserver/network/clientpackets/RequestSetPledgeCrest.java
@@ -93,6 +93,18 @@
  member.broadcastUserInfo();
  }
 
+ try (Connection con = DatabaseFactory.getConnection())
+ {
+ final PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET crest_id = ? WHERE clan_id = ?");
+ statement.setInt(1, 0);
+ statement.setInt(2, clan.getClanId());
+ statement.executeUpdate();
+ statement.close();
+ }
+ catch (SQLException e)
+ {
+ LOGGER.warning("could not update the crest id:" + e.getMessage());
+ }
  return;
  }
 


[G-hamsteR]

I just tested it and the patch is working

[phanie]

It works! Nice.

[Mobius]

Fixed with https://bitbucket.org/MobiusDev/l2j_mobius/commits/8e54a5d5b8c8f6f2350ced3c01536436a397df16
Thanks