Start_zones don't work...

[Nerdgasm]

[04.23. - 22:34:14] SoF Start zone query: SELECT x,y,z,heading,bind_id FROM start_zones WHERE zone_id=189 AND player_class=12 AND player_deity=396 AND player_race=6

Not sure what's going on.

[NatedogEZ]

Do you have a Hub zone for start zone? You need to set this rule in the Rule_values table

|| 1 || World:SoFStartZoneID || 348 || Sets the Starting Zone for SoF Clients separate from Titanium Clients (-1 is disabled) ||

[Nerdgasm]

It's set, it's like the Start_Zones aren't being pulled.

[NatedogEZ]

Do you have a Variable in the variable table for "Startzone" -- that one doesnt work for me if you have it in your database...

It would always send my characters to qeynos2

[Nerdgasm]

Huh that's odd... Linked is what I see.


I feel I'm missing a bit

[NatedogEZ]

What do you have ... World:SoFStartZoneID set to?

[Nerdgasm]

185 like it needs to be.

1470	605	-180.9	96	185	0	0	2	203	3	185	1470	605	-180.9	50

[NatedogEZ]

UPDATE `rule_values` SET `rule_value`='185' WHERE `ruleset_id`=1 AND `rule_name`='World:SoFStartZoneID';


If you want all players to start in that zone.

[Nerdgasm]

Huh... well. I looked and I had the tutorial zone as 189, so that' solves that problem, now they'll get sent to this zone - HOWEVER, they will not be where I want them to be (Currently I have a hub porter there now to port them down here) but... yeah

[lerxst2112]

What happens if you issue the failed query manually?

SELECT x,y,z,heading,bind_id FROM start_zones WHERE zone_id=189 AND player_class=12 AND player_deity=396 AND player_race=6

[Nerdgasm]

Rows matches: 1 - just like I said. =P It's already set, it's like teh start zones aren't being connected to the char DB... Is that possible?

[Nerdgasm]

Originally Posted by lerxst2112

What happens if you issue the failed query manually?

SELECT x,y,z,heading,bind_id FROM start_zones WHERE zone_id=189 AND player_class=12 AND player_deity=396 AND player_race=6

I looked over this and it says 189, where It's actually 185... Checked multiple times, DB still thinks it's 189 too in according to my logs...

[Nerdgasm]

[04.23. - 23:45:41] Unquoted string "bazaar" may clash with future reserved word at quests/load2/Translocator_Berendor.pl line 21.
[04.23. - 23:45:41] Unquoted string "roost" may clash with future reserved word at quests/load2/Chapter_One.pl line 24.
[04.23. - 23:45:53] Unable to read perl file 'quests/load2/player_v0.pl'

Doing this thing again. I know there's nothing wrong with either of those... time to go in and play around - Armada will be up tomorrow.

[NatedogEZ]

Those are fine.. can usually ignore those.

But if you want startzone to be Tutorialb need 189 not 185 heh...

185 == Load2

[Nerdgasm]

Yes, I know. ^.^ We are using Load2 as the 'hub' zone, but the problem is, it's not sending you to the right Coordinated it use to, then I was trying to clear the Character_ table and accidently deleted it. I restored it by source drop.player.sql then source load.player.sql it came back, the start zone is as shown in the table, but it doesn't actually send the client to the coordinates posted.