We have a winner! According to this Chribba dice, the winner is Euclid Motorhead!
The runner ups were Growler Dude and The Chrysi.
Thank you to everyone who participated, and best of luck next time!
Prizes have been contracted to the winners and are ready to be claimed. Enjoy!
In November 2013 CCP has allowed high sec NPC Customs Offices owned by Interbus to be destroyed and then replaced with player owned ones. Previously only low-sec Customs Offices were vulnerable. Of course having POCOs makes a very nice passive source of ISK (you don't have to do anything, apart from an occassional call to arms to defend them). But have you ever wondered how much you earn through your POCO network or who is using them?
In a previous update of LMeve I have added the ability to visualize which POCOs earn the most ISK, and in this iteration I continue the trend to show even more details. You can now choose a specific POCO and see a Details page for it. This page shows how much this specific Customs Office earned in the last 30 days - counting between 30 days ago and today, income in the last calendar month, and in the current one, so you can see trends).
What's another new thing is the list of your customers. Corp Wallet Journal entries for planetary taxes show the client's name and planets ID, so by running an aggregate query on that you can see:
- who is using a specific POCO
- how often they use it
- how much they pay in taxes (so you can approach them and offer a discount in exchange for let's say blue status)
Note: due to this information being obtained from corp Wallet Journal, it won't show characters who have 0% tax rate, as these people will only pay the NPC tax, and no taxes to your corp at all (so no records are added to corporation Wallet Journal).
If you have ideas for more features in LMeve, please feel free to contact me. The best way is to raise an Issue on project's Github page: https://github.com/roxlukas/lmeve. Choose an appropriate category (bug fix, enhacement or question) and write down what you need, or what needs fixing. I can't guarantee that all requests will result in that feature being added to LMeve, but if the feature looks useful, won't take forever to code and most importantly, the information required to make it is in the EVE API, it has a high chance of being included in one of the future releases.
Just one more thing. Ashterothi, ex-member of Aideron Robotics and well-known host of podcasts such as High Drag and Hydrostatic Podcast, has recently created a Slack team for Tweetfleet. Slack is generally a communications platform aimed at companies, but it has a very nice real time chat (plus a dedicated app for iOS & Android). It is very useful, and a dedicated #devfleet channel also exists, so feel free to drop by and chat with fellow players, CCP devs and third party devs. It's really fun!
To get invited, simply head to https://www.aideronrobotics.com/tweetfleet/ and fill in the form.
Yesterday during fourth episode of the "o7" show, CCP was giving away 30 codes for Megathron Quafe Edition skin (the same one that I've drawn using Rixx Javix hints).
I have just realized I won one of those codes!
But I think one of you, my dear space friends, will put it to better use than I would, so I'm giving it away!
To enter the raffle, simply comment under this post until 23:59, January 22th. Winner will be chosen randomly next Friday, Jan 23. Make sure to include your in-game name, so I can contact you regarding the prize.
Giveaway prize list so far
|1.||1x Megathron Quafe Edition Blueprint Copy (1 run)|
4x Quafe Zero
P.S. Tech I Megathron is not included - you will need one to apply the skin to.
P.S.2. A little change of plans. I won't be available this weekend, so I'm shortening the giveaway so the winner will be announced on Friday.
Just as promised in the previous LMeve dev blog, I have recently added the ability to track income from individual planets. Moreover, with the new percentage bars, you will know what are your best planets simply by looking at the table. To check how much a specific planet earned you in the last 30 days, simply hover your mouse above that planet's name to see a tooltip with the exact number.
But this is not the only thing added in this release. Some pages require crunching a lot of data, which means they render rather slowly. Most of this data doesn't change very often, so it seems to be a good idea to generate them once, and then save a cached copy. Then every time users come back to this page, a cached version is displayed, saving everyones time.
One of the pages, the Profit Chart can have several hundred records, which need their manufacturing and invention prices calculated, and it can load for as long as few minutes (depending on individual configuration of course). I used a different approach here: a lazy loader. Instead of one big 2 minute request, I display the page immediately, and as user is scrolling, more data is being loaded into the table in packs of 10 rows.
How to link POCOs with planets & income?
It's not trivial, but far from impossible. Let's have a look at columns returned by the /corp/CustomsOffices.xml.aspx API:
<row itemID="101296791423" solarSystemID="30004295" solarSystemName="Keba" reinforceHour="19" allowAlliance="True" allowStandings="True" standingLevel="-10" taxRateAlliance="0" taxRateCorp="0" taxRateStandingHigh="0" taxRateStandingGood="0.05" taxRateStandingNeutral="0.07" taxRateStandingBad="0.1" taxRateStandingHorrible="0.15" />
There is POCO itemID, which stays the same in all API endpoints, there is solarSystemID and system name. And of course the tax settings. But there is nothing about planet itemID here. Maybe /corp/Locations.xml.aspx endpoint will reveal a bit more?
<row itemID="101296791423" itemName="Customs Office (Keba I)" x="58598019193.2515" y="-5937030740.62145" z="-3890977687.95432" />
Okay, so now we have x, y, z coordinates, and POCOs name. In the first version of POCO management screen I simply cut planet name out of this using a regular expression. But to link it with other data we still need the planet itemID. How do we find it? Well, POCO is orbiting a planet, right? And we have cooridnates of all planets in the Static Data Export database - in the mapDenormalize table. What are we waiting for?
CREATE FUNCTION `findNearest`(`x1` DOUBLE, `y1` DOUBLE, `z1` DOUBLE, `solarSystemID1` INT) RETURNS int(11) READS SQL DATA RETURN ( SELECT a.itemID FROM (SELECT SQRT(POW(x1-x,2)+POW(y1-y,2)+POW(z1-z,2)) AS dist,itemID FROM mapDenormalize WHERE `solarSystemID`=solarSystemID1 ORDER BY dist ASC LIMIT 1) a ) 40271955
Bingo! The function returns the closest solar body, in this case, itemID of the planet. We just have to JOIN two other tables from SDE: invNames to convert the planet ID we just got into planet name, Keba I, and invItems to find it's typeID (Temperate, Barren, Oceanic, etc.).
Ok, now on to income for this specific POCO. For this, we will need /corp/WalletJournal.xml.aspx endpoint, which contains all the transactions of a corp. The records we are looking for will have refTypeID equal to 96 and 97 (import/export taxes) and the planet itemID will be in argID1 field. Once all joins are in place, we simply have to filter last thirty days and SUM all the amount values.
As usual, the current LMeve version can be downloaded from https://github.com/roxlukas/lmeve
Last thursday CCP Guard and CCP Mimic hosted episode #3 of the o7 show (which, mind you, is quite amazing and you should definitely check it out), and during that show CCP Seagull told us the name of the January expansion, the Proteus. The guys responsible for the Community website have already prepared a page for the upcoming release, and it's available here:
Now back to Caroline's Star. Did you notice the thing in the top left corner, just under words "Proteus 13 Jan"?
Every supernova leaves a nebula after the explosion. It contains the remains of the exploded star, mostly made of elements heavier than Helium, which were fused during the stellar collapse and subsequent explosion. Mind you, most of the atoms in our very bodies came from a supernova. Anyway, as you can clearly see on the picture, Carolines' Star, despite its superluminal effects, behaves just like a typical nova: it creates a new nebula.
Updated on Dec 19th:
As it turns out, the background on Proteus website is refreshed every day, so it shows how the nebula looks like in game, in real time.
Almost everyone knows the "Caroline's star"* by now. It's this bright new star, with a vertical streak, that is visible from every corner of New Eden.
* the screenshot of the new star was first published on Twitter by Caroline Grace. Both CCP and players quickly adopted "Caroline's star" as the name for this phenomenon.
But there is more to it than just a few pixels on the sky. It seems that the recent supernova in Jovian space has destroyed almost all stargates in the following regions: A821-A, J7HZ-F and UUA-F4.
Data mining only confirms these findings. When you queried EVE SDE database for Phoebe for jumps between systems in Jove space, you would get 546 jump connections:
SELECT COUNT(*) FROM `eve_pho100_dbo`.`mapSolarSystemJumps` WHERE `fromRegionID` IN ( 10000004, 10000017, 10000019 )
But now, when you open your map in game and set all jump lines to be shown, you will notice there is no jump connections in Jove space anymore! Also please notice how the epicenter pinpointed by
NPCs players in this ingame news item happens to be exactly in the middle of the cleared area.
Querying Rhea Static Data Export only confirms this:
SELECT COUNT(*) FROM `eve_rhe100_dbo`.`mapSolarSystemJumps` WHERE `fromRegionID` IN ( 10000004, 10000017, 10000019 )
Warning: wild speculation follows
This answers the question why CCP has removed Jovian graphical assets from the game earlier this year. There are no Jovians left. I am probably safe to say that by now all the Jove are gone!
This also let's me believe that the whole "Stargate Building" thing shown by CCP Seagull during the last Fanfest will most likely happen in the post-Jovian regions of space. Of course nothing has been confirmed byt the CCP yet.
@Fuzzysteve (Steve Ronuken, member of CSM #9 and the guy behind the most popular SDE-to-MySQL and SQLite conversions) has surprised the community today with a very nice simple website:
— Fuzzysteve (@Fuzzysteve) November 18, 2014
What does it do? You've guessed it, it's a simple wiki-like vocabulary for EVE Online. Everyone is welcome to add new definitions to it. How do you log on? Simple: Eve Lexicon is using EVE SSO, so go on, log in using your EVE Online credentials, and add some definitions!
The site is written in PHP with a tiny bit of JQuery to make it pretty. EVE SSO integrations are now possible thanks to the new Third Party Developers Portal. A sample SSO library for developers (also by @Fuzzysteve) is available at github.com.
About two years ago I've written a post about iOS and Android apps for EVE Online, but I didn't have any Windows Phone device at the time, so I had to skip this fledgling platform. Said post has become very popular and is one of my top post to the date. Few months ago I've become owner of Nokia Lumia running Windows Phone 8.1, so I am now able to test EVE apps on Windows Phone. Enjoy!
Windows Phone 8 apps
EVE Mail is in-game mail client. Entering API Key is straightforward - simply press the plus sign on the first page. Once you've done that, your characters will appear on the front page. Each toon has their own set of mailboxes including "Inbox" (all mail), "Personal" (character mail), "Corporation" (corp mail) and "Alliance" (as name says). You also see your "Mail lists" and "Sent" which holds all messages you've sent. XML EVE API does not let messages to be sent from device, so this app is of course read-only.
Unfortunately the app does not have a Live Tile, which would utilize one of the most powerful features of Windows Phone. There is also no notifications when new mail arrives - you have to open the app to manually refresh the mails.
All in all, the app is still useful, because it gets the job done.
This is an ultra simple reference app. Looking for a Mercenary? Download this app and you'll know who to talk to. Information is divided by space type (high sec, low sec, null and wh space).
While the app does contain some potentially useful information, it is very poorly designed. Readibility and formatting is well below acceptable level. There is not even an "About" screen, so I had to go back to Windows Store to find out who to blame. Sorry Team R Helix, I am no Windows Phone dev, but I can make a better looking app in under an hour.
Eve Mining Monitor
Now something well designed for a change (and quite useful, too). This is another reference app, this time for miners. It does exactly the same thing as LMeve Ore Chart: shows the ISK value per cubic meter of every ore and every ice in game. However, you have to make sure to update the prices before using the app, or the Ore chart will be inaccurate. Go to Settings and choose either Region or Trade Hub prices and then hit refresh. Good job, Vagus Malakhov!
Another reference app, this time for market traders (but let's face it, everyone needs a Jita price check now and then). There is two lookup modes:
- Quick - simply enter item name and system - app will try to guess what you mean and will provide a quick drop down list with most relevant choices
- Search - enter item name, choose region (and optionally system)
What I find useful about this app is that you can save your favourite searches on the "Favorites" page - so there is no need to enter item and system names every time.
All price data comes from eve-central.com.
First character tracker for Windows Phone in this test. It is very simple, but gets the job done.
- "Details" page shows characater name and portrait, amount of ISK, character attributes and clone data. Note: no numer formatting on the ISK field. Can't see if I have 3 billion ISK or three hundred million.
- "Now Training" page shows information and progress bar for the skill currently in training. You can add a reminder when the skill is trained.
- "Queue" page shows the current skill queue. Note: on the small screen of my Lumia, the font used for the skill list seems a little too big.
- "Skills" page shows all the skills currently trained by the character.
- "Certificates" page currently shows nothing (bug?)
Another character progress tracker. This one allows one more thing, compared to EVEision: it shows market transactions. Unfortunately (again) has problems with number formatting. While ISK amounts look fine, training times are shown in a weird format: D.H:mm:ss
It does however support Start Tiles (not Live Tiles though, but still, it's better than no tiles support whatsoever). You can pin any of your characters to the start menu. Tapping the tile brings up EveLet showing this specific character. Neat!
- Summary - shows corp, ship, ISK and SP amounts, Skill Queue and Market Transaction summary
- Queue - shows current skill queue
- Transactions - shows the list of last market transactions
- Orders - shows the list of current market orders
Yup, it's the same EVEMON you know from the "big" Windows and it's been developed by the same team of people.
Unfortunately... it does not work After entring API key it complains about the format of the Characters.xml.aspx endpoint, so it probably requires some compatibility work. I will review it again when (and if) it is properly updated.
One more character tracker. And I must say I'm impressed, because it is very well designed. It looks both like a native Windows Phone app (puts emphasis on fonts, font sizes and minimalistic design), and an EVE Online themed app. Menu slides in from the left and looks similar to NEOCOM strip in game. Very good design, Mr Jeremy Shore!
Regarding features it is rather limited when compared to the other character trackers. It offers the following:
Character Summary page: corporation, when joined, security status, active ship
Eve Mail page - a very neat mail reader
Skills page - I was unable to load all the skills Lukas has
Unfortunately it is less stable than the other apps and crashed to start menu a few times. Maybe it is just my budget Lumia. I hope Jeremy updates his app soon, because it looks really great.
Probably the best character tracker for Windows Phone so far, it is both stable, good looking and has quite some features. Don't let that home brew icon fool you. After entering the API key, main menu is shown and it consist of:
- pilot list
- eve-news (several sources news reader, including eve news 24, tmc and official eve online feeds)
After choosing on of the characters, several pages worth of information are shown:
- sheet - shows security status, currently piloted ship and location, ISK balance, SP amount, Clone grade, date of character creation and attributes
- queue - shows skill queue
- skills - displays currently trained skills. Note: it's the only app that has skills grouped like in game
- notifications - like name says
And it supports Live Tiles on the start menu! I really recommend this app. Good job, 3rd Rock Studios!
Another ultra simple reference app. Remember when everyone had damage dealt/weakness for all factions in their bio? Well, this is it.
This app is a ship database. It takes a while to load, but is packed with information, and can even display some of the ships in 3D. It looks very much like a show info window and contains the same st of information (ship stats, description, ship image). If you can't live without spinning ships on the go, this app is for you.
Have you ever heard of Rixx Javix? I bet you have. Well, our famous blogger friend from Eveoganda has recently started drawing EVE Online ships in Adobe Illustrator in order to create high quality posters that you can then print out on A0 and put on your wall, so everyone knows that internet spaceships are your hobby. I really recommend you take some time, and have a look at his work here: Art Print Poster Series.
The series looks great, each ship is positioned in a way that presents it best, and is meticulously detailed, so even after printing at a very high resolution, it still looks amazing. I guessed the method Rixx used to create these (he later confirmed it on his blog), and - being inspired with his work - took my own attempt at recreating one of the most iconic ships in EVE - The Megathron - in a vector drawing. But it's not just any Megathron - it's Megathron Quafe Edition.
Rixx is using Adobe software to make his series, namely Illustrator and Photoshop. I have chosen to use open source software instead, so my poster was made with The GIMP and Inkscape. Both me and Rixx used The Amber's excellent ship viewer known as "Jeremy" at http://caldariprimeponyclub.com/ for reference.
Feel free to download the vector SVG version here.