Item-Character inventory editor error

[Lillu]

Georges, with one of the recent SQL updates, the character inventory editor won't work anymore. It gives the following error when I try to open a bag from inventory or bank.
http://www.thehiddenforest.org/images/error.png
(The itemID in the gif name varies when trying to open different bags)

If I create the missing gif file, the tool will work, but that's obviously not the solution here.

If I click an item, I get a "type mismatch" error.

This was the SQL update resulting in the error:
INSERT INTO commands VALUES ('mysql', 250, 'Mysql CLI, see \'help\' for options.');

UPDATE `items` SET `stackable`='1' WHERE `id`='40902';
UPDATE `items` SET `stackable`='1' WHERE `id`='40903';

CREATE TABLE `char_create_combinations` (
`allocation_id` INT(10) UNSIGNED NOT NULL,
`race` INT(10) UNSIGNED NOT NULL,
`class` INT(10) UNSIGNED NOT NULL,
`deity` INT(10) UNSIGNED NOT NULL,
`start_zone` INT(10) UNSIGNED NOT NULL,
`expansions_req` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`race`, `class`, `deity`, `start_zone`)
);

INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '201', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '204', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '207', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '206', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '211', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '396', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '212', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '1', '208', '58', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '396', '58', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '201', '58', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '207', '58', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '206', '58', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '212', '58', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '211', '58', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '208', '58', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '204', '58', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '396', '58', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '1', '211', '58', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '2', '201', '48', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '2', '207', '48', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '2', '208', '48', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '2', '212', '48', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '2', '206', '48', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '2', '204', '48', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '2', '201', '48', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '2', '206', '48', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '2', '207', '48', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '2', '204', '48', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '2', '212', '48', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '2', '208', '48', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '3', '204', '54', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '3', '207', '54', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '3', '208', '54', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '3', '212', '54', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '3', '207', '54', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '3', '212', '54', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '3', '208', '54', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '3', '204', '54', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '4', '207', '55', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '4', '215', '55', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '4', '207', '55', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '4', '215', '55', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '5', '201', '57', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '5', '206', '57', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '5', '201', '57', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '5', '206', '57', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '6', '207', '49', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '6', '215', '49', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '6', '207', '49', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '6', '215', '49', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '7', '210', '52', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '7', '396', '52', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '7', '396', '52', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '7', '210', '52', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '202', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '207', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '209', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '211', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '213', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '215', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '396', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '216', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '214', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '212', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '210', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '208', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '204', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '8', '205', '47', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '396', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '205', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '204', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '207', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '212', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '209', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '210', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '213', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '202', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '211', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '216', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '215', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '214', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '208', '47', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '396', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '209', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '213', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '211', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '216', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '215', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '214', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '202', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '210', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '8', '205', '47', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '9', '201', '56', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '9', '206', '56', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '9', '207', '56', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '9', '212', '56', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '9', '396', '56', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '9', '205', '56', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '9', '204', '56', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '396', '56', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '212', '56', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '204', '56', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '207', '56', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '201', '56', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '206', '56', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '205', '56', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '396', '56', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '9', '205', '56', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '11', '201', '53', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '11', '206', '53', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '11', '201', '53', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '11', '206', '53', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '201', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '204', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '207', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '206', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '208', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '213', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '396', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '12', '212', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '396', '51', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '213', '51', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '206', '51', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '207', '51', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '204', '51', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '212', '51', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '208', '51', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '201', '51', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '396', '51', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '12', '213', '51', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '13', '201', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '13', '207', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '13', '208', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '13', '212', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '13', '396', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '13', '206', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '13', '204', '51', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '396', '51', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '212', '51', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '208', '51', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '201', '51', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '206', '51', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '207', '51', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '204', '51', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '13', '396', '51', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '14', '201', '50', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '14', '206', '50', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '14', '208', '50', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '14', '212', '50', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '14', '396', '50', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '14', '207', '50', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '1', '14', '204', '50', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '396', '50', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '208', '50', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '212', '50', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '204', '50', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '201', '50', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '206', '50', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '207', '50', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '1', '14', '396', '50', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '2', '1', '211', '4', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '2', '1', '214', '4', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '2', '1', '396', '4', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '2', '1', '396', '4', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '2', '1', '214', '4', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '2', '1', '211', '4', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '2', '9', '205', '2', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '2', '9', '396', '2', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '2', '9', '214', '2', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '2', '9', '396', '2', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '2', '9', '205', '2', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '2', '9', '214', '2', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '2', '10', '214', '3', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '2', '10', '214', '3', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '2', '15', '208', '0', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '2', '15', '214', '0', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '2', '15', '208', '0', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '2', '15', '214', '0', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '2', '16', '211', '1', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '2', '16', '396', '1', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '2', '16', '214', '1', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '2', '16', '396', '1', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '2', '16', '211', '1', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '2', '16', '214', '1', '29');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '2', '203', '17', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '2', '210', '17', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '2', '209', '17', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '2', '203', '17', '75');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '2', '210', '17', '24');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '2', '209', '17', '24');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '3', '209', '21', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '3', '210', '21', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '3', '209', '21', '24');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '3', '210', '21', '24');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '5', '203', '22', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '5', '203', '22', '75');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '11', '203', '20', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '11', '203', '20', '75');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '12', '209', '19', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '12', '213', '19', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '12', '396', '19', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '12', '210', '19', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '12', '396', '19', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '12', '209', '19', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '12', '213', '19', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '12', '210', '19', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '13', '209', '19', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '13', '210', '19', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '13', '396', '19', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '13', '396', '19', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '13', '209', '19', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '13', '210', '19', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '14', '209', '18', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '14', '210', '18', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '3', '14', '396', '18', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '14', '396', '18', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '14', '210', '18', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '3', '14', '209', '18', '23');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '1', '207', '85', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '1', '211', '85', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '1', '215', '85', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '1', '396', '85', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '1', '396', '85', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '1', '207', '85', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '1', '211', '85', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '1', '215', '85', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '4', '215', '83', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '4', '215', '83', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '6', '215', '82', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '6', '215', '82', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '202', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '209', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '396', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '216', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '215', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '214', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '213', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '212', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '211', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '210', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '208', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '204', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '207', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '8', '205', '81', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '396', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '205', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '207', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '208', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '211', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '216', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '215', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '214', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '202', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '213', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '210', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '209', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '212', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '8', '204', '81', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '9', '205', '84', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '9', '215', '84', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '9', '207', '84', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '4', '9', '396', '84', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '9', '396', '84', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '9', '215', '84', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '9', '207', '84', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '4', '9', '205', '84', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '2', '215', '43', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '2', '215', '43', '61');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '3', '215', '46', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '3', '215', '46', '61');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '12', '204', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '12', '208', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '12', '215', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '12', '396', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '12', '213', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '12', '207', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '12', '396', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '12', '207', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '12', '204', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '12', '213', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '12', '215', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '12', '208', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '13', '204', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '13', '207', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '13', '208', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '13', '396', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '13', '215', '45', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '13', '396', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '13', '207', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '13', '208', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '13', '215', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '13', '204', '45', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '14', '204', '44', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '14', '215', '44', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '14', '396', '44', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '14', '208', '44', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '5', '14', '207', '44', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '14', '396', '44', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '14', '207', '44', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '14', '204', '44', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '14', '215', '44', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '5', '14', '208', '44', '62');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '1', '206', '11', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '1', '211', '11', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '1', '396', '11', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '1', '396', '11', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '1', '211', '11', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '1', '206', '11', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '2', '206', '5', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '2', '206', '5', '42');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '5', '206', '10', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '5', '206', '10', '42');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '9', '205', '9', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '9', '206', '9', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '9', '396', '9', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '9', '396', '9', '42');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '9', '205', '9', '42');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '9', '206', '9', '42');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '11', '206', '8', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '11', '206', '8', '42');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '12', '206', '7', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '12', '213', '7', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '12', '396', '7', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '12', '396', '7', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '12', '206', '7', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '12', '213', '7', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '13', '206', '7', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '13', '396', '7', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '13', '396', '7', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '13', '206', '7', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '14', '206', '6', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '6', '14', '396', '6', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '14', '396', '6', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '6', '14', '206', '6', '41');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '201', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '212', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '396', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '215', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '214', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '211', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '204', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '207', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '208', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '209', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '1', '206', '36', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '396', '36', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '208', '36', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '211', '36', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '215', '36', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '214', '36', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '209', '36', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '212', '36', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '204', '36', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '201', '36', '45');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '207', '36', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '206', '36', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '396', '36', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '209', '36', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '211', '36', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '214', '36', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '396', '36', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '211', '36', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '214', '36', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '1', '209', '36', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '3', '204', '33', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '3', '208', '33', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '3', '212', '33', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '3', '215', '33', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '3', '207', '33', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '3', '207', '33', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '3', '215', '33', '61');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '3', '212', '33', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '3', '204', '33', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '3', '208', '33', '9');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '4', '207', '34', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '4', '215', '34', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '4', '207', '34', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '4', '215', '34', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '4', '215', '34', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '6', '207', '32', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '6', '215', '32', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '6', '207', '32', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '6', '215', '32', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '6', '215', '32', '3');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '202', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '210', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '212', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '396', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '216', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '215', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '214', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '213', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '211', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '209', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '204', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '205', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '208', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '8', '207', '31', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '396', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '212', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '214', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '202', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '213', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '210', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '209', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '205', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '207', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '204', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '208', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '211', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '216', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '215', '31', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '396', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '209', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '213', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '214', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '211', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '216', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '215', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '202', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '210', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '205', '31', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '396', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '211', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '216', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '215', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '214', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '202', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '213', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '210', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '209', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '8', '205', '31', '1');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '9', '201', '35', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '9', '205', '35', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '9', '204', '35', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '9', '212', '35', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '9', '396', '35', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '9', '215', '35', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '7', '9', '207', '35', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '396', '35', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '205', '35', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '201', '35', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '207', '35', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '212', '35', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '215', '35', '54');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '204', '35', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '396', '35', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '205', '35', '10');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '396', '35', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '7', '9', '205', '35', '2');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '8', '1', '202', '16', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '8', '1', '396', '16', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '8', '1', '396', '16', '60');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '8', '1', '202', '16', '60');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '8', '2', '202', '13', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '8', '2', '202', '13', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '8', '3', '202', '14', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '8', '3', '202', '14', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '8', '9', '202', '15', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '8', '9', '396', '15', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '8', '9', '205', '15', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '8', '9', '396', '15', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '8', '9', '205', '15', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '8', '9', '202', '15', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '8', '16', '202', '12', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '8', '16', '205', '12', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '8', '16', '396', '12', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '8', '16', '396', '12', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '8', '16', '205', '12', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '8', '16', '202', '12', '67');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '1', '203', '74', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '1', '396', '74', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '1', '211', '74', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '1', '206', '74', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '1', '396', '74', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '1', '206', '74', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '1', '211', '74', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '1', '203', '74', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '5', '203', '72', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '5', '206', '72', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '5', '203', '72', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '5', '206', '72', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '10', '203', '73', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '9', '10', '206', '73', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '10', '203', '73', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '9', '10', '206', '73', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '9', '15', '203', '70', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '9', '15', '206', '70', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '9', '15', '203', '70', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '9', '15', '206', '70', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '9', '16', '203', '71', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '9', '16', '211', '71', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '9', '16', '396', '71', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '9', '16', '206', '71', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '9', '16', '396', '71', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '9', '16', '211', '71', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '9', '16', '203', '71', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '9', '16', '206', '71', '52');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '10', '1', '203', '107', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '10', '1', '396', '107', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '10', '1', '211', '107', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '10', '1', '396', '107', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '10', '1', '203', '107', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '10', '1', '211', '107', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '10', '5', '203', '67', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '10', '5', '211', '67', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '10', '5', '203', '67', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '10', '5', '211', '67', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '10', '10', '211', '68', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '10', '10', '211', '68', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '10', '15', '211', '65', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '10', '15', '211', '65', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '10', '16', '203', '108', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '10', '16', '396', '108', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2112', '10', '16', '211', '108', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '10', '16', '396', '108', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '10', '16', '211', '108', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('64', '10', '16', '203', '108', '49');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '1', '202', '42', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '1', '396', '42', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '1', '211', '42', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '1', '396', '42', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '1', '211', '42', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '1', '202', '42', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '2', '205', '37', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '2', '205', '37', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '3', '207', '39', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '3', '207', '39', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '4', '207', '40', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '4', '207', '40', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '6', '207', '38', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '6', '207', '38', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '9', '202', '41', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '9', '205', '41', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '11', '9', '396', '41', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '9', '396', '41', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '9', '205', '41', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '11', '9', '202', '41', '19');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '1', '201', '30', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '1', '396', '30', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '1', '202', '30', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '1', '211', '30', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '1', '396', '30', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '1', '211', '30', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '1', '202', '30', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '1', '201', '30', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '2', '201', '23', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '2', '205', '23', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '2', '202', '23', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '2', '201', '23', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '2', '202', '23', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '2', '205', '23', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '3', '202', '27', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '3', '202', '27', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '5', '201', '29', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '5', '201', '29', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '9', '201', '28', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '9', '396', '28', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '9', '202', '28', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '9', '205', '28', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '9', '396', '28', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '9', '201', '28', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '9', '202', '28', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '9', '205', '28', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '11', '201', '26', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '11', '201', '26', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '12', '201', '25', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '12', '202', '25', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '12', '213', '25', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '12', '396', '25', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '12', '396', '25', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '12', '201', '25', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '12', '202', '25', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '12', '213', '25', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '13', '201', '25', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '13', '396', '25', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '13', '202', '25', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '13', '396', '25', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '13', '202', '25', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '13', '201', '25', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '14', '201', '24', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '14', '396', '24', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '12', '14', '202', '24', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '14', '396', '24', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '14', '201', '24', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('0', '12', '14', '202', '24', '55');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2059', '128', '1', '203', '64', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('1', '128', '1', '203', '64', '106');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2059', '128', '5', '203', '62', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('1', '128', '5', '203', '62', '106');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2059', '128', '7', '203', '60', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('1', '128', '7', '203', '60', '106');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2059', '128', '10', '203', '63', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('1', '128', '10', '203', '63', '106');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2059', '128', '11', '203', '61', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('1', '128', '11', '203', '61', '82');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2053', '128', '15', '203', '59', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('5', '128', '15', '203', '59', '106');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '130', '1', '396', '80', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '130', '1', '396', '80', '155');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '130', '8', '396', '75', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '130', '8', '396', '75', '155');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '130', '9', '396', '78', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '130', '9', '396', '78', '155');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '130', '10', '396', '79', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '130', '10', '396', '79', '155');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2052', '130', '15', '396', '76', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('4', '130', '15', '396', '76', '155');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2116', '130', '16', '396', '77', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('68', '130', '16', '396', '77', '155');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '1', '208', '92', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '1', '208', '92', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '2', '206', '86', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '2', '208', '86', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '2', '206', '86', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '2', '208', '86', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '3', '208', '88', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '3', '208', '88', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '5', '206', '90', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '5', '206', '90', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '9', '206', '89', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '9', '206', '89', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '10', '208', '91', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '10', '208', '91', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '11', '206', '87', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '11', '206', '87', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2064', '330', '12', '208', '93', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('16', '330', '12', '208', '93', '50');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '1', '216', '94', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '2', '216', '95', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '3', '216', '96', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '4', '216', '97', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '5', '216', '98', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '6', '216', '99', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '7', '216', '100', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '8', '216', '101', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '9', '216', '102', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '11', '216', '103', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '12', '216', '104', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '13', '216', '105', '394');
INSERT INTO `char_create_combinations` (`expansions_req`, `race`, `class`, `deity`, `allocation_id`, `start_zone`) VALUES('2048', '522', '14', '216', '106', '394');



