· 7 years ago · Dec 06, 2018, 04:28 PM
1CREATE TABLE IF NOT EXISTS `playercreateinfo` (
2 `Index` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
3 `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
4 `factiontemplate` int(10) unsigned NOT NULL DEFAULT '0',
5 `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
6 `mapID` int(10) unsigned NOT NULL DEFAULT '0',
7 `zoneID` int(10) unsigned NOT NULL DEFAULT '0',
8 `positionX` float NOT NULL DEFAULT '0',
9 `positionY` float NOT NULL DEFAULT '0',
10 `positionZ` float NOT NULL DEFAULT '0',
11 `displayID` smallint(5) unsigned NOT NULL DEFAULT '0',
12 `BaseStrength` tinyint(3) unsigned NOT NULL DEFAULT '0',
13 `BaseAgility` tinyint(3) unsigned NOT NULL DEFAULT '0',
14 `BaseStamina` tinyint(3) unsigned NOT NULL DEFAULT '0',
15 `BaseIntellect` tinyint(3) unsigned NOT NULL DEFAULT '0',
16 `BaseSpirit` tinyint(3) unsigned NOT NULL DEFAULT '0',
17 `BaseHealth` int(10) unsigned NOT NULL DEFAULT '0',
18 `BaseMana` int(10) unsigned NOT NULL DEFAULT '0',
19 `BaseRage` int(10) unsigned NOT NULL DEFAULT '0',
20 `BaseFocus` int(10) unsigned NOT NULL DEFAULT '0',
21 `BaseEnergy` int(10) unsigned NOT NULL DEFAULT '0',
22 `attackpower` int(10) unsigned NOT NULL DEFAULT '0',
23 `mindmg` float NOT NULL DEFAULT '0',
24 `maxdmg` float NOT NULL DEFAULT '0',
25 `introid` int(10) unsigned NOT NULL DEFAULT '0',
26 `taximask` tinytext,
27 PRIMARY KEY (`Index`)
28) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1 COMMENT='Player System';
29
30INSERT INTO `playercreateinfo` (`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`, `introid`, `taximask`) VALUES
31 (1, 1, 1, 1, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
32 (2, 1, 1, 2, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
33 (3, 1, 1, 3, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
34 (4, 1, 1, 4, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
35 (5, 1, 1, 5, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
36 (6, 1, 1, 6, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
37 (7, 1, 1, 7, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
38 (8, 1, 1, 8, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
39 (9, 1, 1, 9, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
40 (10, 1, 1, 10, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
41 (11, 1, 1, 11, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
42 (12, 2, 2, 1, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
43 (13, 2, 2, 2, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
44 (14, 2, 2, 3, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
45 (15, 2, 2, 4, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
46 (16, 2, 2, 5, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
47 (17, 2, 2, 6, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
48 (18, 2, 2, 7, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
49 (19, 2, 2, 8, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
50 (20, 2, 2, 9, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
51 (21, 2, 2, 10, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
52 (22, 2, 2, 11, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
53 (23, 3, 3, 1, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
54 (24, 3, 3, 2, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
55 (25, 3, 3, 3, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
56 (26, 3, 3, 4, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
57 (27, 3, 3, 5, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
58 (28, 3, 3, 6, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
59 (29, 3, 3, 7, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
60 (30, 3, 3, 8, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
61 (31, 3, 3, 9, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
62 (32, 3, 3, 10, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
63 (33, 3, 3, 11, 0, 1, -6240.31, 331.03, 382.75, 53, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
64 (34, 4, 4, 1, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
65 (35, 4, 4, 2, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
66 (36, 4, 4, 3, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
67 (37, 4, 4, 4, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
68 (38, 4, 4, 5, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
69 (39, 4, 4, 6, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
70 (40, 4, 4, 7, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
71 (41, 4, 4, 8, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
72 (42, 4, 4, 9, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
73 (43, 4, 4, 10, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
74 (44, 4, 4, 11, 1, 141, 10311.9, 832.25, 1326.39, 55, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
75 (45, 5, 5, 1, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
76 (46, 5, 5, 2, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
77 (47, 5, 5, 3, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
78 (48, 5, 5, 4, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
79 (49, 5, 5, 5, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
80 (50, 5, 5, 6, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
81 (51, 5, 5, 7, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
82 (52, 5, 5, 8, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
83 (53, 5, 5, 9, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
84 (54, 5, 5, 10, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
85 (55, 5, 5, 11, 0, 85, 1676.62, 1677.2, 121.67, 57, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
86 (56, 6, 6, 1, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
87 (57, 6, 6, 2, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
88 (58, 6, 6, 3, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
89 (59, 6, 6, 4, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
90 (60, 6, 6, 5, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
91 (61, 6, 6, 6, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
92 (62, 6, 6, 7, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
93 (63, 6, 6, 8, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
94 (64, 6, 6, 9, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
95 (65, 6, 6, 10, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
96 (66, 6, 6, 11, 1, 215, -2917.58, -257.98, 52.99, 59, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
97 (67, 7, 115, 1, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
98 (68, 7, 115, 2, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
99 (69, 7, 115, 3, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
100 (70, 7, 115, 4, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
101 (71, 7, 115, 5, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
102 (72, 7, 115, 6, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
103 (73, 7, 115, 7, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
104 (74, 7, 115, 8, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
105 (75, 7, 115, 9, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
106 (76, 7, 115, 10, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
107 (77, 7, 115, 11, 0, 1, -6240.31, 331.03, 382.75, 1563, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
108 (78, 8, 116, 1, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
109 (79, 8, 116, 2, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
110 (80, 8, 116, 3, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
111 (81, 8, 116, 4, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
112 (82, 8, 116, 5, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
113 (83, 8, 116, 6, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
114 (84, 8, 116, 7, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
115 (85, 8, 116, 8, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
116 (86, 8, 116, 9, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
117 (87, 8, 116, 10, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
118 (88, 8, 116, 11, 1, 14, -618.51, -4251.66, 38.71, 1478, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
119 (89, 10, 1610, 1, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
120 (90, 10, 1610, 2, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
121 (91, 10, 1610, 3, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
122 (92, 10, 1610, 4, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
123 (93, 10, 1610, 5, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
124 (94, 10, 1610, 6, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
125 (95, 10, 1610, 7, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
126 (96, 10, 1610, 8, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
127 (97, 10, 1610, 9, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
128 (98, 10, 1610, 10, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
129 (99, 10, 1610, 11, 2, 530, 3430, 10357.6, -6369.56, 36.18, 15476, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
130 (100, 11, 1629, 1, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
131 (101, 11, 1629, 2, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
132 (102, 11, 1629, 3, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
133 (103, 11, 1629, 4, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
134 (104, 11, 1629, 5, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
135 (105, 11, 1629, 6, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
136 (106, 11, 1629, 7, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
137 (107, 11, 1629, 8, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
138 (108, 11, 1629, 9, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
139 (109, 11, 1629, 10, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'),
140 (110, 11, 1629, 11, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2');
141
142 CREATE TABLE IF NOT EXISTS `playercreateinfo_spells` (
143 `indexid` tinyint(3) unsigned NOT NULL DEFAULT '0',
144 `spellid` smallint(5) unsigned NOT NULL DEFAULT '0'
145) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Player System';
146
147INSERT INTO `playercreateinfo_spells` (`indexid`, `spellid`) VALUES
148 (2, 20598),
149 (2, 20597),
150 (2, 20600),
151 (2, 59224),
152 (2, 59752),
153 (2, 81),
154 (2, 20599),
155 (2, 107),
156 (2, 6603),
157 (1, 20598),
158 (1, 20597),
159 (1, 20600),
160 (1, 59224),
161 (1, 59752),
162 (1, 81),
163 (1, 20599),
164 (1, 107),
165 (1, 6603),
166 (3, 6603),
167 (3, 107),
168 (3, 20599),
169 (3, 81),
170 (3, 59752),
171 (3, 59224),
172 (3, 20600),
173 (3, 20597),
174 (3, 20598),
175 (4, 6603),
176 (4, 107),
177 (4, 20599),
178 (4, 81),
179 (4, 59752),
180 (4, 59224),
181 (4, 20600),
182 (4, 20597),
183 (4, 20598),
184 (5, 6603),
185 (5, 107),
186 (5, 20599),
187 (5, 81),
188 (5, 59752),
189 (5, 59224),
190 (5, 20600),
191 (5, 20597),
192 (5, 20598),
193 (6, 6603),
194 (6, 107),
195 (6, 20599),
196 (6, 81),
197 (6, 59752),
198 (6, 59224),
199 (6, 20600),
200 (6, 20597),
201 (6, 20598),
202 (7, 6603),
203 (7, 107),
204 (7, 20599),
205 (7, 81),
206 (7, 59752),
207 (7, 59224),
208 (7, 20600),
209 (7, 20597),
210 (7, 20598),
211 (8, 6603),
212 (8, 107),
213 (8, 20599),
214 (8, 81),
215 (8, 59752),
216 (8, 59224),
217 (8, 20600),
218 (8, 20597),
219 (8, 20598),
220 (9, 6603),
221 (9, 107),
222 (9, 20599),
223 (9, 81),
224 (9, 59752),
225 (9, 59224),
226 (9, 20600),
227 (9, 20597),
228 (9, 20598),
229 (10, 6603),
230 (10, 107),
231 (10, 20599),
232 (10, 81),
233 (10, 59752),
234 (10, 59224),
235 (10, 20600),
236 (10, 20597),
237 (10, 20598),
238 (11, 6603),
239 (11, 107),
240 (11, 20599),
241 (11, 81),
242 (11, 59752),
243 (11, 59224),
244 (11, 20600),
245 (11, 20597),
246 (11, 20598),
247 (12, 6603),
248 (12, 107),
249 (12, 81),
250 (12, 20574),
251 (12, 33697),
252 (12, 21563),
253 (12, 20573),
254 (13, 6603),
255 (13, 107),
256 (13, 81),
257 (13, 20574),
258 (13, 33697),
259 (13, 21563),
260 (13, 20573),
261 (14, 6603),
262 (14, 107),
263 (14, 81),
264 (14, 20574),
265 (14, 33697),
266 (14, 21563),
267 (14, 20573),
268 (15, 6603),
269 (15, 107),
270 (15, 81),
271 (15, 20574),
272 (15, 33697),
273 (15, 21563),
274 (15, 20573),
275 (16, 6603),
276 (16, 107),
277 (16, 81),
278 (16, 20574),
279 (16, 33697),
280 (16, 21563),
281 (16, 20573),
282 (17, 6603),
283 (17, 107),
284 (17, 81),
285 (17, 20574),
286 (17, 33697),
287 (17, 21563),
288 (17, 20573),
289 (18, 6603),
290 (18, 107),
291 (18, 81),
292 (18, 20574),
293 (18, 33697),
294 (18, 21563),
295 (18, 20573),
296 (19, 6603),
297 (19, 107),
298 (19, 81),
299 (19, 20574),
300 (19, 33697),
301 (19, 21563),
302 (19, 20573),
303 (20, 6603),
304 (20, 107),
305 (20, 81),
306 (20, 20574),
307 (20, 33697),
308 (20, 21563),
309 (20, 20573),
310 (21, 6603),
311 (21, 107),
312 (21, 81),
313 (21, 20574),
314 (21, 33697),
315 (21, 21563),
316 (21, 20573),
317 (22, 6603),
318 (22, 107),
319 (22, 81),
320 (22, 20574),
321 (22, 33697),
322 (22, 21563),
323 (22, 20573),
324 (23, 6603),
325 (23, 107),
326 (23, 81),
327 (23, 2481),
328 (23, 20596),
329 (23, 20595),
330 (23, 59224),
331 (23, 20594),
332 (24, 6603),
333 (24, 107),
334 (24, 81),
335 (24, 2481),
336 (24, 20596),
337 (24, 20595),
338 (24, 59224),
339 (24, 20594),
340 (25, 6603),
341 (25, 107),
342 (25, 81),
343 (25, 2481),
344 (25, 20596),
345 (25, 20595),
346 (25, 59224),
347 (25, 20594),
348 (26, 6603),
349 (26, 107),
350 (26, 81),
351 (26, 2481),
352 (26, 20596),
353 (26, 20595),
354 (26, 59224),
355 (26, 20594),
356 (27, 6603),
357 (27, 107),
358 (27, 81),
359 (27, 2481),
360 (27, 20596),
361 (27, 20595),
362 (27, 59224),
363 (27, 20594),
364 (28, 6603),
365 (28, 107),
366 (28, 81),
367 (28, 2481),
368 (28, 20596),
369 (28, 20595),
370 (28, 59224),
371 (28, 20594),
372 (29, 6603),
373 (29, 107),
374 (29, 81),
375 (29, 2481),
376 (29, 20596),
377 (29, 20595),
378 (29, 59224),
379 (29, 20594),
380 (30, 6603),
381 (30, 107),
382 (30, 81),
383 (30, 2481),
384 (30, 20596),
385 (30, 20595),
386 (30, 59224),
387 (30, 20594),
388 (31, 6603),
389 (31, 107),
390 (31, 81),
391 (31, 2481),
392 (31, 20596),
393 (31, 20595),
394 (31, 59224),
395 (31, 20594),
396 (32, 6603),
397 (32, 107),
398 (32, 81),
399 (32, 2481),
400 (32, 20596),
401 (32, 20595),
402 (32, 59224),
403 (32, 20594),
404 (33, 6603),
405 (33, 107),
406 (33, 81),
407 (33, 2481),
408 (33, 20596),
409 (33, 20595),
410 (33, 59224),
411 (33, 20594),
412 (34, 6603),
413 (34, 107),
414 (34, 21009),
415 (34, 4081),
416 (34, 20582),
417 (34, 58984),
418 (34, 20585),
419 (35, 6603),
420 (35, 107),
421 (35, 21009),
422 (35, 4081),
423 (35, 20582),
424 (35, 58984),
425 (35, 20585),
426 (36, 6603),
427 (36, 107),
428 (36, 21009),
429 (36, 4081),
430 (36, 20582),
431 (36, 58984),
432 (36, 20585),
433 (37, 6603),
434 (37, 107),
435 (37, 21009),
436 (37, 4081),
437 (37, 20582),
438 (37, 58984),
439 (37, 20585),
440 (38, 6603),
441 (38, 107),
442 (38, 21009),
443 (38, 4081),
444 (38, 20582),
445 (38, 58984),
446 (38, 20585),
447 (39, 6603),
448 (39, 107),
449 (39, 21009),
450 (39, 4081),
451 (39, 20582),
452 (39, 58984),
453 (39, 20585),
454 (40, 6603),
455 (40, 107),
456 (40, 21009),
457 (40, 4081),
458 (40, 20582),
459 (40, 58984),
460 (40, 20585),
461 (41, 6603),
462 (41, 107),
463 (41, 21009),
464 (41, 4081),
465 (41, 20582),
466 (41, 58984),
467 (41, 20585),
468 (42, 6603),
469 (42, 107),
470 (42, 21009),
471 (42, 4081),
472 (42, 20582),
473 (42, 58984),
474 (42, 20585),
475 (43, 6603),
476 (43, 107),
477 (43, 21009),
478 (43, 4081),
479 (43, 20582),
480 (43, 58984),
481 (43, 20585),
482 (44, 6603),
483 (44, 107),
484 (44, 21009),
485 (44, 4081),
486 (44, 20582),
487 (44, 58984),
488 (44, 20585),
489 (45, 6603),
490 (45, 81),
491 (45, 20577),
492 (45, 59535),
493 (45, 5227),
494 (45, 7744),
495 (46, 6603),
496 (46, 81),
497 (46, 20577),
498 (46, 59535),
499 (46, 5227),
500 (46, 7744),
501 (47, 6603),
502 (47, 81),
503 (47, 20577),
504 (47, 59535),
505 (47, 5227),
506 (47, 7744),
507 (48, 6603),
508 (48, 81),
509 (48, 20577),
510 (48, 59535),
511 (48, 5227),
512 (48, 7744),
513 (49, 6603),
514 (49, 81),
515 (49, 20577),
516 (49, 59535),
517 (49, 5227),
518 (49, 7744),
519 (50, 6603),
520 (50, 81),
521 (50, 20577),
522 (50, 59535),
523 (50, 5227),
524 (50, 7744),
525 (51, 6603),
526 (51, 81),
527 (51, 20577),
528 (51, 59535),
529 (51, 5227),
530 (51, 7744),
531 (52, 6603),
532 (52, 81),
533 (52, 20577),
534 (52, 59535),
535 (52, 5227),
536 (52, 7744),
537 (53, 6603),
538 (53, 81),
539 (53, 20577),
540 (53, 59535),
541 (53, 5227),
542 (53, 7744),
543 (54, 6603),
544 (54, 81),
545 (54, 20577),
546 (54, 59535),
547 (54, 5227),
548 (54, 7744),
549 (55, 6603),
550 (55, 81),
551 (55, 20577),
552 (55, 59535),
553 (55, 5227),
554 (55, 7744),
555 (56, 6603),
556 (56, 81),
557 (56, 20552),
558 (56, 20550),
559 (56, 4081),
560 (56, 46026),
561 (57, 6603),
562 (57, 81),
563 (57, 20552),
564 (57, 20550),
565 (57, 4081),
566 (57, 46026),
567 (58, 6603),
568 (58, 81),
569 (58, 20552),
570 (58, 20550),
571 (58, 4081),
572 (58, 46026),
573 (59, 6603),
574 (59, 81),
575 (59, 20552),
576 (59, 20550),
577 (59, 4081),
578 (59, 46026),
579 (60, 6603),
580 (60, 81),
581 (60, 20552),
582 (60, 20550),
583 (60, 4081),
584 (60, 46026),
585 (61, 6603),
586 (61, 81),
587 (61, 20552),
588 (61, 20550),
589 (61, 4081),
590 (61, 46026),
591 (62, 6603),
592 (62, 81),
593 (62, 20552),
594 (62, 20550),
595 (62, 4081),
596 (62, 46026),
597 (63, 6603),
598 (63, 81),
599 (63, 20552),
600 (63, 20550),
601 (63, 4081),
602 (63, 46026),
603 (64, 6603),
604 (64, 81),
605 (64, 20552),
606 (64, 20550),
607 (64, 4081),
608 (64, 46026),
609 (65, 6603),
610 (65, 81),
611 (65, 20552),
612 (65, 20550),
613 (65, 4081),
614 (65, 46026),
615 (66, 6603),
616 (66, 81),
617 (66, 20552),
618 (66, 20550),
619 (66, 4081),
620 (66, 46026),
621 (67, 6603),
622 (67, 81),
623 (67, 20592),
624 (67, 20593),
625 (67, 20589),
626 (67, 20591),
627 (68, 6603),
628 (68, 81),
629 (68, 20592),
630 (68, 20593),
631 (68, 20589),
632 (68, 20591),
633 (69, 6603),
634 (69, 81),
635 (69, 20592),
636 (69, 20593),
637 (69, 20589),
638 (69, 20591),
639 (70, 6603),
640 (70, 81),
641 (70, 20592),
642 (70, 20593),
643 (70, 20589),
644 (70, 20591),
645 (71, 6603),
646 (71, 81),
647 (71, 20592),
648 (71, 20593),
649 (71, 20589),
650 (71, 20591),
651 (72, 6603),
652 (72, 81),
653 (72, 20592),
654 (72, 20593),
655 (72, 20589),
656 (72, 20591),
657 (73, 6603),
658 (73, 81),
659 (73, 20592),
660 (73, 20593),
661 (73, 20589),
662 (73, 20591),
663 (74, 6603),
664 (74, 81),
665 (74, 20592),
666 (74, 20593),
667 (74, 20589),
668 (74, 20591),
669 (75, 6603),
670 (75, 81),
671 (75, 20592),
672 (75, 20593),
673 (75, 20589),
674 (75, 20591),
675 (76, 6603),
676 (76, 81),
677 (76, 20592),
678 (76, 20593),
679 (76, 20589),
680 (76, 20591),
681 (77, 6603),
682 (77, 81),
683 (77, 20592),
684 (77, 20593),
685 (77, 20589),
686 (77, 20591),
687 (78, 6603),
688 (78, 81),
689 (78, 107),
690 (78, 20557),
691 (78, 26290),
692 (78, 58943),
693 (78, 20555),
694 (78, 20558),
695 (79, 6603),
696 (79, 81),
697 (79, 107),
698 (79, 20557),
699 (79, 26290),
700 (79, 58943),
701 (79, 20555),
702 (79, 20558),
703 (80, 6063),
704 (80, 81),
705 (80, 107),
706 (80, 20557),
707 (80, 26290),
708 (80, 58943),
709 (80, 20555),
710 (80, 20558),
711 (81, 6063),
712 (81, 81),
713 (81, 107),
714 (81, 20557),
715 (81, 26290),
716 (81, 58943),
717 (81, 20555),
718 (81, 20558),
719 (82, 6063),
720 (82, 81),
721 (82, 107),
722 (82, 20557),
723 (82, 26290),
724 (82, 58943),
725 (82, 20555),
726 (82, 20558),
727 (83, 6063),
728 (83, 81),
729 (83, 107),
730 (83, 20557),
731 (83, 26290),
732 (83, 58943),
733 (78, 6603),
734 (78, 81),
735 (78, 107),
736 (78, 20557),
737 (78, 26290),
738 (78, 58943),
739 (78, 20555),
740 (78, 20558),
741 (79, 6603),
742 (79, 81),
743 (79, 107),
744 (79, 20557),
745 (79, 26290),
746 (79, 58943),
747 (79, 20555),
748 (79, 20558),
749 (80, 6063),
750 (80, 81),
751 (80, 107),
752 (80, 20557),
753 (80, 26290),
754 (80, 58943),
755 (80, 20555),
756 (80, 20558),
757 (81, 6063),
758 (81, 81),
759 (81, 107),
760 (81, 20557),
761 (81, 26290),
762 (81, 58943),
763 (81, 20555),
764 (81, 20558),
765 (82, 6063),
766 (82, 81),
767 (82, 107),
768 (82, 20557),
769 (82, 26290),
770 (82, 58943),
771 (82, 20555),
772 (82, 20558),
773 (83, 6063),
774 (83, 81),
775 (83, 107),
776 (83, 20557),
777 (83, 26290),
778 (83, 58943),
779 (78, 6603),
780 (78, 81),
781 (78, 107),
782 (78, 20557),
783 (78, 26290),
784 (78, 58943),
785 (78, 20555),
786 (78, 20558),
787 (79, 6603),
788 (79, 81),
789 (79, 107),
790 (79, 20557),
791 (79, 26290),
792 (79, 58943),
793 (79, 20555),
794 (79, 20558),
795 (80, 6063),
796 (80, 81),
797 (80, 107),
798 (80, 20557),
799 (80, 26290),
800 (80, 58943),
801 (80, 20555),
802 (80, 20558),
803 (81, 6063),
804 (81, 81),
805 (81, 107),
806 (81, 20557),
807 (81, 26290),
808 (81, 58943),
809 (81, 20555),
810 (81, 20558),
811 (82, 6063),
812 (82, 81),
813 (82, 107),
814 (82, 20557),
815 (82, 26290),
816 (82, 58943),
817 (82, 20555),
818 (82, 20558),
819 (83, 6063),
820 (83, 81),
821 (83, 107),
822 (83, 20557),
823 (83, 26290),
824 (83, 58943),
825 (83, 20555),
826 (83, 20558),
827 (84, 6063),
828 (84, 81),
829 (84, 107),
830 (84, 20557),
831 (84, 26290),
832 (84, 58943),
833 (84, 20555),
834 (84, 20558),
835 (85, 6063),
836 (85, 81),
837 (85, 107),
838 (85, 20557),
839 (85, 26290),
840 (85, 58943),
841 (85, 20555),
842 (85, 20558),
843 (86, 6063),
844 (86, 81),
845 (86, 107),
846 (86, 20557),
847 (86, 26290),
848 (86, 58943),
849 (86, 20555),
850 (86, 20558),
851 (87, 6063),
852 (87, 81),
853 (87, 107),
854 (87, 20557),
855 (87, 26290),
856 (87, 58943),
857 (87, 20555),
858 (87, 20558),
859 (88, 6063),
860 (88, 81),
861 (88, 107),
862 (88, 20557),
863 (88, 26290),
864 (88, 58943),
865 (88, 20555),
866 (88, 20558),
867 (89, 6603),
868 (89, 92),
869 (89, 65535),
870 (89, 59547),
871 (89, 6562),
872 (89, 59535),
873 (90, 6603),
874 (90, 92),
875 (90, 65535),
876 (90, 59547),
877 (90, 6562),
878 (90, 59535),
879 (91, 6603),
880 (91, 92),
881 (91, 65535),
882 (91, 59547),
883 (91, 6562),
884 (91, 59535),
885 (92, 6603),
886 (92, 92),
887 (92, 65535),
888 (92, 59547),
889 (92, 6562),
890 (92, 59535),
891 (93, 6603),
892 (93, 92),
893 (93, 65535),
894 (93, 59547),
895 (93, 6562),
896 (93, 59535),
897 (94, 6603),
898 (94, 92),
899 (94, 65535),
900 (94, 59547),
901 (94, 6562),
902 (94, 59535),
903 (95, 6603),
904 (95, 92),
905 (95, 65535),
906 (95, 59547),
907 (95, 6562),
908 (95, 59535),
909 (96, 6603),
910 (96, 92),
911 (96, 65535),
912 (96, 59547),
913 (96, 6562),
914 (96, 59535),
915 (97, 6603),
916 (97, 92),
917 (97, 65535),
918 (97, 59547),
919 (97, 6562),
920 (97, 59535),
921 (98, 6603),
922 (98, 92),
923 (98, 65535),
924 (98, 59547),
925 (98, 6562),
926 (98, 59535),
927 (99, 6603),
928 (99, 92),
929 (99, 65535),
930 (99, 59547),
931 (99, 6562),
932 (99, 59535),
933 (100, 6603),
934 (100, 92),
935 (100, 28877),
936 (100, 50613),
937 (100, 822),
938 (101, 6603),
939 (101, 92),
940 (101, 28877),
941 (101, 50613),
942 (101, 822),
943 (102, 6603),
944 (102, 92),
945 (102, 28877),
946 (102, 50613),
947 (102, 822),
948 (103, 6603),
949 (103, 92),
950 (103, 28877),
951 (103, 50613),
952 (103, 822),
953 (104, 6603),
954 (104, 92),
955 (104, 28877),
956 (104, 50613),
957 (104, 822),
958 (105, 6603),
959 (105, 92),
960 (105, 28877),
961 (105, 50613),
962 (105, 822),
963 (106, 6603),
964 (106, 92),
965 (106, 28877),
966 (106, 50613),
967 (106, 822),
968 (107, 6603),
969 (107, 92),
970 (107, 28877),
971 (107, 50613),
972 (107, 822),
973 (108, 6603),
974 (108, 92),
975 (108, 28877),
976 (108, 50613),
977 (108, 822),
978 (109, 6603),
979 (109, 92),
980 (109, 28877),
981 (109, 50613),
982 (109, 822),
983 (110, 6603),
984 (110, 92),
985 (110, 28877),
986 (110, 50613),
987 (110, 822);