mysql_query function for quests

[Dimmi 19]

Hi guys,

I need a mysql query function for quests, only for update & select commands. Can anyone give it to me, please?

Thanks!

[nanoia 56]

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

[Dimmi 19]

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.

[berk 1]

i did sorry ^^

[ds_aim 240]

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

[berk 1]

/

/

[Eigenartig 7]

thank you

On 16.04.2015 18:00:29, nanoia said:

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

thank you

[Hik 108]

@nanoia

 

thank you very much, you're great!

Sorry for bad english.

[Marggraf 137]

Thank you very much,helped me

[emoemolizu 1]

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
 

[emoemolizu 1]

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

 

[lorcbatu 2]

dont use mysql_query

use mysql.query

[eurotruck 0]

gmake dep

[Traceur3RUN 73]

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?

[Traceur3RUN 73]

any idea how to use it?

[Jkony3 0]

Thank