Archive

Archive for November, 2009

Eve online dominion SQL dump

November 29th, 2009
652 views No comments

Limit function in MSSQL 2000

November 28th, 2009
310 views No comments

Since there is no real limit functionality in MSSQL 2000 , getting a selection of records can be somewhat difficult. Well, here’s a solution to get a number of records that works like the “limit” function that can be found in MsSQL

SELECT col FROM (
   SELECT top 50 * FROM (
      SELECT top 200 * FROM tbl1
      WHERE col > 1 ) ORDER BY col
   ) AS newtbl1 ORDER BY coldesc
) AS newtbl2 ORDER BY col ASC

Note that there is a similiar limit function in MSSQL 2k5 called “rownumber” which makes returning the desired results a lot easier. ;/

Arkie Code and Stuff , , , , , ,

We must find and we must destroy the cock!?

November 28th, 2009
185 views No comments

Burger in a can

November 28th, 2009
184 views No comments

No matter how good it looks, I bet it tastes like shit. Anyone tried?

Arkie Everything else

Eve online dominion features page

November 28th, 2009
151 views No comments

Dominion, the latest free expansion for eve online will be out in december 1st. Check out the changes here: http://www.eveonline.com/dominion/features.html

Arkie Everything else , ,

Flash quake

November 27th, 2009
146 views No comments
Quake Flash, Enjoy!

Arkie Everything else ,

8-bit trip

November 26th, 2009
153 views No comments

1500 hours of moving legobricks and take photos of them.

Arkie Everything else

Eve-Online – Hotdropped by Stealth Bombers

November 25th, 2009
197 views No comments

Yup, that hurts. A gang of stealth bombers is nothing to laugh af.

That said, i bought a purifier today to play with and will post the fitting later. My purifier does around 1k damage but the ~10sec rof kills the dps so I guess I need to skill some missile skills to do either more damage or improve rof..

Arkie Everything else

NDS cosplay, can you spot him?

November 23rd, 2009
179 views No comments

If you can spot the NDS cosplay guy you can give yourself a cookie.

Arkie Everything else

Idiot vs Lightning, lightning 1-0

November 23rd, 2009
144 views No comments

I bet that was shocking.

Arkie Everything else

Fox Ranger

November 22nd, 2009
128 views No comments

This is a game that I played years ago on my 486 DX-2 66mhz which i still have fond memories of. Oh boy I sure miss the good old days.

Fox Ranger is a side scrolling space shooter where you gotta survive and blow up bosses. Made in 1992, this DOS Shareware game is pretty good and will keep you interested for a day or two. This game was played on DOSBox 0.72 which can be retrieved for free.
You can download the game (for free) as well as read an awesome review here: http://www.abandonia.com/en/games/703…

GAMEPLAY starts at 3:37!!!

Anyway, in this video I go on HARD mode but EASY for shield and on my way to beat the game I ace level 1 and 4 (100% kills) and die on the same frame as level 6’s boss. I then show that you can still die while the bosses just blow up in their animation sequence. I had a very nice “white” invincibility mark during the last ’stage clear’ sequence, heh.

Level 1 is easy, boss also easy. I pick up the yellow thing and fire cobra as well as the lasers. Fire Cobra is a linear 5-fireball shooting weapon BUT eliminates enemy fire which is the best. Searching Missles, Shadow Missiles, Sweeper and FireBall are not seen (except for Sweeper for a second at the last stage).
Level 2 is an attempt to survive because from there the game becomes insanely hard and you have a lot to avoid. Boss is a wimp.
Level 3 shows Fire Cobra and why you need it. Boss can be beaten in 3 cycles.
Level 4 also easy, boss is toughy and I lose the shield by getting hit for no reason.
Level 5 is HARDEST because you cant see shit and the boss can own you if you don’t have fire cobra with you (I still got hit hard).
Level 6 is easy, but the boss has an instant kill attack (the missle), or so I remember.

Music of the game is awesome (except for levels 4 and 5) and I even showed the main menu’s music at the end of the video. Intro for the game and epilouge as well as the greatest song in the game (credits) are also given.

I may make another video showing me beat bosses much faster.

End of the day: RECOMMENDED to play for 1-2 days, to pass the time.

Enjoy!

Arkie Everything else

Ultimate Freefight fail…

November 22nd, 2009
129 views No comments

If one knockout doesn’t cut it, why not both?

Arkie Everything else

Retarded keeper

November 22nd, 2009
150 views No comments

Nuff said.

Want more? Alright, here’s one more..

Arkie Everything else

Cod:MW2 Speed run *SPOILERS*

November 22nd, 2009
272 views No comments

Watch at your own risk, a speed run video of COD:MW2 with a bit of a spoiler.

Arkie Everything else

Eve online drone user guide

November 22nd, 2009
488 views No comments