delete from player_levelstats where race=3 and class=7;

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 1, 24, 17, 23, 18, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 2, 25, 17, 24, 19, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 3, 26, 18, 25, 20, 27);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 5, 27, 19, 27, 22, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 6, 28, 19, 28, 23, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 7, 29, 20, 29, 24, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 8, 30, 20, 30, 25, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 9, 31, 21, 31, 26, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 10, 32, 21, 32, 27, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 11, 33, 22, 33, 28, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 12, 34, 22, 34, 29, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 13, 34, 23, 35, 30, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 14, 35, 23, 36, 31, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 15, 36, 24, 37, 32, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 16, 37, 24, 39, 33, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 17, 38, 25, 40, 34, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 18, 39, 25, 41, 35, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 19, 40, 26, 42, 36, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 20, 41, 26, 43, 37, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 21, 42, 27, 44, 38, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 22, 43, 27, 45, 39, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 23, 44, 28, 47, 40, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 24, 45, 28, 48, 41, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 25, 47, 29, 49, 43, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 26, 48, 30, 50, 44, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 27, 49, 30, 52, 45, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 28, 50, 31, 53, 46, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 29, 51, 31, 54, 47, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 30, 52, 32, 55, 48, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 31, 53, 33, 57, 50, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 32, 54, 33, 58, 51, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 33, 55, 34, 59, 52, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 34, 57, 34, 61, 53, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 35, 58, 35, 62, 55, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 36, 59, 36, 63, 56, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 37, 60, 36, 65, 57, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 38, 61, 37, 66, 58, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 39, 62, 38, 67, 60, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 40, 64, 38, 69, 61, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 41, 65, 39, 70, 62, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 42, 66, 40, 72, 64, 76);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 43, 67, 40, 73, 65, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 44, 69, 41, 74, 66, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 45, 70, 42, 76, 68, 81);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 46, 71, 42, 77, 69, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 47, 72, 43, 79, 70, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 48, 74, 44, 80, 72, 85);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 49, 75, 45, 82, 73, 87);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 50, 76, 45, 83, 75, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 51, 78, 46, 85, 76, 90);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 52, 79, 47, 86, 77, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 53, 80, 47, 88, 79, 93);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 54, 82, 48, 90, 80, 95);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 55, 83, 49, 91, 82, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 56, 85, 50, 93, 83, 98);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 57, 86, 50, 94, 85, 100);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 58, 87, 51, 96, 86, 102);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 59, 89, 52, 97, 88, 103);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 60, 90, 53, 99, 89, 105);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 61, 92, 54, 101, 91, 107);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 62, 93, 54, 102, 92, 109);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 63, 95, 55, 104, 94, 110);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 64, 96, 56, 106, 95, 112);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 65, 97, 57, 107, 97, 114);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 66, 99, 58, 109, 99, 116);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 67, 100, 58, 111, 100, 118);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 68, 102, 59, 113, 102, 119);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 69, 103, 60, 114, 103, 121);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 70, 105, 61, 116, 105, 123);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 71, 106, 62, 118, 117, 125);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 72, 108, 63, 120, 119, 128);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 73, 110, 64, 122, 122, 130);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 74, 112, 65, 125, 124, 132);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 75, 114, 66, 127, 126, 134);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 76, 116, 67, 129, 128, 137);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 77, 117, 68, 131, 128, 139);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 78, 119, 69, 133, 133, 141);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 79, 121, 70, 136, 135, 144);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (3, 7, 80, 123, 71, 138, 137, 146);

delete from playercreateinfo_spell where race=3 and class=7;

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 81, 'Dodge');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 107, 'Block');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 198, 'One-Handed Maces');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 203, 'Unarmed');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 204, 'Defense');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 227, 'Staves');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 331, 'Healing Wave');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 403, 'Lightning Bolt');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 2382, 'Generic');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 3050, 'Detect');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 3365, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 6233, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 6246, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 6247, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 6477, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 6478, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 6603, 'Attack');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 7266, 'Duel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 7267, 'Grovel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 7355, 'Stuck');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 8386, 'Attacking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 9077, 'Leather');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 9078, 'Cloth');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 9116, 'Shield');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 9125, 'Generic');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 20573, 'Hardiness');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 20574, 'Axe Specialization');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 21563, 'Command');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 21651, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 21652, 'Closing');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 27763, 'Totem');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 33697, 'Blood Fury');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 61437, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 65222, 'Command');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 68398, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (3, 7, 75461, 'Flame Shock Passive');

delete from playercreateinfo_action where race=3 and class=7;

insert into playercreateinfo_action (race, class, button, action, type) values (3, 7, 0, 6603, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (3, 7, 1, 403, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (3, 7, 2, 331, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (3, 7, 3, 33697, 0);