Adding start up locations coordinates to db?

[lordhamburger]

Hi there I am trying to change my start up location for when you create a character. I disabled the tutorial start up, now I am trying to set the X/Y/ZPos in the database under startuplocation. By default it is an int, what should I set this too if I wanna add some coordinates to thidranki for example. So X = 550046, Y = 556038, Z = 4336, Heading = 555, Region 238. This is from using /gloc in game and finding a spot I wanted to test this for.

So when I try to do change the x/y/z pos I get the error SQL Error (1439): Display width out of range for 'XPos' (max = 255)
Can anyone point me in the right direction on what to use instead of an int? Thanks!

[ontheDOL]

i can change them just fine (int range is alooot more than 255 )

what editor are you using for your db? and what DB

[lordhamburger]

Thank you for the reply! I am using Maria DB and Heidi sql. Here is a screenshot, I am sure I am just goofing it up somehow.
https://imgur.com/a/Oxw32qu

[lordhamburger]

I was able to hard code in the start point values to the script StartupLocation.cs, I guess maybe the script was overwriting the db values somehow I am not really sure. Starts in Thidranki now tho so that's good at least

[ontheDOL]

ok your problem here is, you are trying to edit the wrong thing! Those are the constraints on the actual columns. You need to click on the 'data' tab up above , where you can then change all the startup location data ( this is also true for any table in the database)

so, set all of those back to 11 ( their default value), then click on the 'data' tab above that, and it will alllllll make sense