Quick way to change starting zones with ALTER TABLE?
 

I Just to know these commands, been a wile...

I want to change the starting zone for everyrace to the same one...






Thanks!!

Anyone have a clue ? =(

If you wanted to set all races, classes, and selections to start in the same zone, it appears that you could use the following SQL command:

UPDATE start_zones SET zone_id=(Zone), x=(x), y=(y), z=(z), start_zone=(Zone), bind_x=(x), bind_y=(y), bind_z=(z);

Change (Zone), (x), (y), and (z) to the values you want to use. You don't need the parentheses.

Everyone would then start in the specified zone at the specified coordinates.

Apparently the zone and coords are in there twice so you can set a player to be bound by default to a location different from the actual starting location, so you don't get too many players popping into the same spot on log-in and death.

Ah, Thanks alot for your help :)

I recommend doing a little testing, since the meanings of the x, y, and z coordinates can be interpreted differently in different systems. They don't always match up with the order given in a /loc.

/loc gives Y,X,Z and #loc gives X,Y,Z, so it is always best to use #loc IMO. But, keep in mind that /loc always only gives your location. The #loc command will give the location of your target if you have one and if not, it gives the loc of yourself. Basically, you just need to make sure you have the correct target when using #loc so you don't get bad info.

On Rev535 I edited the database as Shendare had mentioned. This did not matter. My start zone was always the tutorial zone until I edited the World:TutorialZoneID rule in the rule_values table. With the addition of SoF it appears that the start_zone table is now obsolete. Maybe it is working in later REV's, but not in 535.

Depending on what version you are running, you are going to want to look at these two rules in the rule-values table:

World:SoFStartZoneID
World:TutorialZoneID

Yeah, I actully ran into these. Thanks for help guys.