gP7LiYME

1DROP DATABASE IF EXISTS `arcmercs`;
2CREATE DATABASE IF NOT EXISTS `arcmercs` /*!40100 DEFAULT CHARACTER SET latin1 */;
3USE `arcmercs`;
4
5CREATE TABLE `mercenaries` (
6  `ownerGuid` int(6) unsigned NOT NULL DEFAULT '0',
7  `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0',
8  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
9  `entry` int(6) unsigned NOT NULL DEFAULT '0',
10  `display` int(6) unsigned NOT NULL DEFAULT '0',
11  `angle` float unsigned NOT NULL,
12  `stance` tinyint(3) unsigned NOT NULL DEFAULT '1',
13  `mercGuid` varchar(21) NOT NULL DEFAULT '',
14  `ownerName` varchar(21) NOT NULL DEFAULT '',
15  `type` varchar(21) NOT NULL DEFAULT '',
16  PRIMARY KEY (`ownerguid`, `groupId`, `id`)
17) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
18
19CREATE TABLE `gossip_display` (
20  `entry` int(6) unsigned NOT NULL DEFAULT '0',
21  `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0',
22  `team` tinyint(3) unsigned NOT NULL DEFAULT '0',
23  `optionName` varchar(21) NOT NULL DEFAULT '',
24  `optionId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
25  `display` int(6) unsigned NOT NULL DEFAULT '0',
26  `teamName` varchar(21) NOT NULL DEFAULT '',
27  `type` varchar(21) NOT NULL DEFAULT '',
28  PRIMARY KEY (`entry`, `groupId`, `team`, `optionId`)
29) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
30
31CREATE TABLE `spells` (
32  `entry` int(6) unsigned NOT NULL DEFAULT '0',
33  `stance` tinyint(3) unsigned NOT NULL DEFAULT '0',
34  `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
35  `spellId` int(6) unsigned NOT NULL DEFAULT '0',
36  `rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
37  `minlv` tinyint(3) unsigned NOT NULL DEFAULT '0',
38  `maxlv` tinyint(3) unsigned NOT NULL DEFAULT '0',
39  `target` tinyint(3) unsigned NOT NULL DEFAULT '0',
40  `spName` varchar(21) NOT NULL DEFAULT '',
41  PRIMARY KEY (`entry`, `stance`, `slot`, `spellId`, `rank`)
42) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
43
44CREATE TABLE `weapons` (
45  `entry` int(6) unsigned NOT NULL DEFAULT '0',
46  `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0',
47  `team` tinyint(3) unsigned NOT NULL DEFAULT '0',
48  `display` int(6) unsigned NOT NULL DEFAULT '0',
49  `stance` tinyint(3) unsigned NOT NULL DEFAULT '0',
50  `slot1` int(6) unsigned NOT NULL DEFAULT '0',
51  `slot2` int(6) unsigned NOT NULL DEFAULT '0',
52  `slot3` int(6) unsigned NOT NULL DEFAULT '0',
53  `teamName` varchar(21) NOT NULL DEFAULT '',
54  `raceName` varchar(21) NOT NULL DEFAULT '',
55  `type` varchar(21) NOT NULL DEFAULT '',
56  PRIMARY KEY (`entry`, `groupId`, `team`, `display`, `stance`)
57) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
58
59insert  into `gossip_display`(`entry`,`groupId`,`team`,`optionName`,`optionId`,`display`,`teamName`,`type`) values 
60(43284,1,0,'Human Male I',17,3167,'Alliance','Soldier'),
61(43284,1,0,'Human Female I',18,5446,'Alliance','Soldier'),
62(43284,1,0,'Dwarf Male I',19,3524,'Alliance','Soldier'),
63(43284,1,0,'Dwarf Male II',20,3525,'Alliance','Soldier'),
64(43284,1,0,'Dwarf Male III',21,3526,'Alliance','Soldier'),
65(43284,1,0,'Dwarf Male IV',22,3527,'Alliance','Soldier'),
66(43284,1,0,'Gnome Male I',23,31654,'Alliance','Soldier'),
67(43284,1,0,'Gnome Male II',24,31656,'Alliance','Soldier'),
68(43284,1,0,'Gnome Female I',25,31681,'Alliance','Soldier'),
69(43284,1,0,'Gnome Female II',26,31655,'Alliance','Soldier'),
70(43284,1,0,'Nightelf Female I',27,2306,'Alliance','Soldier'),
71(43284,1,0,'Nightelf Female II',28,14613,'Alliance','Soldier'),
72(43284,1,0,'Nightelf Female III',29,14614,'Alliance','Soldier'),
73(43284,1,0,'Nightelf Female IV',30,14615,'Alliance','Soldier'),
74(43284,1,0,'Draenei Male I',31,17372,'Alliance','Soldier'),
75(43284,1,0,'Draenei Male II',32,17373,'Alliance','Soldier'),
76(43284,1,0,'Draenei Female I',33,17374,'Alliance','Soldier'),
77(43284,1,0,'Draenei Female II',34,17375,'Alliance','Soldier'),
78(43285,1,1,'Orc Male I',17,4259,'Horde','Soldier'),
79(43285,1,1,'Orc Female I',18,4260,'Horde','Soldier'),
80(43285,1,1,'Orc Male II',19,4602,'Horde','Soldier'),
81(43285,1,1,'Orc Female II',20,4601,'Horde','Soldier'),
82(43285,1,1,'Undead Male I',21,2854,'Horde','Soldier'),
83(43285,1,1,'Undead Male II',22,1666,'Horde','Soldier'),
84(43285,1,1,'Undead Male III',23,2859,'Horde','Soldier'),
85(43285,1,1,'Undead Male IV',24,2853,'Horde','Soldier'),
86(43285,1,1,'Tauren Male I',25,2141,'Horde','Soldier'),
87(43285,1,1,'Tauren Male II',27,9391,'Horde','Soldier'),
88(43285,1,1,'Tauren Female I',26,8572,'Horde','Soldier'),
89(43285,1,1,'Tauren Female II',28,9392,'Horde','Soldier'),
90(43285,1,1,'Troll Male',29,4083,'Horde','Soldier'),
91(43285,1,1,'Troll Female',30,4084,'Horde','Soldier'),
92(43285,1,1,'Bloodelf Male I',31,15936,'Horde','Soldier'),
93(43285,1,1,'Bloodelf Male II',32,17264,'Horde','Soldier'),
94(43285,1,1,'Bloodelf Female I',33,17266,'Horde','Soldier'),
95(43285,1,1,'Bloodelf Female II',34,17265,'Horde','Soldier');
96
97DELETE FROM `spells` WHERE entry != 0;
98
99INSERT INTO `spells`(`entry`,`stance`,`slot`,`spellId`,`rank`,`minlv`,`maxlv`,`target`,`spName`) VALUES
100(43284,1,1,6343,1,15,17,0,'Thunder Clap'),
101(43284,1,1,8198,2,18,27,0,'Thunder Clap'),
102(43284,1,1,8204,3,28,37,0,'Thunder Clap'),
103(43284,1,1,8205,4,38,47,0,'Thunder Clap'),
104(43284,1,1,11580,5,48,57,0,'Thunder Clap'),
105(43284,1,1,11581,6,58,67,0,'Thunder Clap'),
106(43284,1,1,25264,7,68,72,0,'Thunder Clap'),
107(43284,1,1,47501,8,73,77,0,'Thunder Clap'),
108(43284,1,1,47502,9,78,81,0,'Thunder Clap'),
109(43284,1,2,485,1,15,29,0,'Cleave'),
110(43284,1,2,7369,2,30,39,0,'Cleave'),
111(43284,1,2,11608,3,40,49,0,'Cleave'),
112(43284,1,2,11609,4,50,59,0,'Cleave'),
113(43284,1,2,20569,5,60,67,0,'Cleave'),
114(43284,1,2,25231,6,68,71,0,'Cleave'),
115(43284,1,2,47519,7,72,76,0,'Cleave'),
116(43284,1,2,47520,8,77,81,0,'Cleave'),
117(43284,1,3,1160,1,15,23,0,'Demoralizing Shout'),
118(43284,1,3,6190,2,24,33,0,'Demoralizing Shout'),
119(43284,1,3,11554,3,34,43,0,'Demoralizing Shout'),
120(43284,1,3,11555,4,44,53,0,'Demoralizing Shout'),
121(43284,1,3,11556,5,54,61,0,'Demoralizing Shout'),
122(43284,1,3,25202,6,62,69,0,'Demoralizing Shout'),
123(43284,1,3,25203,7,70,78,0,'Demoralizing Shout'),
124(43284,1,3,47437,8,79,81,0,'Demoralizing Shout'),
125(43284,1,4,12294,1,40,47,1,'Mortal Strike'),
126(43284,1,4,21551,2,48,53,1,'Mortal Strike'),
127(43284,1,4,21552,3,54,59,1,'Mortal Strike'),
128(43284,1,4,21553,4,60,65,1,'Mortal Strike'),
129(43284,1,4,25248,5,66,69,1,'Mortal Strike'),
130(43284,1,4,30330,6,70,74,1,'Mortal Strike'),
131(43284,1,4,47485,7,75,78,1,'Mortal Strike'),
132(43284,1,4,47486,8,79,81,1,'Mortal Strike'),
133(43285,1,1,6343,1,15,17,0,'Thunder Clap'),
134(43285,1,1,8198,2,18,27,0,'Thunder Clap'),
135(43285,1,1,8204,3,28,37,0,'Thunder Clap'),
136(43285,1,1,8205,4,38,47,0,'Thunder Clap'),
137(43285,1,1,11580,5,48,57,0,'Thunder Clap'),
138(43285,1,1,11581,6,58,67,0,'Thunder Clap'),
139(43285,1,1,25264,7,68,72,0,'Thunder Clap'),
140(43285,1,1,47501,8,73,77,0,'Thunder Clap'),
141(43285,1,1,47502,9,78,81,0,'Thunder Clap'),
142(43285,1,2,485,1,15,29,0,'Cleave'),
143(43285,1,2,7369,2,30,39,0,'Cleave'),
144(43285,1,2,11608,3,40,49,0,'Cleave'),
145(43285,1,2,11609,4,50,59,0,'Cleave'),
146(43285,1,2,20569,5,60,67,0,'Cleave'),
147(43285,1,2,25231,6,68,71,0,'Cleave'),
148(43285,1,2,47519,7,72,76,0,'Cleave'),
149(43285,1,2,47520,8,77,81,0,'Cleave'),
150(43285,1,3,1160,1,15,23,0,'Demoralizing Shout'),
151(43285,1,3,6190,2,24,33,0,'Demoralizing Shout'),
152(43285,1,3,11554,3,34,43,0,'Demoralizing Shout'),
153(43285,1,3,11555,4,44,53,0,'Demoralizing Shout'),
154(43285,1,3,11556,5,54,61,0,'Demoralizing Shout'),
155(43285,1,3,25202,6,62,69,0,'Demoralizing Shout'),
156(43285,1,3,25203,7,70,78,0,'Demoralizing Shout'),
157(43285,1,3,47437,8,79,81,0,'Demoralizing Shout'),
158(43285,1,4,12294,1,40,47,1,'Mortal Strike'),
159(43285,1,4,21551,2,48,53,1,'Mortal Strike'),
160(43285,1,4,21552,3,54,59,1,'Mortal Strike'),
161(43285,1,4,21553,4,60,65,1,'Mortal Strike'),
162(43285,1,4,25248,5,66,69,1,'Mortal Strike'),
163(43285,1,4,30330,6,70,74,1,'Mortal Strike'),
164(43285,1,4,47485,7,75,78,1,'Mortal Strike'),
165(43285,1,4,47486,8,79,81,1,'Mortal Strike');
166
167delete from weapons where entry != 0;
168
169insert  into `weapons`(`entry`,`groupId`,`team`,`display`,`stance`,`slot1`,`slot2`,`slot3`,`teamName`,`raceName`,`type`) values 
170(43284,1,0,3167,1,49778,1,1,'Alliance','Human','Soldier'),
171(43284,1,0,3167,2,1899,143,1,'Alliance','Human','Soldier'),
172(43284,1,0,3167,3,1899,1899,1,'Alliance','Human','Soldier'),
173(43284,1,0,5446,1,49778,1,1,'Alliance','Human','Soldier'),
174(43284,1,0,5446,2,1899,143,1,'Alliance','Human','Soldier'),
175(43284,1,0,5446,3,1899,1899,1,'Alliance','Human','Soldier'),
176(43284,1,0,31654,1,53056,1,1,'Alliance','Gnome','Soldier'),
177(43284,1,0,31654,2,53056,11585,1,'Alliance','Gnome','Soldier'),
178(43284,1,0,31654,3,53056,53056,1,'Alliance','Gnome','Soldier'),
179(43284,1,0,31656,1,53056,1,1,'Alliance','Gnome','Soldier'),
180(43284,1,0,31656,2,53056,11585,1,'Alliance','Gnome','Soldier'),
181(43284,1,0,31656,3,53056,53056,1,'Alliance','Gnome','Soldier'),
182(43284,1,0,31681,1,53056,1,1,'Alliance','Gnome','Soldier'),
183(43284,1,0,31681,2,53056,11585,1,'Alliance','Gnome','Soldier'),
184(43284,1,0,31681,3,53056,53056,1,'Alliance','Gnome','Soldier'),
185(43284,1,0,31655,1,53056,1,1,'Alliance','Gnome','Soldier'),
186(43284,1,0,31655,2,53056,11585,1,'Alliance','Gnome','Soldier'),
187(43284,1,0,31655,3,53056,53056,1,'Alliance','Gnome','Soldier'),
188(43284,1,0,3524,1,2483,1,0,'Alliance','Dwarf','Soldier'),
189(43284,1,0,3524,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
190(43284,1,0,3524,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
191(43284,1,0,3525,1,2483,1,0,'Alliance','Dwarf','Soldier'),
192(43284,1,0,3525,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
193(43284,1,0,3525,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
194(43284,1,0,3526,1,2483,1,0,'Alliance','Dwarf','Soldier'),
195(43284,1,0,3526,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
196(43284,1,0,3526,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
197(43284,1,0,3527,1,2483,1,0,'Alliance','Dwarf','Soldier'),
198(43284,1,0,3527,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
199(43284,1,0,3527,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
200(43284,1,0,2306,1,49778,1,0,'Alliance','Night Elf','Soldier'),
201(43284,1,0,2306,2,5599,1,0,'Alliance','Night Elf','Soldier'),
202(43284,1,0,2306,3,5598,1,0,'Alliance','Night Elf','Soldier'),
203(43284,1,0,14613,1,49778,1,0,'Alliance','Night Elf','Soldier'),
204(43284,1,0,14613,2,5599,1,0,'Alliance','Night Elf','Soldier'),
205(43284,1,0,14613,3,5598,1,0,'Alliance','Night Elf','Soldier'),
206(43284,1,0,14614,1,49778,1,0,'Alliance','Night Elf','Soldier'),
207(43284,1,0,14614,2,5599,1,0,'Alliance','Night Elf','Soldier'),
208(43284,1,0,14614,3,5598,5286,0,'Alliance','Night Elf','Soldier'),
209(43284,1,0,14615,1,49778,1,0,'Alliance','Night Elf','Soldier'),
210(43284,1,0,14615,2,5599,1,0,'Alliance','Night Elf','Soldier'),
211(43284,1,0,14615,3,5598,1,0,'Alliance','Night Elf','Soldier'),
212(43284,1,0,17372,1,24332,0,0,'Alliance','Draenei','Soldier'),
213(43284,1,0,17372,2,24332,24331,0,'Alliance','Draenei','Soldier'),
214(43284,1,0,17372,3,24332,24332,0,'Alliance','Draenei','Soldier'),
215(43284,1,0,17373,1,24332,0,0,'Alliance','Draenei','Soldier'),
216(43284,1,0,17373,2,24332,24331,0,'Alliance','Draenei','Soldier'),
217(43284,1,0,17373,3,24332,24332,0,'Alliance','Draenei','Soldier'),
218(43284,1,0,17374,1,24332,0,0,'Alliance','Draenei','Soldier'),
219(43284,1,0,17374,2,24332,24331,0,'Alliance','Draenei','Soldier'),
220(43284,1,0,17374,3,24332,24332,0,'Alliance','Draenei','Soldier'),
221(43284,1,0,17375,1,24332,0,0,'Alliance','Draenei','Soldier'),
222(43284,1,0,17375,2,24332,24331,0,'Alliance','Draenei','Soldier'),
223(43284,1,0,17375,3,24332,24332,0,'Alliance','Draenei','Soldier'),
224(43284,1,1,4259,1,5289,1,1,'Horde','Orc','Soldier'),
225(43284,1,1,4259,2,10612,1961,1,'Horde','Orc','Soldier'),
226(43284,1,1,4259,3,10612,10612,1,'Horde','Orc','Soldier'),
227(43284,1,1,4260,1,5289,1,1,'Horde','Orc','Soldier'),
228(43284,1,1,4260,2,10612,1961,1,'Horde','Orc','Soldier'),
229(43284,1,1,4260,3,10612,10612,1,'Horde','Orc','Soldier'),
230(43284,1,1,4602,1,5289,1,1,'Horde','Orc','Soldier'),
231(43284,1,1,4602,2,10612,1961,1,'Horde','Orc','Soldier'),
232(43284,1,1,4602,3,10612,10612,1,'Horde','Orc','Soldier'),
233(43284,1,1,4601,1,5289,1,1,'Horde','Orc','Soldier'),
234(43284,1,1,4601,2,10612,1961,1,'Horde','Orc','Soldier'),
235(43284,1,1,4601,3,10612,10612,1,'Horde','Orc','Soldier'),
236(43284,1,1,2141,1,12754,1,1,'Horde','Tauren','Soldier'),
237(43284,1,1,2141,2,18596,1961,1,'Horde','Tauren','Soldier'),
238(43284,1,1,2141,3,18596,18596,1,'Horde','Tauren','Soldier'),
239(43284,1,1,9391,1,12754,1,1,'Horde','Tauren','Soldier'),
240(43284,1,1,9391,2,18596,1961,1,'Horde','Tauren','Soldier'),
241(43284,1,1,9391,3,18596,18596,1,'Horde','Tauren','Soldier'),
242(43284,1,1,8572,1,12754,1,1,'Horde','Tauren','Soldier'),
243(43284,1,1,8572,2,18596,1961,1,'Horde','Tauren','Soldier'),
244(43284,1,1,8572,3,18596,18596,1,'Horde','Tauren','Soldier'),
245(43284,1,1,9392,1,12754,1,1,'Horde','Tauren','Soldier'),
246(43284,1,1,9392,2,18596,1961,1,'Horde','Tauren','Soldier'),
247(43284,1,1,9392,3,18596,18596,1,'Horde','Tauren','Soldier'),
248(43284,1,1,4083,1,2023,1,1,'Horde','Troll','Soldier'),
249(43284,1,1,4083,2,1904,1961,1,'Horde','Troll','Soldier'),
250(43284,1,1,4083,3,1904,1904,1,'Horde','Troll','Soldier'),
251(43284,1,1,4084,1,2023,1,1,'Horde','Troll','Soldier'),
252(43284,1,1,4084,2,1904,1961,1,'Horde','Troll','Soldier'),
253(43284,1,1,4084,3,1904,1904,1,'Horde','Troll','Soldier'),
254(43284,1,1,2854,1,5286,1,1,'Horde','Undead','Soldier'),
255(43284,1,1,2854,2,1905,1961,1,'Horde','Undead','Soldier'),
256(43284,1,1,2854,3,1905,1905,1,'Horde','Undead','Soldier'),
257(43284,1,1,1666,1,5286,1,1,'Horde','Undead','Soldier'),
258(43284,1,1,1666,2,1905,1961,1,'Horde','Undead','Soldier'),
259(43284,1,1,1666,3,1905,1905,1,'Horde','Undead','Soldier'),
260(43284,1,1,2859,1,5286,1,1,'Horde','Undead','Soldier'),
261(43284,1,1,2859,2,1905,1961,1,'Horde','Undead','Soldier'),
262(43284,1,1,2859,3,1905,1905,1,'Horde','Undead','Soldier'),
263(43284,1,1,2853,1,5286,1,1,'Horde','Undead','Soldier'),
264(43284,1,1,2853,2,1905,1961,1,'Horde','Undead','Soldier'),
265(43284,1,1,2853,3,1905,1905,1,'Horde','Undead','Soldier'),
266(43284,1,1,15936,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
267(43284,1,1,15936,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
268(43284,1,1,15936,3,18596,1961,1,'Horde','Bloodelf','Soldier'),
269(43284,1,1,17264,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
270(43284,1,1,17264,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
271(43284,1,1,17264,3,18596,1961,1,'Horde','Bloodelf','Soldier'),
272(43284,1,1,17266,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
273(43284,1,1,17266,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
274(43284,1,1,17266,3,18596,1961,1,'Horde','Bloodelf','Soldier'),
275(43284,1,1,17265,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
276(43284,1,1,17265,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
277(43284,1,1,17265,3,18596,1961,1,'Horde','Bloodelf','Soldier');