- Joined
- Sep 23, 2011
- Messages
- 189
- Reaction score
- 51
wz add more column in item bmd and need other editor for bmd files
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Original databases UPDATE from mesosa (Thanks!)
Until he update the original repository I just on my personal one
Buff Template =>You must be registered to see links
character_base
character_bonus
character_experience_bonus
character_experience_table
character_formula
character_helper
character_item
character_max_level_reward
character_skill
character_specialization
character_stat_fruit
You must be registered to see links
Admin Command:
for Invisilibity press .cmd 0 (ON/OFF)
for Attack press .cmd 1 (ON/OFF)
for been Attacked press .cmd 2 (ON/OFF)
for allow WHISPER .cmd 3 (ON/OFF)
FULL ADMIN_FLAG => 4194303 (remember set authority=2)
Thx for update .
I have a question why characters no make any dmg ? only mobs can attack us ?
Thx
For this, we must use MySQL instead of Microsoft SQL?
For this, we must use MySQL instead of Microsoft SQL?
Why no higher? High have compbaility, but lower nope.You need 5.7.XX (5.7.29, 5.7.31 or 5.7.33) version
Dont uset lower or higher.
Why no higher? High have compbaility, but lower nope.
You need 5.7.XX (5.7.29, 5.7.31 or 5.7.33) version
Dont uset lower or higher.
Its regarding that mysql 8 dont support INSERT DELAYED, it's just ignore by that version
PrepareStatement(MULOG_STATEMENT_ITEM_DROP, "INSERT DELAYED INTO log_item_drop (server, account_id, account, char_id, char_name, player_data, item_data, `comment`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
Maybe it's not a big problem anyway
So, it seems that STARTING with MySQL 5.7, INSERT DELAYED can be used but internally it will be converted to only INSERT.We removed the support for INSERT DELAYED in 5.7 and onwards. INSERT DELAYED has a lot of limitations and issues attached to it, and with InnoDB as default engine it becomes even less relevant. We decided to keep the INSERT/REPLACE DELAYED syntax, but convert it to INSERT/REPLACE with a warning before execution. (Remove INSERT DELAYED,You must be registered to see links)
You must be registered to see links
So, it seems that STARTING with MySQL 5.7, INSERT DELAYED can be used but internally it will be converted to only INSERT.
So, to keep the real INSERT DELAYED behaviour, MySQL 5.6.xx must be used?
We either rely on the old DELAYED behaviour of MySQL to insert this data, or the C++ code of the GameServer must be updated to insert on different threads (didn't check the code to see how it's actually done since I don't have the code at the moment).
But that delayed is needed (if something similar is not implemented in the C++ code), otherwise calls that block may happen.
Anyway it's async logs, i think it maybe even udp.Good Point, @Mulegend is there a strong reason for "INSERT DELAYED"? or is something that we could change on the source and use only INSERT with MYSQL 8.X?
I see server, logged in but cant create character, do I need to change anything in database?
You must be registered to see links
2021-03-24_10:58:25 INFO [ LOGIN REQUEST ] Success [SRV 0 -- 1501 - IP: 192.168.1.200 - MAC: ########## - Account: 3-hellboy - ]
2021-03-24_10:58:35 INFO [ CHARACTER CREATE ] [SRV 0 -- 1501 - IP: 192.168.1.200 - MAC: ########## - Account: 3-hellboy - ] Created character [Angel] class 32