8,290
edits
Overloaded: Difference between revisions
Jump to navigation
Jump to search
m
Update to use new Cargo table
(add ninefold boots) |
m (Update to use new Cargo table) |
||
| Line 129: | Line 129: | ||
inefficient. Could maybe be improved later if we store better data to determine when something is eligible for a specific mod. | inefficient. Could maybe be improved later if we store better data to determine when something is eligible for a specific mod. | ||
--> | --> | ||
{{#cargo_query: tables= | {{#cargo_query: tables=GeneralData=GD,MissileWeaponData=MWD,ArtifactData=AD | ||
|join on= | |join on=GD.JoinKey=MWD.JoinKey,GD.JoinKey=AD.JoinKey | ||
|fields= | |fields= | ||
CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{!}}prefix:&yov&we&Wr&Rl&Wo&wa&yded{{)}}')=Item, | CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{!}}prefix:&yov&we&Wr&Rl&Wo&wa&yded{{)}}')=Item, | ||
AD.ChargeUsed=Base</br>Charge Use,FLOOR(4 * AD.ChargeUsed)=Overloaded</br>Charge Use,FLOOR(AD.ChargeUsed / 25.0)+1=Overheat</br>Temp Per Use, | |||
CONCAT(CONCAT(FLOOR( | CONCAT(CONCAT(FLOOR(AD.ChargeUsed/2.5)+1.0)/100.0,'%')=Breakage</br>Chance Per Use | ||
|where= | |where=AD.ChargeUsed IS NOT NULL AND GD._pageName NOT LIKE 'Data:%' AND (MWD._pageName IS NOT NULL OR (PlainName LIKE 'gaslight %' OR PlainName LIKE '% rod' OR PlainName LIKE 'geomagnetic disc' OR PlainName LIKE 'maghammer' OR PlainName LIKE 'powered exoskeleton' OR PlainName LIKE 'ulnar stimulators' OR PlainName LIKE 'ganglionic teleprojector' OR PlainName LIKE 'night-vision goggles')) | ||
|format=table | |format=table | ||
|order by=GD.PlainName | |order by=GD.PlainName | ||