Archive

Posts Tagged ‘Eve Online’

[Eve Online db] query published skills with description, rank and baseprice

August 5th, 2010
56 views No comments
SELECT typeName, invTypes.description, valueFloat AS skillrank, baseprice
FROM invGroups
INNER JOIN invTypes ON invTypes.groupID = invGroups.groupID
INNER JOIN dgmTypeAttributes ON dgmTypeAttributes.typeID =  invTypes.typeID
INNER JOIN dgmAttributeTypes ON dgmAttributeTypes.attributeID = dgmTypeAttributes.attributeID
WHERE invGroups.categoryID = 16
AND dgmTypeAttributes.attributeID = 275
AND dgmAttributeTypes.published = 1
AND valueFloat IS NOT NULL
AND marketGroupID IS NOT NULL
ORDER BY groupName, typeName ASC

Arkie Code and Stuff

[Eve Online] BP Manager (aka BluePrint Manager)

August 1st, 2010
105 views No comments

So today someone from my alliance (Loony toons) contacted me and asked if I could write an application for him to store information about blueprints and who owns it etc. Although the exact requirements were pretty vaque at best, I managed to wrap something up that should be what he was asking for and added some other stuff while i was at it and reused some of my code that i wrote on other eve related projects (EveRoamer anyone?!).

So what works and what not? Well, everything you see on the image below works in the current build, i’ve already written the database design to store and retrieve the infomation about blueprints/owner etc but i couldn’t be bothered anymore today to write the data handling part so that will be the first thing what i’ll do.

So you might have already guessed what doesn’t work.. adding the “submit” and “search” functionally doesn’t work yet but will be done later when I have the time for it :o )

If you have any suggetions/comments or features that you would like to see in BPManager, leave a comment below :)

http://retardedweblogger.com/blog/wp-content/uploads/2010/08/BPManager_2010_08_02.png

[Update] WIP screenshots

http://retardedweblogger.com/blog/wp-content/uploads/2010/08/BPManager_2010_08_03.png

http://retardedweblogger.com/blog/wp-content/uploads/2010/08/BPManager_2010_08_04.png

Arkie Code and Stuff ,

Eve online pos bash livestream!

July 10th, 2010
56 views No comments

Watch a random livestream about some guys that are bashing a pos.
mms://96.231.51.225:6666/

Arkie Everything else

Watch the Eve Online Alliance Tournament VIII in HD quality

June 6th, 2010
202 views No comments

The EVE Online Alliance Tournament is the ultimate battlefield in which the top pilots in EVE Online fight for the glory and honour of their alliance. 64 Alliances compete over 3 weekends of intense, explosive action.

Dates & Times
June 5th & 6th – Qualifying Round 1
June 12th & 13th – Qualifying Round 2
June 19th & 20th – Finals

All days run from 1500 GMT/UTC until 2100 GMT/UTC

Watch the Eve Online Alliance Tournament VIII in HD quality here: http://www.eveonline.com/events/alliances/tournament/t8/viewerHD.asp

For more info about the alliance tournament, visit this link.

Match Schedule – Alliance Tournament VIII – Round 1

Winners are shown in YELLOW and BOLD

