Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think if two people are accessing your website they can access the data separately and play game independently</p> <p>To control number of concurrent users in a site you have to create a Application State variable and store two selected user ids to it.</p> <p>Every time a user try to play game, you have to check if its ID exists in Application State variable or not , if exists allow him otherwise not.</p> <p>Of course you have to write lot of code to </p> <ol> <li>add/delete userid to Application State variable in Global.ascx file</li> <li>implement authentication to know who the user is and user validations.</li> <li>if you want them to sign out automatically after some time (idle/fixed) you have to write code in Session_End event of Global.ascx file.</li> </ol> <p>Let me know more details if you want specific answer.</p> <p>Create a class GameSession { int gameid; string player1; string player2}</p> <p>suppose there is only one game and 2 users max</p> <p>User Registration Process: if a first user enters to your website, check user if he is registered check his userid pwd and get his userid from table, if he is guest generate random key (guid) or ask him for the unique key (uniquenickname). </p> <p>State Management: create object of this class , assign gameid = 1 and assign player1 = user's unique key. Create collection of GameSession object say GameSessions, add GameSession to GameSessions Store GameSessions to Application State.</p> <p>Next time if another user logs in, follow the same User Registration Process. Check for empty slot (empty player2) in GameSessions, if found assign this user to first or selected empty slot of GameSessions. Now this GameSession is ready to serve.</p> <p>Save the object back to Application State.</p> <p>Allow user to play the game</p> <p>Write negative cases for above scenarios. </p> <p>This way you can do this.</p>
    singulars
    1. This table or related slice is empty.
    1. POhow to connect two people in your website
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USImran Rizvi
    1. USImran Rizvi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO1. Application State or Session State Variable? As Application State Variables are common for all users. Right? 2. How will I identify that the a particular game is private? I mean, Suppose we both are playing, without using database, How can I prevent third user to allow access to this game? Please suggest...
      singulars
      1. PO
      1. USPankaj
    2. COsee I have updated my answer, this is the basic idea, off course you have to write lots more code and modify few approaches. let me know if you need more information.
      singulars
      1. PO
      1. USImran Rizvi
    3. CO**Everytime a user try to play game, you have to check if its ID exists in Application State variable or not , if exists allow him otherwise not.** Which ID should i consider in case of Guest ? and Which ID to save in Application variable ?
      singulars
      1. PO
      1. USPankaj
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload