The first one is to assign a path in creature_addon table. The path is then in waypoint_data table. This one is used for any permanently spawned NPC that is supposed to perform WP movement all the time.

The second one is to assign a path via smart_scripts. The path is then in waypoints table. Typically this is used for one-time waypoint movements i.e. in quest scripts.

Both movements behave like a point movement from A to B. This is alright for ground NPCs.

But when you take a look at sniffs or videos you will notice that flying NPCs on a permanent flying path don't use point movement. In fact they use cyclic splines.

For the one-time waypoint movements especially of flying vehicle NPCs catmullrom splines are used. This makes them behave like taxi flights.

These two features are not working right now. They should be implemented.

Maybe optionally for persisting waypoint movements or even better in a generic way that makes the core decide which one has to be used.

There is already quite a bunch of spline related functions in the core like SetSmooth and SetCyclic. Hopefully half the work is already done by now...

change Table `npc_trainer` contains an entry for a creature template (Entry: 50025) without trainer flag, ignoring to a single row/afected npc.
Allow parameter to onlinelist to allow choice map/zone, add country, names of maps, zones with for example onlinelistextended. Ie: account onlinelist map 0.

add location to group list.
list instanceid id list the ppl on one instance id returning instance id, playername, location and if it's online or no (can be used to discover cheaters (25 man on a 10 man raid)

