Another way (and is pretty close to a many-to-many intermediate table) is to have all the moves in their own table, of course. Then have another table that combines the moves to the player with 3 columns: ID, which is just for indexing to speed up queries and won't be used. fighter, which is the ID...

Infinite to both. I will be adding moves as the game goes on and every move I add can be attained in one form or another. I'm launching at 500 moves. If I had to guess a range where moves will be added more sparingly, I'd say around 750. This is not a normal "fight" game, this is a game ba...

Fighter pulls x amount of moves he has and they are then used randomly throughout a fight. What makes this different is a fight has 5 different sections where certain moves can only be used. Therefore move x can only be used in section 1,2, or 5 in random output. In each section, the script will loo...

Well, the way I would probably tackle this is to have a move list table. All moves listed out in singles, one row per one move. Each move will have a move_id. That is what I have now with 12 different fields/attributes. (id, name, damage, energy, etc) Then you have another table that is called move...

I am trying to figure out the best way to store some data in my database. I plan on joining 3 different tables. users table fighters table moveset table In the fighters table I have a row for 'moveset' in which I am trying to figure out a way that move_id's from the moveset table can then be associa...

Chalk me up for buying one a good year or two after release. I bought a 360 and PS3 at launch and it was a mistake. I'd rather wait on a price reduction and a more established game collection.

I completely get it now, I didn't even know that about the sections and whatnot. It all makes sense now. You could do for loops, and have it set to once the total moves reaches 10, it advances to the next section. Then for each section, have it pull the fighters moves for that section. IE if it was...

I was thinking of having an overall health/energy system with the move sections. The reason why I chose sections from an overall start/end/post concept is there is already a few wrestling sim games and they all have the start/end concept with light/medium/heavy moves. The problem with this ultimatel...

Thanks man, I was starting to think people were just ignoring me. Haha

I am trying to figure out how to run a play-by-play simulation(simulator) for a wrestling game(think WWE/F). Wrestler1 and Wrestler2 have 100% health to start and each move from the move database does x amount of damage and deducts y amount of energy. If the move is hit it subtracts from health and ...