Jump to content

Recommended Posts

Ok I'm switching the game I'm developing from XML files over to using an online database, but what I did in XML was time consuming to do so I was looking for an easier way while I make the transition. Anyway here is what I'm doing:

 

its a fighting game so I have a table for the character, another table for the attacks each character can only use certain attacks and some attacks can be used by all the characters, so I was wondering what the easiest way would be to make it so that when I'm loading the characters it lists only the attacks that they can use.

 

I thought about making a field in the characters table and then putting the ID of the attacks that they can use, or the opposite and putting a field in the attacks with the ID's of the characters that can use the attack.

 

That was kind of confusing I apologize, but I can't really explain it any better.

Link to comment
https://forums.phpfreaks.com/topic/158790-looking-for-easiest-way-to-acheive-this/
Share on other sites

I thought about making a field in the characters table and then putting the ID of the attacks that they can use, or the opposite and putting a field in the attacks with the ID's of the characters that can use the attack.

Make  a third table linking the two...

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.