[FIXED] <Jewelcrafting> Prospecting Elementium Ore

[Mallfurion]

Wowhead/WoW Freakz Link: http://www.wowhead.com/item=52185#prospecting
Descrierea bugului / Bug description: Atunci cand dau prospecting la Elementium Ore, de multe ori nu primesc nici un gem, iar cand primesc, sunt numai verzi, nici unul albastru.
Dovada / Proof:

Fix propus:

Code:

DELETE FROM prospecting_loot_template WHERE entry=52185; INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52190, 4, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52191, 4, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52194, 4, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52195, 4, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52192, 5, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52193, 5, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52177, 18, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52178, 18, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52179, 18, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52180, 18, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52181, 18, 1, 0, 1, 2); INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52182, 18, 1, 0, 1, 2);

[ylfor]

Mai la toate ore se intampla asta ( sa nu primesti nimic ) , nu stiu de problema ta @ rare gems ca eu primesc .

[Zohlomg]

In primul rand, la ChanceorQuestChance, se aplica server rates, vezi aici.

In al doilea rand, daca vrei sa continui sa faci fixul:

1. Nu mai pune insert de 100 de ori, poti pune ',' si sa continui, gen.

Code:

INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (52185, 52190, 4, 1, 0, 1, 2), (52185, 52191, 4, 1, 0, 1, 2);

2. Pune toate gemurile in grouploot 1.

[Zohlomg]

Fixed!