8,290
edits
Overloaded: Difference between revisions
Jump to navigation
Jump to search
m
Add "overloaded" prefix to cargo query results
(Add navbox) |
m (Add "overloaded" prefix to cargo query results) |
||
| Line 128: | Line 128: | ||
{{#cargo_query: tables=ItemsTable=IT,GeneralData=GD,MissileWeaponData=MWD | {{#cargo_query: tables=ItemsTable=IT,GeneralData=GD,MissileWeaponData=MWD | ||
|join on=IT.JoinKey=GD.JoinKey,IT.JoinKey=MWD.JoinKey | |join on=IT.JoinKey=GD.JoinKey,IT.JoinKey=MWD.JoinKey | ||
|fields=CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Item,IT.ChargeUsed=Base</br>Charge Use,FLOOR(4 * IT.ChargeUsed)=Overloaded</br>Charge Use,FLOOR(IT.ChargeUsed / 25.0)+1=Overheat</br>Temp Per Use,CONCAT(CONCAT(FLOOR(IT.ChargeUsed/2.5)+1.0)/100.0,'%')=Breakage</br>Chance Per Use | |fields= | ||
CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{!}}prefix:&yov&we&Wr&Rl&Wo&wa&yded{{)}}')=Item, | |||
IT.ChargeUsed=Base</br>Charge Use,FLOOR(4 * IT.ChargeUsed)=Overloaded</br>Charge Use,FLOOR(IT.ChargeUsed / 25.0)+1=Overheat</br>Temp Per Use, | |||
CONCAT(CONCAT(FLOOR(IT.ChargeUsed/2.5)+1.0)/100.0,'%')=Breakage</br>Chance Per Use | |||
|where=IT.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')) | |where=IT.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 | ||