c65191ed7e
Update shop items SQL function for Eva (1340/1043004) player shop
2026-06-17 14:18:33 -04:00
4ec0fc4b57
Update shop data SQL function for Eva (1043004)
2026-06-17 13:57:42 -04:00
dfaab7e20a
Update/tune global drop SQL function for Gachapon tickets
2026-06-17 13:51:03 -04:00
c659e3170d
Ignore server config.yaml in .gitignore
2026-06-17 13:39:02 -04:00
70b2059ad5
Update GmShopCommand for Eva (1043004) shop (1430)
2026-06-17 13:35:33 -04:00
93facf54df
Update ItemConstants.java for new hair/face IDs
2026-06-17 13:32:35 -04:00
574844faed
Update Character.wz for v175 cosmetics
2026-06-16 21:48:34 -04:00
1167eb1844
Update String.wz with new coemtics/NPCs
2026-06-16 21:30:03 -04:00
377f9815eb
Update Cash Shop (Commodity) with new cosmetics, removed Pay2Win
2026-06-16 21:27:52 -04:00
c30ae34a9d
Update Free Market Entrance w/ new NPCs
2026-06-16 20:53:17 -04:00
7bfc6767e1
Add Avery (1043002), Ivy (1043003) and Eva (1043004) NPCs to wz
2026-06-16 20:45:06 -04:00
5c30f55b8a
Remove all LvMAX restraints on quests
2026-06-16 20:15:01 -04:00
f257930447
Add Avery (1043002) & Ivy (1043003) Hair/Face NPC scripts
2026-06-16 20:04:21 -04:00
Ponk
fec53bc771
Merge pull request #334 from anliting/fix-quest-21010-reward #patch
...
Fix quest 21010 reward.
2026-02-03 17:55:01 +01:00
An-Li Ting
02380aeee9
Fix quest 21010 reward.
2026-02-03 01:49:31 +08:00
Ponk
cf5ba09233
Merge pull request #314 from xstupidcow/fix/missing-table-when-deleting-character #patch
...
Fix missing table when deleting character
2025-08-03 15:35:49 +02:00
TN
41adae8278
Remove server_queue table
2025-08-03 19:57:10 +07:00
Ponk
265afb6b15
Merge pull request #230 from PaperChonChon/master #patch
...
NPC 2040022.js is removing items even if player does not have all materials to craft it. party3_jailin.js - Map is unpassable as the top layer spears will not hit mobs
2025-07-29 10:32:18 +02:00
Ponk
9101cd189c
Merge pull request #311 from P0nk/cleanup/custom-npc-scripts #minor
...
Remove custom NPC scripts
2025-07-22 14:57:28 +02:00
P0nk
196e3efec7
Remove support for custom NPC
2025-07-22 14:48:31 +02:00
P0nk
7adce5e2af
Remove custom NPC script: Agent E accessory crafter
2025-07-22 14:41:19 +02:00
P0nk
c9aa049874
Remove custom NPC script: Coco chaos synthesizer
2025-07-22 14:38:44 +02:00
P0nk
58d6603946
Remove custom NPC script: Asia shop
2025-07-22 14:34:01 +02:00
P0nk
bfd9f68805
Remove custom NPC script: Dalair equipment merge
2025-07-22 14:29:58 +02:00
P0nk
44c2b77595
Remove custom NPC script: Donation Box bulk selling
2025-07-22 14:25:11 +02:00
P0nk
5148d76f9f
Remove custom NPC script: T-1337 shop
2025-07-22 14:18:32 +02:00
P0nk
45bfc395be
Remove custom NPC script: Spiegelmann ore refining
2025-07-22 14:06:52 +02:00
P0nk
8052814028
Remove custom NPC script: scroll generator
2025-07-22 14:06:51 +02:00
Ponk
1eeb2483bf
Merge pull request #309 from P0nk/feat/liquibase #major
...
Use Liquibase for automated database schema & data migrations
2025-07-22 10:44:04 +02:00
P0nk
2aabeb378c
Tune global drops
...
Global drops are too common, and the ones we have here are not part of vanilla v83
2025-07-22 10:36:36 +02:00
P0nk
7054d37b58
Remove duplicate items from the GM shop
2025-07-22 10:24:26 +02:00
P0nk
64b20aa659
Remove test table
2025-07-14 21:46:42 +02:00
P0nk
42bb664add
Support running additional changelogs at the end
...
In case you want to add your own custom stuff or change drops or something else.
2025-07-14 21:41:39 +02:00
P0nk
97ed3d2da5
Split into multiple changelogs
2025-07-14 20:32:43 +02:00
P0nk
e2ac5e448b
Switch from manual sql scripts to automated scripts with Liquibase
2025-07-06 19:49:54 +02:00
P0nk
2365458b78
Add admin account
2025-07-06 19:02:46 +02:00
P0nk
c807c1e54f
Remove custom shops
2025-07-06 17:56:49 +02:00
P0nk
6d647e8010
Add Rien shops' items
2025-07-06 17:50:06 +02:00
P0nk
1dce65d146
Add GM shop items
2025-07-06 17:48:25 +02:00
P0nk
8ceb60329d
Add missing equips in Singapore shops
2025-07-06 17:36:01 +02:00
P0nk
f240c7e98b
Remove duplicate drops
...
Some of these duplicate drops should be kept,
but are removed for the sake of efficiency.
For example, Stumpy (3220000) should drop multiple Tree Branch (4000003) and Leaf (4000005), but the duplicate have been removed.
To fix this, one has to go through the removed drops in this commit and manually reintroduce the drops that should have been kept. The "RemoveDuplicateDrops" tool simplifies this a little bit as it produces a file with all the removed drops. As of writing this, it removed duplicate drops from 415 mobs, for a total of 7331 removed drops.
The following SQL query finds the amount of duplicate drops in the database:
SELECT COUNT(*) total_mobs_with_duplicate_items, SUM(extra_item_drops) AS total_duplicate_items
FROM (SELECT dropperid, SUM(extras) AS extra_item_drops
FROM
(SELECT dropperid, itemid, COUNT(*) - 1 AS extras
FROM lb_drop_data
GROUP BY dropperid, itemid
HAVING COUNT(*) > 1) AS i
GROUP BY dropperid
ORDER BY dropperid
) AS i2
2025-07-06 14:47:02 +02:00
P0nk
f5c17768f4
Add RemoveDuplicateDrops tool
2025-07-06 14:12:27 +02:00
P0nk
d08e1c4567
Remove drops from nonexistent mobs
2025-07-06 11:26:01 +02:00
P0nk
e7d94ee4fb
Update skill & mastery books drop chances and fix max quantities
2025-07-06 11:16:36 +02:00
P0nk
89dfc37551
Refactor SkillbookChanceFetcher & add logs
...
Less static variables and generally cleaner code
2025-07-06 10:44:51 +02:00
P0nk
02f45397ce
Remove duplicate mastery book drops
2025-07-05 21:48:25 +02:00
P0nk
82e377f39a
Temp drop data table in separate changeset
2025-07-05 21:14:56 +02:00
P0nk
7227be3189
Remove Final Blow mastery book drop from unknown mob
2025-07-05 21:07:24 +02:00
P0nk
cad04a4725
Update drop chance that are 1500 (1/6666) to 1287 (1/7777)
2025-07-05 16:36:48 +02:00
P0nk
a2d6b88cde
Update bow/crossbow arrow drop quantities
2025-07-05 16:30:23 +02:00
