Pages: [1] 2 3 4 |
1. SDE Conversion for Citadel - in EVE Technology Lab [original thread]
As usual... love your work mate :)
- by KnifeOrSpoon - at 2016.04.28 06:11:03
|
2. Killmail database dump - in EVE Technology Lab [original thread]
I've been indexing kills from that zKill killID/Hash dump, and also anything related to War Declarations. I should have a process in place shortly to export this information into .sql files for predetermined time periods.
- by KnifeOrSpoon - at 2016.02.28 01:27:55
|
3. SDE and Ore Distribution - in EVE Technology Lab [original thread]
The SDE doesn't have this sort of information... however. https://wiki.eveonline.com/en/wiki/Locations_of_ore_and_ice_in_space
- by KnifeOrSpoon - at 2014.10.07 08:38:00
|
4. RAM Activities and Outposts in the SDE? - in EVE Technology Lab [original thread]
Althalus Stenory wrote: You have a flag "conquerable" in staStationType table to flag conquerable stations. Then you can join both ramAssemblyLineStations and this table to get all lines from conquerable station Just for funsies I thought ...
- by KnifeOrSpoon - at 2014.10.06 09:33:00
|
5. Yapeal PHP API library (revision 1207 branches/keys/) - in EVE Technology Lab [original thread]
Delicious! Thanks mate, my own implementation is a little dodgy for a hack of your work. I'd much prefer to have your own implementation instead of my rusty nail in the baseball bat.
- by KnifeOrSpoon - at 2014.07.23 09:04:00
|
6. Cirus SDE - Can we get this now? - in EVE Technology Lab [original thread]
Have a gander at this http://dl.eve-files.com/media/1406/Cruis_-_Industry_Extrapolation_30JUN14_SISI.zip invBlueprintTypes updated with the new maxProduction values, and an extrapolation for ramTypeRequirements for all ActivityIDs including: S...
- by KnifeOrSpoon - at 2014.06.30 12:12:00
|
7. Sticky:Dev blog: Coming in Crius - in EVE Information Portal [original thread]
Delicious. Spent the day on SISI taking a look around... was impressed with the changes to slots (i.e removal), build times considerably reduced (if the following figures are accurate that is). Ballistic Control System II Copying - 20 x max run ...
- by KnifeOrSpoon - at 2014.06.28 12:20:00
|
8. Corp Website Setup - in EVE Technology Lab [original thread]
I'm working on the Joomla side of things... unfortunately it is quite a time competitive development (what with RL work, a major EVE project website in local development stages, and a burning need to sleep and eat). I have a bunch of Joomla compo...
- by KnifeOrSpoon - at 2014.06.01 00:30:00
|
9. YAPEAL - Adding Planetary Interaction endpoints in????? - in EVE Technology Lab [original thread]
Hi all, I thought I might have a crack at adding the API endpoints for PI into YAPEAL however it seems I have hit a brick wall for all bar 1 of them. Has anyone else had a successful crack at integrating: /char/PlanetaryLinks /char/PlanetaryPin...
- by KnifeOrSpoon - at 2014.05.03 12:16:00
|
10. Is there a database of what items are dropped by NPC's? - in EVE Technology Lab [original thread]
It could be because there is not predictable mechanic like this. I've had some weirdly expensive stuff drop from seemingly random rats in belts before, and then nothing but crap drop from what you would think should drop something neat. I could b...
- by KnifeOrSpoon - at 2014.04.30 07:27:00
|
11. Help finding effects of skill level on attribute - in EVE Technology Lab [original thread]
Hey all, I just had a read of this and recalled a few new SQL databases I created a few weeks ago from Rubicon SDE. I've seperated out the Attributes and AttributeTypes tables into skill, module, structure specfics so these table names will be od...
- by KnifeOrSpoon - at 2014.04.25 09:44:00
|
12. Wanted: Central Contract Scraping Resource - in EVE Technology Lab [original thread]
I'm not too sure if there has been a player built tool like this before either. Sounds like something one could put together fairly easily, and could even have an API built to serve those who want to scrape the database too. I'll look into it :D
- by KnifeOrSpoon - at 2014.04.25 08:36:00
|
13. derpina has a question - in EVE Technology Lab [original thread]
Alright, so I have had a little play with this, and it seems there is a way to do what you are looking for. I did this one in PHP, because it's the development environment I have available to me at the moment, and given the wealth of data on the ...
- by KnifeOrSpoon - at 2014.04.03 23:39:00
|
14. derpina has a question - in EVE Technology Lab [original thread]
My guess is just from looking at the paste bin code ( http://pastebin.com/EAujc3ab ) that you would change the URL in there to this: http://public-crest.eveonline.com/market/10000002/types/34/history/ EDIT AGAIN: How are you trying to view ...
- by KnifeOrSpoon - at 2014.04.03 20:46:00
|
15. Some way to obtain a sample of daily kills? - in EVE Technology Lab [original thread]
Nhanderu Mbaekuaa wrote: Some products seem to be finals according the table invTypeMaterials but not according the Evelopedia. For instane, "Construction Blocks", aka typeID=3828, is not in invTypeMaterials. I guess here I need some of the UN...
- by KnifeOrSpoon - at 2014.04.02 22:43:00
|
16. Some way to obtain a sample of daily kills? - in EVE Technology Lab [original thread]
Nhanderu Mbaekuaa wrote: invTypeMaterials table seems all I need to run the decomposition. To a degree yes. There is also a ramTypeRequirements table which has a bunch of material requirements too. To get an SQL query to handle any bluepri...
- by KnifeOrSpoon - at 2014.04.02 03:30:00
|
17. Eve marketdata question - in EVE Technology Lab [original thread]
Vartan Sarkisian wrote: 5/600 = 500 to 600 :D ahhh right, I have Pre Calculus Maths in my brain still.... I interpreted that as 5 out of 600.
- by KnifeOrSpoon - at 2014.03.31 20:25:00
|
18. Some way to obtain a sample of daily kills? - in EVE Technology Lab [original thread]
Steve Ronuken wrote: take a look at the zkill api Steve, I have to say a big THANK YOU mate. Your blogs and Data Dump SQL posts have saved not only a crap load of time, but prevented me from going crazy with relational databases.
- by KnifeOrSpoon - at 2014.03.31 20:24:00
|
19. Some way to obtain a sample of daily kills? - in EVE Technology Lab [original thread]
As Steve said, leverage the kill mails from zKill. To decompose into raw materials is a trickier function. Depending on whether or not the item destroyed was buildable from a blueprint you need to determine what the ideal Material Efficiency of s...
- by KnifeOrSpoon - at 2014.03.31 20:22:00
|
20. Eve marketdata question - in EVE Technology Lab [original thread]
There are well and truly more than 5 ship types in EVE. The market tree for ships is actually quite deep, because it drills down into the ships by Race (Cald, Amarr, Min, Gall) and some case Faction ships, and special editions. For example (and I...
- by KnifeOrSpoon - at 2014.03.31 20:15:00
|
Pages: [1] 2 3 4 |
First page | Previous page | Next page | Last page |