diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_02_04_01_world.sql | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_02_04_01_world.sql b/sql/updates/world/3.3.5/2019_02_04_01_world.sql new file mode 100644 index 00000000000..399db4ffe63 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_02_04_01_world.sql @@ -0,0 +1,58 @@ +-- +UPDATE `creature_template` SET `mingold`=600000, `maxgold`=700000 WHERE `entry` IN (39746,39747,39751); +UPDATE `creature_template` SET `mingold`=1500000, `maxgold`=1750000 WHERE `entry` IN (39805, 39823, 39920); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (39863, 39864, 39944, 39945); +UPDATE `creature_template` SET `mingold`=800000, `maxgold`=1200000 WHERE `entry` IN (10184); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (36538); +UPDATE `creature_template` SET `mingold`=160000, `maxgold`=200000 WHERE `entry` IN (30449,30451,30452); +UPDATE `creature_template` SET `mingold`=400000, `maxgold`=500000 WHERE `entry` IN (31535, 31520, 31534); +UPDATE `creature_template` SET `mingold`=1800000, `maxgold`=2000000 WHERE `entry` IN (30453); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (31001); +UPDATE `gameobject_template_addon` SET `mingold`=1500000, `maxgold`=1800000 WHERE `entry`=193905; +UPDATE `gameobject_template_addon` SET `mingold`=2500000, `maxgold`=3000000 WHERE `entry`=193967; +UPDATE `creature_template` SET `mingold`=1700000, `maxgold`=1900000 WHERE `entry` IN (31125, 33993, 35013, 38433); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2500000 WHERE `entry` IN (31722,33994,35360,38462); +UPDATE `creature_template` SET `mingold`=800000, `maxgold`=900000 WHERE `entry` IN (36612, 36626, 36627, 36678, 36853, 36855, 37955, 37970); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (37957, 37504, 38390, 38431, 38265, 38106, 38434, 38401); +UPDATE `creature_template` SET `mingold`=1000000, `maxgold`=1200000 WHERE `entry` IN (37958, 37505, 38549, 38585, 38266, 38296, 38435, 38784); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (37959, 37506, 38550, 38586, 38267, 38297, 38436, 38785); +UPDATE `gameobject_template_addon` SET `mingold`=800000, `maxgold`=900000 WHERE `entry` IN (202239,201873,202178,201959); +UPDATE `gameobject_template_addon` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (202240,201874,202180,202339); +UPDATE `gameobject_template_addon` SET `mingold`=1000000, `maxgold`=1200000 WHERE `entry` IN (202238,201872,202177,202338); +UPDATE `gameobject_template_addon` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (202241,201875,202179,202340); +UPDATE `creature_template` SET `mingold`=1000000, `maxgold`=1200000 WHERE `entry` IN (36597); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (39166); +UPDATE `creature_template` SET `mingold`=1200000, `maxgold`=1400000 WHERE `entry` IN (39167); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN (39168); +UPDATE `creature_template` SET `mingold`=1500000, `maxgold`=1800000 WHERE `entry` IN (32857, 32867, 32927, 33113, 33118, 33186, 33271, 33293, 33515); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2500000 WHERE `entry` IN (33694, 33693, 33692, 34003, 33190, 33724, 33449, 33885, 34175); +UPDATE `gameobject_template_addon` SET `mingold`=1500000, `maxgold`=1800000 WHERE `entry` IN ( 195046, 194307, 194789,194957, 194312, 194313, 194324,194325,194327,194326); +UPDATE `gameobject_template_addon` SET `mingold`=2000000, `maxgold`=2500000 WHERE `entry` IN ( 195047, 194308,194956,194958, 194314, 194315,194330,194329,194331,194328); +UPDATE `creature_template` SET `mingold`=1800000, `maxgold`=2000000 WHERE `entry` IN (33288); +UPDATE `creature_template` SET `mingold`=3000000, `maxgold`=3250000 WHERE `entry` IN (33955); +UPDATE `gameobject_template_addon` SET `mingold`=1800000, `maxgold`=2000000 WHERE `entry`=194821; +UPDATE `gameobject_template_addon` SET `mingold`=3000000, `maxgold`=3250000 WHERE `entry`=194822; +UPDATE `creature_template` SET `mingold`=1200000, `maxgold`=1400000 WHERE `entry` IN(16060, 15956,16061,15936,15954,16028,15953,15989,15932,15931); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN(29373,29417,29701,29268,29615,29249,29991,29324,29955,29940); +UPDATE `creature_template` SET `mingold`=1700000, `maxgold`=1800000 WHERE `entry` IN(15952,15928,16011); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN(29448, 29278, 29718); +UPDATE `gameobject_template_addon` SET `mingold`=1700000, `maxgold`=1800000 WHERE `entry`=181366; +UPDATE `gameobject_template_addon` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry`=193426; +UPDATE `creature_template` SET `mingold`=1800000, `maxgold`=2000000 WHERE `entry` IN(15990); +UPDATE `creature_template` SET `mingold`=2250000, `maxgold`=2500000 WHERE `entry` IN(30061); +UPDATE `creature_template` SET `mingold`=400000, `maxgold`=450000 WHERE `entry` IN(34496, 34497); +UPDATE `creature_template` SET `mingold`=1000000, `maxgold`=1125000 WHERE `entry` IN(35347, 35350); +UPDATE `creature_template` SET `mingold`=450000, `maxgold`=500000 WHERE `entry` IN(35348, 35351); +UPDATE `creature_template` SET `mingold`=1125000, `maxgold`=1250000 WHERE `entry` IN(35349, 35352); +UPDATE `creature_template` SET `mingold`=800000, `maxgold`=900000 WHERE `entry` IN(34780, 34797); +UPDATE `creature_template` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry` IN(35216, 35447); +UPDATE `creature_template` SET `mingold`=900000, `maxgold`=1000000 WHERE `entry` IN(35268, 35448); +UPDATE `creature_template` SET `mingold`=2250000, `maxgold`=2500000 WHERE `entry` IN(35269, 35449); +UPDATE `creature_template` SET `mingold`=900000, `maxgold`=1000000 WHERE `entry` IN(34564); +UPDATE `creature_template` SET `mingold`=2250000, `maxgold`=2500000 WHERE `entry` IN(34566); +UPDATE `creature_template` SET `mingold`=1000000, `maxgold`=1100000 WHERE `entry` IN(35615); +UPDATE `creature_template` SET `mingold`=2500000, `maxgold`=2700000 WHERE `entry` IN(35616); +UPDATE `gameobject_template_addon` SET `mingold`=800000, `maxgold`=900000 WHERE `entry`=195631; +UPDATE `gameobject_template_addon` SET `mingold`=2000000, `maxgold`=2250000 WHERE `entry`=195632; +UPDATE `gameobject_template_addon` SET `mingold`=900000, `maxgold`=1000000 WHERE `entry`=195633; +UPDATE `gameobject_template_addon` SET `mingold`=2250000, `maxgold`=2500000 WHERE `entry`=195635; |