Drum-loaded: Difference between revisions
Jump to navigation
Jump to search
(→Rifles: add linear cannon) |
m (Update cargo query to use new MissileWeaponData table) |
||
Line 12: | Line 12: | ||
Drum-loaded is a modification for magazine based weapons, or non-bow or dart gun weapons that use physical ammo. It increases the maximum ammo they can hold by 20%, with a minimum of one. | Drum-loaded is a modification for magazine based weapons, or non-bow or dart gun weapons that use physical ammo. It increases the maximum ammo they can hold by 20%, with a minimum of one. | ||
== Rifles == | == Rifles == | ||
{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | {{#cargo_query:table=ItemsTable=IT, GeneralData=GD, MissileWeaponData=MWD | ||
| join on = IT. | | join on = IT.JoinKey=GD.JoinKey, IT.JoinKey=MWD.JoinKey | ||
| fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Item, MaxAmmo=Ammo (base), CONCAT(CASE | | fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Item, MWD.MaxAmmo=Ammo (base), CONCAT(CASE | ||
WHEN FLOOR(MaxAmmo*1.2) = MaxAmmo | WHEN FLOOR(MWD.MaxAmmo*1.2) = MWD.MaxAmmo | ||
THEN | THEN | ||
MaxAmmo + 1 | MWD.MaxAmmo + 1 | ||
ELSE | ELSE | ||
FLOOR(MaxAmmo*1.2) | FLOOR(MWD.MaxAmmo*1.2) | ||
END) = Ammo (modded) | END) = Ammo (modded) | ||
| where = IT._pageNamespace = 0 AND IT._pageNamespace = 0 AND MaxAmmo > 0 AND GD.ParentObject WITHIN "BaseRifle" | | where = IT._pageNamespace = 0 AND IT._pageNamespace = 0 AND MWD.MaxAmmo > 0 AND GD.ParentObject WITHIN "BaseRifle" | ||
| order by = MaxAmmo ASC, GD.Tier ASC | | order by = MWD.MaxAmmo ASC, GD.Tier ASC | ||
}} | }} | ||
== Pistols == | == Pistols == | ||
{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | {{#cargo_query:table=ItemsTable=IT, GeneralData=GD, MissileWeaponData=MWD | ||
| join on = IT. | | join on = IT.JoinKey=GD.JoinKey, IT.JoinKey=MWD.JoinKey | ||
| fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Item, MaxAmmo=Ammo (base), CONCAT(CASE | | fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Item, MWD.MaxAmmo=Ammo (base), CONCAT(CASE | ||
WHEN FLOOR(MaxAmmo*1.2) = MaxAmmo | WHEN FLOOR(MWD.MaxAmmo*1.2) = MWD.MaxAmmo | ||
THEN | THEN | ||
MaxAmmo + 1 | MWD.MaxAmmo + 1 | ||
ELSE | ELSE | ||
FLOOR(MaxAmmo*1.2) | FLOOR(MWD.MaxAmmo*1.2) | ||
END) = Ammo (modded) | END) = Ammo (modded) | ||
| where = IT._pageNamespace = 0 AND IT._pageNamespace = 0 AND MaxAmmo > 0 AND GD.ParentObject WITHIN "BaseMagazinePistol" | | where = IT._pageNamespace = 0 AND IT._pageNamespace = 0 AND MWD.MaxAmmo > 0 AND GD.ParentObject WITHIN "BaseMagazinePistol" | ||
| order by = MaxAmmo | | order by = MWD.MaxAmmo | ||
}} | }} | ||
== Heavy Weapons == | == Heavy Weapons == | ||
{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | {{#cargo_query:table=ItemsTable=IT, GeneralData=GD, MissileWeaponData=MWD | ||
| join on = IT. | | join on = IT.JoinKey=GD.JoinKey,IT.JoinKey=MWD.JoinKey | ||
| fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Item, MaxAmmo=Ammo (base), CONCAT(CASE | | fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Item, MWD.MaxAmmo=Ammo (base), CONCAT(CASE | ||
WHEN FLOOR(MaxAmmo*1.2) = MaxAmmo | WHEN FLOOR(MWD.MaxAmmo*1.2) = MWD.MaxAmmo | ||
THEN | THEN | ||
MaxAmmo + 1 | MWD.MaxAmmo + 1 | ||
ELSE | ELSE | ||
FLOOR(MaxAmmo*1.2) | FLOOR(MWD.MaxAmmo*1.2) | ||
END) = Ammo (modded) | END) = Ammo (modded) | ||
| where = IT._pageNamespace = 0 AND IT._pageNamespace = 0 AND MaxAmmo > 0 AND GD.ParentObject WITHIN "BaseMagazineHeavyWeapon" | | where = IT._pageNamespace = 0 AND IT._pageNamespace = 0 AND MWD.MaxAmmo > 0 AND GD.ParentObject WITHIN "BaseMagazineHeavyWeapon" | ||
| order by = MaxAmmo ASC, GD.Tier ASC | | order by = MWD.MaxAmmo ASC, GD.Tier ASC | ||
}} | }} | ||
{{Mod Navbox}} | {{Mod Navbox}} |