ZumbaCafew

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

All right, thank you I will try

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

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

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

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

Hello, I have a machine under FreeBSD in x64 I don't have the lib-lmysqlclient Thank you

Hello, up please Thank you

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

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

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

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

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

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