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? 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
Archived
This topic is now archived and is closed to further replies.