The Little Guy Posted April 9, 2008 Share Posted April 9, 2008 I am making a server for online games, I would like to know: What would be the safest way for users to select, insert, delete, or update info in a database? The information will come completely from their game, so they have to write their own queries. I do give the the database username and password, but the user they get is a limited user, only one who can select, insert, delete, or update. The user can NOT create, drop, index, or alter tables. Any Suggestions, or Questions? Link to comment https://forums.phpfreaks.com/topic/100390-external-queries/ Share on other sites More sharing options...
Barand Posted April 9, 2008 Share Posted April 9, 2008 ... so they have to write their own queries. Any Suggestions, or Questions? I think you should be strapped into a straightjacket and taken away to padded cell. Link to comment https://forums.phpfreaks.com/topic/100390-external-queries/#findComment-513404 Share on other sites More sharing options...
The Little Guy Posted April 9, 2008 Author Share Posted April 9, 2008 I have been thinking... maybe I should have a query builder, that builds queries. This way they can only use queries I allow, and they can not physically write them. So when they run their game they link to a page with the correct GameID, and Game Unique Stamp (like a auth code). So.. they just enter into their game. I want: ID#: 2843 and Stamp: o87243lkjeo87h42o3l and when they go to this specific page it runs the query that they predefined (Safely) and returns text which they then can parse in there game. How about that? Link to comment https://forums.phpfreaks.com/topic/100390-external-queries/#findComment-513414 Share on other sites More sharing options...
Barand Posted April 9, 2008 Share Posted April 9, 2008 Welcome back to sanity. Link to comment https://forums.phpfreaks.com/topic/100390-external-queries/#findComment-513417 Share on other sites More sharing options...
gluck Posted April 9, 2008 Share Posted April 9, 2008 I have been thinking... maybe I should have a query builder, that builds queries. This way they can only use queries I allow, and they can not physically write them. So when they run their game they link to a page with the correct GameID, and Game Unique Stamp (like a auth code). So.. they just enter into their game. I want: ID#: 2843 and Stamp: o87243lkjeo87h42o3l and when they go to this specific page it runs the query that they predefined (Safely) and returns text which they then can parse in there game. How about that? makes sense Link to comment https://forums.phpfreaks.com/topic/100390-external-queries/#findComment-513420 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.