mpath 2013-08-26 23:48
Check your submission, I see no links.
Foon → Ludum Dare Explorer → LD27 → NSA's Where's Snowden?
| Category | Rank | Score | Count | |
|---|---|---|---|---|
| Innovation | 25 | 3.83 | ||
| Coolness | 2 | 89 | ||
| Humor | 30 | 3.85 | ||
| Mood | 117 | 3.40 | ||
| Overall | 215 | 3.28 | ||
| Fun | 324 | 2.85 | ||
| Graphics | 369 | 2.95 | ||
| Audio | 499 | 1.55 | ||
| Theme | 580 | 1.98 |
Check your submission, I see no links.
*claps*
Holy smokes. Very crazy. I appreciate this. Very much.
Thanks guys! Hopefully this goes down well :-)
We ran out of time so the dossier isn't finished and there are few plot setting emails. Might do a minor post compo release just on that.
It seems cool but I dont know how to play.
And the theme is not surveillance.
Where's the theme?! Anyway, cool ambience
Haha :D Now that's good black humour!! :D :D
Holly shit, thats amassing! Its the perfect game of freaks (aka. ME xD)... Only with the 1 letter password, the command interpreter with SQL support and the facking windows clip, you stole my heart :p
Congratz!
Crazy idea~ good job~
Great and very, very impressive work! Game is a tad complex for me right now after the lack of sleep induced by the jam, but I will come back and try to really complete it. The theme is not really there though, but you still did an amazing job!
Impressive !
Oh my god this is amazing. Glad you made this even though the theme wasn't surveillance in the end.
5 star's for humor, I burst out laughing from the title itself but the "secure passwords are at least 1 character long" and the emails finished me off hahaha
Athough I'm confused on how to play. I booked flights for my agents but what do I do afterwards?
Keep up the encouragent guys.
We kinda put the theme to one side and built the game we (read Will) wanted to. The 10-seconds thing is there in the game speed but we wanted it to be a deep game.
Some play hints.
To play smart you need to figure out the SQL (see help in Prism window).. Look for people who are flying from Moscow (code DME) to hostile locations as final destination (via multiple airports, not direct). Assume Snowden will be under fake ID. then, when your target is in the air on-route to a friendly country, delete their record from the flight itinerary. Bingo.
Or try to get your agents onto the same flight but that's a bit harder I think.
Insanely detailed! I'll have to come back to read through everything. How much of this did you write from scratch for the compo?!
@namuol basically all of it :) I made the SQL parser on Friday as warmup 'framework', but by the end of the contest I'd rewritten a lot of it anyway! http://www.ludumdare.com/compo/2013/08/23/im-in-and-im-going-to-use-sql/ Wombatica made lots more content - emails, subplots etc - that we never got time to incorporate. Wasted a lot of time trying to programmatically generate reasonable flight schedules....
lol, crazy idea
Interesting, I did not see the theme though. Also is there any audio? :)
Haha, like the political approach you took, although i have to admit that i lack the patience to go through all the text, a bit too slow paced for me.
Hah, completely unexpected this) What can I say, you sir are genius) Theme is just awesome!)
Awesome idea, but not so much with theme or game to do :/
Sweet. Excellent style.
Wow, what an intricate game. I'm very impressed you managed to code a UI and SQL system within that timeframe. Must admit I didn't have the patience to see it through to completion, but I did experiment for some time (I think I missed the flight or something).
Anyway, well done.
PAPERCLIP!
Doesn't quite fit the theme, but this game is absolutely brilliantly done. I am in awe at just how much you've managed to implement and will have to check out your source code sometime. You guys deserve a medal or something.
Very interesting (and frightening, and funny, yeah it feels weird to have both at the same time :p) concept. Props for aiming for realism!
good job
Top four SQL queries, in this order.
SELECT * FROM AIRPORTS AS A, FLIGHTS AS F WHERE F.DEPART = A.CODE AND A.COUNTRY = 'RUSSIA'
SELECT T.* FROM TARGETS AS T, MANIFESTS AS M WHERE M.PASS = T.PASS AND M.FLIGHT = '<insert flight ID here>'
SELECT F.*, M.REMARK FROM FLIGHTS AS F, MANIFESTS AS M WHERE M.PASS = '<insert suspected passport ID here>' AND F.CODE = M.FLIGHT;
DELETE FROM manifests WHERE flight = 'xxxxxx' AND pass = 'yyyyy'
That was excellent, very entertaining! Thanks for making this :)
Fun, like a more serious version of uplink. being a bit of a SQL noob, I had nowhere enough time to do anything more than run a couple of queries before Snowden escapes every time! If you work any more on this please add some way of changing how quickly time flows. Thanks to clippy and @wombatica for offering useful querries. How do you move your agents?
Wow! This was insanely deep, entertaining, and difficult.
People should suggest this game to those wishing to learn SQL.
Good luck with the increased surveilance at your house now!
darkshadow, look in the NSA internal email window. At the start there are two mails, one from each of your agents, telling you where they are and where they can fly to from there. Click on the flights you want them to take and it'll say "BOOKED". Crude by hey, it was built in quite a rush! They'll take the first one to leave and will only take the others if they return to the same airport. Each time they land they send you another mail. If you are super-keen you can plan their routes using PRISM flight details beforehand but takes some detective work.
Re speed, agreed. Just one of those things sacrificed for a) the 10 seconds theme and b) build time.
Wow, really impressive work, writing an own SQL parser is something I would have never expected to happen within a weekend.
I mean I like such games, (I also had a similar idea if the theme would have been 'Surveillance') but at the moment this is too much SQL for me. Better get some sleep and then try it again.
(It may sound crazy, but maybe this could be used to teach SQL to students...?)
Seems like an interesting concept, but I couldn't really do much as I don't know SQL (and the help isn't particularly.. well, helpful) Good work though! Not many can say they've made a parser in a day.
@wombatica Thanks I was able to book now. Ah okay if you do anything post jam, prehaps highlight it blue like a hyper-link or something to indicate it is functional rather than just plain text.
Slowly getting to grips with querying faster, still got loads to learn. I'll let you know if I have any success catching people.
I feel like this was good, but I think I'd like to be lead a little better with the gameplay, at least at the start. I think this was an amazing idea and very innovative, but something to really pull me into the game would have made it better for me :)
Wow, this was so ambitious. I loved the idea, completely original. I found hard the instructions, specially booking a flight for the 'agents'. The use and inclusion of pseudo-sql was really cool, and I believe this could be a great didactical tool, in the lines of Oregan Trail.
Btw, it is "Caracas Simón Bolívar, Venezuela", on the game it's named a little different the site, or you did that on purpose?
Found this game interesting and original, sadly I could not figure it out in merely a minute. I featured it in my video compilation series of LD27 games, if you would like to check it out :) http://www.youtube.com/watch?v=tyApng3Bq-c
Ahaha, incredible!