How do I stop players from spawning in Crescent Reach?

[Nydosa]

Titanium clients will spawn wherever it says in startzone in the Variables table. There are also start zone variables in rule_values.

[Lucia Moore]

I don't see anything in rule_values or variables that lets me select player start zones.

[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';

[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.
		}

	}