crashf / digitalhellps Goto Github PK

This project forked from trinitycore/trinitycore

Digital Hell Private server

Home Page: http://digitalhell.tech-method.com

License: GNU General Public License v2.0

CMake 0.88% C 7.83% Shell 0.01% PHP 0.03% Perl 0.01% C++ 91.06% Objective-C 0.05% Batchfile 0.01% GDB 0.01% TSQL 0.10% Python 0.02%

digitalhellps's People

Contributors

Stargazers

Watchers

digitalhellps's Issues

Combat dummy in Exile incorrect ID

Description

Combat dummy in Exile incorrect ID

SQL fix

UPDATE `world`.`creature` SET `id` = 174954, `map` = 2261, `zoneId` = 10424, `areaId` = 10639, `spawnDifficulties` = '0', `phaseUseFlags` = 0, `PhaseId` = 0, `PhaseGroup` = 0, `terrainSwapMap` = -1, `modelid` = 0, `equipment_id` = 0, `position_x` = -11.2698, `position_y` = 8.09454, `position_z` = 5.42378, `orientation` = 5.36703, `spawntimesecs` = 5, `spawndist` = 0, `currentwaypoint` = 0, `curhealth` = 114, `curmana` = 0, `MovementType` = 0, `npcflag` = 0, `unit_flags` = 0, `unit_flags2` = 0, `unit_flags3` = 0, `dynamicflags` = 0, `ScriptName` = '', `VerifiedBuild` = 41079 WHERE `guid` = 1050169;
UPDATE `world`.`creature` SET `id` = 174954, `map` = 2261, `zoneId` = 10424, `areaId` = 10639, `spawnDifficulties` = '0', `phaseUseFlags` = 0, `PhaseId` = 0, `PhaseGroup` = 0, `terrainSwapMap` = -1, `modelid` = 0, `equipment_id` = 0, `position_x` = -7.6347, `position_y` = 9.62948, `position_z` = 5.22708, `orientation` = 5.17507, `spawntimesecs` = 5, `spawndist` = 0, `currentwaypoint` = 0, `curhealth` = 114, `curmana` = 0, `MovementType` = 0, `npcflag` = 0, `unit_flags` = 0, `unit_flags2` = 0, `unit_flags3` = 0, `dynamicflags` = 0, `ScriptName` = '', `VerifiedBuild` = 41079 WHERE `guid` = 1050166;
UPDATE `world`.`creature` SET `id` = 174954, `map` = 2261, `zoneId` = 10424, `areaId` = 10639, `spawnDifficulties` = '0', `phaseUseFlags` = 0, `PhaseId` = 0, `PhaseGroup` = 0, `terrainSwapMap` = -1, `modelid` = 0, `equipment_id` = 0, `position_x` = -14.0159, `position_y` = 4.46932, `position_z` = 5.58979, `orientation` = 0, `spawntimesecs` = 5, `spawndist` = 0, `currentwaypoint` = 0, `curhealth` = 114, `curmana` = 0, `MovementType` = 0, `npcflag` = 0, `unit_flags` = 0, `unit_flags2` = 0, `unit_flags3` = 0, `dynamicflags` = 0, `ScriptName` = '', `VerifiedBuild` = 41079 WHERE `guid` = 1050165;
UPDATE `world`.`creature` SET `id` = 174954, `map` = 2261, `zoneId` = 10424, `areaId` = 10639, `spawnDifficulties` = '0', `phaseUseFlags` = 0, `PhaseId` = 0, `PhaseGroup` = 0, `terrainSwapMap` = -1, `modelid` = 0, `equipment_id` = 0, `position_x` = -11.1898, `position_y` = -7.82821, `position_z` = 5.42829, `orientation` = 0.674162, `spawntimesecs` = 5, `spawndist` = 0, `currentwaypoint` = 0, `curhealth` = 114, `curmana` = 0, `MovementType` = 0, `npcflag` = 0, `unit_flags` = 0, `unit_flags2` = 0, `unit_flags3` = 0, `dynamicflags` = 0, `ScriptName` = '', `VerifiedBuild` = 41079 WHERE `guid` = 1050164;
UPDATE `world`.`creature` SET `id` = 174954, `map` = 2261, `zoneId` = 10424, `areaId` = 10639, `spawnDifficulties` = '0', `phaseUseFlags` = 0, `PhaseId` = 0, `PhaseGroup` = 0, `terrainSwapMap` = -1, `modelid` = 0, `equipment_id` = 0, `position_x` = -7.825, `position_y` = -9.21034, `position_z` = 5.28981, `orientation` = 0.997226, `spawntimesecs` = 5, `spawndist` = 0, `currentwaypoint` = 0, `curhealth` = 114, `curmana` = 0, `MovementType` = 0, `npcflag` = 0, `unit_flags` = 0, `unit_flags2` = 0, `unit_flags3` = 0, `dynamicflags` = 0, `ScriptName` = '', `VerifiedBuild` = 41079 WHERE `guid` = 1050168;
UPDATE `world`.`creature` SET `id` = 174954, `map` = 2261, `zoneId` = 10424, `areaId` = 10639, `spawnDifficulties` = '0', `phaseUseFlags` = 0, `PhaseId` = 0, `PhaseGroup` = 0, `terrainSwapMap` = -1, `modelid` = 0, `equipment_id` = 0, `position_x` = -13.8277, `position_y` = -4.42007, `position_z` = 5.58518, `orientation` = 0, `spawntimesecs` = 5, `spawndist` = 0, `currentwaypoint` = 0, `curhealth` = 114, `curmana` = 0, `MovementType` = 0, `npcflag` = 0, `unit_flags` = 0, `unit_flags2` = 0, `unit_flags3` = 0, `dynamicflags` = 0, `ScriptName` = '', `VerifiedBuild` = 41079 WHERE `guid` = 1050167;

