DELETE FROM `command` WHERE `name` = 'reload';
DELETE FROM `command` WHERE `name` = 'reload all';
DELETE FROM `command` WHERE `name` = 'reload all_spell';
INSERT INTO `command` VALUES('reload',3,'Syntax: .reload table_name\r\n\r\nReload table `table_name` if reload support added for this table and this table can be _safe_ reloaded.');
INSERT INTO `command` VALUES('reload all',3,'Syntax: .reload all\r\n\r\nReload all tables with reload support added and that can be _safe_ reloaded.');
INSERT INTO `command` VALUES('reload all_spell',3,'Syntax: .reload all\r\n\r\nReload all `spell_*` tables with reload support added and that can be _safe_ reloaded.');
DELETE FROM `spell_chain` WHERE `spell_id` IN (5487,9634,33943,40120);
INSERT INTO `spell_chain` VALUES
(5487,0,5487,1),
(9634,5487,5487,2),
(33943,0,33943,1),
(40120,33943,33943,2);
DELETE FROM `command` WHERE `name` = 'reload all_area';
DELETE FROM `command` WHERE `name` = 'reload all_loot';
DELETE FROM `command` WHERE `name` = 'reload all_quest';
INSERT INTO `command` VALUES('reload all_area',3,'Syntax: .reload all_area\r\n\r\nReload all `areatrigger_*` tables if reload support added for this table and this table can be _safe_ reloaded.');
INSERT INTO `command` VALUES('reload all_loot',3,'Syntax: .reload all_loot\r\n\r\nReload all `*_loot_template` tables. This can be slow operation with lags for server run.');
INSERT INTO `command` VALUES('reload all_quest',3,'Syntax: .reload all_quest\r\n\r\nReload all quest related tables if reload support added for this table and this table can be _safe_ reloaded.');
DELETE FROM `spell_proc_event` WHERE `entry` IN ( 11255, 12598 );
INSERT INTO `spell_proc_event` VALUES
(11255,32,0,0,3,0,16384,0),
(12598,32,0,0,3,0,16384,0);
INSERT INTO `command` ( `name` , `security` , `help` )
VALUES (
'tele', '1', 'Syntax: .tele $location\n\nTeleport the gm to the provided location. You can look up these locations using .lookuptele'
);
ALTER TABLE `character_reputation` DROP `reputation`;
/* for reference
DROP TABLE IF EXISTS `spell_proc_event`;
CREATE TABLE `spell_proc_event` (
`entry` smallint(6) unsigned NOT NULL default '0',
`SchoolMask` tinyint(4) NOT NULL default '0',
`Category` smallint(6) NOT NULL default '0',
`SkillID` smallint(6) NOT NULL default '0',
`SpellFamilyName` smallint(6) unsigned NOT NULL default '0',
`SpellFamilyMask` bigint(40) unsigned NOT NULL default '0',
`procFlags` int(11) unsigned NOT NULL default '0',
`ppmRate` float NOT NULL default '0',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
*/
DELETE FROM `spell_proc_event` WHERE `entry` IN ( 30675, 30678, 30679, 30680, 30681 );
INSERT INTO `spell_proc_event` VALUES
(30675,0,0,0,11,3,16384,0),
(30678,0,0,0,11,3,16384,0),
(30679,0,0,0,11,3,16384,0),
(30680,0,0,0,11,3,16384,0),
(30681,0,0,0,11,3,16384,0);