User:MagicManRandySavage: Difference between revisions
Jump to navigation
Jump to search
(Created page with "'''Don't mind me, just trying to learn in an environment that doesn't brick other things :)''' ==Hmmm== {{#cargo_compound_query: tables=mods, mod_spawn_weights;where=(mods.domain=1 AND mods.generation_type=5 AND mod_spawn_weights.tag="one_hand_weapon" AND mod_spawn_weights.value>0);fields=mods._pageName=Page,mods.required_level,mods.stat_text=Stats;join on=mods._pageID = mod_spawn_weights._pageID |tables=mods, mod_spawn_weights;where=(mods.domain=1 AND mods.generation_...") |
No edit summary |
||
| Line 1: | Line 1: | ||
'''Don't mind me, just trying to learn in an environment that doesn't brick other things :)''' | '''Don't mind me, just trying to learn in an environment that doesn't brick other things :)''' | ||
==LETSGOOO== | |||
{{#cargo_query: | |||
tables=mods, mod_spawn_weights | |||
|fields=mods._pageName=Page, mods.id=id, mod_spawn_weights.value, mod_spawn_weights.tag | |||
|where=mods.domain=1 AND mods.generation_type=5 AND (mod_spawn_weights.tag="one_hand_weapon" OR mod_spawn_weights.tag="axe") | |||
|join on=mods._pageID = mod_spawn_weights._pageID | |||
|group by=mods.mod_type | |||
|having=mod_spawn_weights.value>0 | |||
|order by=mod_spawn_weights.tag ASC | |||
}} | |||
<!-- | |||
==Hmmm== | ==Hmmm== | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=mods, mod_spawn_weights;where=(mods.domain=1 AND mods.generation_type=5 AND mod_spawn_weights.tag="one_hand_weapon" AND mod_spawn_weights.value>0);fields=mods._pageName=Page,mods.required_level,mods.stat_text=Stats;join on=mods._pageID = mod_spawn_weights._pageID | tables=mods, mod_spawn_weights;where=(mods.domain=1 AND mods.generation_type=5 AND mod_spawn_weights.tag="one_hand_weapon" AND mod_spawn_weights.value>0);fields=mods._pageName=Page,mod_spawn_weights.ordinal,mods.required_level,mods.stat_text=Stats;join on=mods._pageID = mod_spawn_weights._pageID | ||
|tables=mods, mod_spawn_weights;where=(mods.domain=1 AND mods.generation_type=5 AND mod_spawn_weights.tag="axe" AND mod_spawn_weights.value>0);fields=mods._pageName=Page,mods.required_level,mods.stat_text=Stats;join on=mods._pageID = mod_spawn_weights._pageID | |tables=mods, mod_spawn_weights;where=(mods.domain=1 AND mods.generation_type=5 AND mod_spawn_weights.tag="axe" AND mod_spawn_weights.value>0);fields=mods._pageName=Page,mod_spawn_weights.ordinal,mods.required_level,mods.stat_text=Stats;join on=mods._pageID = mod_spawn_weights._pageID | ||
|limit=100 | |limit=100 | ||
|format=table | |format=table | ||
}} | }} | ||
==HOLY SHIT IT WORKS (but looks less bad)== | ==HOLY SHIT IT WORKS (but looks less bad)== | ||
Revision as of 22:09, 17 April 2024
Don't mind me, just trying to learn in an environment that doesn't brick other things :)
LETSGOOO
| Page | id | value | tag |
|---|---|---|---|
| Modifier:V2ChanceToBleedOnHitAndIncreasedDamageToBleedingTargetsCorrupted~ | V2ChanceToBleedOnHitAndIncreasedDamageToBleedingTargetsCorrupted_ | 1,000 | axe |
| Modifier:V2LocalIncreasedPhysicalDamageCorrupted1 | V2LocalIncreasedPhysicalDamageCorrupted1 | 1,000 | axe |
| Modifier:V2ChanceToGainFortifyOnMeleeHitCorrupted | V2ChanceToGainFortifyOnMeleeHitCorrupted | 1,000 | one_hand_weapon |
| Modifier:V2LocalAddedPhysicalDamage1hCorrupted1 | V2LocalAddedPhysicalDamage1hCorrupted1 | 1,000 | one_hand_weapon |
| Modifier:V2ChanceToGainOnslaughtOnKillCorrupted~ | V2ChanceToGainOnslaughtOnKillCorrupted_ | 1,000 | one_hand_weapon |
| Modifier:V2IncreasedAreaOfEffect1hCorrupted | V2IncreasedAreaOfEffect1hCorrupted | 1,000 | one_hand_weapon |
| Modifier:V2LocalIncreasedAttackSpeed1hCorrupted | V2LocalIncreasedAttackSpeed1hCorrupted | 1,000 | one_hand_weapon |
List of things for later:
1H Axe
2H Axe
Bow
Claw
Dagger
1H Mace
2H Mace
Sceptre
Staff
1H Sword
2H Swort
Raipier
Wand
Fishing Pole
Amulet
Ring
Belt
Quiver
Shield
Helm
Body
Glove
Boot
Jewel