MySQL & LoginServer updates

Hi sswijaya,

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:

- GuildName

- GuildID

- GuildRank

I have created the following fields in the 'guild_member' table:

- GuildMemberID

- GuildID

- CharacterID

- JoinDate

- Rank

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.


Beceriler: Veri Girişi, Veri İşleme, Excel, PHP, SQL

Daha fazlasını gör: xr-e, numerical entry project^^%%, mysql function update, mysql update field, recorded game, mysql update function, mysql date field, game auto update, unique houses, file backwards, auto game player, auto update database mysql, capture time mysql, mysql database auto update, player mysql, character changes project, update database mysql file, rank mysql, mysql file write, make player character, make mysql game, capture entry project work, capture character game, game item database, mysql date table

İşveren Hakkında:
( 1 değerlendirme ) Sudbury, Canada

Proje NO: #6559476

Bu iş için 1 freelancer ortalamada $20 teklif veriyor


Hired by the Employer

$20 USD / saat
(58 Değerlendirme)