Skip to content

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