How do I stop players from spawning in Crescent Reach?

[Kingly_Krab]

You can use this to see how your rules are set, these must be set to the zone you want people to start in.

SELECT * FROM rule_values WHERE rule_name IN ("World:SoFStartZoneID", "World:TutorialZoneID");

You can also use this query to mass update everystart_zone to the same X, Y, Z, Heading, and Zone ID, just in case they're not all set to the same thing.

UPDATE start_zones SET x = 'VALUE', y = 'VALUE', z = 'VALUE', heading = 'VALUE', zone_id = 'VALUE', start_zone = zone_id, bind_x = x, bind_y = y, bind_z = z;

[Lucia Moore]

Originally Posted by Kingly_Krab

You can use this to see how your rules are set, these must be set to the zone you want people to start in.

SELECT * FROM rule_values WHERE rule_name IN ("World:SoFStartZoneID", "World:TutorialZoneID");

You can also use this query to mass update everystart_zone to the same X, Y, Z, Heading, and Zone ID, just in case they're not all set to the same thing.

UPDATE start_zones SET x = 'VALUE', y = 'VALUE', z = 'VALUE', heading = 'VALUE', zone_id = 'VALUE', start_zone = zone_id, bind_x = x, bind_y = y, bind_z = z;

My start zones are set, the problem is the server is kicking people into Crescent Reach if I try to get them to spawn. My only assumption is that I screwed something up, but I can't for the life of me determine what it was.

[rencro]

By chance is the "tutorial" button enabled when the character is created, I assume you may have reassigned the tutorial zone to 0 and its trying to send your characters to tutorial, but when it cant find a proper zone id it craps out to its last choice which is Crescent Reach. Perhaps try disabling the tutorial button as well..

I built a new peq today, and created a human agnostic monk. If I have tutorial enabled, world will spit out:

No starts_zones entry in database, using defaults

Then I start in tutorial zone which is tutorialB

Then created new human agnostic monk and unclicked tutorial:

Found starting location in start_zones

And it puts me in qeynos2 as it should

What does your world report after creating new chars, and by chance have you changed the WorldTutorialZoneID?

[Lucia Moore]

Originally Posted by rencro

By chance is the "tutorial" button enabled when the character is created, I assume you may have reassigned the tutorial zone to 0 and its trying to send your characters to tutorial, but when it cant find a proper zone id it craps out to its last choice which is Crescent Reach. Perhaps try disabling the tutorial button as well..

I built a new peq today, and created a human agnostic monk. If I have tutorial enabled, world will spit out:

No starts_zones entry in database, using defaults

Then I start in tutorial zone which is tutorialB

Then created new human agnostic monk and unclicked tutorial:

Found starting location in start_zones

And it puts me in qeynos2 as it should

What does your world report after creating new chars, and by chance have you changed the WorldTutorialZoneID?

It looks like people are reading the replies to my post without actually reading what I typed.

People aren't spawning in the tutorial zone, they're spawning in Crescent Reach when I choose to spawn in Freeport.

This issue only happens when I try to have someone spawn in the OLD Freeport. Spawning in Qeynos works just fine for human characters, but any time I pick either West Freeport or East Freeport off of the list of starting zones, I spawn in Crescent Reach instead. The tutorial button is not clicked.

To reiterate: I changed all of the start_zone entries that were aimed at the NEW Freeport zones to the OLD Freeport zones, and I updated the XYZ coordinates to a valid location. Attempting to start in Freeport instead spawns players in Crescent Reach. There is no server error feedback indicating why this is happening, and I cannot find anything in the start_zones entries pointing to Crescent Reach either.

[rencro]

FFS read what IIIIIIIII IIII TYPE....

Im done with you

[Lucia Moore]

Originally Posted by rencro

FFS read what IIIIIIIII IIII TYPE....

Im done with you

The attitude is entirely unwelcome. If you're going to get angry, please don't bother responding to me. I can wait for someone that's not going to lose their temper to assist me. Furthermore, I did read what you typed, but it doesn't apply to my problem. I guess I can quote the part that doesn't apply, if that helps?

Originally Posted by rencro

By chance is the "tutorial" button enabled when the character is created, I assume you may have reassigned the tutorial zone to 0 and its trying to send your characters to tutorial, but when it cant find a proper zone id it craps out to its last choice which is Crescent Reach. Perhaps try disabling the tutorial button as well..

You assume incorrectly. I never modified the tutorial zone settings. I would never set a zone setting to 0, because I'm well aware that could cause a big problem. As I've said several times, the only zone settings I've changed were changing 382 and 383 to 9. That's it. I never touched any other settings regarding zone ID numbers. That's why I'm confused as to why it's defaulting to Crescent Reach.

As per the piece of code you quoted earlier:

		in_pp->x = atof(row[0]);
		in_pp->y = atof(row[1]);
		in_pp->z = atof(row[2]);
		in_pp->heading = atof(row[3]);
		in_pp->zone_id = in_cc->start_zone;
		in_pp->binds[0].zoneId = atoi(row[4]);

All of those values in my DB are valid. There's no reason the code should hiccup and default to Crescent Reach.

Originally Posted by Kingly_Krab

Are you sure the client you're using has the old zones? Would you mind using #zone to go there and see if it works, if it doesn't, that's why it's putting you in Crescent Reach, if you can go there, the problem lies elsewhere.

I can zone there as a GM with no problem, and the zone is fully populated and functional. That's how I got the spawn coordinates and heading. I went there and used the #loc command (not to be confused with /loc).

[Lucia Moore]

Update

Okay, I'm getting an error message now (or, at least, I'm looking at the correct window now) and I can see what's screwing up, but have no idea why, unless it's something hardcoded into the client or server?

[Status] SoF Start zone query: SELECT x,y,z,heading,bind_id FROM start_zones WHERE zone_id=383 AND player_class=2 AND player_deity=204 AND player_race=1

No start_zones entry in database, using defaults

So, if I changed that start zone entry in the database to 9, and I have the whole "separate SoF start zone" rule disabled, why is it still looking for a 383 entry in the database?

[Kingly_Krab]

Can you post some pictures of your rule_values and start_zones settings perhaps?

[Kingly_Krab]

Are you sure the client you're using has the old zones? Would you mind using #zone to go there and see if it works, if it doesn't, that's why it's putting you in Crescent Reach, if you can go there, the problem lies elsewhere.