Advertisement
cressidagp

arcmercs_db

Dec 30th, 2024
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 14.54 KB | None | 0 0
  1. DROP DATABASE IF EXISTS `arcmercs`;
  2. CREATE DATABASE IF NOT EXISTS `arcmercs` /*!40100 DEFAULT CHARACTER SET latin1 */;
  3. USE `arcmercs`;
  4.  
  5. CREATE 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.  
  19. CREATE 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.  
  31. CREATE 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.  
  44. CREATE 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.  
  59. insert  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.  
  97. DELETE FROM `spells` WHERE entry != 0;
  98.  
  99. INSERT 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.  
  167. delete from weapons where entry != 0;
  168.  
  169. insert  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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement