· 8 years ago · May 14, 2018, 09:32 AM
1
2DROP TABLE IF EXISTS `playercreateinfo`;
3CREATE TABLE `playercreateinfo` (
4 `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
5 `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
6 `map` smallint(5) unsigned NOT NULL DEFAULT '0',
7 `zone` mediumint(8) unsigned NOT NULL DEFAULT '0',
8 `position_x` float NOT NULL DEFAULT '0',
9 `position_y` float NOT NULL DEFAULT '0',
10 `position_z` float NOT NULL DEFAULT '0',
11 `orientation` float NOT NULL DEFAULT '0',
12 PRIMARY KEY (`race`,`class`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;
14
15
16INSERT INTO `playercreateinfo` VALUES ('1', '1', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
17INSERT INTO `playercreateinfo` VALUES ('1', '2', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
18INSERT INTO `playercreateinfo` VALUES ('1', '4', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
19INSERT INTO `playercreateinfo` VALUES ('1', '5', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
20INSERT INTO `playercreateinfo` VALUES ('1', '8', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
21INSERT INTO `playercreateinfo` VALUES ('1', '9', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
22INSERT INTO `playercreateinfo` VALUES ('2', '1', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
23INSERT INTO `playercreateinfo` VALUES ('2', '3', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
24INSERT INTO `playercreateinfo` VALUES ('2', '4', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
25INSERT INTO `playercreateinfo` VALUES ('2', '7', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
26INSERT INTO `playercreateinfo` VALUES ('2', '9', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
27INSERT INTO `playercreateinfo` VALUES ('3', '1', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
28INSERT INTO `playercreateinfo` VALUES ('3', '2', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
29INSERT INTO `playercreateinfo` VALUES ('3', '3', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
30INSERT INTO `playercreateinfo` VALUES ('3', '4', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
31INSERT INTO `playercreateinfo` VALUES ('3', '5', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
32INSERT INTO `playercreateinfo` VALUES ('4', '1', '1', '141', '16233.6', '16402.7', '-64.3', '3.1379');
33INSERT INTO `playercreateinfo` VALUES ('4', '3', '1', '141', '16233.6', '16402.7', '-64.3', '3.1379');
34INSERT INTO `playercreateinfo` VALUES ('4', '4', '1', '141', '16233.6', '16402.7', '-64.3', '3.1379');
35INSERT INTO `playercreateinfo` VALUES ('4', '5', '1', '141', '16233.6', '16402.7', '-64.3', '3.1379');
36INSERT INTO `playercreateinfo` VALUES ('4', '11', '1', '141', '16233.6', '16402.7', '-64.3', '3.1379');
37INSERT INTO `playercreateinfo` VALUES ('5', '1', '1', '85', '16233.6', '16402.7', '-64.3', '3.1379');
38INSERT INTO `playercreateinfo` VALUES ('5', '4', '1', '85', '16233.6', '16402.7', '-64.3', '3.1379');
39INSERT INTO `playercreateinfo` VALUES ('5', '5', '1', '85', '16233.6', '16402.7', '-64.3', '3.1379');
40INSERT INTO `playercreateinfo` VALUES ('5', '8', '1', '85', '16233.6', '16402.7', '-64.3', '3.1379');
41INSERT INTO `playercreateinfo` VALUES ('5', '9', '1', '85', '16233.6', '16402.7', '-64.3', '3.1379');
42INSERT INTO `playercreateinfo` VALUES ('6', '1', '1', '215', '16233.6', '16402.7', '-64.3', '3.1379');
43INSERT INTO `playercreateinfo` VALUES ('6', '3', '1', '215', '16233.6', '16402.7', '-64.3', '3.1379');
44INSERT INTO `playercreateinfo` VALUES ('6', '7', '1', '215', '16233.6', '16402.7', '-64.3', '3.1379');
45INSERT INTO `playercreateinfo` VALUES ('6', '11', '1', '215', '16233.6', '16402.7', '-64.3', '3.1379');
46INSERT INTO `playercreateinfo` VALUES ('7', '1', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
47INSERT INTO `playercreateinfo` VALUES ('7', '9', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
48INSERT INTO `playercreateinfo` VALUES ('7', '8', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
49INSERT INTO `playercreateinfo` VALUES ('7', '4', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
50INSERT INTO `playercreateinfo` VALUES ('8', '1', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
51INSERT INTO `playercreateinfo` VALUES ('8', '3', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
52INSERT INTO `playercreateinfo` VALUES ('8', '4', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
53INSERT INTO `playercreateinfo` VALUES ('8', '5', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
54INSERT INTO `playercreateinfo` VALUES ('8', '7', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
55INSERT INTO `playercreateinfo` VALUES ('8', '8', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
56INSERT INTO `playercreateinfo` VALUES ('10', '2', '1', '3431', '16233.6', '16402.7', '-64.3', '3.1379');
57INSERT INTO `playercreateinfo` VALUES ('10', '3', '1', '3431', '16233.6', '16402.7', '-64.3', '3.1379');
58INSERT INTO `playercreateinfo` VALUES ('10', '4', '1', '3431', '16233.6', '16402.7', '-64.3', '3.1379');
59INSERT INTO `playercreateinfo` VALUES ('10', '5', '1', '3431', '16233.6', '16402.7', '-64.3', '3.1379');
60INSERT INTO `playercreateinfo` VALUES ('10', '8', '1', '3431', '16233.6', '16402.7', '-64.3', '3.1379');
61INSERT INTO `playercreateinfo` VALUES ('10', '9', '1', '3431', '16233.6', '16402.7', '-64.3', '3.1379');
62INSERT INTO `playercreateinfo` VALUES ('11', '1', '1', '3526', '16233.6', '16402.7', '-64.3', '3.1379');
63INSERT INTO `playercreateinfo` VALUES ('11', '2', '1', '3526', '16233.6', '16402.7', '-64.3', '3.1379');
64INSERT INTO `playercreateinfo` VALUES ('11', '3', '1', '3526', '16233.6', '16402.7', '-64.3', '3.1379');
65INSERT INTO `playercreateinfo` VALUES ('11', '5', '1', '3526', '16233.6', '16402.7', '-64.3', '3.1379');
66INSERT INTO `playercreateinfo` VALUES ('11', '7', '1', '3526', '16233.6', '16402.7', '-64.3', '3.1379');
67INSERT INTO `playercreateinfo` VALUES ('11', '8', '1', '3526', '16233.6', '16402.7', '-64.3', '3.1379');
68INSERT INTO `playercreateinfo` VALUES ('1', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
69INSERT INTO `playercreateinfo` VALUES ('2', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
70INSERT INTO `playercreateinfo` VALUES ('3', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
71INSERT INTO `playercreateinfo` VALUES ('4', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
72INSERT INTO `playercreateinfo` VALUES ('5', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
73INSERT INTO `playercreateinfo` VALUES ('6', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
74INSERT INTO `playercreateinfo` VALUES ('7', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
75INSERT INTO `playercreateinfo` VALUES ('8', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
76INSERT INTO `playercreateinfo` VALUES ('10', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
77INSERT INTO `playercreateinfo` VALUES ('11', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
78INSERT INTO `playercreateinfo` VALUES ('10', '1', '1', '3431', '16233.6', '16402.7', '-64.3', '3.1379');
79INSERT INTO `playercreateinfo` VALUES ('3', '8', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
80INSERT INTO `playercreateinfo` VALUES ('3', '7', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
81INSERT INTO `playercreateinfo` VALUES ('3', '9', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
82INSERT INTO `playercreateinfo` VALUES ('7', '5', '1', '1', '16233.6', '16402.7', '-64.3', '3.1379');
83INSERT INTO `playercreateinfo` VALUES ('9', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
84INSERT INTO `playercreateinfo` VALUES ('9', '3', '1', '4737', '16233.6', '16402.7', '-64.3', '3.1379');
85INSERT INTO `playercreateinfo` VALUES ('9', '8', '1', '4737', '16233.6', '16402.7', '-64.3', '3.1379');
86INSERT INTO `playercreateinfo` VALUES ('9', '5', '1', '4737', '16233.6', '16402.7', '-64.3', '3.1379');
87INSERT INTO `playercreateinfo` VALUES ('9', '4', '1', '4737', '16233.6', '16402.7', '-64.3', '3.1379');
88INSERT INTO `playercreateinfo` VALUES ('9', '7', '1', '4737', '16233.6', '16402.7', '-64.3', '3.1379');
89INSERT INTO `playercreateinfo` VALUES ('9', '1', '1', '4737', '16233.6', '16402.7', '-64.3', '3.1379');
90INSERT INTO `playercreateinfo` VALUES ('9', '9', '1', '4737', '16233.6', '16402.7', '-64.3', '3.1379');
91INSERT INTO `playercreateinfo` VALUES ('1', '3', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
92INSERT INTO `playercreateinfo` VALUES ('4', '8', '1', '141', '16233.6', '16402.7', '-64.3', '3.1379');
93INSERT INTO `playercreateinfo` VALUES ('2', '8', '1', '12', '16233.6', '16402.7', '-64.3', '3.1379');
94INSERT INTO `playercreateinfo` VALUES ('6', '2', '1', '215', '16233.6', '16402.7', '-64.3', '3.1379');
95INSERT INTO `playercreateinfo` VALUES ('6', '5', '1', '215', '16233.6', '16402.7', '-64.3', '3.1379');
96INSERT INTO `playercreateinfo` VALUES ('8', '11', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
97INSERT INTO `playercreateinfo` VALUES ('8', '9', '1', '14', '16233.6', '16402.7', '-64.3', '3.1379');
98INSERT INTO `playercreateinfo` VALUES ('5', '3', '1', '85', '16233.6', '16402.7', '-64.3', '3.1379');
99INSERT INTO `playercreateinfo` VALUES ('22', '6', '609', '4298', '2460.71', '-5598.05', '551', '2.04204');
100INSERT INTO `playercreateinfo` VALUES ('22', '11', '1', '4714', '16233.6', '16402.7', '-64.3', '3.1379');
101INSERT INTO `playercreateinfo` VALUES ('22', '3', '1', '4714', '16233.6', '16402.7', '-64.3', '3.1379');
102INSERT INTO `playercreateinfo` VALUES ('22', '8', '1', '4714', '16233.6', '16402.7', '-64.3', '3.1379');
103INSERT INTO `playercreateinfo` VALUES ('22', '5', '1', '4714', '16233.6', '16402.7', '-64.3', '3.1379');
104INSERT INTO `playercreateinfo` VALUES ('22', '4', '1', '4714', '16233.6', '16402.7', '-64.3', '3.1379');
105INSERT INTO `playercreateinfo` VALUES ('22', '1', '1', '4714', '16233.6', '16402.7', '-64.3', '3.1379');
106INSERT INTO `playercreateinfo` VALUES ('22', '9', '1', '4714', '16233.6', '16402.7', '-64.3', '3.1379');