NPC spawning problems using SQL to code

[ddftrick]

I am really only having two problems with spawning NPCs that I create using SQL, as appose to WoW-V vendor creator.

1: NPC's spawn with only 1% health and do not regen up to 100%. They just stay at 1% the entire time.

2: I can't figure out what I have to do to get the mob to have the golden elite dragon display.

I have tried searching the forums for these solutions already, but I am either to incompetent to find them, or they are not listed. Most likely the former, but any help would be appreciated.

[2dgreengiant]

use ade to create your mobs, its the easiest way than manually creating them

[ddftrick]

Thanks for the info. I just did a search and see what your talking about. I'll give it a shot and if I got problems I'll just post in this thread again.

+Rep for the help

[ddftrick]

Using ADE I have been able to get my NPCs to spawn with full health, but I still can't get it to flag the mobs with the elite golden dragon even though I have selected elite while creating the npc.

If I choose boss I get the golden elite dragon along with the skull to block out the level, but I can't get mobs selected any other option (elite, elite rare, elite rare?) to get that golden elite dragon graphic. Anyone else had this problem and figured out how to fix it?

[latruwski]

Using ADE I have been able to get my NPCs to spawn with full health, but I still can't get it to flag the mobs with the elite golden dragon even though I have selected elite while creating the npc.

If I choose boss I get the golden elite dragon along with the skull to block out the level, but I can't get mobs selected any other option (elite, elite rare, elite rare?) to get that golden elite dragon graphic. Anyone else had this problem and figured out how to fix it?

hmm it should work with ADE but if it doesnt check the creature tables and do it manualy...

how? find the "rank" column and put in one of these values:
0-Normal
1-Elite
2-RareElite
3-WorldBoss
4-Rare

[Lich King]

There's a scroll down menu on ADE for elite, boss, normal, rare, etc.

[ddftrick]

hmm it should work with ADE but if it doesnt check the creature tables and do it manualy...

how? find the "rank" column and put in one of these values:
0-Normal
1-Elite
2-RareElite
3-WorldBoss
4-Rare

Tried doing it manually in SQL, but still nothing. The mob has 1 under its rank column but for some reason he is still non elite in game.

[Lich King]

Oh, that sometimes happens to me. Sometimes when I edit a creature, the edits don't show up in-game, try making a completely new creature with ADE and use the drop down menu to select it from the begining

[latruwski]

Oh, that sometimes happens to me. Sometimes when I edit a creature, the edits don't show up in-game, try making a completely new creature with ADE and use the drop down menu to select it from the begining

or just delete your cache and reload the table and see

[Lich King]

or just delete your cache and reload the table and see

Oh yeah.. the cache.. thanks, I forgot about that

[join]

sorry that i souns n00b, but how to fix that the NPC spawns? i had made a npc and everything is fine, but wen i going to add it just say invalid entry id, and what is the command to reload npcs? please help xD

[Shellie_p]

in game .reloadtable creature_names
.reloadtable creature_proto

and if its a vendor that you've added items to in the DB
.reloadtable vendors