delete from player_levelstats where race=4 and class=8;

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 1, 21, 22, 21, 19, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 2, 21, 22, 21, 20, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 3, 21, 22, 22, 22, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 4, 21, 22, 22, 23, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 5, 21, 23, 22, 25, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 6, 21, 23, 22, 26, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 7, 21, 23, 23, 27, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 8, 22, 23, 23, 29, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 9, 22, 23, 23, 30, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 10, 22, 23, 24, 32, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 11, 22, 24, 24, 33, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 12, 22, 24, 24, 35, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 13, 22, 24, 25, 36, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 14, 22, 24, 25, 38, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 15, 22, 24, 25, 39, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 16, 22, 24, 26, 41, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 17, 23, 25, 26, 42, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 18, 23, 25, 26, 44, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 19, 23, 25, 27, 46, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 20, 23, 25, 27, 47, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 21, 23, 25, 27, 49, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 22, 23, 26, 28, 51, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 23, 23, 26, 28, 52, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 24, 24, 26, 29, 54, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 25, 24, 26, 29, 56, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 26, 24, 27, 29, 57, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 27, 24, 27, 30, 59, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 28, 24, 27, 30, 61, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 29, 24, 27, 31, 63, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 30, 24, 28, 31, 64, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 31, 25, 28, 31, 66, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 32, 25, 28, 32, 68, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 33, 25, 28, 32, 70, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 34, 25, 29, 33, 71, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 35, 25, 29, 33, 73, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 36, 26, 29, 34, 75, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 37, 26, 29, 34, 77, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 38, 26, 30, 35, 79, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 39, 26, 30, 35, 81, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 40, 26, 30, 35, 83, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 41, 27, 31, 36, 85, 86);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 42, 27, 31, 36, 87, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 43, 27, 31, 37, 89, 90);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 44, 27, 32, 37, 91, 91);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 45, 27, 32, 38, 93, 93);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 46, 28, 32, 38, 95, 95);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 47, 28, 32, 39, 97, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 48, 28, 33, 39, 99, 99);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 49, 28, 33, 40, 101, 101);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 50, 29, 33, 40, 103, 103);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 51, 29, 34, 41, 105, 105);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 52, 29, 34, 42, 107, 107);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 53, 29, 35, 42, 109, 109);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 54, 30, 35, 43, 111, 111);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 55, 30, 35, 43, 113, 113);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 56, 30, 36, 44, 115, 115);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 57, 30, 36, 44, 118, 118);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 58, 31, 36, 45, 120, 120);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 59, 31, 37, 45, 122, 122);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 60, 31, 37, 46, 124, 124);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 61, 31, 37, 47, 126, 126);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 62, 32, 38, 47, 129, 128);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 63, 32, 38, 48, 131, 130);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 64, 32, 39, 48, 133, 133);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 65, 33, 39, 49, 135, 135);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 66, 33, 39, 50, 138, 137);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 67, 33, 40, 50, 140, 139);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 68, 33, 40, 51, 142, 141);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 69, 34, 41, 51, 145, 144);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 70, 34, 41, 52, 147, 146);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 71, 34, 41, 53, 150, 149);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 72, 34, 42, 54, 153, 152);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 73, 34, 42, 55, 156, 155);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 74, 35, 43, 55, 159, 157);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 75, 35, 43, 56, 162, 160);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 76, 35, 43, 57, 168, 163);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 77, 36, 44, 58, 168, 166);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 78, 36, 44, 58, 171, 169);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 79, 36, 45, 59, 177, 172);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 8, 80, 37, 45, 60, 177, 175);

delete from playercreateinfo_spell where race=4 and class=8;

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 81, 'Dodge');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 133, 'Fireball');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 168, 'Frost Armor');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 203, 'Unarmed');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 204, 'Defense');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 227, 'Staves');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 522, 'SPELLDEFENSE (DND)');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 2382, 'Generic');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 2479, 'Honorless Target');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 3050, 'Detect');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 3365, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 5009, 'Wands');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 5019, 'Shoot');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 6233, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 6246, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 6247, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 6477, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 6478, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 6603, 'Attack');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 7266, 'Duel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 7267, 'Grovel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 7341, 'Language Troll');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 7355, 'Stuck');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 8386, 'Attacking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 9078, 'Cloth');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 9125, 'Generic');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 20555, 'Regeneration');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 20557, 'Beast Slaying');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 20558, 'Throwing Specialization');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 21651, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 21652, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 22027, 'Remove Insignia');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 22810, 'Opening - No Text');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 26290, 'Bow Specialization');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 26297, 'Berserking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 45927, 'Summon Friend');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 58943, 'Da Voodoo Shuffle');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 61437, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 68398, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 8, 71761, 'Deep Freeze Immunity State');

delete from playercreateinfo_action where race=4 and class=8;

insert into playercreateinfo_action (race, class, button, action, type) values (4, 8, 0, 133, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (4, 8, 1, 168, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (4, 8, 2, 26297, 0);