CREATE TABLE `char_create_point_allocations` (
`id` INT(10) UNSIGNED NOT NULL,
`base_str` INT(10) UNSIGNED NOT NULL,
`base_sta` INT(10) UNSIGNED NOT NULL,
`base_dex` INT(10) UNSIGNED NOT NULL,
`base_agi` INT(10) UNSIGNED NOT NULL,
`base_int` INT(10) UNSIGNED NOT NULL,
`base_wis` INT(10) UNSIGNED NOT NULL,
`base_cha` INT(10) UNSIGNED NOT NULL,
`alloc_str` INT(10) UNSIGNED NOT NULL,
`alloc_sta` INT(10) UNSIGNED NOT NULL,
`alloc_dex` INT(10) UNSIGNED NOT NULL,
`alloc_agi` INT(10) UNSIGNED NOT NULL,
`alloc_int` INT(10) UNSIGNED NOT NULL,
`alloc_wis` INT(10) UNSIGNED NOT NULL,
`alloc_cha` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
);

INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('0', '103', '70', '87', '105', '60', '80', '60', '0', '5', '5', '5', '0', '5', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('1', '113', '80', '82', '100', '60', '70', '55', '25', '0', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('2', '103', '80', '92', '95', '60', '70', '55', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('3', '103', '70', '82', '100', '60', '80', '60', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('4', '113', '70', '87', '105', '60', '70', '55', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('5', '65', '75', '90', '70', '99', '93', '60', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('6', '60', '75', '90', '65', '109', '83', '70', '0', '0', '0', '0', '5', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('7', '60', '75', '90', '75', '109', '83', '60', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('8', '60', '85', '90', '65', '109', '83', '60', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('9', '60', '85', '100', '65', '99', '83', '60', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('10', '70', '75', '90', '70', '109', '83', '65', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('11', '70', '75', '95', '75', '99', '83', '60', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('12', '100', '100', '70', '95', '60', '83', '45', '25', '0', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('13', '95', '90', '70', '95', '60', '93', '45', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('14', '100', '90', '70', '95', '60', '88', '55', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('15', '90', '100', '80', '90', '60', '83', '45', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('16', '100', '90', '75', '100', '60', '83', '45', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('17', '65', '70', '70', '75', '107', '93', '70', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('18', '60', '70', '70', '70', '117', '83', '80', '0', '0', '0', '0', '5', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('19', '60', '70', '70', '80', '117', '83', '70', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('20', '60', '80', '70', '70', '117', '83', '70', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('21', '70', '70', '70', '75', '107', '88', '80', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('22', '70', '70', '70', '75', '117', '83', '75', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('23', '65', '85', '85', '75', '98', '77', '60', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('24', '60', '85', '85', '70', '108', '67', '70', '0', '0', '0', '0', '5', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('25', '60', '85', '85', '80', '108', '67', '60', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('26', '60', '95', '85', '70', '108', '67', '60', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('27', '70', '85', '85', '75', '98', '72', '70', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('28', '60', '95', '95', '70', '98', '67', '60', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('29', '70', '85', '85', '75', '108', '67', '65', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('30', '70', '85', '90', '80', '98', '67', '60', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('31', '75', '95', '90', '70', '75', '60', '85', '0', '0', '0', '0', '0', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('32', '70', '85', '90', '80', '75', '70', '75', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('33', '80', '85', '90', '75', '75', '65', '85', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('34', '75', '85', '100', '80', '75', '65', '75', '0', '20', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('35', '70', '95', '100', '70', '75', '60', '75', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('36', '80', '85', '95', '80', '75', '60', '75', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('37', '75', '90', '95', '80', '67', '90', '50', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('38', '70', '90', '95', '85', '67', '90', '50', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('39', '80', '90', '95', '80', '67', '85', '60', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('40', '75', '90', '105', '85', '67', '85', '50', '0', '20', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('41', '70', '100', '105', '75', '67', '80', '50', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('42', '80', '90', '100', '85', '67', '80', '50', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('43', '60', '70', '85', '70', '92', '105', '80', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('44', '55', '70', '85', '65', '102', '95', '90', '0', '0', '0', '0', '5', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('45', '55', '70', '85', '75', '102', '95', '80', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('46', '65', '70', '85', '70', '92', '100', '90', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('47', '80', '85', '75', '75', '75', '75', '85', '0', '0', '0', '0', '0', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('48', '80', '75', '75', '80', '75', '85', '75', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('49', '75', '75', '75', '85', '75', '85', '75', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('50', '75', '75', '75', '75', '85', '75', '85', '0', '0', '0', '0', '5', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('51', '75', '75', '75', '85', '85', '75', '75', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('52', '80', '85', '85', '80', '75', '75', '75', '0', '0', '20', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('53', '75', '85', '75', '75', '85', '75', '75', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('54', '85', '75', '75', '80', '75', '80', '85', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('55', '80', '75', '85', '85', '75', '80', '75', '0', '20', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('56', '75', '85', '85', '75', '75', '75', '75', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('57', '85', '75', '75', '80', '85', '75', '80', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('58', '85', '75', '80', '85', '75', '75', '75', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('59', '70', '85', '95', '80', '75', '90', '60', '0', '5', '5', '5', '0', '5', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('60', '75', '95', '100', '75', '75', '80', '55', '0', '0', '20', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('61', '70', '95', '90', '70', '85', '80', '55', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('62', '80', '85', '90', '75', '85', '80', '60', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('63', '70', '85', '90', '75', '75', '90', '60', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('64', '80', '85', '95', '80', '75', '80', '55', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('65', '130', '70', '75', '132', '60', '77', '42', '0', '5', '5', '5', '0', '5', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('66', '140', '80', '70', '127', '60', '67', '37', '25', '0', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('67', '140', '70', '70', '127', '70', '67', '42', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('68', '130', '70', '70', '127', '60', '77', '42', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('69', '140', '70', '75', '132', '60', '67', '37', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('70', '108', '75', '88', '119', '52', '70', '45', '0', '5', '5', '5', '0', '5', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('71', '118', '85', '83', '114', '52', '60', '40', '25', '0', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('72', '118', '75', '83', '114', '62', '60', '45', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('73', '108', '75', '83', '114', '52', '70', '45', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('74', '118', '75', '88', '119', '52', '60', '40', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('75', '95', '80', '90', '75', '65', '70', '75', '0', '0', '0', '0', '0', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('76', '90', '70', '95', '85', '65', '80', '70', '0', '5', '5', '5', '0', '5', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('77', '100', '80', '90', '80', '65', '70', '65', '25', '0', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('78', '90', '80', '100', '75', '65', '70', '65', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('79', '90', '70', '90', '80', '65', '80', '70', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('80', '100', '70', '95', '85', '65', '70', '65', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('81', '70', '90', '95', '65', '75', '80', '85', '0', '0', '0', '0', '0', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('82', '65', '80', '95', '75', '75', '90', '75', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('83', '70', '80', '105', '75', '75', '85', '75', '0', '20', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('84', '65', '90', '105', '65', '75', '80', '75', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('85', '75', '80', '100', '75', '75', '80', '75', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('86', '75', '100', '100', '85', '75', '85', '50', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('87', '70', '110', '100', '80', '85', '75', '50', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('88', '80', '100', '100', '85', '75', '80', '60', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('89', '70', '110', '110', '80', '75', '75', '50', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('90', '80', '100', '100', '85', '85', '75', '55', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('91', '70', '100', '100', '85', '75', '85', '55', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('92', '80', '100', '105', '90', '75', '75', '50', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('93', '70', '100', '100', '90', '85', '75', '50', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('94', '80', '75', '90', '90', '85', '80', '75', '0', '0', '0', '25', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('95', '75', '75', '85', '85', '85', '90', '75', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('96', '80', '75', '85', '85', '85', '85', '85', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('97', '75', '75', '95', '90', '85', '85', '75', '0', '20', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('98', '80', '75', '85', '85', '95', '80', '80', '0', '0', '0', '20', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('99', '70', '75', '85', '90', '85', '90', '75', '0', '0', '0', '5', '0', '25', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('100', '75', '85', '95', '85', '85', '80', '75', '0', '0', '20', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('101', '75', '85', '85', '80', '85', '80', '85', '0', '0', '0', '0', '0', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('102', '70', '85', '95', '80', '85', '80', '75', '25', '5', '0', '0', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('103', '70', '85', '85', '80', '95', '80', '75', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('104', '70', '75', '85', '90', '95', '80', '75', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('105', '70', '75', '85', '90', '95', '80', '75', '0', '0', '0', '5', '25', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('106', '70', '75', '85', '80', '95', '80', '85', '0', '0', '0', '0', '5', '0', '25');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('107', '140', '70', '75', '132', '60', '67', '37', '7', '0', '0', '18', '0', '0', '0');
INSERT INTO `char_create_point_allocations` (`id`, `base_str`, `base_dex`, `base_agi`, `base_sta`, `base_int`, `base_wis`, `base_cha`, `alloc_str`, `alloc_dex`, `alloc_agi`, `alloc_sta`, `alloc_int`, `alloc_wis`, `alloc_cha`) VALUES('108', '140', '80', '70', '127', '60', '67', '37', '10', '0', '0', '15', '0', '0', '0');


CREATE TABLE `character_buffs` (
`character_id` INT(10) UNSIGNED NOT NULL,
`slot_id` TINYINT(3) UNSIGNED NOT NULL,
`spell_id` SMALLINT(10) UNSIGNED NOT NULL,
`caster_level` TINYINT(3) UNSIGNED NOT NULL,
`caster_name` VARCHAR(64) NOT NULL,
`ticsremaining` INT(10) UNSIGNED NOT NULL,
`counters` INT(10) UNSIGNED NOT NULL,
`numhits` INT(10) UNSIGNED NOT NULL,
`melee_rune` INT(10) UNSIGNED NOT NULL,
`magic_rune` INT(10) UNSIGNED NOT NULL,
`persistent` TINYINT(3) UNSIGNED NOT NULL,
`death_save_chance` INT(10) UNSIGNED NOT NULL,
`death_save_aa_chance` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`character_id`, `slot_id`),
INDEX `character_id` (`character_id`)
);

ALTER TABLE `inventory` ADD COLUMN `custom_data` TEXT NULL AFTER `instnodrop`;
ALTER TABLE `sharedbank` ADD COLUMN `custom_data` TEXT NULL AFTER `augslot5`;

INSERT INTO `rule_values` (`ruleset_id`,`rule_name`,`rule_value`,`notes`) VALUES ('1','Character:StatCap','0','Sets the Max Statistics Cap for PCs. 0 = feature disabled');

ALTER TABLE `spawn2` ADD COLUMN `animation` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `enabled`;

ALTER TABLE doors DROP INDEX DoorIndex;
ALTER TABLE doors ADD CONSTRAINT DoorIndex UNIQUE KEY (zone, doorid, version);

INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Guild:PlayerCreationAllowed', 'true', 'Allow players with Underfoot+ to create a guild via new UI window.');
INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Guild:PlayerCreationLimit', '1', 'Allow players to create a guild using the window in Underfoot+');
INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Guild:PlayerCreationRequiredLevel', '0', 'Required level to use the UF+ window to create a new guild.');
INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Guild:PlayerCreationRequiredStatus', '0', 'Required admin status to use UF+ window to create a new guild.');
INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Guild:PlayerCreationRequiredTime', '0', 'Required Time Entitled on Account to be able to use UF+ window to create a new guild.');

INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Spells:LiveLikeFocusEffects', 'false', 'Makes certain healing, dmg and mana reduction focuses random like live');

INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'NPC:StartEnrageValue', '9', '% HP value that mobs will begin to enrage.');
INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'NPC:LiveLikeEnrage', 'false', 'If enabled, will cause all non-player pets to lose the ability to enrage.');

ALTER TABLE `npc_types` ADD COLUMN `underwater` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `unique_spawn_by_name`;

INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Character:CheckCursorEmptyWhenLooting', 'true', 'If true, a player cannot loot a corpse (player or NPC) with an item on their cursor');
INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Character:MaintainIntoxicationAcrossZones', 'true', 'If true, alcohol effects are maintained across zoning and logging out/in.');

CREATE TABLE `alternate_currency` (
`id` INT(10) NOT NULL,
`item_id` INT(10) NOT NULL,
PRIMARY KEY (`id`)
);

CREATE TABLE `character_alt_currency` (
`char_id` INT(10) UNSIGNED NOT NULL,
`currency_id` INT(10) UNSIGNED NOT NULL,
`amount` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`char_id`, `currency_id`)
)
ENGINE=InnoDB;

ALTER TABLE `merchantlist` ADD COLUMN `faction_required` SMALLINT NOT NULL DEFAULT '-100' AFTER `item`, ADD COLUMN `level_required` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `faction_required`, ADD COLUMN `alt_currency_cost` SMALLINT UNSIGNED NOT NULL DEFAULT '0' AFTER `level_required`;
ALTER TABLE `npc_types` ADD COLUMN `alt_currency_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `merchant_id`;
ALTER TABLE `lootdrop_entries` CHANGE COLUMN `item_charges` `item_charges` SMALLINT(2) UNSIGNED NOT NULL DEFAULT '1' AFTER `item_id`;
ALTER TABLE `inventory` CHANGE COLUMN `charges` `charges` SMALLINT(3) UNSIGNED NULL DEFAULT '0' AFTER `itemid`;
ALTER TABLE `sharedbank` CHANGE COLUMN `charges` `charges` SMALLINT(3) UNSIGNED NULL DEFAULT '0' AFTER `itemid`;
ALTER TABLE `object` CHANGE COLUMN `charges` `charges` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `itemid`;
ALTER TABLE `object_contents` CHANGE COLUMN `charges` `charges` SMALLINT(3) NOT NULL DEFAULT '0' AFTER `itemid`;

INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Skills:MaxTrainSpecializations', '50', 'Max level a GM trainer will train casting specializations');



Please look into it when you get a moment. We love your tools and already miss this one.

Thanks in advance!

[Akkadius]

Looks to me like the `custom _data` column additions probably broke the tool.

[GeorgeS]

Thanks for the heads-up. You guys make troubleshooting bugs way too easy :)

I'll look into this tonight and barring any disaster, should have a fix later.

George

[Lillu]

Thanks for the quick reply Georges. Looking forward to the fix. =)

[GeorgeS]

Just uploaded the fixed binary. You should be good to go,

That was pretty hard. I had to update the database to r2022 (for SoD), which I got to work past server select, then goes back to server select.
Any ideas? -- I'm using minilogin.

GeorgeS

[blackdragonsdg]

Does the new items editor require a specific version of ODBC drivers or mysql? I ask because I am suddenly getting a mysql connection failure but it is only occuring with the new items editor. The old editor and the rest of your tools are still working. My db.ini is correct...checked it three time just to be sure. Ran register.ocx with no issues. Any ideas?

I have mysql 5.1.59 and odbc driver 3.51 and 5.1.9.

[trevius]

I don't use minilogin, but maybe this thread can help, GeorgeS:

http://www.eqemulator.org/forums/showthread.php?t=30894

Otherwise, I would maybe suggest trying to use EQEmuLoginServer or even setting your server to Public if that is an option for you. The EQEmuLoginServer can be a bit rough to get configured properly at first, but once you get it, it is way better than Minilogin.

[lerxst2112]

Does the new items editor require a specific version of ODBC drivers or mysql? I ask because I am suddenly getting a mysql connection failure but it is only occuring with the new items editor. The old editor and the rest of your tools are still working. My db.ini is correct...checked it three time just to be sure. Ran register.ocx with no issues. Any ideas?

I have mysql 5.1.59 and odbc driver 3.51 and 5.1.9.

I'm not having any issues. Make sure you didn't overwrite your db.ini file with the one from the archive. If you did you'll need to put your information back in it.

[Lillu]

Thanks for the quick fix Georges. Love this tool, it's awesome. :)

[Expletus]

Does the new items editor require a specific version of ODBC drivers or mysql? I ask because I am suddenly getting a mysql connection failure but it is only occuring with the new items editor. The old editor and the rest of your tools are still working. My db.ini is correct...checked it three time just to be sure. Ran register.ocx with no issues. Any ideas?

I have mysql 5.1.59 and odbc driver 3.51 and 5.1.9.

Were you able to get this working? The same thing is happening to me and I've tried everything to correct it. According to your test connection everything is working correctly and it's a fresh copy of the programs (happening in this one and the eqitems version). It was working till I got the new copy, everything installs correctly, kinda lost.

[GeorgeS]

Does the tool show the splash screen?

Or does it crash after that?

A connection error means something with the db.ini is not being recognized.
If that's the case, I will build in something tonight in the tool to show if this is the case.

Let me know..

GeorgeS

[Expletus]

It says "MYSQL Connection FAILED! - Check DB.INI OR MyODBC Drivers not installed"

The splash screen comes up, I can click lets go, and the main program comes up. Any query ran crashed it out. Its the same DB info that I am running w/your other programs and they work. Its just the newest versions of eqitems and npc loot edit. To make it really weird, trade skill recipes works with in the same folder.

[blackdragonsdg]

Were you able to get this working? The same thing is happening to me and I've tried everything to correct it. According to your test connection everything is working correctly and it's a fresh copy of the programs (happening in this one and the eqitems version). It was working till I got the new copy, everything installs correctly, kinda lost.

Nope both of the updated tools give the same error and it happens on two different computers.
Expletus what version of mysql were you using?

[Expletus]

Looks like 5.0.82

[lerxst2112]

I use 5.0.91 and it's working fine for me.

[GeorgeS]

This is not a mysql issue, as the queries are basic.

Do any of you get an error message at the bottom of the spalsh screen that says "Error in mp3 playing"?
That could be important and relatively easy to fix.


GeorgeS

[Expletus]

"MUSIC DLL Failed. Not fatal!"

That shows in the top right of the splash screen after the first error box.

[blackdragonsdg]

Yes I got that same error about music failing to play.

[GeorgeS]

That's exactly what I hoped was going on. Now to figure out the dll issue..

George

[GeorgeS]

Ok here's the fix

make sure you have dll library quartz.dll in resources.
Next register it with the register bat file inlcuding this entry below -

regsvr32 quartz.dll

That will fix it.

GeorgeS

[Psiodon]

still getting "MYSQL Connection FAILED! - Check DB.INI OR MyODBC Drivers not installed" and music dll showing failed on splash screen

psi

[blackdragonsdg]

I still get the same connection error with both tools.

[GeorgeS]

Ok, are in running windows 7 or XP?

You should put quartz.dll in windows/system32/ to fix the music issue.
The exact error that should display is "Error in mp3 playing" - I hope you see that at least. It's looking for deaththeme.mp3 in your eq folder.
Now the program is designed to not fail when there's no music but should give a pop up after the splash screen indicating an error has occured but the program will continue without music.

Next the more likely issue -
Th issue may is with your items table, and not with your db.ini since the splash screen checks for a connection to mysql. You can tell it's ok when you see somewhere this text "RUNNING DBVERSION POP0700" or some version close to that. Also the splash screen will not appear.

This points to the items table. The next step to fix this is for you to export your items table as a sql, zip it up and send it to me. Make sure you have the create table included as well as the full inserts.

send it to me @ wizardportal@email.com.

Thanks
Georges

[blackdragonsdg]

GeorgeS, I sent you an email with my items table attached.

[GeorgeS]

Also, I have created a beta version with the music deleted. unrar and replace and see if this works

http://georgestools.eqemulator.net/eqitems.rar


George

Thanks for the table. I'm on it now

[blackdragonsdg]

GeorgeS, thanks for trying to fix the connection problem.....the beta version with no music still gives the same connection error.

[Expletus]

Same connection error no matter what I do.

[GeorgeS]

Ok that's real bad. So far nothing I tried works. Schema that blackdragonsdg gave me is identical to mine, so it therefore has to be something with the version of mysql or the odbc connection/drivers.

Also, just realized this - the only version of the ODBC drivers that I know work 100% are the ones from my site. Make sure you're using that one.

Next, just to be sure, this beta version has a new splash screen with a connection status. I am guessing it states connection is a sucess?
-- Does the main program load ok but when you hit search, does it crash right there or just after the grid populates first with items?

So the last resort is to make a test version for you guys that logs every code branch to a log file. I will work on that tonight.

GeorgeS

[blackdragonsdg]

Both the normal version and beta version of the items editor give the connection error right after the program is launched and stops right there. There is no splash screen or anything else displayed.

The npc loot editor will give the connection error then once i click ok it will load the splash screen. Splash screen displays the graphics fine and in the top right hand corner says Music DLL Failed. Error Not Fatal! and afterwards I can load into the program and hit search and it says the failed connection stuff again and then Run-time error '91': Object variable or With Block variable not set.

[GeorgeS]

Another very similar program with a similar startup is the merchant editor. Does it run ok?
I think if it does, then I have a solution to fix the program tonight.

George

[blackdragonsdg]

Are you talking about the merchant editor inside the npc_loot_editor or is there another one I am not aware of?
The merchant editor that is launched from within the npc_loot_editor gives the same connection error as the other tools and crashes with the same run-time error 91 that is mentioned above.

[GeorgeS]

Sorry, the old version of the tool - try this
http://georgestools.eqemulator.net/Merchant_Editor.zip

If this does not work, then this pretty much makes all tools that access the DB not working.
Can you zip up your db.ini or paste it here - just modify the password, but otherwise I would like to check it.

GeorgeS

[Akkadius]

They all don't work now on latest releases.

Had to use old version for someone else who uses them (Ashes) .

:)

[GeorgeS]

I uploaded a full beta with error logging

http://georgestools.eqemulator.net/eqitems.rar

Updated the db.ini -- please use this and only this in the file, and modify the credentials to yours.

host=localhost
user=root
password=eqemu
database=peq_2022
everquest_folder=c:\Underfoot_Steam


What I need if for each of you to paste the contents of the logfile.txt in root folder of this tool. Also, what version does work?

Thanks -GeorgeS

[blackdragonsdg]

Sorry, the old version of the tool - try this
http://georgestools.eqemulator.net/Merchant_Editor.zip

If this does not work, then this pretty much makes all tools that access the DB not working.
Can you zip up your db.ini or paste it here - just modify the password, but otherwise I would like to check it.

GeorgeS

This worked perfectly.

[blackdragonsdg]

I uploaded a full beta with error logging

http://georgestools.eqemulator.net/eqitems.rar

Updated the db.ini -- please use this and only this in the file, and modify the credentials to yours.

host=localhost
user=root
password=eqemu
database=peq_2022
everquest_folder=c:\Underfoot_Steam


What I need if for each of you to paste the contents of the logfile.txt in root folder of this tool. Also, what version does work?

Thanks -GeorgeS

This won't even launch. I get Run-time error '53': File not found. It doesn't even specify which file it can't find.

[GeorgeS]

Oh, I think it needs an empty text file called logfile.txt in root folder where the exe runs from.

GeorgeS

[Psiodon]

creating log entry
Identified user:root
Identified database:peq
Identified host:localhost
Identified everquest_folder:c:\EverQuest\
Completed getting user info
credential output to screen ok
Call to ODBC open connection started
Call to ODBC open connection failed

[GeorgeS]

An update - thanks for MS for breaking compatibility

An ADO application does not run on down-level operating systems after you recompile it on a computer that is running Windows 7 SP 1 or Windows Server 2008 R2 SP 1 or that has KB983246 installed



Thank you Psiodon for that error log file- now that means one thing - I compiled using win7 SP1 and that breaks the ADO in other OS versions.

So now I am compiling several other versions for you all to test.
Also, I am going to test on a non sp1 machine once I get EQ installed, then hopefully the tools will work by sometime sunday. Keeps fingers crossed.
When you DL the test exe's please indicate your OS SP# and sucess/fail/works or something similar


GeorgeS

[blackdragonsdg]

Well the logfile.txt in the root directory fixed the run-time error but that is where everything ended. I get an immediate connection error and here is the split second log.

creating log entry
Identified user:root
Identified database:peq
Identified host:localhost
Identified everquest_folder:C:\Program Files (x86)\Everquest - SoD\
Completed getting user info
credential output to screen ok
Call to ODBC open connection started
Call to ODBC open connection failed

I am using Vista Ultimate SP2 fully update as of today.

[GeorgeS]

Ok, after endless work on this, I got it to work on the test machine.
Now using a backwards compatible DLL, it should all work again as it should have in the first place.

Please DL the newest binaries -

http://georgestools.eqemulator.net/eqitems.zip

Hope this is it after this long crazy ordeal.


--remember to run register_ocx.bat because I am using a new dll

GeorgeS

[KingMort]

I can't seem to get the Loot Editor to load :(

[blackdragonsdg]

The items editor is working perfectly again. Thanks GeorgeS!

[Psiodon]

working now, will you be updating the npc loot editor as well since same problem?

Psi

[Expletus]

items works great now except for the UI. It's all over the place on my screen and nothing is lining up. Any idea how to fix that?

[GeorgeS]

Ok just added the same code base to the npc&loot editor. Uploaded the zip now.

Oh regarding the UI, nothing ever is changed. I would check your screen res. or change the setting just to make sure. There's very little I can do.

GeorgeS

[Wolfling]

Hi
I just downloaded the new npc loot editor. as i see you have updated, great tools btw =)

But im getting..
run time error 53
file not found
However, the original one still seems to works fine, so no big problem atm

the tradeskill tool works fine in the updated zip
tried this on my modified db, and current peq 2027 db, with latest core, sql updates

[GeorgeS]

I just noticed file logfile.txt is missing from zip. Just create an empty file called logfile.txt in the same folder as the .exe

I'll fix the distribution tonight

GeorgeS

[Akkadius]

While you are making fixes, is there anyway we can get versions of each of these editors that don't have a bunch of graphics, using them through Remote Desktop could be much faster if they had a 'thin' option.

Thanks,
Akkadius

[Wolfling]

Thanks for the update, I will do that tonight.
Also
Is there any chance of updating icon viewer?
Another of your handy tools)
Absolutly no rush, just of it can be done at some point.
If there is anything I can help with, I will


Thanks again
Wolf

[GeorgeS]

What do you want updated with the icon viewer?
Are there more icons you want added?

GeorgeS

[Wolfling]

Yes
The dragitems are over 100 now
I keep my items updated and also make custom items.
So it comes in handy
There are a few missing on the last page, I managed to make the gifs for those but any added beyond the last one dont show

I know that most of these newer icons will be the new house items and such, so this isn't important and put on the "might do later" pile

You have a life, and I know how time consuming things like this can be )

Thanks again
Wolf

[KingMort]

I just wanted to say You Rock George as usual , keep up the good work man we all appreciate it very much !