diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_12_01_00_world.sql | 842 | ||||
| -rw-r--r-- | sql/updates/world/2014_12_01_01_world.sql | 277 | ||||
| -rw-r--r-- | sql/updates/world/2014_12_04_00_world.sql | 64 |
3 files changed, 485 insertions, 698 deletions
diff --git a/sql/updates/world/2014_12_01_00_world.sql b/sql/updates/world/2014_12_01_00_world.sql index fed2dbf6ade..6e96a1bfe9a 100644 --- a/sql/updates/world/2014_12_01_00_world.sql +++ b/sql/updates/world/2014_12_01_00_world.sql @@ -1,423 +1,423 @@ DELETE FROM `playercreateinfo_action`; INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES -('10', '10', '0', '100780', '0'), -('10', '10', '9', '129597', '0'), -('10', '10', '72', '100780', '0'), -('10', '10', '81', '129597', '0'), -('10', '8', '0', '44614', '0'), -('10', '8', '9', '28730', '0'), -('10', '9', '0', '686', '0'), -('10', '9', '9', '28730', '0'), -('10', '9', '10', '10', '48'), -('10', '2', '0', '35395', '0'), -('10', '2', '9', '155145', '0'), -('10', '3', '0', '3044', '0'), -('10', '3', '9', '80483', '0'), -('10', '3', '10', '9', '48'), -('10', '3', '11', '982', '0'), -('10', '1', '0', '88163', '0'), -('10', '1', '1', '78', '0'), -('10', '1', '9', '69179', '0'), -('10', '1', '72', '88163', '0'), -('10', '1', '73', '78', '0'), -('10', '1', '81', '69179', '0'), -('10', '4', '0', '1752', '0'), -('10', '4', '9', '25046', '0'), -('10', '5', '0', '585', '0'), -('10', '5', '9', '28730', '0'), -('4', '6', '0', '6603', '0'), -('4', '6', '1', '49576', '0'), -('4', '6', '2', '45477', '0'), -('4', '6', '3', '45462', '0'), -('4', '6', '4', '50842', '0'), -('4', '6', '5', '47541', '0'), -('4', '6', '10', '58984', '0'), -('4', '6', '83', '58984', '0'), -('7', '6', '0', '6603', '0'), -('7', '6', '1', '49576', '0'), -('7', '6', '2', '45477', '0'), -('7', '6', '3', '45462', '0'), -('7', '6', '4', '50842', '0'), -('7', '6', '5', '47541', '0'), -('7', '6', '10', '20589', '0'), -('7', '6', '72', '6603', '0'), -('7', '6', '83', '117', '128'), -('7', '6', '84', '6603', '0'), -('7', '6', '96', '6603', '0'), -('7', '6', '108', '6603', '0'), -('3', '6', '0', '6603', '0'), -('3', '6', '1', '49576', '0'), -('3', '6', '2', '45477', '0'), -('3', '6', '3', '45462', '0'), -('3', '6', '4', '50842', '0'), -('3', '6', '5', '47541', '0'), -('1', '6', '0', '6603', '0'), -('1', '6', '1', '49576', '0'), -('1', '6', '2', '45477', '0'), -('1', '6', '3', '45462', '0'), -('1', '6', '4', '50842', '0'), -('1', '6', '5', '47541', '0'), -('1', '6', '11', '59752', '0'), -('6', '6', '0', '6603', '0'), -('6', '6', '1', '49576', '0'), -('6', '6', '2', '45477', '0'), -('6', '6', '3', '45462', '0'), -('6', '6', '4', '50842', '0'), -('6', '6', '5', '47541', '0'), -('6', '6', '10', '20549', '0'), -('6', '6', '75', '20549', '0'), -('2', '6', '0', '6603', '0'), -('2', '6', '1', '49576', '0'), -('2', '6', '2', '45477', '0'), -('2', '6', '3', '45462', '0'), -('2', '6', '4', '50842', '0'), -('2', '6', '5', '47541', '0'), -('2', '6', '10', '20572', '0'), -('22', '6', '0', '6603', '0'), -('22', '6', '1', '49576', '0'), -('22', '6', '2', '45477', '0'), -('22', '6', '3', '45462', '0'), -('22', '6', '4', '50842', '0'), -('22', '6', '5', '47541', '0'), -('22', '6', '9', '68992', '0'), -('22', '6', '10', '68996', '0'), -('22', '6', '11', '87840', '0'), -('5', '6', '0', '6603', '0'), -('5', '6', '1', '49576', '0'), -('5', '6', '2', '45477', '0'), -('5', '6', '3', '45462', '0'), -('5', '6', '4', '50842', '0'), -('5', '6', '5', '47541', '0'), -('5', '6', '10', '20577', '0'), -('10', '6', '0', '6603', '0'), -('10', '6', '1', '49576', '0'), -('10', '6', '2', '45477', '0'), -('10', '6', '3', '45462', '0'), -('10', '6', '4', '50842', '0'), -('10', '6', '5', '47541', '0'), -('10', '6', '6', '50613', '0'), -('8', '6', '0', '6603', '0'), -('8', '6', '1', '49576', '0'), -('8', '6', '2', '45477', '0'), -('8', '6', '3', '45462', '0'), -('8', '6', '4', '50842', '0'), -('8', '6', '5', '47541', '0'), -('8', '6', '10', '26297', '0'), -('9', '6', '0', '6603', '0'), -('9', '6', '1', '49576', '0'), -('9', '6', '2', '45477', '0'), -('9', '6', '3', '45462', '0'), -('9', '6', '4', '50842', '0'), -('9', '6', '5', '47541', '0'), -('9', '6', '9', '69070', '0'), -('9', '6', '10', '69041', '0'), -('9', '6', '11', '69046', '0'), -('11', '6', '0', '6603', '0'), -('11', '6', '1', '49576', '0'), -('11', '6', '2', '45477', '0'), -('11', '6', '3', '45462', '0'), -('11', '6', '4', '50842', '0'), -('11', '6', '5', '47541', '0'), -('11', '6', '10', '59545', '0'), -('11', '3', '0', '3044', '0'), -('11', '3', '9', '59543', '0'), -('11', '3', '10', '9', '48'), -('11', '3', '11', '982', '0'), -('11', '3', '72', '6603', '0'), -('11', '3', '74', '75', '0'), -('11', '3', '82', '159', '128'), -('11', '3', '83', '4540', '128'), -('11', '2', '0', '35395', '0'), -('11', '2', '9', '59542', '0'), -('11', '2', '83', '4540', '128'), -('11', '1', '0', '88163', '0'), -('11', '1', '1', '78', '0'), -('11', '1', '9', '28880', '0'), -('11', '1', '72', '88163', '0'), -('11', '1', '73', '78', '0'), -('11', '1', '81', '28880', '0'), -('11', '5', '0', '585', '0'), -('11', '5', '9', '59544', '0'), -('11', '5', '83', '4540', '128'), -('11', '7', '0', '403', '0'), -('11', '7', '9', '59547', '0'), -('11', '10', '0', '100780', '0'), -('11', '10', '72', '100780', '0'), -('11', '10', '81', '121093', '0'), -('11', '8', '0', '44614', '0'), -('11', '8', '9', '59548', '0'), -('11', '8', '83', '4540', '128'), -('3', '3', '0', '3044', '0'), -('3', '3', '9', '20594', '0'), -('3', '3', '10', '9', '48'), -('3', '3', '11', '982', '0'), -('3', '3', '75', '20594', '0'), -('3', '2', '0', '35395', '0'), -('3', '2', '9', '20594', '0'), -('3', '1', '0', '88163', '0'), -('3', '1', '1', '78', '0'), -('3', '1', '9', '20594', '0'), -('3', '1', '72', '88163', '0'), -('3', '1', '73', '78', '0'), -('3', '1', '81', '20594', '0'), -('3', '7', '0', '403', '0'), -('3', '7', '9', '20594', '0'), -('3', '7', '72', '403', '0'), -('3', '5', '0', '585', '0'), -('3', '5', '9', '20594', '0'), -('3', '4', '0', '1752', '0'), -('3', '4', '9', '20594', '0'), -('3', '10', '0', '100780', '0'), -('3', '10', '72', '100780', '0'), -('3', '10', '81', '20594', '0'), -('3', '9', '0', '686', '0'), -('3', '9', '9', '20594', '0'), -('3', '9', '10', '10', '48'), -('3', '8', '0', '44614', '0'), -('3', '8', '9', '20594', '0'), -('7', '5', '0', '585', '0'), -('7', '4', '0', '1752', '0'), -('7', '1', '0', '88163', '0'), -('7', '1', '1', '78', '0'), -('7', '1', '72', '88163', '0'), -('7', '1', '73', '78', '0'), -('7', '1', '81', '20589', '0'), -('7', '10', '0', '100780', '0'), -('7', '10', '72', '100780', '0'), -('7', '10', '81', '20589', '0'), -('7', '9', '0', '686', '0'), -('7', '9', '10', '10', '48'), -('7', '8', '0', '44614', '0'), -('9', '9', '0', '686', '0'), -('9', '9', '9', '69070', '0'), -('9', '9', '10', '69041', '0'), -('9', '9', '11', '10', '48'), -('9', '8', '0', '44614', '0'), -('9', '8', '9', '69070', '0'), -('9', '8', '10', '69041', '0'), -('9', '1', '0', '88163', '0'), -('9', '1', '1', '78', '0'), -('9', '1', '9', '69070', '0'), -('9', '1', '10', '69041', '0'), -('9', '1', '72', '88163', '0'), -('9', '1', '73', '78', '0'), -('9', '1', '81', '69070', '0'), -('9', '1', '82', '69041', '0'), -('9', '3', '0', '3044', '0'), -('9', '3', '8', '982', '0'), -('9', '3', '9', '69070', '0'), -('9', '3', '10', '69041', '0'), -('9', '3', '11', '9', '48'), -('9', '5', '0', '585', '0'), -('9', '5', '9', '69070', '0'), -('9', '5', '10', '69041', '0'), -('9', '4', '0', '1752', '0'), -('9', '4', '9', '69070', '0'), -('9', '4', '10', '69041', '0'), -('9', '7', '0', '403', '0'), -('9', '7', '9', '69070', '0'), -('9', '7', '10', '69041', '0'), -('9', '7', '72', '403', '0'), -('1', '1', '0', '88163', '0'), -('1', '1', '1', '78', '0'), -('1', '1', '9', '59752', '0'), -('1', '1', '72', '88163', '0'), -('1', '1', '73', '78', '0'), -('1', '1', '81', '59752', '0'), -('1', '3', '0', '3044', '0'), -('1', '3', '9', '59752', '0'), -('1', '3', '10', '9', '48'), -('1', '3', '11', '982', '0'), -('1', '2', '0', '35395', '0'), -('1', '2', '9', '59752', '0'), -('1', '5', '0', '585', '0'), -('1', '5', '9', '59752', '0'), -('1', '4', '0', '1752', '0'), -('1', '4', '9', '59752', '0'), -('1', '9', '0', '686', '0'), -('1', '9', '9', '59752', '0'), -('1', '9', '10', '10', '48'), -('1', '8', '0', '44614', '0'), -('1', '8', '9', '59752', '0'), -('1', '10', '0', '100780', '0'), -('1', '10', '72', '100780', '0'), -('1', '10', '81', '59752', '0'), -('4', '4', '0', '1752', '0'), -('4', '4', '4', '58984', '0'), -('4', '4', '81', '58984', '0'), -('4', '5', '0', '585', '0'), -('4', '5', '9', '58984', '0'), -('4', '5', '81', '58984', '0'), -('4', '1', '0', '88163', '0'), -('4', '1', '1', '78', '0'), -('4', '1', '9', '58984', '0'), -('4', '1', '72', '88163', '0'), -('4', '1', '73', '78', '0'), -('4', '1', '81', '58984', '0'), -('4', '3', '0', '3044', '0'), -('4', '3', '9', '58984', '0'), -('4', '3', '10', '9', '48'), -('4', '3', '11', '982', '0'), -('4', '3', '81', '58984', '0'), -('4', '8', '0', '44614', '0'), -('4', '8', '9', '58984', '0'), -('4', '10', '0', '100780', '0'), -('4', '10', '72', '100780', '0'), -('4', '10', '81', '58984', '0'), -('4', '11', '0', '5176', '0'), -('4', '11', '9', '58984', '0'), -('4', '11', '72', '6603', '0'), -('4', '11', '74', '58984', '0'), -('4', '11', '84', '6603', '0'), -('4', '11', '96', '6603', '0'), -('4', '11', '108', '6603', '0'), -('2', '3', '0', '3044', '0'), -('2', '3', '9', '20572', '0'), -('2', '3', '10', '9', '48'), -('2', '3', '11', '982', '0'), -('2', '1', '0', '88163', '0'), -('2', '1', '1', '78', '0'), -('2', '1', '9', '20572', '0'), -('2', '1', '72', '88163', '0'), -('2', '1', '73', '78', '0'), -('2', '1', '81', '20572', '0'), -('2', '7', '0', '403', '0'), -('2', '7', '9', '33697', '0'), -('2', '7', '72', '403', '0'), -('2', '4', '0', '1752', '0'), -('2', '4', '9', '20572', '0'), -('2', '10', '0', '100780', '0'), -('2', '10', '72', '100780', '0'), -('2', '10', '81', '33697', '0'), -('2', '8', '0', '44614', '0'), -('2', '8', '9', '33702', '0'), -('2', '9', '0', '686', '0'), -('2', '9', '9', '33702', '0'), -('2', '9', '10', '10', '48'), -('24', '8', '0', '44614', '0'), -('24', '8', '9', '107079', '0'), -('24', '8', '11', '77264', '128'), -('24', '10', '0', '100780', '0'), -('24', '10', '72', '100780', '0'), -('24', '10', '81', '107079', '0'), -('24', '10', '83', '77272', '128'), -('24', '1', '0', '88163', '0'), -('24', '1', '1', '78', '0'), -('24', '1', '9', '107079', '0'), -('24', '1', '11', '77273', '128'), -('24', '1', '72', '88163', '0'), -('24', '1', '73', '78', '0'), -('24', '1', '81', '107079', '0'), -('24', '1', '83', '77273', '128'), -('24', '3', '0', '3044', '0'), -('24', '3', '7', '77272', '128'), -('24', '3', '9', '107079', '0'), -('24', '3', '10', '9', '48'), -('24', '3', '11', '982', '0'), -('24', '4', '0', '1752', '0'), -('24', '4', '9', '107079', '0'), -('24', '4', '11', '77272', '128'), -('24', '5', '0', '585', '0'), -('24', '5', '9', '107079', '0'), -('24', '5', '11', '77264', '128'), -('24', '7', '0', '403', '0'), -('24', '7', '9', '107079', '0'), -('24', '7', '11', '77272', '128'), -('24', '7', '72', '403', '0'), -('6', '7', '0', '403', '0'), -('6', '7', '9', '20549', '0'), -('6', '7', '75', '20549', '0'), -('6', '5', '0', '585', '0'), -('6', '5', '9', '20549', '0'), -('6', '2', '0', '35395', '0'), -('6', '2', '9', '20549', '0'), -('6', '3', '0', '3044', '0'), -('6', '3', '9', '20549', '0'), -('6', '3', '10', '9', '48'), -('6', '3', '11', '982', '0'), -('6', '3', '75', '20549', '0'), -('6', '1', '0', '88163', '0'), -('6', '1', '1', '78', '0'), -('6', '1', '9', '20549', '0'), -('6', '1', '72', '88163', '0'), -('6', '1', '73', '78', '0'), -('6', '1', '81', '20549', '0'), -('6', '10', '0', '100780', '0'), -('6', '10', '72', '100780', '0'), -('6', '10', '81', '20549', '0'), -('6', '11', '0', '5176', '0'), -('6', '11', '9', '20549', '0'), -('6', '11', '72', '6603', '0'), -('6', '11', '75', '20549', '0'), -('6', '11', '84', '6603', '0'), -('6', '11', '96', '6603', '0'), -('6', '11', '108', '6603', '0'), -('8', '8', '0', '44614', '0'), -('8', '8', '9', '26297', '0'), -('8', '9', '0', '686', '0'), -('8', '9', '9', '26297', '0'), -('8', '9', '10', '10', '48'), -('8', '10', '0', '100780', '0'), -('8', '10', '72', '100780', '0'), -('8', '10', '81', '26297', '0'), -('8', '11', '0', '5176', '0'), -('8', '11', '9', '26297', '0'), -('8', '11', '72', '6603', '0'), -('8', '11', '84', '6603', '0'), -('8', '11', '96', '6603', '0'), -('8', '1', '0', '88163', '0'), -('8', '1', '1', '78', '0'), -('8', '1', '9', '26297', '0'), -('8', '1', '72', '88163', '0'), -('8', '1', '73', '78', '0'), -('8', '1', '81', '26297', '0'), -('8', '3', '0', '3044', '0'), -('8', '3', '9', '26297', '0'), -('8', '3', '10', '9', '48'), -('8', '3', '11', '982', '0'), -('8', '4', '0', '1752', '0'), -('8', '4', '9', '26297', '0'), -('8', '4', '76', '26297', '0'), -('8', '5', '0', '585', '0'), -('8', '5', '9', '26297', '0'), -('8', '7', '0', '403', '0'), -('8', '7', '9', '26297', '0'), -('8', '7', '72', '403', '0'), -('5', '5', '0', '585', '0'), -('5', '5', '9', '20577', '0'), -('5', '4', '0', '1752', '0'), -('5', '4', '9', '20577', '0'), -('5', '1', '0', '88163', '0'), -('5', '1', '1', '78', '0'), -('5', '1', '9', '20577', '0'), -('5', '1', '72', '88163', '0'), -('5', '1', '73', '78', '0'), -('5', '1', '81', '20577', '0'), -('5', '3', '0', '3044', '0'), -('5', '3', '9', '20577', '0'), -('5', '3', '10', '9', '48'), -('5', '3', '11', '982', '0'), -('5', '9', '0', '686', '0'), -('5', '9', '9', '20577', '0'), -('5', '9', '10', '10', '48'), -('5', '8', '0', '44614', '0'), -('5', '8', '9', '20577', '0'), -('5', '10', '0', '100780', '0'), -('5', '10', '72', '100780', '0'), -('5', '10', '81', '20577', '0'), -('22', '4', '0', '1752', '0'), -('22', '5', '0', '585', '0'), -('22', '3', '0', '3044', '0'), -('22', '3', '10', '9', '48'), -('22', '3', '11', '982', '0'), -('22', '1', '0', '88163', '0'), -('22', '1', '1', '78', '0'), -('22', '1', '72', '88163', '0'), -('22', '1', '73', '78', '0'), -('22', '11', '0', '5176', '0'), -('22', '11', '72', '6603', '0'), -('22', '11', '84', '6603', '0'), -('22', '11', '96', '6603', '0'), -('22', '8', '0', '44614', '0'), -('22', '9', '0', '686', '0'), -('22', '9', '10', '10', '48'); +(10, 10, 0, 100780, 0), +(10, 10, 9, 129597, 0), +(10, 10, 72, 100780, 0), +(10, 10, 81, 129597, 0), +(10, 8, 0, 44614, 0), +(10, 8, 9, 28730, 0), +(10, 9, 0, 686, 0), +(10, 9, 9, 28730, 0), +(10, 9, 10, 10, 48), +(10, 2, 0, 35395, 0), +(10, 2, 9, 155145, 0), +(10, 3, 0, 3044, 0), +(10, 3, 9, 80483, 0), +(10, 3, 10, 9, 48), +(10, 3, 11, 982, 0), +(10, 1, 0, 88163, 0), +(10, 1, 1, 78, 0), +(10, 1, 9, 69179, 0), +(10, 1, 72, 88163, 0), +(10, 1, 73, 78, 0), +(10, 1, 81, 69179, 0), +(10, 4, 0, 1752, 0), +(10, 4, 9, 25046, 0), +(10, 5, 0, 585, 0), +(10, 5, 9, 28730, 0), +(4, 6, 0, 6603, 0), +(4, 6, 1, 49576, 0), +(4, 6, 2, 45477, 0), +(4, 6, 3, 45462, 0), +(4, 6, 4, 50842, 0), +(4, 6, 5, 47541, 0), +(4, 6, 10, 58984, 0), +(4, 6, 83, 58984, 0), +(7, 6, 0, 6603, 0), +(7, 6, 1, 49576, 0), +(7, 6, 2, 45477, 0), +(7, 6, 3, 45462, 0), +(7, 6, 4, 50842, 0), +(7, 6, 5, 47541, 0), +(7, 6, 10, 20589, 0), +(7, 6, 72, 6603, 0), +(7, 6, 83, 117, 128), +(7, 6, 84, 6603, 0), +(7, 6, 96, 6603, 0), +(7, 6, 108, 6603, 0), +(3, 6, 0, 6603, 0), +(3, 6, 1, 49576, 0), +(3, 6, 2, 45477, 0), +(3, 6, 3, 45462, 0), +(3, 6, 4, 50842, 0), +(3, 6, 5, 47541, 0), +(1, 6, 0, 6603, 0), +(1, 6, 1, 49576, 0), +(1, 6, 2, 45477, 0), +(1, 6, 3, 45462, 0), +(1, 6, 4, 50842, 0), +(1, 6, 5, 47541, 0), +(1, 6, 11, 59752, 0), +(6, 6, 0, 6603, 0), +(6, 6, 1, 49576, 0), +(6, 6, 2, 45477, 0), +(6, 6, 3, 45462, 0), +(6, 6, 4, 50842, 0), +(6, 6, 5, 47541, 0), +(6, 6, 10, 20549, 0), +(6, 6, 75, 20549, 0), +(2, 6, 0, 6603, 0), +(2, 6, 1, 49576, 0), +(2, 6, 2, 45477, 0), +(2, 6, 3, 45462, 0), +(2, 6, 4, 50842, 0), +(2, 6, 5, 47541, 0), +(2, 6, 10, 20572, 0), +(22, 6, 0, 6603, 0), +(22, 6, 1, 49576, 0), +(22, 6, 2, 45477, 0), +(22, 6, 3, 45462, 0), +(22, 6, 4, 50842, 0), +(22, 6, 5, 47541, 0), +(22, 6, 9, 68992, 0), +(22, 6, 10, 68996, 0), +(22, 6, 11, 87840, 0), +(5, 6, 0, 6603, 0), +(5, 6, 1, 49576, 0), +(5, 6, 2, 45477, 0), +(5, 6, 3, 45462, 0), +(5, 6, 4, 50842, 0), +(5, 6, 5, 47541, 0), +(5, 6, 10, 20577, 0), +(10, 6, 0, 6603, 0), +(10, 6, 1, 49576, 0), +(10, 6, 2, 45477, 0), +(10, 6, 3, 45462, 0), +(10, 6, 4, 50842, 0), +(10, 6, 5, 47541, 0), +(10, 6, 6, 50613, 0), +(8, 6, 0, 6603, 0), +(8, 6, 1, 49576, 0), +(8, 6, 2, 45477, 0), +(8, 6, 3, 45462, 0), +(8, 6, 4, 50842, 0), +(8, 6, 5, 47541, 0), +(8, 6, 10, 26297, 0), +(9, 6, 0, 6603, 0), +(9, 6, 1, 49576, 0), +(9, 6, 2, 45477, 0), +(9, 6, 3, 45462, 0), +(9, 6, 4, 50842, 0), +(9, 6, 5, 47541, 0), +(9, 6, 9, 69070, 0), +(9, 6, 10, 69041, 0), +(9, 6, 11, 69046, 0), +(11, 6, 0, 6603, 0), +(11, 6, 1, 49576, 0), +(11, 6, 2, 45477, 0), +(11, 6, 3, 45462, 0), +(11, 6, 4, 50842, 0), +(11, 6, 5, 47541, 0), +(11, 6, 10, 59545, 0), +(11, 3, 0, 3044, 0), +(11, 3, 9, 59543, 0), +(11, 3, 10, 9, 48), +(11, 3, 11, 982, 0), +(11, 3, 72, 6603, 0), +(11, 3, 74, 75, 0), +(11, 3, 82, 159, 128), +(11, 3, 83, 4540, 128), +(11, 2, 0, 35395, 0), +(11, 2, 9, 59542, 0), +(11, 2, 83, 4540, 128), +(11, 1, 0, 88163, 0), +(11, 1, 1, 78, 0), +(11, 1, 9, 28880, 0), +(11, 1, 72, 88163, 0), +(11, 1, 73, 78, 0), +(11, 1, 81, 28880, 0), +(11, 5, 0, 585, 0), +(11, 5, 9, 59544, 0), +(11, 5, 83, 4540, 128), +(11, 7, 0, 403, 0), +(11, 7, 9, 59547, 0), +(11, 10, 0, 100780, 0), +(11, 10, 72, 100780, 0), +(11, 10, 81, 121093, 0), +(11, 8, 0, 44614, 0), +(11, 8, 9, 59548, 0), +(11, 8, 83, 4540, 128), +(3, 3, 0, 3044, 0), +(3, 3, 9, 20594, 0), +(3, 3, 10, 9, 48), +(3, 3, 11, 982, 0), +(3, 3, 75, 20594, 0), +(3, 2, 0, 35395, 0), +(3, 2, 9, 20594, 0), +(3, 1, 0, 88163, 0), +(3, 1, 1, 78, 0), +(3, 1, 9, 20594, 0), +(3, 1, 72, 88163, 0), +(3, 1, 73, 78, 0), +(3, 1, 81, 20594, 0), +(3, 7, 0, 403, 0), +(3, 7, 9, 20594, 0), +(3, 7, 72, 403, 0), +(3, 5, 0, 585, 0), +(3, 5, 9, 20594, 0), +(3, 4, 0, 1752, 0), +(3, 4, 9, 20594, 0), +(3, 10, 0, 100780, 0), +(3, 10, 72, 100780, 0), +(3, 10, 81, 20594, 0), +(3, 9, 0, 686, 0), +(3, 9, 9, 20594, 0), +(3, 9, 10, 10, 48), +(3, 8, 0, 44614, 0), +(3, 8, 9, 20594, 0), +(7, 5, 0, 585, 0), +(7, 4, 0, 1752, 0), +(7, 1, 0, 88163, 0), +(7, 1, 1, 78, 0), +(7, 1, 72, 88163, 0), +(7, 1, 73, 78, 0), +(7, 1, 81, 20589, 0), +(7, 10, 0, 100780, 0), +(7, 10, 72, 100780, 0), +(7, 10, 81, 20589, 0), +(7, 9, 0, 686, 0), +(7, 9, 10, 10, 48), +(7, 8, 0, 44614, 0), +(9, 9, 0, 686, 0), +(9, 9, 9, 69070, 0), +(9, 9, 10, 69041, 0), +(9, 9, 11, 10, 48), +(9, 8, 0, 44614, 0), +(9, 8, 9, 69070, 0), +(9, 8, 10, 69041, 0), +(9, 1, 0, 88163, 0), +(9, 1, 1, 78, 0), +(9, 1, 9, 69070, 0), +(9, 1, 10, 69041, 0), +(9, 1, 72, 88163, 0), +(9, 1, 73, 78, 0), +(9, 1, 81, 69070, 0), +(9, 1, 82, 69041, 0), +(9, 3, 0, 3044, 0), +(9, 3, 8, 982, 0), +(9, 3, 9, 69070, 0), +(9, 3, 10, 69041, 0), +(9, 3, 11, 9, 48), +(9, 5, 0, 585, 0), +(9, 5, 9, 69070, 0), +(9, 5, 10, 69041, 0), +(9, 4, 0, 1752, 0), +(9, 4, 9, 69070, 0), +(9, 4, 10, 69041, 0), +(9, 7, 0, 403, 0), +(9, 7, 9, 69070, 0), +(9, 7, 10, 69041, 0), +(9, 7, 72, 403, 0), +(1, 1, 0, 88163, 0), +(1, 1, 1, 78, 0), +(1, 1, 9, 59752, 0), +(1, 1, 72, 88163, 0), +(1, 1, 73, 78, 0), +(1, 1, 81, 59752, 0), +(1, 3, 0, 3044, 0), +(1, 3, 9, 59752, 0), +(1, 3, 10, 9, 48), +(1, 3, 11, 982, 0), +(1, 2, 0, 35395, 0), +(1, 2, 9, 59752, 0), +(1, 5, 0, 585, 0), +(1, 5, 9, 59752, 0), +(1, 4, 0, 1752, 0), +(1, 4, 9, 59752, 0), +(1, 9, 0, 686, 0), +(1, 9, 9, 59752, 0), +(1, 9, 10, 10, 48), +(1, 8, 0, 44614, 0), +(1, 8, 9, 59752, 0), +(1, 10, 0, 100780, 0), +(1, 10, 72, 100780, 0), +(1, 10, 81, 59752, 0), +(4, 4, 0, 1752, 0), +(4, 4, 4, 58984, 0), +(4, 4, 81, 58984, 0), +(4, 5, 0, 585, 0), +(4, 5, 9, 58984, 0), +(4, 5, 81, 58984, 0), +(4, 1, 0, 88163, 0), +(4, 1, 1, 78, 0), +(4, 1, 9, 58984, 0), +(4, 1, 72, 88163, 0), +(4, 1, 73, 78, 0), +(4, 1, 81, 58984, 0), +(4, 3, 0, 3044, 0), +(4, 3, 9, 58984, 0), +(4, 3, 10, 9, 48), +(4, 3, 11, 982, 0), +(4, 3, 81, 58984, 0), +(4, 8, 0, 44614, 0), +(4, 8, 9, 58984, 0), +(4, 10, 0, 100780, 0), +(4, 10, 72, 100780, 0), +(4, 10, 81, 58984, 0), +(4, 11, 0, 5176, 0), +(4, 11, 9, 58984, 0), +(4, 11, 72, 6603, 0), +(4, 11, 74, 58984, 0), +(4, 11, 84, 6603, 0), +(4, 11, 96, 6603, 0), +(4, 11, 108, 6603, 0), +(2, 3, 0, 3044, 0), +(2, 3, 9, 20572, 0), +(2, 3, 10, 9, 48), +(2, 3, 11, 982, 0), +(2, 1, 0, 88163, 0), +(2, 1, 1, 78, 0), +(2, 1, 9, 20572, 0), +(2, 1, 72, 88163, 0), +(2, 1, 73, 78, 0), +(2, 1, 81, 20572, 0), +(2, 7, 0, 403, 0), +(2, 7, 9, 33697, 0), +(2, 7, 72, 403, 0), +(2, 4, 0, 1752, 0), +(2, 4, 9, 20572, 0), +(2, 10, 0, 100780, 0), +(2, 10, 72, 100780, 0), +(2, 10, 81, 33697, 0), +(2, 8, 0, 44614, 0), +(2, 8, 9, 33702, 0), +(2, 9, 0, 686, 0), +(2, 9, 9, 33702, 0), +(2, 9, 10, 10, 48), +(24, 8, 0, 44614, 0), +(24, 8, 9, 107079, 0), +(24, 8, 11, 77264, 128), +(24, 10, 0, 100780, 0), +(24, 10, 72, 100780, 0), +(24, 10, 81, 107079, 0), +(24, 10, 83, 77272, 128), +(24, 1, 0, 88163, 0), +(24, 1, 1, 78, 0), +(24, 1, 9, 107079, 0), +(24, 1, 11, 77273, 128), +(24, 1, 72, 88163, 0), +(24, 1, 73, 78, 0), +(24, 1, 81, 107079, 0), +(24, 1, 83, 77273, 128), +(24, 3, 0, 3044, 0), +(24, 3, 7, 77272, 128), +(24, 3, 9, 107079, 0), +(24, 3, 10, 9, 48), +(24, 3, 11, 982, 0), +(24, 4, 0, 1752, 0), +(24, 4, 9, 107079, 0), +(24, 4, 11, 77272, 128), +(24, 5, 0, 585, 0), +(24, 5, 9, 107079, 0), +(24, 5, 11, 77264, 128), +(24, 7, 0, 403, 0), +(24, 7, 9, 107079, 0), +(24, 7, 11, 77272, 128), +(24, 7, 72, 403, 0), +(6, 7, 0, 403, 0), +(6, 7, 9, 20549, 0), +(6, 7, 75, 20549, 0), +(6, 5, 0, 585, 0), +(6, 5, 9, 20549, 0), +(6, 2, 0, 35395, 0), +(6, 2, 9, 20549, 0), +(6, 3, 0, 3044, 0), +(6, 3, 9, 20549, 0), +(6, 3, 10, 9, 48), +(6, 3, 11, 982, 0), +(6, 3, 75, 20549, 0), +(6, 1, 0, 88163, 0), +(6, 1, 1, 78, 0), +(6, 1, 9, 20549, 0), +(6, 1, 72, 88163, 0), +(6, 1, 73, 78, 0), +(6, 1, 81, 20549, 0), +(6, 10, 0, 100780, 0), +(6, 10, 72, 100780, 0), +(6, 10, 81, 20549, 0), +(6, 11, 0, 5176, 0), +(6, 11, 9, 20549, 0), +(6, 11, 72, 6603, 0), +(6, 11, 75, 20549, 0), +(6, 11, 84, 6603, 0), +(6, 11, 96, 6603, 0), +(6, 11, 108, 6603, 0), +(8, 8, 0, 44614, 0), +(8, 8, 9, 26297, 0), +(8, 9, 0, 686, 0), +(8, 9, 9, 26297, 0), +(8, 9, 10, 10, 48), +(8, 10, 0, 100780, 0), +(8, 10, 72, 100780, 0), +(8, 10, 81, 26297, 0), +(8, 11, 0, 5176, 0), +(8, 11, 9, 26297, 0), +(8, 11, 72, 6603, 0), +(8, 11, 84, 6603, 0), +(8, 11, 96, 6603, 0), +(8, 1, 0, 88163, 0), +(8, 1, 1, 78, 0), +(8, 1, 9, 26297, 0), +(8, 1, 72, 88163, 0), +(8, 1, 73, 78, 0), +(8, 1, 81, 26297, 0), +(8, 3, 0, 3044, 0), +(8, 3, 9, 26297, 0), +(8, 3, 10, 9, 48), +(8, 3, 11, 982, 0), +(8, 4, 0, 1752, 0), +(8, 4, 9, 26297, 0), +(8, 4, 76, 26297, 0), +(8, 5, 0, 585, 0), +(8, 5, 9, 26297, 0), +(8, 7, 0, 403, 0), +(8, 7, 9, 26297, 0), +(8, 7, 72, 403, 0), +(5, 5, 0, 585, 0), +(5, 5, 9, 20577, 0), +(5, 4, 0, 1752, 0), +(5, 4, 9, 20577, 0), +(5, 1, 0, 88163, 0), +(5, 1, 1, 78, 0), +(5, 1, 9, 20577, 0), +(5, 1, 72, 88163, 0), +(5, 1, 73, 78, 0), +(5, 1, 81, 20577, 0), +(5, 3, 0, 3044, 0), +(5, 3, 9, 20577, 0), +(5, 3, 10, 9, 48), +(5, 3, 11, 982, 0), +(5, 9, 0, 686, 0), +(5, 9, 9, 20577, 0), +(5, 9, 10, 10, 48), +(5, 8, 0, 44614, 0), +(5, 8, 9, 20577, 0), +(5, 10, 0, 100780, 0), +(5, 10, 72, 100780, 0), +(5, 10, 81, 20577, 0), +(22, 4, 0, 1752, 0), +(22, 5, 0, 585, 0), +(22, 3, 0, 3044, 0), +(22, 3, 10, 9, 48), +(22, 3, 11, 982, 0), +(22, 1, 0, 88163, 0), +(22, 1, 1, 78, 0), +(22, 1, 72, 88163, 0), +(22, 1, 73, 78, 0), +(22, 11, 0, 5176, 0), +(22, 11, 72, 6603, 0), +(22, 11, 84, 6603, 0), +(22, 11, 96, 6603, 0), +(22, 8, 0, 44614, 0), +(22, 9, 0, 686, 0), +(22, 9, 10, 10, 48); diff --git a/sql/updates/world/2014_12_01_01_world.sql b/sql/updates/world/2014_12_01_01_world.sql deleted file mode 100644 index d9532d5881b..00000000000 --- a/sql/updates/world/2014_12_01_01_world.sql +++ /dev/null @@ -1,277 +0,0 @@ -DROP TABLE IF EXISTS `playercreateinfo_skills`; -DROP TABLE IF EXISTS `playercreateinfo_spell`; - -CREATE TABLE `playercreateinfo_spell` ( - `racemask` int(10) unsigned NOT NULL DEFAULT '0', - `classmask` int(10) unsigned NOT NULL DEFAULT '0', - `Spell` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Note` varchar(255) DEFAULT NULL, - PRIMARY KEY (`racemask`,`classmask`,`Spell`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES -('10487807', '943', '201', 'One-Handed Swords'), -('10487807', '623', '196', 'One-Handed Axes'), -('10487807', '1659', '198', 'One-Handed Maces'), -('10487807', '2047', '522', 'SPELLDEFENSE (DND)'), -('10487807', '2047', '204', 'Defense'), -('10487807', '2047', '81', 'Dodge'), -('946', '2047', '669', 'Language Orcish'), -('10487807', '2005', '227', 'Staves'), -('512', '959', '813', 'Language Thalassian'), -('10487807', '2047', '203', 'Unarmed'), -('10487807', '2047', '6478', 'Opening'), -('10487807', '2047', '6603', 'Auto Attack'), -('10487807', '2047', '45927', 'Summon Friend'), -('10487807', '2047', '22027', 'Remove Insignia'), -('10487807', '2047', '114585', 'Mastery'), -('10487807', '2047', '2382', 'Generic'), -('10487807', '2047', '21652', 'Closing'), -('10487807', '2047', '8386', 'Attacking'), -('10487807', '2047', '7266', 'Duel'), -('10487807', '2047', '7267', 'Grovel'), -('10487807', '2047', '7355', 'Stuck'), -('10487807', '2047', '6233', 'Closing'), -('10487807', '2047', '6247', 'Opening'), -('10487807', '2047', '6477', 'Opening'), -('10487807', '2047', '115043', 'Player Damage Reduction'), -('10487807', '2047', '3050', 'Detect'), -('10487807', '2047', '9125', 'Generic'), -('10487807', '2047', '61437', 'Opening'), -('10487807', '2047', '68398', 'Opening'), -('10487807', '2047', '96220', 'Opening'), -('8390399', '512', '106902', 'Weapon Skills'), -('8390399', '512', '106904', 'Armor Skills'), -('10487807', '2047', '3365', 'Opening'), -('10487807', '2047', '21651', 'Opening'), -('10487807', '2047', '6246', 'Closing'), -('10487807', '2047', '132334', ''), -('10487807', '2047', '22810', 'Opening - No Text'), -('10487807', '2047', '134732', 'Battle Fatigue'), -('10487807', '2047', '161691', 'Garrison Ability'), -('10487807', '1575', '200', 'Polearms'), -('10487807', '1647', '9077', 'Leather'), -('10487807', '2047', '9078', 'Cloth'), -('10487807', '1613', '15590', 'Fist Weapons'), -('512', '959', '822', 'Arcane Resistance'), -('512', '959', '28877', 'Arcane Affinity'), -('512', '959', '79748', 'Languages'), -('512', '512', '129597', 'Arcane Torrent'), -('512', '959', '154742', 'Arcane Acuity'), -('8390399', '512', '125670', 'Targeted Expulsion'), -('8390399', '512', '116812', 'Parry'), -('8390399', '512', '128678', 'Jab'), -('8390399', '512', '107500', '<DND> Monk Energy Driver'), -('8390399', '512', '108562', 'Monk Weapon Override Driver'), -('8390399', '512', '108977', 'Way of the Monk'), -('8390399', '512', '120275', 'Way of the Monk'), -('8390399', '512', '115074', 'Fighting Style'), -('8390399', '512', '100780', 'Jab'), -('8390399', '512', '115612', 'Expel Harm Driver'), -('8390399', '512', '119650', 'Energy Usage'), -('8390399', '512', '120277', 'Way of the Monk'), -('8390399', '512', '137022', 'Hotfix Passive'), -('8390399', '512', '103985', 'Stance of the Fierce Tiger'), -('10487807', '1501', '1180', 'Daggers'), -('10487775', '128', '76276', 'Armor Skills'), -('10487775', '128', '76298', 'Weapon Skills'), -('10487807', '400', '5009', 'Wands'), -('10487807', '400', '5019', 'Shoot'), -('512', '400', '28730', 'Arcane Torrent'), -('10487775', '128', '121039', 'Mana Attunement'), -('10487775', '128', '44614', 'Frostfire Bolt'), -('10487775', '128', '137018', 'Hotfix Passive'), -('10487775', '384', '162699', 'Stat Negation Aura - Intellect DPS'), -('2098135', '256', '76299', 'Weapon Skills'), -('2098135', '256', '76277', 'Armor Skills'), -('2098135', '256', '121688', ''), -('2098135', '256', '688', 'Summon Imp'), -('2098135', '256', '686', 'Shadow Bolt'), -('2098135', '256', '114190', ''), -('2098135', '256', '137042', 'Hotfix Passive'), -('2098135', '256', '157903', 'Warlock'), -('10487807', '39', '202', 'Two-Handed Swords'), -('10487807', '67', '107', 'Block'), -('10487807', '1123', '199', 'Two-Handed Maces'), -('10487807', '103', '197', 'Two-Handed Axes'), -('1573', '2', '76271', 'Armor Skills'), -('1573', '2', '76294', 'Weapon Skills'), -('10487807', '35', '119811', 'Mail'), -('10487807', '67', '9116', 'Shield'), -('512', '2', '155145', 'Arcane Torrent'), -('1573', '2', '82242', 'Parry'), -('1573', '2', '123830', 'Block'), -('1573', '2', '35395', 'Crusader Strike'), -('1573', '2', '137026', 'Hotfix Passive'), -('10487807', '13', '264', 'Bows'), -('10487807', '13', '266', 'Guns'), -('10487807', '12', '674', 'Dual Wield'), -('10487743', '4', '34082', 'Hunter Passive Auras (DND)'), -('10487743', '4', '76249', 'Weapon Skills'), -('10487743', '4', '76250', 'Armor Skills'), -('10487743', '4', '75', 'Auto Shot'), -('10487807', '13', '5011', 'Crossbows'), -('512', '4', '80483', 'Arcane Torrent'), -('10487743', '4', '77442', 'Focus'), -('10487743', '4', '883', 'Call Pet 1'), -('10487743', '4', '982', 'Revive Pet'), -('10487743', '4', '137014', 'Hotfix Passive'), -('10487743', '4', '157443', 'Critical Strikes'), -('10487807', '12', '162697', 'Stat Negation Aura - Agility DPS'), -('10487743', '4', '3044', 'Arcane Shot'), -('10487807', '1', '5301', 'Revenge Trigger'), -('10487807', '1', '32215', 'Victorious State'), -('10487807', '1', '76268', 'Armor Skills'), -('10487807', '1', '76290', 'Weapon Skills'), -('512', '1', '69179', 'Arcane Torrent'), -('10487807', '1', '3127', 'Parry'), -('10487807', '1', '88163', 'Attack'), -('10487807', '1', '2457', 'Battle Stance'), -('10487807', '1', '123829', 'Block'), -('10487807', '1', '128217', 'Pummel (shield visual override) (DND)'), -('10487807', '1', '137047', 'Hotfix Passive'), -('10487807', '1', '78', 'Heroic Strike'), -('10486751', '8', '76297', 'Weapon Skills'), -('10486751', '8', '76273', 'Armor Skills'), -('512', '8', '25046', 'Arcane Torrent'), -('10486751', '8', '1752', 'Sinister Strike'), -('10486751', '8', '121733', 'Throw'), -('10486751', '8', '82245', 'Parry'), -('10486751', '8', '137034', 'Hotfix Passive'), -('10486751', '8', '157442', 'Critical Strikes'), -('10487805', '16', '76279', 'Armor Skills'), -('10487805', '16', '76301', 'Weapon Skills'), -('10487805', '16', '585', 'Smite'), -('10487805', '16', '137030', 'Hotfix Passive'), -('2098253', '2047', '668', 'Language Common'), -('8', '1725', '671', 'Language Darnassian'), -('8', '1725', '76252', 'Languages'), -('8', '1725', '20582', 'Quickness'), -('8', '1725', '20585', 'Wisp Spirit'), -('8', '1725', '21009', 'Elusiveness'), -('8', '1725', '58984', 'Shadowmeld'), -('8', '1725', '20583', 'Nature Resistance'), -('8', '1725', '154748', 'Touch of Elune'), -('2099199', '32', '10846', 'First Aid'), -('2099199', '32', '7928', 'Silk Bandage'), -('2099199', '32', '7929', 'Heavy Silk Bandage'), -('2099199', '32', '7934', 'Anti-Venom'), -('2099199', '32', '3275', 'Linen Bandage'), -('2099199', '32', '3276', 'Heavy Linen Bandage'), -('2099199', '32', '3278', 'Heavy Wool Bandage'), -('2099199', '32', '18629', 'Runecloth Bandage'), -('2099199', '32', '10840', 'Mageweave Bandage'), -('2099199', '32', '10841', 'Heavy Mageweave Bandage'), -('2099199', '32', '18630', 'Heavy Runecloth Bandage'), -('2099199', '32', '3277', 'Wool Bandage'), -('2099199', '32', '76292', 'Weapon Skills'), -('2099199', '32', '76282', 'Armor Skills'), -('2099199', '32', '750', 'Plate Mail'), -('2099199', '32', '33391', 'Journeyman Riding'), -('2099199', '32', '86524', 'Plate Specialization'), -('2099199', '32', '82246', 'Parry'), -('2099199', '32', '47541', 'Death Coil'), -('2099199', '32', '49576', 'Death Grip'), -('2099199', '32', '48266', 'Frost Presence'), -('2099199', '32', '45477', 'Icy Touch'), -('2099199', '32', '50842', 'Blood Boil'), -('2099199', '32', '45462', 'Plague Strike'), -('2099199', '32', '137005', 'Hotfix Passive'), -('2099199', '32', '89964', 'Vanishing Powder'), -('2099199', '32', '58715', 'Shifting Presences'), -('2099199', '32', '63644', 'Activating Secondary Spec'), -('2099199', '32', '63645', 'Activating Primary Spec'), -('2099199', '32', '127650', 'Remove Talent'), -('64', '953', '7340', 'Language Gnomish'), -('64', '953', '20589', 'Escape Artist'), -('64', '953', '20593', 'Engineering Specialization'), -('64', '953', '20592', 'Arcane Resistance'), -('64', '953', '92680', 'Nimble Fingers'), -('64', '953', '79740', 'Languages'), -('64', '32', '154747', 'Expansive Mind'), -('4', '1023', '20596', 'Frost Resistance'), -('4', '1023', '20594', 'Stoneform'), -('4', '1023', '59224', 'Might of the Mountain'), -('4', '1023', '92682', 'Explorer'), -('4', '1023', '79739', 'Languages'), -('4', '1023', '672', 'Language Dwarven'), -('1', '959', '20599', 'Diplomacy'), -('1', '959', '20598', 'The Human Spirit'), -('1', '959', '59752', 'Every Man for Himself'), -('1', '959', '79738', 'Languages'), -('32', '1655', '670', 'Language Taurahe'), -('32', '1655', '20549', 'War Stomp'), -('32', '1655', '20550', 'Endurance'), -('32', '1655', '20551', 'Nature Resistance'), -('32', '1655', '20552', 'Cultivation'), -('32', '1655', '79746', 'Languages'), -('32', '1655', '154743', 'Brawn'), -('2', '1005', '21563', 'Command'), -('2', '45', '20572', 'Blood Fury'), -('2', '1005', '20573', 'Hardiness'), -('2', '1005', '79743', 'Languages'), -('2097152', '32', '94293', 'Altered Form'), -('2097152', '32', '87840', 'Running Wild'), -('2097152', '1469', '79742', 'Languages'), -('2097152', '32', '68975', 'Viciousness'), -('2097152', '32', '68978', 'Flayer'), -('2097152', '32', '68992', 'Darkflight'), -('2097152', '32', '68976', 'Aberration'), -('2097152', '32', '68996', 'Two Forms'), -('16', '957', '5227', 'Touch of the Grave'), -('16', '957', '7744', 'Will of the Forsaken'), -('16', '957', '20577', 'Cannibalize'), -('16', '957', '20579', 'Shadow Resistance'), -('16', '957', '79747', 'Languages'), -('16', '957', '17737', 'Language Gutterspeak'), -('512', '32', '50613', 'Arcane Torrent'), -('128', '2045', '7341', 'Language Troll'), -('128', '2045', '26297', 'Berserking'), -('128', '2045', '58943', 'Da Voodoo Shuffle'), -('128', '2045', '20555', 'Regeneration'), -('128', '2045', '20557', 'Beast Slaying'), -('128', '2045', '79744', 'Languages'), -('256', '32', '69046', 'Pack Hobgoblin'), -('256', '509', '79749', 'Languages'), -('256', '509', '69070', 'Rocket Jump'), -('256', '509', '69044', 'Best Deals Anywhere'), -('256', '509', '69045', 'Better Living Through Chemistry'), -('256', '509', '69041', 'Rocket Barrage'), -('256', '509', '69042', 'Time is Money'), -('256', '509', '69269', 'Language Goblin'), -('1024', '759', '29932', 'Language Draenei'), -('1024', '759', '6562', 'Heroic Presence'), -('1024', '759', '28875', 'Gemcutting'), -('1024', '759', '59221', 'Shadow Resistance'), -('1024', '32', '59545', 'Gift of the Naaru'), -('1024', '759', '79741', 'Languages'), -('1024', '4', '59543', 'Gift of the Naaru'), -('1024', '2', '59542', 'Gift of the Naaru'), -('1024', '1', '28880', 'Gift of the Naaru'), -('1024', '16', '59544', 'Gift of the Naaru'), -('8390054', '64', '76296', 'Weapon Skills'), -('8390054', '64', '76272', 'Armor Skills'), -('1024', '64', '59547', 'Gift of the Naaru'), -('8390054', '64', '403', 'Lightning Bolt'), -('8390054', '64', '123831', 'Block'), -('8390054', '64', '137038', 'Hotfix Passive'), -('1024', '512', '121093', 'Gift of the Naaru'), -('1024', '128', '59548', 'Gift of the Naaru'), -('64', '912', '20591', 'Expansive Mind'), -('64', '520', '154744', 'Expansive Mind'), -('64', '1', '154746', 'Expansive Mind'), -('2097320', '1024', '76275', 'Armor Skills'), -('2097320', '1024', '76300', 'Weapon Skills'), -('2097320', '1024', '5176', 'Wrath'), -('2097320', '1024', '137009', 'Hotfix Passive'), -('2097320', '1024', '159822', 'Shapemender'), -('2', '576', '33697', 'Blood Fury'), -('2', '384', '33702', 'Blood Fury'), -('8388608', '733', '131701', 'Languages'), -('8388608', '733', '107076', 'Bouncy'), -('8388608', '733', '107074', 'Inner Peace'), -('8388608', '733', '107073', 'Gourmand'), -('8388608', '733', '107072', 'Epicurean'), -('8388608', '733', '107079', 'Quaking Palm'), -('8388608', '733', '108127', 'Language Pandaren Neutral'), -('2097152', '1437', '69001', ''); diff --git a/sql/updates/world/2014_12_04_00_world.sql b/sql/updates/world/2014_12_04_00_world.sql new file mode 100644 index 00000000000..5308b0f51d7 --- /dev/null +++ b/sql/updates/world/2014_12_04_00_world.sql @@ -0,0 +1,64 @@ +DROP TABLE IF EXISTS `playercreateinfo_spell`; +DROP TABLE IF EXISTS `playercreateinfo_skills`; +CREATE TABLE `playercreateinfo_skills` ( + `raceMask` int(10) unsigned NOT NULL, + `classMask` int(10) unsigned NOT NULL, + `skill` smallint(5) unsigned NOT NULL, + `rank` smallint(5) unsigned NOT NULL DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`raceMask`,`classMask`,`skill`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `playercreateinfo_skills` (`raceMask`, `classMask`, `skill`, `rank`, `comment`) VALUES +(0, 0, 95, 0, 'Defense'), +(0, 0, 162, 0, 'Unarmed'), +(0, 0, 183, 0, 'GENERIC (DND)'), +(0, 0, 415, 0, 'Cloth'), +(0, 0, 777, 0, 'Mounts'), +(0, 0, 778, 0, 'Companion Pets'), +(0, 0, 934, 0, 'All - Specializations'), +(0, 3, 160, 0, 'Two-Handed Maces'), +(0, 4, 45, 0, 'Bows'), +(0, 4, 46, 0, 'Guns'), +(0, 4, 226, 0, 'Crossbows'), +(0, 8, 176, 0, 'Thrown'), +(0, 32, 129, 4, 'Death Knight - First Aid'), +(0, 32, 229, 0, 'Polearms'), +(0, 32, 293, 0, 'Plate'), +(0, 32, 762, 0, 'Death Knight - Riding'), +(0, 35, 55, 0, 'Two-Handed Swords'), +(0, 35, 413, 0, 'Mail'), +(0, 37, 44, 0, 'Axes'), +(0, 37, 172, 0, 'Two-Handed Axes'), +(0, 39, 43, 0, 'Swords'), +(0, 40, 118, 0, 'Dual Wield'), +(0, 67, 433, 0, 'Shield'), +(0, 400, 228, 0, 'Wands'), +(0, 1107, 54, 0, 'Maces'), +(0, 1135, 414, 0, 'Leather'), +(0, 1293, 173, 0, 'Daggers'), +(0, 1488, 136, 0, 'Staves'), +(1, 0, 754, 0, 'Human - Racial'), +(2, 0, 125, 0, 'Orc - Racial'), +(4, 0, 101, 0, 'Dwarf - Racial'), +(4, 0, 111, 0, 'Language: Dwarven'), +(8, 0, 113, 0, 'Language: Darnassian'), +(8, 0, 126, 0, 'Night Elf - Racial'), +(16, 0, 220, 0, 'Undead - Racial'), +(16, 0, 673, 0, 'Language: Forsaken'), +(32, 0, 115, 0, 'Language: Taurahe'), +(32, 0, 124, 0, 'Tauren - Racial'), +(64, 0, 313, 0, 'Language: Gnomish'), +(64, 0, 753, 0, 'Gnome - Racial'), +(128, 0, 315, 0, 'Language: Troll'), +(128, 0, 733, 0, 'Troll - Racial'), +(256, 0, 790, 0, 'Racial - Goblin'), +(256, 0, 792, 0, 'Language: Goblin'), +(512, 0, 137, 0, 'Language: Thalassian'), +(512, 0, 756, 0, 'Blood Elf - Racial'), +(946, 0, 109, 0, 'Language: Orcish'), +(1024, 0, 759, 0, 'Language: Draenei'), +(1024, 0, 760, 0, 'Draenei - Racial'), +(2097152, 0, 789, 0, 'Racial - Worgen'), +(2097152, 0, 791, 0, 'Language: Worgen'), +(2098253, 0, 98, 0, 'Language: Common'); |
