Jump to content
  • 0

Quest Mysql Query


blackfyre

Question

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 : 
 
xYyx8js.png
 
Can anybody help me?
Link to comment
  • Answers 3
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

3 answers to this question

Recommended Posts

  • 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)
Link to comment
  • 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 .. "'
Link to comment
  • 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 .. "'

 

 

Just my error

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

copy and paste this and it ll work

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.