Jump to content
metin2dev
  • 0
Sign in to follow this  
Dimmi

mysql_query function for quests

Question

Hi guys,

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

Thanks!

Share this post


Link to post
Share on other sites

14 answers to this question

Recommended Posts

  • 0

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

 

http://www.mediafire.com/download/4k9ib6e21422549/questlua_mysql.cpp

 

VirusTotal

 

https://www.virustotal.com/tr/file/810c3f8a9df74dc56227e3bd11927a087b4fb1c7e78420127369625ffd1d5f3c/analysis/1418487997/

  • Like 4

Share this post


Link to post
Share on other sites
  • 0

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

 

http://www.mediafire.com/download/4k9ib6e21422549/questlua_mysql.cpp

 

VirusTotal

 

https://www.virustotal.com/tr/file/810c3f8a9df74dc56227e3bd11927a087b4fb1c7e78420127369625ffd1d5f3c/analysis/1418487997/

 

Thanks. It works. :D

I used mysql.query for update and mysql.direct_query for select.

  • Like 1

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0

thank you :o

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

 

http://www.mediafire.com/download/4k9ib6e21422549/questlua_mysql.cpp

 

VirusTotal

 

https://www.virustotal.com/tr/file/810c3f8a9df74dc56227e3bd11927a087b4fb1c7e78420127369625ffd1d5f3c/analysis/1418487997/

thank you :o

  • Like 1

Share this post


Link to post
Share on other sites
  • 0

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
 

Share this post


Link to post
Share on other sites
  • 0

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

 

Share this post


Link to post
Share on other sites
  • 0

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?

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×