All pastes #974002 Raw Edit

Unbenannt

public text v1 · immutable
·published 2008-04-06 14:07 UTC
rendered paste body
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4614.253906 , position_y=-2096.881592 , position_z=1236.974243 WHERE race=1;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4614.253906 , position_y=-2096.881592 , position_z=1236.974243 WHERE race=3;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4614.253906 , position_y=-2096.881592 , position_z=1236.974243 WHERE race=7;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4614.253906 , position_y=-2096.881592 , position_z=1236.974243 WHERE race=11;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4614.253906 , position_y=-2096.881592 , position_z=1236.974243 WHERE race=4;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4582.174805 , position_y=-3195.660400 , position_z=1034.425537 WHERE race=10;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4582.174805 , position_y=-3195.660400 , position_z=1034.425537 WHERE race=2;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4582.174805 , position_y=-3195.660400 , position_z=1034.425537 WHERE race=8;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4582.174805 , position_y=-3195.660400 , position_z=1034.425537 WHERE race=5;
UPDATE playercreateinfo SET zone=616 , map=1 , position_x=4582.174805 , position_y=-3195.660400 , position_z=1034.425537 WHERE race=6;

# PALADIN

INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (1, 2, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (3, 2, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (10, 2, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (11, 2, 750, 0);

# WARRIOR

INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (1, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (2, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (3, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (4, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (5, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (6, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (7, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (8, 1, 750, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (11, 1, 750, 0);

# HUNTER

INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (2, 3, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (3, 3, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (4, 3, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (6, 3, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (8, 3, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (10, 3, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (11, 3, 8737, 0);

# SHAMAN 

INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (2, 7, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (6, 7, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (8, 7, 8737, 0);
INSERT INTO playercreateinfo_spell (race, class, spell, active) VALUES (11, 7, 8737, 0);

# WARRIOR

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 1, 21995, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 21999, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 22001, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 21997, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 21996, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 21998, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 21994, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 22000, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 1, 21995, 1);

# PALADIN

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22091, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22093, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22089, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22088, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22090, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22086, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22092, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 2, 22087, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22091, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22093, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22089, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22088, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22090, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22086, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22092, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 2, 22087, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22091, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22093, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22089, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22088, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22090, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22086, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22092, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 2, 22087, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22091, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22093, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22089, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22088, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22090, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22086, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22092, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 2, 22087, 1);

# HUNTER

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22013, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22016, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22060, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22011, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22015, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22010, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22017, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 3, 22061, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22013, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22016, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22060, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22011, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22015, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22010, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22017, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 3, 22061, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22013, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22016, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22060, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22011, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22015, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22010, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22017, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 3, 22061, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22013, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22016, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22060, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22011, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22015, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22010, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22017, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 3, 22061, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22013, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22016, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22060, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22011, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22015, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22010, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22017, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 3, 22061, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22013, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22016, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22060, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22011, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22015, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22010, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22017, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 3, 22061, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22013, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22016, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22060, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22011, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22015, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22010, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22017, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 3, 22061, 1);

# ROGUE

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 4, 22003, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 4, 22003, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 4, 22003, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 4, 22003, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 4, 22003, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 4, 22003, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 4, 22003, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22005, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22008, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22009, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22004, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22006, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22002, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22007, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 4, 22003, 1);

# PRIEST

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22080, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22082, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22083, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22079, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22081, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22078, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22085, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 5, 22084, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22080, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22082, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22083, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22079, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22081, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22078, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22085, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (3, 5, 22084, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22080, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22082, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22083, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22079, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22081, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22078, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22085, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 5, 22084, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22080, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22082, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22083, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22079, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22081, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22078, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22085, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 5, 22084, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22080, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22082, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22083, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22079, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22081, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22078, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22085, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 5, 22084, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22080, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22082, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22083, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22079, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22081, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22078, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22085, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 5, 22084, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22080, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22082, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22083, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22079, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22081, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22078, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22085, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 5, 22084, 1);

# SHAMAN

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22097, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22101, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22102, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22095, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22099, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22098, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22100, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 7, 22096, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22097, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22101, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22102, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22095, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22099, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22098, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22100, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 7, 22096, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22097, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22101, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22102, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22095, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22099, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22098, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22100, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 7, 22096, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22097, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22101, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22102, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22095, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22099, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22098, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22100, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 7, 22096, 1);

# MAGE

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22065, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22068, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22069, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22063, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22066, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22062, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22067, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 8, 22064, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22065, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22068, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22069, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22063, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22066, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22062, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22067, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 8, 22064, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22065, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22068, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22069, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22063, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22066, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22062, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22067, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 8, 22064, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22065, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22068, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22069, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22063, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22066, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22062, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22067, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (8, 8, 22064, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22065, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22068, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22069, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22063, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22066, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22062, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22067, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 8, 22064, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22065, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22068, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22069, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22063, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22066, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22062, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22067, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (11, 8, 22064, 1);

# WARLOCK

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22074, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22073, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22075, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22071, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22077, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22070, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22072, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (1, 9, 22076, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22074, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22073, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22075, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22071, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22077, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22070, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22072, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (2, 9, 22076, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22074, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22073, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22075, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22071, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22077, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22070, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22072, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (5, 9, 22076, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22074, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22073, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22075, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22071, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22077, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22070, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22072, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (7, 9, 22076, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22074, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22073, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22075, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22071, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22077, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22070, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22072, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (10, 9, 22076, 1);

# DRUID

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22109, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22112, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22113, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22108, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22110, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22106, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22111, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (4, 11, 22107, 1);

INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22109, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22112, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22113, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22108, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22110, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22106, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22111, 1);
INSERT INTO playercreateinfo_item (race, class, itemid, amount) VALUES (6, 11, 22107, 1);

UPDATE creature_template SET minlevel=250 , maxlevel=255 WHERE maxlevel=73;
UPDATE creature_template SET minlevel=240 , maxlevel=255 WHERE maxlevel=72;
UPDATE creature_template SET minlevel=230 , maxlevel=255 WHERE maxlevel=71;
UPDATE creature_template SET minlevel=225 , maxlevel=255 WHERE maxlevel=70;
UPDATE creature_template SET minlevel=220 , maxlevel=250 WHERE maxlevel=69;
UPDATE creature_template SET minlevel=215 , maxlevel=245 WHERE maxlevel=68;
UPDATE creature_template SET minlevel=210 , maxlevel=245 WHERE maxlevel=67;
UPDATE creature_template SET minlevel=210 , maxlevel=240 WHERE maxlevel=66;
UPDATE creature_template SET minlevel=205 , maxlevel=235 WHERE maxlevel=65;
UPDATE creature_template SET minlevel=200 , maxlevel=230 WHERE maxlevel=64;
UPDATE creature_template SET minlevel=195 , maxlevel=225 WHERE maxlevel=63;
UPDATE creature_template SET minlevel=190 , maxlevel=220 WHERE maxlevel=62;
UPDATE creature_template SET minlevel=185 , maxlevel=215 WHERE maxlevel=61;
UPDATE creature_template SET minlevel=185 , maxlevel=210 WHERE maxlevel=60;
UPDATE creature_template SET minlevel=180 , maxlevel=210 WHERE maxlevel=59;
UPDATE creature_template SET minlevel=175 , maxlevel=205 WHERE maxlevel=58;
UPDATE creature_template SET minlevel=170 , maxlevel=200 WHERE maxlevel=57;
UPDATE creature_template SET minlevel=165 , maxlevel=195 WHERE maxlevel=56;
UPDATE creature_template SET minlevel=160 , maxlevel=195 WHERE maxlevel=55;
UPDATE creature_template SET minlevel=160 , maxlevel=190 WHERE maxlevel=54;
UPDATE creature_template SET minlevel=155 , maxlevel=185 WHERE maxlevel=53;
UPDATE creature_template SET minlevel=150 , maxlevel=180 WHERE maxlevel=52;
UPDATE creature_template SET minlevel=145 , maxlevel=180 WHERE maxlevel=51;
UPDATE creature_template SET minlevel=145 , maxlevel=175 WHERE maxlevel=50;
UPDATE creature_template SET minlevel=140 , maxlevel=170 WHERE maxlevel=49;
UPDATE creature_template SET minlevel=135 , maxlevel=165 WHERE maxlevel=48;
UPDATE creature_template SET minlevel=130 , maxlevel=160 WHERE maxlevel=47;
UPDATE creature_template SET minlevel=120 , maxlevel=150 WHERE maxlevel=46;
UPDATE creature_template SET minlevel=115 , maxlevel=145 WHERE maxlevel=45;
UPDATE creature_template SET minlevel=105 , maxlevel=135 WHERE maxlevel=44;
UPDATE creature_template SET minlevel=100 , maxlevel=130 WHERE maxlevel=43;
UPDATE creature_template SET minlevel=100 , maxlevel=130 WHERE maxlevel=42;
UPDATE creature_template SET minlevel=100 , maxlevel=130 WHERE maxlevel=41;
UPDATE creature_template SET minlevel=95 , maxlevel=125 WHERE maxlevel=40;
UPDATE creature_template SET minlevel=92 , maxlevel=122 WHERE maxlevel=39;
UPDATE creature_template SET minlevel=89 , maxlevel=119 WHERE maxlevel=38;
UPDATE creature_template SET minlevel=84 , maxlevel=115 WHERE maxlevel=37;
UPDATE creature_template SET minlevel=81 , maxlevel=112 WHERE maxlevel=36;
UPDATE creature_template SET minlevel=78 , maxlevel=109 WHERE maxlevel=35;
UPDATE creature_template SET minlevel=75 , maxlevel=106 WHERE maxlevel=34;
UPDATE creature_template SET minlevel=72 , maxlevel=103 WHERE maxlevel=33;
UPDATE creature_template SET minlevel=69 , maxlevel=100 WHERE maxlevel=32;
UPDATE creature_template SET minlevel=66 , maxlevel=97 WHERE maxlevel=31;
UPDATE creature_template SET minlevel=63 , maxlevel=94 WHERE maxlevel=30;
UPDATE creature_template SET minlevel=60 , maxlevel=91 WHERE maxlevel=29;
UPDATE creature_template SET minlevel=57 , maxlevel=88 WHERE maxlevel=28;
UPDATE creature_template SET minlevel=54 , maxlevel=85 WHERE maxlevel=27;
UPDATE creature_template SET minlevel=51 , maxlevel=82 WHERE maxlevel=26;
UPDATE creature_template SET minlevel=48 , maxlevel=79 WHERE maxlevel=25;
UPDATE creature_template SET minlevel=43 , maxlevel=74 WHERE maxlevel=24;
UPDATE creature_template SET minlevel=36 , maxlevel=68 WHERE maxlevel=23;
UPDATE creature_template SET minlevel=31 , maxlevel=63 WHERE maxlevel=22;
UPDATE creature_template SET minlevel=26 , maxlevel=58 WHERE maxlevel=21;
UPDATE creature_template SET minlevel=23 , maxlevel=53 WHERE maxlevel=20;
UPDATE creature_template SET minlevel=23 , maxlevel=48 WHERE maxlevel=19;
UPDATE creature_template SET minlevel=23 , maxlevel=43 WHERE maxlevel=18;
UPDATE creature_template SET minlevel=23 , maxlevel=40 WHERE maxlevel=17;
UPDATE creature_template SET minlevel=21 , maxlevel=35 WHERE maxlevel=16;
UPDATE creature_template SET minlevel=19 , maxlevel=31 WHERE maxlevel=15;
UPDATE creature_template SET minlevel=17 , maxlevel=27 WHERE maxlevel=14;
UPDATE creature_template SET minlevel=15 , maxlevel=23 WHERE maxlevel=13;
UPDATE creature_template SET minlevel=14 , maxlevel=23 WHERE maxlevel=12;
UPDATE creature_template SET minlevel=14 , maxlevel=23 WHERE maxlevel=11;
UPDATE creature_template SET minlevel=13 , maxlevel=20 WHERE maxlevel=10;
UPDATE creature_template SET minlevel=10 , maxlevel=20 WHERE maxlevel=9;
UPDATE creature_template SET minlevel=10 , maxlevel=20 WHERE maxlevel=8;
UPDATE creature_template SET minlevel=10 , maxlevel=20 WHERE maxlevel=7;
UPDATE creature_template SET minlevel=10 , maxlevel=20 WHERE maxlevel=6;
UPDATE creature_template SET minlevel=3 , maxlevel=9 WHERE maxlevel=5;
UPDATE creature_template SET minlevel=3 , maxlevel=9 WHERE maxlevel=4;
UPDATE creature_template SET minlevel=3 , maxlevel=9 WHERE maxlevel=3;
UPDATE creature_template SET minlevel=2 , maxlevel=7 WHERE maxlevel=2;
UPDATE creature_template SET minlevel=2 , maxlevel=7 WHERE maxlevel=1;
UPDATE creature_template SET minlevel=200 , maxlevel=255 WHERE rank=3;