R
R
Redel Reiz2018-08-29 05:20:45
MySQL
Redel Reiz, 2018-08-29 05:20:45

Database write error?

Hello.
Please help me solve the problem with the database for the online game.
I downloaded the source of the online game Tower Of Heroes (Mobile)

http://forum.ragezone.com/f857/tower-heroes-mobile-1139327

after starting the server, I entered the database in the player table, there already was one record under id 1 , so far so good.
I go into the game itself, register a new account, go through training, receive rewards for quests, then I again went into the same player table, but the account did not confess, as it was alone and remained.
As usual, the entry should go in ascending order 1,2,3 ... But there is nothing at all.
And if you look at the end of the log, you can see how the server itself deletes the account.
Please tell me how to fix this error?
Here is the log
2018-08-29 09:44:51:877 [info] [c945124] PlayerHandler::friend
2018-08-29 09:44:51:897 [info] [c945124] PlayerHandler::friend
2018-08-29 09:44:51:917 [info] [c945124] PlayerHandler::friend
2018-08-29 09:44:51:938 [info] PlayerHandler::guildOp
2018-08-29 09:44:52:682 [info] [c945124] PlayerHandler::friend
2018-08-29 09:44:52:702 [info] DatabaseAsync::exe 5 second: sqlBytes:[20]/5=[4] count:[1]/5=[0] mergeCount[1], m_sqlBuffer.used[0].free[2097151],m_resultQueue.used[0].free[63]
2018-08-29 09:44:52:745 [info] [c945124] PlayerHandler::friend
2018-08-29 09:44:52:762 [info] DatabaseAsync::exe 5 second: sqlBytes:[24]/5=[4] count:[1]/5=[0] mergeCount[1], m_sqlBuffer.used[0].free[2097151],m_resultQueue.used[0].free[63]
2018-08-29 09:44:52:766 [info] [c945124] PlayerHandler::friend
2018-08-29 09:44:52:782 [info] DatabaseAsync::exe 5 second: sqlBytes:[32]/5=[6] count:[1]/5=[0] mergeCount[1], m_sqlBuffer.used[0].free[2097151],m_resultQueue.used[0].free[63]
2018-08-29 09:44:52:808 [info] PlayerHandler::guildOp
2018-08-29 09:45:36:587 [info] [c945124] closing player: processPacket net closed!
2018-08-29 09:45:36:587 [info] [c945124] server::closePlayer
2018-08-29 09:45:36:587 [debug] [server.cpp:1350] [bkb::Server::closePlayer] 1close player error! account map no player! accountc945124
2018-08-29 09:46:40:820 [info] login packet: name = Dhgffhuh, version = 154
2018-08-29 09:46:40:820 [info] LoginQueue: add userid [Dhgffhuh]
2018-08-29 09:46:40:848 [info] LoginQueue::_login begin Time = 769675
2018-08-29 09:46:40:848 [info] load balancer: name[Dhgffhuh] exists index[1]
2018-08-29 09:46:40:848 [info] LoginQueue::_playerLogin: account = Dhgffhuh
2018-08-29 09:46:40:848 [info] kick player: account = Dhgffhuh
2018-08-29 09:46:40:848 [debug] [player.h:509] [bkb::Player::sendPacket] [c945124] send packet but connection is null!
2018-08-29 09:46:40:848 [info] [c945124] server::closePlayer
2018-08-29 09:46:40:848 [debug] [server.cpp:1350] [bkb::Server::closePlayer] 1close player error! account map no player! accountc945124
2018-08-29 09:46:40:848 [info] Server::inst().closePlayer() failed! cann't kick: account = Dhgffhuh
2018-08-29 09:46:40:848 [debug] [player.h:509] [bkb::Player::sendPacket] [c945124] send packet but connection is null!
2018-08-29 09:46:40:848 [info] login queue delete player[Dhgffhuh][2]
2018-08-29 09:46:40:848 [info] LoginQueue::_login end use Time [0] loginCount=[1]
spoiler
Ребят можно пожалуйста без сарказма помочь, пожалуйста не тратьте ваше время на такие фразы как Google в помощь, иди читай книги и т.д... Я все понимаю мне действительно нужно читать такие книги чтобы вопросов меньше было, но все же. Подскажите пожалуйста. Спасибо за понимание.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
stainer, 2018-08-29
@stainer

Attach a screenshot of the database structure and field properties

R
Redel Reiz, 2018-08-29
@Redel

5b86ae35e8247746078287.png5b86ae3ed113f102784682.png5b86ae45196a4827541353.png5b86ae4c4567b583305576.png5b86ae528eb19124174019.png5b86ae584de5a545020834.png
I don't think I'm wrong

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question