From a7fc2586e765a39371d49bf3f2b0b81d9c9df69a Mon Sep 17 00:00:00 2001 From: QAston Date: Fri, 10 Feb 2012 12:44:07 +0100 Subject: Core/Db/Conditions: Add NegativeCondition column to conditions table which allows to check whenever player does not meet condition specified by ConditionTypeOrReference column (ConditionTypeOrReference and ConditionValue3 set to reference id are not affected by the change) --- sql/updates/world/2012_02_10_00_world_conditions.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2012_02_10_00_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2012_02_10_00_world_conditions.sql b/sql/updates/world/2012_02_10_00_world_conditions.sql new file mode 100644 index 00000000000..508011609cf --- /dev/null +++ b/sql/updates/world/2012_02_10_00_world_conditions.sql @@ -0,0 +1 @@ +ALTER TABLE `conditions` ADD COLUMN `NegativeCondition` tinyint(3) UNSIGNED NOT NULL default '0' AFTER `ConditionValue3`; -- cgit v1.2.3 From 6a43ee550190ae34da7eda0225a5ac4937168d04 Mon Sep 17 00:00:00 2001 From: Nay Date: Fri, 10 Feb 2012 15:03:12 +0000 Subject: DB/GOs: Remove wrong flags and not working SAI script from (LiiT) Picnic Basket Ref 32b2fccf331e545b83e8e Accepting suggestions on how to make it not despawn on first use/click. --- sql/updates/world/2012_02_10_01_world_gameobject.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2012_02_10_01_world_gameobject.sql (limited to 'sql') diff --git a/sql/updates/world/2012_02_10_01_world_gameobject.sql b/sql/updates/world/2012_02_10_01_world_gameobject.sql new file mode 100644 index 00000000000..1dbbb850472 --- /dev/null +++ b/sql/updates/world/2012_02_10_01_world_gameobject.sql @@ -0,0 +1,3 @@ +-- Picnic Basket +UPDATE `gameobject_template` SET `flags`=0, `AIName`='' WHERE `entry`=187267; +DELETE FROM `smart_scripts` WHERE `entryorguid`=187267 AND `source_type`=1; -- cgit v1.2.3