From 0dc9e0bb214e7a6c93ee1b156fd85dc437d8fc07 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 17 Mar 2020 20:44:33 +0100
Subject: DB/Creature: Techbot

Closes #24322
---
 sql/updates/world/3.3.5/2020_03_17_02.sql       |  3 ---
 sql/updates/world/3.3.5/2020_03_17_02_world.sql |  3 +++
 sql/updates/world/3.3.5/2020_03_17_03.sql       | 11 -----------
 sql/updates/world/3.3.5/2020_03_17_03_world.sql | 11 +++++++++++
 sql/updates/world/3.3.5/2020_03_17_04_world.sql |  2 ++
 5 files changed, 16 insertions(+), 14 deletions(-)
 delete mode 100644 sql/updates/world/3.3.5/2020_03_17_02.sql
 create mode 100644 sql/updates/world/3.3.5/2020_03_17_02_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2020_03_17_03.sql
 create mode 100644 sql/updates/world/3.3.5/2020_03_17_03_world.sql
 create mode 100644 sql/updates/world/3.3.5/2020_03_17_04_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/3.3.5/2020_03_17_02.sql b/sql/updates/world/3.3.5/2020_03_17_02.sql
deleted file mode 100644
index f964ce888aa..00000000000
--- a/sql/updates/world/3.3.5/2020_03_17_02.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- 
-DELETE FROM `creature` WHERE `id`=18431;
-DELETE FROM `linked_respawn` WHERE `guid` IN (91131,91132,91133);
diff --git a/sql/updates/world/3.3.5/2020_03_17_02_world.sql b/sql/updates/world/3.3.5/2020_03_17_02_world.sql
new file mode 100644
index 00000000000..f964ce888aa
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_03_17_02_world.sql
@@ -0,0 +1,3 @@
+-- 
+DELETE FROM `creature` WHERE `id`=18431;
+DELETE FROM `linked_respawn` WHERE `guid` IN (91131,91132,91133);
diff --git a/sql/updates/world/3.3.5/2020_03_17_03.sql b/sql/updates/world/3.3.5/2020_03_17_03.sql
deleted file mode 100644
index 25943efe425..00000000000
--- a/sql/updates/world/3.3.5/2020_03_17_03.sql
+++ /dev/null
@@ -1,11 +0,0 @@
--- Calliard 16159 random Talk 
-DELETE FROM `creature_text` WHERE `CreatureID`=16159;
-INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
-(16159, 0, 0, 'Am I hearing things?', 12, 0, 100, 0, 0, 0, 13252, 0, 'Calliard random talk'),
-(16159, 0, 1, 'Who goes there?', 12, 0, 100, 0, 0, 0, 13251, 0, 'Calliard random talk'),
-(16159, 0, 2, 'All quiet.', 12, 0, 100, 0, 0, 0, 13250, 0, 'Calliard random talk');
--- Calliard 16159 random Talk SAI
-UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=16159;
-DELETE FROM `smart_scripts` WHERE (`entryorguid`=16159 AND `source_type`=0);
-INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
-(16159, 0, 0, 0, 1, 0, 100, 0, 0, 0, 60000, 60000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Calliard random talk ooc");
diff --git a/sql/updates/world/3.3.5/2020_03_17_03_world.sql b/sql/updates/world/3.3.5/2020_03_17_03_world.sql
new file mode 100644
index 00000000000..25943efe425
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_03_17_03_world.sql
@@ -0,0 +1,11 @@
+-- Calliard 16159 random Talk 
+DELETE FROM `creature_text` WHERE `CreatureID`=16159;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
+(16159, 0, 0, 'Am I hearing things?', 12, 0, 100, 0, 0, 0, 13252, 0, 'Calliard random talk'),
+(16159, 0, 1, 'Who goes there?', 12, 0, 100, 0, 0, 0, 13251, 0, 'Calliard random talk'),
+(16159, 0, 2, 'All quiet.', 12, 0, 100, 0, 0, 0, 13250, 0, 'Calliard random talk');
+-- Calliard 16159 random Talk SAI
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=16159;
+DELETE FROM `smart_scripts` WHERE (`entryorguid`=16159 AND `source_type`=0);
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(16159, 0, 0, 0, 1, 0, 100, 0, 0, 0, 60000, 60000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Calliard random talk ooc");
diff --git a/sql/updates/world/3.3.5/2020_03_17_04_world.sql b/sql/updates/world/3.3.5/2020_03_17_04_world.sql
new file mode 100644
index 00000000000..8ec1c02b6ae
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_03_17_04_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `creature` SET `spawntimesecs`=43200 WHERE `id` IN (6231);
-- 
cgit v1.2.3