EQEmulator Forums - lootdrop_entries => Disabled Chance? & zone => Type?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - lootdrop_entries => Disabled Chance? & zone => Type? (https://www.eqemulator.org/forums/showthread.php?t=36511)

lootdrop_entries => Disabled Chance? & zone => Type?

I just did a refresh to the DB and code and noticed that there was no .sql in the code nor DB sql folders that specified this change.

If you don't do a drop/define here is the fix:

Code:

ALTER TABLE `lootdrop_entries` ADD `disabled_chance` FLOAT UNSIGNED NOT NULL DEFAULT '0';

fix to zone table:

Code:

ALTER TABLE `zone` ADD COLUMN `type` tinyint(3) NOT NULL DEFAULT 0 AFTER `suspendbuffs`;

I know there is quite a few moves to tools going on, but these two seemed to either missed or changed where they report the required DB updates (either in code /utils/sql or db /updates)

Was this an oops or should I start looking at other folders?

FIX FIX! Couldn't edit message above, do not use it!

Use below:

Code:

ALTER TABLE `lootdrop_entries` ADD `disabled_chance` FLOAT UNSIGNED NOT NULL DEFAULT '0' after `chance`;