I cant create NPCs and then reload NPC tables and then spawn. I need to restart.

[Wheeze201]

Alright so my problem is that usually I am able to create an NPC then reload the tables "creature_names" and "creature_proto" right ?

Well every time I put a new NPC in my DB, a restart is required in order to spawn it in-game.

It really gets in the way of my server's development process and if somebody can figure out whats wrong and recommend me a fix then he will be doing my server a great favor and +rep of course!

[Trollblod]

What kind of DB are you using? NaviCat? Damn, haven't done this kind of stuff in a while, can't remember the other bigger tool.. well, if you use NaviCat I recommend the other, hmm, not MySQL... that's the whole tool, oh whatever.
What kind of emulator do you use? I hope you use ArcEmu.

[stoneharry]

Trollblod, your thinking of SQLyog.
If after reloading the tables you can not spawn a creature still, I advise you to update to a better revision / downgrade to a better revision that actually works.

[Wheeze201]

The SQL manager has nothing to do with this.

And I am using the latest WhyDB rev and ArcEmu rev2986.

EDIT: Alright stoneharry. Do you have a ArcEmu revision you can recommend me ?

[Ground Zero]

Did you remember to type .server reload creature_Names and creature_proto... right?

[stoneharry]

I'm using 3021 and it's working perfectly (although I am getting spell syntex errors on startup, I am only using levels 1-30 though). I'm going to upgrade next time a syntex fix comes out and then probably stay at that. It's all about testing revs, and finding one that suits the server you are building for. Read the commit log!

[Ground Zero]

(although I am getting spell syntex errors on startup, I am only using levels 1-30 though).

Same. ^^ Need to update it.

[Trollblod]

Trollblod, your thinking of SQLyog.
If after reloading the tables you can not spawn a creature still, I advise you to update to a better revision / downgrade to a better revision that actually works.

And ye, I meant SQLyog ty, but ye, meant upgrade ArcEmy if you use it.

[stoneharry]

Same. ^^ Need to update it.

ALTER TABLE `spelloverride` ADD COLUMN `spellId`  int(30) NOT NULL AFTER `spellhash`;

Temporary fix.

[Vision1000]

ALTER TABLE `spelloverride` ADD COLUMN `spellId`  int(30) NOT NULL AFTER `spellhash`;

Temporary fix.

I also had this problem. (Noticed it when Peroidic Damage didn't scale with spellpower).

I'm pretty sure the problem was that arcemu updated the core, had you apply sql updates to spelloverride, and then they reverted the core back and iirc they didn't add anything to revert the spelloverride table. So if your dots don't scale with spellpower and your using Arcemu r.3021 just restore your spelloverride table with an old spelloverride sql. If you do not have one here's the one I used: pastebin - collaborative debugging tool

Sorry for the offtopic response, but dots using only base damage kinda fails, thought I'd help out.