I'm creating a text based rpg in php/mySQL and I've come up to a dead end in regards implementing the pvp aspect of the game. First off is this even possible in php/mysql? If so, how would I go about implementing it? I was thinking something like having an arena or room where you can go to battle. Then have a list of everyone else in the room who is looking for a fight. You can then make a request to fight someone from the list. Once the request has been accepted, then you can begin the fight. In terms of this mechanic, it seems to me something similar to what I am after is described in the following question: http://stackoverflow.com/questions/8934681/database-design-for-turn-based-game

P.S. The combat system is turn based. So first you attack, then the enemy attacks, and so on until you have a winner.

I'm creating a text based rpg in php/mySQL and I've come up to a dead end in regards implementing the pvp aspect of the game. First off is this even possible in php/mysql? If so, how would I go about implementing it? I was thinking something like having an arena or room where you can go to battle. Then have a list of everyone else in the room who is looking for a fight. You can then make a request to fight someone from the list. Once the request has been accepted, then you can begin the fight. In terms of this mechanic, it seems to me something similar to what I am after is described in the following question: https://stackoverflow.com/questions/8934681/database-design-for-turn-based-game

P.S. The combat system is turn based. So first you attack, then the enemy attacks, and so on until you have a winner.