How do I stop players from spawning in Crescent Reach?

[Lucia Moore]

Originally Posted by rencro

Its a custom rule..

To enable it you need to insert it into your db..

If you set SOFstartzone to -1 and remove the tutorial option then whatever you set in the "variables" table for startzone will send "everybody" there, to the zones safe coords..

ie...

INSERT INTO `variables` (`varname`,`value`,`information`) VALUES 
    ('startzone','tutoriala','Setting default Startzone for all clients and races to TutorialA');

UPDATE `rule_values` SET `rule_value`='false' WHERE `rule_name` = 'World:EnableTutorialButton';

This assumes that the result of this query is -1

SELECT * from `rule_values` WHERE `rule_name` = 'World:SoFStartZoneID';

That's fine and all, but I'm not having trouble with players starting in the Mines of Gloomingdeep. I took care of that already. I'm having problems with players being able to start in Crescent Reach, an entirely different zone.

Also, I'm getting an issue where new players that pick "East Freeport" or "West Freeport" on the character creation menu start in Crescent Reach.

[rencro]

errr. you can put whatever zone name you want there, and my example is tutorial A not B, because thats where I send players too, remember tutoriala, the small jail cell where you first meet Arias and have to kill the kobold.......Again if you want Crescent Reach, put Crescent Reach...Put whatever you want, sorry if I wasnt clear...

[rencro]

Another example:

INSERT INTO `variables` (`varname`,`value`,`information`) VALUES 
    ('startzone','farsideofmoon','Setting default Startzone for all clients and races to the Far Side of the Moon zone');

[Lucia Moore]

Originally Posted by rencro

errr. you can put whatever zone name you want there, and my example is tutorial A not B, because thats where I send players too, remember tutoriala, the small jail cell where you first meet Arias and have to kill the kobold.......Again if you want Crescent Reach, put Crescent Reach...Put whatever you want, sorry if I wasnt clear...

*SIGH*

Maybe I'm the one that's not being clear...

I do not want players to spawn in Crescent Reach. At all. Ever.

I went through and replaced all of the starting zone entries that pointed to the new Freeport to Zone ID 9, which is freportw, the old classic Freeport.

When I create a new human warrior, even if I pick East Freeport, the new character starts in Crescent Reach. I do not know why they are starting there or how to make them start where I told them to start.

[rencro]

Apologies...Have you shut down and restarted the server after making your db changes?

If so, perhaps there is an issue in your tables as the server will default you to Crescent Reach if it cant find good info in the db:

{
		LogFile->write(EQEMuLog::Status, "Found starting location in start_zones");
		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]);
	}
	else
	{
		printf("No start_zones entry in database, using defaults\n");

		if(in_cc->start_zone == RuleI(World, TutorialZoneID))
			in_pp->zone_id = in_cc->start_zone;
		else {
			in_pp->x = in_pp->binds[0].x = -51;
			in_pp->y = in_pp->binds[0].y = -20;
			in_pp->z = in_pp->binds[0].z = 0.79;
			in_pp->zone_id = in_pp->binds[0].zoneId = 394; // Crescent Reach.
		}

	}

[Lucia Moore]

That's the thing, I don't THINK there's an error. I changed the start_zone and zoneid fields from 382 (or 383) to 9 and got the xyz coordinates from in-game. There's no reason I can think of why players shouldn't be able to spawn there.