Here are a few pictures that highlight my corporation’s venture into Wormhole space to strike it rich.
Given the shakeup coming with the tiericide effort, Armor tanking, and the sweeping changes coming this summer, I feel comfortable disclosing performance numbers for production and trade involving popular Battlecruisers hulls.
The Drake and Hurricane market has been and continues to be a very competitive market. I contribute this to a few factors.
First there are many industrial people that will not consider the time it takes for them to mine minerals; remember that time is money and the hours that you spend slaving away staring at a rock for a few million an hour could be better spent doing more lucrative activities. Note that this point is not isolated to these hulls and is a common error in production logic for new industrialists.
The PVP and PVE proficiency of the Drake makes it a very popular ship. There will always be a large draw for industry people to focus on this hull, making for high competition.
Lastly, given the time that these two ships have been in the game, many industrialists have these BPOs researched to high levels and have had them for many years.
My production and trade focus shifted off of the Drake and Hurricane when the Tier 3 Battlecruisers were introduced as I saw a high demand for them in the PVP arena.
As you can see the trading performance below, they have proven to be far more profitable on average than their older counterparts.
Make Naga, Oracle, Talos, and Tornado hulls not Drake and Hurricane ones.
The ability to produce order from chaos gives us direction. There is a lot of data out there for the Eve universe; kill reports, market prices, and player content all contain information that we can use.
In order to give my trading ventures some direction, I produced a report out of the large amount of kill report data that is publicly available.
After setting up an instance of EDK, I pulled data from various sources including eve-kill.net, TEST, Goon, and AAA killboards. I then ran some filters on the dataset in order to exclude some cases that don’t contribute to my target PVP environment:
- Ignored duplicate mails when importing (attempt to sanitize the input).
- Ignored ammo as I have found that the ammo trade is very hit-or-miss as far as profits are concerned.
- Filtered to only null and lowsec kills.
- Removed losses that contained NPCs (lols Ratting Ishtar).
My query produced a list of top ships and modules that turnover. Here is a nice list of 154 items you should be trading based on my filters if you want to stock the war chests of PVP players.
10MN Afterburner II 10MN MicroWarpdrive II 1400mm Gallium Cannon 1400mm Howitzer Artillery II 1400mm Prototype Siege Cannon 150mm Light AutoCannon II 200mm AutoCannon II 220mm Vulcan AutoCannon II 425mm AutoCannon II 425mm Compressed Coil Gun I 425mm Medium Prototype Automatic Cannon 425mm Railgun II 720mm Howitzer Artillery II 720mm Prototype Siege Cannon 800mm Heavy Prototype Repeating Siege Cannon 800mm Repeating Artillery II Adaptive Invulnerability Field II Adaptive Nano Plating II Arazu 'Arbalest' Cruise Launcher I Armor EM Hardener II Armor Explosive Hardener II Armor Kinetic Hardener II Armor Thermic Hardener II Ballistic Control System II Basilisk Blackbird Broadsword BZ-5 Neutralizing Spatial Destabilizer ECM Cap Recharger II Capacitor Power Relay II Compulsive Signal Distortion Amplifier I Conjunctive Magnetometric ECCM Scanning Array I Conjunctive Radar ECCM Scanning Array I Co-Processor II Covert Ops Cloaking Device II Curse Cynosural Field Generator I Damage Control II Devoter Drake Dual 180mm AutoCannon II E50 Prototype Energy Vampire ECM - Ion Field Projector II ECM - Multispectral Jammer II ECM - Phase Inverter II ECM - Spatial Destabilizer II EM Ward Amplifier II EM Ward Field II Energized Adaptive Nano Membrane II Enfeebling Phase Inversion ECM I Eris Experimental 10MN Afterburner I Experimental 10MN MicroWarpdrive I Flycatcher FZ-3a Disruptive Spatial Destabilizer ECM 'Gloom' I White Noise ECM Guardian Gyrostabilizer II Heat Sink II Heavy Electrochemical Capacitor Booster I Heavy Electron Blaster II Heavy Ion Blaster II Heavy Missile Launcher II Heavy Pulse Laser II Heavy Unstable Power Fluctuator I Heretic Huginn Hurricane 'Hypnos' Ion Field ECM I Improved Cloaking Device II Interdiction Sphere Launcher I Kinetic Deflection Field II Lachesis Languid Phase Inversion ECM I Large Anti-EM Screen Reinforcer I Large 'Arup' Remote Bulwark Reconstruction Large Core Defense Field Extender I Large F-S9 Regolith Shield Induction Large 'Notos' Explosive Charge I Large 'Regard' Power Projector Large S95a Partial Shield Transporter Large Shield Extender II Large 'Solace' Remote Bulwark Reconstruction Limited 1MN MicroWarpdrive I Low Frequency Sensor Suppressor I Maelstrom Magnetic Field Stabilizer II 'Malkuth' Heavy Missile Launcher I Maller Medium Ancillary Current Router I Medium Anti-EM Screen Reinforcer I Medium Anti-Thermal Screen Reinforcer I Medium 'Arup' Remote Bulwark Reconstruction Medium Azeotropic Ward Salubrity I Medium Capacitor Booster II Medium Capacitor Control Circuit I Medium Core Defense Field Extender I Medium Energy Discharge Elutriation I Medium Energy Locus Coordinator I Medium Energy Neutralizer I Medium Energy Neutralizer II Medium Ionic Field Projector I Medium Particle Dispersion Augmentor I Medium Particle Dispersion Projector I Medium S95a Partial Shield Transporter Medium Shield Extender II Medium Targeting System Subcontroller I Medium Trimark Armor Pump I Medium Unstable Power Fluctuator I Nanofiber Internal Structure II Oneiros Onyx Oracle Phased Muon ECCM Caster I Phobos Power Diagnostic System II Prototype 100MN MicroWarpdrive I Prototype Armor EM Hardener I Prototype Armor Explosive Hardener I Prototype Armor Thermic Hardener I Prototype Cloaking Device I Reactor Control Unit II Remote Sensor Dampener II Rokh Sabre Scimitar Scorpion Sensor Booster I Sensor Booster II Shadow Serpentis Armor EM Hardener Shadow Serpentis Armor Kinetic Hardener Signal Distortion Amplifier II Small Capacitor Booster II Small Core Defense Field Extender I Small Diminishing Power System Drain I Small Nosferatu II Stabber Fleet Issue Standard Missile Launcher II Stasis Webifier II Tachyon Anode Particle Stream I Tachyon Beam Laser II Tempest Thermic Dissipation Field II Tornado Tracking Computer II Tracking Disruptor II Tracking Enhancer II Type-D Attenuation Signal Augmentation 'Umbra' White Noise ECM Warp Disruption Field Generator I Warp Disruptor II Warp Scrambler II Zealot
I’m following the trend that Rixx Javix started and posting my goods. As mainly a trader and researcher, I don’t feel like I have a large fleet of PVP ships as I try to maintain a lean operation. ISK goes back into trading and manufacturing operations instead of sitting as a rusting Minmatar hull in a hangar.
I’ve blanked out the majority of my ship name but I’ll let you know that I name them all after Babylon 5 ship classes.
This character sits in Jita 4-4 and moves and/or ships items around. I think of this guy as the holding account.
(396) Various capital part BPCs left over from copying capital part BPOs for passive income
(293) Various Tech1 BPCs left over when I used to do Invention
(14) Invented Tech2 module BPCs
(5) Invented Anshar (ME -1) BPCs for JF building
Ishtar, Onyx, Phobos, Pilgrim Invented BPCs
(2) Jump Freighter
(5) Iteron Mark V
This character is working with around 290 BPOs worth around 13.59 B. I’ve always wanted to be able to produce anything in the game so I bought up the majority of the common module, frigate, and cruiser prints. The only Battlecruiser prints that I own is a set of the Tier3 ones. I have no intention to ever produce Drakes/Hurricanes due to their small profit margin. I also don’t own any Battleship prints as I like to fly T1/T2 cruiser hulls.
Capital Bittervet Pilot
I’m training this character to fly all four racial Interceptors, Recons, Logistics, and standard BCs. I also have him trained for the standard T2 Alpha Maelstrom because it is such a common request in nullsec fleets.
Test builds are being deployed. I will attempt to keep a master list here so bookmark and refresh this post.
Patch Notes [link]
Patch Size: ~1.04 GB
Game of Drones:
Revamped the Inventory:
– Managing corporation items in a station
– All item management from POS structures done in space on grid
– All Inventory management in space (wrecks, opening other ship locations, etc)
– All Inventory management in stations (items, ships)
– This change does NOT affect the ASSETS window
– LP for kills
– Bunkers are now infrastructure hubs
– LP for all FW actions (capturing complexes, capturing infrastructures hubs, etc)
– New FW front page
– Consequences for capturing systems/regions (benefits for you, grief for your enemy)
– Capturing FW system affect SOV ownership
– Map filters for FW have been revamped
• New missile launchers and launch effects
• New missiles, trails and explosions
• New Stealth Bombers
• Amarr V3
o All sub capital Amarr ships, excluding T3 cruisers.
“14 different skintypes have been added to the Character Creator. This allows all bloodlines to have a wide range of skincolors.
These skintypes replace the previous skintones that allowed players to modify their skincolor a little bit.
A character can keep his/her current skintone, but as soon as a skintype has been applied and the character saved, one of the new skintypes has to be used.
The skintypes can only be applied with full recustomization, that is when you also have the option to resculpt your character, but the plan is to give everyone an optional full recustomization when this goes on TQ.”
• Updated Kill Reports (aka Kill Mails)
• Different war cost
• Corp CEO/Director declares wars, no voting required
• Alliance wars transfer to corps leaving
• No automatic war retraction by aggressor
• Wars last for week by default
• Either side can offer surrender in a war
• The defending side can get allies to help
• There is a place for people to find prospective allies/clients
• Players can now more easily track the war in the War Report
• All corps have publicly viewable war history
• Drone Damage module (Extrinsic Damage Amplifier)
• CPU Rigs (Small/Medium/Large Processor Overclocking Unit)
• Fueled Shield booster (Small/Medium/Large Ancillary Shield Booster), using Cap Boosters as charges
• Light and Medium Web drones
• Resistance shifting armor hardener (Armor Adaptive Hardener)
1. Frigate Rebalance [link]
Tormentor, Punisher, Merlin, Incursus, and Rifter changes.
2. New Modules
From Soundwave’s presentation at Fanfest, it sounded like the following modules are going to be included in Inferno. So far we only have this slide from FanFest and a long forum posts. [44:24]
Micro Jump Drive — Perhaps soon:
Drone Damage module (Extrinsic Damage Amplifier)
CPU Rigs (Small/Medium/Large Processor Overclocking Unit)
Fueled Shield booster (Small/Medium/Large Ancillary Shield Booster), using Cap Boosters as charges
Light and Medium Web drones
Resistance shifting armor hardener (Armor Adaptive Hardener)
3. Missile Effects [link]
Youtube video starting at 3:30.
4. Missile Launchers [link]
For a while, we’ve been talking about global killboards and all the awesome stuff that comes with it (leaderboards, weekly contests etc). Linking killmails in chat to other players means that you’ll effectively have access to that data, making our global killboard project slightly problematic. That, coupled with some security concerns means that we’ll have to withdraw linking killmails ingame.
Just to make it clear, we’re not pulling this feature because we don’t want you linking killmails, we’re pulling it because we have concerns about the impact on our global killboard project and making this massive amount of data available in a more graceful manner in terms of security etc.
6. Unified Inventory UI [devblog]
7. Amarr v3 Ship Updates [preview youtube]
8. Updated Ship Models
[unofficial renders on youtube]
Overview Fading [link] Included in Escalation
10. War Mechanic Updates [devblog]
11. FW Changes [devblog]
Without going into exhaustive detail:
1. Cannot dock in stations that are in systems controlled by an enemy
– Example: Minmatar cannot dock in stations in a FW system controlled by the Amarr/Caldari
– You also cannot use station services if you docked before system flipped
– Ninja Edit: This does not affect neutrals
2. There are 5 levels of discounts for a number of different things – if you own the system and have upgraded it
– Medical clone discounts (from 10% in increments of 10 up to 50% discount)
– Number of assembly lines increases by 1 for every level
– All broker fees discounted (from 10% in increments of 10 up to 50%)
– NOTE: You only get these discounts in the FW system
– ADDENDUM: These discounts apply to neutrals not in FW
3. Militia store LP prices are affected by faction wide performance (discounts in increments of 10%)
– Note that Datacores have been split and moved in FW LP stores
– Pending implementation, LP gain increase for all ways in which LP can be gained in FW – FW Kills, FW Missions, Complexs etc
12. War Costs
1. Drake Rebalance
2. Titan Rebalance
3. Technetium Rebalance
1. Destroyer and Battlecruiser Skill Rebalance
There will be no skill change for Inferno. Your destroyer and battlecruiser skills are safe for now. Battlecruisers will have to wait until we have rebalanced frigates and destroyers to have something clean to compare them with.
CCP Ytterbium link
2. Armor and Shield Rig Rebalance [link]
In conclusion, this is just too much controversial / poorly thought to be a first step to anything, we need to take a step back, breathe, and have a look at the whole passive versus active tanking situation through modules and ships as well as changing rigs before committing to more changes.
CCP Ytterbium link
More Power to the People
The propose of this short guide is to empower a person that has limited or no experience working with the Eve dataset to perform queries and extract useful information.
Eve has two main data sets. The first is the static data that is published by CCP and updated with each expansion. This set contains information that doesn’t change such as stargate coordinates, number of Moons in VFK-IV, type of research agents in the Forge, or the minerals requirements for a Drake.
The other set is the dynamic data, which is exposed through the API. This data contains the types of assets you own, wallet transactions, or kill statics for a particular system — things that change and things that go boom.
More Data, More Problems
With every new release, CCP publishes a Microsoft SQL database backup file of their static data. You can find the most up to date file on the Community Toolkit website.
Along with the database backup, you will find other useful downloads such as images for every item in Eve — very important when trying to create something presentable out of boring database tables if you are designing a 3rd Party application.
Some people do not use Microsoft SQL and opt to run their database with MySQL, the most popular opensource database package. This format is not released by CCP and thus enterprising players routinely convert the data from Microsoft SQL to MySQL format. Nothing is lost, just converted.
Usually a few hours after a new file has been posted on the Community Toolkit site, people have conversions up for download. If you hang out in the Eve Technology Lab sub-forum, people will usually post links once available. I have been getting my releases from this site: http://zofu.no-ip.de/.
Noise. has written an excellent guide on how to install the free version of Microsoft SQL Server and work with CCP’s database backup file in order to get to a point where you can run a database query.
Table Prefix Nomenclature
The naming format of the tables is very intuitive and can be picked up fairly quickly.
|agt||all about agents both mission and research|
|chr||character information such as bloodlines, factions, and races|
|crp||NPC corporation divisions|
|dmg||damage attributes, effects, dogma (attribute system)|
|eve||basic information for icons and units|
|inv||market groups, item details, item reactions. I do a lot of work with these tables|
|map||xyz data, landmarks, regions, solar systems connections, and general universe data|
|planet||planetary interaction schematics|
|ram||industry, manufacturing, refine|
|sta||station services, xyz docking locations|
Tips and Tricks
An item’s typeID is a very important thing to know. This is a unique number that identifies a type of object in Eve.
Keep in mind that referring to a Drake (typeID 24698 in the static dataset) will be different than referring to your Drake (unique itemID 1002615059065 in the API feed). The itemID value is a unique number that identifies every object in Eve (1).
Eve Queries 101
SELECT * FROM [dbo].[invTypes] WHERE typeID = 24698 GO
List all Battlecruisers
SELECT * FROM [dbo].[invTypes] WHERE groupID = 419 GO
Eve Queries 201
PI Schematics are contained in the planetSchematicsTypeMap self referencing table. This means that the build requirements for P0, P1, P2, and P3 are all contained in one table. The isInput column is used to list build requirements when set to 1.
1. Listing all P0 items using the isInput value set to 0.
SELECT planetSchematicsTypeMap.*, invTypes.typeName FROM planetSchematicsTypeMap JOIN invTypes ON (planetSchematicsTypeMap.typeID = invTypes.typeID) WHERE planetSchematicsTypeMap.isInput = 0 AND invTypes.marketGroupID = 1335 ORDER BY invTypes.typeName
2. Listing items that go into Construction Blocks, a P1 with typeID 3828 and schematicID 74.
SELECT planetSchematicsTypeMap.*, invTypes.typeName FROM planetSchematicsTypeMap, invTypes WHERE planetSchematicsTypeMap.typeID = invTypes.typeID AND schematicID = 74 AND isInput = 1
Eve Queries 301
CCP’s dataset does not contain a table with Tech2 build requirements. We have to create a new table that combines information from a number of tables and then work off the new table.
1. Run this pastebin query once to create your new typeBuildReqs table. If successful, you will get a message like this:
(15791 row(s) affected).
2. Find the build requirements for a Cap Recharge II with input typeID of 2033 (Cap Recharge II Blueprint). The NOT IN statement excludes the skills required to build the item.
SELECT typeBuildReqs.*, invTypes.typeID, invTypes.typeName FROM typeBuildReqs JOIN invTypes ON (invTypes.typeID = typeBuildReqs.requiredTypeID) WHERE typeBuildReqs.typeID = 2033 AND invTypes.groupID NOT IN (268,269,270) AND activityID = 1
If you want some more example queries, comment or find me on twitter.
(1) If you remember that old Devblog post about Drake missile lag, one major component to the lag was that every missile fired had to have a unique itemID created and destroyed after it exploded. This database operation ate up a lot of time, which is critical to a simulation trying to play through a battle.
After seeing JonnyPew’s videos on how to fit a bomber and search for bot activity in nullsec, I set on my own journey to see if I could find them action.
His guide shows how to fit a Hound, which I cannot fly. Luckily the fitting differences between racial bombers are not that high so I changed one or two modules and bought up Nemesis fit. The total was around 36 M, which included four bombs and a compliment of torpedoes.
After looking at a few regions on Dotlan, I found a pocket of space that contained a high (inhuman) amount of NPC kills. You can easily see these by filtering for NPC Kills over the past 24 hours and seeing areas where 10,000+ NPC kills occurred.
I set course and flew out of Jita 4-4 towards the unknown, 67 jumps to be exact.
I’ve spent a far amount of time in nullsec, navigating with large fleets and going on solo roams in cloakey ships so I was confident in my ability to dodge bubble camps. I did have to pass through the N-RAEL system, which is a known hotspot as it connects Empire space to the Great Wildlands. I watched the gate and picked a quiet hour to sneak in after seeing a few industrialists go back and forth.
Pretty uneventful until I got into the destination constellation, where the locals were pretty active. The final jump laded me right into a pile of bubbles. It was clear that the locals did not want a lot of traffic to get around easily.
I found a celestial, aligned, cycled the MWD, and cloaked. When I breached the bubbles, I went into warp. I made a few safe spots and refreshed the directional scanner to get a good feeling of what was around me. There was only one Force Field on scanner, a Drake, and a few frigates.
Note: Count the number of towers and force fields listed on the directional scanner. If the count does not match, then a tower is offline and you might be able to see if any goodies were left anchored.
I’ve been hanging around the deep nullsec system for a week now, monitoring activities and taking names. I haven’t pounced on a ratter yet as every time I login, I see a lonely Drake warp to a safe POS and disconnect.