Trinitycore: DB/GameObject: Supply Crate

Created on 10 Dec 2019  路  29Comments  路  Source: TrinityCore/TrinityCore

Description:

Supply Crate (object=176224) which can be found in Strathome can't be opend/looted.
The cursor shows that these boxes can be opend, but when clicking on them nothing happens.

This also affects quest "Houses of the Holy", since it requires player to loot these boxes for questitems.

Video shows how it should work:
https://youtu.be/iLiQOM39xt0?t=59

Branch(es):

3.3.5

TC rev. hash/commit:

TrinityCore rev. 8c61ef2 2019-12-09

Operating system:

Win10

Branch-3.3.5a Comp-Database Feedback-FixOutdatedMissingWIP Sub-GameObject

Most helpful comment

Yes changing the despawn with GO_JUST_DEACTIVATED fix the issue:
``sql DELETE FROMsmart_scriptsWHEREentryorguidIN (175535, 175536, 175534, 175537) ANDsource_type=1; INSERT INTOsmart_scripts(entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,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
(175535, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176304, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated'),
(175536, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176307, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated'),
(175534, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176308, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated'),
(175537, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176309, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated');

All 29 comments

It was actually opened.

These crates suppose to give you either loots, or break and rats popped. The second part is not working that's why you had "nothing happened". Why? If you keep opening other crates and you will eventually get the loot window. This is confirming the "crate breaks and rats spawn" action is not working.

Duplicate of #19385

11.Non lootable supply crates should do an animation of the box breaking when you get close enough to trigger it, probably pooled since they have seperate id's. Out of these the ones that do summon something (some just animate breaking open but nothing spawns) plagued insects/maggots/rats arent appearing either.
https://s15.postimg.org/8lv4vm26z/dudcrate.png
https://s15.postimg.org/o8me8zfyz/plagued_insect_crate.png
https://s15.postimg.org/muurdogpn/plagued_maggot_crate.png
https://s15.postimg.org/a4qj0l8rf/plagued_rat_crate.png

well #19385 is a sample of HOW don't create one ticket.

At least now we know it's an old issue

Ok after looking to these game objects there are actually 5 different supply crate (gob type 3) in stratholme one has loot the other 4 are linked to traps (gob type 6)

These are all "Supply Crate" in stratholme

176224 - This drops loot
176304 - Spawns insects which attack player
176307 - Spawns Maggots which attack player
176308 - Spawns Rats which attack player
176309 - Casts plague mist

The spells for above are from the traps which are linked to the supply crates which are triggered on player coming into range with a suplly crate except for the ones which contain loot seems the spells where getting cast but the crate was remaining intact and creatures did not attack due to been set as critters and could not be seen because spawned inside crate

The last part needs checking for these creatures because the plagued insects, maggots and rats are set as critters which makes creature passive even if you try and overide in sai these creatures need to attack on spawn but not sure if the type change is correct but definitly dont think these are critters especially since they are level 55.

Anyway with above bad crates get destroyed when player gets close to them and attacks work

~~~sql
UPDATE gameobject_template SET AIName='SmartGameObjectAI' WHERE entryIN(175534,175535,175536,175537);
DELETE FROM smart_scripts WHERE entryorguidIN(175534,175535,175536,175537) AND source_type=1;

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, 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, cus_target_param1, comment) VALUES
(175535, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 20, 176304, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - set state'),
(175535, 1, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 41, 250, 60, 0, 0, 0, 0, 20, 176304, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn'),
(175535, 1, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 60, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn'),
(175536, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 20, 176307, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - set state'),
(175536, 1, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 41, 250, 60, 0, 0, 0, 0, 20, 176307, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn'),
(175536, 1, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 60, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn'),
(175534, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 20, 176308, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - set state'),
(175534, 1, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 41, 250, 60, 0, 0, 0, 0, 20, 176308, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn'),
(175534, 1, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 60, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn'),
(175537, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 20, 176309, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - set state'),
(175537, 1, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 41, 250, 60, 0, 0, 0, 0, 20, 176309, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn'),
(175537, 1, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 60, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Chaned - Despawn');

UPDATE spell_dbc SET Effect1='28',EffectMiscValueB1='64' WHERE Id=16371;

UPDATE creature_template SET type='6' WHERE entry in(10461,10441,10536);

so only this one needs confirmation

UPDATE `creature_template` SET `type`='6' WHERE  `entry` in(10461,10441,10536);

who defined (10461,10441,10536) to be critters back i the days?

Well, when looking at the type table in the creature_template field descriptions, I would not say that there are any obvious alternatives (although I see you have suggested "Undead" as an improvement). Maybe I am simply thinking of "undead" as NPCs with somewhat bigger size and larger health pool.

Well for undead half of stratholme undead suits

These are level 55 npcs regardless of size and should be aggressive

This crates must be pooled https://github.com/cmangos/classic-db/blob/master/Updates/2972_instances_chests_rework.sql

Also according to sniffs we need just to change the react to aggressive for this critters:
```
ServerToClient: SMSG_AI_REACTION (0xCEC2) Length: 12 ConnIdx: 0 Time: 11/23/2011 09:20:38.000 Number: 72508
GUID: Full: 0xF13028DD0000257C Type: Creature Entry: 10461 Low: 9596
Reaction: 2 (Hostile)

ServerToClient: SMSG_ATTACK_START (0xCA4A) Length: 16 ConnIdx: 0 Time: 11/23/2011 09:20:39.000 Number: 72541
GUID: Full: 0xF13028DD0000257C Type: Creature Entry: 10461 Low: 9596
Victim GUID: Full: 0xxxxxxxx Type: Player Low: xxxxxxx Name: xxxxx

That was my first point of call but could not get these to agro while set as critters they won鈥檛 attack even if you try and set this in sai the npc remains passive and won鈥檛 attack unless agrod first

Pooling
~~~sql
SET @POOL := XXXX;
SET @OGUID := XXXXX;

DELETE FROM pool_members WHERE spawnId IN(20959,20960,21114,21115,21116,21156,22022,22023,22030,22031,22032,22033,29194,29204,29659,29805,31986,31987,35461,35475,35789,35791,35796,35835,35836,35837,35838,35839,35840,35841,35842,35843,35844,35845,35846,35847,35849,35850,35851,35852,35853,35854,35855,35856,35857,35858,35859,35867,42059,42060,42450,42453,42455,42464,42882,42883,42884,42885,42886,42887,47785);
DELETE FROM pool_members WHERE spawnId BETWEEN @OGUID+0 AND @OGUID+243;
DELETE FROM pool_members WHERE poolSpawnId BETWEEN @POOL+0 AND @POOL+61;

INSERT INTO pool_members (type, spawnId, poolSpawnId, chance, description) VALUES
(0 ,20959, @POOL+0, 0, "Stratholme Crate (Lootable)"),
(0 ,20960, @POOL+1, 0, "Stratholme Crate (Lootable)"),
(0 ,21114, @POOL+2, 0, "Stratholme Crate (Lootable)"),
(0 ,21115, @POOL+3, 0, "Stratholme Crate (Lootable)"),
(0 ,21116, @POOL+4, 0, "Stratholme Crate (Lootable)"),
(0 ,21156, @POOL+5, 0, "Stratholme Crate (Lootable)"),
(0 ,22022, @POOL+6, 0, "Stratholme Crate (Lootable)"),
(0 ,22023, @POOL+7, 0, "Stratholme Crate (Lootable)"),
(0 ,22030, @POOL+8, 0, "Stratholme Crate (Lootable)"),
(0 ,22031, @POOL+9, 0, "Stratholme Crate (Lootable)"),
(0 ,22032, @POOL+10, 0, "Stratholme Crate (Lootable)"),
(0 ,22033, @POOL+11, 0, "Stratholme Crate (Lootable)"),
(0 ,29194, @POOL+12, 0, "Stratholme Crate (Lootable)"),
(0 ,29204, @POOL+13, 0, "Stratholme Crate (Lootable)"),
(0 ,29659, @POOL+14, 0, "Stratholme Crate (Lootable)"),
(0 ,29805, @POOL+15, 0, "Stratholme Crate (Lootable)"),
(0 ,31986, @POOL+16, 0, "Stratholme Crate (Lootable)"),
(0 ,31987, @POOL+17, 0, "Stratholme Crate (Lootable)"),
(0 ,35461, @POOL+18, 0, "Stratholme Crate (Lootable)"),
(0 ,35475, @POOL+19, 0, "Stratholme Crate (Lootable)"),
(0 ,35789, @POOL+20, 0, "Stratholme Crate (Lootable)"),
(0 ,35791, @POOL+21, 0, "Stratholme Crate (Lootable)"),
(0 ,35796, @POOL+22, 0, "Stratholme Crate (Lootable)"),
(0 ,35835, @POOL+23, 0, "Stratholme Crate (Lootable)"),
(0 ,35836, @POOL+24, 0, "Stratholme Crate (Lootable)"),
(0 ,35837, @POOL+25, 0, "Stratholme Crate (Lootable)"),
(0 ,35838, @POOL+26, 0, "Stratholme Crate (Lootable)"),
(0 ,35839, @POOL+27, 0, "Stratholme Crate (Lootable)"),
(0 ,35840, @POOL+28, 0, "Stratholme Crate (Lootable)"),
(0 ,35841, @POOL+29, 0, "Stratholme Crate (Lootable)"),
(0 ,35842, @POOL+30, 0, "Stratholme Crate (Lootable)"),
(0 ,35843, @POOL+31, 0, "Stratholme Crate (Lootable)"),
(0 ,35844, @POOL+32, 0, "Stratholme Crate (Lootable)"),
(0 ,35845, @POOL+33, 0, "Stratholme Crate (Lootable)"),
(0 ,35846, @POOL+34, 0, "Stratholme Crate (Lootable)"),
(0 ,35847, @POOL+35, 0, "Stratholme Crate (Lootable)"),
(0 ,35849, @POOL+36, 0, "Stratholme Crate (Lootable)"),
(0 ,35850, @POOL+37, 0, "Stratholme Crate (Lootable)"),
(0 ,35851, @POOL+38, 0, "Stratholme Crate (Lootable)"),
(0 ,35852, @POOL+39, 0, "Stratholme Crate (Lootable)"),
(0 ,35853, @POOL+40, 0, "Stratholme Crate (Lootable)"),
(0 ,35854, @POOL+41, 0, "Stratholme Crate (Lootable)"),
(0 ,35855, @POOL+42, 0, "Stratholme Crate (Lootable)"),
(0 ,35856, @POOL+43, 0, "Stratholme Crate (Lootable)"),
(0 ,35857, @POOL+44, 0, "Stratholme Crate (Lootable)"),
(0 ,35858, @POOL+45, 0, "Stratholme Crate (Lootable)"),
(0 ,35859, @POOL+46, 0, "Stratholme Crate (Lootable)"),
(0 ,35867, @POOL+47, 0, "Stratholme Crate (Lootable)"),
(0 ,42059, @POOL+48, 0, "Stratholme Crate (Lootable)"),
(0 ,42060, @POOL+49, 0, "Stratholme Crate (Lootable)"),
(0 ,42450, @POOL+50, 0, "Stratholme Crate (Lootable)"),
(0 ,42453, @POOL+51, 0, "Stratholme Crate (Lootable)"),
(0 ,42455, @POOL+52, 0, "Stratholme Crate (Lootable)"),
(0 ,42464, @POOL+53, 0, "Stratholme Crate (Lootable)"),
(0 ,42882, @POOL+54, 0, "Stratholme Crate (Lootable)"),
(0 ,42883, @POOL+55, 0, "Stratholme Crate (Lootable)"),
(0 ,42884, @POOL+56, 0, "Stratholme Crate (Lootable)"),
(0 ,42885, @POOL+57, 0, "Stratholme Crate (Lootable)"),
(0 ,42886, @POOL+58, 0, "Stratholme Crate (Lootable)"),
(0 ,42887, @POOL+59, 0, "Stratholme Crate (Lootable)"),
(0 ,47785, @POOL+60, 0, "Stratholme Crate (Lootable)"),
(0 ,@OGUID+0, @POOL+0, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+1, @POOL+1, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+2, @POOL+2, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+3, @POOL+3, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+4, @POOL+4, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+5, @POOL+5, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+6, @POOL+6, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+7, @POOL+7, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+8, @POOL+8, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+9, @POOL+9, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+10, @POOL+10, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+11, @POOL+11, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+12, @POOL+12, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+13, @POOL+13, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+14, @POOL+14, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+15, @POOL+15, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+16, @POOL+16, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+17, @POOL+17, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+18, @POOL+18, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+19, @POOL+19, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+20, @POOL+20, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+21, @POOL+21, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+22, @POOL+22, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+23, @POOL+23, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+24, @POOL+24, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+25, @POOL+25, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+26, @POOL+26, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+27, @POOL+27, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+28, @POOL+28, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+29, @POOL+29, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+30, @POOL+30, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+31, @POOL+31, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+32, @POOL+32, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+33, @POOL+33, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+34, @POOL+34, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+35, @POOL+35, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+36, @POOL+36, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+37, @POOL+37, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+38, @POOL+38, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+39, @POOL+39, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+40, @POOL+40, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+41, @POOL+41, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+42, @POOL+42, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+43, @POOL+43, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+44, @POOL+44, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+45, @POOL+45, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+46, @POOL+46, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+47, @POOL+47, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+48, @POOL+48, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+49, @POOL+49, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+50, @POOL+50, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+51, @POOL+51, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+52, @POOL+52, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+53, @POOL+53, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+54, @POOL+54, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+55, @POOL+55, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+56, @POOL+56, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+57, @POOL+57, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+58, @POOL+58, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+59, @POOL+59, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+60, @POOL+60, 0, "Stratholme Crate (Insects)"),
(0 ,@OGUID+61, @POOL+0, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+62, @POOL+1, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+63, @POOL+2, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+64, @POOL+3, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+65, @POOL+4, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+66, @POOL+5, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+67, @POOL+6, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+68, @POOL+7, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+69, @POOL+8, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+70, @POOL+9, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+71, @POOL+10, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+72, @POOL+11, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+73, @POOL+12, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+74, @POOL+13, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+75, @POOL+14, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+76, @POOL+15, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+77, @POOL+16, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+78, @POOL+17, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+79, @POOL+18, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+80, @POOL+19, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+81, @POOL+20, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+82, @POOL+21, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+83, @POOL+22, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+84, @POOL+23, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+85, @POOL+24, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+86, @POOL+25, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+87, @POOL+26, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+88, @POOL+27, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+89, @POOL+28, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+90, @POOL+29, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+91, @POOL+30, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+92, @POOL+31, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+93, @POOL+32, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+94, @POOL+33, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+95, @POOL+34, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+96, @POOL+35, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+97, @POOL+36, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+98, @POOL+37, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+99, @POOL+38, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+100, @POOL+39, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+101, @POOL+40, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+102, @POOL+41, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+103, @POOL+42, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+104, @POOL+43, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+105, @POOL+44, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+106, @POOL+45, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+107, @POOL+46, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+108, @POOL+47, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+109, @POOL+48, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+110, @POOL+49, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+111, @POOL+50, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+112, @POOL+51, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+113, @POOL+52, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+114, @POOL+53, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+115, @POOL+54, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+116, @POOL+55, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+117, @POOL+56, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+118, @POOL+57, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+119, @POOL+58, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+120, @POOL+59, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+121, @POOL+60, 0, "Stratholme Crate (Maggots)"),
(0 ,@OGUID+122, @POOL+0, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+123, @POOL+1, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+124, @POOL+2, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+125, @POOL+3, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+126, @POOL+4, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+127, @POOL+5, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+128, @POOL+6, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+129, @POOL+7, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+130, @POOL+8, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+131, @POOL+9, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+132, @POOL+10, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+133, @POOL+11, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+134, @POOL+12, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+135, @POOL+13, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+136, @POOL+14, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+137, @POOL+15, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+138, @POOL+16, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+139, @POOL+17, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+140, @POOL+18, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+141, @POOL+19, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+142, @POOL+20, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+143, @POOL+21, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+144, @POOL+22, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+145, @POOL+23, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+146, @POOL+24, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+147, @POOL+25, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+148, @POOL+26, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+149, @POOL+27, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+150, @POOL+28, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+151, @POOL+29, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+152, @POOL+30, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+153, @POOL+31, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+154, @POOL+32, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+155, @POOL+33, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+156, @POOL+34, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+157, @POOL+35, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+158, @POOL+36, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+159, @POOL+37, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+160, @POOL+38, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+161, @POOL+39, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+162, @POOL+40, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+163, @POOL+41, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+164, @POOL+42, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+165, @POOL+43, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+166, @POOL+44, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+167, @POOL+45, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+168, @POOL+46, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+169, @POOL+47, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+170, @POOL+48, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+171, @POOL+49, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+172, @POOL+50, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+173, @POOL+51, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+174, @POOL+52, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+175, @POOL+53, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+176, @POOL+54, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+177, @POOL+55, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+178, @POOL+56, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+179, @POOL+57, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+180, @POOL+58, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+181, @POOL+59, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+182, @POOL+60, 0, "Stratholme Crate (Rats)"),
(0 ,@OGUID+183, @POOL+0, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+184, @POOL+1, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+185, @POOL+2, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+186, @POOL+3, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+187, @POOL+4, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+188, @POOL+5, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+189, @POOL+6, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+190, @POOL+7, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+191, @POOL+8, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+192, @POOL+9, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+193, @POOL+10, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+194, @POOL+11, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+195, @POOL+12, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+196, @POOL+13, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+197, @POOL+14, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+198, @POOL+15, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+199, @POOL+16, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+200, @POOL+17, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+201, @POOL+18, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+202, @POOL+19, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+203, @POOL+20, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+204, @POOL+21, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+205, @POOL+22, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+206, @POOL+23, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+207, @POOL+24, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+208, @POOL+25, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+209, @POOL+26, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+210, @POOL+27, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+211, @POOL+28, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+212, @POOL+29, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+213, @POOL+30, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+214, @POOL+31, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+215, @POOL+32, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+216, @POOL+33, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+217, @POOL+34, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+218, @POOL+35, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+219, @POOL+36, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+220, @POOL+37, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+221, @POOL+38, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+222, @POOL+39, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+223, @POOL+40, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+224, @POOL+41, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+225, @POOL+42, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+226, @POOL+43, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+227, @POOL+44, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+228, @POOL+45, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+229, @POOL+46, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+230, @POOL+47, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+231, @POOL+48, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+232, @POOL+49, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+233, @POOL+50, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+234, @POOL+51, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+235, @POOL+52, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+236, @POOL+53, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+237, @POOL+54, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+238, @POOL+55, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+239, @POOL+56, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+240, @POOL+57, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+241, @POOL+58, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+242, @POOL+59, 0, "Stratholme Crate (Poison)"),
(0 ,@OGUID+243, @POOL+60, 0, "Stratholme Crate (Poison)");

DELETE FROM pool_template WHERE entry BETWEEN @POOL+0 AND @POOL+61;
INSERT INTO pool_template (entry, max_limit, description) VALUES
(@POOL+0, 1, 'Supply Crate 1/5'),
(@POOL+1, 1, 'Supply Crate 1/5'),
(@POOL+2, 1, 'Supply Crate 1/5'),
(@POOL+3, 1, 'Supply Crate 1/5'),
(@POOL+4, 1, 'Supply Crate 1/5'),
(@POOL+5, 1, 'Supply Crate 1/5'),
(@POOL+6, 1, 'Supply Crate 1/5'),
(@POOL+7, 1, 'Supply Crate 1/5'),
(@POOL+8, 1, 'Supply Crate 1/5'),
(@POOL+9, 1, 'Supply Crate 1/5'),
(@POOL+10, 1, 'Supply Crate 1/5'),
(@POOL+11, 1, 'Supply Crate 1/5'),
(@POOL+12, 1, 'Supply Crate 1/5'),
(@POOL+13, 1, 'Supply Crate 1/5'),
(@POOL+14, 1, 'Supply Crate 1/5'),
(@POOL+15, 1, 'Supply Crate 1/5'),
(@POOL+16, 1, 'Supply Crate 1/5'),
(@POOL+17, 1, 'Supply Crate 1/5'),
(@POOL+18, 1, 'Supply Crate 1/5'),
(@POOL+19, 1, 'Supply Crate 1/5'),
(@POOL+20, 1, 'Supply Crate 1/5'),
(@POOL+21, 1, 'Supply Crate 1/5'),
(@POOL+22, 1, 'Supply Crate 1/5'),
(@POOL+23, 1, 'Supply Crate 1/5'),
(@POOL+24, 1, 'Supply Crate 1/5'),
(@POOL+25, 1, 'Supply Crate 1/5'),
(@POOL+26, 1, 'Supply Crate 1/5'),
(@POOL+27, 1, 'Supply Crate 1/5'),
(@POOL+28, 1, 'Supply Crate 1/5'),
(@POOL+29, 1, 'Supply Crate 1/5'),
(@POOL+30, 1, 'Supply Crate 1/5'),
(@POOL+31, 1, 'Supply Crate 1/5'),
(@POOL+32, 1, 'Supply Crate 1/5'),
(@POOL+33, 1, 'Supply Crate 1/5'),
(@POOL+34, 1, 'Supply Crate 1/5'),
(@POOL+35, 1, 'Supply Crate 1/5'),
(@POOL+36, 1, 'Supply Crate 1/5'),
(@POOL+37, 1, 'Supply Crate 1/5'),
(@POOL+38, 1, 'Supply Crate 1/5'),
(@POOL+39, 1, 'Supply Crate 1/5'),
(@POOL+40, 1, 'Supply Crate 1/5'),
(@POOL+41, 1, 'Supply Crate 1/5'),
(@POOL+42, 1, 'Supply Crate 1/5'),
(@POOL+43, 1, 'Supply Crate 1/5'),
(@POOL+44, 1, 'Supply Crate 1/5'),
(@POOL+45, 1, 'Supply Crate 1/5'),
(@POOL+46, 1, 'Supply Crate 1/5'),
(@POOL+47, 1, 'Supply Crate 1/5'),
(@POOL+48, 1, 'Supply Crate 1/5'),
(@POOL+49, 1, 'Supply Crate 1/5'),
(@POOL+50, 1, 'Supply Crate 1/5'),
(@POOL+51, 1, 'Supply Crate 1/5'),
(@POOL+52, 1, 'Supply Crate 1/5'),
(@POOL+53, 1, 'Supply Crate 1/5'),
(@POOL+54, 1, 'Supply Crate 1/5'),
(@POOL+55, 1, 'Supply Crate 1/5'),
(@POOL+56, 1, 'Supply Crate 1/5'),
(@POOL+57, 1, 'Supply Crate 1/5'),
(@POOL+58, 1, 'Supply Crate 1/5'),
(@POOL+59, 1, 'Supply Crate 1/5'),
(@POOL+60, 1, 'Supply Crate 1/5'),
(@POOL+61, 1, 'Supply Crate 1/5');

DELETE FROM gameobject WHERE id IN(176224,176304,176307,176308,176309);
INSERT INTO gameobject (guid, id, map, zoneId, areaId, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state, ScriptName, VerifiedBuild) VALUES
(20959, 176224, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(20960, 176224, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(21114, 176224, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 180, 100, 1, '', 0),
(21115, 176224, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 180, 100, 1, '', 0),
(21116, 176224, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(21156, 176224, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(22022, 176224, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 180, 100, 1, '', 0),
(22023, 176224, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 180, 100, 1, '', 0),
(22030, 176224, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 180, 100, 1, '', 0),
(22031, 176224, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 180, 100, 1, '', 0),
(22032, 176224, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 180, 100, 1, '', 0),
(22033, 176224, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 180, 100, 1, '', 0),
(29194, 176224, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 180, 100, 1, '', 0),
(29204, 176224, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(29659, 176224, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 180, 100, 1, '', 0),
(29805, 176224, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 180, 100, 1, '', 0),
(31986, 176224, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 180, 100, 1, '', 0),
(31987, 176224, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 180, 100, 1, '', 0),
(35461, 176224, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(35475, 176224, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 180, 100, 1, '', 0),
(35789, 176224, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 180, 100, 1, '', 0),
(35791, 176224, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 180, 100, 1, '', 0),
(35796, 176224, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 180, 100, 1, '', 0),
(35835, 176224, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(35836, 176224, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 180, 100, 1, '', 0),
(35837, 176224, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 180, 100, 1, '', 0),
(35838, 176224, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 180, 100, 1, '', 0),
(35839, 176224, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(35840, 176224, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(35841, 176224, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 180, 100, 1, '', 0),
(35842, 176224, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 180, 100, 1, '', 0),
(35843, 176224, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(35844, 176224, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 180, 100, 1, '', 0),
(35845, 176224, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 180, 100, 1, '', 0),
(35846, 176224, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 180, 100, 1, '', 0),
(35847, 176224, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 180, 100, 1, '', 0),
(35849, 176224, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 180, 100, 1, '', 0),
(35850, 176224, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 180, 100, 1, '', 0),
(35851, 176224, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 180, 100, 1, '', 0),
(35852, 176224, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(35853, 176224, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 180, 100, 1, '', 0),
(35854, 176224, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 180, 100, 1, '', 0),
(35855, 176224, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 180, 100, 1, '', 0),
(35856, 176224, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 180, 100, 1, '', 0),
(35857, 176224, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(35858, 176224, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 180, 100, 1, '', 0),
(35859, 176224, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 180, 100, 1, '', 0),
(35867, 176224, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 180, 100, 1, '', 0),
(42059, 176224, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(42060, 176224, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(42450, 176224, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 180, 100, 1, '', 0),
(42453, 176224, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 180, 100, 1, '', 0),
(42455, 176224, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 180, 100, 1, '', 0),
(42464, 176224, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 180, 100, 1, '', 0),
(42882, 176224, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 180, 100, 1, '', 0),
(42883, 176224, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(42884, 176224, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 180, 100, 1, '', 0),
(42885, 176224, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 180, 100, 1, '', 0),
(42886, 176224, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 180, 100, 1, '', 0),
(42887, 176224, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 180, 100, 1, '', 0),
(47785, 176224, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 255, 1, '', 23706),
(@OGUID+0, 176304, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+1, 176304, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+2, 176304, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 180, 100, 1, '', 0),
(@OGUID+3, 176304, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 180, 100, 1, '', 0),
(@OGUID+4, 176304, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+5, 176304, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+6, 176304, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 180, 100, 1, '', 0),
(@OGUID+7, 176304, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 180, 100, 1, '', 0),
(@OGUID+8, 176304, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 180, 100, 1, '', 0),
(@OGUID+9, 176304, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 180, 100, 1, '', 0),
(@OGUID+10, 176304, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 180, 100, 1, '', 0),
(@OGUID+11, 176304, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 180, 100, 1, '', 0),
(@OGUID+12, 176304, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 180, 100, 1, '', 0),
(@OGUID+13, 176304, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+14, 176304, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+15, 176304, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 180, 100, 1, '', 0),
(@OGUID+16, 176304, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+17, 176304, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 180, 100, 1, '', 0),
(@OGUID+18, 176304, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+19, 176304, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 180, 100, 1, '', 0),
(@OGUID+20, 176304, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 180, 100, 1, '', 0),
(@OGUID+21, 176304, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 180, 100, 1, '', 0),
(@OGUID+22, 176304, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 180, 100, 1, '', 0),
(@OGUID+23, 176304, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+24, 176304, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 180, 100, 1, '', 0),
(@OGUID+25, 176304, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 180, 100, 1, '', 0),
(@OGUID+26, 176304, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 180, 100, 1, '', 0),
(@OGUID+27, 176304, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+28, 176304, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+29, 176304, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+30, 176304, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 180, 100, 1, '', 0),
(@OGUID+31, 176304, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+32, 176304, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 180, 100, 1, '', 0),
(@OGUID+33, 176304, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 180, 100, 1, '', 0),
(@OGUID+34, 176304, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 180, 100, 1, '', 0),
(@OGUID+35, 176304, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+36, 176304, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 180, 100, 1, '', 0),
(@OGUID+37, 176304, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 180, 100, 1, '', 0),
(@OGUID+38, 176304, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 180, 100, 1, '', 0),
(@OGUID+39, 176304, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+40, 176304, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 180, 100, 1, '', 0),
(@OGUID+41, 176304, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 180, 100, 1, '', 0),
(@OGUID+42, 176304, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 180, 100, 1, '', 0),
(@OGUID+43, 176304, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 180, 100, 1, '', 0),
(@OGUID+44, 176304, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+45, 176304, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 180, 100, 1, '', 0),
(@OGUID+46, 176304, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 180, 100, 1, '', 0),
(@OGUID+47, 176304, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 180, 100, 1, '', 0),
(@OGUID+48, 176304, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+49, 176304, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+50, 176304, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 180, 100, 1, '', 0),
(@OGUID+51, 176304, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 180, 100, 1, '', 0),
(@OGUID+52, 176304, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 180, 100, 1, '', 0),
(@OGUID+53, 176304, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 180, 100, 1, '', 0),
(@OGUID+54, 176304, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 180, 100, 1, '', 0),
(@OGUID+55, 176304, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+56, 176304, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 180, 100, 1, '', 0),
(@OGUID+57, 176304, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 180, 100, 1, '', 0),
(@OGUID+58, 176304, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 180, 100, 1, '', 0),
(@OGUID+59, 176304, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 180, 100, 1, '', 0),
(@OGUID+60, 176304, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 255, 1, '', 23706),
(@OGUID+61, 176307, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+62, 176307, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+63, 176307, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 180, 100, 1, '', 0),
(@OGUID+64, 176307, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 180, 100, 1, '', 0),
(@OGUID+65, 176307, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+66, 176307, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+67, 176307, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 180, 100, 1, '', 0),
(@OGUID+68, 176307, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 180, 100, 1, '', 0),
(@OGUID+69, 176307, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 180, 100, 1, '', 0),
(@OGUID+70, 176307, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 180, 100, 1, '', 0),
(@OGUID+71, 176307, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 180, 100, 1, '', 0),
(@OGUID+72, 176307, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 180, 100, 1, '', 0),
(@OGUID+73, 176307, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 180, 100, 1, '', 0),
(@OGUID+74, 176307, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+75, 176307, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+76, 176307, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 180, 100, 1, '', 0),
(@OGUID+77, 176307, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+78, 176307, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 180, 100, 1, '', 0),
(@OGUID+79, 176307, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+80, 176307, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 180, 100, 1, '', 0),
(@OGUID+81, 176307, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 180, 100, 1, '', 0),
(@OGUID+82, 176307, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 180, 100, 1, '', 0),
(@OGUID+83, 176307, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 180, 100, 1, '', 0),
(@OGUID+84, 176307, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+85, 176307, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 180, 100, 1, '', 0),
(@OGUID+86, 176307, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 180, 100, 1, '', 0),
(@OGUID+87, 176307, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 180, 100, 1, '', 0),
(@OGUID+88, 176307, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+89, 176307, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+90, 176307, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+91, 176307, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 180, 100, 1, '', 0),
(@OGUID+92, 176307, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+93, 176307, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 180, 100, 1, '', 0),
(@OGUID+94, 176307, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 180, 100, 1, '', 0),
(@OGUID+95, 176307, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 180, 100, 1, '', 0),
(@OGUID+96, 176307, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+97, 176307, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 180, 100, 1, '', 0),
(@OGUID+98, 176307, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 180, 100, 1, '', 0),
(@OGUID+99, 176307, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 180, 100, 1, '', 0),
(@OGUID+100, 176307, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+101, 176307, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 180, 100, 1, '', 0),
(@OGUID+102, 176307, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 180, 100, 1, '', 0),
(@OGUID+103, 176307, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 180, 100, 1, '', 0),
(@OGUID+104, 176307, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 180, 100, 1, '', 0),
(@OGUID+105, 176307, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+106, 176307, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 180, 100, 1, '', 0),
(@OGUID+107, 176307, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 180, 100, 1, '', 0),
(@OGUID+108, 176307, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 180, 100, 1, '', 0),
(@OGUID+109, 176307, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+110, 176307, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+111, 176307, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 180, 100, 1, '', 0),
(@OGUID+112, 176307, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 180, 100, 1, '', 0),
(@OGUID+113, 176307, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 180, 100, 1, '', 0),
(@OGUID+114, 176307, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 180, 100, 1, '', 0),
(@OGUID+115, 176307, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 180, 100, 1, '', 0),
(@OGUID+116, 176307, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+117, 176307, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 180, 100, 1, '', 0),
(@OGUID+118, 176307, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 180, 100, 1, '', 0),
(@OGUID+119, 176307, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 180, 100, 1, '', 0),
(@OGUID+120, 176307, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 180, 100, 1, '', 0),
(@OGUID+121, 176307, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 255, 1, '', 23706),
(@OGUID+122, 176308, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+123, 176308, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+124, 176308, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 180, 100, 1, '', 0),
(@OGUID+125, 176308, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 180, 100, 1, '', 0),
(@OGUID+126, 176308, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+127, 176308, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+128, 176308, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 180, 100, 1, '', 0),
(@OGUID+129, 176308, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 180, 100, 1, '', 0),
(@OGUID+130, 176308, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 180, 100, 1, '', 0),
(@OGUID+131, 176308, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 180, 100, 1, '', 0),
(@OGUID+132, 176308, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 180, 100, 1, '', 0),
(@OGUID+133, 176308, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 180, 100, 1, '', 0),
(@OGUID+134, 176308, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 180, 100, 1, '', 0),
(@OGUID+135, 176308, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+136, 176308, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+137, 176308, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 180, 100, 1, '', 0),
(@OGUID+138, 176308, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+139, 176308, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 180, 100, 1, '', 0),
(@OGUID+140, 176308, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+141, 176308, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 180, 100, 1, '', 0),
(@OGUID+142, 176308, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 180, 100, 1, '', 0),
(@OGUID+143, 176308, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 180, 100, 1, '', 0),
(@OGUID+144, 176308, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 180, 100, 1, '', 0),
(@OGUID+145, 176308, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+146, 176308, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 180, 100, 1, '', 0),
(@OGUID+147, 176308, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 180, 100, 1, '', 0),
(@OGUID+148, 176308, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 180, 100, 1, '', 0),
(@OGUID+149, 176308, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+150, 176308, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+151, 176308, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+152, 176308, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 180, 100, 1, '', 0),
(@OGUID+153, 176308, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+154, 176308, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 180, 100, 1, '', 0),
(@OGUID+155, 176308, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 180, 100, 1, '', 0),
(@OGUID+156, 176308, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 180, 100, 1, '', 0),
(@OGUID+157, 176308, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+158, 176308, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 180, 100, 1, '', 0),
(@OGUID+159, 176308, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 180, 100, 1, '', 0),
(@OGUID+160, 176308, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 180, 100, 1, '', 0),
(@OGUID+161, 176308, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+162, 176308, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 180, 100, 1, '', 0),
(@OGUID+163, 176308, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 180, 100, 1, '', 0),
(@OGUID+164, 176308, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 180, 100, 1, '', 0),
(@OGUID+165, 176308, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 180, 100, 1, '', 0),
(@OGUID+166, 176308, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+167, 176308, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 180, 100, 1, '', 0),
(@OGUID+168, 176308, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 180, 100, 1, '', 0),
(@OGUID+169, 176308, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 180, 100, 1, '', 0),
(@OGUID+170, 176308, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+171, 176308, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+172, 176308, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 180, 100, 1, '', 0),
(@OGUID+173, 176308, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 180, 100, 1, '', 0),
(@OGUID+174, 176308, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 180, 100, 1, '', 0),
(@OGUID+175, 176308, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 180, 100, 1, '', 0),
(@OGUID+176, 176308, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 180, 100, 1, '', 0),
(@OGUID+177, 176308, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+178, 176308, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 180, 100, 1, '', 0),
(@OGUID+179, 176308, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 180, 100, 1, '', 0),
(@OGUID+180, 176308, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 180, 100, 1, '', 0),
(@OGUID+181, 176308, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 180, 100, 1, '', 0),
(@OGUID+182, 176308, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 255, 1, '', 23706),
(@OGUID+183, 176309, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+184, 176309, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+185, 176309, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 180, 100, 1, '', 0),
(@OGUID+186, 176309, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 180, 100, 1, '', 0),
(@OGUID+187, 176309, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+188, 176309, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+189, 176309, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 180, 100, 1, '', 0),
(@OGUID+190, 176309, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 180, 100, 1, '', 0),
(@OGUID+191, 176309, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 180, 100, 1, '', 0),
(@OGUID+192, 176309, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 180, 100, 1, '', 0),
(@OGUID+193, 176309, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 180, 100, 1, '', 0),
(@OGUID+194, 176309, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 180, 100, 1, '', 0),
(@OGUID+195, 176309, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 180, 100, 1, '', 0),
(@OGUID+196, 176309, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+197, 176309, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+198, 176309, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 180, 100, 1, '', 0),
(@OGUID+199, 176309, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+200, 176309, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 180, 100, 1, '', 0),
(@OGUID+201, 176309, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 180, 100, 1, '', 0),
(@OGUID+202, 176309, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 180, 100, 1, '', 0),
(@OGUID+203, 176309, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 180, 100, 1, '', 0),
(@OGUID+204, 176309, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 180, 100, 1, '', 0),
(@OGUID+205, 176309, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 180, 100, 1, '', 0),
(@OGUID+206, 176309, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 180, 100, 1, '', 0),
(@OGUID+207, 176309, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 180, 100, 1, '', 0),
(@OGUID+208, 176309, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 180, 100, 1, '', 0),
(@OGUID+209, 176309, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 180, 100, 1, '', 0),
(@OGUID+210, 176309, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+211, 176309, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 180, 100, 1, '', 0),
(@OGUID+212, 176309, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 180, 100, 1, '', 0),
(@OGUID+213, 176309, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 180, 100, 1, '', 0),
(@OGUID+214, 176309, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+215, 176309, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 180, 100, 1, '', 0),
(@OGUID+216, 176309, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 180, 100, 1, '', 0),
(@OGUID+217, 176309, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 180, 100, 1, '', 0),
(@OGUID+218, 176309, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 180, 100, 1, '', 0),
(@OGUID+219, 176309, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 180, 100, 1, '', 0),
(@OGUID+220, 176309, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 180, 100, 1, '', 0),
(@OGUID+221, 176309, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 180, 100, 1, '', 0),
(@OGUID+222, 176309, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 180, 100, 1, '', 0),
(@OGUID+223, 176309, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 180, 100, 1, '', 0),
(@OGUID+224, 176309, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 180, 100, 1, '', 0),
(@OGUID+225, 176309, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 180, 100, 1, '', 0),
(@OGUID+226, 176309, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 180, 100, 1, '', 0),
(@OGUID+227, 176309, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 180, 100, 1, '', 0),
(@OGUID+228, 176309, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 180, 100, 1, '', 0),
(@OGUID+229, 176309, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 180, 100, 1, '', 0),
(@OGUID+230, 176309, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 180, 100, 1, '', 0),
(@OGUID+231, 176309, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+232, 176309, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 180, 100, 1, '', 0),
(@OGUID+233, 176309, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 180, 100, 1, '', 0),
(@OGUID+234, 176309, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 180, 100, 1, '', 0),
(@OGUID+235, 176309, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 180, 100, 1, '', 0),
(@OGUID+236, 176309, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 180, 100, 1, '', 0),
(@OGUID+237, 176309, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 180, 100, 1, '', 0),
(@OGUID+238, 176309, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 180, 100, 1, '', 0),
(@OGUID+239, 176309, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 180, 100, 1, '', 0),
(@OGUID+240, 176309, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 180, 100, 1, '', 0),
(@OGUID+241, 176309, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 180, 100, 1, '', 0),
(@OGUID+242, 176309, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 180, 100, 1, '', 0),
(@OGUID+243, 176309, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 255, 1, '', 23706);

After lots of testing I managed to do this:

  • The issue with critters is fixed
  • The crates must be destroyed + trap activated when the gob is clicked=opened (this is not working)

The issue here is this gobs are GAMEOBJECT_TYPE_CHEST = 3 with data0=0 open (LockId from Lock.dbc) and for unknown reason when you try to open this kind of chests it will tells you "wrong target" and it will not open.
If I change Data0 to something else like normal chest that have opening time and no key, everything works fine with the trap casting the spell, the gob doing the animation ect..

@xvwyh any Idea why this chests with no lockID throw an error when I try to open them ?

``sql UPDATEspell_dbcSETEffect1=28,EffectMiscValueB1=64 WHEREId=16371; UPDATEgameobject_template_addonSETfaction=168 WHEREentryIN (175535, 175536, 175534, 175537); UPDATEgameobject_templateSETData2=0 WHEREentryIN (175534,175535,175536,175537); -- remove traps range as they must be activated by themain gob -- SAI for test purpose -- UPDATEgameobject_templateSETAIName='SmartGameObjectAI' WHEREentryIN (176304, 176307, 176308, 176309); -- DELETE FROMsmart_scriptsWHEREentryorguidIN (176304, 176307, 176308, 176309) ANDsource_type=1; -- INSERT INTOsmart_scripts(entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,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
-- (176307, 1, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Changed - set state'),
-- (176308, 1, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Changed - set state'),
-- (176304, 1, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Changed - set state'),
-- (176309, 1, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 118, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On On State Changed - set state');

-- Plagued Insect (10461)
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=10461;
DELETE FROM smart_scripts WHERE entryorguid=10461 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10461, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16460, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Insect - In Combat - Cast Festering Bite'),
(10461, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Insect - Just summoned - React aggressive');

-- Plagued Maggot (10536)
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=10536;
DELETE FROM smart_scripts WHERE entryorguid=10536 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10536, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16449, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Maggot - In Combat - Cast Maggot Slime'),
(10536, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Maggot - Just summoned - React aggressive');
-- Plagued Rat (10441)
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=10441;
DELETE FROM smart_scripts WHERE entryorguid=10441 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10441, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16448, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Rat - In Combat - Cast Black Rot'),
(10441, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Rat - Just summoned - React aggressive');

any Idea why this chests with no lockID throw an error when I try to open them ?

Clear your cache. If it doesn't help - you will have to search for the issue in TC yourselves, my server just silently does nothing. For me the client sends CMSG_GAMEOBJ_USE when I try to click on a lock-less GO, it then calls GameObject::Use on the server and absolutely nothing happens. If for you the client attempts to cast a spell - your client thinks the GO has a lock, because it cached it while it still had a lock on the server, which you then presumably removed, but the client doesn't know about this.

UPDATEgameobject_templateSETData2=0 WHEREentryIN (175534,175535,175536,175537); -- remove traps range as they must be activated by themain gob

This is WRONG, remove this. Traps MUST be triggered by proximity, NOT by players interacting with Supply Crates. Source: I'm playing classic, and I'm sick of people spawning critters out of crates and keeping me in combat :D.

Crates do absolutely nothing, they're just decoys that are supposed to bait players to come close to them, at which point the trap will trigger and the crate must despawn (which would play a breaking animation) - THIS is what you need to script, nothing else. Just make a script for every trap to despawn the closest Supply Crate upon triggering.

Also, before you ask, both crates and traps are supposed to be visible. Traps have 1% larger size, which makes them take priority over crates when hovering your mouse over them. When a player gets close enough to a trap to "detect" it (it's a stealthed trap) - the 1% larger trap model will appear and the players will get "Requires Disarm Trap" in its tooltip, alerting them that the crate is trapped, and they need to back away. If, however, they come to close to the trap - it triggers and they suffer the consequences.

Thanks, it was just client cache issue.

As for

UPDATEcreature_templateSETtype='6' WHEREentryin(10461,10441,10536);

This is also correct incorrect (my bad, I thought 6 was critter): they have "critter" type on classic
image
and additionally don't have nameplates:
image
(which makes them freaking annoying to target)

This works fine:
``sql UPDATEspell_dbcSETEffect1=28,EffectMiscValueB1=64 WHEREId=16371; UPDATEgameobject_template_addonSETfaction=168 WHEREentryIN (175535, 175536, 175534, 175537); UPDATEgameobject_templateSETAIName='SmartGameObjectAI' WHEREentryIN (175535, 175536, 175534, 175537); DELETE FROMsmart_scriptsWHEREentryorguidIN (175535, 175536, 175534, 175537) ANDsource_type=1; INSERT INTOsmart_scripts(entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,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
(175535, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176304, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn'),
(175536, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176307, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn'),
(175534, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176308, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn'),
(175537, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176309, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn');

-- Plagued Insect (10461)
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=10461;
DELETE FROM smart_scripts WHERE entryorguid=10461 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10461, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16460, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Insect - In Combat - Cast Festering Bite'),
(10461, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Insect - Just summoned - React aggressive');

-- Plagued Maggot (10536)
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=10536;
DELETE FROM smart_scripts WHERE entryorguid=10536 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10536, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16449, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Maggot - In Combat - Cast Maggot Slime'),
(10536, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Maggot - Just summoned - React aggressive');
-- Plagued Rat (10441)
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=10441;
DELETE FROM smart_scripts WHERE entryorguid=10441 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10441, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16448, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Rat - In Combat - Cast Black Rot'),
(10441, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Rat - Just summoned - React aggressive');

Yup, that's exactly the same SAI script that I just came up with when attempting to get them to work too. Changing loot state in the event to 3, and removing despawn delays and unnecessary extra actions. Works for both triggering the trap and disarming it, for me at least.

The only contentious point is respawn times. I don't think 3 minutes is ok. Stratholme run can take hours to clear, and I haven't seen any of the crates respawn on my way back, so I would assume that respawn is at least several hours long, if they can respawn at all.

Yes, I don't think they must respawn at all

Together with instance reset?

With just using action 41 you still see effect of crate been destroyed but no sound

That's correct, it's not supposed to have any sound. :)

So everything looks good until I add the pooling, then crates will no longer deswpawn once the visual destruction happen https://imgur.com/dy9kN6y

``` sql

UPDATE spell_dbc SET Effect1=28,EffectMiscValueB1=64 WHERE Id=16371;
UPDATE gameobject_template_addon SET faction=168 WHERE entry IN (175535, 175536, 175534, 175537);
UPDATE gameobject_template SET AIName='SmartGameObjectAI' WHERE entryIN (175535, 175536, 175534, 175537);
DELETE FROM smart_scripts WHERE entryorguidIN (175535, 175536, 175534, 175537) AND source_type=1;
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, 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
(175535, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176304, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn'),
(175536, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176307, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn'),
(175534, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176308, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn'),
(175537, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 176309, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Despawn');

-- Plagued Insect (10461)
UPDATE creature_template SET AIName='SmartAI' WHERE entry=10461;
DELETE FROM smart_scripts WHERE entryorguid=10461 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10461, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16460, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Insect - In Combat - Cast Festering Bite'),
(10461, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Insect - Just summoned - React aggressive');

-- Plagued Maggot (10536)
UPDATE creature_template SET AIName='SmartAI' WHERE entry=10536;
DELETE FROM smart_scripts WHERE entryorguid=10536 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10536, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16449, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Maggot - In Combat - Cast Maggot Slime'),
(10536, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Maggot - Just summoned - React aggressive');
-- Plagued Rat (10441)
UPDATE creature_template SET AIName='SmartAI' WHERE entry=10441;
DELETE FROM smart_scripts WHERE entryorguid=10441 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(10441, 0, 0, 0, 0, 0, 100, 0, 1000, 9000, 10000, 15000, 11, 16448, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Plagued Rat - In Combat - Cast Black Rot'),
(10441, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Plagued Rat - Just summoned - React aggressive');

SET @POOL := 700;
SET @OGUID := 92064;
DELETE FROM pool_members WHERE spawnId IN(20959,20960,21114,21115,21116,21156,22022,22023,22030,22031,22032,22033,29194,29204,29659,29805,31986,31987,35461,35475,35789,35791,35796,35835,35836,35837,35838,35839,35840,35841,35842,35843,35844,35845,35846,35847,35849,35850,35851,35852,35853,35854,35855,35856,35857,35858,35859,35867,42059,42060,42450,42453,42455,42464,42882,42883,42884,42885,42886,42887,47785);
DELETE FROM pool_members WHERE spawnId BETWEEN @OGUID+0 AND @OGUID+243;
DELETE FROM pool_members WHERE poolSpawnId BETWEEN @POOL+0 AND @POOL+61;
INSERT INTO pool_members (type, spawnId, poolSpawnId, chance, description) VALUES
(1, 20959, @POOL+0, 0, "Stratholme Crate (Lootable)"),
(1, 20960, @POOL+1, 0, "Stratholme Crate (Lootable)"),
(1, 21114, @POOL+2, 0, "Stratholme Crate (Lootable)"),
(1, 21115, @POOL+3, 0, "Stratholme Crate (Lootable)"),
(1, 21116, @POOL+4, 0, "Stratholme Crate (Lootable)"),
(1, 21156, @POOL+5, 0, "Stratholme Crate (Lootable)"),
(1, 22022, @POOL+6, 0, "Stratholme Crate (Lootable)"),
(1, 22023, @POOL+7, 0, "Stratholme Crate (Lootable)"),
(1, 22030, @POOL+8, 0, "Stratholme Crate (Lootable)"),
(1, 22031, @POOL+9, 0, "Stratholme Crate (Lootable)"),
(1, 22032, @POOL+10, 0, "Stratholme Crate (Lootable)"),
(1, 22033, @POOL+11, 0, "Stratholme Crate (Lootable)"),
(1, 29194, @POOL+12, 0, "Stratholme Crate (Lootable)"),
(1, 29204, @POOL+13, 0, "Stratholme Crate (Lootable)"),
(1, 29659, @POOL+14, 0, "Stratholme Crate (Lootable)"),
(1, 29805, @POOL+15, 0, "Stratholme Crate (Lootable)"),
(1, 31986, @POOL+16, 0, "Stratholme Crate (Lootable)"),
(1, 31987, @POOL+17, 0, "Stratholme Crate (Lootable)"),
(1, 35461, @POOL+18, 0, "Stratholme Crate (Lootable)"),
(1, 35475, @POOL+19, 0, "Stratholme Crate (Lootable)"),
(1, 35789, @POOL+20, 0, "Stratholme Crate (Lootable)"),
(1, 35791, @POOL+21, 0, "Stratholme Crate (Lootable)"),
(1, 35796, @POOL+22, 0, "Stratholme Crate (Lootable)"),
(1, 35835, @POOL+23, 0, "Stratholme Crate (Lootable)"),
(1, 35836, @POOL+24, 0, "Stratholme Crate (Lootable)"),
(1, 35837, @POOL+25, 0, "Stratholme Crate (Lootable)"),
(1, 35838, @POOL+26, 0, "Stratholme Crate (Lootable)"),
(1, 35839, @POOL+27, 0, "Stratholme Crate (Lootable)"),
(1, 35840, @POOL+28, 0, "Stratholme Crate (Lootable)"),
(1, 35841, @POOL+29, 0, "Stratholme Crate (Lootable)"),
(1, 35842, @POOL+30, 0, "Stratholme Crate (Lootable)"),
(1, 35843, @POOL+31, 0, "Stratholme Crate (Lootable)"),
(1, 35844, @POOL+32, 0, "Stratholme Crate (Lootable)"),
(1, 35845, @POOL+33, 0, "Stratholme Crate (Lootable)"),
(1, 35846, @POOL+34, 0, "Stratholme Crate (Lootable)"),
(1, 35847, @POOL+35, 0, "Stratholme Crate (Lootable)"),
(1, 35849, @POOL+36, 0, "Stratholme Crate (Lootable)"),
(1, 35850, @POOL+37, 0, "Stratholme Crate (Lootable)"),
(1, 35851, @POOL+38, 0, "Stratholme Crate (Lootable)"),
(1, 35852, @POOL+39, 0, "Stratholme Crate (Lootable)"),
(1, 35853, @POOL+40, 0, "Stratholme Crate (Lootable)"),
(1, 35854, @POOL+41, 0, "Stratholme Crate (Lootable)"),
(1, 35855, @POOL+42, 0, "Stratholme Crate (Lootable)"),
(1, 35856, @POOL+43, 0, "Stratholme Crate (Lootable)"),
(1, 35857, @POOL+44, 0, "Stratholme Crate (Lootable)"),
(1, 35858, @POOL+45, 0, "Stratholme Crate (Lootable)"),
(1, 35859, @POOL+46, 0, "Stratholme Crate (Lootable)"),
(1, 35867, @POOL+47, 0, "Stratholme Crate (Lootable)"),
(1, 42059, @POOL+48, 0, "Stratholme Crate (Lootable)"),
(1, 42060, @POOL+49, 0, "Stratholme Crate (Lootable)"),
(1, 42450, @POOL+50, 0, "Stratholme Crate (Lootable)"),
(1, 42453, @POOL+51, 0, "Stratholme Crate (Lootable)"),
(1, 42455, @POOL+52, 0, "Stratholme Crate (Lootable)"),
(1, 42464, @POOL+53, 0, "Stratholme Crate (Lootable)"),
(1, 42882, @POOL+54, 0, "Stratholme Crate (Lootable)"),
(1, 42883, @POOL+55, 0, "Stratholme Crate (Lootable)"),
(1, 42884, @POOL+56, 0, "Stratholme Crate (Lootable)"),
(1, 42885, @POOL+57, 0, "Stratholme Crate (Lootable)"),
(1, 42886, @POOL+58, 0, "Stratholme Crate (Lootable)"),
(1, 42887, @POOL+59, 0, "Stratholme Crate (Lootable)"),
(1, 47785, @POOL+60, 0, "Stratholme Crate (Lootable)"),
(1, @OGUID+0, @POOL+0, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+1, @POOL+1, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+2, @POOL+2, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+3, @POOL+3, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+4, @POOL+4, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+5, @POOL+5, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+6, @POOL+6, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+7, @POOL+7, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+8, @POOL+8, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+9, @POOL+9, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+10, @POOL+10, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+11, @POOL+11, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+12, @POOL+12, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+13, @POOL+13, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+14, @POOL+14, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+15, @POOL+15, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+16, @POOL+16, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+17, @POOL+17, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+18, @POOL+18, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+19, @POOL+19, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+20, @POOL+20, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+21, @POOL+21, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+22, @POOL+22, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+23, @POOL+23, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+24, @POOL+24, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+25, @POOL+25, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+26, @POOL+26, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+27, @POOL+27, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+28, @POOL+28, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+29, @POOL+29, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+30, @POOL+30, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+31, @POOL+31, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+32, @POOL+32, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+33, @POOL+33, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+34, @POOL+34, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+35, @POOL+35, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+36, @POOL+36, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+37, @POOL+37, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+38, @POOL+38, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+39, @POOL+39, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+40, @POOL+40, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+41, @POOL+41, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+42, @POOL+42, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+43, @POOL+43, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+44, @POOL+44, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+45, @POOL+45, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+46, @POOL+46, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+47, @POOL+47, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+48, @POOL+48, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+49, @POOL+49, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+50, @POOL+50, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+51, @POOL+51, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+52, @POOL+52, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+53, @POOL+53, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+54, @POOL+54, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+55, @POOL+55, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+56, @POOL+56, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+57, @POOL+57, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+58, @POOL+58, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+59, @POOL+59, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+60, @POOL+60, 0, "Stratholme Crate (Insects)"),
(1, @OGUID+61, @POOL+0, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+62, @POOL+1, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+63, @POOL+2, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+64, @POOL+3, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+65, @POOL+4, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+66, @POOL+5, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+67, @POOL+6, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+68, @POOL+7, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+69, @POOL+8, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+70, @POOL+9, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+71, @POOL+10, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+72, @POOL+11, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+73, @POOL+12, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+74, @POOL+13, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+75, @POOL+14, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+76, @POOL+15, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+77, @POOL+16, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+78, @POOL+17, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+79, @POOL+18, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+80, @POOL+19, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+81, @POOL+20, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+82, @POOL+21, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+83, @POOL+22, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+84, @POOL+23, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+85, @POOL+24, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+86, @POOL+25, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+87, @POOL+26, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+88, @POOL+27, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+89, @POOL+28, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+90, @POOL+29, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+91, @POOL+30, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+92, @POOL+31, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+93, @POOL+32, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+94, @POOL+33, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+95, @POOL+34, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+96, @POOL+35, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+97, @POOL+36, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+98, @POOL+37, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+99, @POOL+38, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+100, @POOL+39, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+101, @POOL+40, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+102, @POOL+41, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+103, @POOL+42, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+104, @POOL+43, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+105, @POOL+44, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+106, @POOL+45, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+107, @POOL+46, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+108, @POOL+47, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+109, @POOL+48, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+110, @POOL+49, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+111, @POOL+50, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+112, @POOL+51, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+113, @POOL+52, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+114, @POOL+53, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+115, @POOL+54, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+116, @POOL+55, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+117, @POOL+56, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+118, @POOL+57, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+119, @POOL+58, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+120, @POOL+59, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+121, @POOL+60, 0, "Stratholme Crate (Maggots)"),
(1, @OGUID+122, @POOL+0, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+123, @POOL+1, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+124, @POOL+2, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+125, @POOL+3, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+126, @POOL+4, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+127, @POOL+5, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+128, @POOL+6, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+129, @POOL+7, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+130, @POOL+8, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+131, @POOL+9, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+132, @POOL+10, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+133, @POOL+11, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+134, @POOL+12, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+135, @POOL+13, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+136, @POOL+14, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+137, @POOL+15, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+138, @POOL+16, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+139, @POOL+17, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+140, @POOL+18, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+141, @POOL+19, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+142, @POOL+20, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+143, @POOL+21, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+144, @POOL+22, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+145, @POOL+23, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+146, @POOL+24, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+147, @POOL+25, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+148, @POOL+26, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+149, @POOL+27, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+150, @POOL+28, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+151, @POOL+29, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+152, @POOL+30, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+153, @POOL+31, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+154, @POOL+32, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+155, @POOL+33, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+156, @POOL+34, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+157, @POOL+35, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+158, @POOL+36, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+159, @POOL+37, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+160, @POOL+38, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+161, @POOL+39, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+162, @POOL+40, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+163, @POOL+41, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+164, @POOL+42, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+165, @POOL+43, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+166, @POOL+44, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+167, @POOL+45, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+168, @POOL+46, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+169, @POOL+47, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+170, @POOL+48, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+171, @POOL+49, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+172, @POOL+50, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+173, @POOL+51, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+174, @POOL+52, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+175, @POOL+53, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+176, @POOL+54, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+177, @POOL+55, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+178, @POOL+56, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+179, @POOL+57, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+180, @POOL+58, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+181, @POOL+59, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+182, @POOL+60, 0, "Stratholme Crate (Rats)"),
(1, @OGUID+183, @POOL+0, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+184, @POOL+1, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+185, @POOL+2, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+186, @POOL+3, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+187, @POOL+4, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+188, @POOL+5, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+189, @POOL+6, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+190, @POOL+7, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+191, @POOL+8, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+192, @POOL+9, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+193, @POOL+10, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+194, @POOL+11, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+195, @POOL+12, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+196, @POOL+13, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+197, @POOL+14, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+198, @POOL+15, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+199, @POOL+16, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+200, @POOL+17, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+201, @POOL+18, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+202, @POOL+19, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+203, @POOL+20, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+204, @POOL+21, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+205, @POOL+22, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+206, @POOL+23, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+207, @POOL+24, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+208, @POOL+25, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+209, @POOL+26, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+210, @POOL+27, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+211, @POOL+28, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+212, @POOL+29, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+213, @POOL+30, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+214, @POOL+31, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+215, @POOL+32, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+216, @POOL+33, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+217, @POOL+34, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+218, @POOL+35, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+219, @POOL+36, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+220, @POOL+37, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+221, @POOL+38, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+222, @POOL+39, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+223, @POOL+40, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+224, @POOL+41, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+225, @POOL+42, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+226, @POOL+43, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+227, @POOL+44, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+228, @POOL+45, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+229, @POOL+46, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+230, @POOL+47, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+231, @POOL+48, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+232, @POOL+49, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+233, @POOL+50, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+234, @POOL+51, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+235, @POOL+52, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+236, @POOL+53, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+237, @POOL+54, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+238, @POOL+55, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+239, @POOL+56, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+240, @POOL+57, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+241, @POOL+58, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+242, @POOL+59, 0, "Stratholme Crate (Poison)"),
(1, @OGUID+243, @POOL+60, 0, "Stratholme Crate (Poison)");

DELETE FROM pool_template WHERE entry BETWEEN @POOL+0 AND @POOL+61;
INSERT INTO pool_template (entry, max_limit, description) VALUES
(@POOL+0, 1, 'Supply Crate 1/5'),
(@POOL+1, 1, 'Supply Crate 1/5'),
(@POOL+2, 1, 'Supply Crate 1/5'),
(@POOL+3, 1, 'Supply Crate 1/5'),
(@POOL+4, 1, 'Supply Crate 1/5'),
(@POOL+5, 1, 'Supply Crate 1/5'),
(@POOL+6, 1, 'Supply Crate 1/5'),
(@POOL+7, 1, 'Supply Crate 1/5'),
(@POOL+8, 1, 'Supply Crate 1/5'),
(@POOL+9, 1, 'Supply Crate 1/5'),
(@POOL+10, 1, 'Supply Crate 1/5'),
(@POOL+11, 1, 'Supply Crate 1/5'),
(@POOL+12, 1, 'Supply Crate 1/5'),
(@POOL+13, 1, 'Supply Crate 1/5'),
(@POOL+14, 1, 'Supply Crate 1/5'),
(@POOL+15, 1, 'Supply Crate 1/5'),
(@POOL+16, 1, 'Supply Crate 1/5'),
(@POOL+17, 1, 'Supply Crate 1/5'),
(@POOL+18, 1, 'Supply Crate 1/5'),
(@POOL+19, 1, 'Supply Crate 1/5'),
(@POOL+20, 1, 'Supply Crate 1/5'),
(@POOL+21, 1, 'Supply Crate 1/5'),
(@POOL+22, 1, 'Supply Crate 1/5'),
(@POOL+23, 1, 'Supply Crate 1/5'),
(@POOL+24, 1, 'Supply Crate 1/5'),
(@POOL+25, 1, 'Supply Crate 1/5'),
(@POOL+26, 1, 'Supply Crate 1/5'),
(@POOL+27, 1, 'Supply Crate 1/5'),
(@POOL+28, 1, 'Supply Crate 1/5'),
(@POOL+29, 1, 'Supply Crate 1/5'),
(@POOL+30, 1, 'Supply Crate 1/5'),
(@POOL+31, 1, 'Supply Crate 1/5'),
(@POOL+32, 1, 'Supply Crate 1/5'),
(@POOL+33, 1, 'Supply Crate 1/5'),
(@POOL+34, 1, 'Supply Crate 1/5'),
(@POOL+35, 1, 'Supply Crate 1/5'),
(@POOL+36, 1, 'Supply Crate 1/5'),
(@POOL+37, 1, 'Supply Crate 1/5'),
(@POOL+38, 1, 'Supply Crate 1/5'),
(@POOL+39, 1, 'Supply Crate 1/5'),
(@POOL+40, 1, 'Supply Crate 1/5'),
(@POOL+41, 1, 'Supply Crate 1/5'),
(@POOL+42, 1, 'Supply Crate 1/5'),
(@POOL+43, 1, 'Supply Crate 1/5'),
(@POOL+44, 1, 'Supply Crate 1/5'),
(@POOL+45, 1, 'Supply Crate 1/5'),
(@POOL+46, 1, 'Supply Crate 1/5'),
(@POOL+47, 1, 'Supply Crate 1/5'),
(@POOL+48, 1, 'Supply Crate 1/5'),
(@POOL+49, 1, 'Supply Crate 1/5'),
(@POOL+50, 1, 'Supply Crate 1/5'),
(@POOL+51, 1, 'Supply Crate 1/5'),
(@POOL+52, 1, 'Supply Crate 1/5'),
(@POOL+53, 1, 'Supply Crate 1/5'),
(@POOL+54, 1, 'Supply Crate 1/5'),
(@POOL+55, 1, 'Supply Crate 1/5'),
(@POOL+56, 1, 'Supply Crate 1/5'),
(@POOL+57, 1, 'Supply Crate 1/5'),
(@POOL+58, 1, 'Supply Crate 1/5'),
(@POOL+59, 1, 'Supply Crate 1/5'),
(@POOL+60, 1, 'Supply Crate 1/5'),
(@POOL+61, 1, 'Supply Crate 1/5');

DELETE FROM gameobject WHERE id IN(176224,176304,176307,176308,176309);
INSERT INTO gameobject (guid, id, map, zoneId, areaId, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state, ScriptName, VerifiedBuild) VALUES
(20959, 176224, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(20960, 176224, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(21114, 176224, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 7200, 100, 1, '', 0),
(21115, 176224, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 7200, 100, 1, '', 0),
(21116, 176224, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(21156, 176224, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(22022, 176224, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 7200, 100, 1, '', 0),
(22023, 176224, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 7200, 100, 1, '', 0),
(22030, 176224, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 7200, 100, 1, '', 0),
(22031, 176224, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 7200, 100, 1, '', 0),
(22032, 176224, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 7200, 100, 1, '', 0),
(22033, 176224, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 7200, 100, 1, '', 0),
(29194, 176224, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 7200, 100, 1, '', 0),
(29204, 176224, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(29659, 176224, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 7200, 100, 1, '', 0),
(29805, 176224, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 7200, 100, 1, '', 0),
(31986, 176224, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 7200, 100, 1, '', 0),
(31987, 176224, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 7200, 100, 1, '', 0),
(35461, 176224, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(35475, 176224, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 7200, 100, 1, '', 0),
(35789, 176224, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 7200, 100, 1, '', 0),
(35791, 176224, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 7200, 100, 1, '', 0),
(35796, 176224, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 7200, 100, 1, '', 0),
(35835, 176224, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(35836, 176224, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 7200, 100, 1, '', 0),
(35837, 176224, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 7200, 100, 1, '', 0),
(35838, 176224, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 7200, 100, 1, '', 0),
(35839, 176224, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(35840, 176224, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(35841, 176224, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 7200, 100, 1, '', 0),
(35842, 176224, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 7200, 100, 1, '', 0),
(35843, 176224, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(35844, 176224, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 7200, 100, 1, '', 0),
(35845, 176224, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 7200, 100, 1, '', 0),
(35846, 176224, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 7200, 100, 1, '', 0),
(35847, 176224, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 7200, 100, 1, '', 0),
(35849, 176224, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 7200, 100, 1, '', 0),
(35850, 176224, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 7200, 100, 1, '', 0),
(35851, 176224, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 7200, 100, 1, '', 0),
(35852, 176224, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(35853, 176224, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 7200, 100, 1, '', 0),
(35854, 176224, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 7200, 100, 1, '', 0),
(35855, 176224, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 7200, 100, 1, '', 0),
(35856, 176224, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 7200, 100, 1, '', 0),
(35857, 176224, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(35858, 176224, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 7200, 100, 1, '', 0),
(35859, 176224, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 7200, 100, 1, '', 0),
(35867, 176224, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 7200, 100, 1, '', 0),
(42059, 176224, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(42060, 176224, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(42450, 176224, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 7200, 100, 1, '', 0),
(42453, 176224, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 7200, 100, 1, '', 0),
(42455, 176224, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 7200, 100, 1, '', 0),
(42464, 176224, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0),
(42882, 176224, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 7200, 100, 1, '', 0),
(42883, 176224, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(42884, 176224, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 7200, 100, 1, '', 0),
(42885, 176224, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 7200, 100, 1, '', 0),
(42886, 176224, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 7200, 100, 1, '', 0),
(42887, 176224, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 7200, 100, 1, '', 0),
(47785, 176224, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 100, 1, '', 23706),
(@OGUID+0, 176304, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+1, 176304, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+2, 176304, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 7200, 100, 1, '', 0),
(@OGUID+3, 176304, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 7200, 100, 1, '', 0),
(@OGUID+4, 176304, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+5, 176304, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+6, 176304, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 7200, 100, 1, '', 0),
(@OGUID+7, 176304, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 7200, 100, 1, '', 0),
(@OGUID+8, 176304, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 7200, 100, 1, '', 0),
(@OGUID+9, 176304, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 7200, 100, 1, '', 0),
(@OGUID+10, 176304, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 7200, 100, 1, '', 0),
(@OGUID+11, 176304, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 7200, 100, 1, '', 0),
(@OGUID+12, 176304, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 7200, 100, 1, '', 0),
(@OGUID+13, 176304, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+14, 176304, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+15, 176304, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 7200, 100, 1, '', 0),
(@OGUID+16, 176304, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+17, 176304, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 7200, 100, 1, '', 0),
(@OGUID+18, 176304, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+19, 176304, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 7200, 100, 1, '', 0),
(@OGUID+20, 176304, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 7200, 100, 1, '', 0),
(@OGUID+21, 176304, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 7200, 100, 1, '', 0),
(@OGUID+22, 176304, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 7200, 100, 1, '', 0),
(@OGUID+23, 176304, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+24, 176304, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 7200, 100, 1, '', 0),
(@OGUID+25, 176304, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 7200, 100, 1, '', 0),
(@OGUID+26, 176304, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 7200, 100, 1, '', 0),
(@OGUID+27, 176304, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+28, 176304, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+29, 176304, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+30, 176304, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 7200, 100, 1, '', 0),
(@OGUID+31, 176304, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+32, 176304, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 7200, 100, 1, '', 0),
(@OGUID+33, 176304, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 7200, 100, 1, '', 0),
(@OGUID+34, 176304, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 7200, 100, 1, '', 0),
(@OGUID+35, 176304, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+36, 176304, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 7200, 100, 1, '', 0),
(@OGUID+37, 176304, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 7200, 100, 1, '', 0),
(@OGUID+38, 176304, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 7200, 100, 1, '', 0),
(@OGUID+39, 176304, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+40, 176304, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 7200, 100, 1, '', 0),
(@OGUID+41, 176304, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 7200, 100, 1, '', 0),
(@OGUID+42, 176304, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 7200, 100, 1, '', 0),
(@OGUID+43, 176304, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 7200, 100, 1, '', 0),
(@OGUID+44, 176304, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+45, 176304, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 7200, 100, 1, '', 0),
(@OGUID+46, 176304, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 7200, 100, 1, '', 0),
(@OGUID+47, 176304, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 7200, 100, 1, '', 0),
(@OGUID+48, 176304, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+49, 176304, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+50, 176304, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 7200, 100, 1, '', 0),
(@OGUID+51, 176304, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 7200, 100, 1, '', 0),
(@OGUID+52, 176304, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 7200, 100, 1, '', 0),
(@OGUID+53, 176304, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+54, 176304, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 7200, 100, 1, '', 0),
(@OGUID+55, 176304, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+56, 176304, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 7200, 100, 1, '', 0),
(@OGUID+57, 176304, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 7200, 100, 1, '', 0),
(@OGUID+58, 176304, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 7200, 100, 1, '', 0),
(@OGUID+59, 176304, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 7200, 100, 1, '', 0),
(@OGUID+60, 176304, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 100, 1, '', 23706),
(@OGUID+61, 176307, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+62, 176307, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+63, 176307, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 7200, 100, 1, '', 0),
(@OGUID+64, 176307, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 7200, 100, 1, '', 0),
(@OGUID+65, 176307, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+66, 176307, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+67, 176307, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 7200, 100, 1, '', 0),
(@OGUID+68, 176307, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 7200, 100, 1, '', 0),
(@OGUID+69, 176307, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 7200, 100, 1, '', 0),
(@OGUID+70, 176307, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 7200, 100, 1, '', 0),
(@OGUID+71, 176307, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 7200, 100, 1, '', 0),
(@OGUID+72, 176307, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 7200, 100, 1, '', 0),
(@OGUID+73, 176307, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 7200, 100, 1, '', 0),
(@OGUID+74, 176307, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+75, 176307, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+76, 176307, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 7200, 100, 1, '', 0),
(@OGUID+77, 176307, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+78, 176307, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 7200, 100, 1, '', 0),
(@OGUID+79, 176307, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+80, 176307, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 7200, 100, 1, '', 0),
(@OGUID+81, 176307, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 7200, 100, 1, '', 0),
(@OGUID+82, 176307, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 7200, 100, 1, '', 0),
(@OGUID+83, 176307, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 7200, 100, 1, '', 0),
(@OGUID+84, 176307, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+85, 176307, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 7200, 100, 1, '', 0),
(@OGUID+86, 176307, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 7200, 100, 1, '', 0),
(@OGUID+87, 176307, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 7200, 100, 1, '', 0),
(@OGUID+88, 176307, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+89, 176307, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+90, 176307, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+91, 176307, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 7200, 100, 1, '', 0),
(@OGUID+92, 176307, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+93, 176307, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 7200, 100, 1, '', 0),
(@OGUID+94, 176307, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 7200, 100, 1, '', 0),
(@OGUID+95, 176307, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 7200, 100, 1, '', 0),
(@OGUID+96, 176307, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+97, 176307, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 7200, 100, 1, '', 0),
(@OGUID+98, 176307, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 7200, 100, 1, '', 0),
(@OGUID+99, 176307, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 7200, 100, 1, '', 0),
(@OGUID+100, 176307, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+101, 176307, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 7200, 100, 1, '', 0),
(@OGUID+102, 176307, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 7200, 100, 1, '', 0),
(@OGUID+103, 176307, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 7200, 100, 1, '', 0),
(@OGUID+104, 176307, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 7200, 100, 1, '', 0),
(@OGUID+105, 176307, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+106, 176307, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 7200, 100, 1, '', 0),
(@OGUID+107, 176307, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 7200, 100, 1, '', 0),
(@OGUID+108, 176307, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 7200, 100, 1, '', 0),
(@OGUID+109, 176307, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+110, 176307, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+111, 176307, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 7200, 100, 1, '', 0),
(@OGUID+112, 176307, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 7200, 100, 1, '', 0),
(@OGUID+113, 176307, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 7200, 100, 1, '', 0),
(@OGUID+114, 176307, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+115, 176307, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 7200, 100, 1, '', 0),
(@OGUID+116, 176307, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+117, 176307, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 7200, 100, 1, '', 0),
(@OGUID+118, 176307, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 7200, 100, 1, '', 0),
(@OGUID+119, 176307, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 7200, 100, 1, '', 0),
(@OGUID+120, 176307, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 7200, 100, 1, '', 0),
(@OGUID+121, 176307, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 100, 1, '', 23706),
(@OGUID+122, 176308, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+123, 176308, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+124, 176308, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 7200, 100, 1, '', 0),
(@OGUID+125, 176308, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 7200, 100, 1, '', 0),
(@OGUID+126, 176308, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+127, 176308, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+128, 176308, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 7200, 100, 1, '', 0),
(@OGUID+129, 176308, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 7200, 100, 1, '', 0),
(@OGUID+130, 176308, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 7200, 100, 1, '', 0),
(@OGUID+131, 176308, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 7200, 100, 1, '', 0),
(@OGUID+132, 176308, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 7200, 100, 1, '', 0),
(@OGUID+133, 176308, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 7200, 100, 1, '', 0),
(@OGUID+134, 176308, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 7200, 100, 1, '', 0),
(@OGUID+135, 176308, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+136, 176308, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+137, 176308, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 7200, 100, 1, '', 0),
(@OGUID+138, 176308, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+139, 176308, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 7200, 100, 1, '', 0),
(@OGUID+140, 176308, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+141, 176308, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 7200, 100, 1, '', 0),
(@OGUID+142, 176308, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 7200, 100, 1, '', 0),
(@OGUID+143, 176308, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 7200, 100, 1, '', 0),
(@OGUID+144, 176308, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 7200, 100, 1, '', 0),
(@OGUID+145, 176308, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+146, 176308, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 7200, 100, 1, '', 0),
(@OGUID+147, 176308, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 7200, 100, 1, '', 0),
(@OGUID+148, 176308, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 7200, 100, 1, '', 0),
(@OGUID+149, 176308, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+150, 176308, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+151, 176308, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+152, 176308, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 7200, 100, 1, '', 0),
(@OGUID+153, 176308, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+154, 176308, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 7200, 100, 1, '', 0),
(@OGUID+155, 176308, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 7200, 100, 1, '', 0),
(@OGUID+156, 176308, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 7200, 100, 1, '', 0),
(@OGUID+157, 176308, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+158, 176308, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 7200, 100, 1, '', 0),
(@OGUID+159, 176308, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 7200, 100, 1, '', 0),
(@OGUID+160, 176308, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 7200, 100, 1, '', 0),
(@OGUID+161, 176308, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+162, 176308, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 7200, 100, 1, '', 0),
(@OGUID+163, 176308, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 7200, 100, 1, '', 0),
(@OGUID+164, 176308, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 7200, 100, 1, '', 0),
(@OGUID+165, 176308, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 7200, 100, 1, '', 0),
(@OGUID+166, 176308, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+167, 176308, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 7200, 100, 1, '', 0),
(@OGUID+168, 176308, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 7200, 100, 1, '', 0),
(@OGUID+169, 176308, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 7200, 100, 1, '', 0),
(@OGUID+170, 176308, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+171, 176308, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+172, 176308, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 7200, 100, 1, '', 0),
(@OGUID+173, 176308, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 7200, 100, 1, '', 0),
(@OGUID+174, 176308, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 7200, 100, 1, '', 0),
(@OGUID+175, 176308, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+176, 176308, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 7200, 100, 1, '', 0),
(@OGUID+177, 176308, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+178, 176308, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 7200, 100, 1, '', 0),
(@OGUID+179, 176308, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 7200, 100, 1, '', 0),
(@OGUID+180, 176308, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 7200, 100, 1, '', 0),
(@OGUID+181, 176308, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 7200, 100, 1, '', 0),
(@OGUID+182, 176308, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 100, 1, '', 23706),
(@OGUID+183, 176309, 329, 0, 0, 1, 1, 3584.93, -3482.1, 135.124, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+184, 176309, 329, 0, 0, 1, 1, 3508.78, -3372.3, 135.379, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+185, 176309, 329, 0, 0, 1, 1, 3973.62, -3619.9, 129.999, -2.37365, 0, 0, -0.927184, 0.374606, 7200, 100, 1, '', 0),
(@OGUID+186, 176309, 329, 0, 0, 1, 1, 3486.79, -3331.54, 131.38, 1.46608, 0, 0, 0.669132, 0.743144, 7200, 100, 1, '', 0),
(@OGUID+187, 176309, 329, 0, 0, 1, 1, 3961.73, -3539.9, 127.744, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+188, 176309, 329, 0, 0, 1, 1, 3666.63, -3182.46, 126.252, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+189, 176309, 329, 0, 0, 1, 1, 3877.03, -3663.46, 143.9, -1.67552, 0, 0, -0.743146, 0.669129, 7200, 100, 1, '', 0),
(@OGUID+190, 176309, 329, 0, 0, 1, 1, 3636.53, -3347.54, 125.592, 0.715585, 0, 0, 0.350207, 0.936672, 7200, 100, 1, '', 0),
(@OGUID+191, 176309, 329, 0, 0, 1, 1, 3888.71, -3699.08, 143.85, -0.383972, 0, 0, -0.190809, 0.981627, 7200, 100, 1, '', 0),
(@OGUID+192, 176309, 329, 0, 0, 1, 1, 4104.72, -3435.93, 117.802, 2.74017, 0, 0, 0.979925, 0.199366, 7200, 100, 1, '', 0),
(@OGUID+193, 176309, 329, 0, 0, 1, 1, 3892.38, -3563.78, 138.099, -2.28638, 0, 0, -0.909961, 0.414694, 7200, 100, 1, '', 0),
(@OGUID+194, 176309, 329, 0, 0, 1, 1, 3738.43, -3477.54, 131.393, -2.86234, 0, 0, -0.990268, 0.139173, 7200, 100, 1, '', 0),
(@OGUID+195, 176309, 329, 0, 0, 1, 1, 3599.32, -3460.67, 136.472, -2.21657, 0, 0, -0.894935, 0.446197, 7200, 100, 1, '', 0),
(@OGUID+196, 176309, 329, 0, 0, 1, 1, 3476.95, -3363.85, 136.242, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+197, 176309, 329, 0, 0, 1, 1, 3952.68, -3632.92, 133.41, -2.51327, 0, 0, -0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+198, 176309, 329, 0, 0, 1, 1, 3581.11, -3351, 129.513, 1.6057, 0, 0, 0.719339, 0.694659, 7200, 100, 1, '', 0),
(@OGUID+199, 176309, 329, 0, 0, 1, 1, 4062.22, -3515.15, 123.116, -2.04204, 0, 0, -0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+200, 176309, 329, 0, 0, 1, 1, 3656.34, -3210.08, 128.257, 1.44862, 0, 0, 0.662619, 0.748957, 7200, 100, 1, '', 0),
(@OGUID+201, 176309, 329, 0, 0, 1, 1, 3682.68, -3416.87, 133.312, 0.610865, 0, 0, 0.300706, 0.953717, 7200, 100, 1, '', 0),
(@OGUID+202, 176309, 329, 0, 0, 1, 1, 3668.9, -3284.14, 128.53, 0.034907, 0, 0, 0.0174526, 0.999848, 7200, 100, 1, '', 0),
(@OGUID+203, 176309, 329, 0, 0, 1, 1, 3788.89, -3624.55, 146.377, 0.314159, 0, 0, 0.156434, 0.987688, 7200, 100, 1, '', 0),
(@OGUID+204, 176309, 329, 0, 0, 1, 1, 3998.96, -3448.72, 122.307, 0.628319, 0, 0, 0.309017, 0.951056, 7200, 100, 1, '', 0),
(@OGUID+205, 176309, 329, 0, 0, 1, 1, 3880.02, -3517.12, 139.189, -2.58309, 0, 0, -0.961262, 0.275636, 7200, 100, 1, '', 0),
(@OGUID+206, 176309, 329, 0, 0, 1, 1, 3630.3, -3469.46, 138.793, -0.855212, 0, 0, -0.414694, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+207, 176309, 329, 0, 0, 1, 1, 3638.04, -3534.9, 138.45, 0, 0, 0, 0, 1, 7200, 100, 1, '', 0),
(@OGUID+208, 176309, 329, 0, 0, 1, 1, 3543.4, -3432.62, 136.636, 1.20428, 0, 0, 0.566407, 0.824125, 7200, 100, 1, '', 0),
(@OGUID+209, 176309, 329, 0, 0, 1, 1, 4011.06, -3646.39, 131.552, 0.069813, 0, 0, 0.0348994, 0.999391, 7200, 100, 1, '', 0),
(@OGUID+210, 176309, 329, 0, 0, 1, 1, 3466.64, -3298.56, 132.741, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+211, 176309, 329, 0, 0, 1, 1, 4011.67, -3518.38, 122.346, -0.698132, 0, 0, -0.34202, 0.939693, 7200, 100, 1, '', 0),
(@OGUID+212, 176309, 329, 0, 0, 1, 1, 3696.27, -3195.51, 127.796, 2.51327, 0, 0, 0.951056, 0.309019, 7200, 100, 1, '', 0),
(@OGUID+213, 176309, 329, 0, 0, 1, 1, 3665.47, -3662.99, 138.414, 2.02458, 0, 0, 0.848048, 0.52992, 7200, 100, 1, '', 0),
(@OGUID+214, 176309, 329, 0, 0, 1, 1, 3669.82, -3263.99, 127.804, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+215, 176309, 329, 0, 0, 1, 1, 3887.52, -3745.81, 142.36, 2.11185, 0, 0, 0.870356, 0.492423, 7200, 100, 1, '', 0),
(@OGUID+216, 176309, 329, 0, 0, 1, 1, 4113.99, -3383.44, 117.806, 2.98451, 0, 0, 0.996917, 0.0784606, 7200, 100, 1, '', 0),
(@OGUID+217, 176309, 329, 0, 0, 1, 1, 3862.17, -3610.11, 144.137, 2.84489, 0, 0, 0.989016, 0.147808, 7200, 100, 1, '', 0),
(@OGUID+218, 176309, 329, 0, 0, 1, 1, 3720.45, -3502.32, 130.548, 2.04204, 0, 0, 0.852641, 0.522496, 7200, 100, 1, '', 0),
(@OGUID+219, 176309, 329, 0, 0, 1, 1, 3592.94, -3512.49, 137.395, -0.663225, 0, 0, -0.325568, 0.945519, 7200, 100, 1, '', 0),
(@OGUID+220, 176309, 329, 0, 0, 1, 1, 3477.72, -3397.27, 138.636, 1.41372, 0, 0, 0.649449, 0.760405, 7200, 100, 1, '', 0),
(@OGUID+221, 176309, 329, 0, 0, 1, 1, 3968.17, -3592.17, 129.298, 0.558505, 0, 0, 0.275637, 0.961262, 7200, 100, 1, '', 0),
(@OGUID+222, 176309, 329, 0, 0, 1, 1, 3546.42, -3307.08, 130.52, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0),
(@OGUID+223, 176309, 329, 0, 0, 1, 1, 3956.05, -3570.05, 129.894, 0.767945, 0, 0, 0.374607, 0.927184, 7200, 100, 1, '', 0),
(@OGUID+224, 176309, 329, 0, 0, 1, 1, 3704.46, -3168.81, 127.617, 2.87979, 0, 0, 0.991445, 0.130528, 7200, 100, 1, '', 0),
(@OGUID+225, 176309, 329, 0, 0, 1, 1, 4095.95, -3361.53, 117.661, -2.30383, 0, 0, -0.913544, 0.406739, 7200, 100, 1, '', 0),
(@OGUID+226, 176309, 329, 0, 0, 1, 1, 3695.37, -3301.16, 128.532, 2.79253, 0, 0, 0.984808, 0.173647, 7200, 100, 1, '', 0),
(@OGUID+227, 176309, 329, 0, 0, 1, 1, 3818.95, -3687.04, 144.695, -0.10472, 0, 0, -0.0523361, 0.99863, 7200, 100, 1, '', 0),
(@OGUID+228, 176309, 329, 0, 0, 1, 1, 3973.82, -3419.91, 120.918, 1.29154, 0, 0, 0.601814, 0.798637, 7200, 100, 1, '', 0),
(@OGUID+229, 176309, 329, 0, 0, 1, 1, 3870.84, -3598.91, 143.474, 2.61799, 0, 0, 0.965925, 0.258821, 7200, 100, 1, '', 0),
(@OGUID+230, 176309, 329, 0, 0, 1, 1, 3672.29, -3523.02, 137.733, 2.6529, 0, 0, 0.970296, 0.241922, 7200, 100, 1, '', 0),
(@OGUID+231, 176309, 329, 0, 0, 1, 1, 3615.6, -3535.18, 138.505, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+232, 176309, 329, 0, 0, 1, 1, 3521.19, -3409.08, 134.254, 0.785398, 0, 0, 0.382683, 0.92388, 7200, 100, 1, '', 0),
(@OGUID+233, 176309, 329, 0, 0, 1, 1, 4009.57, -3585.86, 130.177, -1.91986, 0, 0, -0.819151, 0.573577, 7200, 100, 1, '', 0),
(@OGUID+234, 176309, 329, 0, 0, 1, 1, 3561.1, -3307.54, 130.66, -2.05949, 0, 0, -0.857168, 0.515037, 7200, 100, 1, '', 0),
(@OGUID+235, 176309, 329, 0, 0, 1, 1, 4065.88, -3548.68, 124.621, 1.43117, 0, 0, 0.656059, 0.75471, 7200, 100, 1, '', 0),
(@OGUID+236, 176309, 329, 0, 0, 1, 1, 3622.79, -3196.69, 131.094, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0),
(@OGUID+237, 176309, 329, 0, 0, 1, 1, 3711.94, -3147.64, 128.189, -2.94961, 0, 0, -0.995396, 0.095844, 7200, 100, 1, '', 0),
(@OGUID+238, 176309, 329, 0, 0, 1, 1, 3658.95, -3364.85, 126.05, -0.244346, 0, 0, -0.121869, 0.992546, 7200, 100, 1, '', 0),
(@OGUID+239, 176309, 329, 0, 0, 1, 1, 3862.64, -3663.65, 144.775, 3.10669, 0, 0, 0.999848, 0.0174505, 7200, 100, 1, '', 0),
(@OGUID+240, 176309, 329, 0, 0, 1, 1, 4066.38, -3455.35, 120.555, -1.25664, 0, 0, -0.587786, 0.809016, 7200, 100, 1, '', 0),
(@OGUID+241, 176309, 329, 0, 0, 1, 1, 3838.05, -3553.55, 140.413, 0.925024, 0, 0, 0.446198, 0.894934, 7200, 100, 1, '', 0),
(@OGUID+242, 176309, 329, 0, 0, 1, 1, 3729.11, -3450.53, 130.433, -2.1293, 0, 0, -0.874619, 0.48481, 7200, 100, 1, '', 0),
(@OGUID+243, 176309, 329, 0, 0, 1, 1, 3659.38, -3305.04, 127.062, 5.0091, 0, 0, -0.594823, 0.803857, 7200, 100, 1, '', 23706);

No idea, I also added spawns and poolings from dr-j's comments and I have no such issues, but then again I did make big changes to GO spawning/despawning in the past, might be working because of them.

My suspicion is that despawn with pooling is handled differently than regular despawn, and linked trap isn't being deleted in that case.

I suggest taking a look at this part:
https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/game/Entities/GameObject/GameObject.cpp#L924
If GO is not part of a pool - it's being physically removed from the map, and then the linked trap will be deleted here:
https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/game/Entities/GameObject/GameObject.cpp#L244
But if GO is part of a pool - I guess something different is happening: maybe GO is retained in the map in a despawned state (and thus the trap isn't deleted) until it's about to respawn, which would trigger the pool to delete the old instance and randomly select a new one to spawn.

Another hack worth trying - instead of despawning the crate in SAI - try forcibly changing it's lootstate to GO_JUST_DEACTIVATED if it's possible to do that via SAI - that should then "simulate" the crate being opened and cause it to go through a codepath in GameObject::Update that already has linked trap deletion.

Yes changing the despawn with GO_JUST_DEACTIVATED fix the issue:
``sql DELETE FROMsmart_scriptsWHEREentryorguidIN (175535, 175536, 175534, 175537) ANDsource_type=1; INSERT INTOsmart_scripts(entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,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
(175535, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176304, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated'),
(175536, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176307, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated'),
(175534, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176308, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated'),
(175537, 1, 0, 0, 70, 0, 100, 0, 3, 0, 0, 0, 99, 3, 0, 0, 0, 0, 0, 20, 176309, 0, 0, 0, 0, 0, 0, 0, 'Supply Crate (Trap) - On State Changed - Set loot state Just deactivated');

Was this page helpful?
0 / 5 - 0 ratings

Related issues

Carbenium picture Carbenium  路  47Comments

Kingswow picture Kingswow  路  55Comments

Keader picture Keader  路  119Comments

Amit86 picture Amit86  路  58Comments

Vincent-Michael picture Vincent-Michael  路  98Comments