lawry 2 Posted April 24, 2014 Share Posted April 24, 2014 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 Link to comment Share on other sites More sharing options...
Former Staff .InyaProduction 1123 Posted April 24, 2014 Former Staff Share Posted April 24, 2014 make --e for mysql55 Link to comment Share on other sites More sharing options...
lawry 2 Posted April 24, 2014 Author Share Posted April 24, 2014 like this ? os.execute('mysql '..pre..' --e'..string.format('%q',query)..' > '..fi) -- für MySQL55 Link to comment Share on other sites More sharing options...
Denis 1474 Posted April 24, 2014 Share Posted April 24, 2014 Yes Link to comment Share on other sites More sharing options...
Premium Shogun 4587 Posted April 24, 2014 Premium Share Posted April 24, 2014 This is posted in a totally wrong forum. Moving to questions and Answers. Link to comment Share on other sites More sharing options...
lawry 2 Posted April 24, 2014 Author Share Posted April 24, 2014 syserr again mysql: unknown variable 'eSELECT * FROM player.item where item.id = '30180484' order by item.id desc limit 1;' Link to comment Share on other sites More sharing options...
Bot Solution Metin2 Dev 4873 Posted April 24, 2014 Bot Solution Share Posted April 24, 2014 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) Link to comment Share on other sites More sharing options...
lawry 2 Posted April 24, 2014 Author Share Posted April 24, 2014 OK I will try it Thank you Link to comment Share on other sites More sharing options...
lawry 2 Posted April 24, 2014 Author Share Posted April 24, 2014 Thanks it works Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now