Aquaria Open Source Project: Online Mod Database

[RoadCrewWorker]

Exactly how many released mods are actually out there anyway? Isn't concentrating on a DB CMS for <10 instead of actually modding a bit of overkill?

Portable UniServer has worked well for rapid prototyping apache/php/mysql designs for me. You don't really want to run a real website from/through your dads pc though.

[GMMan]

I've managed to get the thing working a bit, but also broke something else on my server. I was playing with regular expression, and I can't seem to make them work properly. Could someone write a test pattern for me that will match "/aquaria-mod-db/*.html", where * may be anything, and also one that will match "/aquaria-mod-db/dummy" (a page that doesn't have ".html" on it) but not "/aquaria-mod-db/media/theme/blahblah/dummy2.png" (my current one matches both, and I can't figure out how to exclude everything after the second "/".) (My PHPMyAdmin is affected because of those test expressions.)

[frostyfrog]

/aquaria-mod-db/*.html = "/(aquaria-mod-db\/[-_+a-z0-9]*.html)/i"
/aquaria-mod-db/Anything = "/(aquaria-mod-db\/[-_+a-z0-9]*)/"
Tested on http://www.regextester.com/

Edit:

Exactly how many released mods are actually out there anyway? Isn't concentrating on a DB CMS for <10 instead of actually modding a bit of overkill?

Maybe, but it's better to place the system in now then to place it in down the line when there are hundreds . Also, I'm not too good at modding.

Portable UniServer has worked well for rapid prototyping apache/php/mysql designs for me. You don't really want to run a real website from/through your dads pc though.

I've been using WAMP ( http://www.wampserver.com/en/ ). I'm running this through my computer which is on 24/7 pretty much anyways and I don't have a job to get it hosted, so it's been going through my computer for now.

[aerozol]

Exactly how many released mods are actually out there anyway? Isn't concentrating on a DB CMS for <10 instead of actually modding a bit of overkill?

I don't know how many people have bought/ installed Aquaria so far, but it's a lot.
I think the main thing is that mods don't get much exposure. Releasing a browser that highlights even just one good mod, would be a huge boost in support for the creators, and would definitely get more people in.

It would have to be in an official patch though, because if someone's going to bother installing 3rd party software to do it, they may as well browse the mods on the web too, or just grab the ones they want of the list of mods in the Wiki. imo

[GMMan]

@frostyfrog:

/aquaria-mod-db/Anything = "/(aquaria-mod-db\/[-_+a-z0-9]*)/"

I mean immediately following the "/aquaria-mod-db", and nothing after that (or it may rewrite everything else as well. Maybe I should try url.rewrite-once?

I'll test it out tomorrow. Thanks.

[frostyfrog]

that /anything meant stuff like: dummy, about, etc. not like: dummy/test/

[GMMan]

I've  fixed up the regular expression patterns a little bit, and now everything is displayed properly, and the rules aren't devouring other pages either.  Here's what I changed in my lighttpd.conf:

Code: [Select]

url.rewrite-once              = (
        "(/aquaria-mod-db/[-_+a-z0-9]*.html)\?(.*)" => "/aquaria-mod-db/index.php?$2",
        "(/aquaria-mod-db/[-_+a-z0-9]*.html)" => "/aquaria-mod-db/index.php",
        "(/aquaria-mod-db/[-_+a-z0-9]*)$" => "/aquaria-mod-db/index.php"
)

The app should be up and running on my server now. I still need to test uploads. If you want to have a look, go to http://216.197.137.27/aquaria-mod-db/.

UPDATE: I had to add another line to the url.rewrite-once list, because the server would rewrite an URL with "?file=blah" at the end with one that doesn't have it at the end.

[GMMan]

Everything should be working now, though I do get a warning when uploading a mod that says nl2br() has the wrong number of arguments (which I checked, shouldn't have a problem).

@frostyfrog: There doesn't seem to be any way to download mods. That sort of defeats the purpose, doesn't it?

[frostyfrog]

Currently, no there isn't. I'll go ahead and commit soon.

[Lady-Succubus]

I need to work on the design but now that I have time I'm too lazy to. T_T

[GMMan]

I've updated my server with the new files from the SVN. It's working. A couple suggestions (as a text based browser allow):
1. There needs to be a bit of spacing between the mod icon and the text.
2. Filenames needs to be prettied up. No one is going to be able to find a file named faaab.zip. Maybe record the original filename on upload and then apply it to the download file at user request? Also, instead of telling the client to pull the file from a specific location, how about using something like a "file_download.php" to both pull the file and apply the original filename?

[Lady-Succubus]

The first point I will work on when I get to designing the website.

The second... well frosty can deal with that one. :3

[GMMan]

I just tested mods.xml, and it doesn't work. I've updated my url.rewrite-once list, and I get the error

Code: [Select]

Parse error: syntax error, unexpected T_STRING in /var/www/aquaria-mod-db/root.php(22) : eval()'d code on line 1 when I try to access it. The page on frostyfrog's server returns a blank page.

[frostyfrog]

lol, sorry about that. the problem was A) I just barely setup the DB on Linux now, B) PHP was allowing short tags and the first line in that XML file uses php's short tags. It is currently displaying everything correctly now and...

No one is going to be able to find a file named faaab.zip.

I can, in linux, I just search start typing the name in my downloads folder. I can do the same thing in windows, and I'm pretty sure macs have the same capability. Also, the only web browsers that I can think of that would make it more difficult, would be IE or Lynx, since both browsers don't have recent download lists. And a problem with the file_download would be that it would make the file come a lot later then it would normally since the server would need to read the file, load it into the output buffer, and then send it. the bigger the file, the longer it would take.
I can't really think of a reason to change it from how it is, but I could if it becomes a problem.

A couple suggestions (as a text based browser allow)

So, text browser support? I can do that. I was also thinking of iPhone support and such.

1. There needs to be a bit of spacing between the mod icon and the text.

I can fix that.

[GMMan]

[strike]Say, could you commit your changes to the XML mod list?[/strike] Nevermind, I just inserted a bit of PHP to write out the first "<?". There isn't any links to the XML, maybe you could put that in somewhere?
Regarding the text browser, I'm just saying I'm using Lynx to go on the forums (because it's blocked from my regular connection, so I can only use my server at home to access the forums. And it doesn't have VNC, so I'm stuck with Lynx (have you tried to put VNC on an Xbox server? It's a pain and it's so slow.))
For the download thing, maybe it's possible to modify only the filename header, and then just directly output from the file on the server.