Branch

master

TC rev. hash/commit

Quest 56775 - Warming up Exiles reach.

Description

Wrong creature entry in quest_objective. Should be 160737

SQL fix

UPDATE `world`.`quest_objectives` SET `QuestID` = 56775, `Type` = 0, `Order` = 0, `StorageIndex` = 0, `ObjectID` = 160737, `Amount` = 1, `Flags` = 0, `Flags2` = 0, `ProgressBarWeight` = 0, `Description` = 'Practice combat on a Combat Dummy', `VerifiedBuild` = 41031 WHERE `ID` = 391353;

Branch

master

TC rev. hash/commit

Quest: Emergency First Aid: https://www.wowhead.com/quest=54951/emergency-first-aid

Description

Unable to use first aid on npc required

Expected behaviour

Should be able to use first aid

Steps to reproduce the problem

accept quest and try to use first aid

Branch

master

TC rev. hash/commit

Operating system

windows 11

Custom changes

Forced to watch from afar

Description

Can not complete quest objectives.

Mounteneer Dunstan does not accept orders
Mounteneer valgrum does not accept orders
Mounteneer lewin does not accept orders

Expected behaviour

Mountaineers should accept orders

Steps to reproduce the problem

Accept quest: https://www.wowhead.com/quest=313/forced-to-watch-from-afar. Attempt to talk to mountaineers

Branch

master

TC rev. hash/commit

Operating system

windows 11

Custom changes

Stand you group ID: 58209 - requires core mods

Description

Private cole just disappears when accepting quest. Should walk across ship and spar.

Suggest work around for now

SQL fix

