Old Crystalbark

Hi

I made an SQL fix trying to solve thie issue https://github.com/TrinityCore/TrinityCore/issues/1843

I was able to turn NPC Old Crystalbark attackable, and I also added the correct loot, but I’m not sure about the values ChanceOrQuestChance in creature_template

If anyone could see it, and explain to me if I did something wrong, I would apreciate it

Thank you

TC rev: bdc75eb856cd07f11caa

DB: TDB 335.11.40

SQL:

[CODE]

– Turning Old Crystalbark attackable

UPDATE creature_template SET faction_A=103,faction_H=103 WHERE entry=32357;

INSERT INTO creature_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES

(32357,44663,1,1,1,1,1),

(32357,44649,1,1,1,1,1);[/CODE]

Edit: values for loot items are here http://www.wowhead.com/npc=32357#drops

I just don’t know how to correctly add them into ChanceOrQuestChance

The wiki is there for a reason

http://www.trinitycore.info/Loot_template_tc2#ChanceOrQuestChance

I’ve read through the whole page three times a few weeks ago and just can’t get to understand it. It’s outdated, a lot of information is really wrong and it’s hard to understand.

How does the loot work for 10M norm, 10M heroic, 25M norm and 25M heroic work? And I don’t understand the quest chance either.

EDIT.

I just realized using the ‘-100’ value made it a 100% dropchance. Now referring to this wiki page that should be correct.

when positive: the minimum number of copies of the item that can drop in a single lootwhen negative: a reference to another template.

-- Turning Old Crystalbark attackable UPDATE `creature_template` SET `faction_A`=103,`faction_H`=103 WHERE `entry`=32357; INSERT INTO `creature_loot_template` (`entry`, `item` ,`ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (32357, 44663, -100, 1, 1, 1, 1), (32357, 44649, -100, 1, 1, 1, 1);[/sql]

It’s 100%, just invalid information from the client used by WoWhead. It’s never entirely accurate. /emoticons/default_wink.png

I’ll add your correction on the SQL in the bugtracker

Thanks /emoticons/default_smile.png

Here is some dire maul talk text you may want to use:

-- NPC talk text insert from sniff DELETE FROM `creature_text` WHERE `entry` IN (11489,14566,11469,11466,11486,14383) AND `groupid` IN (0); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES (11489,0,0, 'You do not belong here! Ancients, rise against these intruders!',14,0,100,0,0,0, 'Tendris Warpwood'), (14566,0,0, '%s breaks free of its spectral bonds with a tremendous crash of thunder!',16,0,100,0,0,0, 'Ancient Equine Spirit'), (11469,0,0, '%s goes into a frenzy!',16,0,100,0,0,0, 'Eldreth Seether'), (11466,0,0, 'The demon is loose! Quickly we must restrain him!',14,0,100,0,0,0, 'Highborne Summoner'), (11486,0,0, 'Who dares disrupt the sanctity of Eldre''Thalas? Face me, cowards!',14,0,100,0,0,0, 'Prince Tortheldrin'), (14383,0,0, 'Where is "Garona: A Study in Stealth and Treachery!" These texts must be returned! ',12,0,100,5,0,0, 'Lorekeeper Kildrath');[/sql]

Malcrom, that looks really good, but I think you’re trying to post it on the previous topic “Dire Maul Spawn Fixes” /emoticons/default_tongue.png

And you commented a DELETE FROM line. x)

Actually the parser outputs it commented like this:

-- DELETE FROM `creature_text` WHERE `entry` IN () AND `groupid` IN ();

I just forgot to remove it after filling in the values /emoticons/default_smile.png

Ah, explains. =)

Well thanks alot. Hope this gets pushed in official repo soon!