[Tutorial] How to make an instance not an instance.

[Lexkorbs]

How to make an instance into a normal zone

In this Tutorail i am going to make Alterac Valley into a normal zone, so everyone can see each other.

[Uses]
Could be used for a mall, custom city, or whatever

First im going to alterac valley, i'll use the .recall command for that

.rec port alteracvalley

Now i am going to find the mapID with this command

.gps

Right, so Alterac Valley got the MapID 30. Now, where going to open our mySQL editor. I'm using Navicat.
Im going into my World DB (the one which is not logon >.>), and finding the table called worldmap_info.

In there im going to look for the row with entry 30.




Now to the editting.
- Change type to 0
- Change maxplayers to 0
- Change repopx, repopy, repopz to 0
- Change flags to 1



Ok, that table is done. Now were going to delete some areatrigger.
Go to your world DB (the one that is not logon >.>) and open areatriggers.


[Optional to make next step easier]: Im going to click on any field under map. Then im going to change sorting to Ascending. Then scroll down and find the rows with map at 30.
Now WTFPWN (delete) all the rows with map 30! RAWR!



If you are unable to sort, then you just have to find all the rows, one by one and delete.


If you want all the npc's deleted, it can be done quickly with a query.

DELETE FROM creature_spawns WHERE map = '30'

Restart the server and enjoy!

[ADDED]: Now how will you get to your instance which isnt an instance anymore? .worldport <map> 0 0 0
For alterac valley that would be .worldport 30 0 0 0


Credits goes all to me, i made this all by myself since i could find no tut on this.

Prefer if i dont need to defend this tutorail from all those dudes who comes up with their "RAWRA you took "Restart the server and enjoy! " from my tutorial DAMN YOU COPYCAT!

-Thanks for NOT doing that

[TigerPigen]

bump

[Lexkorbs]

lol thanks for bump

[TigerPigen]

np nice guide m8

[Lexkorbs]

well i hoped some more respons' for all the efforts i put into this picture tutorial :\

[cillian]

Nice tut +Rep

[Lexkorbs]

Thanks Cillian +rep back, tho you got enough of it xD

[LS12]

i've seen one other of these tutorials but there is still a portal Into those Uninstanced instances! I dont know if this makes the instance without loading screen but still nice tutorial +rep!

[Lexkorbs]

Originally Posted by LS12

i've seen one other of these tutorials but there is still a portal Into those Uninstanced instances! I dont know if this makes the instance without loading screen but still nice tutorial +rep!

portals into uninstanced instances?

-Nope, only ZG and ZF got useful of such..

[nadskap2]

hmm... does the old Alterac Valley work while the other? and can i spawn the new AV everywhere?

[xmbsx905]

Amazing TUT, I needed this because Emerald dreams turned into a "raid" instance at 3.0.3

rep + for you

[Lexkorbs]

Thanks XMBSX905