Current: 
INSERT INTO `world`.`quest_template`(`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardDisplaySpell1`, `RewardDisplaySpell2`, `RewardDisplaySpell3`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardItem1`, `RewardAmount1`, `RewardItem2`, `RewardAmount2`, `RewardItem3`, `RewardAmount3`, `RewardItem4`, `RewardAmount4`, `ItemDrop1`, `ItemDropQuantity1`, `ItemDrop2`, `ItemDropQuantity2`, `ItemDrop3`, `ItemDropQuantity3`, `ItemDrop4`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemQuantity1`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemID2`, `RewardChoiceItemQuantity2`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemID3`, `RewardChoiceItemQuantity3`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemID4`, `RewardChoiceItemQuantity4`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemID5`, `RewardChoiceItemQuantity5`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardFactionID1`, `RewardFactionValue1`, `RewardFactionOverride1`, `RewardFactionCapIn1`, `RewardFactionID2`, `RewardFactionValue2`, `RewardFactionOverride2`, `RewardFactionCapIn2`, `RewardFactionID3`, `RewardFactionValue3`, `RewardFactionOverride3`, `RewardFactionCapIn3`, `RewardFactionID4`, `RewardFactionValue4`, `RewardFactionOverride4`, `RewardFactionCapIn4`, `RewardFactionID5`, `RewardFactionValue5`, `RewardFactionOverride5`, `RewardFactionCapIn5`, `RewardFactionFlags`, `RewardCurrencyID1`, `RewardCurrencyQty1`, `RewardCurrencyID2`, `RewardCurrencyQty2`, `RewardCurrencyID3`, `RewardCurrencyQty3`, `RewardCurrencyID4`, `RewardCurrencyQty4`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `TreasurePickerID`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `QuestCompletionLog`, `VerifiedBuild`) VALUES (58209, 2, 0, 957, 10424, 0, 0, 0, 5, 1, 565, 5, 1, 60, 0, 0, 0, 316454, 0, 0, 0, 0, 1, 0, 40894464, 8194, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 18446744073709551615, 0, 0, 0, 0, 'Stand Your Ground', 'Spar with Private Cole.', 'I hope this rain isn\'t a bad omen... this is supposed to be a simple rescue mission.\n\nYou\'ll be sparring with me today. We have to make sure you can handle yourself once we make landfall.\n\nLet\'s see what you\'ve got!', '', '', '', '', '', '', 41031);


Suggested workaround:
UPDATE `world`.`quest_template` SET `QuestType` = 0, `QuestPackageID` = 0, `ContentTuningID` = 957, `QuestSortID` = 10424, `QuestInfoID` = 0, `SuggestedGroupNum` = 0, `RewardNextQuest` = 0, `RewardXPDifficulty` = 5, `RewardXPMultiplier` = 1, `RewardMoney` = 565, `RewardMoneyDifficulty` = 5, `RewardMoneyMultiplier` = 1, `RewardBonusMoney` = 60, `RewardDisplaySpell1` = 0, `RewardDisplaySpell2` = 0, `RewardDisplaySpell3` = 0, `RewardSpell` = 316454, `RewardHonor` = 0, `RewardKillHonor` = 0, `StartItem` = 0, `RewardArtifactXPDifficulty` = 0, `RewardArtifactXPMultiplier` = 1, `RewardArtifactCategoryID` = 0, `Flags` = 40894464, `FlagsEx` = 8194, `FlagsEx2` = 0, `RewardItem1` = 0, `RewardAmount1` = 0, `RewardItem2` = 0, `RewardAmount2` = 0, `RewardItem3` = 0, `RewardAmount3` = 0, `RewardItem4` = 0, `RewardAmount4` = 0, `ItemDrop1` = 0, `ItemDropQuantity1` = 0, `ItemDrop2` = 0, `ItemDropQuantity2` = 0, `ItemDrop3` = 0, `ItemDropQuantity3` = 0, `ItemDrop4` = 0, `ItemDropQuantity4` = 0, `RewardChoiceItemID1` = 0, `RewardChoiceItemQuantity1` = 0, `RewardChoiceItemDisplayID1` = 0, `RewardChoiceItemID2` = 0, `RewardChoiceItemQuantity2` = 0, `RewardChoiceItemDisplayID2` = 0, `RewardChoiceItemID3` = 0, `RewardChoiceItemQuantity3` = 0, `RewardChoiceItemDisplayID3` = 0, `RewardChoiceItemID4` = 0, `RewardChoiceItemQuantity4` = 0, `RewardChoiceItemDisplayID4` = 0, `RewardChoiceItemID5` = 0, `RewardChoiceItemQuantity5` = 0, `RewardChoiceItemDisplayID5` = 0, `RewardChoiceItemID6` = 0, `RewardChoiceItemQuantity6` = 0, `RewardChoiceItemDisplayID6` = 0, `POIContinent` = 0, `POIx` = 0, `POIy` = 0, `POIPriority` = 0, `RewardTitle` = 0, `RewardArenaPoints` = 0, `RewardSkillLineID` = 0, `RewardNumSkillUps` = 0, `PortraitGiver` = 0, `PortraitGiverMount` = 0, `PortraitGiverModelSceneID` = 0, `PortraitTurnIn` = 0, `RewardFactionID1` = 0, `RewardFactionValue1` = 0, `RewardFactionOverride1` = 0, `RewardFactionCapIn1` = 7, `RewardFactionID2` = 0, `RewardFactionValue2` = 0, `RewardFactionOverride2` = 0, `RewardFactionCapIn2` = 7, `RewardFactionID3` = 0, `RewardFactionValue3` = 0, `RewardFactionOverride3` = 0, `RewardFactionCapIn3` = 7, `RewardFactionID4` = 0, `RewardFactionValue4` = 0, `RewardFactionOverride4` = 0, `RewardFactionCapIn4` = 7, `RewardFactionID5` = 0, `RewardFactionValue5` = 0, `RewardFactionOverride5` = 0, `RewardFactionCapIn5` = 7, `RewardFactionFlags` = 0, `RewardCurrencyID1` = 0, `RewardCurrencyQty1` = 0, `RewardCurrencyID2` = 0, `RewardCurrencyQty2` = 0, `RewardCurrencyID3` = 0, `RewardCurrencyQty3` = 0, `RewardCurrencyID4` = 0, `RewardCurrencyQty4` = 0, `AcceptedSoundKitID` = 890, `CompleteSoundKitID` = 878, `AreaGroupID` = 0, `TimeAllowed` = 0, `AllowableRaces` = 18446744073709551615, `TreasurePickerID` = 0, `Expansion` = 0, `ManagedWorldStateID` = 0, `QuestSessionBonus` = 0, `LogTitle` = 'Stand Your Ground', `LogDescription` = 'Spar with Private Cole.', `QuestDescription` = 'I hope this rain isn\'t a bad omen... this is supposed to be a simple rescue mission.\n\nYou\'ll be sparring with me today. We have to make sure you can handle yourself once we make landfall.\n\nLet\'s see what you\'ve got!', `AreaDescription` = '', `PortraitGiverText` = '', `PortraitGiverName` = '', `PortraitTurnInText` = '', `PortraitTurnInName` = '', `QuestCompletionLog` = '', `VerifiedBuild` = 41031 WHERE `ID` = 58209;

Branch

master

TC rev. hash/commit

Murlocks not dropping items in exile

Description

For quest: https://www.wowhead.com/quest=55122/murloc-mania, murlocks are not lootable so quest can not be completed

Murlocks are also not moving

Expected behaviour

Should be able to look first aid kit https://www.wowhead.com/item=168410/first-aid-kit
Murlocks should have movement.

Steps to reproduce the problem

Kill murlocks, no loot

Branch

master

TC rev. hash/commit

Operating system

windows 11

Custom changes

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.