...I was thinking more along these lines:
update npc_types set maxdmg=3 where level=1;
update npc_types set maxdmg=6 where level=2;
update npc_types set maxdmg=9 where level=3;
update npc_types set maxdmg=12 where level=4;
update npc_types set maxdmg=13 where level=5;
update npc_types set maxdmg=13 where level=6;
update npc_types set maxdmg=14 where level=7;
update npc_types set maxdmg=14 where level=8;
update npc_types set maxdmg=14 where level=9;
update npc_types set maxdmg=25 where level=10;
update npc_types set maxdmg=25 where level=11;
update npc_types set maxdmg=26 where level=12;
update npc_types set maxdmg=26 where level=13;
update npc_types set maxdmg=27 where level=14;
update npc_types set maxdmg=37 where level=15;
update npc_types set maxdmg=38 where level=16;
update npc_types set maxdmg=38 where level=17;
update npc_types set maxdmg=38 where level=18;
update npc_types set maxdmg=39 where level=19;
update npc_types set maxdmg=49 where level=20;
update npc_types set maxdmg=50 where level=21;
update npc_types set maxdmg=50 where level=22;
update npc_types set maxdmg=51 where level=23;
update npc_types set maxdmg=51 where level=24;
update npc_types set maxdmg=62 where level=25;
update npc_types set maxdmg=62 where level=26;
update npc_types set maxdmg=62 where level=27;
update npc_types set maxdmg=63 where level=28;
update npc_types set maxdmg=63 where level=29;
update npc_types set maxdmg=74 where level=30;
update npc_types set maxdmg=74 where level=31;
update npc_types set maxdmg=75 where level=32;
update npc_types set maxdmg=75 where level=33;
update npc_types set maxdmg=76 where level=34;
update npc_types set maxdmg=86 where level=35;
update npc_types set maxdmg=86 where level=36;
update npc_types set maxdmg=87 where level=37;
update npc_types set maxdmg=87 where level=38;
update npc_types set maxdmg=88 where level=39;
update npc_types set maxdmg=98 where level=40;
update npc_types set maxdmg=99 where level=41;
update npc_types set maxdmg=99 where level=42;
update npc_types set maxdmg=100 where level=43;
update npc_types set maxdmg=100 where level=44;
update npc_types set maxdmg=110 where level=45;
update npc_types set maxdmg=111 where level=46;
update npc_types set maxdmg=111 where level=47;
update npc_types set maxdmg=112 where level=48;
update npc_types set maxdmg=112 where level=49;
update npc_types set maxdmg=123 where level=50;
update npc_types set maxdmg=123 where level=51;
update npc_types set maxdmg=124 where level=52;
update npc_types set maxdmg=124 where level=53;
update npc_types set maxdmg=124 where level=54;
update npc_types set maxdmg=135 where level=55;
|