Trinitycore: DB/GameObject: multiple road signs hanging in mid-air, out of position
Description:
Summing up, these are the road sign gameobjects I have found to be either not fitted or incorrectly fitted to their sign posts:
SELECT * FROM `gameobject` WHERE `ID` IN (381, 387, 388, 389, 1162, 2024, 2032, 3211, 3212) ORDER BY `id`;
guid id map zoneId areaId spawnMask phaseMask position_x position_y position_z orientation rotation0 rotation1 rotation2 rotation3 spawntimesecs animprogress state ScriptName VerifiedBuild
----- ------ ----- ------ ------ --------- --------- ---------- ---------- ---------- ----------- --------- --------- --------- ------------ ------------- ------------ ------ ---------- -------------
13764 381 0 0 0 1 1 -3600.88 -2714.84 18.5583 -3.14152 0 0 -1 0.0000363151 7200 100 1 15595
14230 387 0 0 0 1 1 -2620.74 -2491.65 79.4416 1.66679 0 0 0.740218 0.672367 7200 100 1 0
14248 388 0 0 0 1 1 -2620.21 -2490.75 78.7749 -1.4748 0 0 -0.672366 0.740219 7200 100 1 0
14231 389 0 0 0 1 1 -2621.4 -2491.45 80.2191 0.095993 0 0 0.0479781 0.998848 7200 100 1 0
13724 1162 0 0 0 1 1 -2621.21 -2491.46 77.9969 1.66679 0 0 0.740218 0.672367 7200 100 1 0
30079 2024 0 0 0 1 1 452.427 -629.573 166.348 2.90598 0 0 0.993069 0.117534 7200 100 1 0
30108 2032 0 0 0 1 1 758.8 -1466.92 78.471 4.65149 0 0 0.728307 -0.685251 7200 100 1 0
18 3211 0 0 0 1 1 -13331.6 62.018 23.2462 -2.41728 0 0 -0.935135 0.354292 900 100 1 0
22 3212 0 0 0 1 1 -13332.1 61.8614 21.7726 0.776671 0 0 0.378648 0.925541 900 100 1 0
Using guid instead, the same table is:
SELECT * FROM `gameobject` WHERE `guid` IN (18, 22, 13724, 13764, 14230, 14231, 14248, 30079, 30108);
guid id map zoneId areaId spawnMask phaseMask position_x position_y position_z orientation rotation0 rotation1 rotation2 rotation3 spawntimesecs animprogress state ScriptName VerifiedBuild
----- ------ ----- ------ ------ --------- --------- ---------- ---------- ---------- ----------- --------- --------- --------- ------------ ------------- ------------ ------ ---------- -------------
18 3211 0 0 0 1 1 -13331.6 62.018 23.2462 -2.41728 0 0 -0.935135 0.354292 900 100 1 0
22 3212 0 0 0 1 1 -13332.1 61.8614 21.7726 0.776671 0 0 0.378648 0.925541 900 100 1 0
13724 1162 0 0 0 1 1 -2621.21 -2491.46 77.9969 1.66679 0 0 0.740218 0.672367 7200 100 1 0
13764 381 0 0 0 1 1 -3600.88 -2714.84 18.5583 -3.14152 0 0 -1 0.0000363151 7200 100 1 15595
14230 387 0 0 0 1 1 -2620.74 -2491.65 79.4416 1.66679 0 0 0.740218 0.672367 7200 100 1 0
14231 389 0 0 0 1 1 -2621.4 -2491.45 80.2191 0.095993 0 0 0.0479781 0.998848 7200 100 1 0
14248 388 0 0 0 1 1 -2620.21 -2490.75 78.7749 -1.4748 0 0 -0.672366 0.740219 7200 100 1 0
30079 2024 0 0 0 1 1 452.427 -629.573 166.348 2.90598 0 0 0.993069 0.117534 7200 100 1 0
30108 2032 0 0 0 1 1 758.8 -1466.92 78.471 4.65149 0 0 0.728307 -0.685251 7200 100 1 0
... and just to add the sign names & extra info, from gameobject_template:
entry type displayId name IconName castBarCaption unk1 size Data0 Data1 Data2 Data3 Data4 Data5 Data6 Data7 Data8 Data9 Data10 Data11 Data12 Data13 Data14 Data15 Data16 Data17 Data18 Data19 Data20 Data21 Data22 Data23 AIName ScriptName VerifiedBuild
----- ---- --------- ----------------------- -------- -------------- ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ---------- -------------
381 5 22 Grim Batol 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
387 5 22 Loch Modan 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
388 5 22 Arathi Highlands 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
389 5 22 Dun Modr 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
1162 5 22 Menethil Harbor 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
2024 5 203 Andorhal 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
2032 5 22 Warning!!!! Plaguelands 0.84 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
3211 5 22 Duskwood 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
3212 5 22 Booty Bay 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12340
Please note: I tried looking around in the game for more posts with signs way off their right place, but it is just too time-consuming as a continuous travel search.
Branch(es):
3.3.5 ( I am fairly sure that most of the landscape is changed by Cataclysm & later.)
TC rev. hash/commit:
TrinityCore rev. 0152878de5c1 2020-09-29 19:50:29 +0200 (3.3.5 branch) (Win64, Release, Static)
Using SSL version: OpenSSL 1.1.1g 21 Apr 2020 (library: OpenSSL 1.1.1g 21 Apr 2020)
Using Boost version: 1.73.0
Using MySQL version: 50731
Using CMake version: 3.18.2
Compiled on: Windows 10.0.19041
Automatic database updates are enabled for the following databases: Auth, Characters, World
Worldserver listening connections on port 8085
Realmlist (Realm Id: 1) configured in port 8085
VMAPs status: Enabled. LineOfSight: 1, getHeight: 1, indoorCheck: 1
MMAPs status: Enabled
maps directory located in ./maps. Total size: 251987687 bytes
vmaps directory located in ./vmaps. Total size: 658130721 bytes
mmaps directory located in ./mmaps. Total size: 3901434544 bytes
Using enUS DBC Locale as default. All available DBC locales: enUS
Using World DB: TDB 335.20091
Operating system: Windows 10 Version 2004 (OS Build 19041.508)
illfated
All 12 comments
Same goes for the Grim Batol sign in Wetlands.
https://tcubuntu.northeurope.cloudapp.azure.com/aowow/?object=381
TQPS
on 1 Oct 2020
Thank you, good job. I will line up that one too and add it to my suggestion.
edit: I wonder if, how, and when this has happened, because I am pretty sure I have moved my player character past those places several times the last 2 years, but not noticed anything about the signs.
illfated
on 1 Oct 2020
TrinityCore rev. e811b9cdc258 2020-10-01 04:41:08 +0200 (3.3.5 branch) (Win64, Release, Static)
Confirmed. The "Grim Batol" sign is hanging in the air, off the sign post by an approximate width of 2 player characters.
13762 (Entry: 379) - [Loch Modan X:-3597.209961 Y:-2714.679932 Z:19.613800 MapId:0]
13763 (Entry: 380) - [Menethil X:-3597.879883 Y:-2713.780029 Z:18.836399 MapId:0]
13764 (Entry: 381) - [Grim Batol X:-3600.879883 Y:-2714.840088 Z:18.558300 MapId:0]
14261 (Entry: 382) - [Dun Modr X:-3597.649902 Y:-2713.629883 Z:18.280500 MapId:0]
13704 (Entry: 1668) - [Dun Algaz X:-3597.300049 Y:-2714.840088 Z:17.519600 MapId:0]
Found nearby gameobjects (distance 10.000000): 5
The difficulty here is that all the signs are slanted (pointing end hanging lower than the blunt end) and none of the other signs point in the same direction.
I need to look for an image of how the sign post is supposed to look, to determine where the "Grim Batol" sign is meant to sit on the sign post.
illfated
on 1 Oct 2020
Found another signpost with all 4 signs more or less off their intended position: right outside Dun Modr, south of Thandol Span:
14230 (Entry: 387) - [Loch Modan X:-2620.739990 Y:-2491.649902 Z:79.441597 MapId:0]
14248 (Entry: 388) - [Arathi Highlands X:-2620.209961 Y:-2490.750000 Z:78.774902 MapId:0]
14231 (Entry: 389) - [Dun Modr X:-2621.399902 Y:-2491.449951 Z:80.219101 MapId:0]
13724 (Entry: 1162) - [Menethil Harbor X:-2621.209961 Y:-2491.459961 Z:77.996902 MapId:0]
Found nearby gameobjects (distance 10.000000): 4
Details
The lowest sign, [Menethil Harbor], hangs just off the post, in the air.
The second lowest, [Arathi Highlands], goes through the middle of the wooden signpost like a wood joint.
The remaining 2 signs are slightly indented into the post, not sitting on the surface of (nailed on to) the post.
It would have been nice to know if original sniff data is available and actually correct for these signs.
illfated
on 1 Oct 2020
One list of all entries in one comment is better
offl
on 1 Oct 2020
Sure thing, will do. Just trying to find out if there are any more obvious signs out of place, by resetting my world DB to clean TDB + TC updates.
edit: Added the <details> </details> tags around my images, to reduce the scrolling in this ticket.
illfated
on 2 Oct 2020
Booty Bay sign outside Gurubashi Arena
TQPS
on 2 Oct 2020
Thank you for the additional signpost. I will add that to the list.
@TQPS : Do you know how to add the "details" tags in your posts, by editing your own posts? I think that would be helpful to others. See example below this text:
<details>
(content to hide)
</details>
illfated
on 2 Oct 2020
Latest update in the main ticket comment (https://github.com/TrinityCore/TrinityCore/issues/25517#issue-712394518) is based on 60ded4ea4796 :
core_version core_revision db_version cache_id
----------------------------------------------------------------------------------------------- ------------- ------------- --------
TrinityCore rev. 60ded4ea4796 2020-10-03 02:37:58 +0300 (3.3.5 branch) (Win64, Release, Static) 60ded4ea4796 TDB 335.20091 20091
This can also be seen in the DB by comparing sign 2023 with 2024, because they point in the same direction along the road to Chillwind Camp & Andorhal.
SELECT * FROM `gameobject` WHERE `guid` IN (30073, 30079, 30111, 30121);Are they too bugged? There's lot of unneeded info in this issue, it's not the case where more info is better, all we need here is list of entries
offl
on 4 Oct 2020
OK, fair enough. I can reduce the main comment to only include the directly problematic gameobjects.
Sorry for messing up the information.
illfated
on 4 Oct 2020
15d69bd885adca7070d3819493519065f02b35ca
![github-actions[bot] picture](https://avatars.githubusercontent.com/in/15368?v=4&s=40)
github-actions[bot]
on 15 Jan 2021
Related issues
daddycaddy
路
3Comments
Rushor
路
3Comments
tje3d
路
3Comments
besplash
路
3Comments
DDuarte
路
3Comments
Most helpful comment
One list of all entries in one comment is better