sethwhitaker
commented
9 years ago user_connection table
Need to make sure duplicate rows are not made.
| id | user_id | connection_id | initiator_id | status |
|---|---|---|---|---|
| 1 | 1 | 2 | 1 | sent |
| 2 | 1 | 3 | 1 | connected |
| 3 | 2 | 3 | 3 | declined |
Closed sethwhitaker closed 9 years ago
sethwhitaker
commented
9 years ago Need to make sure duplicate rows are not made.
| id | user_id | connection_id | initiator_id | status |
|---|---|---|---|---|
| 1 | 1 | 2 | 1 | sent |
| 2 | 1 | 3 | 1 | connected |
| 3 | 2 | 3 | 3 | declined |
The user connections feature will allow users to challenge anyone whom they have established a connection with. Users will be able to see (or lookup) all users and request a connection.
When a user requests a connection an email is sent to the other user #59.
The issue this solves is that you are only able to challenge someone who is currently online at the same time. With the recent addition of game state saved feature, no longer do users need to be online at the same time to carry out a game. The ability to connect with people and challenge them when they are not online will complete the puzzle.
Will eventually add in an email & desktop notification #58 feature to notify a user that they have been challenged by a connection.