Saturday 5th June
15:00 Against ALL Authorities v Perihelion Alliance Video Report
15:20 Agony Empire v HYDRA RELOADED Video Report
15:40 Arbeitaholics Anonymous v Get Off My Lawn Video Report
16:00 Atlas Alliance v Intrepid Crossing Video Report
16:20 B A N E v Unaffiliated Video Report
16:40 Beyond Virginity v Majesta Empire Video Report
17:00 BricK sQuAD. v Panda Team Video Report
17:20 Circle-Of-Two v Indecisive Certainty Video Report
Break
18:20 Cry Havoc. v Plutonix Video Report
18:40 Curatores Veritatis Alliance v DarkSide. Video Report
19:00 Dead Terrorists v Pandemic Legion Video Report
19:20 death from above.. v Noir. Mercenary Group Video Report
19:40 Dystopia Alliance v Morsus Mihi Video Report
20:00 Electric Monkey Overlords v Leguinea Romana Video Report
20:20 Electus Matari v Veni Vidi Vici Video Report
20:40 Erebus Alliance v RED.OVERLORD Video Report
Sunday 6th June
15:00 Eve Engineering v R.A.G.E Video Report
15:20 Honourable Templum of Alcedonia v WE FORM VOLTRON Video Report
15:40 HUN Reloaded v The Tusker Bastards Video Report
16:00 Huzzah Federation v THE R0NIN Video Report
16:20 Important Internet Spaceship League v Monks of War. Video Report
16:40 Interstellar Alcohol Conglomerate v The Wrong Alliance Video Report
17:00 Ivy League v SOLAR FLEET Video Report
17:20 Manifest Destiny. v RAZOR Alliance Video Report
Break
18:20 Mos Vape Heavy Industries v Paisti Syndicate Video Report
18:40 Negative Ten. v Soldiers of Thunderstorm Video Report
19:00 Old Intentions v Ushra’Khan Video Report
19:20 OWN Alliance v The G0dfathers Video Report
19:40 Pitch Black Legion v The Kadeshi Video Report
20:00 Rote Kapelle v Silver Twilight Enterprises Video Report
20:20 Snatch Victory v THE SPACE P0LICE Video Report
20:40 T o r m e n t u m v The Star Fraction Video Report

Arkie Everything else ,

Amarr Control Tower pwning stealthbomber gang

May 23rd, 2010
93 views No comments

Eve online in 3D?

May 23rd, 2010
112 views No comments

Check this image out that a corpmate showed me, Eve Online in 3D. I wonder how it looks like with 3d glasses because without it, it looks pretty crap.

http://img12.imageshack.us/img12/2246/3deve.png

Arkie Everything else ,

NC Best Friends Forever

May 20th, 2010
90 views No comments

Atlas leaving the north after the fight in H-W9TY

May 17th, 2010
162 views No comments

So i got this mail from an alliance member quoting  Bobby Atlas:

“The whole idea of logging capitals off in H-W was a ludicrously stupid plan, it was one I was vocal about not doing and my biggest regret in this whole situation is failing to do what I have done for the past 3 years — telling others to go fuck themselves and issuing my own orders in the best interest of ATLAS. I was trying to be a team player and it bit us in the ass — I will not make that same mistake again. I have no problem working with allies but at the end of the day, never will I allow us again to be subordinate to other peoples plans. You take what ATLAS offers you or you can suck our collective dicks.”

The good thing is that Atlas has withdrawn from the war but the main fight is still far from over. I bet IT will continue their skirmishes and try to harrass our alliances home systems although in the end we will kill them like we did to Atlas.

Arkie Everything else ,

Death star

May 15th, 2010
120 views No comments

This is veldspar!?

May 13th, 2010
286 views No comments

This is veldspar!?

http://cailais.files.wordpress.com/2010/04/veldspar.jpg

Arkie Everything else

Battle Summary for H-W9TY, 2010-05-13 10:08 – 14:19

May 13th, 2010
154 views No comments

http://apexwebgaming.com/large_reviews/eveonline/logo.jpg
The Northern Coalition [NC] is kicking the Southern Coalition’s [SC] ass! Check out the battle summary below and see for yourself.

http://acmekb.infinitecovenant.com/?a=kill_related&kll_id=16562

Arkie Everything else , ,

Eve Online: IT Alliance vs. Goons L-1S disco!

May 1st, 2010
166 views No comments

STFU in local!

April 29th, 2010
99 views No comments

Eve online hauler spawn 0.0

April 28th, 2010
150 views No comments

First time I ever got a hauler spawn containing this much trit in 0.0 space!
nice_shit2

Arkie Everything else

Another ship bites the dust.

April 9th, 2010
249 views No comments

http://farm1.static.flickr.com/111/282849913_6e1b62a975.jpg

In this case, the Atlas aliance got raped big time. Check out their killboard and check what they lost.. O_0
http://www.atlas-alliance.com/killboard/index.php?a=kill_related&kll_id=162572 or http://eve-kill.net/?a=kill_related&kll_id=6286545

Arkie Everything else ,