Dimmi 19 Posted April 16, 2015 Share Posted April 16, 2015 Hi guys, I need a mysql query function for quests, only for update & select commands. Can anyone give it to me, please? Thanks! Link to comment Share on other sites More sharing options...
Solution nanoia 56 Posted April 16, 2015 Solution Share Posted April 16, 2015 Here has the following functions in C ++ mysql.querymysql.direct_querymysql.updatemysql.real_escape_stringmysql.get_table_postfix go to game / src open queslua.cpp under RegisterDragonSoulFunctionTable(); add RegisterMysqlFunctionTable(); open queslua.h under extern void RegisterDragonSoulFunctionTable(); add extern void RegisterMysqlFunctionTable(); add in the makefile questlua_mysql.cpp Download the file This is the hidden content, please Sign In or Sign Up VirusTotal This is the hidden content, please Sign In or Sign Up 23 1 1 5 20 Link to comment Share on other sites More sharing options...
Dimmi 19 Posted April 16, 2015 Author Share Posted April 16, 2015 Here has the following functions in C ++ mysql.query mysql.direct_query mysql.update mysql.real_escape_string mysql.get_table_postfix go to game / src open queslua.cpp under RegisterDragonSoulFunctionTable(); add RegisterMysqlFunctionTable(); open queslua.h under extern void RegisterDragonSoulFunctionTable(); add extern void RegisterMysqlFunctionTable(); add in the makefile questlua_mysql.cpp Download the file This is the hidden content, please Sign In or Sign Up VirusTotal This is the hidden content, please Sign In or Sign Up Thanks. It works. I used mysql.query for update and mysql.direct_query for select. 6 1 3 Link to comment Share on other sites More sharing options...
berk 1 Posted December 14, 2015 Share Posted December 14, 2015 i did sorry ^^ Link to comment Share on other sites More sharing options...
ds_aim 241 Posted December 15, 2015 Share Posted December 15, 2015 12 minutes ago, berk said: when i do this Calls undeclared function! : mysql.query Abort (core dumped) Dude, u don't know to slove this fuking easy problem ? Add function in quest_functions Link to comment Share on other sites More sharing options...
berk 1 Posted December 15, 2015 Share Posted December 15, 2015 / / Link to comment Share on other sites More sharing options...
Eigenartig 7 Posted December 15, 2015 Share Posted December 15, 2015 thank you On 16.04.2015 18:00:29, nanoia said: Here has the following functions in C ++ mysql.querymysql.direct_querymysql.updatemysql.real_escape_stringmysql.get_table_postfix go to game / src open queslua.cpp under RegisterDragonSoulFunctionTable(); add RegisterMysqlFunctionTable(); open queslua.h under extern void RegisterDragonSoulFunctionTable(); add extern void RegisterMysqlFunctionTable(); add in the makefile questlua_mysql.cpp Download the file This is the hidden content, please Sign In or Sign Up VirusTotal This is the hidden content, please Sign In or Sign Up thank you 1 1 Link to comment Share on other sites More sharing options...
Hik 108 Posted January 5, 2016 Share Posted January 5, 2016 @nanoia thank you very much, you're great! Sorry for bad english. Link to comment Share on other sites More sharing options...
Marggraf 139 Posted March 2, 2016 Share Posted March 2, 2016 Thank you very much,helped me Link to comment Share on other sites More sharing options...
emoemolizu 1 Posted October 9, 2016 Share Posted October 9, 2016 OBJDIR/questlua_mysql.o: In function `quest::_mysql_query(lua_State*)': /xDestroy/Srcs/Server/game/src/questlua_mysql.cpp:28: multiple definition of `quest::_mysql_query(lua_State*)' OBJDIR/questlua_global.o:/xDestroy/Srcs/Server/game/src/questlua_global.cpp:1344: first defined here OBJDIR/questlua_mysql.o: In function `quest::_mysql_real_escape_string(lua_State*)': /xDestroy/Srcs/Server/game/src/questlua_mysql.cpp:83: multiple definition of `quest::_mysql_real_escape_string(lua_State*)' OBJDIR/questlua_global.o:/xDestroy/Srcs/Server/game/src/questlua_global.cpp:1397: first defined here OBJDIR/questlua_mysql.o: In function `quest::_mysql_update_query(lua_State*)': /xDestroy/Srcs/Server/game/src/questlua_mysql.cpp:14: multiple definition of `quest::_mysql_update_query(lua_State*)' OBJDIR/questlua_global.o:/xDestroy/Srcs/Server/game/src/questlua_global.cpp:1332: first defined here Link to comment Share on other sites More sharing options...
emoemolizu 1 Posted October 9, 2016 Share Posted October 9, 2016 RunState: LUA_ERROR: [string "mds"]:1: attempt to index field `?' (a nil value) SYSERR: Oct 9 13:31:59 :: WriteRunningStateToSyserr: LUA_ERROR: quest mds.start letter please help Link to comment Share on other sites More sharing options...
lorcbatu 2 Posted October 26, 2017 Share Posted October 26, 2017 dont use mysql_query use mysql.query Link to comment Share on other sites More sharing options...
eurotruck 0 Posted February 19, 2018 Share Posted February 19, 2018 gmake dep Link to comment Share on other sites More sharing options...
Traceur3RUN 75 Posted May 17, 2018 Share Posted May 17, 2018 how to create now function to get? function pc.get_test() local test = mysql.direct_query("select test from account.account where id = 1") return test end doesn't work someone can help? Link to comment Share on other sites More sharing options...
Traceur3RUN 75 Posted May 19, 2018 Share Posted May 19, 2018 any idea how to use it? Link to comment Share on other sites More sharing options...
Jkony3 0 Posted August 28, 2023 Share Posted August 28, 2023 Thank 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