Change starting location upon create/ starting bind point issues.

[rlie_0]

Hello, I got everything up and running, and Ive followed some guide sugguestions here, all that is happening now is every time i created a new toon, the bind point, starting point is NOT where I want it to go.

Currently they are appearing in South Qeynos, by the docks, which for some races is dangerous as you might know at level 1 lol.

What my goal is, is to have the starting point in TDeep, in the Fire pot room, I have the needed location, and zone ID number just unsure how to apply this fully as now every class/race shows up in 1 spot just not where i want them.

Zone ID : 96
X ; -12258.88
Y ; 4353.00
Z ; -279.66

Any suggestions on a fix it for this please? (Im using HeidiSQL 8.1.0.4545 as the database editor) Any help would be great! Thanks!

[rlie_0]

UPDATE:

I was able to mess around some, it appears i gotta enter each one manually which will suck cant just enter it once and get them all updated at once.

The issue now is, I get into TDeep, the Location is now incorrect there anything Im missing?

[HnathBST]

Originally Posted by rlie_0

UPDATE:

I was able to mess around some, it appears i gotta enter each one manually which will suck cant just enter it once and get them all updated at once.

The issue now is, I get into TDeep, the Location is now incorrect there anything Im missing?

There are a few places you can set the starting zone for ALL players (not individual race/class combos)

In your variables table you can add an entry:

INSERT INTO `peqdb`.`variables` (`varname`, `value`, `information`, `ts`) VALUES ('startzone', 'poknowledge', 'Sends new players to a specific starting zone.', '2013-10-02 07:11:01');

Change poknowledge to the shortname of the zone you want.

you can also set the clients using the SOF or greater client to a specific starting zone by using:

INSERT INTO `peqdb`.`rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES ('1', 'World:SoFStartZoneID', 'poknowledge', 'Sets the Starting Zone for SoF Clients separate from Titanium Clients (-1 is disabled)');

again changing poknowledge to the shortname of the zone you want.

when you use variable to set the start zone, it will use the safe spot coordinates from the zone table. you can change that by using:

UPDATE `peqdb`.`zone` SET  `safe_x`='-285', `safe_y`='-148', `safe_z`='-159' WHERE (`short_name`='poknowledge');

once again obvisiously changing poknowledge to your zone and the safe_x,y&z to your choosen coordinates.

Hope that helps

[rlie_0]

Thanks for the information

I can now land myself in the right location. In the Fire pot room, in Timorous Deep. Tho when i set the bind_id to 96, and set the location, it fails to BIND me in the same location...It appears Im at the succort point.

Do I have to have a different bind location vs frist create/log in location for this to take effect? Ill try something like this and see if not then im SoL and may have to removed the level requirement from Locket of espace and make it a starter item to allow new comers to bind in fire pot room as well.

[HnathBST]

I believe that the server ~should~ bind you in the start_zone if you're using that variable. IIRC it completely skips over the start_zone table. The bind zone is set when the character clicks the 'Enter World' button after customizing their character.

[rlie_0]

Yes, I figured it out late last night, I was entering to much information and finally figured out where i needed to enter the location for start zone, and BINE ID zone only needed to enter the X,Y,Z once and enabled everyone who logs in to load in at that point and also be bound at that point (them changing it upon logging in is upto them) Thanks for the time and sugguestion advice and opening up my eyes to seeing more then just looking at 1 or 2 sections. Really helpful thank you.

[HnathBST]

The emulator is developed by so many people that sometimes you have to just jump right into the code and figure out exactly how things work. It may seem a little daunting at first, but once you learn some of the lingo you'll be golden. I just used the code to update the statistics formula for mageloclone (or my hacked version of it lol).