I would like to make a few more changes to the database structure and LoginServer. Are you available to work on this / how much time do you think it would take you?
These are the changes:
1. I have removed the following 'guild' fields from the character table:
I have created the following fields in the 'guild_member' table:
Currently, the LoginServer project does not write to the guild_member table at all.
I would like the above fields in the guild_member table to function like this:
+ GuildMemberID -> Primary key and auto-increment whenever a new entry is written to this table;
+ GuildID -> To be the same GuildID issued in the 'guild' table. So if guild 'xR' has a GuildID of '2204', whenever a player joins the guild, it writes the GuildID as '2204' in the guild_member table.
+ CharacterID -> Whenever a player joins the guild, their CharacterID is captured in the table (instead of the 'CharacterName').
+ JoinDate -> Date the player joined (i.e., NOW when the entry is written)
+ Rank -> Whatever entries updated the 'GuildRank' in the character table would now instead update the 'Rank' field in the 'guild_member' table.
2. Every item in the game has a unique 'ItemName' and 'ID' as identified in the configuration files ([url removed, login to view], [url removed, login to view], [url removed, login to view]). Whenever an entry in the 'item' table occurs, the 'ItemName' is recorded properly. However, currently, the entry does not capture the item's 'ID' as identified by the same configuration that houses the names of the items. Would you be able to set it up so that it does? ItemID would be the primary key and auto-increment (i.e., every entry generates a sequential ItemID as it currently does) and 'ID' would be the numerical ID of the item associated with the item. I think the code tries to do this (the ItemUniqueID C++ references)...I may have it backwards where ItemID needs to be the unique itemID per the configuration file and ID needs to be the auto-increment. Whichever way would work I would be happy with.