[Help] How do I demorph ALL? +Rep if you can help

[MisterEMU]

I accidentally morphed everyone into a female orc... lol how can I reverse this process. Logging out and restarting server doesn't work...

[xshadowfirex]

Perhaps restart your server? XP.
There's not much else for it, there is no .demorph all command, so the only way I know of is a quick restart o.o.

[Mango Jerry]

Actually restart your server, nothing else to do.
Just complain why you restarted

[arigity]

how did you do it in the first place? i don't recall a .morph all command...

[MisterEMU]

I think it was a glitch that made all into orcs...

I tried restarting server still orcs... all 300 orcs...

I used all these commands as buff but they got turned into orcs
.cast 9910
.cast 26990
.cast 33450
.cast 27126
.cast 27126
.cast 27141
.cast 27143
.cast 25898
.cast 27260
.cast 27239

[Toxik the Spammer]

delete your WTF folder

it's possible that it just LOOKS like they turned into orcs, but they are fine and its some model glitch. if that doesn't work, try to run the repair tool

[arigity]

try doing .removeauras on someone who is an orc

[Ickybad]

Try having people remove the cast... Like it will be an icon in the top right hand corner if its a casted spell.

[MisterEMU]

doesn't work it's not a buff or anything ...

[jontehack]

try to morph em to something else with a spell. like the one that turns them into a undead and they get a buff icon then they simply only need to click away buff to get back to original form, most often works for me else give em noggenfogger elixir:P

[MisterEMU]

no buff icons nothing.

[latruwski]

did you clear your cache? players may still "look" like orcs... while they are not... clear cache and tell if it worked...

[1ns0mnia]

check the display ID's in the database (table "characters") if there all the same then oh dear :P if not then it must be a cache or something you have missed

[Dythzer]

Characters don't get saved in the cache folder.

I know how to fix it, I just need to download an ascent database to see the table structure and then I'll give you a SQL query for that.

EDIT:
Alright, I found a database and I must say that the ascent table structure looks really weird comparing to mangos so you have to do it this way:

UPDATE characters SET auras = '0';

Use it in the characters database
Shutdown the server before you use this.

If you are using MaNGOS you can do it in a better way so players wont lose ALL their buffs:

DELETE FROM character_aura WHERE spell = 33450;

Cheers

[MisterEMU]

did you clear your cache? players may still "look" like orcs... while they are not... clear cache and tell if it worked...

nope cache does NOT work. Also it has nothing to do with auras?