[DB/Gameobject Spawns] Durotar - minning nodes

[TerrorBringer]

Description:

There seems to be some problems regarding the minning nodes in Durotar, like for example:

. There are 2 Mithril nodes in razorwind canyon . There is a Tin Vein in Valley of Trials . There is a Ooze covered Gold Vein near Kolkar Crag . The are way too many Copper veins spawned in areas like near Tirargarde Keep, or near the Quillboars (Bad pooling, maybe?)

Branch(es):

3.3.5

TC rev. hash/commit:

https://github.com/TrinityCore/TrinityCore/commit/ef694cc251844d34a64ae03f79d28a5c76719f6b

Operating system: Win 10 x64

[ghost]

TrinityCore rev. e10239311c95 2020-02-01 14:55:16 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static)

Confirmed, there seems to be too many copper vein nodes in Durotar. I ran a level 12 character around Thunder Ridge + Razorwind Canyon + Razormane Grounds only once, but still mined+smelted enough copper ore to advance my mining skill to Journeyman Miner (70/150).

I noticed there are at least 2 inaccessible copper nodes:

(Find Minerals turned on, visible sparkling visual)
Map: 1 (Kalimdor) Zone: 14 (Durotar) Area: 369 (Thunder Ridge) Phase: 1
X: 833.472961 Y: -4095.233398 Z: 27.004641 Orientation: 5.327209
grid[33,24]cell[4,2] InstanceID: 0
 ZoneX: 40.335388 ZoneY: 27.655611
GroundZ: -12.771421 FloorZ: 27.004623 Have height data (Map: 1 VMap: 1 MMap: 1)

.gobject near
5361 (Entry: 1731) - [Copper Vein X:833.341003 Y:-4095.000000 Z:25.370001 MapId:1]  
Found nearby gameobjects (distance 10.000000): 1

(no visible sparkling visual)
Map: 1 (Kalimdor) Zone: 14 (Durotar) Area: 14 (Durotar) Phase: 1
X: 1120.377930 Y: -4494.803711 Z: 23.925867 Orientation: 3.691210
grid[34,23]cell[0,4] InstanceID: 0
 ZoneX: 47.892273 ZoneY: 19.516462
GroundZ: 20.435436 FloorZ: 23.926559 Have height data (Map: 1 VMap: 1 MMap: 1)

4788 (Entry: 1731) - [Copper Vein X:1119.910034 Y:-4494.000000 Z:20.438000 MapId:1]  
1847 (Entry: 1619) - [Earthroot X:1118.319946 Y:-4499.899902 Z:20.304501 MapId:1]  
Found nearby gameobjects (distance 10.000000): 2

[ghost]

(Repeat of one of the nodes above, just to make sure the details are correct.)

2 nodes spawn at very close X,Y coordinates (seems like on top of each other), but one up inside the rocks, one at the bottom floor, 38.2136 (yards?) apart.

At the bottom floor in Thunder Ridge, reachable node:

 12378 (Entry: 1731) - [Copper Vein X:833.362976 Y:-4095.239990 Z:-12.843600 MapId:1]  
 Found nearby gameobjects (distance 10.000000): 1

Unreachable node:

 5361 (Entry: 1731) - [Copper Vein X:833.341003 Y:-4095.000000 Z:25.370001 MapId:1]  
 Found nearby gameobjects (distance 10.000000): 1

Chat log details:

```sql [20:33:15] 20:33:15 [Zogzog] says: At the bottom floor, Thunder Ridge: [20:33:18] You are outdoors. [20:33:18] Map: 1 (Kalimdor) Zone: 14 (Durotar) Area: 369 (Thunder Ridge) Phase: 1 [20:33:18] X: 832.601196 Y: -4094.228516 Z: -12.867044 Orientation: 2.188874 [20:33:18] grid[33,24]cell[4,2] InstanceID: 0 [20:33:18] ZoneX: 40.316383 ZoneY: 27.680342 [20:33:18] GroundZ: -12.868095 FloorZ: -12.868095 Have height data (Map: 1 VMap: 1 MMap: 1) [20:33:25] 12378 (Entry: 1731) - [Copper Vein X:833.362976 Y:-4095.239990 Z:-12.843600 MapId:1] [20:33:25] Found nearby gameobjects (distance 10.000000): 1 [20:35:57] 20:35:57 [Zogzog] says: Thunder Ridge rooftop, center of the Ridge, standing above glittering unreachable node: [20:36:04] You are outdoors. [20:36:04] Map: 1 (Kalimdor) Zone: 14 (Durotar) Area: 369 (Thunder Ridge) Phase: 1 [20:36:04] X: 832.081787 Y: -4093.515381 Z: 26.789415 Orientation: 1.538559 [20:36:04] grid[33,24]cell[4,2] InstanceID: 0 [20:36:04] ZoneX: 40.302898 ZoneY: 27.695078 [20:36:04] GroundZ: -12.871663 FloorZ: 26.789127 Have height data (Map: 1 VMap: 1 MMap: 1) [20:36:12] 5361 (Entry: 1731) - [Copper Vein X:833.341003 Y:-4095.000000 Z:25.370001 MapId:1] [20:36:12] Found nearby gameobjects (distance 10.000000): 1 ```

edit: TrinityCore rev. c8c572d9800a 2020-12-10 15:23:58 +0100 (3.3.5 branch) (Win64, Release, Static)

.server debug output

```sql TC> .server debug TrinityCore rev. c8c572d9800a 2020-12-10 15:23:58 +0100 (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.3 Compiled on: Windows 10.0.19042 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: 1962379500 bytes Using enUS DBC Locale as default. All available DBC locales: enUS Using World DB: TDB 335.20111 TC> _ ```

[offl]

We have Calculate.Gameoject.Zone.Area.Data to search something by area\zone

[ghost]

Oh. I see. So it is better to enable those settings in worldserver.conf and then see if it becomes more evened out.