Updated Horses Table for SoF

**trevius** · #1 05-07-2009, 05:04 AM

Here are the most recent updates for the horses table that should include all of the mounts in SoF as well as Titanium. It may not be 100% accurate yet, but it should be pretty close. This will enable the new mount races like Kirin, Chimera, Worg, War Horse, Unicorn and so on. I also added notes for the new ones I just updated that include the spell ID and the name of the spell.

Code:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for horses
-- ----------------------------
DROP TABLE IF EXISTS `horses`;
CREATE TABLE `horses` (
  `filename` varchar(32) NOT NULL,
  `race` smallint(3) NOT NULL default '216',
  `gender` tinyint(1) NOT NULL default '0',
  `texture` tinyint(2) NOT NULL default '0',
  `mountspeed` float(4,2) NOT NULL default '0.75',
  `notes` varchar(64) default 'Notes',
  PRIMARY KEY  (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `horses` VALUES ('SumChimeraFast', '582', '2', '0', '1.75', '12917 - Summon Seething Chimera');
INSERT INTO `horses` VALUES ('SumCragslither1Fast', '216', '1', '0', '1.75', '12895 - Summon Crimson Cragslither');
INSERT INTO `horses` VALUES ('SumCragslither2Fast', '216', '1', '0', '1.75', '12896 - Summon Viridian Cragslither');
INSERT INTO `horses` VALUES ('SumCragslither3Fast', '216', '1', '1', '1.75', '12871 - Summon Plagued Cragslither');
INSERT INTO `horses` VALUES ('SumHorseBlFast', '216', '0', '2', '1.75', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBlRun1', '216', '0', '2', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBlRun2', '216', '0', '2', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBlSlow1', '216', '0', '2', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBlSlow2', '216', '0', '0', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBrFast', '216', '0', '0', '1.75', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBrRun1', '216', '0', '0', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBrRun2', '216', '0', '0', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBrSlow1', '216', '0', '0', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseBrSlow2', '216', '0', '0', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseTaFast', '216', '0', '3', '1.75', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseTaRun1', '216', '0', '3', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseTaRun2', '216', '0', '3', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseTaSlow1', '216', '0', '3', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseTaSlow2', '216', '0', '3', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseWhFast', '216', '0', '1', '1.75', '2871 - Summon Horse SumHorseWhFast');
INSERT INTO `horses` VALUES ('SumHorseWhRun1', '216', '0', '1', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseWhRun2', '216', '0', '1', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseWhSlow1', '216', '0', '1', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumHorseWhSlow2', '216', '0', '1', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumKirin0Fast', '583', '2', '0', '1.75', '12916 - Summon Mystical Kirin');
INSERT INTO `horses` VALUES ('SumKirin2Fast', '583', '2', '0', '1.75', '12872 - Summon Cursed Kirin');
INSERT INTO `horses` VALUES ('SumLizardBlkFast', '216', '1', '1', '1.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardBlkRun1', '216', '1', '1', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardBlkRun2', '216', '1', '1', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardBlkSlow1', '216', '1', '1', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardBlkSlow2', '216', '1', '1', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardGrnFast', '216', '1', '2', '1.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardGrnRun1', '216', '1', '2', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardGrnRun2', '216', '1', '2', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardGrnSlow1', '216', '1', '2', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardGrnSlow2', '216', '1', '2', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardRedFast', '216', '1', '3', '1.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardRedRun1', '216', '1', '3', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardRedRun2', '216', '1', '3', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardRedSlow1', '216', '1', '3', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardRedSlow2', '216', '1', '3', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardWhtFast', '216', '1', '0', '1.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardWhtRun1', '216', '1', '0', '1.25', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardWhtRun2', '216', '1', '0', '1.50', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardWhtSlow1', '216', '1', '0', '0.75', 'Notes');
INSERT INTO `horses` VALUES ('SumLizardWhtSlow2', '216', '1', '0', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('SumNightmareFast', '517', '2', '1', '1.75', '8978 - Abyssal Steed');
INSERT INTO `horses` VALUES ('SumPuma1Fast', '584', '2', '1', '1.75', '12915 - Summon Shadow Panther');
INSERT INTO `horses` VALUES ('SumPuma3Fast', '584', '2', '0', '1.75', '12914 - Summon Snow Leopard');
INSERT INTO `horses` VALUES ('SumRoboboar', '472', '2', '0', '1.00', '8355 - Activate Roboboar');
INSERT INTO `horses` VALUES ('SumRoboboarFast', '472', '2', '0', '1.75', '9185 - Activate Roboboar');
INSERT INTO `horses` VALUES ('SumRoboboarRun1', '472', '2', '0', '1.25', '9183 - Activate Roboboar');
INSERT INTO `horses` VALUES ('SumRoboboarRun2', '472', '2', '0', '1.50', '9184 - Activate Roboboar');
INSERT INTO `horses` VALUES ('SumRoboboarSlow2', '472', '2', '0', '1.00', '9182 - Activate Roboboar');
INSERT INTO `horses` VALUES ('SumUnicornFast', '517', '2', '0', '1.75', '8977 - Valiant Steed');
INSERT INTO `horses` VALUES ('SumWarHorseBlFast', '492', '2', '8', '1.75', '8976 - Summon Death Charger');
INSERT INTO `horses` VALUES ('SumWarHorseBlRun1', '492', '2', '5', '1.25', '8913 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBlRun2', '492', '2', '5', '1.50', '8914 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBlSlow1', '492', '2', '2', '0.75', '8911 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBlSlow2', '492', '2', '2', '1.00', '8912 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBrFast', '492', '2', '6', '1.75', '8905 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBrRun1', '492', '2', '3', '1.25', '8903 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBrRun2', '492', '2', '3', '1.50', '8904 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBrSlow1', '492', '2', '0', '0.75', '8901 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseBrSlow2', '492', '2', '0', '1.00', '8902 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseTaFast', '492', '2', '6', '1.75', '11564 - Summon Ghostrider');
INSERT INTO `horses` VALUES ('SumWarHorseTaRun1', '492', '2', '3', '1.25', '8918 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseTaRun2', '492', '2', '3', '1.50', '8919 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseTaSlow1', '492', '2', '0', '0.75', '8916 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseTaSlow2', '492', '2', '0', '1.00', '8917 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseWhFast', '492', '2', '7', '1.75', '8975 - Summon Holy Steed');
INSERT INTO `horses` VALUES ('SumWarHorseWhRun1', '492', '2', '4', '1.25', '8908 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseWhRun2', '492', '2', '4', '1.50', '8909 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseWhSlow1', '492', '2', '1', '0.75', '8906 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWarHorseWhSlow2', '492', '2', '1', '1.00', '8907 - Summon Warhorse');
INSERT INTO `horses` VALUES ('SumWorgFastClaimDigital', '580', '2', '2', '1.75', '9394 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWorgFastClaimRetailBox', '580', '2', '2', '1.75', '9395 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWorgRun1ClaimDigital', '580', '2', '1', '1.25', '9396 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWorgRun1ClaimRetailBox', '580', '2', '1', '1.25', '9397 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWorgRun2ClaimDigital', '580', '2', '1', '1.50', '9398 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWorgRun2ClaimRetailBox', '580', '2', '1', '1.50', '9399 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWorgSlow2ClaimDigital', '580', '2', '0', '1.00', '9400 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWorgSlow2ClaimRetailBox', '580', '2', '0', '1.00', '9401 - Summon Worg');
INSERT INTO `horses` VALUES ('SumWrulon1Fast', '580', '2', '0', '1.75', '12893 - Summon Guardian Wrulon');
INSERT INTO `horses` VALUES ('SumWrulon2Fast', '580', '2', '1', '1.75', '12894 - Summon Wrulon Protector');
INSERT INTO `horses` VALUES ('SumWrulon3Fast', '580', '2', '2', '1.75', '12870 - Summon Wrulon Warder');
INSERT INTO `horses` VALUES ('TestHorseA', '216', '0', '0', '1.00', 'Notes');
INSERT INTO `horses` VALUES ('TestWarHorseA', '492', '2', '8', '1.00', 'Notes');