Aquaria Open Source Project: Online Mod Database

[Dolphin's Cry]

Do you mean security as in escaping user-supplied parameters in SQL queries or putting the database password into a configuration file that is not included in the publicly viewable SVN repository? It would be a shame if some hacker breaks into the database and destroys it just because he's bored.

[frostyfrog]

Do you mean security as in escaping user-supplied parameters in SQL queries

Exactly!

or putting the database password into a configuration file that is not included in the publicly viewable SVN repository? It would be a shame if some hacker breaks into the database and destroys it just because he's bored.

MySQL doesn't reach outside of my house. Besides, that user only has access to that project. I'll make sure to put it all in a config, well, soon anyways.

[Lady-Succubus]

MySQL is something that the engine uses, though, right? :/

[frostyfrog]

yes, that is just the database though, I can't get my dad to allow too much through from my computer
Most servers that allow php5 though, have MySQL preinstalled.

[Lady-Succubus]

Yes, but what I mean is, if your webserver is accessible from outside, the MySQL queries it performs can be performed via outside access as well, right?

Yes... that makes sense. xD

[GMMan]

I'm just thinking, why not do it the way GooFans did it? Build a website specifically for modding, and make a utility that automatically install mods. It'd be hard to make a leaderboard for Aquaria, but everything else would be doable. All that needs to be done is customize the content management software so that it's suited to mods. It's better than starting completely fresh.

(Annnnddd... I might be able to host the entire thing on my server (consisting of an Xbox), though I have no idea when I would do it, and how fast it would be if I did do it (my connection is DSL). Oh, and it's on only from 8 till 5, so I hope that won't be too much trouble.)

[Lady-Succubus]

That is, in fact, what we are planning to do, I believe. :3

Except we have someone willing to edit the game source on board, so the utility will be in the game itself. :3

[GMMan]

Interesting idea, but I'm not sure if Bit Blot is going to release a community version of the game alongside the main game.  It has to be packaged separately, somehow (I mean the new game engine and everything).

If there were to be mods that extend beyond the current capabilities: The engine itself needs to be very flexible. In fact, what if the engine itself was just a runtime, and everything else are just scripts? At least that solves the "I'm going to add more emotions" problem.

[Lady-Succubus]

Well, we can figure it out once the engine goes open source. :3

[GMMan]

I've got the project downloaded on to my server, though I'm having a bit of trouble getting it to all work. I've got the SQL tables and accounts set up, and should be working, but somehow requests to other pages are not responded to and are just returning 404 errors. The thing is set up at 216.197.137.27/aquaria-mod-db/ . (I'm a PHP noob, so I have no idea how to fix it myself.)

(I'm running lighttpd, if it helps.)

[frostyfrog]

Is there some way for me to contact you other than the forums? (via chat program I mean) I think it may be because I enabled a few things in apache (like mod_headers) but I'm not sure what else I've done to my installation, so I would like to talk to you in real time to try to figure this out. Once I figure out all that I have changed, I will commit another change with all of the modified settings in  a readme file. Sorry for the inconvenience .

[GMMan]

It looks like that my webserver tries to literally find the .html file and fails.

@frostyfrog: I'll PM you on Saturday if I have time.

[frostyfrog]

Ok, I'll be waiting then. Sounds so far like apache doesn't allow htaccess files to overide.

[GMMan]

Ok, I'll be waiting then. Sounds so far like apache doesn't allow htaccess files to overide.

Actually, I'm running lighttpd. Maybe it doesn't support htaccess overrides? I did a search, and the way lighttpd parses overrides are different to the way Apache does.

[frostyfrog]

It looks like lighttp isn't ever going to support htaccess files. Here is a solution if you don't mind installing another web server and have the space/time: http://www.apachefriends.org/en/xampp.html