cmangos / issues

This repository is used as a centralized point for all issues regarding CMaNGOS.
180 stars 47 forks source link

🐛 [Bug Report] Dark Iron Deposit chance #3471

Open Tobschinski opened 1 year ago

Tobschinski commented 1 year ago

Bug Details

find out the actual chance for Dark Iron Deposit to spawn, it is much more common than Truesilver Deposits and Gold Veins

Steps to Reproduce

-

Expected behavior

-

Suggested Workaround

-

Crash Log

-

Core SHA1 Commit Hash

-

Database SHA1 Commit Hash

-

Operating System

Win

Client Version

1.12.1 (Classic)

AnonXS commented 1 year ago

Dark Iron Deposit 165658: grafik cover full zone

Truesilver Deposit 2047: grafik cover full zone

Mithril Deposit 2040: grafik cover half the zone

Gold Vein 1734: grafik cover half the zone

edit/ thorium has to be taken into account too as it shares nodes with darkiron

INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (1734, 46, 4); -- Gold Vein * 2 = 2%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2040, 46, 115); -- Mithril Deposit * 2 = 64%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2047, 46, 27);-- Truesilver Deposit * 1 = 8%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (165658, 46, 96); -- Dark Iron Deposit * 1 = 26%
8, 230, 27, 96 = 361
->

INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (324, 46, 125);
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (1734, 46, 4); -- Gold Vein * 2, due to only half zone = 2%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2040, 46, 115); -- Mithril Deposit * 2, due to only half zone
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2047, 46, 27);-- Truesilver Deposit * 1 = 5%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (165658, 46, 96); -- Dark Iron Deposit * 1 = 18%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (175404, 46, 50);

8, 230, 27, 96 = 361+ 125+50 = 536

INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (1734, 46, 2); -- Gold Vein * 2 = 4%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2040, 46, 36); -- Mithril Deposit * 2 = 62%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2047, 46, 12); -- Truesilver Deposit * 1 = 10%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (165658, 46, 29); -- Dark Iron Deposit * 1 = 24%
4, 72, 12, 29 =  117

INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (324, 46, 39);
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (1734, 46, 2); -- Gold Vein * 2, due to only half zone
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2040, 46, 36); -- Mithril Deposit * 2, due to only half zone
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (2047, 46, 12); -- Truesilver Deposit * 1 = 7%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (165658, 46, 29); -- Dark Iron Deposit * 1 = 16%
INSERT INTO `gameobject` (`id`, `zone_id`, `count`) VALUES (175404, 46, 28);
4, 72, 12, 29 =  117 + 39 + 28 = 184

-> 20-25% for Dark Iron Deposit.