diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_01_10_06_world_335.sql | 24 |
1 files changed, 24 insertions, 0 deletions
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'); |