Page 1 of 1

Adding start up locations coordinates to db?

PostPosted: Thu Jul 05, 2018 10:20 pm
by 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!

Re: Adding start up locations coordinates to db?

PostPosted: Sat Jul 07, 2018 3:11 pm
by ontheDOL
i can change them just fine (int range is alooot more than 255 :P )

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

Re: Adding start up locations coordinates to db?

PostPosted: Mon Jul 09, 2018 7:11 am
by 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

Re: Adding start up locations coordinates to db?

PostPosted: Mon Jul 09, 2018 7:25 am
by 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 :D

Re: Adding start up locations coordinates to db?

PostPosted: Mon Jul 09, 2018 5:20 pm
by 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 ;)