At 2/24/09 09:21 PM, LazyPint wrote: Tour the Guinness factory!

Noted, and will do!

Also, I hope you're richer than God because Dublin is a very expensive city, though maybe the celebrations will lower prices.

Actually I'm pretty broke from booking the trip. I have like two weeks to raise some cash, but I hope my friends are just gonna get some Irish strangers drunk so they buy the next 60 rounds. Not planning on spending much cash other than food, drinks and perhaps a shirt.

Don't expect to see many Irish people, it's surprisingly diversely populated and staffed.

As long as I hear the accent a lot. Man I love that accent. (especially in women, lol)

I beat you.
Loving that site. They did say something about my eyebrows though :(

At 2/24/09 08:52 PM, Podburrys wrote: Hope you don't leave leave on St. Patty's, or you'll miss it - timezones.

I'm near amsterdam, it's 1 hour difference or something and I'm returning the 18th in the evening. St Paddy's is 17th right?

That's right! me and some friends have booked a cheap flight and crappy hostel for St. Patricks Day! I'm going to Dublin from 14th until 18th march!

Any tips on what to do there, except celebrate? Anything special to do?
And where do I get green beer?

I got $500, I can now buy food!

=D

At 10/29/08 10:44 PM, LostVoices wrote: looks awesome

Sign up here

www.flashgamelicense.com

im sure someone will sponsor that

I've been a member there for some time and I will put it on there if I still can't find a sponsor, but the best thing would be to get it over and done with before halloween

I've spent ages upon ages working on my next game, it's the sequel to a Halloween game I made two years ago. I really spent a lot of time to finish it before this Halloween, and guess what? It's done!

Now I really worked hard on this game and it would be nice if I could make some money off it, but it's only two days until Halloween and I'm having lots of trouble finding a decent sponsor, and I've only made money from my games with sponsors. I have no experience with ads or whatsoever. So my question is: what is a good way to make some nice money for my hard work in very very little time to set up? :) Or do you think people are interrested in sponsoring a Halloween game when Halloween is already over?

on a side note, it's not all about the money. I did enjoy making this game. It's just a little bonus and I focused really hard on this game so I'm a little low on cash these days.

Also, check out some pimpin screenshots of my game:

http://img520.imageshack.us/my.php?image =src1hh8.jpg
http://img520.imageshack.us/my.php?image =src2wr5.jpg
http://img530.imageshack.us/my.php?image =src3rv1.jpg
http://img112.imageshack.us/my.php?image =src4if1.jpg
http://img88.imageshack.us/my.php?image=
src5lv0.jpg
http://img112.imageshack.us/my.php?image =src6cp8.jpg
http://img225.imageshack.us/my.php?image =src7hr2.jpg

So when it's St. Paddy's again, me and a group of friends are going to visit Dublin (arriving 19.05 at some airport in Dublin the 16th of March and leaving again at 15:25 the 19th) - we managed to get the flight and shelter for 120 euro's each of us.

Now how much money should I save up to be able to buy lots of food, drinks, souvenirs and have an awesome time? Also what the fuck is the currency of Ireland? Dollar? Pound? Raw Fish? Yen? Shilling?

Newgrounds, you know everything so help me out here

Flock. Because I broke firefox :(

have gold

the cinematic trailer causes boner syndrome. Damn, it looks wicked.
The gameplay trailer is huge so I didn't get a chance to check it yet.

17.
Holy shit it are correct

At 4/11/08 04:29 PM, EviLudy wrote: about a second between when my swing hits the body and death to occur?

Just leveled up and lost the axe, lol.
Still pretty fast

about a second between when my swing hits the body and death to occur?

I have no experience with INNER JOIN. Where do I go from there?

So I'm on this databse project for my school and I'm having some trouble with getting the right query. What I have is this:

SELECT bezoeker.voornaam, bezoeker.tussenvoegsel, bezoeker.achternaam, bezoeker.woonplaats AS uit, route.film_1 as 'Film 1', route.bios_1 as 'bioscoop 1', route.film_2 as 'Film 2', route.bios_2 as 'bioscoop 2', route.film_3 as 'Film 3', route.bios_3 as 'bioscoop 3', route.film_4 as 'Film 4', route.bios_4 as 'bioscoop 4', route.film_5 as 'Film 5', route.bios_5 as 'bioscoop 5'
FROM bezoeker, route
WHERE route.routenr=bezoeker.routenr
ORDER BY bezoekersnr;

Nou this pops up all records from the table 'bezoeker' and some fields of it, followed by a bunch of numbers (from the table 'route' which holds numbers for 'bioscoop_1' ~ 'bioscoop_5' as well as 'film_1' ~ 'film_5')

Now I have two other tables called 'bioscoop' and 'film.'
For example I will use the table 'film'

Film's contents are something like this:
filmnr | titel
1 | Juno
2 | Eastern Promises

Now when in my query I show 'route.film_3' it shows a number, for example '2'
What I want to do is not show that number but show the text that is in the field of 'titel' in the table 'film' where 'filmnr' is 2. So in this case it would show Eastern Promises
And so on for all fields: film_1, film_2, film_3, film_4 and film_5.

Same goes for bioscoop. Bioscoop has 'bioscoopnr' and 'naam.' And I want it to show what's under the field 'naam' for the corresponding 'bioscoopnr'

My question is: is this possible in one query? (so no messing around with php or whatever. I need to be able to open access or another database tool, enter this one query and get the desired result) And if it is possible, can someone help me with it?

Thanks in advance.
I hope I made clear what my problem is. Below is an image about how relations should be.

At 3/14/08 06:47 PM, Gagsy wrote: IT. Though it's fucked up at the end.

It was too long for it's coolness :(
Insomnia, the shining and Cujo are win. I have yet to read misery

I don't mind waking up.
Getting out of bed that's the problem. as well as being fucking tired the first part of my day.

I'm gonna try and pull it off.
Updates later.

At 1/25/08 09:33 PM, jackripperz wrote: Anyway i like traveling. Right now,im preparing myself for an audition. If i can win that, i can go international! If I can.

I was just about to flame your for staying off topic, but what the hell.
Audition for what? I myself am sort of an actor myself. Been in several plays and got paid for it. I'm auditioning for Drama school pretty soon.

ALL RIGHT FOLKS BACK ON TOPIC

At 1/17/08 10:53 AM, flashsurfer11 wrote: BBS is KH3, there are a two newer games in production 365(?)/2 days which is DS, BBS for a next-gen console, in the english (or jap if you can read it) secret video in KH2 it said birth by sleep is KH3.

All false.
None of the new announced games are sequels to KH2.

- 358/2 days is set before KH2 and is about Axel and Roxas and their days in the organization. Since Roxas has left the organization in KH2, it is set before KH2. For nintendo DS.

- KH: Coded is basically bullshit. It's about people having forgotten about some events and some digital tricks to clear it up and reliving it all. Takes place between KH and KH2. For phones.

- Birth by sleep is the most promising new game thus far. It's a story with all new characters, set 10 years before the events of Kingdom Hearts. This game probably explains all items that eventually caused the events of Kingdom Hearts. It features a guy who looks just like Roxas but since Sora only got heartless in KH2, he didn't have a Nobody 10 years before that. So either it's a weird look-a-like or we're getting a weird ass explanation. Why did we see a trailer at the end of KH2 about this? That's easy. Seeing the trailer doesn't mean it's the next sequel. It has little to do with what happened in KH or KH2, just what happened before. Just because KH's bonus video's were about a sequel doesn't mean KH2's is. It said 'birth by sleep' and not 'kingdom hearts 3'. Also, birth by sleep is coming to PSP.

The actual Kingdom Hearts III, well I got my hopes up. The only one of the above games I REALLY want to play is birth by sleep and possibly the days one. I only saw a recap of all cutscenes of Chain of Memories and I understood KH2 fine. The reason I put up with Kingdom Hearts games is because I really really like the story. I totally enjoyed KH and KH2 though, but KH2 was pretty easy and CoM sucked balls.

Let's all hope we get KH3 confirmed as soon as possible and we get to follow the adventures of Sora, Riku and Kairi in another kick-ass console game. (no handheld bullshit)

I wonder where that fish has gone.

My best friend once fainted on me in class, he was sitting next to me and suddenly he was laying on my shoulder so I was like "dude, get the fuck off" and then I noticed he was all fucked up and it scared me shitless.

I ought to try it once though.

At 1/12/08 03:52 AM, q13qew wrote: awesome the shooter game was great

At 1/12/08 04:25 AM, Cyberdevil wrote: Breakpoint twas pretty cool :)

Thanks =D

Hot Fuzz not making the top 10?

Jet - Are you gonna be my girl.

At 12/21/07 07:39 PM, Kuro wrote: WHAT'S THIS?

There's something very wrong.

At 12/18/07 06:45 PM, MetalDart wrote: Offtopic but is your eye better? :)

Pretty much, it's open but the eye itself is still slightly red and area around it purple. Yay

At 12/18/07 06:42 PM, SouthAsian wrote: 30 hours?but your in Europe.When I visited England from America it took me 8 hours.

We're going by bus, which sucks. In total (way to go there and back) we're going to be in the bus longer than in London. Plus I'm not leaving yet. The bus will be leaving exactly 24 hours from now.

At 12/18/07 06:37 PM, BananaBreadMuffin wrote: Have sex with me.

Pick me up at the Globe, or buckingham palace. Whatsever closer to a dark alley for the act :D

At 12/18/07 06:38 PM, Gagsy wrote: Go to a show in the evening for sure.

I wanted to go see Wicked which I've listened to for ages, but still haven't seen the show. It fucks up my departure plans though, I could see half an hour of the show before I'd have to get out of there to catch my bus.