Need help updating some monsters SQL

[mufaka]

Im trying to revamp Shadowfang keep by changing the current monsters level, hp dmg etc to new ones. No problem. I went into creature_proto and updated as necessary.

The problems Im having is with the displays. I wanted to change the models for some entries to different ones. Example model ID 3851 (shadowfang whitescalp) to 20045 (Wrathguard). I changed the display ID in creature names and that did not work. SO I proceeded to go into creature_spawns and change the model ID manually, saving my work after each model is updated per spawn. I probally updated 50 mobs (10 spawns per mob). I delete my cache folder, load up my server and no change.

When I do back to my DB and look the display ID in the creature_spawns index are back to the old values. What am I doing wrong.

Also is it possible to do an UPDATE query where it looks for monsters with a certain ENTRY ID to change their DISPLAY ID. I tried this but Im about 3 days into sql so I know my syntax is horrible

update displayid in creature_spawns when entry = "3851" to "20045";

That didnt work but thats generally what I want.

[MentaL]

[mufaka]

I seem to be able to update monsters outside dungeons fine. Maybe instances have an extra area I need to set the new display ID?