Deleted User

We definitely need a "Valkryst Approves" award for outstanding excellence in the field of anything I approve of. One thing I think is pretty weird, is that the "Back To Top" bar is visible while you're at the top of the page.

It's still hanging around on my HDD. There's just too much to finish on it for now, so I've shelved it for some amount of time.

I'm pretty-much done with working on my own server, so I've got some time to write a few random scripts for whoever. Basically anything within reason is doable, so run the idea by me over Skype before you think I'll do it. Prices are going to vary from script to script, but anything overly basic is 1-3$. Past that you're looking at 5-10$ for most things. Larger systems or more complex scripts that require a lot of work and debugging will vary. Not going to be checking topic replies, so message directly on Skype. ---------------------------------- Completed Work: Dynamic Gameobject Linked-Teleportation System - Ayleth Token Exchange System - Devon the Grim ---------------------------------- Work to Do: MOBA Character Data-handling System - Real Super Sand ---------------------------------- Skype - valkryst.

Use the new version of OSB, from here and use MPV instead of VLC as VLC seriously fucks with the colors of the video on playback compared to MPV, you can see a shitty comparison here.

Before typing out the rest of this post, I’d like to thank Legion for giving me the idea to write this post. If you know of any additional information, notice an error, etc.. just comment and I’ll do my best to keep this post updated. In this post I will assume that you know enough to competently use the in-game commands on a TrinityCore server. Just in case anyone wants to know what I’m running: Windows 8, x64 — HomeDebian 7 x32 — ServerTrinityCore — Latest version as of 20/June/2015WotLK 3.3.5aNotes: There are a number of waypoint-related commands and you may be wondering what they’re all for even if we won’t be using them in this tutorial. The commands are as follows. .wp add ID – This command adds a new waypoint record to the database using the specified ID. It is recommended that you use the creature’s GUID as the ID. This prevents any errors that may occur from mix-matching IDs..wp event – I’m not entirely sure what this command is used for, nor have I had a use for it yet. If anyone knows, please comment below..wp load ID – This command will load (attach) the waypoint path specified by the ID to whichever NPC is selected when the command is executed..wp modify – I’m not entirely sure what this command is used for, nor have I had a use for it yet. If anyone knows, please comment below..wp reload ID – Whenever an existing waypoint path is altered, or a new waypoint path created, this command must be run to reload the waypoint path so that the server recognizes either the new points or the entire new path. This must be done before using .wp load ID..wp show on ID – Shows the waypoint path specified by the ID..wp show on – Shows the waypoint path loaded (attached) to the selected NPC..wp show off – Hides the currently visible waypoint path..wp info – Shows some information for the currently selected waypoint path.Waypoint Creation Example: For this example we require the GUID of the creature that will be set to the waypoint path that will be created. You can find the GUID by using the command .npc info while having an NPC selected. The GUID that we are using is listed as the DB GUID in the large section of information that shows up after the command. As this is such a simple process, I will describe it step-by-step instead of writing it out as a paragraph. Whenever you see the acronym GUID in a command below, replace it with the GUID of the creature you are creating a waypoint for. Create a Macro and enter .wp add GUID. We will call this Macro #1.Create another Macro and enter .wp reload GUID on the first line and .wp load GUID on the second line. We will call this Macro #2.Add both Macros to your action bar.Make sure that the NPC is spawned at the starting position of the waypoint path, if it isn’t, then spawn it at the correct location and return to step #1 and use the new GUID.Click Macro #1.Walk to the next point.Click Macro #1.Go back to step #6 until you reach the end of the waypoint path. When you reach this point, don’t stop! You need to make a path back to the starting position.Walk to the next point.Click Macro #1.Go back to step #9 until you reach a point that is a straight line from the start of the waypoint path. From this point we are done creating the path as the creature will walk in a straight line back to the first waypoint in the waypoint path from the last waypoint in the waypoint path.Click Macro #2. Your NPC should begin to walk on the waypoint path. If the NPC does not begin walking on the waypoint path, try restarting the server.After setting an NPC on a waypoint path, I always watch the NPC complete one full cycle of the path to make sure that it turned out as intended. Whenever the path is anything except for correct, I run the following query on my database and restart the server. This will erase the entire wapoint path and allow you to start from scratch. Query to delete an entire waypoint path.-- Replace GUID with the GUID of the creature -- that you created a waypoint path for. DELETE FROM waypoint_data WHERE id = GUID; If you’d like to delete all unused waypoints at once, you can run the following query without modifying it. DELETE FROM waypoint_data WHERE (SELECT COUNT(1) FROM creature WHERE guid = waypoint_data.id) < 1

Just to note, on Linux this is usually... service mysql stop //To stop MySQL service mysql start //To start MySQL service mysql restart //To restart MySQL

Around ~6 hours or-so worth of work and I've got around 70% of the city roughly laid-out. After the layout is fine and all building collisions (that aren't intended) are eliminated, then the detail will be added, and finally we'll go in and hand-decorate the entire city with GOs.

Around ~6 hours or-so worth of work and I've got around 70% of the city roughly laid-out. After the layout is fine and all building collisions (that aren't intended) are eliminated, then the detail will be added, and finally we'll go in and hand-decorate the entire city with GOs.