|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::GeorgeS's Tools A forum just for GeorgeS's tools |
 |
|
 |
10-24-2011, 10:23 PM
|
|
Hill Giant
|
|
Join Date: Sep 2008
Posts: 204
|
|
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.
(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!
__________________
|
 |
|
 |
10-24-2011, 11:03 PM
|
 |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Looks to me like the `custom _data` column additions probably broke the tool.
|
10-26-2011, 12:12 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
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 |
10-28-2011, 08:38 AM
|
|
Hill Giant
|
|
Join Date: Sep 2008
Posts: 204
|
|
Thanks for the quick reply Georges. Looking forward to the fix. =)
__________________
|
10-31-2011, 01:37 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
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
|
10-31-2011, 02:56 AM
|
|
Dragon
|
|
Join Date: Dec 2008
Location: Tennessee
Posts: 654
|
|
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.
|
11-08-2011, 03:51 PM
|
|
Demi-God
|
|
Join Date: Aug 2010
Posts: 1,742
|
|
I use 5.0.91 and it's working fine for me.
|
11-09-2011, 11:21 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
This is not a mysql issue, as the queries are basic.
Do any of you get an error message at the bottom of the spalsh screen that says "Error in mp3 playing"?
That could be important and relatively easy to fix.
GeorgeS
|
11-09-2011, 11:53 AM
|
|
Hill Giant
|
|
Join Date: Jan 2010
Location: Baltimore Maryland
Posts: 152
|
|
"MUSIC DLL Failed. Not fatal!"
That shows in the top right of the splash screen after the first error box.
__________________
Expletus / Volgar
|
11-09-2011, 02:13 PM
|
|
Dragon
|
|
Join Date: Dec 2008
Location: Tennessee
Posts: 654
|
|
Yes I got that same error about music failing to play.
|
11-09-2011, 06:58 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
That's exactly what I hoped was going on. Now to figure out the dll issue..
George
|
11-10-2011, 10:56 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
Ok here's the fix
make sure you have dll library quartz.dll in resources.
Next register it with the register bat file inlcuding this entry below -
regsvr32 quartz.dll
That will fix it.
GeorgeS
|
11-10-2011, 11:56 PM
|
|
Fire Beetle
|
|
Join Date: Feb 2010
Posts: 8
|
|
still getting "MYSQL Connection FAILED! - Check DB.INI OR MyODBC Drivers not installed" and music dll showing failed on splash screen
psi
|
|
|
|
11-11-2011, 12:53 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
Ok, are in running windows 7 or XP?
You should put quartz.dll in windows/system32/ to fix the music issue.
The exact error that should display is "Error in mp3 playing" - I hope you see that at least. It's looking for deaththeme.mp3 in your eq folder.
Now the program is designed to not fail when there's no music but should give a pop up after the splash screen indicating an error has occured but the program will continue without music.
Next the more likely issue -
Th issue may is with your items table, and not with your db.ini since the splash screen checks for a connection to mysql. You can tell it's ok when you see somewhere this text "RUNNING DBVERSION POP0700" or some version close to that. Also the splash screen will not appear.
This points to the items table. The next step to fix this is for you to export your items table as a sql, zip it up and send it to me. Make sure you have the create table included as well as the full inserts.
send it to me @ wizardportal@email.com.
Thanks
Georges |
|
|
|
11-11-2011, 12:46 AM
|
|
Dragon
|
|
Join Date: Dec 2008
Location: Tennessee
Posts: 654
|
|
I still get the same connection error with both tools.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 09:33 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Hybrid Mode