tele instanceid (or iid) to allow gm to teleport a selected instance id (ie to fix problems of teleportation to some heroic instances/raids without having to unbind.
tele name <player> npcid / npcguid <id/guid>

Allow every command with time as parameter to choice the time type ie: seconds, hours, days.
adump (account dump).

disable_type_lfg_map
disable_type_random_battleground

change .account password <old> <new> <new> to .account password <old> <new> <new> <email> and if email don't matches don't change and maybe even send email of the try with the ip of the changer. maybe conf?
create a gm command to allow to read guild_eventlog and guild_bank_eventlog without having to join guild.

Full locales implementation: A lot of tables misses locales (IE commands help, game_tele).
A command to check if a player fits the requirements of one quest (have all items and where (on player, on bank), killed all mobs, etc) and location of quest taker.

A setting to allow to choice raid reset raid.
Split Rate.InstanceResetTime on Rate.RaidDiff0ResetTime, Rate.RaidDiff1ResetTime, Rate.RaidDiff2ResetTime, Rate.RaidDiff3ResetTime and Rate.DungeonDiff1ResetTime.
(why no 10m,25m, etc is obvious to avoid ppl asking "what i must change for the 20 man or 40 man instances")

Allow game_event table to start on X day of the week (ie sunday) X day of the month (1st of june) X day (1st sunday of month)
Allow .additem to ignore the unique flag to get 1 unique item on inventory.

On retail when you try to send one email to a gm you get "cannot find mail recipient" maybe it can be added with a conf 0 allow mails, 1 disable mails from players, 2 disable all mails, 3 remember last state.
Add .wp modify orientation .wp modify posx/y/z commands.

Allow .additem to set player if isnt targeted for example .additem <item id> <player id/player name>
Last ip stats for account/character stored on db and available on db.

A command to dump a whole guild and restore with all the members and bank items, if items are somewhere else write where they are (to restore defaced guilds)
Change account lock on/account lock off to simply account lock and switch lock status on use.

Allow to set the duration of the spells used with aura.
Allow to reload any possible table.

Add the amount of gold and tokens to connection/disconection logs can help to detect exploits.
a command to list the amount of tokens one character owns.

ainfo, account info, adds the last ips one account used, creation date, email, number of characters, level, class, gold, location, rename from lookup player account/ip/email.
Easy way to avoid GO/creature overflow:
Leave a hole on creature/gameobjects db, ie max db entry+100000 ¿config?, when server starts the mobs on instances starts to spawn from the max db entry+100000 (ie 301914), if you use .npc add 10000 it goes to be added after the last db entry ie 201914. No need of new tables, and almost 100% safe of gms overspawning mobs ingame with high uptimes on high pop servers.

Account/character ip history loging the ips one player used and a command to allow gm read them.
debug loot command, to allow gm to see the loot one mob generated if you are unable to loot the mob because some strange reason (ie keltzuzad failing to give loot).

Guild list <"part of name"> lists guilds with the name, shows guild master, last guild master online, guild members amount, last guild member online.
Guild info <"name"> rank <#> limit <#> shows detailed info about guild, shows guild master, last guild master online, guild members amount, members list, note, officer note.

mod xp command to allow gm to reward the xp of one quest after core crash. Thx Guybrush.
a command to allow gms to see friendlist of someone and who have someone on friendlist, ignore and who have it on ignore.

lookup area id command, to allow to search area names.
Seperate config to change rate of money for quests. Idea by Ascathor.

Allow to set the duration of freeze command.
MoP like loot system for nearly mobs (disabled by default)(the one that looting one mob allows you loot every mob near you).

Allow npc info to have guid and be used from console ie: npc info guid 10000.

None.

-- ------------------
-- -- Event Spawns --
-- ------------------
SET @CGUID := 138255; -- Set by TDB
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID AND @CGUID+2;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(@CGUID,20102,530,1,1,0,0,3038.56,3635.53,144.012,3.32713,300,0,0,42,0,0,0,0,0),
(@CGUID+1,32823,0,1,1,0,0,-5082.28,-792.136,495.678,1.86906,300,0,0,1,0,0,0,0,0),
(@CGUID+2,32823,0,1,1,0,0,-5093.01,-795.451,495.128,3.49483,300,0,0,1,0,0,0,0,0);

	/// Sets an UPDATE_FIELD, for a float value
	void SetFloatValue(uint16 index, float value);
	/// Sets an UPDATE_FIELD, for a byte value
	void SetByteValue(uint16 index, uint8 offset, uint8 value);
	/// Sets an UPDATE_FIELD, for a short int value
	void SetUInt16Value(uint16 index, uint8 offset, uint16 value);

function documentation (extended)
---------------------------------

/**
* @brief Tries to find a GameObject given an entry and a range
*
* This function searches for a GameObject in place and returns
* the closest one, if found.
*
* @param entry GameObject entry to find
* @param range The range around the caller the search will be done
*
* @return A GameObject* if found, NULL otherwise
*
* Example Usage:
* @code
* if (GameObject* cage = me->FindNearestGameObject(1234, 10.0f))
*     cage->SetGoState(GO_STATE_ACTIVE);
* @endcode
*/
GameObject* FindNearestGameObject(uint32 entry, float range) const;

/**
* @brief Returns the template of the item
*
* This function returns the template of an item, which was taken
* from the DB and loaded at startup.
*
* @return An ItemTemplate const*
*
* Example Usage:
* @code
* if (Item* item = GetItemByPos(NULL_BAG, NULL_SLOT))
*     ItemTemplate const* proto = item->GetTemplate();
* @endcode
*/
ItemTemplate const* GetTemplate() const;

file documentation
------------------

/**
* @file cs_account.cpp
* @brief .account related commands
*
* This file contains the CommandScripts for all
* account sub-commands
*/

class member documentation
--------------------

private:
uint32 m_InstanceId; ///< in map copy with instance id
uint32 m_phaseMask; ///< in area phase state

tagging (anywhere)
------------------

else /// No more vacant places
{
/// @todo Send a packet to announce it to player
m_PlayersWillBeKick[player->GetTeamId()][player->GetGUID()] = time(NULL) + 10;
InvitePlayerToQueue(player);
}

...

/// @workaround We do not know what types of stealth should be interrupted by CC
if ((m_spellInfo->AttributesCu & SPELL_ATTR0_CU_AURA_CC) && unit->IsControlledByPlayer())
unit->RemoveAurasByType(SPELL_AURA_MOD_STEALTH);

Useful links
------------

Doxygen
Doxygen

```code
src/server/scripts/Spells/spell_generic.cpp | 9 +++++++--
1 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/src/server/scripts/Spells/spell_generic.cpp b/src/server/scripts/Spells/spell_generic.cpp
index 80474f2..a301428 100644
--- a/src/server/scripts/Spells/spell_generic.cpp
+++ b/src/server/scripts/Spells/spell_generic.cpp
@@ -1262,6 +1262,11 @@ class spell_gen_launch : public SpellScriptLoader
}
};

+enum VehicleScaling
+{
+ SPELL_GEAR_SCALING = 66668,
+};
+
class spell_gen_vehicle_scaling : public SpellScriptLoader
{
public:
```

```sql
insert into ........
```

NOTE it's very important to leave one empty row before ```code or ```sql

• We reserve the right to remove, at any time and without notice, any content from these message boards.
  
  
• We do not support data, binary or source developed externally from the TrinityCore Development Team. Please refrain from posting questions or support topics on these subjects. Support should be given by it's original authors, and not by the TrinityCore Development Team.
  
  
• Refrain from using inappropriate language, including language that may look, sound like, stand for, hint at, abbreviate, or insinuate profanity, hate speech (including but not limited to racial, ethnic, or religious slurs).
  
  
• If it is found that a user has fraudulently registered, their account will immediately be terminated.
  
  
• We reserve the right to contact your ISP regarding any inappropriate activities by you on the message boards.
  
  
• Reposting content, help, documentation or otherwise that is not yours will result in a ban. Plagiarism will not be tolerated here.
  
  
• You may not post: .dbc, .map and or relevant materials that are under copyright. Please keep posts restricted to database entry and database related software, accordingly.
  
  
• Any links containing custom "repacks" of server files will be deleted, and the user will be issued a warning. These files are not supported by the TrinityCore Development Team. Please keep discussion on custom "repack" content to a minimum and off the message boards.
  
  
• We reserve the right to immediately terminate or suspend anyone who fails to abide by these General Rules of Conduct.

• Offensive Material - Users may not transmit or encourage others to transmit material or links to material considered patently offensive in nature. This includes, but is not limited to using vulgar, profane, or sexually explicit language; using race, religion, sexual orientation, culture, ethnicity, handicap, nationality, or gender as a means of insult; using threatening, harassing, defamatory, hate-speech, or libelous language; and posting, requesting, or otherwise sharing material considered pornographic, obscene, graphic, or hate speech.
  
  
  
• Vulgar language or substitutes for such - Our forums are programmed with a list of words that are considered vulgar under any context, and these words are not allowed to be used under any circumstances. Attempting to bypass the censor by misspelling, inserting spaces or symbols, transposing letters, using look-alike symbols, or any other method is not allowed. The only acceptable method of posting one of these vulgar words is to completely obscure it, making it impossible to determine what the word is without context. Additionally, certain words are prohibited from being used in topic titles and user information pages; bypassing the censor to post those words where they are restricted is also disallowed. For example, if "poop" is a banned word, the following are examples of bypassing that are not allowed: p-o-o-p, po*p, dood. Taking advantage of any limits in the forum's language filtering capabilities is not allowed. Any limits in such filters shall not be taken as permission to bypass rules regarding vulgar language.
  
  
  
• Flaming - Communications clearly insulting other users, individually or as a group, directly or indirectly, are not allowed. This includes, but is not limited to: name-calling ("You're an idiot", "You moron"); direct insults and orders ("Screw you", "Go kill yourself"); insinuations ("Are you stupid or something?"); or insults towards family ("Your mom...").
  
  
• Trolling (Inciting flames) - Messages intended solely to annoy and/or offend other users by going against the clear nature of a board, topic or chat room are not allowed. This includes, but is not limited to: provoking other users to respond with flames; provoking fans of a particular system or game, especially on boards or topics dedicated to that system or game; making misleading topic titles; asking obviously useless questions; and posting false information as fact.
  
  
• Illegal activity - Communications that violate or incite others to violate the law are not allowed. This includes, but is not limited to, asking for or providing: illegal copies of copyrighted software; methods of circumventing copyright protection; illegal copies of copyrighted music, movies, videos, or any other type of media; reprints of material from other web sites; or methods of cheating in online games.
  
  
• Advertising - Messages that clearly advertise a service or product are not allowed. This includes, but is not limited to: unsolicited commercial or personal web site advertisements(ı); :For-Sale/For-Trade/For-Auction/Wanted: notices; "Make Money Fast" scams, chain letters, and pyramid schemes; or any referrer-ID based sites (including both games and free-item marketing sites).
  
  
  (ı) THIS MEANS ANY PERSONAL SERVER OR WEBSITE HOSTING ANY CONTENT.
  
• Off-topic postings - The main purpose of the message boards is to provide discussion forums and opportunities for various Databases and Multi-functional Server Software. Topicality is expected and will be enforced on all message board sections.
  
  
• Disruptive Behavior - Behavior that disrupts the service for other users, intentional or not, are prohibited. This includes, but is not limited to: messages or topic titles that force browsers to scroll horizontally; large blank or content-free messages; "bumping" multiple older topics (posting in them well after the last post); posting multiple identical or near-identical messages or topics, including "fad" posts or topics; intentionally hard-to-read topic titles or posts (i.e. ALL CAPS, AlTeRnAtE cApS, no spaces, no or excessive punctuation); posting multiple hard-to-read or nonsensical messages in a single or multiple topics; posting large ASCII art (except in social topics specifically calling for it); or post counting (i.e. "First", "100th Post"). Double-posting or otherwise not editing your last post is considered disruptive behavior.
  
  
• Flooding, Invading, and Board Wars - Flooding a forum with multiple disruptive topics or messages; invading another board (flooding a board as a group with multiple topics or messages); instigating, participating in, or retaliating in an invasion of a message board or any other online service; announcing or inciting a "war" or any conflict with the regular members of another board.
  
  
• Impersonation - Impersonating other users by creating and/or using a user account with a name clearly intended to impersonate, mock, or antagonize another user, or otherwise falsely claiming to be another member is strictly prohibited.
  
  
• Harassment/Stalking/Privacy - Continual harassing behavior directed towards a certain individual or group with the intent of creating an intimidating, offensive, or hostile environment on the forums, with or without use of explicit or implicit threats is strictly prohibited. Posting contact or other private information of any person (forum user or not) is also prohibited.
  
  
• Moderation - Please do not attempt to be a moderator. We have appointed specific personnel, and any posts regarding inclusive portions from the above should be reported to a Moderator and or Developer. Do no try to "moderate" the forums and posts and it is not in your ability to do so in the first place.

emerge irssi
apt-get install irssi
yum install irssi
pacman -S irssi
pkg_add -r irssi