Overloaded: Difference between revisions

86 bytes added ,  03:26, 18 September 2021
m
no edit summary
(Add info about overheating and breaking)
mNo edit summary
Line 126: Line 126:
|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,'{{)}}')=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'))
|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
|order by=GD.PlainName
|order by=GD.PlainName