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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.