ZumbaCafew

November 9, 2020

Hello,

now I'm encountering a problem while creating a character. I go back to the empire selection and as a mistake I have this:

SYSERR: Nov  9 19:42:33 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'iq`, `job`, `voice`, `dir`, `x`, `y`, `z`, `hp`, `mp`, `random_hp`, `random_sp`,' at line 1
query: INSERT INTO player (`id`, `account_id`, `name`, `level`, `st`, `ht`, `dx, `iq`, `job`, `voice`, `dir`, `x`, `y`, `z`, `hp`, `mp`, `random_hp`, `random_sp`, `stat_point`, `stamina`, `part_base`, `part_main`, `part_hair`, `part_acce`, `gold`, `cheque`, `gem`, `pin`, `playtime`, `skill_level`, `quickslot`) VALUES (0, 1, 'Pumba', 1, 6, 4, 3, 3, 0, 0, 0, 963541, 278088, 0, 760, 260, 0, 0, 0, 800, 1, 1, 0, 0, 0, 0, 0, '1234', 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Nov  9 19:42:33 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1=0 WHERE `id`=1' at line 1
query: UPDATE player_index SET `pid`1=0 WHERE `id`=1

Thank you

November 8, 2020

All right, thank you
I will try

November 8, 2020

Thanks for sharing, where should I put this folder? Thank you

November 8, 2020

All right, fine. Thank you very much for your help

November 8, 2020

I solved the problem thanks to the lib in the mysql 7.x-5.1.35 folder, so I manage to compile, but how can I get the lib for mysql8?

Thanks

November 8, 2020

I have this vdi: FreeBSD 11.3 x64.vdi

In the mysql 7.x-5.1.35 folder I have the lib "libmysqlclient.a / libmysqlclient_r.a" but I want to switch to mysql_8_0_20. Where can I find the lib for this version? Thanks

November 8, 2020

Hello,

I have a machine under FreeBSD in x64

I don't have the lib-lmysqlclient

Thank you

November 8, 2020

Hello, up please

Thank you

November 3, 2020

Hello, would it be possible to have some help please? Thank you

Makefile db:

CC = clang++90

INCDIR =
LIBDIR =
BINDIR = ..
OBJDIR = .obj

PLATFORM = $(shell file /bin/ls | cut -d' ' -f3 | cut -d'-' -f1)
GCC_VERSION = $(shell $(CC) --version 2>&1 | grep "(GCC)" | cut -d' ' -f3 | cut -d'.' -f1)
BSD_VERSION = $(shell uname -v 2>&1 | cut -d' ' -f2 | cut -d'.' -f1)
VERSION = $(shell cat ../REVISION)
REVISION = $(shell echo $$(($(VERSION)+1)))

$(shell if [ ! -d $(OBJDIR) ]; then mkdir $(OBJDIR); fi)

CFLAGS = -m32 -w -g -Wall -O2 -pipe -fno-rtti -fno-exceptions -Wno-long-long -pthread -D_THREAD_SAFE

# MySQL
# INCDIR += -I/usr/local/include/mysql
# LIBDIR += -L/usr/local/lib/mysql

ifeq ($(BSD_VERSION), 7)
INCDIR += -I../../libmysql/7.x-5.1.35
LIBDIR += -L../../libmysql/7.x-5.1.35
else
INCDIR += -I../../libmysql/mysql_8_0_20
LIBDIR += -L../../libmysql/mysql_8_0_20
endif

# Project Libraries
INCDIR += -I../../../Extern/include
LIBDIR += -I../../../Extern/lib

INCDIR += -I/usr/local/include
LIBDIR += -I/usr/local/lib

LIBDIR += -L../../libthecore/lib -L../../libsql -L../../libpoly -L../../libgame/lib

LIBS = -lthecore -lmysqlclient -lsql -lpoly -lgame -lm -lz

TARGET = $(BINDIR)/db_r$(REVISION)_$(PLATFORM)

SRCS = Config.cpp NetBase.cpp Peer.cpp PeerBase.cpp Main.cpp Lock.cpp DBManager.cpp \
	Cache.cpp LoginData.cpp ClientManager.cpp ClientManagerPlayer.cpp ClientManagerLogin.cpp \
	ClientManagerBoot.cpp ClientManagerParty.cpp ClientManagerGuild.cpp GuildManager.cpp HB.cpp \
	PrivManager.cpp MoneyLog.cpp ItemAwardManager.cpp ClientManagerEventFlag.cpp Marriage.cpp \
	Monarch.cpp BlockCountry.cpp ItemIDRangeManager.cpp ClientManagerHorseName.cpp version.cpp \
	ProtoReader.cpp CsvReader.cpp

OBJS = $(SRCS:%.cpp=$(OBJDIR)/%.o)

default: $(TARGET)

$(TARGET): $(OBJS)
	@echo linking $(TARGET)....
	@$(CC) $(FLAGS) $(LIBDIR) $(OBJS) $(LIBS) -o $(TARGET)
	@expr $(REVISION) > ../REVISION

$(OBJDIR)/%.o: %.cpp
	@echo compiling $<
	@$(CC) $(CFLAGS) $(INCDIR) -c $< -o $@

$(OBJDIR)/version.o: version.cpp
	@$(CC) $(CFLAGS) -D__VERSION__=\"$(REVISION)\" -c $< -o $@
	@echo compiling $<

$(OBJDIR):
	@mkdir $(OBJDIR)

clean:
	@rm -f $(OBJS) $(BINDIR)/db_r*

dep:
	@touch Depend
	makedepend -f Depend $(INCDIR) -I/usr/include/c++/3.3 -I/usr/include/c++/4.2 -p$(OBJDIR)/ $(SRCS) 2> /dev/null

sinclude Depend

Makefile game:

MAKE = gmake
CC = clang++90

INCDIR =
LIBDIR =
BINDIR = ..
OBJDIR = .obj

PLATFORM = $(shell file /bin/ls | cut -d' ' -f3 | cut -d'-' -f1)
GCC_VERSION = $(shell $(CC) --version 2>&1 | grep "(GCC)" | cut -d' ' -f3 | cut -d'.' -f1)
BSD_VERSION = $(shell uname -v 2>&1 | cut -d' ' -f2 | cut -d'.' -f1)
VERSION = $(shell cat ../REVISION)
REVISION = $(shell echo $$(($(VERSION)+1)))

$(shell if [ ! -d $(OBJDIR) ]; then mkdir $(OBJDIR); fi)

# Standard Setting
LIBS = -pthread -lm -lmd
CFLAGS = -m32 -g -Wall -w -O2 -pipe -fexceptions -D_THREAD_SAFE -DNDEBUG

# Removed -fno-rtti
CFLAGS += -fstack-protector-all -fno-strict-aliasing

# DevIL
INCDIR += -I../../libdevil
LIBDIR += -L../../libdevil
LIBS += -lIL -lpng -ltiff -lmng -llcms -ljpeg

# MySQL
# INCDIR += -I/usr/local/include/mysql
# LIBDIR += -L/usr/local/lib/mysql

ifeq ($(BSD_VERSION), 7)
INCDIR += -I../../libmysql/7.x-5.1.35
LIBDIR += -L../../libmysql/7.x-5.1.35
else
INCDIR += -I../../libmysql/mysql_8_0_20
LIBDIR += -L../../libmysql/mysql_8_0_20
endif

LIBS += -lmysqlclient -lz

# Miscellaneous external libraries
INCDIR += -I../../../Extern/include
LIBDIR += -L../../../Extern/lib
LIBS += -lcryptopp
# LIBS += -lgtest

INCDIR += -I/usr/local/include
LIBDIR += -L/usr/local/lib

# OpenSSL
# INCDIR += -I/usr/include
# LIBS += -lssl
# LIBS += /usr/lib/libssl.a

# Project Library
INCDIR += -I../../liblua/include
INCDIR += -I../../libserverkey
LIBDIR += -L../../libthecore/lib -L../../libpoly -L../../libsql -L../../libgame/lib -L../../liblua/lib -L../../libserverkey

LIBS += -lthecore -lpoly -llua -llualib -lsql -lgame -lserverkey

TARGET = $(BINDIR)/game_r$(REVISION)_$(PLATFORM)

CFILE = minilzo.c

CPPFILE = BattleArena.cpp FSM.cpp MarkConvert.cpp MarkImage.cpp MarkManager.cpp OXEvent.cpp TrafficProfiler.cpp ani.cpp\
	arena.cpp banword.cpp battle.cpp blend_item.cpp block_country.cpp buffer_manager.cpp building.cpp castle.cpp\
	char.cpp char_affect.cpp char_battle.cpp char_change_empire.cpp char_horse.cpp char_item.cpp char_cards.cpp char_manager.cpp\
	char_quickslot.cpp char_resist.cpp char_skill.cpp char_state.cpp char_gem.cpp PetSystem.cpp cmd.cpp cmd_emotion.cpp cmd_general.cpp\
	cmd_gm.cpp cmd_oxevent.cpp config.cpp constants.cpp crc32.cpp cube.cpp db.cpp desc.cpp\
	desc_client.cpp desc_manager.cpp desc_p2p.cpp dev_log.cpp dungeon.cpp empire_text_convert.cpp entity.cpp\
	entity_view.cpp event.cpp event_queue.cpp exchange.cpp file_loader.cpp fishing.cpp gm.cpp guild.cpp\
	guild_manager.cpp guild_war.cpp horse_rider.cpp horsename_manager.cpp input.cpp input_auth.cpp input_db.cpp\
	input_login.cpp input_main.cpp input_p2p.cpp input_teen.cpp ip_ban.cpp\
	item.cpp item_addon.cpp item_attribute.cpp item_manager.cpp item_manager_idrange.cpp locale.cpp\
	locale_service.cpp log.cpp login_data.cpp lzo_manager.cpp marriage.cpp matrix_card.cpp\
	messenger_manager.cpp mining.cpp mob_manager.cpp monarch.cpp motion.cpp over9refine.cpp p2p.cpp packet_info.cpp\
	party.cpp passpod.cpp pcbang.cpp polymorph.cpp priv_manager.cpp pvp.cpp\
	questevent.cpp questlua.cpp questlua_affect.cpp questlua_arena.cpp questlua_ba.cpp questlua_building.cpp\
	questlua_danceevent.cpp questlua_dungeon.cpp questlua_forked.cpp questlua_game.cpp questlua_global.cpp\
	questlua_guild.cpp questlua_horse.cpp questlua_pet.cpp questlua_item.cpp questlua_marriage.cpp questlua_mgmt.cpp\
	questlua_monarch.cpp questlua_npc.cpp questlua_oxevent.cpp questlua_party.cpp questlua_pc.cpp\
	questlua_quest.cpp questlua_target.cpp questmanager.cpp questnpc.cpp questpc.cpp\
	refine.cpp regen.cpp safebox.cpp sectree.cpp sectree_manager.cpp sequence.cpp shop.cpp\
	skill.cpp start_position.cpp target.cpp trigger.cpp utils.cpp vector.cpp war_map.cpp\
	wedding.cpp xmas_event.cpp version.cpp panama.cpp threeway_war.cpp map_location.cpp auth_brazil.cpp\
	BlueDragon.cpp BlueDragon_Binder.cpp DragonLair.cpp questlua_dragonlair.cpp\
	skill_power.cpp affect.cpp SpeedServer.cpp questlua_speedserver.cpp\
	auction_manager.cpp FileMonitor_FreeBSD.cpp ClientPackageCryptInfo.cpp cipher.cpp\
	buff_on_attributes.cpp dragon_soul_table.cpp DragonSoul.cpp\
	group_text_parse_tree.cpp char_dragonsoul.cpp questlua_dragonsoul.cpp\
	shop_manager.cpp shopEx.cpp item_manager_read_tables.cpp offline_shop.cpp offlineshop_manager.cpp MeleyLair.cpp questlua_meleylair.cpp\
	TempleOchao.cpp questlua_templeochao.cpp\
	GrowthPetSystem.cpp questlua_growthpet.cpp\
	char_mailbox.cpp\
	minigame.cpp minigame_catch_king.cpp CsvReader.cpp\
	battle_pass.cpp switchbot.cpp questlua_pvp.cpp

COBJS = $(CFILE:%.c=$(OBJDIR)/%.o)
CPPOBJS = $(CPPFILE:%.cpp=$(OBJDIR)/%.o)

MAINOBJ = $(OBJDIR)/main.o
MAINCPP = main.cpp

default: $(TARGET)

$(OBJDIR)/minilzo.o: minilzo.c
	@$(CC) $(CFLAGS) $(INCDIR) -c $< -o $@
	@echo compiling $<

$(OBJDIR)/version.o: version.cpp
	@$(CC) $(CFLAGS) -D__VERSION__="$(REVISION)" -c $< -o $@
	@echo compiling $<

$(OBJDIR)/%.o: %.cpp
	@echo compiling $<
	@$(CC) $(CFLAGS) $(INCDIR) -c $< -o $@

limit_time:
	@echo update limit time
	@python update_limit_time.py

$(TARGET): $(CPPOBJS) $(COBJS) $(MAINOBJ)
	@echo linking $(TARGET)....
	@$(CC) $(CFLAGS) $(LIBDIR) $(COBJS) $(CPPOBJS) $(MAINOBJ) $(LIBS) -o $(TARGET)
	@expr $(REVISION) > ../REVISION

clean:
	@rm -f $(COBJS) $(CPPOBJS)
	@rm -f $(BINDIR)/game_r* $(BINDIR)/conv

tag:
	ctags *.cpp *.h *.c

dep:
	makedepend -f Depend $(INCDIR) -I/usr/include/c++/3.3 -I/usr/include/c++/4.2 -p$(OBJDIR)/ $(CPPFILE) $(CFILE) $(MAINCPP) 2> /dev/null > Depend

sinclude Depend

October 24, 2020

Hello, after changing the includes path to "../../mysql_8_0_20", I get an error when compiling the db and game source:

linking ../db_r40414_64....
ld: error: unable to find library -lmysqlclient
clang-9: error: linker command failed with exit code 1 (use -v to see invocation)
gmake: *** [Makefile:56: ../db_r40414_64] Error 1

linking ../game_r44214_64....
ld: error: unable to find library -lmysqlclient
clang-9: error: linker command failed with exit code 1 (use -v to see invocation)
gmake: *** [Makefile:127: ../game_r44214_64] Error 1

Does anyone know how to do this?

thank you

October 15, 2020

Hello everyone,

Would it be possible to know what I need to modify in the db sources to use mysql80?

Just an example if you like so I understand and change everything else on my side

Also, where do I find the mysql8 includes and then put them or in my sources?

I was using mysql56 and when I launch the server I have this :

# mysql_real_connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Thank you

October 12, 2020

Hello,

I'm currently looking to buy a server with source code, stable with all the new features of the official one.

Thanks

October 12, 2020

Hello,

Thank you all for answering, but being a beginner, could someone please explain to me step by step how to do it? Unless a tutorial already exists? Thank you in advance

October 11, 2020

Hello,

I hope that you and your loved ones are doing well in this complicated health crisis as well.

I wanted to know if it was possible to run my Metin2 server which is currently running Mysql56 part Mysql8?

Thanks in advance

Sign In

ZumbaCafew

Posts

Joined

Last visited

Feedback

Content Type

Forums

Store

Third Party - Providers Directory

Feature Plan

Release Notes

Docs

Events

Posts posted by ZumbaCafew

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Mysql56 to Mysql8

Buy a server with source code.

Mysql56 to Mysql8

Mysql56 to Mysql8

Community

My Activity Streams

Store

Tools

Important Information