Jump to content

Waypoint Mapper and Coordinates to SQL script converter (LUA, C# WPF)


Chucksta

Recommended Posts

WoW Waypoint Mapper + WoW Continent Coordinates to SQL Script

This is for the creature_movement and creature_movement_template tables - building of paths/routes for NPC's and creatures.

This tool allows the recording of a path you wish an NPC or creature to use, and for the resulting waypoints to be converted to SQL script, so that they can be easily added to the creature's/NPC's creature_movement or creature_movement_template table.

Basically:

- record path waypoints (with WoW addon - CoordinatesRecorder)

- convert to SQL script (with SQL converter - WoWCoordsToSQLScript)

- use your MySQL favourite editor to execute the script in order to add the records to the creature_movement or creature_movement_template tables

I wanted to do this all in the WoW Addon, but due to restrictions implemented by WoW, and without hacking, I have had to create an external program to do the waypoints to SQL script conversion.

The Programs/Tools and Required files

1) CoordinatesRecorder:

WoW addon (must be placed in the Interface/Addons folder of World of Warcraft)

This aids in the recording of the waypoints (click on the button as you move along the path)

CoordinatesRecorder.jpg

You can use slash commands to show and hide the addon's interface whilst in-game:

/coordsmap show

/coordsmap hide

2) WoWChatLog.txt

This holds the waypoint information.

You must activate chat logging, by entering /chatlog in chat.

This file is created with all the chat messages, once you leave the game. The file is not generated as you go along in-game.

3) WoW Continent Coords to SQL Script

This loads the data from the WoWChatLog.txt file and retrieves the waypoint information.

You can then save the data as SQL script, ready to be written to the creature_movement or creature_movement _template tables (copy & paste the script into MySQL Workbench or similar).

ConvertToSQL.jpg

Choose creatures_movement (GUID) or creatures_movement_template (ENTRY) by selecting the 'guid' or 'entry' radio button.

Choose the type of path the creature/NPC will travel, by selecting the 'one direction' or 'bi-directional' radio button.

- 'one direction'. is a path where the creature or NPC only ever travels one way along it, such as a circle.

- 'bi-directional', is a path where the creature or NPC travels in both directions (going back and forth)

OTT help feature :D

ConvertToSQLHelp.jpg

Extra feature (delimiter conversion tool)

If you click on the Delimiter conversion button, the interface reveals the ability to save/convert files so that

they contain whatever delimiter you wish.

You can save the data you just loaded from gathering the path coordinates, or you can load an existing file that you

wish to change the delimiter for.

DelimiterConversionTool.jpg

4) MaNGOS server (only tested with Zero, so far)

You need to be in GM mode, as the Addon uses the .gps command (yeah, I know, should have made a hack!)

EXAMPLE:

I used this to plot out the path for Rexxar, from Stonetalon Mountains, through Desolace, and into Feralas (The Twin Colossals)

It took me 20 minutes, including executing the resulting scripts to add the records to the creature_movement table (via Workbench)

Here, my toon is following Rexxar to make sure the path I have defined for him, using these tools, goes without any problems. All went well :D

RexxarPath.jpg

DOWNLOADS

WoWCoordsToSQLScript tool:

Executable file:

https://github.com/Chuck5ta/WoWCreaturePathMapper/tree/master/WoWCoordsToSQLScript%20exe

Source files (C# WPF):

https://github.com/Chuck5ta/WoWCreaturePathMapper

WoW addon

(this is also included in the above download link!):

https://github.com/Chuck5ta/WoWCreaturePathMapper/tree/master/WoW%20Addon/CoordinatesRecorder

IDE/Editor used:

VS 2013

Notepad++

WoWCoordsToSQLConverterGUI.jpg

CoordinatesGrabberAddon.jpg

ConvertToSQL.jpg

RexxarPath.jpg.0599717b4c5c102966d006179

WoWCoordsToSQLConverterGUI.jpg.154972598

CoordinatesGrabberAddon.jpg.ff1cd5dba916

CoordinatesRecorder.jpg.9fb033d60344bd9f

ConvertToSQL.jpg.acde212abc8d7677b6b1fe9

DelimiterConversionTool.jpg.6b90bb74d2ac

ConvertToSQLHelp.jpg.a138215492f380efd40

ConvertToSQL.jpg.540c9f85efde1dd73bdb7b3

Link to comment
Share on other sites

Changelog

v1.2.0.0 Coordinates Recorder WoW addon (14 October 2014)

- support for creature_movement_template added (no idea why I did not have this included to start with!)

- Added the choice of 2 types of path that the creature/NPC can take:

  1. one way (can only go in one direction along the path)
  2. bidirectional (back and forth movement along the path)

v1.1.0.0 Coordinates Recorder WoW addon (14 October 2014)

- Slash commands added to show and hide the addon's interface

- SHOW ADDON: /coordsmap show

- HIDE ADDON: /coordsmap hide

v1.0.0.0 Coordinates Recorder WoW addon (28 September 2014)

- First release of the waypoint mapper/coordinates recorder addon for World of Warcraft (only tested on classic).

To Do

Coordinates Recorder Addon

1) Test the addon on other cores and produce new versions of the addon if needed.

