TFS 0.X how to obtain a town value from query?

[5lave Ots]

somebody asked for an offline reward talkaction that im working on
and i need to define a player.town id from the query

player = db.getResult('SELECT `name`, `town_id` FROM `players` WHERE `name` = "' .. par[1] .. '";')

how to define a local variable ' town_id' from that query?
shall i use player.town_id?

to return me that line

doPlayerSendMailByName(par[1], chest, town_id)

Post automatically merged: Jun 15, 2021

somebody asked for an offline reward talkaction that im working on
and i need to define a player.town id from the query

player = db.getResult('SELECT `name`, `town_id` FROM `players` WHERE `name` = "' .. par[1] .. '";')

how to define a local variable ' town_id' from that query?
shall i use player.town_id?

to return me that line

doPlayerSendMailByName(par[1], chest, town_id)

its solved but i cant delete the post
using player.town_id was the answer

 

[Mauya]

player.town_id could make a mysql injection
imnot sure so you better try the possible chances of that