Quote:
UPDATE totemspells SET spellToCast1= 8349 WHERE spellId=1535;
UPDATE totemspells SET spellToCast1= 8502 WHERE spellId=8498;
UPDATE totemspells SET spellToCast1= 8503 WHERE spellId=8499;
UPDATE totemspells SET spellToCast1= 11306 WHERE spellId=11314;
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=11315;
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=27623;
UPDATE totemspells SET spellToCast1= 8187 WHERE spellId=8190;
UPDATE totemspells SET spellToCast1= 10579 WHERE spellId=10585;
UPDATE totemspells SET spellToCast1= 10580 WHERE spellId=10586;
UPDATE totemspells SET spellToCast1= 10581 WHERE spellId=10587;
DROP TABLE IF EXISTS `reputation_creature_onkill`;
CREATE TABLE `reputation_creature_onkill` (
`creature_id` int(30) NOT NULL,
`faction_change_alliance` int(30) NOT NULL,
`change_deltamin_alliance` int(30) NOT NULL,
`change_deltamax_alliance` int(30) NOT NULL,
`faction_change_horde` int(30) NOT NULL,
`change_deltamin_horde` int(30) NOT NULL,
`change_deltamax_horde` int(30) NOT NULL,
KEY `index` (`creature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `reputation_faction_onkill`;
CREATE TABLE `reputation_faction_onkill` (
`faction_id` int(30) NOT NULL,
`change_factionid_alliance` int(30) NOT NULL,
`change_deltamin_alliance` int(30) NOT NULL,
`change_deltamax_alliance` int(30) NOT NULL,
`change_factionid_horde` int(30) NOT NULL,
`change_deltamin_horde` int(30) NOT NULL,
`change_deltamax_horde` int(30) NOT NULL,
KEY `factindex` (`faction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `npc_monstersay`;
CREATE TABLE `npc_monstersay` (
`entry` int(11) NOT NULL,
`event` int(11) NOT NULL,
`chance` float NOT NULL,
`language` int(11) NOT NULL,
`type` int(11) NOT NULL,
`monstername` longtext,
`text0` longtext,
`text1` longtext,
`text2` longtext,
`text3` longtext,
`text4` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;