This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » Uploading database values to a "master" database

Uploading database values to a "master" database
Cody Erekson Member Since: 11 Apr 2009 Posts: 1	Posted 12 Apr 2009 02:36:09 Hello forum! Let me preface this by saying that my SQL/PHP experience is rather limited. I've essentially just done things like adding hacks and mods to existing free script sets such as phpBB3, Coppermine, etc. I've been reading some online tutorials on both, and have recently set up an Ubuntu box to play around on, so I'm picking up a bit more here and there. I have a project in mind, and I'd like some feedback on the best, most secure way, to go about this. I run a game modification forum for a single player RPG. An associate of mine recently created a small program can accept data from the game and insert them into an SQLite database. We want to make a site that displays a player's game stats. So for example, they will first register a username with the site, and then request a new character ID. They will put this ID into the game, and it will be used to identify this character in the database. On the personal PC, at certain intervals, the character data will be sent to the local database. Anybody on the web site can go in and view the current stats of any character. It will be categorized by user, then characters. The thing I need to figure out is how to best get the info from that local database into our online one. Ideally it would be nice if it could be updated at near-real time (the game data will probably only be written once every 5 minutes or so.) But if necessary, we will make it so that the player has to manually upload the information. So how can this be done securely? We are kind of paranoid after being hacked last year because I was using an uploader script that had some serious flaws. So I want to avoid the possibility of someone adding data to the database that will compromise our system. Or is that even really a concern with such a system? Thanks for your help with this, it is greatly appreciated! --Fliggerty Hello forum! Let me preface this by saying that my SQL/PHP experience is rather limited. I've essentially just done things like adding hacks and mods to existing free script sets such as phpBB3, Coppermine, etc. I've been reading some online tutorials on both, and have recently set up an Ubuntu box to play around on, so I'm picking up a bit more here and there. I have a project in mind, and I'd like some feedback on the best, most secure way, to go about this. I run a game modification forum for a single player RPG. An associate of mine recently created a small program can accept data from the game and insert them into an SQLite database. We want to make a site that displays a player's game stats. So for example, they will first register a username with the site, and then request a new character ID. They will put this ID into the game, and it will be used to identify this character in the database. On the personal PC, at certain intervals, the character data will be sent to the local database. Anybody on the web site can go in and view the current stats of any character. It will be categorized by user, then characters. The thing I need to figure out is how to best get the info from that local database into our online one. Ideally it would be nice if it could be updated at near-real time (the game data will probably only be written once every 5 minutes or so.) But if necessary, we will make it so that the player has to manually upload the information. So how can this be done securely? We are kind of paranoid after being hacked last year because I was using an uploader script that had some serious flaws. So I want to avoid the possibility of someone adding data to the database that will compromise our system. Or is that even really a concern with such a system? Thanks for your help with this, it is greatly appreciated! --Fliggerty

Uploading database values to a "master" database

Cody Erekson
Member

Since: 11 Apr 2009
Posts: 1

Posted 12 Apr 2009 02:36:09

Hello forum!

Let me preface this by saying that my SQL/PHP experience is rather limited. I've essentially just done things like adding hacks and mods to existing free script sets such as phpBB3, Coppermine, etc. I've been reading some online tutorials on both, and have recently set up an Ubuntu box to play around on, so I'm picking up a bit more here and there.

I have a project in mind, and I'd like some feedback on the best, most secure way, to go about this. I run a game modification forum for a single player RPG. An associate of mine recently created a small program can accept data from the game and insert them into an SQLite database.

We want to make a site that displays a player's game stats. So for example, they will first register a username with the site, and then request a new character ID. They will put this ID into the game, and it will be used to identify this character in the database. On the personal PC, at certain intervals, the character data will be sent to the local database. Anybody on the web site can go in and view the current stats of any character. It will be categorized by user, then characters.

The thing I need to figure out is how to best get the info from that local database into our online one. Ideally it would be nice if it could be updated at near-real time (the game data will probably only be written once every 5 minutes or so.) But if necessary, we will make it so that the player has to manually upload the information.

So how can this be done securely? We are kind of paranoid after being hacked last year because I was using an uploader script that had some serious flaws. So I want to avoid the possibility of someone adding data to the database that will compromise our system. Or is that even really a concern with such a system?

Thanks for your help with this, it is greatly appreciated!

--Fliggerty

Hello forum!

Let me preface this by saying that my SQL/PHP experience is rather limited. I've essentially just done things like adding hacks and mods to existing free script sets such as phpBB3, Coppermine, etc. I've been reading some online tutorials on both, and have recently set up an Ubuntu box to play around on, so I'm picking up a bit more here and there.

I have a project in mind, and I'd like some feedback on the best, most secure way, to go about this. I run a game modification forum for a single player RPG. An associate of mine recently created a small program can accept data from the game and insert them into an SQLite database.

We want to make a site that displays a player's game stats. So for example, they will first register a username with the site, and then request a new character ID. They will put this ID into the game, and it will be used to identify this character in the database. On the personal PC, at certain intervals, the character data will be sent to the local database. Anybody on the web site can go in and view the current stats of any character. It will be categorized by user, then characters.

The thing I need to figure out is how to best get the info from that local database into our online one. Ideally it would be nice if it could be updated at near-real time (the game data will probably only be written once every 5 minutes or so.) But if necessary, we will make it so that the player has to manually upload the information.

So how can this be done securely? We are kind of paranoid after being hacked last year because I was using an uploader script that had some serious flaws. So I want to avoid the possibility of someone adding data to the database that will compromise our system. Or is that even really a concern with such a system?

Thanks for your help with this, it is greatly appreciated!

--Fliggerty