Should all Database Changes go through on zone?
 

Hi all,

Should all Database Changes go through on zone? I'm curious the criteria for things to be allowed to change without restarting.

I know LUA requires a restart. Perl can be done with the #reloadqst, but what about the DB? I've done some changes to items that have required a restart (or at least I think it did,) while other DB changes went through without zoning, and some went through instantly (unless that was all in my head...)

Thank you!

changes to items needed some sort of server reboot - maybe there is a command now
Changes to npcs can be done with simple zonning.

I just run shared_memory.exe when I make DB changes, such as items, etc. I know some use #hotfix, which is one way to run the
shared_memory from in-game, but, I just keep a shortcut to the executable on my desktop when I get into serious editing.
There is sometimes, I end up having to zone, after running shared_memory, more commonly with merchant items, but it
seems to be a random occurence. It's not a big deal to me.
You can also use #reloadstatic, when you make changes to doors, etc. One example, is when I get rid of a port stone in PoK,
I run the #reloadstatic in game and it happens instantly. Everyone has their own way of doing things. My biggest asset is patience. :)

You guys just saved me soooo much time. Thank you!

Lua doesn't require a restart as far as I'm aware. I believe #reloadquest will work for it as well.

Changes to Tradeskills take effect instantly. If you alter an NPC in any way you just need to #repop. Perl and Lua both get reloaded with #reloadquest.

This is an item on our documentation hitlist

Our new documentation has taken residence here: https://github.com/EQEmu/Server/wiki

A page that details how all in game assets are reloaded is a repeated question that would be useful to have a breakdown for

I'll look at doing this before I go to bed here

I'm working on the page currently, but you can find our new official guide on this subject here:

https://github.com/EQEmu/Server/wiki/Hot-Reload-Methods

If I don't cover any methods folks would like to see in this page, feel free to drop a comment and I will add it.

It should be quite thorough at this point

Is this going on the main wiki ? Just noticed this is on the "github" wiki

Github will be our new "main wiki" for indefinite time until I can finish the overhaul of my Wiki engine.

Moving and a job change is not going to allow that short term so we are not going to hold back on much needed knowledge content to be poured into a medium

So there you have it

The other site will be phased out here

Oh ok, makes sense. A page like that is great for new people learning, but the link to it (at the moment) might get buried here, lol
I will keep the link handy to share on future threads when needed.

It won't be buried as it is on the sidebar of the new Wiki, and if people ask again - people can refer to the link instead of repeatedly answering the same question in detail over and over again

https://github.com/EQEmu/Server/wiki...r-Data-Loading