Jump to content
  • Advertisement

iNoMore

Member
  • Content Count

    7
  • Joined

  • Last visited

Community Reputation

106 Neutral

About iNoMore

  • Rank
    Newbie
  1. Hi!   So after my last post conclusions, I decided on a PHP based server for my game the server is pretty much done, the only problem is, that I have no idea how to keep track on logged users   I want to make sure that the same username is not used at the same time from different computers   At first I thought on saving a session key in the database and delete it when logging out, but what if the client crashed, or the connection was reset at the user`s end, I cant know when the user was disconnected and I cant know how long a game session will last   I hope you can point me at the right direction, Thanks!!
  2. Hi!   I hope its ok to post another question here and not in a new post   Do you have an idea on how to keep track on which user is logged in already? (to prevent 2 people to connect with the same account at the same time)   My server is pretty much done other than that...
  3. Hi! I Hope that ok to ask another thing in this topic, I thought that its stupid to start a new topic...   Do you have any idea how can I keep track on which user is logged to the server - In a PHP server so I dont have consistent connection, keeping in mind that maybe the game client crashed or something so I cant trust that a logout command has been sent to the PHP server?   My server is pretty much done other then that thing
  4. Thank you so much for your replays! I think I got the point and what I need for my game :) You helped a lot!
  5. Ok so ill try to specify my game Its a fps built in unity3d, i use photon cloud to mange the rooms and the game logic I only need to acess the database to store users, characters, and shop items About the server budget, we are not worried about that now, we will invest as needed to grow, but thats way i am looking for a way that will be fast and efficent
  6. Thank you for the fast replay!   Ok so you are right, normal database it is then   2 questions that I still cant understand would it be better to access a PHP website that will update the data or an app server that will do the database things?   and if an app server, will it be a good idea to load a few things in advance? like shop items or map list? or would it be smarter just to poll them out of the database each call?
  7. Hello!   I was looking around here for a while and couldn't get any answer that really covered it with explanation   So a little background, I am working on a room based FPS kind of game. I need to find a way to manage the data: Users - Details on the account Characters - every user may have more than one Inventory -  For each character (?)Store - Items and prices (BTW : would you recommend store it in DB or hard code it in the game and update by patch? I will have to send a patch anyway for most of the new Items so they can work)   After some thought I decided as a security measure to not connect to the database directly from the client, but create a costume server that will handle requests and replays by socket connection.   No I am trying to wrap my head around the server logic, what will be the best way...   Should I use a MySQL server to handle everything? Isn't that a little unnecessary? I could use a file to hold the data and poll it from there?   Or if I stay with MySQL, I could make the server app read all the data from the database and keep it on start up, since Store and things wont change after server start up and then when user request something I don't need any database access, and when I need to update, I update locally on the server app and have a separated thread update the SQL database every minute, so if I crash I wont lose that much data   So these are my thoughts, what do you think?
  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

GameDev.net is your game development community. Create an account for your GameDev Portfolio and participate in the largest developer community in the games industry.

Sign me up!