[3.3.5] [cosmetic] DB/Creature: Cornish Rex Cat in Coldridge Valley

[ghost]

TDB 335.60 / commit 071ede8 -- cosmetic issue.

Ref. #9267 (comment) and observing in-game: There is a Cornish Rex Cat (ID 7384) in the dwarf / gnome starting area and I am fairly certain that it does not belong there (ref. the comment from @Alpharius):

post scriptum:
There is a cornish rex cat in dun morogh, creature.guid = 1528 creature_template.id = 7384, I think it's wrongly placed - nothing serious, just cosmetic.

I also notice that this cat is both used as a sample of one of the cat carriers you can buy from Donni Anthania <Crazy Cat Lady> near the Lion's Pride inn in Elwynn Forest and used in a SAI script for "Stinker in Love". I don't think that is related to any specific event in Coldridge Valley in Dun Morogh.

In TDB 6.03 the spawn is correct, only 1 entry in Elwynn Forest.

The cat in Dun Morogh is alone out in the cold, could someone take care of it? ;-)

SELECT ct.name, c.* FROM `creature` c LEFT JOIN `creature_template` ct ON c.id = ct.entry 
WHERE ct.name = 'Cornish Rex Cat';

name               guid      id     map  zoneId  areaId  spawnMask  phaseMask  modelid  equipment_id  position_x  position_y  position_z  orientation  spawntimesecs  spawndist  currentwaypoint  curhealth  curmana  MovementType  npcflag  unit_flags  dynamicflags  VerifiedBuild
---------------  ------  ------  ------  ------  ------  ---------  ---------  -------  ------------  ----------  ----------  ----------  -----------  -------------  ---------  ---------------  ---------  -------  ------------  -------  ----------  ------------  -------------
Cornish Rex Cat    1528    7384       0       0       0          1          1        0             0    -6271.02     305.206      382.05      5.34521            300          0                0         42        0             0        0           0             0              0
Cornish Rex Cat   79910    7384       0       0       0          1          1        0             0    -9175.33     3.87259     80.3912      4.33778            180          0                0         42        0             0        0           0             0              0

Notice that VerifiedBuild = 0, so it has not been parsed yet (not verified?).

Player selected NPC
DB GUID: 1528, current GUID: 2405.
Faction: 188.
npcFlags: 0.
Entry: 7384.
DisplayID: 5586 (Native: 5586).
Level: 1.
EquipmentId: 0 (Original: 0).
Health (base): 42. (max): 42. (current): 42.
InhabitType: 3
Unit Flags: 768
UNIT_FLAG_IMMUNE_TO_PC (0x100)
UNIT_FLAG_IMMUNE_TO_NPC (0x200)
Unit Flags 2: 2048.
Dynamic Flags: 0.
Faction Template: 188.
SpawnTime: Full:5m Remain:0s
Loot: 0 Pickpocket: 0 Skinning: 100008
InstanceID: 0
Phasemask: 1
Armor: 15
Position: -6271.020020 305.205994 382.046875.
AIName: SmartAI ScriptName:
Flags Extra: 2
CREATURE_FLAG_EXTRA_CIVILIAN (0x2)
MechanicImmuneMask: 0

Because it does not belong there and is not parsed / verified, I suggest:

-- Remove wrong spawn of Cornish Rex Cat in Dun Morogh:
DELETE FROM `creature` WHERE `guid`= 1528 and `id`= 7384;