Bay 12 Games Forum

Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: Creative game project, some advice needed  (Read 590 times)

MrOnio

  • Escaped Lunatic
    • View Profile
Creative game project, some advice needed
« on: January 09, 2013, 01:11:43 am »

Hello all!

I've been playing with creating games since I was about 10 with QBasic and now that I am in my 20's I'm starting to actually understand it (I'm a little slow).

I have an idea for a game, that I actually started to create singleplayer but decided that would be boring compared to multiplayer, so I decided to go with that. The question I have is if anyone here had made a multiplayer game using PHP and SQL? I know it works, because I made it where you can login and chose a player, move around and other players see it. My roommate tried it with me and it seemed to be working ok. I'm kind of concerned going this route though, because I see a lot of security issues with using PHP as the SQL database is where all player positions are stored at the moment so a mean person could send their own custom info to the PHP file and update another players position to wherever they wanted.

Thanks for the help!



Heres a little screenshot of the singleplayer game that I was making, I was looking in the fridge playing taking apples and putting them back in. (I finally understand the 'array' now, woot!) There was some neat features in the game, each of the blocks could be destroyed, if an outerwall got destroyed for example, oxygen in the room was removed, and you were slowly being sucked out the hole if you were to close. Lots of SS13 inspiration here!



Long time reader of these forums by the way (love the other game section, found so many great games reading through that!)
Logged

zombie urist

  • Bay Watcher
  • [NOT_LIVING]
    • View Profile
Re: Creative game project, some advice needed
« Reply #1 on: January 09, 2013, 01:28:38 am »

The Kingdom of Loathing is mainly PHP + some database and its very secure. Security, of course, depends on how well you write the php files and such.
Logged
The worst part of all of this is that Shakerag won.

GreatWyrmGold

  • Bay Watcher
  • Sane, by the local standards.
    • View Profile
Re: Creative game project, some advice needed
« Reply #2 on: January 09, 2013, 10:05:49 pm »

This looks neat.
Logged
Sig
Are you a GM with players who haven't posted? TheDelinquent Players Help will have Bay12 give you an action!
[GreatWyrmGold] gets a little crown. May it forever be his mark of Cain; let no one argue pointless subjects with him lest they receive the same.

MrOnio

  • Escaped Lunatic
    • View Profile
Re: Creative game project, some advice needed
« Reply #3 on: January 11, 2013, 01:41:38 am »

I guess I'll have to work on the security part  :(

But for now I guess I'll focus on the core game, I've recently implemented a type of paperdoll (wayyyy more difficult than I thought it'd be).
I also changed the way the backend works, so that instead of searching through every player in the database, it now looks for the table they are in, based on the area they are in.

My pride and joy of the night, 3 players who can all see each other along with teleporters to take you to different areas, and a paperdoll system that all players can see, and animations to boot! wohoo


Logged