April Changelog

 [4/17/24]
- reboot mysql server and reload database from backups
- picked random spot and start fixing translation issues and variable names
- improve the -DWITH_ZLIB = system check
- MySql libraries up to 8.3

[4/18/24]
- fix issue with loading weekly quest strings
- refactor how rows in SQL are iterated through
- fix resources being allocated when not needed on KDA tracking
- spell window translations
- revert to earlier version of MySQL until FORWARD_ONLY ResultSets are fixed

[4/19/24]
- fix issue with fishing times being saved incorrectly

[4/20/24]
- fix training dummies not giving exp to players
- format several quest dialogues
- Loudspeakers can now be used at level 82
- add Bunny Shop Naflin to Giran
- add several items to Bunny Shop
- fix wand of conjure lightning

- add exception handling on server launch

- fix potential NullPointerException in V2MapReader

- remove double checking on mobskill use for skill 7023

[4/21/24]

- upgrade Eclipse IDE to 2024-03

- impossible to find furniture instances can now be found

- remove double checking for a sender on pledge mail

- as always, lots of translations

- double checking of spellbook 3000091

- add stackTracing to several places that needed it. This will make it easier to track down bugs

- improve random number quality for lottery tickets

- synchronized EventItemController to guarantee thread safety

- synchronized NpcChatTimeController to guarantee thread safety

[Performance]

- fix two instances of double boxing

- clean up resources after item loading

- remove excess garbage collection on server start

- remove unnecessary casting toString() in several places

- fix several instances where strings could be parsed directly to int, avoiding overhead of boxing/unboxing

[Security]

- one instances of potential SQL injection

[4/22/24]

- applied new techniques to prevent thread locking

- synchronised getLevel() to prevent race conditions

[Performance]

- Use nextInt method of Random rather than nextDouble to generate a faster random npc spawner

- fix 5 methods invoking inefficient new String, improving response time for buddy lists, party member names, etc

- fix 3 instances of toString on already String

- fix 11 instances of inefficient use of keySet iterator instead of entrySet iterator

- fix 21 instances of boxing/unboxing to parse a primitive

[4/23/24]

- fix Black Knight quest not rewarding the Scroll of Escape

- fix Combat Enhancement quest not rewarding scrolls

- increase Gunther teleport access to 82:small_red_triangle:

- fix Instructor Theon teleport locations, add new ones

- test run quests for 1-55, all working as intended

[4/24/24]

- database translations

- cleared badnames list

- add Primordial Jade Chain, B-teles to Bunny Shop

[4/26/24]

- translate the rest of the crafting NPC names in giran

- remove second Talas

- setup external access for people wanting to help translate documents

- fix teleporter Lupin error message

- new NPC **Mr Nostalgia** sells various nostalgic items/tools in Giran

- add .light for GM

[New Item]

- Scroll of Nostalgia 1f to 5f, teleports player to Tower of Insolence

[4/27/24]

- fix Elemental Battle Arrow prices

- fix Royal unable to learn spell Empire

- add new GM commands

- add Kratos memorabilia to Giran

- update intro npc in RKT

- add Helper NPC to RKT

- add Dolly Parton NPC to Giran, sells level 1 to 4 Magic Dolls

- remove duplicate Cassiopia spawns

- add option to skip to level 55

- lower Kurtz respawn time to allow people to finish quests