# Loading Server Data

This page explains how different assets on the server are loaded and by what methods can they be refreshed and/or reloaded

## AA Data
* **#reload aa** will reload Alternate Advancement data from the `aa_ability` table globally

## Alternate Currency Data
* **#reload static** will reload Alternate Currency data from the `alternate_currency` table globally
* **#reload alt_currencies** will also reload Alternate Currency data from the `alternate_currency` table globally without reloading everything else that **#reload static** does

## Base Data
* Base Data uses shared memory - you most likely aren't editing this
* Base Data is recommended to be ran from server boot-up for drastic changes, however editing existing data can be reloaded server-wide using **#hotfix**

## Blocked Spells
* **#reload blocked_spells** will reload Blocked Spells data from the `blocked_spells` table globally

## Commands
* **#reload commands** will reload Commands data from the `command_settings` table globally

## Content Flags
* **#reload content_flags** will reload Content Flags data from the `content_flags` table globally

## Doors
* **#reload static** will reload Doors data from the `doors` table globally
* **#reload doors** will also reload Doors data from the `doors` table globally without reloading everything else that **#reload static** does

## Factions
* Factions uses shared memory
* Factions can be hot reloaded in game using **#hotfix** - keep in mind that this uses shared memory files produced from **shared_memory** binary located in the **./shared** folder
* New factions need a server reboot, existing factions can use **#hotfix**, you can use placeholder data to add new factions and safely reload like other shared memory data

## Fishing and Foraging
* Fishing and Foraging data are live once entered into the database, no reloading is required

## Grids and Pathing Data
* All grid data is loaded at zone boot-up and any new data is simply reloaded during a **#repop**

## Ground Spawns
* **#reload static** will reload Ground Spawns data from the `ground_spawns` table globally
* **#reload ground_spawns** will also reload Ground Spawns data from the `ground_spawns` table globally without reloading everything else that **#reload static** does

## Horses
* Horse data is queried directly from the `horses` table on request of creating horse from Spell cast

## Items
* Items uses shared memory
* Items can be hot reloaded in game using **#hotfix** - keep in mind that this uses shared memory files produced from **shared_memory** binary located in the **./shared** folder
* Items in earlier clients such as Titanium show the change immediately, if you have inspected an item on a later client, then issued a **#hotfix**, the client caches these results so you will need to camp or zone to see the stat changes however any affects should take affect immediately
* Note: If you are going to build new items on your server on the fly, I recommend creating a big bank of blank or placeholder ID's in your table that you can use in the future. You can't hot reload the server with new items without creating issues after creating a new row entry
* Existing items can be safely edited without a server reload and using the **#hotfix** command. This takes affect for all zones immediately

## Level EXP Mods
* **#reload level_mods** will reload Level Based Experience Modifiers data from the `level_exp_mods` table globally
* Note: Must be enabled with the `Zone:LevelBasedEXPMods` rule to be used.

## Logging
* **#reload logs** will reload Log Settings data from the `logsys_categories` table globally
* **#logs reload** will also reload Log Settings data from the `logsys_categories` table globally

## Loot
* Loot uses shared memory
* Loot can be hot reloaded in game using **#hotfix** - keep in mind that this uses shared memory files produced from **shared_memory** binary located in the **./shared** folder
* Note: Loot assigned in a script/quest does not rely on the database system or to be reloaded from shared memory

## Merchants
* **#reload merchants** will reload Merchants data from the `merchantlist` table globally.
* Merchant data is loaded and cached the first time the request is made to a merchant if it wasn't already loaded on zone bootup

## NPC Data
* **#repop** will reload NPC data from the `npc_types` table for your current zone

## NPC Emotes
* **#reload npc_emotes** will reload NPC Emotes from the `npc_emotes` table globally.
* While emotes don't HAVE to be database driven (most custom servers will just use scripts) - there is an option to reload the database driven emotes

## Objects
* **#reload static** will reload Objects data from the `object` table globally
* **#reload objects** will also reload Objects data from the `object` table globally without reloading everything else that **#reload static** does

!!! info
      Note that you will likely have to zone for your client to update.

## Pets
* Pet data is live and usable the moment it is in the `pets` table and an `npc_types` entry is made.
* Otherwise a **#repop** will be require to reload the NPC data from the `npc_types` table

## Perl Event Exports
* **#reload perl_export** will reload Perl Event Export Settings data from the `perl_event_export_settings` table globally

## Quests
* **#reload quest** or **#reload quest 0** will reload all quest scripts for the zone you are in.
    - **#reload quest 1** will reload all quests for the zone you're in and stop quest timers.
* **#reload world** or **#reload world 0** will reload Quests globally.
    - **#reload world 1** will reload Quests and repop globally
    - **#reload world 2** will reload Quests and forcefully repop globally

## Reload Static Command
* **#reload static** reloads the following globally.
    - Alternate Currencies
    - Doors
    - Objects
    - Ground Spawns
    - NPC Emotes
    - Traps
    - Veteran Rewards
    - Zone Configurations
    - Zone Points

## Rules
* **#reload rules** will reload Rules data from the `rule_values` table globally

## Skill Caps
* Skill Caps uses shared memory (Class skills, caps etc.)
* Skill caps is recommended to be ran from server boot-up for drastic changes, however editing existing data can be reloaded server-wide using **#hotfix**

## Spells
* Spells uses shared memory
* Spells can be hot reloaded in game using **#hotfix** - keep in mind that this uses shared memory files produced from **shared_memory** binary located in the **./shared** folder
* Note: If you are going to build new spells on your server on the fly, I recommend creating a big bank of blank or placeholder ID's in your table that you can use in the future. You can't hot reload the server with new spells without creating issues after creating a new row entry.
* Existing spells can be safely edited without a server reload and using the **#hotfix** command. This takes affect for all zones immediately

## Tasks
* **#task reloadall** or **#reload tasks** will reload Tasks data from the `tasks` table and the `activities` table globally
* Note: If a character has a task that you are testing/building and you add new steps, the server will remove it from your task window

## Titles
* **#reload titles** will reload Titles data from `titles` table globally

## Tradeskills
* Tradeskills query the database directly and do not require reload to take affect

## Traps
* **#reload static** will reload Traps data from the `traps` table globally
* **#reload traps 1** will also reload Traps globally without reloading everything else that **#reload static** does

## Variables
* **#reload variables** will reload Variables data from the `variables` table globally

## Veteran Rewards
* **#reload static** will reload Veteran Rewards data from the `veteran_reward_templates` table globally
* **#reload veteran_rewards** will also reload Veteran Rewards data from the `veteran_reward_templates` table globally without reloading everything else that **#reload static** does

## Zone Data
* **#reload zone [Zone ID|Zone Short Name]** will reload the Zone data from the `zone` table for your current zone.
* **#zheader [Zone Short Name]** will also reload the Zone data from the `zone` table for your current zone.

## Zone Points
* **#reload static** will reload Zone Points data from the `zone_points` table globally
* **#reload zone_points** will also reload Zone Points data globally without reloading everything else that **#reload static** does