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
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 
)
If you have any suggetions/comments or features that you would like to see in BPManager, leave a comment below 
[Update] WIP screenshots
Arkie Code and Stuff BP Manager, Eve Online
Watch a random livestream about some guys that are bashing a pos.
mms://96.231.51.225:6666/
Arkie Everything else Eve Online
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 Alliance Tournament VIII, Eve Online
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.
Arkie Everything else 3D, Eve Online
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 Atlas, Eve Online
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, Northern Coalition, Southern Coalition
First time I ever got a hauler spawn containing this much trit in 0.0 space!
Arkie Everything else Eve Online
