From 2fb573150d5c08a5a2fa870f886969d25aee5734 Mon Sep 17 00:00:00 2001 From: Killyana Date: Thu, 10 Jan 2019 21:46:14 +0100 Subject: DB/GameObject: Add pooling for Water Barrel and Food Crate Closes #22933 --- .../world/3.3.5/2019_01_10_06_world_335.sql | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_01_10_06_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_01_10_06_world_335.sql b/sql/updates/world/3.3.5/2019_01_10_06_world_335.sql new file mode 100644 index 00000000000..4e9960a3e6e --- /dev/null +++ b/sql/updates/world/3.3.5/2019_01_10_06_world_335.sql @@ -0,0 +1,24 @@ +-- +DELETE FROM `pool_template` WHERE entry IN (501,502,503,504,505,506); +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(501, 1, 'Water Barrel and Food Crate1'), +(502, 1, 'Water Barrel and Food Crate2'), +(503, 1, 'Water Barrel and Food Crate3'), +(504, 1, 'Water Barrel and Food Crate4'), +(505, 1, 'Water Barrel and Food Crate5'), +(506, 1, 'Water Barrel and Food Crate6'); + +DELETE FROM `pool_gameobject` WHERE pool_entry IN (501,502,503,504,505,506); +INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`) VALUES +(29275,501, 0, 'Water Barrel and Food Crate - Spawn 1'), +(30758,501, 0, 'Water Barrel and Food Crate - Spawn 1'), +(32754,502, 0, 'Water Barrel and Food Crate - Spawn 2'), +(32313,502, 0, 'Water Barrel and Food Crate - Spawn 2'), +(30839,503, 0, 'Water Barrel and Food Crate - Spawn 3'), +(30677,503, 0, 'Water Barrel and Food Crate - Spawn 3'), +(29276,504, 0, 'Water Barrel and Food Crate - Spawn 4'), +(30687,504, 0, 'Water Barrel and Food Crate - Spawn 4'), +(10677,505, 0, 'Water Barrel and Food Crate - Spawn 5'), +(1462, 505, 0, 'Water Barrel and Food Crate - Spawn 5'), +(29609,506, 0, 'Water Barrel and Food Crate - Spawn 6'), +(29306,506, 0, 'Water Barrel and Food Crate - Spawn 6'); -- cgit v1.2.3