2) Implement the option of automatic recording of waypoints (e.g. to fire every x feet)

Link to comment
Share on other sites

  • 2 weeks later...

Oops, sorry, will sort that now.

I need to make it so that the addon can be enabled and disabled from chat, but I'll fix this link first, then do the necessary on the addon.

EDIT: Links fixed :)

EDIT: AGAIN!!! New version (1.1.0.0) of the addon just added (14 Oct 2014 17:20hrs). Virus total updated too :)

Now includes slash commands to hide and show the addon's interface

SHOW ADDON: /coordinatesrecorderon OR /coordrecon

HIDE ADDON: /coordinatesrecorderoff OR /coordrecoff

I'll now change the 2nd post of this thread to better reflect the state of this tool.

Link to comment
Share on other sites

Thanks a lot, Chucksta, I'll gladly test it. I had no idea what to use for waypoint creation if not your convertor without coding such a thing myself :)

I tell you, it flummoxed me for a bit when I found that the built in function that was used to get continent level coordinates had been removed/disabled by Blizzard, and that file I/O was disabled too. Nightmare!

The little grey cells (brain) did their magic and came up with the logging of the chat and the use of the GM command .gps :D

Another way would be to locate where and how your character's coordinates are stored in the game's process's memory, then you'd only need the external tool, which would do both the recording of the waypoints and conversion to SQL script.

Good luck with the testing :)

Link to comment
Share on other sites

  • 1 year later...

Tool updated (v1.2.0.0):

The tool can now be used for both the creature_movement and creature_movement_template tables!

  • select the 'guid' radio button if wishing to generate script for the creature_movement table.
  • select the 'entry' radio button if wishing to generate script for the creature_movement_template table.

Added the ability to choose from 2 types of path, one way and bidirectional.

  1. one way - creature/NPC can only travel in one direction on the path (e.g. Rexxar)
  2. bidirectional - creature/NPC can travel back and forth along the path.

Link to comment
Share on other sites

  • 4 months later...

Well this is actually very unnecessary because you can do it with GM-Commands much easier.

Just type in: .npc addmove CreatureID

CreatureID is the number which is unique for the NPC. Or better said for this version of the NPC. It is called GUID. Put this in a macro and thats it. Thats much easier than a third party tool could be.

Link to comment
Share on other sites

Well this is actually very unnecessary because you can do it with GM-Commands much easier.

Just type in: .npc addmove CreatureID

CreatureID is the number which is unique for the NPC. Or better said for this version of the NPC. It is called GUID. Put this in a macro and thats it. Thats much easier than a third party tool could be.

Interesting, I did not know about the GM command.

For me, this was just a buzz to create a tool. If people use it then great, if they don't need it then no big deal, but for me it's all in the high I get from creating and problem solving.

Link to comment
Share on other sites

  • 2 months later...

I am getting an error after clicking on "Grab Data".

 

What i did:

Logged in

write .gm on

write /chatlog

clicked on NPC

clicked on addon ( i got .gps and white message which includes the coordinates)

Logged out

copied Logfile into "WoWCoordsToSQLScript exe" folder

entered GUID Char name etc

clicked on "WTF!!" (loaded logfile)

clicked Grab Data

 

Makes a weird error and then closes it.

 

For now i will just use the Chatlogfile.txt, its already helpfull for me, it would be much more helpfull if the programm printed it, much better overview....

Turning the chatlogfile.txt into Excel... tried it? Its in perfecet order try it

Link to comment
Share on other sites

Quote

I am getting an error after clicking on "Grab Data".  

I just tried this out and it worked fine.

The WTF button does not need to be pressed. That just reformats the text in the message box area.

What is the error message that pops up?

 

 

Link to comment
Share on other sites

Ah ha, das ist das problem, du bist Deutsch!

;) 

It may be the contents of the WoWChatLog file. Can you post a copy of one of yours here, bitte :) 

That reminds me, I must get on with my German language studies. I'm off to Oktoberfest in the last week of September :D 

 

Link to comment
Share on other sites

Carefull its long:

 

Spoiler

