How to update a game off a database

Posted by James Clifton on Game Development See other posts from Game Development or by James Clifton
Published on 2012-06-04T01:55:31Z Indexed on 2012/06/04 4:48 UTC
Read the original article Hit count: 387

Filed under:

game-design

I am currently writing a sports strategy management game (cricket) in PHP, with a MYSQL database, and I have come across one stumbling block - how do I update games where neither player is online?

Cricket is a game played between two players, and when they (or one of them) is online then everything is fine; but what if neither player is online? This occurs when championship games are played, and these games need to happen at certain times for game reasons.

At the moment I have a private web page that updates every 5 seconds, and each time it loads all games are updated; but then I have the problem that when my private web page stops (for example my computer crashes or my web browser plays up) the game stops updating!

Any suggestions?

Related posts about game-design

Game Design Dilemma

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I'm working on a 2d tilemapped RPG. I've actually made quite a fair amount of progress, but I'm at a point where I need to make a UI decision. I have the overland world completely mapped out, and I have several towns and special areas. I'm on the fence about how to integrate the two. Scenario 1: I… >>> More
Day 2 - Game Design Documentation

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
So yesterday I didn't cut any code for my game but I was able to do a tiny bit of research on the XNA Game Development Technology and the communities out there and do you know what? I feel I'm a bit closer to my goal. The bad news is today I didn't cut code either. However, not all is lost because… >>> More
Suggestions on switching from lamp based web design-development to game design-development

as seen on Programmers - Search for 'Programmers'
I have around 2.5 years of experience as a web developer cum designer working mainly on the LAMP platform. Now, I want to try out game development (of the likes of First Person Shooter games like Call of Duty (COD)). It is one of my dreams to some day succeed in making a profitable, popular, commercial… >>> More
Game Design Schools in Canada

as seen on Game Development - Search for 'Game Development'
I am a High School student in Ontario and i am trying looking for college/university programs the are specifically about game design. There are quite a few at most colleges near me, but they are all BA's and I am looking for a BSc. The only one i have been able to find is at digipen but that is across… >>> More
I want to make video games, but I hate coding

as seen on Game Development - Search for 'Game Development'
I know this sounds eally crazy. However, I just want to ask. Now, I am studying C++ code in my school (My major is computer programming). Honestly, my grade is not so good, and assignments are really hard. Sometimes, I feel sad that I will spend 8~10 hours per day for coding (which is stressful)… >>> More

Developer IT