[BC-WoD]Orb of the Sin'dorei

[Lordakius]

Greetings people

bugtracker link:http://tracker.ashran.com/issues/11173

item: orb of the sin'dorei

creatures, who drop the item (all can be found in magisters terrace):

kaelthas sunstrider

vexallus

selin fireheart

priestess delrissa

Correction: added loot

 

DELETE FROM `creature_loot_template` WHERE `entry`=24664 AND `item`=35275;
DELETE FROM `creature_loot_template` WHERE `entry`=24744 AND `item`=35275;
DELETE FROM `creature_loot_template` WHERE `entry`=24723 AND `item`=35275;
DELETE FROM `creature_loot_template` WHERE `entry`=24560 AND `item`=35275;

INSERT INTO 'creature_loot_template' ('entry', 'item', 'ChanceOrQuestChance', 'lootmode', 'groupid', 'mincountOrRef', 'maxcount') VALUES
('24664', '35275', '3.0', '1', '0', '1', '1'),
('24744', '35275', '1.3', '1', '0', '1', '1'),
('24723', '35275', '1.3', '1', '0', '1', '1'),
('24560', '35275', '1.3', '1', '0', '1', '1');
UPDATE `creature_template` SET 'lootid'='35275' WHERE 'entry'='24664';
UPDATE `creature_template` SET 'lootid'='35275' WHERE 'entry'='24744';
UPDATE `creature_template` SET 'lootid'='35275' WHERE 'entry'='24723';
UPDATE `creature_template` SET 'lootid'='35275' WHERE 'entry'='24560';

Not sure about 'groupid' and 'mincountOrRef'.. The rest should be correct.

 

Kind Regards,

Lordakius

 

 

Edited January 11, 2016 by Lordakius

[Hypnos]

The first, I will add the patch if it isnt in the loot still. I will check it later when Im at home.

Second. any advices:

- You use ` instead of '  in the name of tables and fields:

wrong --> 'lootid'

good --> `lootid`

- Normally lootid is the same id that the npc id so:

UPDATE `creature_template` SET `lootid`='24664' WHERE `entry`='24664';
UPDATE `creature_template` SET `lootid`='24744' WHERE `entry`='24744';
UPDATE `creature_template` SET `lootid`='24723' WHERE `entry`='24723';
UPDATE `creature_template` SET `lootid`='24560' WHERE `entry`='24560';

Be carefull please.

[Lordakius]

I thought both would work. I will use ` in the future  

 

 

Quote

 

lootid

The ID of the loot template ID that this creature should use to generate loots. See creature_loot_template.entry

 

This confused me a bit. So it means lootid == id of the creature, which has the item in loot  ?

[Hypnos]

You have the example down of it. entry in creature_template,lootid in creature_template and entry in creature_loot_template is the same in the 3 tables. Yes.

You can use a lootid different to entry in creature_template if you want but so, lootid in creature_template and entry in creature_loot_template have to be the same.

2 hours ago, Lordakius said:

This confused me a bit. So it means lootid == id of the creature, which has the item in loot  ?

Yes.

 

By the way, did you join the dungeon in heroic mode? The item only drop in heroic and im checking the db now and the item is in the loot....

The drops have a rate of 3,2,2 and 2. So its higher than it would have.... (not much  )

So sorry, rejected because its working nowdays.

I will check if  the quest to join in heroic works.

Edited January 13, 2016 by Hypnos

[Lordakius]

Quote

By the way, did you join the dungeon in heroic mode?

It is a bug I have seen in the bugtracker

 

Thank you for explaining it in detail, tho.

[Rizon]

On 13.01.2016 at 10:10 PM, Hypnos said:

You have the example down of it. entry in creature_template,lootid in creature_template and entry in creature_loot_template is the same in the 3 tables. Yes.

You can use a lootid different to entry in creature_template if you want but so, lootid in creature_template and entry in creature_loot_template have to be the same.

Yes.

 

By the way, did you join the dungeon in heroic mode? The item only drop in heroic and im checking the db now and the item is in the loot....

The drops have a rate of 3,2,2 and 2. So its higher than it would have.... (not much  )

So sorry, rejected because its working nowdays.

I will check if  the quest to join in heroic works.

I think  Orb of the Sin'dorei has not correct effect

How it is on our server 

And how it must be(from wowhead)