7/26 18:04:34.365  Clarklee says: sef
7/26 18:04:42.412  You are OUTdoor
7/26 18:04:42.412  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8824.967773 Y: 622.435059 Z: 93.970741 Orientation: 3.953231grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.427349 ZoneY: 60.926476GroundZ: 93.968750 FloorZ: 93.969910 Have height data (Map: 1 VMap: 1)
7/26 18:04:42.462  Clarklee says: XStart -8824.967773 XEndYStart 622.435059 YEndZStart 93.970741 ZEnd
7/26 18:10:06.048  Thomas Miller says: Fresh bread for sale
7/26 18:10:07.851  You are OUTdoor
7/26 18:10:07.851  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8831.629883 Y: 620.507019 Z: 93.733200 Orientation: 1.954420grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.570774 ZoneY: 61.669720GroundZ: 93.726563 FloorZ: 93.733223 Have height data (Map: 1 VMap: 1)
7/26 18:10:07.901  Clarklee says: XStart -8831.629883 XEndYStart 620.507019 YEndZStart 93.733200 ZEnd
7/26 18:10:09.854  Thomas Miller says: Get it while its hot
7/26 18:18:47.651  Object GUID is: Creature (Entry: 2532 Guid: 590022)
7/26 18:18:54.864  You are OUTdoor
7/26 18:18:54.864  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8828.013672 Y: 619.076233 Z: 94.057335 Orientation: 2.764683grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.677212 ZoneY: 61.266285GroundZ: 94.273438 FloorZ: 94.273781 Have height data (Map: 1 VMap: 1)
7/26 18:18:54.914  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:18:58.856  You are OUTdoor
7/26 18:18:58.856  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8825.367188 Y: 619.252991 Z: 94.229904 Orientation: 6.089272grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.664063 ZoneY: 60.971035GroundZ: 94.429688 FloorZ: 94.426262 Have height data (Map: 1 VMap: 1)
7/26 18:18:58.906  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:04.666  You are OUTdoor
7/26 18:19:04.666  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8818.325195 Y: 615.268616 Z: 94.924904 Orientation: 2.766675grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.960461 ZoneY: 60.185410GroundZ: 95.015625 FloorZ: 95.010803 Have height data (Map: 1 VMap: 1)
7/26 18:19:04.716  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:08.557  You are OUTdoor
7/26 18:19:08.557  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8827.631836 Y: 618.932434 Z: 94.091393 Orientation: 2.766675grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.687908 ZoneY: 61.223686GroundZ: 94.312500 FloorZ: 94.317833 Have height data (Map: 1 VMap: 1)
7/26 18:19:08.557  You are OUTdoor
7/26 18:19:08.557  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8827.631836 Y: 618.932434 Z: 94.091393 Orientation: 2.766675grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.687908 ZoneY: 61.223686GroundZ: 94.312500 FloorZ: 94.317833 Have height data (Map: 1 VMap: 1)
7/26 18:19:08.624  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:08.624  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:17.457  You are OUTdoor
7/26 18:19:17.457  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8820.000000 Y: 618.200012 Z: 94.654602 Orientation: 2.426430grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.742393 ZoneY: 60.372253GroundZ: 94.648438 FloorZ: 94.653618 Have height data (Map: 1 VMap: 1)
7/26 18:19:17.507  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:19.360  You are OUTdoor
7/26 18:19:19.360  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8828.844727 Y: 630.121277 Z: 94.125519 Orientation: 5.289190grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 55.855572 ZoneY: 61.358997GroundZ: 94.117188 FloorZ: 94.125801 Have height data (Map: 1 VMap: 1)
7/26 18:19:19.411  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:20.463  You are OUTdoor
7/26 18:19:20.463  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8830.145508 Y: 632.120422 Z: 94.199112 Orientation: 5.289190grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 55.706856 ZoneY: 61.504116GroundZ: 94.203125 FloorZ: 94.200195 Have height data (Map: 1 VMap: 1)
7/26 18:19:20.512  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:28.160  All visual waypoints removed
7/26 18:19:28.209  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:19:32.268  You are OUTdoor
7/26 18:19:32.268  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8816.907227 Y: 614.701599 Z: 95.052315 Orientation: 2.766221grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 57.002640 ZoneY: 60.027214GroundZ: 95.093750 FloorZ: 95.095718 Have height data (Map: 1 VMap: 1)
7/26 18:19:32.318  Clarklee says: XStart -8816.907227 XEndYStart 614.701599 YEndZStart 95.052315 ZEnd
7/26 18:19:59.618  You are OUTdoor
7/26 18:19:59.618  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8817.042969 Y: 615.196289 Z: 95.016716 Orientation: 5.532764grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.965839 ZoneY: 60.042358GroundZ: 95.031250 FloorZ: 95.041687 Have height data (Map: 1 VMap: 1)
7/26 18:19:59.669  Clarklee says: XStart -8817.042969 XEndYStart 615.196289 YEndZStart 95.016716 ZEnd
7/26 18:34:02.571  You are OUTdoor
7/26 18:34:02.571  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8821.711914 Y: 616.493286 Z: 94.627213 Orientation: 2.756992grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.869354 ZoneY: 60.563240GroundZ: 94.804688 FloorZ: 94.805801 Have height data (Map: 1 VMap: 1)
7/26 18:34:02.621  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:08.965  You are OUTdoor
7/26 18:34:08.965  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8828.964844 Y: 624.458008 Z: 93.876823 Orientation: 0.992317grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.276863 ZoneY: 61.372398GroundZ: 93.875000 FloorZ: 93.883049 Have height data (Map: 1 VMap: 1)
7/26 18:34:09.016  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:10.919  You are OUTdoor
7/26 18:34:10.919  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8826.684570 Y: 626.202942 Z: 94.024193 Orientation: 5.407825grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.147057 ZoneY: 61.118004GroundZ: 93.882813 FloorZ: 93.893150 Have height data (Map: 1 VMap: 1)
7/26 18:34:10.969  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:14.359  You are OUTdoor
7/26 18:34:14.359  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8821.314453 Y: 619.773804 Z: 94.530640 Orientation: 5.408825grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.625320 ZoneY: 60.518898GroundZ: 94.453125 FloorZ: 94.453087 Have height data (Map: 1 VMap: 1)
7/26 18:34:14.409  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:16.513  You are OUTdoor
7/26 18:34:16.513  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8822.847656 Y: 625.673950 Z: 93.818680 Orientation: 5.148585grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.186409 ZoneY: 60.689949GroundZ: 93.812500 FloorZ: 93.818855 Have height data (Map: 1 VMap: 1)
7/26 18:34:16.564  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:17.615  You are OUTdoor
7/26 18:34:17.615  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8822.847656 Y: 625.673950 Z: 93.818680 Orientation: 5.148585grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.186409 ZoneY: 60.689949GroundZ: 93.812500 FloorZ: 93.818855 Have height data (Map: 1 VMap: 1)
7/26 18:34:17.665  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:19.720  You are OUTdoor
7/26 18:34:19.720  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8819.659180 Y: 615.678650 Z: 94.811424 Orientation: 2.758048grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.929958 ZoneY: 60.334232GroundZ: 94.937500 FloorZ: 94.938255 Have height data (Map: 1 VMap: 1)
7/26 18:34:19.770  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:25.914  You are OUTdoor
7/26 18:34:25.914  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8830.141602 Y: 622.556763 Z: 93.816490 Orientation: 1.003018grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.418297 ZoneY: 61.503681GroundZ: 93.843750 FloorZ: 93.846718 Have height data (Map: 1 VMap: 1)
7/26 18:34:25.964  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:30.873  You are OUTdoor
7/26 18:34:30.873  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8823.235352 Y: 622.084351 Z: 94.349266 Orientation: 5.406356grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.453438 ZoneY: 60.733200GroundZ: 94.062500 FloorZ: 94.058945 Have height data (Map: 1 VMap: 1)
7/26 18:34:30.923  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:34.013  You are OUTdoor
7/26 18:34:34.013  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8817.958984 Y: 616.174072 Z: 94.902084 Orientation: 5.501297grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.893101 ZoneY: 60.144554GroundZ: 94.929688 FloorZ: 94.918877 Have height data (Map: 1 VMap: 1)
7/26 18:34:34.063  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:36.717  You are OUTdoor
7/26 18:34:36.717  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8823.780273 Y: 630.429993 Z: 94.100601 Orientation: 4.031710grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 55.832607 ZoneY: 60.793995GroundZ: 94.015625 FloorZ: 94.017365 Have height data (Map: 1 VMap: 1)
7/26 18:34:36.768  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:40.858  You are OUTdoor
7/26 18:34:40.858  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8829.050781 Y: 631.483887 Z: 94.170807 Orientation: 5.169005grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 55.754208 ZoneY: 61.381989GroundZ: 94.171875 FloorZ: 94.172127 Have height data (Map: 1 VMap: 1)
7/26 18:34:40.858  You are OUTdoor
7/26 18:34:40.858  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8829.050781 Y: 631.483887 Z: 94.170807 Orientation: 5.169005grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 55.754208 ZoneY: 61.381989GroundZ: 94.171875 FloorZ: 94.172127 Have height data (Map: 1 VMap: 1)
7/26 18:34:40.908  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:40.908  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:49.224  You are OUTdoor
7/26 18:34:49.224  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8821.297852 Y: 619.706238 Z: 94.533012 Orientation: 5.423512grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.630344 ZoneY: 60.517048GroundZ: 94.460938 FloorZ: 94.460724 Have height data (Map: 1 VMap: 1)
7/26 18:34:49.274  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:52.180  You are OUTdoor
7/26 18:34:52.180  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8820.831055 Y: 615.168701 Z: 96.825714 Orientation: 2.247324grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.967892 ZoneY: 60.464970GroundZ: 94.976563 FloorZ: 94.970078 Have height data (Map: 1 VMap: 1)
7/26 18:34:52.280  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:56.872  You are OUTdoor
7/26 18:34:56.872  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8829.261719 Y: 627.023621 Z: 94.012543 Orientation: 5.302523grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.086006 ZoneY: 61.405521GroundZ: 94.007813 FloorZ: 94.012520 Have height data (Map: 1 VMap: 1)
7/26 18:34:56.922  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:34:58.675  You are OUTdoor
7/26 18:34:58.675  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8829.466797 Y: 619.630371 Z: 93.928352 Orientation: 2.756765grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.635990 ZoneY: 61.428398GroundZ: 94.078125 FloorZ: 94.077919 Have height data (Map: 1 VMap: 1)
7/26 18:34:58.725  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:35:11.132  You are OUTdoor
7/26 18:35:11.132  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8832.898438 Y: 619.156372 Z: 93.532104 Orientation: 0.387353grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.671249 ZoneY: 61.811241GroundZ: 93.578125 FloorZ: 93.576736 Have height data (Map: 1 VMap: 1)
7/26 18:35:11.182  Clarklee says: XStartXEndYStartYEndZStartZEnd
7/26 18:35:29.866  You are OUTdoor
7/26 18:35:29.866  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8819.645508 Y: 617.847656 Z: 94.697639 Orientation: 5.500810grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.768604 ZoneY: 60.332706GroundZ: 94.710938 FloorZ: 94.699646 Have height data (Map: 1 VMap: 1)
7/26 18:35:29.916  Clarklee says: XStart -8819.645508 XEndYStart 617.847656 YEndZStart 94.697639 ZEnd
7/26 18:35:34.708  You are OUTdoor
7/26 18:35:34.708  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8821.219727 Y: 616.282349 Z: 94.672363 Orientation: 2.756238grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.885048 ZoneY: 60.508331GroundZ: 94.843750 FloorZ: 94.839218 Have height data (Map: 1 VMap: 1)
7/26 18:35:34.725  You are OUTdoor
7/26 18:35:34.725  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8821.219727 Y: 616.282349 Z: 94.672363 Orientation: 2.756238grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.885048 ZoneY: 60.508331GroundZ: 94.843750 FloorZ: 94.839218 Have height data (Map: 1 VMap: 1)
7/26 18:35:34.776  Clarklee says: XStart -8821.219727 XEndYStart 616.282349 YEndZStart 94.672363 ZEnd
7/26 18:35:34.776  Clarklee says: XStart -8821.219727 XEndYStart 616.282349 YEndZStart 94.672363 ZEnd
7/26 18:35:39.066  You are OUTdoor
7/26 18:35:39.066  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8831.064453 Y: 620.277649 Z: 93.784195 Orientation: 2.755748grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.587837 ZoneY: 61.606640GroundZ: 93.812500 FloorZ: 93.823433 Have height data (Map: 1 VMap: 1)
7/26 18:35:39.117  Clarklee says: XStart -8831.064453 XEndYStart 620.277649 YEndZStart 93.784195 ZEnd
7/26 18:35:41.003  You are OUTdoor
7/26 18:35:41.003  Map: 0 (Eastern Kingdoms) Zone: 1519 (Stormwind City) Area: 1519 (Stormwind City)X: -8829.273438 Y: 624.044861 Z: 93.859352 Orientation: 0.983019grid[15,33]cell[7,2] InstanceID: 0 ZoneX: 56.307594 ZoneY: 61.406826GroundZ: 93.867188 FloorZ: 93.871338 Have height data (Map: 1 VMap: 1)
7/26 18:35:41.070  Clarklee says: XStart -8829.273438 XEndYStart 624.044861 YEndZStart 93.859352 ZEnd

 

I dont have SQL btw, only the MySQL thing that is required to start the Game. I mean the Database thing, i dont know how to make it.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use