1429 Commits

Author SHA1 Message Date
P0nk
1504da67f6 Correct table for 2nd insert 2025-07-01 21:41:14 +02:00
P0nk
d6d8560d23 Consistent Nependeath Seed drop chance 2025-07-01 21:39:51 +02:00
P0nk
325f3b54a6 Fix Horned Mushroom 2 drop 2025-07-01 21:38:25 +02:00
P0nk
bfe174c242 Fix Sparta (lv 100) being dropped by lower lv mobs 2025-07-01 21:36:19 +02:00
P0nk
4747d88f40 Adjust zak and pb thematic drops 2025-07-01 21:13:15 +02:00
P0nk
af1878c3a0 Copy Reinforced Mithril Mutae drops to Obstacle Mutae 2025-07-01 21:09:58 +02:00
P0nk
a365d20fd8 Re-add drops for real(?) Pink Bean 2025-07-01 21:03:58 +02:00
P0nk
8c0350b16c Remove drops from Pink Bean clones 2025-07-01 21:01:50 +02:00
P0nk
c384d31827 Copy Pianus (R) drops to Pianus (L) 2025-07-01 20:57:45 +02:00
P0nk
8533d52c7a Add Bob the snail drops 2025-07-01 20:53:28 +02:00
P0nk
c08003a436 Clean up Freezer drops 2025-07-01 20:44:38 +02:00
P0nk
e9598d407b Apply unusual accessory scroll drops 2025-07-01 20:39:03 +02:00
P0nk
0e7c5358e2 Set minimum drop chance of skill/mastery books to 1/1000 2025-07-01 20:37:43 +02:00
P0nk
5da87f7b22 Add more skill/mastery books 2025-07-01 19:54:39 +02:00
P0nk
6e9ff7fb34 Remove drops from mobs that shouldn't have them 2025-07-01 17:41:47 +02:00
P0nk
7f149d56f0 Remove inexistent drop "[Mastery Book] Wind Booster" 2025-07-01 17:27:14 +02:00
P0nk
bfcadc0691 Apply drops that "should have been present by now" 2025-07-01 17:25:38 +02:00
P0nk
d6ad68d537 Apply horntail drops 2025-07-01 17:24:16 +02:00
P0nk
be98a7ab47 Apply kerning square drops 2025-07-01 17:21:33 +02:00
P0nk
469c70d1d7 Apply kerning square drop removals 2025-07-01 17:12:25 +02:00
P0nk
099275c5a3 Move "spider" drop data 2025-07-01 17:06:50 +02:00
P0nk
419f5d92b4 Allow duplicate drops for the same mob
This previously caused a bunch (327 to be exact) of drops to silently not be inserted due to "INSERT _IGNORE_ INTO drop_data (...)"
2025-07-01 17:01:40 +02:00
P0nk
05ca945145 Add drop data changeset
Not able to run it yet due to duplicate (dropperid, itemid) combos causing the constraint to reject the entire insert
2025-07-01 16:59:30 +02:00
P0nk
543cbafd0b Fix table name 2025-07-01 16:49:14 +02:00
P0nk
131379e39e Clean up tables in old script 2025-07-01 16:43:47 +02:00
P0nk
150754a74b Add global drop data changeset 2025-07-01 16:41:15 +02:00
P0nk
d4c65ed690 Add nxcoupons data changeset 2025-07-01 16:39:41 +02:00
P0nk
295144758d Add specialcashitems data changeset 2025-07-01 16:34:55 +02:00
P0nk
ad63aaad44 Let db generate shopitemid's 2025-07-01 16:31:58 +02:00
P0nk
b05e952268 Let db generate monstercarddata id's 2025-07-01 16:29:03 +02:00
P0nk
193257c25b Let db generate reactordropid's 2025-07-01 16:26:25 +02:00
P0nk
111c4f2677 Apply subsequent removals of reactor drop data 2025-07-01 16:22:31 +02:00
P0nk
84c5216b8f Add complementing reactor drop data 2025-07-01 12:58:49 +02:00
P0nk
0921396c57 Integrate quest id adjustments to reactor drop data 2025-07-01 12:51:06 +02:00
P0nk
8b76a28458 Add reactor drops data changeset 2025-07-01 12:42:55 +02:00
P0nk
fc0075831a Finalize monster card data
Exported the result of running the old queries from HeidiSQL and copy-pasted the INSERT.
2025-07-01 12:14:10 +02:00
P0nk
4f0182621a Add monster card data changeset (not complete) 2025-07-01 12:10:55 +02:00
P0nk
9e4ea4a474 Add maker reagent data changeset 2025-07-01 12:05:59 +02:00
P0nk
8ca2720ec1 Add maker reward data changeset 2025-07-01 12:03:47 +02:00
P0nk
c7137954fe Add maker recipe data changeset 2025-07-01 12:00:14 +02:00
P0nk
b410832a81 Add maker create data changeset 2025-07-01 11:55:16 +02:00
P0nk
da17490dbc Add shop data changesets 2025-07-01 09:06:42 +02:00
P0nk
371ed4efff Move duey to its own changeset 2025-07-01 08:25:30 +02:00
P0nk
e51dd82bdb Rename changesets to singular form 2025-07-01 08:15:37 +02:00
P0nk
66567fa595 Add bosslog changeset 2025-07-01 08:13:42 +02:00
P0nk
92db70159f Add ban changeset 2025-07-01 08:11:16 +02:00
P0nk
11cbf2a475 Add field objects changeset 2025-07-01 08:07:08 +02:00
P0nk
3367b58e39 Add maker changeset 2025-07-01 08:02:26 +02:00
P0nk
8f7068c55b Add mts changeset 2025-07-01 07:58:09 +02:00
P0nk
c28182c5a2 Add transfer changeset 2025-07-01 07:26:45 +02:00