Solved Teleport not work, called from mysql

[jomjonejame]

It does not teleport player, Help me plz

Database

Teleport Player ( Problem )

set {_GuildID::*} to objects in column "guild_id" from result of query "SELECT * FROM `guild_players` WHERE `username` = '%player%'"
set {_Location::*} to objects in column "location" from result of query "SELECT * FROM `guild` WHERE `id` = '%{_GuildID::*}%'"
set {_loc} to "%{_Location::*}%"

teleport the player to {_loc}
message "{@prefix} &bTeleport Player to Guild Home"

SetHome ( not problem )

set {_loc} to "%location of player%"
set {_GuildID::*} to objects in column "guild_id" from result of query "SELECT * FROM `guild_players` WHERE `username` = '%player%'"
update "UPDATE `guild` SET `location` = '%{_loc}%' WHERE `id` = '%{_GuildID::*}%'"
message "{@prefix} &bSetHome"

 

[ShaneBee]

A string isn't a location, you have to turn it into one preferably using the location function

 

[ShaneBee]

A string isn't a location, you have to turn it into one preferably using the location function

How to do it, Please Example
[doublepost=1496920712,1496719738][/doublepost]Help me please....

 

[ShaneBee]

You need to parse that data into a location back again, here are two examples:

set {_result} to result of query "SELECT `x`, `y`, `z`, `world` FROM `locations` WHERE `user`='Abwasserrohr' " and close

set {_x} to the first element out of objects in column "x" from {_result}
set {_x} to {_x} parsed as number
set {_y} to the first element out of objects in column "y" from {_result}
set {_y} to {_y} parsed as number
set {_z} to the first element out of objects in column "z" from {_result}
set {_z} to {_z} parsed as number
set {_world} to the first element out of objects in column "world" from {_result}

set {_location} to location at {_x}, {_y}, {_z} in "%{_world}%" parsed as world

teleport player to {_location}

or smaller, that could work too:

"x, y, z in world"

set {_loc} to "0, 0, 0 in myworld"
set {_location} to "%location at %{_loc}%%" parsed as world

 

[ShaneBee]

Thank you , @Abwasserrohr