| trevius |
05-07-2009 05:04 AM |
Updated Horses Table for SoF
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');
|