From 125efc7dc805aebc9b3c3e7f56ea2f4c2aed109e Mon Sep 17 00:00:00 2001 From: Shocker Date: Tue, 24 Apr 2012 03:29:16 +0300 Subject: DB/SQLs: Small corrections to sql files from recent pull requests --- sql/updates/world/2012_04_04_00_world_command.sql | 10 ---------- sql/updates/world/2012_04_11_00_world_spell_proc_event.sql | 4 ---- sql/updates/world/2012_04_17_00_world_warden_checks.sql | 8 -------- sql/updates/world/2012_04_22_01_world_spell_script_names.sql | 3 --- sql/updates/world/2012_04_23_03_world_spell_proc_event.sql | 4 ---- sql/updates/world/2012_04_24_00_world_command.sql | 10 ++++++++++ sql/updates/world/2012_04_24_01_world_spell_proc_event.sql | 4 ++++ sql/updates/world/2012_04_24_02_world_warden_checks.sql | 8 ++++++++ sql/updates/world/2012_04_24_03_world_spell_script_names.sql | 4 ++++ sql/updates/world/2012_04_24_04_world_spell_proc_event.sql | 4 ++++ 10 files changed, 30 insertions(+), 29 deletions(-) delete mode 100644 sql/updates/world/2012_04_04_00_world_command.sql delete mode 100644 sql/updates/world/2012_04_11_00_world_spell_proc_event.sql delete mode 100644 sql/updates/world/2012_04_17_00_world_warden_checks.sql delete mode 100644 sql/updates/world/2012_04_22_01_world_spell_script_names.sql delete mode 100644 sql/updates/world/2012_04_23_03_world_spell_proc_event.sql create mode 100644 sql/updates/world/2012_04_24_00_world_command.sql create mode 100644 sql/updates/world/2012_04_24_01_world_spell_proc_event.sql create mode 100644 sql/updates/world/2012_04_24_02_world_warden_checks.sql create mode 100644 sql/updates/world/2012_04_24_03_world_spell_script_names.sql create mode 100644 sql/updates/world/2012_04_24_04_world_spell_proc_event.sql (limited to 'sql') diff --git a/sql/updates/world/2012_04_04_00_world_command.sql b/sql/updates/world/2012_04_04_00_world_command.sql deleted file mode 100644 index 9adb3cff1d9..00000000000 --- a/sql/updates/world/2012_04_04_00_world_command.sql +++ /dev/null @@ -1,10 +0,0 @@ -DELETE FROM `command` WHERE `name` IN ('modify tp','modify bwalk','modify swim','modify fly','modify arena','modify aspeed','modify morph'); -INSERT INTO `command` (`name`, `security`, `help`) VALUES ('modify speed all', 1, 'Syntax: .modify aspeed #rate\r\n\r\nModify all speeds -run,swim,run back,swim back- of the selected player to "normalbase speed for this move type"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), -('modify speed backwalk', 1, 'Syntax: .modify speed backwalk #rate\r\n\r\nModify the speed of the selected player while running backwards to "normal walk back speed"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), -('modify speed fly', 1, '.modify speed fly #rate\nModify the flying speed of the selected player to "normal flying speed"*rate. If no player is selected, modify your speed.\n #rate may range from 0.1 to 50.'), -('modify speed swim', 1, 'Syntax: .modify speed swim #rate\r\n\r\nModify the swim speed of the selected player to "normal swim speed"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), -('modify speed walk', 1, 'Syntax: .modify speed bwalk #rate\r\n\r\nModify the speed of the selected player while running to "normal walk speed"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), -('modify talentpoints', 1, 'Syntax: .modify talentpoints #amount\r\n\r\nSet free talent points for selected character or character\'s pet. It will be reset to default expected at next levelup/login/quest reward.'), -('morph', 2, 'Syntax: .morph #displayid\r\n\r\nChange your current model id to #displayid.'), -('modify arenapoints', 1, 'Syntax: .modify arenapoints #value\r\nAdd $amount arena points to the selected player.'); -UPDATE `command` SET `help`='Syntax: .modify speed $speedtype #rate\r\n\r\nModify the running speed of the selected player to "normal base run speed"= 1. If no player is selected, modify your speed.\r\n\r\n$speedtypes may be fly, all, walk, backwalk, or swim.\r\n\r\n #rate may range from 0.1 to 50.' WHERE `name`='modify speed' LIMIT 1; \ No newline at end of file diff --git a/sql/updates/world/2012_04_11_00_world_spell_proc_event.sql b/sql/updates/world/2012_04_11_00_world_spell_proc_event.sql deleted file mode 100644 index e5dfbeb0e66..00000000000 --- a/sql/updates/world/2012_04_11_00_world_spell_proc_event.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Honor Among Thieves proc -UPDATE `spell_proc_event` SET `CustomChance`=33 WHERE `entry`=51698; -- Rank 1 -UPDATE `spell_proc_event` SET `CustomChance`=66 WHERE `entry`=51700; -- Rank 2 -UPDATE `spell_proc_event` SET `CustomChance`=100 WHERE `entry`=51701; -- Rank 3 diff --git a/sql/updates/world/2012_04_17_00_world_warden_checks.sql b/sql/updates/world/2012_04_17_00_world_warden_checks.sql deleted file mode 100644 index 74539f99fb3..00000000000 --- a/sql/updates/world/2012_04_17_00_world_warden_checks.sql +++ /dev/null @@ -1,8 +0,0 @@ -UPDATE `warden_checks` SET `comment`='Swimming_FallCalc - movement state' WHERE `id`=15; -UPDATE `warden_checks` SET `comment`='CreateMovementStatus' WHERE `id`=72; -UPDATE `warden_checks` SET `comment`='OnStartSwim OnSplineStartSwim - movement state' WHERE `id`=170; -UPDATE `warden_checks` SET `comment`='DefaultServerLogin - account name' WHERE `id`=198; -UPDATE `warden_checks` SET `comment`='Login Checksum - authentication process' WHERE `id`=320; -UPDATE `warden_checks` SET `comment`='CalcFallStartElevation - (some kind of wall climb)' WHERE `id`=329; -UPDATE `warden_checks` SET `comment`='Code injection at 0x40100A' WHERE `id`=381; -UPDATE `warden_checks` SET `comment`='Login State - (May be false positive)' WHERE `id`=437; diff --git a/sql/updates/world/2012_04_22_01_world_spell_script_names.sql b/sql/updates/world/2012_04_22_01_world_spell_script_names.sql deleted file mode 100644 index bd4becdc3f4..00000000000 --- a/sql/updates/world/2012_04_22_01_world_spell_script_names.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=59566; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(59566,'spell_sha_earthen_power'); diff --git a/sql/updates/world/2012_04_23_03_world_spell_proc_event.sql b/sql/updates/world/2012_04_23_03_world_spell_proc_event.sql deleted file mode 100644 index dfa57b031c3..00000000000 --- a/sql/updates/world/2012_04_23_03_world_spell_proc_event.sql +++ /dev/null @@ -1,4 +0,0 @@ - -- Rogue T9 2P - Should proc only from Rupture ticks. -DELETE FROM `spell_proc_event` WHERE `entry` IN(67209); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `procFlags`) VALUES -(67209, 0x01, 8, 0x100000, 0x50000); \ No newline at end of file diff --git a/sql/updates/world/2012_04_24_00_world_command.sql b/sql/updates/world/2012_04_24_00_world_command.sql new file mode 100644 index 00000000000..25912392347 --- /dev/null +++ b/sql/updates/world/2012_04_24_00_world_command.sql @@ -0,0 +1,10 @@ +DELETE FROM `command` WHERE `name` IN ('modify tp','modify bwalk','modify swim','modify fly','modify arena','modify aspeed','modify morph'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES ('modify speed all', 1, 'Syntax: .modify aspeed #rate\r\n\r\nModify all speeds -run,swim,run back,swim back- of the selected player to "normalbase speed for this move type"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), +('modify speed backwalk', 1, 'Syntax: .modify speed backwalk #rate\r\n\r\nModify the speed of the selected player while running backwards to "normal walk back speed"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), +('modify speed fly', 1, '.modify speed fly #rate\nModify the flying speed of the selected player to "normal flying speed"*rate. If no player is selected, modify your speed.\n #rate may range from 0.1 to 50.'), +('modify speed swim', 1, 'Syntax: .modify speed swim #rate\r\n\r\nModify the swim speed of the selected player to "normal swim speed"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), +('modify speed walk', 1, 'Syntax: .modify speed bwalk #rate\r\n\r\nModify the speed of the selected player while running to "normal walk speed"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'), +('modify talentpoints', 1, 'Syntax: .modify talentpoints #amount\r\n\r\nSet free talent points for selected character or character\'s pet. It will be reset to default expected at next levelup/login/quest reward.'), +('morph', 2, 'Syntax: .morph #displayid\r\n\r\nChange your current model id to #displayid.'), +('modify arenapoints', 1, 'Syntax: .modify arenapoints #value\r\nAdd $amount arena points to the selected player.'); +UPDATE `command` SET `help`='Syntax: .modify speed $speedtype #rate\r\n\r\nModify the running speed of the selected player to "normal base run speed"= 1. If no player is selected, modify your speed.\r\n\r\n$speedtypes may be fly, all, walk, backwalk, or swim.\r\n\r\n #rate may range from 0.1 to 50.' WHERE `name`='modify speed' LIMIT 1; diff --git a/sql/updates/world/2012_04_24_01_world_spell_proc_event.sql b/sql/updates/world/2012_04_24_01_world_spell_proc_event.sql new file mode 100644 index 00000000000..6e997931bb5 --- /dev/null +++ b/sql/updates/world/2012_04_24_01_world_spell_proc_event.sql @@ -0,0 +1,4 @@ +-- Honor Among Thieves proc chance +UPDATE `spell_proc_event` SET `CustomChance`=33 WHERE `entry`=51698; -- Rank 1 +UPDATE `spell_proc_event` SET `CustomChance`=66 WHERE `entry`=51700; -- Rank 2 +UPDATE `spell_proc_event` SET `CustomChance`=100 WHERE `entry`=51701; -- Rank 3 diff --git a/sql/updates/world/2012_04_24_02_world_warden_checks.sql b/sql/updates/world/2012_04_24_02_world_warden_checks.sql new file mode 100644 index 00000000000..74539f99fb3 --- /dev/null +++ b/sql/updates/world/2012_04_24_02_world_warden_checks.sql @@ -0,0 +1,8 @@ +UPDATE `warden_checks` SET `comment`='Swimming_FallCalc - movement state' WHERE `id`=15; +UPDATE `warden_checks` SET `comment`='CreateMovementStatus' WHERE `id`=72; +UPDATE `warden_checks` SET `comment`='OnStartSwim OnSplineStartSwim - movement state' WHERE `id`=170; +UPDATE `warden_checks` SET `comment`='DefaultServerLogin - account name' WHERE `id`=198; +UPDATE `warden_checks` SET `comment`='Login Checksum - authentication process' WHERE `id`=320; +UPDATE `warden_checks` SET `comment`='CalcFallStartElevation - (some kind of wall climb)' WHERE `id`=329; +UPDATE `warden_checks` SET `comment`='Code injection at 0x40100A' WHERE `id`=381; +UPDATE `warden_checks` SET `comment`='Login State - (May be false positive)' WHERE `id`=437; diff --git a/sql/updates/world/2012_04_24_03_world_spell_script_names.sql b/sql/updates/world/2012_04_24_03_world_spell_script_names.sql new file mode 100644 index 00000000000..a53d8bd585c --- /dev/null +++ b/sql/updates/world/2012_04_24_03_world_spell_script_names.sql @@ -0,0 +1,4 @@ +-- Earthen Power +DELETE FROM `spell_script_names` WHERE `spell_id`=59566; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(59566,'spell_sha_earthen_power'); diff --git a/sql/updates/world/2012_04_24_04_world_spell_proc_event.sql b/sql/updates/world/2012_04_24_04_world_spell_proc_event.sql new file mode 100644 index 00000000000..5ba6f24ccf8 --- /dev/null +++ b/sql/updates/world/2012_04_24_04_world_spell_proc_event.sql @@ -0,0 +1,4 @@ + -- Rogue T9 2P - Should proc only from Rupture ticks. +DELETE FROM `spell_proc_event` WHERE `entry` IN(67209); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `procFlags`) VALUES +(67209, 0x01, 8, 0x100000, 0x50000); -- cgit v1.2.3