[Wip]Rare Npc: Skoll

[CODE]
SET @NPC = 35189; – skoll
SET @CREATURE = XXXX; – DB Sniff
SET @POOL = XXXX; – DB Sniff

– Creature Attackable
UPDATE creature_template SET faction_A=1629, faction_H=1629 WHERE entry=@NPC;

– Spawn creature
DELETE FROM creature WHERE id=@NPC;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id, position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES
(@CREATURE+0, @NPC,‘571’,‘1’,‘1’,‘29673’,‘0’,‘7125,82’,‘-2104.75’,‘761,92’,‘4.655’,‘21600’,‘20’,‘0’,‘18900’,‘0’,‘1’,‘0’,‘0’,‘0’),
(@CREATURE+1, @NPC,‘571’,‘1’,‘1’,‘29673’,‘0’,‘7071,90’,‘-592,35’,‘731’,‘4,85’,‘21600’,‘5’,‘0’,‘18900’,‘0’,‘1’,‘0’,‘0’,‘0’),
(@CREATURE+2, @NPC,‘571’,‘1’,‘1’,‘29673’,‘0’,‘7779,14’,‘-154,3’,‘879,68’,‘0,51’,‘21600’,‘20’,‘0’,‘18900’,‘0’,‘1’,‘0’,‘0’,‘0’);

– NPC Spawn Pool
DELETE FROM pool_template WHERE entry=@POOL;
INSERT INTO pool_template(entry,max_limit,description) VALUES
(@POOL,1, ‘Skoll Spawn (35189)’);

DELETE FROM pool_creature WHERE pool_entry=@POOL;
INSERT INTO pool_creature(guid,pool_entry,chance,description) VALUES
(@CREATURE+0,@POOL,0, ‘Skoll Spawn 1’),
(@CREATURE+1,@POOL,0, ‘Skoll Spawn 2’),
(@CREATURE+2,@POOL,0, ‘Skoll Spawn 3’);

– Update wrong disenchant …not 68 = 100% Abyss
UPDATE item_template SET DisenchantID=54 WHERE entry=49227;
[/SQL][/CODE]

http://de.wowhead.co…7#disenchanting

Hopefully used the correct Trinity DB Syntax…suggestions are welcome

If you like it push it to git

DELETE FROM pool_template[SIZE=48px]`[/SIZE] WHERE entry=@NPC*10;

INSERT INTO pool_creature(guid,pool_entry,chance,description) VALUES

(@POOL, @NPC*10,‘0’,‘Skoll Spawn 1’),

(@POOL[SIZE=36px]+1[/SIZE], @NPC*10,‘0’,‘Skoll Spawn 2’),

(@POOL[SIZE=36px]+2[/SIZE], @NPC*10,‘0’,‘Skoll Spawn 3’);

INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id, position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES

(@CREATURE, @NPC,‘571’,‘1’,‘1’,‘29673’,‘0’,‘7125,82’,‘-2104.75’,‘761,92’,‘4.655’,‘21600’,‘20’,‘0’,‘18900’,‘0’,‘1’,‘0’,‘0’,‘0’),

(@CREATURE[SIZE=36px]+1[/SIZE], @NPC,‘571’,‘1’,‘1’,‘29673’,‘0’,‘7071,90’,‘-592,35’,‘731’,‘4,85’,‘21600’,‘5’,‘0’,‘18900’,‘0’,‘1’,‘0’,‘0’,‘0’),

(@CREATURE[SIZE=36px]+2[/SIZE], @NPC,‘571’,‘1’,‘1’,‘29673’,‘0’,‘7779,14’,‘-154,3’,‘879,68’,‘0,51’,‘21600’,‘20’,‘0’,‘18900’,‘0’,‘1’,‘0’,‘0’,‘0’);

Please, compare my changes with your original query.

Do not write quotes around numbers, creature guid needs to be different for each guid and first field on pool_creature is creature guid, not pool and it has nothing to do with creature entry * 10

ty @Amit86

ahh ty Nay for fixing my stupidity…most things happend on conveying to this page from our forum…I not needed the varibles at out server /emoticons/default_smile.png I know that the creature guids has to be different…my fault.

2 little changes Ive made…one quote deleted and changed the delete from pool_creature…so it should work fine now

trying to give something back to community

Where does the faction come from? These have to be sniffed. :confused:

EDIT.

Faction should be 1629 according to sniffs.

[3] UNIT_FIELD_FACTIONTEMPLATE: 1629/2.282715E-42

  • your creature insert has an error “Column count doesn’t match value count at row 1” i think you missed some data

column error fixed…whyever…

but Im not sure…the faction I sniffed from another mob…how do you get 1629 ? Isn´t it PLAYER, Draenei Faction ? Im quite unsure with factions and most of the time I look for similar mobs and take these factions…but I know it isnt the correct way…

thank you both anyway /emoticons/default_smile.png

You found this npc but… as a pet. All the sniffs with Skoll I got are all pets; that data is not useful.

ive already looked him up several times, and i believe i added him in a mass rare update earlier, if not then we will have to verify those factions & spawns first, and that is not easy on rares

sry for beeing away so long. spawn points should be ok…I´m quite unsure about the factions…they work fine…but I´m quite sure they are false. And the Rar wasn´t spawned till Core Updates til beginning of January

Are his spells working? Or they need scripting.