UeNuu22p

1DROP TABLE IF EXISTS `chat_filter`;
2CREATE TABLE `chat_filter`
3(
4    `id` int(2) NOT NULL,
5    `word` CHAR(64) NOT NULL,
6    `filtertype` int(2) NOT NULL DEFAULT 0,
7    `filter` VARCHAR(200) NOT NULL DEFAULT '',
8    `replacement` VARCHAR(100) NOT NULL DEFAULT '',
9    `punishment` int(10) UNSIGNED NOT NULL DEFAULT 0,
10    PRIMARY KEY (`id`)
11);
12
13-- These columns are used when a player logs out while being frozen or stuned.
14ALTER TABLE `characters`.`characters`
15        ADD COLUMN `FreezeTimer` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `deleteDate`,
16        ADD COLUMN `StunTimer` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `FreezeTimer`;
17
18DELETE FROM `chat_filter`;
19INSERT INTO `chat_filter` (`id`,`word`,`punishment`) VALUES
20(0,"asshole",2), -- CHAT_FILTER_PUNISHMENT_MUTE_30_SEC
21(1,"retard",3), -- CHAT_FILTER_PUNISHMENT_MUTE_30_SEC + CHAT_FILTER_PUNISHMENT_MUTE_10_SEC
22(2,"fuck",1), -- CHAT_FILTER_PUNISHMENT_MUTE_10_SEC
23(3,"fucking",2), -- CHAT_FILTER_PUNISHMENT_MUTE_30_SEC
24(4,"nigger",2048); -- CHAT_FILTER_PUNISHMENT_KICK_PLAYER
25
26-- Self Stun removes the stun visual when it expires
27DELETE FROM `spell_linked_spell` WHERE `spell_effect`=-18970;
28INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
29(-65256,-18970,0,"Self Stun removal removes Self Stun - (Visual Only)");