SQL Statements for DB Fixes

[Monrezz]

Just updated the damage fixes - it now uses values calculated by the formula hardcoded. See attack.cpp for the formulas. Here's the SQL to source:

UPDATE npc_types SET maxdmg=2, mindmg=1 WHERE level=1 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=4, mindmg=1 WHERE level=2 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=6, mindmg=1 WHERE level=3 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=8, mindmg=1 WHERE level=4 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=10, mindmg=1 WHERE level=5 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=12, mindmg=1 WHERE level=6 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=14, mindmg=1 WHERE level=7 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=16, mindmg=1 WHERE level=8 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=18, mindmg=1 WHERE level=9 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=20, mindmg=1 WHERE level=10 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=22, mindmg=1 WHERE level=11 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=24, mindmg=1 WHERE level=12 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=26, mindmg=1 WHERE level=13 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=28, mindmg=1 WHERE level=14 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=30, mindmg=1 WHERE level=15 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=32, mindmg=1 WHERE level=16 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=34, mindmg=1 WHERE level=17 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=36, mindmg=1 WHERE level=18 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=38, mindmg=1 WHERE level=19 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=40, mindmg=1 WHERE level=20 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=42, mindmg=1 WHERE level=21 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=44, mindmg=1 WHERE level=22 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=46, mindmg=1 WHERE level=23 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=48, mindmg=1 WHERE level=24 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=50, mindmg=1 WHERE level=25 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=52, mindmg=1 WHERE level=26 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=54, mindmg=1 WHERE level=27 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=58, mindmg=14 WHERE level=28 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=60, mindmg=15 WHERE level=29 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=62, mindmg=15 WHERE level=30 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=64, mindmg=16 WHERE level=31 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=66, mindmg=16 WHERE level=32 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=68, mindmg=17 WHERE level=33 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=70, mindmg=17 WHERE level=34 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=72, mindmg=18 WHERE level=35 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=74, mindmg=18 WHERE level=36 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=76, mindmg=19 WHERE level=37 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=78, mindmg=19 WHERE level=38 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=80, mindmg=20 WHERE level=39 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=120, mindmg=40 WHERE level=40 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=123, mindmg=41 WHERE level=41 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=126, mindmg=42 WHERE level=42 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=129, mindmg=43 WHERE level=43 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=132, mindmg=44 WHERE level=44 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=135, mindmg=45 WHERE level=45 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=138, mindmg=46 WHERE level=46 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=141, mindmg=47 WHERE level=47 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=144, mindmg=48 WHERE level=48 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=147, mindmg=49 WHERE level=49 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=150, mindmg=50 WHERE level=50 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=153, mindmg=68 WHERE level=51 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=156, mindmg=69 WHERE level=52 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=159, mindmg=71 WHERE level=53 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=162, mindmg=72 WHERE level=54 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=165, mindmg=73 WHERE level=55 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=168, mindmg=75 WHERE level=56 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=171, mindmg=76 WHERE level=57 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=174, mindmg=77 WHERE level=58 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=177, mindmg=78 WHERE level=59 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=180, mindmg=80 WHERE level=60 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=183, mindmg=81 WHERE level=61 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=186, mindmg=82 WHERE level=62 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=189, mindmg=83 WHERE level=63 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=192, mindmg=85 WHERE level=64 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=195, mindmg=86 WHERE level=65 AND ((name like 'a_%') OR (name like 'an_%'));
UPDATE npc_types SET maxdmg=495, mindmg=220 WHERE level=66;
UPDATE npc_types SET maxdmg=742, mindmg=220 WHERE level=67;
UPDATE npc_types SET maxdmg=990, mindmg=220 WHERE level=68;
UPDATE npc_types SET maxdmg=1237, mindmg=220 WHERE level=69;
UPDATE npc_types SET maxdmg=1485, mindmg=220 WHERE level=70;

Note: I set the damage for ALL mobs level 66-70, as almost all these are boss mobs and would therefore be hitting for about the damage supplied. I calculated each value for maxdmg/mindmg for each level using the hard-coded value that is set for any mob without a max/min damage in the database.

Hope this helps some people - certainly saves a lot of time!

Monrezz