search

Warglaive / DragonFireOriginal-3.3.5

Тракер за грешки #
http://wow.hysteria-gaming.org
4 stars 9 forks source link

[Event] Kalu'ak Fishing Derby #415

Closed GalaxyWoW closed 9 years ago

GalaxyWoW commented 9 years ago

няма дроп на http://wotlk.openwow.com/item=50289

пробвал съм всички поолове в нортренд с над 200+ уловени риби от всеки поол, също така и в реките, без резултат.

Трябва да се провери 'gameobject_loot_template' дали е добавено

Ето и SQL с който се решава проблема поне при мене Лично го написах и изпробвах, дроп а е 1% и е само по време на евента

DELETE FROM `gameobject_loot_template` WHERE `item`=50289;

INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25671, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25664, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25663, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25662, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25674, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25668, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25670, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25665, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (25673, 50289, 0, 1, 0, 1, 0, 1, 1, NULL);
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup` IN (25673,25665,25670,25668,25674,25662,25663,25664,25671) AND `SourceEntry`=50289;

INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25673, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25665, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25670, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25668, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25674, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25662, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25663, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25664, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (4, 25671, 50289, 0, 0, 12, 0, 63, 0, 0, 0, 0, 0, '', NULL);
FALL1N1 commented 9 years ago

Вкарах го, трябва тест.

GalaxyWoW commented 9 years ago

Резултат: 63x [Musselback Sculpin] 12x [Crystallized Water] 3x [Reinforced Crate] 8x [Pygmy Suckerfish] 1x [Blacktip Shark]

Работи идеално, само че самия евент трябва да е от 2pm , но тука почва в 8am. Не е нещо толкова важно обаче ще е по добре ако почва така както си е посочен в календара.

UPDATE `game_event` SET `start_time`='2012-01-07 14:00:00' WHERE `evententry`=63;

Може да го импортнеш за да се оправи времето. Благодаря!

FALL1N1 commented 9 years ago

Ок е просто сървъра се намира в друга държава.

Larua commented 9 years ago

Сега остава и да се оправи това което е в Странгълторн и ще сте златни!