[Help] How can i change starting zone?

[ares0027]

i worked for portals but i failed. so i am thinking to change the starting zone for newly created characters.

i want to make all characters to start in alterac valley safety zone (each faction in their own side)

how can i do that? or can you create a sql query which does that?

thanks from now on :)

[MentaL]

[giraffesyo]

Don't ask for much do you ? =P I'll work on a script... give me a little bit.

[giraffesyo]

Alright, to the best of my ability (which is pretty damn good ;) not to brag or anything) I have made it..

Anyways here you go =D (pretty nice if I do say so myself...)

Note: I have not tested this, I just wrote it and submitted... Report any bugs..

http://www.epicest.com/SQL/playercre...eracvalley.sql

[ares0027]

i hope it works :D i am testing it atm.

edit: it works like a charm BUT only for alliance side :P all horde characters starts at their own zone :D i will try to edit your file and figure out how it works,then i will try to make same thing for horde :) if i can do it i will post it here :P

[spoocke]

thats simpel if you know the map id 's wich you can also seek in the sqldatabase
playercreateinfo <-- this table contains the PLAYER CREATE INFO'S strange its called that lol.
there is a index called (map) guess what it does
it makes the newly fresh player spawn in the desginated map.
greetz and look in the sql database a bit you'll find alot of things back and use your brain to figure it out.

all peeps here post repacks en questions none ever posted a Sql layout explenation.
so if some one has one please post.