purge08 Posted July 1, 2009 Share Posted July 1, 2009 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? Quote Link to comment https://forums.phpfreaks.com/topic/164342-question-with-access-database-and-how-to-interperate-it-with-mysql/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.