EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::GeorgeS's Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=674)
-   -   Item-Character inventory editor error (https://www.eqemulator.org/forums/showthread.php?t=34388)

Lillu 10-24-2011 10:23 PM

Item-Character inventory editor error
 
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:
Code:

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 10-24-2011 11:03 PM

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

GeorgeS 10-26-2011 12:12 PM

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 10-28-2011 08:38 AM

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

GeorgeS 10-31-2011 01:37 AM

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 10-31-2011 02:56 AM

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 10-31-2011 04:08 AM

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 10-31-2011 05:37 AM

Quote:

Originally Posted by blackdragonsdg (Post 204442)
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 10-31-2011 11:52 AM

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

Expletus 11-08-2011 10:53 AM

Quote:

Originally Posted by blackdragonsdg (Post 204442)
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 11-08-2011 11:19 AM

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 11-08-2011 12:26 PM

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 11-08-2011 02:12 PM

Quote:

Originally Posted by Expletus (Post 204581)
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 11-08-2011 03:07 PM

Looks like 5.0.82

lerxst2112 11-08-2011 03:51 PM

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


All times are GMT -4. The time now is 05:45 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.