Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #1  
Old 10-24-2011, 10:23 PM
Lillu
Hill Giant
 
Join Date: Sep 2008
Posts: 204
Default 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!
__________________
Reply With Quote
  #2  
Old 10-24-2011, 11:03 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Looks to me like the `custom _data` column additions probably broke the tool.
Reply With Quote
  #3  
Old 10-26-2011, 12:12 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #4  
Old 10-28-2011, 08:38 AM
Lillu
Hill Giant
 
Join Date: Sep 2008
Posts: 204
Default

Thanks for the quick reply Georges. Looking forward to the fix. =)
__________________
Reply With Quote
  #5  
Old 10-31-2011, 01:37 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #6  
Old 10-31-2011, 02:56 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 654
Default

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.
Reply With Quote
  #7  
Old 11-08-2011, 03:51 PM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,743
Default

I use 5.0.91 and it's working fine for me.
Reply With Quote
  #8  
Old 11-09-2011, 11:21 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #9  
Old 11-09-2011, 11:53 AM
Expletus
Hill Giant
 
Join Date: Jan 2010
Location: Baltimore Maryland
Posts: 152
Default

"MUSIC DLL Failed. Not fatal!"

That shows in the top right of the splash screen after the first error box.
__________________
Expletus / Volgar
Reply With Quote
  #10  
Old 11-09-2011, 02:13 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 654
Default

Yes I got that same error about music failing to play.
Reply With Quote
  #11  
Old 11-09-2011, 06:58 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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

George
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #12  
Old 11-10-2011, 10:56 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #13  
Old 11-10-2011, 11:56 PM
Psiodon
Fire Beetle
 
Join Date: Feb 2010
Posts: 8
Default

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

psi
Reply With Quote
  #14  
Old 11-11-2011, 12:53 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #15  
Old 11-11-2011, 12:46 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 654
Default

I still get the same connection error with both tools.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:01 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3