[How to fix] About mysql_query（）

[lawry 2]

I use Vanilla Core 2.3 game & DB and Mysql 5.5

when i set --os.execute('mysql '..pre..' --e='..string.format('%q',query)..' > '..fi) -- für MySQL51 , I run the quest .syserr note: RunState: LUA_ERROR: locale/newcibn/quest/questlib.lua:1862: attempt to call global `split' (a nil value)

when i set -- os.execute('mysql '..pre..' -e'..string.format('%q',query)..' > '..fi) -- für MySQL55 I run the quest .syserr note :mysql: ambiguous option '--e=SELECT * FROM player.item where item.id = '400000675' order by item.id desc limit 1;' (enable_cleartext_plugin, execute)

Please help me

[.InyaProduction 1112]

make --e for mysql55

[lawry 2]

like this ?

os.execute('mysql '..pre..' --e'..string.format('%q',query)..' > '..fi) -- für MySQL55

[Denis 1473]

Yes

[Shogun 4562]

This is posted in a totally wrong forum. Moving to questions and Answers.

[lawry 2]

syserr again

 

mysql: unknown variable 'eSELECT * FROM player.item where item.id = '30180484' order by item.id desc limit 1;'

[Metin2 Dev 4828]

Delete this questlib mysql function and use the ones provided by vanilla:

game.mysql_real_escape_string(query) (Not needed for your stuff)
game.mysql_query(query)(Returns a result use this for SELECT)
game.mysql_update_query(query)(Returns no result use this for UPDATE | INSERT etc)

 

[lawry 2]

OK  I will try it

 

Thank you

[lawry 2]

Thanks

 

it works