Quest Mysql Query

[blackfyre 0]

Hello I'm using vanilla core 2.4 

 

When I'm trying select a string I'm getting that error

 

SYSERR: Jun  2 03:58:50 :: WriteRunningStateToSyserr: LUA_ERROR: quest randomharf.start click
SYSERR: Jun  2 03:59:02 :: RunState: LUA_ERROR: [string "randomharf"]:36: attempt to concatenate local `bul' (a table value) WITH ERRORCODE 1
SYSERR: Jun  2 03:59:02 :: RunState: LUA_STATE: index 0 ref 3

Query : 

				local flag = game.get_event_flag("kelimesira")
				local bul = game.mysql_query('SELECT kelime FROM player.kelime WHERE sira = "'..flag..'"')
				say (" "..bul.." ")

Table : 

 

 

Can anybody help me?

Edited August 15, 2022 by Metin2 Dev
Core X - External 2 Internal

[luzzo 193]

I don't know how vanilla manages mysql query but i think that you have to use something like this

local flag = game.get_event_flag("kelimesira")
local bul = game.mysql_query("SELECT kelime FROM player.kelime WHERE sira ='"..flag.."'")
say (bul)

[blackfyre 0]

 

I don't know how vanilla manages mysql query but i think that you have to use something like this

local flag = game.get_event_flag("kelimesira")
local bul = game.mysql_query('SELECT kelime FROM player.kelime WHERE sira ='"..flag.."'")
say (bul)

 

Thank you for answer but it didn't work.

game.mysql_query('SELECT kelime FROM player.kelime WHERE sira = "'..flag..'"')

randomkelime.lua:83:syntax error : [string "start"]:35: `)' expected near `" .. flag .. "'

[luzzo 193]

 

 

I don't know how vanilla manages mysql query but i think that you have to use something like this

local flag = game.get_event_flag("kelimesira")
local bul = game.mysql_query('SELECT kelime FROM player.kelime WHERE sira ='"..flag.."'")
say (bul)

 

Thank you for answer but it didn't work.

game.mysql_query('SELECT kelime FROM player.kelime WHERE sira = "'..flag..'"')

randomkelime.lua:83:syntax error : [string "start"]:35: `)' expected near `" .. flag .. "'

 

 

Just my error

local bul = game.mysql_query("SELECT kelime FROM player.kelime WHERE sira ='"..flag.."'")

copy and paste this and it ll work