Giter Club home page Giter Club logo

wowcoordinatestosqlpaths's Introduction

WowCoordinatesToSQLPaths

WowCoordinatesToSQLPaths is inspired by https://github.com/Chuck5ta/WoWCreaturePathMapper. His WoW Addon has been modified and the WowCoordinatesToSQLPaths tool has been written from scratch.

This tool can be used for creating paths for creatures and NPC for a World of Warcraft Private Server.
Currently only tested with cmangos-classic.

WowCoordinatesToSQLPaths Tool consists of

  • World of Warcraft Addon: CoordinatesRecorder
  • Waypoints to SQL tool: WowCoordinatesToSQLPaths

How To

  1. Download the latest release here : Releases
  2. Grab the Addon CoordinatesRecorder and install it. (Put the addon folder CoordinatesRecorder into your Interface folder.)
  3. Make sure your character has GM privileges with the .gps command
  4. Start the Game and join your server
  5. Make sure the addon has been installed and you see this window:
    Addon Frame
    /coordsmap show or /coordsmap hide
  6. We recommen pressing the Reset butotn before every recording session to make sure no old values are being saved
  7. Record waypoints by moving around and pressing the Record Waypoint button (You only need to record the waypoints in one direction)
  8. When waypoints have been recorded, log out to generate the addon log file
  9. Start WowCoordinatesToSQLPaths.exe
  10. Fill in the creature guid for creature_movement table or creature_template entry for creature_movement_template table / script_waypoint table and load the addon log file from your ../WoW/WTF/Account/Username/SavedVariables/CoordinatesRecorder.lua.
  11. Select the wished type of path (one-directional, bi-directional or script). By selecting script we assume you provide the creature_template entry.
  12. Optionally edit the values.
  13. Save the waypoints which will be saved as a sql script.
  14. Execute the SQL script on your database.
  15. Test and hf.

Made using:

  • VS2017 -> C# / WPF
  • Notepad++ / VS Code -> Lua, XML -> WoW Addon
  • Coffee -> Code

Why remake an existing tool?

A good question. We just wanted to have some special functionalities and our own code base as practice and learning project.

Some Screenshots

Default Layout on startup

Default

Script Waypoints Preview

Script Selected

Required fields have to be filled in

GUID Or Entry Required

Example data loaded

You can still switch between the different types of path / table types Script Waypoints

Autoadjusting in width to fit in all columns

Creature Movement

Any fields can be edited in the data grid

Editeable Data Grid

TODO

  • A better ui?
  • CSV support, not even sure if needed
  • Support for other server types - currently not interested myself, but may take a look when someone requests it.
  • anything else?

Contributing

Feel free to contribute by making changes / additions and making pull requests.

Contributors

Recommend Projects

  • React photo React

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

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

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

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

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

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.