[6.x] New orgrimmar spawns + Brawl'gar arena

[ElleEntertainment]

Deleted all orgrimmar spawns with new (sniffs from 6.1.2 retail)
Added spawns + areatrigger of brawl'gar arena
http://pastebin.com/TunVtbpp

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[Kinzcool]

Don't delete all the old ones as they are correct. Just look through your data, and try to filter the IDs higher than cata for both, gameobjects and creatures. Exception cases of moved NPCs or GOs can be looked after later if you don't know them.

[gegge]

Ok so for example 4000 is the highest id for cataclism, i should only insert ids > than 4000, is it right?

[Killyana]

The highest id is 58864 for cataclysm.

[ElleEntertainment]

and for gameobject?

[Kinzcool]

For gameobjects, MoP IDs start at 209k. As of creatures, 58864 is indeed the highest ID, but be sure to watch out for MoP creatures that would have been created prior to cata's IDs; their IDs start at ~52k.

[Killyana]

We have object ids until 211084 on 4.x DB

[ElleEntertainment]

http://pastebin.com/6QbQeF8R

now it should be correct ;)

[Aokromes]

ugly like hell sql.

[ElleEntertainment]

it is gives no error btw..

[Kinzcool]

Codesyle does matter, and also please use gist instead of pastebin for fixes.

[ElleEntertainment]

oook

[ghost]

@ElleEntertainment : in case you haven't had time to clean up that pastebin SQL, I have created a gist version for you with the top section cleaned up: https://gist.github.com/tkrokli/ec5042be578c3a272fdc

Notice also that I have added a couple of questions and suggestions towards the end of that page.

[Aokromes]

This can be merged?

[ghost]

SET @CGUID := 370837; needs to be checked first to see if that GUID is free.
Otherwise, you know just as much as me about checking if it works as intended.

[Aokromes]

It needs to be 450 000+ because it's mop+ spawns

[ghost]

Replaced the GUID value with XXXXXX and added a comment. Also removed the incorrect column names for the areatrigger_teleport query, which seems less than complete (maybe it should have been replaced with an UPDATE query instead? (Don't have the master DBs rebuilt on my computer at the moment, feel free to check the areatrigger_teleport part vs master branch.)

[Aokromes]

4810e02