Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP DATABASE IF EXISTS `arcmercs`;
- CREATE DATABASE IF NOT EXISTS `arcmercs` /*!40100 DEFAULT CHARACTER SET latin1 */;
- USE `arcmercs`;
- CREATE TABLE `mercenaries` (
- `ownerGuid` int(6) unsigned NOT NULL DEFAULT '0',
- `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
- `entry` int(6) unsigned NOT NULL DEFAULT '0',
- `display` int(6) unsigned NOT NULL DEFAULT '0',
- `angle` float unsigned NOT NULL,
- `stance` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `mercGuid` varchar(21) NOT NULL DEFAULT '',
- `ownerName` varchar(21) NOT NULL DEFAULT '',
- `type` varchar(21) NOT NULL DEFAULT '',
- PRIMARY KEY (`ownerguid`, `groupId`, `id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
- CREATE TABLE `gossip_display` (
- `entry` int(6) unsigned NOT NULL DEFAULT '0',
- `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `team` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `optionName` varchar(21) NOT NULL DEFAULT '',
- `optionId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
- `display` int(6) unsigned NOT NULL DEFAULT '0',
- `teamName` varchar(21) NOT NULL DEFAULT '',
- `type` varchar(21) NOT NULL DEFAULT '',
- PRIMARY KEY (`entry`, `groupId`, `team`, `optionId`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
- CREATE TABLE `spells` (
- `entry` int(6) unsigned NOT NULL DEFAULT '0',
- `stance` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `spellId` int(6) unsigned NOT NULL DEFAULT '0',
- `rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `minlv` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `maxlv` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `target` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `spName` varchar(21) NOT NULL DEFAULT '',
- PRIMARY KEY (`entry`, `stance`, `slot`, `spellId`, `rank`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
- CREATE TABLE `weapons` (
- `entry` int(6) unsigned NOT NULL DEFAULT '0',
- `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `team` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `display` int(6) unsigned NOT NULL DEFAULT '0',
- `stance` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `slot1` int(6) unsigned NOT NULL DEFAULT '0',
- `slot2` int(6) unsigned NOT NULL DEFAULT '0',
- `slot3` int(6) unsigned NOT NULL DEFAULT '0',
- `teamName` varchar(21) NOT NULL DEFAULT '',
- `raceName` varchar(21) NOT NULL DEFAULT '',
- `type` varchar(21) NOT NULL DEFAULT '',
- PRIMARY KEY (`entry`, `groupId`, `team`, `display`, `stance`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='MercSystem';
- insert into `gossip_display`(`entry`,`groupId`,`team`,`optionName`,`optionId`,`display`,`teamName`,`type`) values
- (43284,1,0,'Human Male I',17,3167,'Alliance','Soldier'),
- (43284,1,0,'Human Female I',18,5446,'Alliance','Soldier'),
- (43284,1,0,'Dwarf Male I',19,3524,'Alliance','Soldier'),
- (43284,1,0,'Dwarf Male II',20,3525,'Alliance','Soldier'),
- (43284,1,0,'Dwarf Male III',21,3526,'Alliance','Soldier'),
- (43284,1,0,'Dwarf Male IV',22,3527,'Alliance','Soldier'),
- (43284,1,0,'Gnome Male I',23,31654,'Alliance','Soldier'),
- (43284,1,0,'Gnome Male II',24,31656,'Alliance','Soldier'),
- (43284,1,0,'Gnome Female I',25,31681,'Alliance','Soldier'),
- (43284,1,0,'Gnome Female II',26,31655,'Alliance','Soldier'),
- (43284,1,0,'Nightelf Female I',27,2306,'Alliance','Soldier'),
- (43284,1,0,'Nightelf Female II',28,14613,'Alliance','Soldier'),
- (43284,1,0,'Nightelf Female III',29,14614,'Alliance','Soldier'),
- (43284,1,0,'Nightelf Female IV',30,14615,'Alliance','Soldier'),
- (43284,1,0,'Draenei Male I',31,17372,'Alliance','Soldier'),
- (43284,1,0,'Draenei Male II',32,17373,'Alliance','Soldier'),
- (43284,1,0,'Draenei Female I',33,17374,'Alliance','Soldier'),
- (43284,1,0,'Draenei Female II',34,17375,'Alliance','Soldier'),
- (43285,1,1,'Orc Male I',17,4259,'Horde','Soldier'),
- (43285,1,1,'Orc Female I',18,4260,'Horde','Soldier'),
- (43285,1,1,'Orc Male II',19,4602,'Horde','Soldier'),
- (43285,1,1,'Orc Female II',20,4601,'Horde','Soldier'),
- (43285,1,1,'Undead Male I',21,2854,'Horde','Soldier'),
- (43285,1,1,'Undead Male II',22,1666,'Horde','Soldier'),
- (43285,1,1,'Undead Male III',23,2859,'Horde','Soldier'),
- (43285,1,1,'Undead Male IV',24,2853,'Horde','Soldier'),
- (43285,1,1,'Tauren Male I',25,2141,'Horde','Soldier'),
- (43285,1,1,'Tauren Male II',27,9391,'Horde','Soldier'),
- (43285,1,1,'Tauren Female I',26,8572,'Horde','Soldier'),
- (43285,1,1,'Tauren Female II',28,9392,'Horde','Soldier'),
- (43285,1,1,'Troll Male',29,4083,'Horde','Soldier'),
- (43285,1,1,'Troll Female',30,4084,'Horde','Soldier'),
- (43285,1,1,'Bloodelf Male I',31,15936,'Horde','Soldier'),
- (43285,1,1,'Bloodelf Male II',32,17264,'Horde','Soldier'),
- (43285,1,1,'Bloodelf Female I',33,17266,'Horde','Soldier'),
- (43285,1,1,'Bloodelf Female II',34,17265,'Horde','Soldier');
- DELETE FROM `spells` WHERE entry != 0;
- INSERT INTO `spells`(`entry`,`stance`,`slot`,`spellId`,`rank`,`minlv`,`maxlv`,`target`,`spName`) VALUES
- (43284,1,1,6343,1,15,17,0,'Thunder Clap'),
- (43284,1,1,8198,2,18,27,0,'Thunder Clap'),
- (43284,1,1,8204,3,28,37,0,'Thunder Clap'),
- (43284,1,1,8205,4,38,47,0,'Thunder Clap'),
- (43284,1,1,11580,5,48,57,0,'Thunder Clap'),
- (43284,1,1,11581,6,58,67,0,'Thunder Clap'),
- (43284,1,1,25264,7,68,72,0,'Thunder Clap'),
- (43284,1,1,47501,8,73,77,0,'Thunder Clap'),
- (43284,1,1,47502,9,78,81,0,'Thunder Clap'),
- (43284,1,2,485,1,15,29,0,'Cleave'),
- (43284,1,2,7369,2,30,39,0,'Cleave'),
- (43284,1,2,11608,3,40,49,0,'Cleave'),
- (43284,1,2,11609,4,50,59,0,'Cleave'),
- (43284,1,2,20569,5,60,67,0,'Cleave'),
- (43284,1,2,25231,6,68,71,0,'Cleave'),
- (43284,1,2,47519,7,72,76,0,'Cleave'),
- (43284,1,2,47520,8,77,81,0,'Cleave'),
- (43284,1,3,1160,1,15,23,0,'Demoralizing Shout'),
- (43284,1,3,6190,2,24,33,0,'Demoralizing Shout'),
- (43284,1,3,11554,3,34,43,0,'Demoralizing Shout'),
- (43284,1,3,11555,4,44,53,0,'Demoralizing Shout'),
- (43284,1,3,11556,5,54,61,0,'Demoralizing Shout'),
- (43284,1,3,25202,6,62,69,0,'Demoralizing Shout'),
- (43284,1,3,25203,7,70,78,0,'Demoralizing Shout'),
- (43284,1,3,47437,8,79,81,0,'Demoralizing Shout'),
- (43284,1,4,12294,1,40,47,1,'Mortal Strike'),
- (43284,1,4,21551,2,48,53,1,'Mortal Strike'),
- (43284,1,4,21552,3,54,59,1,'Mortal Strike'),
- (43284,1,4,21553,4,60,65,1,'Mortal Strike'),
- (43284,1,4,25248,5,66,69,1,'Mortal Strike'),
- (43284,1,4,30330,6,70,74,1,'Mortal Strike'),
- (43284,1,4,47485,7,75,78,1,'Mortal Strike'),
- (43284,1,4,47486,8,79,81,1,'Mortal Strike'),
- (43285,1,1,6343,1,15,17,0,'Thunder Clap'),
- (43285,1,1,8198,2,18,27,0,'Thunder Clap'),
- (43285,1,1,8204,3,28,37,0,'Thunder Clap'),
- (43285,1,1,8205,4,38,47,0,'Thunder Clap'),
- (43285,1,1,11580,5,48,57,0,'Thunder Clap'),
- (43285,1,1,11581,6,58,67,0,'Thunder Clap'),
- (43285,1,1,25264,7,68,72,0,'Thunder Clap'),
- (43285,1,1,47501,8,73,77,0,'Thunder Clap'),
- (43285,1,1,47502,9,78,81,0,'Thunder Clap'),
- (43285,1,2,485,1,15,29,0,'Cleave'),
- (43285,1,2,7369,2,30,39,0,'Cleave'),
- (43285,1,2,11608,3,40,49,0,'Cleave'),
- (43285,1,2,11609,4,50,59,0,'Cleave'),
- (43285,1,2,20569,5,60,67,0,'Cleave'),
- (43285,1,2,25231,6,68,71,0,'Cleave'),
- (43285,1,2,47519,7,72,76,0,'Cleave'),
- (43285,1,2,47520,8,77,81,0,'Cleave'),
- (43285,1,3,1160,1,15,23,0,'Demoralizing Shout'),
- (43285,1,3,6190,2,24,33,0,'Demoralizing Shout'),
- (43285,1,3,11554,3,34,43,0,'Demoralizing Shout'),
- (43285,1,3,11555,4,44,53,0,'Demoralizing Shout'),
- (43285,1,3,11556,5,54,61,0,'Demoralizing Shout'),
- (43285,1,3,25202,6,62,69,0,'Demoralizing Shout'),
- (43285,1,3,25203,7,70,78,0,'Demoralizing Shout'),
- (43285,1,3,47437,8,79,81,0,'Demoralizing Shout'),
- (43285,1,4,12294,1,40,47,1,'Mortal Strike'),
- (43285,1,4,21551,2,48,53,1,'Mortal Strike'),
- (43285,1,4,21552,3,54,59,1,'Mortal Strike'),
- (43285,1,4,21553,4,60,65,1,'Mortal Strike'),
- (43285,1,4,25248,5,66,69,1,'Mortal Strike'),
- (43285,1,4,30330,6,70,74,1,'Mortal Strike'),
- (43285,1,4,47485,7,75,78,1,'Mortal Strike'),
- (43285,1,4,47486,8,79,81,1,'Mortal Strike');
- delete from weapons where entry != 0;
- insert into `weapons`(`entry`,`groupId`,`team`,`display`,`stance`,`slot1`,`slot2`,`slot3`,`teamName`,`raceName`,`type`) values
- (43284,1,0,3167,1,49778,1,1,'Alliance','Human','Soldier'),
- (43284,1,0,3167,2,1899,143,1,'Alliance','Human','Soldier'),
- (43284,1,0,3167,3,1899,1899,1,'Alliance','Human','Soldier'),
- (43284,1,0,5446,1,49778,1,1,'Alliance','Human','Soldier'),
- (43284,1,0,5446,2,1899,143,1,'Alliance','Human','Soldier'),
- (43284,1,0,5446,3,1899,1899,1,'Alliance','Human','Soldier'),
- (43284,1,0,31654,1,53056,1,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31654,2,53056,11585,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31654,3,53056,53056,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31656,1,53056,1,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31656,2,53056,11585,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31656,3,53056,53056,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31681,1,53056,1,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31681,2,53056,11585,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31681,3,53056,53056,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31655,1,53056,1,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31655,2,53056,11585,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,31655,3,53056,53056,1,'Alliance','Gnome','Soldier'),
- (43284,1,0,3524,1,2483,1,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3524,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3524,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3525,1,2483,1,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3525,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3525,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3526,1,2483,1,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3526,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3526,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3527,1,2483,1,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3527,2,5286,6254,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,3527,3,5286,5286,0,'Alliance','Dwarf','Soldier'),
- (43284,1,0,2306,1,49778,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,2306,2,5599,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,2306,3,5598,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14613,1,49778,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14613,2,5599,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14613,3,5598,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14614,1,49778,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14614,2,5599,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14614,3,5598,5286,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14615,1,49778,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14615,2,5599,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,14615,3,5598,1,0,'Alliance','Night Elf','Soldier'),
- (43284,1,0,17372,1,24332,0,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17372,2,24332,24331,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17372,3,24332,24332,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17373,1,24332,0,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17373,2,24332,24331,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17373,3,24332,24332,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17374,1,24332,0,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17374,2,24332,24331,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17374,3,24332,24332,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17375,1,24332,0,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17375,2,24332,24331,0,'Alliance','Draenei','Soldier'),
- (43284,1,0,17375,3,24332,24332,0,'Alliance','Draenei','Soldier'),
- (43284,1,1,4259,1,5289,1,1,'Horde','Orc','Soldier'),
- (43284,1,1,4259,2,10612,1961,1,'Horde','Orc','Soldier'),
- (43284,1,1,4259,3,10612,10612,1,'Horde','Orc','Soldier'),
- (43284,1,1,4260,1,5289,1,1,'Horde','Orc','Soldier'),
- (43284,1,1,4260,2,10612,1961,1,'Horde','Orc','Soldier'),
- (43284,1,1,4260,3,10612,10612,1,'Horde','Orc','Soldier'),
- (43284,1,1,4602,1,5289,1,1,'Horde','Orc','Soldier'),
- (43284,1,1,4602,2,10612,1961,1,'Horde','Orc','Soldier'),
- (43284,1,1,4602,3,10612,10612,1,'Horde','Orc','Soldier'),
- (43284,1,1,4601,1,5289,1,1,'Horde','Orc','Soldier'),
- (43284,1,1,4601,2,10612,1961,1,'Horde','Orc','Soldier'),
- (43284,1,1,4601,3,10612,10612,1,'Horde','Orc','Soldier'),
- (43284,1,1,2141,1,12754,1,1,'Horde','Tauren','Soldier'),
- (43284,1,1,2141,2,18596,1961,1,'Horde','Tauren','Soldier'),
- (43284,1,1,2141,3,18596,18596,1,'Horde','Tauren','Soldier'),
- (43284,1,1,9391,1,12754,1,1,'Horde','Tauren','Soldier'),
- (43284,1,1,9391,2,18596,1961,1,'Horde','Tauren','Soldier'),
- (43284,1,1,9391,3,18596,18596,1,'Horde','Tauren','Soldier'),
- (43284,1,1,8572,1,12754,1,1,'Horde','Tauren','Soldier'),
- (43284,1,1,8572,2,18596,1961,1,'Horde','Tauren','Soldier'),
- (43284,1,1,8572,3,18596,18596,1,'Horde','Tauren','Soldier'),
- (43284,1,1,9392,1,12754,1,1,'Horde','Tauren','Soldier'),
- (43284,1,1,9392,2,18596,1961,1,'Horde','Tauren','Soldier'),
- (43284,1,1,9392,3,18596,18596,1,'Horde','Tauren','Soldier'),
- (43284,1,1,4083,1,2023,1,1,'Horde','Troll','Soldier'),
- (43284,1,1,4083,2,1904,1961,1,'Horde','Troll','Soldier'),
- (43284,1,1,4083,3,1904,1904,1,'Horde','Troll','Soldier'),
- (43284,1,1,4084,1,2023,1,1,'Horde','Troll','Soldier'),
- (43284,1,1,4084,2,1904,1961,1,'Horde','Troll','Soldier'),
- (43284,1,1,4084,3,1904,1904,1,'Horde','Troll','Soldier'),
- (43284,1,1,2854,1,5286,1,1,'Horde','Undead','Soldier'),
- (43284,1,1,2854,2,1905,1961,1,'Horde','Undead','Soldier'),
- (43284,1,1,2854,3,1905,1905,1,'Horde','Undead','Soldier'),
- (43284,1,1,1666,1,5286,1,1,'Horde','Undead','Soldier'),
- (43284,1,1,1666,2,1905,1961,1,'Horde','Undead','Soldier'),
- (43284,1,1,1666,3,1905,1905,1,'Horde','Undead','Soldier'),
- (43284,1,1,2859,1,5286,1,1,'Horde','Undead','Soldier'),
- (43284,1,1,2859,2,1905,1961,1,'Horde','Undead','Soldier'),
- (43284,1,1,2859,3,1905,1905,1,'Horde','Undead','Soldier'),
- (43284,1,1,2853,1,5286,1,1,'Horde','Undead','Soldier'),
- (43284,1,1,2853,2,1905,1961,1,'Horde','Undead','Soldier'),
- (43284,1,1,2853,3,1905,1905,1,'Horde','Undead','Soldier'),
- (43284,1,1,15936,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,15936,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,15936,3,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17264,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17264,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17264,3,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17266,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17266,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17266,3,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17265,1,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17265,2,18596,1961,1,'Horde','Bloodelf','Soldier'),
- (43284,1,1,17265,3,18596,1961,1,'Horde','Bloodelf','Soldier');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement