Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
creator85
Easy man... Easy...
3
|
Posted - 2014.07.25 08:06:00 -
[1] - Quote
Hi! http://c2n.me/iAYQ1Q ME does not affect on this items. How i can get this items in MySQL query? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3579
|
Posted - 2014.07.25 12:01:00 -
[2] - Quote
ME affects all items, reducing them to a minimum of 1 per run.
formula is:
max(runs,ceil(quantity*ME modifier * team modifier * facility modifier * runs))
where ME modifier is 1-(ME/100) (assuming me runs from 0 to 10. if you work with 0 to -10, add instead of subtracting) Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Mondain Rush
Hard Knocks Inc.
0
|
Posted - 2014.07.25 13:09:00 -
[3] - Quote
i'm curious how to get this to pull as well. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3582
|
Posted - 2014.07.25 13:58:00 -
[4] - Quote
Assuming you're using my DB conversion:
SELECT materialtypeid,typename,greatest(1,ceil(quantity*(1-(7/100)))) runquantity FROM industryActivityMaterials JOIN invTypes ON (industryActivityMaterials.materialtypeid=invTypes.typeid) WHERE industryActivityMaterials.typeid=22465 and activityid=1;
+----------------+-------------------------------+-------------+ | materialtypeid | typename | runquantity | +----------------+-------------------------------+-------------+ | 3828 | Construction Blocks | 22 | | 11399 | Morphite | 14 | | 11478 | R.A.M.- Starship Tech | 9 | | 11533 | Magpulse Thruster | 56 | | 11534 | Gravimetric Sensor Cluster | 70 | | 11540 | Quantum Microprocessor | 335 | | 11544 | Titanium Diborite Armor Plate | 1395 | | 11550 | Graviton Reactor Unit | 14 | | 11552 | Scalar Capacitor Unit | 140 | | 11558 | Sustained Shield Emitter | 36 | | 16238 | Cormorant | 1 | +----------------+-------------------------------+-------------+
Assuming you're using it with something that supports named parameters:
SELECT materialtypeid,typename,greatest(1,ceil(quantity*(1-(:ME/100))*(1-(:FACILITY/100))*:TEAM )) runquantity FROM industryActivityMaterials JOIN invTypes ON (industryActivityMaterials.materialtypeid=invTypes.typeid) WHERE industryActivityMaterials.typeid=:TYPEID and activityid=1;
Where :TYPEID is the blueprint typeid :ME is the blueprint ME (0-10) :FACILITY is the facility bonus (so 2 for an equipment array, for example) :TEAM is the calculated modifier for the team (due to multiple workers being possible, easiest to calculate in advance)
Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |