Jump to content

Question with access database and how to interperate it with mysql


purge08

Recommended Posts

I am currently working on a web browser based mmorpg game.

i have a database of items for it and the creatures and such.

but what i need to help in what to do is the following:

 

player buys or finds item A:

player has 3 of all 5 different crystal colors which can be used to upgrade the weapon. but can only use a max of 3 crystals total per craftable item.

player decides to use only one crystal type, and changes it to a frost blade.

how do i make a table that references to the first one and if certain requirements are met that now show that the user has a new item. and even a newer item as he upgrades it 1 to 2 more times till the maximum upgrade per item limit?

 

also, for the items in a persons backpack possession and those equipped. do i make another table listing that players items, or use the player profile table?

 

and how do i show how many crystals that player currently has of each type?

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.