Problem tonumber

[Minion 84]

local vnumtest = item.get_vnum()

local rowvnum = tonumber(vnumtest-53000)

local test_query = game.mysql_query("SELECT pet"..rowvnum.." from player.pet_level WHERE pid="..pc.get_player_id().." LIMIT 1")

local coins_now = tonumber(test_query.pet"..rowvnum..")

pet_info_map = {

[53001]     = { 34001, "Lv."..coins_now.." Ph" ,0},


No work... Help plz

[RoxaLyssa 364]

I think we need a wider description than "no work"...

[Sober 37]

maybe like that?

local test_query = game.mysql_query("SELECT pet"..rowvnum.." from player.pet_level WHERE pid="..pc.get_player_id().." LIMIT 1")[1][1]

remember the result of a mysql query is an array

[Minion 84]

local vnumtest = item.get_vnum()

local rowvnum = tonumber(vnumtest-53000)

local test_query = game.mysql_query("SELECT pet1 from player.pet_level WHERE pid="..pc.get_player_id().." LIMIT 1")

local coins_now = tonumber(test_query.pet1)

pet_info_map = {

[53001]     = { 34001, "Lv."..coins_now.." Ph" ,0},

 

When you install pet1 all works. As soon as I pet1 on rownum, then everything stops working

 

pet1 - work

pet"..rownum.." - no work

 

Sorry my bad English