| Pages: [1] 2 |
1. Can't get required materials for single run t2 to line up - in EVE Technology Lab [original thread]
yeah, ran into that as well. I used ceil(num_runs/bp_return_qty) something like greatest(ceil(num_runs/bp_return_qty(t1.typeid)),ceil(iam.quantity*(1-(cbpowf/100))*(1-(2/100))*ceil(num_runs/bp_return_qty(t1.typeid)))) i don't plan for teams s...
- by Badmoons - at 2014.08.14 14:40:00
|
2. Can't get required materials for single run t2 to line up - in EVE Technology Lab [original thread]
Found a post that suggested greatest(1,ceil(iam.quantity*(1-(12/100)))) as quantity Thanks to Steve Ronuken came up with greatest(1,ceil(iam.quantity*(1-(10/100))*(1-(2/100))*5040))
- by Badmoons - at 2014.08.12 18:18:00
|
3. Can't get required materials for single run t2 to line up - in EVE Technology Lab [original thread]
Here's the query I'm trying to use. select iam.materialTypeID, 1*iam.quantity-ceil(round(1*iam.quantity*(12/100),3)) as quantity from evestatic.invTypes t1, evestatic.industryActivityProducts iap1, evestatic.industryActivityMaterials iam where t1...
- by Badmoons - at 2014.08.12 18:00:00
|
4. Can't get required materials for single run t2 to line up - in EVE Technology Lab [original thread]
I'm trying to make a impel and I can't get the numbers to line up. The pos array has a 2% me savings and the bpc has a 2% me savings. However, when I figure up how many components I need, i'm a couple off on the larger of the requirements. For exa...
- by Badmoons - at 2014.08.12 17:27:00
|
5. Easy way to adjust for missing Blueprints tables - in EVE Technology Lab [original thread]
Thank you Dragonaire. The recreateLegacyTables at the bottom of yaml_blueprints.php should do nicely.
- by Badmoons - at 2014.08.09 23:26:00
|
6. Easy way to adjust for missing Blueprints tables - in EVE Technology Lab [original thread]
Sorry, guess I should have added that I'm using MySQL.
- by Badmoons - at 2014.08.09 20:25:00
|
7. Easy way to adjust for missing Blueprints tables - in EVE Technology Lab [original thread]
My queries heavily used invBlueprintTypes and ramTypeRequirements. I've also noticed that invMetaTypes and invTypeMaterials aren't working the same. Has anyone created a view to create these tables back from the data in the new tables or is everyo...
- by Badmoons - at 2014.08.09 15:43:00
|
8. Odd Cached Market Logs and EMDR - in EVE Technology Lab [original thread]
So I noticed that entries for the Mackinaw in Amarr hadn't updated since 6/21 in my database. All other regions were updating. As I watched the streams come in from EMDR, it appeard that only 1 date (current date) was being provided by my client. ...
- by Badmoons - at 2013.06.30 13:12:00
|
9. Who is using EMDR? - in EVE Technology Lab [original thread]
*sigh* nevermind, found my problem.
- by Badmoons - at 2012.12.19 16:41:00
|
10. Who is using EMDR? - in EVE Technology Lab [original thread]
Has anyone else noticed some clients sending dates for the duration column instead of numbers?
- by Badmoons - at 2012.12.19 16:32:00
|
11. material requirements for Procurer - in EVE Technology Lab [original thread]
Cool, thanks. I keep it open because I want to make it changeable in my function.
- by Badmoons - at 2012.12.05 00:00:00
|
12. material requirements for Procurer - in EVE Technology Lab [original thread]
BINGO, thank you to everyone for your help! select typeName, round(sum(quantity)) from (select t2.typeName, tm.quantity*1.10 as quantity from evestatic.invTypes t, evestatic.invTypeMaterials tm, evestatic.invTypes t2 where t.typeName = 'Procurer'...
- by Badmoons - at 2012.12.04 23:48:00
|
13. material requirements for Procurer - in EVE Technology Lab [original thread]
I figured that was kind of the problem, but my inital query returned 0 results. After I read through your old post I tried something new. select typeName, round(sum(quantity)*1.10) from (select t2.typeName, tm.quantity from evestatic.invTypes t, ...
- by Badmoons - at 2012.12.04 20:15:00
|
14. material requirements for Procurer - in EVE Technology Lab [original thread]
I was thinking that may have been the problem, but select * from evestatic.ramTypeRequirements where typeID = 17480 reveals no results.
- by Badmoons - at 2012.12.04 19:53:00
|
15. material requirements for Procurer - in EVE Technology Lab [original thread]
So I've loaded the Retribution db dump and I'm still seeing incorrect returns for the required materials for the Procurer. I was hopeing someone knew what's up. select t2.typeName, round(tm.quantity*1.10) from evestatic.invTypes t, evestatic.invT...
- by Badmoons - at 2012.12.04 17:10:00
|
16. Market Data - in Market Discussions [original thread]
So I'm looking to see if anyone is interested in SQL access to the market data from the EMDR. Msg me for details if so.
- by Badmoons - at 2012.10.14 01:33:00
|
17. Updated static database dump - in EVE General Discussion [original thread]
When does CCP plan to release another static db dump for the development teams? There hasn't been a update since Inferno 1.2 and I know there have been changes to ship mineral requirements since then.
- by Badmoons - at 2012.09.23 22:53:00
|
18. Singularity Build 265540 - in Linux [original thread]
Need to get it added quick or there will be a lot of sad pandas on patch day...
- by Badmoons - at 2011.06.07 13:27:00
|
19. Wormhole Sales - in Sell Orders [original thread]
Just purchased a wormhole with no issues at all. Everything was fast (within 24 hours) and a good price. Good experience!!!
- by Badmoons - at 2011.04.12 22:36:00
|
20. [WTS] Class1 WH (empty) with static lowsec, good PI - in Sell Orders [original thread]
Any other statics?
- by Badmoons - at 2011.04.12 19:45:00
|
| Pages: [1] 2 |
| First page | Previous page | Next page | Last page |