[NPC][master] Silvermoon Guardian duplicate

[ArcaneFox]

Description:
Silvermoon Guardian spawned two times:
guid 56875 and 375662

Current behaviour: (Tell us what happens.)
Silvermoon Guardian spawned two times

Expected behaviour: (Tell us what should happen instead.)
Spawn only one Silvermoon Guardian

Steps to reproduce the problem:

1. Go to 9513.57 -6842.83 16.6175 (xyz)

Branch(es): master

TC rev. hash/commit: 1c00f0b

TDB version: 703.00 + updates

Operating system: Windows 10 64-bit

Possible Fix:
DELETE FROM creature WHERE guid=375662;

[Aokromes]

i cannot test on master db, but at least on 4.3.4 those creatures are on diff coordinates.

[ArcaneFox]

i checked the characters in the TDB_full_434.09_2014_10_19 and here is the 56875 npc:
(56875,16221,530,0,0,1,1,0,0,0,0,9513.57,-6842.83,16.6175,1.16937,300,0,0,1124,0,0,0,0,0,0)

but i could not find coordinates for the 375662

[ghost]

TrinityCore rev. c36f831 2017-01-24 00:08:12 +0100 / TDB 703.00 + updates

SELECT * FROM `creature` WHERE `guid` IN (56875,375662);

  guid      id     map  zoneId  areaId  spawnMask  PhaseId  PhaseGroup  modelid  equipment_id  position_x  position_y  position_z  orientation  spawntimesecs  spawndist  currentwaypoint  curhealth  curmana  MovementType  npcflag  unit_flags  dynamicflags  VerifiedBuild
------  ------  ------  ------  ------  ---------  -------  ----------  -------  ------------  ----------  ----------  ----------  -----------  -------------  ---------  ---------------  ---------  -------  ------------  -------  ----------  ------------  -------------
 56875   16221     530       0       0          1        0           0        0             0     9513.57    -6842.83     16.6175      1.16937            300          0                0       1124        0             0        0           0             0              0
375662   16221     530       0       0          1        0           0        0             0     9513.53    -6842.88     16.5768      1.16937            120          0                0          0        0             0        0           0             0          20886

Looks like the curhealth of 375662 is 0 ("He's dead, Jim.") -- is that the one which should be deleted?

[ArcaneFox]

yes it should be deleted/updated and there are 6 npc with 0 health and different spawntimesecs

SELECT * FROM `creature` WHERE `id` = 16221 AND `curhealth` = 0;

375660	16221	530	0	0	1	0	0	0	0	9308.29	-7134.01	16.308	5.08281	120	0	0	0	0	0	0	0	0	20886
375661	16221	530	0	0	1	0	0	0	0	9309.98	-7133.21	16.4483	5.14132	120	0	0	0	0	0	0	0	0	20886
375662	16221	530	0	0	1	0	0	0	0	9513.53	-6842.88	16.5768	1.16937	120	0	0	0	0	0	0	0	0	20886
375663	16221	530	0	0	1	0	0	0	0	9700.91	-6652.96	6.55616	3.67324	120	0	0	0	0	0	0	0	0	20886
85652	16221	530	0	0	1	0	0	0	0	9363.16	-7314.13	7.11649	5.64581	120	0	0	0	0	0	0	0	0	20886

when i have a little time i will check them ingame