Pages: [1] 2 3 4 5 |
1. material requirements for Procurer - in EVE Technology Lab [original thread]
The problem is that you are only retrieving the "Raw Material" requirements (those that suffer waste). You need to retrieve the "Extra Materials" as well (those that do not suffer waste). For a long time, T1 manufacturing didn't feature Extra Mate...
- by Matthew - at 2012.12.04 19:45:00
|
2. DB Dump Tech III BP materials - in EVE Technology Lab [original thread]
ramTypeRequirements is the table you want, but it is referenced on the blueprint TypeID, not the product. So for your product of typeID 30125, you can go through invBlueprintTypes (productTypeID=30125) to find the corresponding blueprint is bluep...
- by Matthew - at 2012.05.08 22:00:00
|
3. Wallet Journal and Incursion Bounty Surcharge - in EVE Technology Lab [original thread]
I can't remember how off-hand, but I remember I found a "trading with yourself" case where even refTypeID was not a sufficient dis-ambiguator. The only way I could tell which side of the "Journal Transaction" was which was that the "amount" in one...
- by Matthew - at 2011.10.04 12:01:00
|
4. Please help with SQL query, merging rows - in EVE Technology Lab [original thread]
Originally by: Zeta Zhul 3. MSSQL has 'hierarchialid' and might have some new addition for hierarchial queries. Otherwise you're doing the recursive stored procedure thing. If you want to do recursive queries on MSSQL, you could also l...
- by Matthew - at 2011.06.12 11:55:00
|
5. Please help with SQL query, merging rows - in EVE Technology Lab [original thread]
While I agree with the above posters that it's a really bad idea in the first place, there might be a way to achieve this if you are using a current version of SQL Server. You'd have to use ROW_NUMBER partitioned over the fromSystem to derive a t...
- by Matthew - at 2011.06.10 17:24:00
|
6. Incursion 1.4 Static Data Export & Image Export - in EVE Technology Lab [original thread]
Originally by: Tonto Auri Anything changed pertaining images? Blueprint Copy icons... ------- There is no magic Wand of Fixing, and it is not powered by forum whines.
- by Matthew - at 2011.05.19 21:52:00
|
7. API Patch notes for Incursion 1.4 - in EVE Technology Lab [original thread]
Originally by: Sua Vis Originally by: Matthew 2) Even using Rowcount=2560, the "fill forward" technique in place for fetching new records is still only fetching 256 new records at a time, therefore removing the most useful reason ...
- by Matthew - at 2011.04.11 23:40:00
|
8. API Patch notes for Incursion 1.4 - in EVE Technology Lab [original thread]
Is anyone else seeing the following with WalletJournal? 1) Walker is not going back for the full month of data, seems to only go back to when Incursion 1.4 was applied. 2) Even using Rowcount=2560, the "fill forward" technique in place for fetch...
- by Matthew - at 2011.04.09 23:42:00
|
9. API Patch notes for Incursion 1.1.2 - in EVE Technology Lab [original thread]
Originally by: CCP Prism X Roger that. I'll try and look into supplying you with an optional top refresh parameter. I'll even try to maintain backwards compatibility with this current implementation this time around. Prism X, best X ...
- by Matthew - at 2011.03.18 19:06:00
|
10. API Patch notes for Incursion 1.1.2 - in EVE Technology Lab [original thread]
C) Auto Fill-Forward This would be a variant of the previous suggestion, which gives more scope for load management on the server. In this option the first request would respond as it currently does, with the normal 27 minute cache timer: |1--...
- by Matthew - at 2011.03.18 00:37:00
|
11. API Patch notes for Incursion 1.1.2 - in EVE Technology Lab [original thread]
Originally by: CCP Prism X Any clearer? P.S. The alternative leaves the gap on a different place with no indication to the end-user that there are records there being hidden from them. The Alternative (original?) Implementation I a...
- by Matthew - at 2011.03.18 00:33:00
|
12. Help with query -> Blueprint mats. - in EVE Technology Lab [original thread]
Are you saying that instead of generating a table, you want to write a view that does the same thing? Not entirely sure what the advantage of that would be, using such a view would generate significantly more load on your server than running queri...
- by Matthew - at 2011.03.04 00:26:00
|
13. >24 hour delay with /corp/WalletJournal data from API - in EVE Technology Lab [original thread]
Well, it appears that the catch-up yesterday was a one-off hit. It's started falling behind again today. Hopefully a more permanent fix is in the works. ------- There is no magic Wand of Fixing, and it is not powered by forum whines.
- by Matthew - at 2011.02.04 23:18:00
|
14. >24 hour delay with /corp/WalletJournal data from API - in EVE Technology Lab [original thread]
I seem to have had a big catch-up in data in the queries I ran last night, so presumably something got poked. Will have to wait to see what I get out tonight as to whether this signals an actual fix or if someone just manually poked the cache to t...
- by Matthew - at 2011.02.04 12:41:00
|
15. >24 hour delay with /corp/WalletJournal data from API - in EVE Technology Lab [original thread]
Would that 3 days worth of data correspond to around 256 records? I'm seeing an effect whereby it only pulls 256 new records per caching period. So if my journal is filling with new entries faster than that, it starts to fall behind. e.g. if I h...
- by Matthew - at 2011.02.03 14:27:00
|
16. new api for journal - in EVE Technology Lab [original thread]
Originally by: Burnmate umm rowcount is limited to 85? Max rowcount seems to be 256, seems to default to this if you try any higher value (e.g. rowcount=1000 will still only give you 256 rows). ------- There is no magic Wand of Fixing,...
- by Matthew - at 2011.01.20 18:35:00
|
17. API Cache timers - in EVE Technology Lab [original thread]
Originally by: CCP Stillman That's entirely by design. A currentTime field that's not now, but potentially in the past, makes no sense. We don't timestamp when some data is cached. But nobody has requested that in the past, so it's not on ...
- by Matthew - at 2010.11.08 12:32:00
|
18. Solar System Centrality (Eve Database Dump) - in EVE Technology Lab [original thread]
I'm assuming that SQL Server isn't liking the hugely nested joins the description of your query implies. I'd also imagine it takes a while to just write that query for N=20?! This is probably a really bad way of doing it, but if you want to hack ...
- by Matthew - at 2010.09.16 17:32:00
|
19. WalletJournal walking. What I did wrong? - in EVE Technology Lab [original thread]
Bael, that thread you linked is now out of date. CCP upgraded refID to be a bigint, so I'm not expecting to see any further resets of refID values. Unfortunately, it looks like they forgot to upgrade the beforeRefID parameter to handle bigint val...
- by Matthew - at 2010.01.21 15:07:00
|
20. Dominion 1.1 - New wallet API functions? - in EVE Technology Lab [original thread]
Dev Clarification Basically we're getting two new fields in the data, showing how much corp tax we paid, and the ID of the corp we paid it to. ------- There is no magic Wand of Fixing, and it is not powered by forum whines.
- by Matthew - at 2010.01.21 00:03:00
|
Pages: [1] 2 3 4 5 |
First page | Previous page | Next page | Last page |