Log in

View Full Version : Start_zones don't work...


Nerdgasm
04-24-2013, 01:51 AM
[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
04-24-2013, 02:03 AM
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
04-24-2013, 02:17 AM
It's set, it's like the Start_Zones aren't being pulled.

NatedogEZ
04-24-2013, 02:31 AM
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
04-24-2013, 02:37 AM
Huh that's odd... Linked is what I see.

http://i259.photobucket.com/albums/hh317/sinclipse/missing_zpse1275290.jpg (http://s259.photobucket.com/user/sinclipse/media/missing_zpse1275290.jpg.html)
I feel I'm missing a bit

NatedogEZ
04-24-2013, 02:41 AM
What do you have ... World:SoFStartZoneID set to?

Nerdgasm
04-24-2013, 02:42 AM
185 like it needs to be.

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

NatedogEZ
04-24-2013, 02:43 AM
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
04-24-2013, 02:46 AM
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
04-24-2013, 02:47 AM
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
04-24-2013, 02:48 AM
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
04-24-2013, 02:54 AM
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-24-2013, 02:57 AM
[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
04-24-2013, 03:01 AM
Those are fine.. can usually ignore those.

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

185 == Load2

Nerdgasm
04-24-2013, 09:14 AM
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.