Items: Difference between revisions
From Portals of Phereon Wiki
Content added Content deleted
(add order by id) |
(new table format) |
||
Line 1: | Line 1: | ||
{{Ambox|image = [[File:Ambox_warning_blue.svg|50px]]|text=This page is under reconstruction, it will be filled with updated content soon {{CURRENTDAY}}/{{CURRENTMONTH}}/{{CURRENTYEAR}}}} |
{{Ambox|image = [[File:Ambox_warning_blue.svg|50px]]|text=This page is under reconstruction, it will be filled with updated content soon {{CURRENTDAY}}/{{CURRENTMONTH}}/{{CURRENTYEAR}}}} |
||
{{#css: |
|||
.table-image-col tr td:first-child { |
|||
width:64px; |
|||
padding:2px; |
|||
} |
|||
}} |
|||
==Equipment== |
==Equipment== |
||
==='''Weapons'''=== |
==='''Weapons'''=== |
||
{| class="article-table sortable table-image-col" |
|||
! class="unsortable" | Image |
|||
! data-sort-type="text" | Name |
|||
! data-sort-type="text" | Rarity |
|||
! data-sort-type="number" | Value |
|||
! data-sort-type="text" | Weapon Attack |
|||
! data-sort-type="text" | Damage |
|||
! class="unsortable" | Modifiers |
|||
! class="unsortable" | Skill |
|||
! class="unsortable" | Passive effect |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables=items |
tables=items |
||
|fields= |
|fields= |
||
'9'=colNum, |
|||
CONCAT('<div style="width:64px">',icon,'</div>')=Image, |
|||
icon=Image, |
|||
name=Name, |
name=Name, |
||
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
||
value=Value, |
|||
IF(atkType=0,'None',IF(atkType=1,'Basic',IF(atkType=2,'Cleave',IF(atkType=3,'Swing',IF(atkType=4,'Pierce',IF(atkType=5,'Unable',IF(atkType=6,'Ranged',atkType)))))))=Weapon Attack, |
|||
IF(damageType=0,'None',IF(damageType=1,'Basic',IF(damageType=2,'Slashing',IF(damageType=3,'Fire',IF(damageType=4,'Water',IF(damageType=5,'Ice',IF(damageType=6,'Electric',IF(damageType=7,'Poison',IF(damageType=8,'Bleeding',IF(damageType=9,'True',IF(damageType=10,'Light',IF(damageType=11,'Shadow',damageType))))))))))))=Damage, |
IF(damageType=0,'None',IF(damageType=1,'Basic',IF(damageType=2,'Slashing',IF(damageType=3,'Fire',IF(damageType=4,'Water',IF(damageType=5,'Ice',IF(damageType=6,'Electric',IF(damageType=7,'Poison',IF(damageType=8,'Bleeding',IF(damageType=9,'True',IF(damageType=10,'Light',IF(damageType=11,'Shadow',damageType))))))))))))=Damage, |
||
CONCAT( |
CONCAT( |
||
IF(hp=0,'',CONCAT(' |
IF(hp=0,'',CONCAT('HP:',hp,'{{((}}#tag:br{{))}}')), |
||
IF(mana=0,'',CONCAT(' |
IF(mana=0,'',CONCAT('Mana:',mana,'{{((}}#tag:br{{))}}')), |
||
IF(speed=0,'',CONCAT(' |
IF(speed=0,'',CONCAT('Speed:',speed,'{{((}}#tag:br{{))}}')), |
||
IF(strength=0,'',CONCAT(' |
IF(strength=0,'',CONCAT('Strength:',strength,'{{((}}#tag:br{{))}}')), |
||
IF(armor=0,'',CONCAT(' |
IF(armor=0,'',CONCAT('Armor:',armor,'{{((}}#tag:br{{))}}')), |
||
IF(lDmg=0,'',CONCAT('Lust damage:',lDmg,' |
IF(lDmg=0,'',CONCAT('Lust damage:',lDmg,'{{((}}#tag:br{{))}}')), |
||
IF(lRes=0,'',CONCAT('Lust |
IF(lRes=0,'',CONCAT('Lust resistance:',lRes,'{{((}}#tag:br{{))}}')), |
||
IF(magicStrength=0,'',CONCAT('Magic strength:',magicStrength,' |
IF(magicStrength=0,'',CONCAT('Magic strength:',magicStrength,'{{((}}#tag:br{{))}}')))=Modifiers, |
||
CONCAT(activeSkill,' |
CONCAT(activeSkill,'{{((}}#tag:br{{))}}','range:',itemRange,' mana cost:',manaCost,' ap cost:',apCost,' uses:',uses,'{{((}}#tag:br{{))}}',description)=Skill, |
||
passiveEffect=Passive effect |
passiveEffect=Passive effect |
||
|where=itemType=1 |
|where=itemType=1 |
||
|order by= |
|order by=name |
||
|format= |
|format=template |
||
|template=Cargo Table |
|||
}} |
}} |
||
|} |
|||
==='''Armor'''=== |
==='''Armor'''=== |
||
{| class="article-table sortable table-image-col" |
|||
! class="unsortable" | Image |
|||
! data-sort-type="text" | Name |
|||
! data-sort-type="text" | Rarity |
|||
! data-sort-type="number" | Value |
|||
! class="unsortable" | Modifiers |
|||
! class="unsortable" | Skill |
|||
! class="unsortable" | Passive effect |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables=items |
tables=items |
||
|fields= |
|fields= |
||
'7'=colNum, |
|||
CONCAT('<div style="width:64px">',icon,'</div>')=Image, |
|||
icon=Image, |
|||
name=Name, |
name=Name, |
||
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
||
value=Value, |
value=Value, |
||
CONCAT( |
CONCAT( |
||
IF(hp=0,'',CONCAT(' |
IF(hp=0,'',CONCAT('HP:',hp,'{{((}}#tag:br{{))}}')), |
||
IF(mana=0,'',CONCAT(' |
IF(mana=0,'',CONCAT('Mana:',mana,'{{((}}#tag:br{{))}}')), |
||
IF(speed=0,'',CONCAT(' |
IF(speed=0,'',CONCAT('Speed:',speed,'{{((}}#tag:br{{))}}')), |
||
IF(strength=0,'',CONCAT(' |
IF(strength=0,'',CONCAT('Strength:',strength,'{{((}}#tag:br{{))}}')), |
||
IF(armor=0,'',CONCAT(' |
IF(armor=0,'',CONCAT('Armor:',armor,'{{((}}#tag:br{{))}}')), |
||
IF(lDmg=0,'',CONCAT('Lust damage:',lDmg,' |
IF(lDmg=0,'',CONCAT('Lust damage:',lDmg,'{{((}}#tag:br{{))}}')), |
||
IF(lRes=0,'',CONCAT('Lust |
IF(lRes=0,'',CONCAT('Lust resistance:',lRes,'{{((}}#tag:br{{))}}')), |
||
IF(magicStrength=0,'',CONCAT('Magic strength:',magicStrength,' |
IF(magicStrength=0,'',CONCAT('Magic strength:',magicStrength,'{{((}}#tag:br{{))}}')))=Modifiers, |
||
CONCAT(activeSkill,' |
CONCAT(activeSkill,'{{((}}#tag:br{{))}}','range:',itemRange,' mana cost:',manaCost,' ap cost:',apCost,' uses:',uses,'{{((}}#tag:br{{))}}',description)=Skill, |
||
passiveEffect=Passive effect |
passiveEffect=Passive effect |
||
|where=itemType=2 |
|where=itemType=2 |
||
|order by= |
|order by=name |
||
|format= |
|format=template |
||
|template=Cargo Table |
|||
}} |
}} |
||
|} |
|||
==='''Miscellaneous'''=== |
==='''Miscellaneous'''=== |
||
{| class="article-table sortable table-image-col" |
|||
! class="unsortable" | Image |
|||
! data-sort-type="text" | Name |
|||
! data-sort-type="text" | Rarity |
|||
! data-sort-type="number" | Value |
|||
! class="unsortable" | Modifiers |
|||
! class="unsortable" | Skill |
|||
! class="unsortable" | Passive effect |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables=items |
tables=items |
||
|fields= |
|fields= |
||
'7'=colNum, |
|||
CONCAT('<div style="width:64px">',icon,'</div>')=Image, |
|||
icon=Image, |
|||
name=Name, |
name=Name, |
||
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
||
value=Value, |
value=Value, |
||
CONCAT( |
CONCAT( |
||
IF(hp=0,'',CONCAT(' |
IF(hp=0,'',CONCAT('HP:',hp,'{{((}}#tag:br{{))}}')), |
||
IF(mana=0,'',CONCAT(' |
IF(mana=0,'',CONCAT('Mana:',mana,'{{((}}#tag:br{{))}}')), |
||
IF(speed=0,'',CONCAT(' |
IF(speed=0,'',CONCAT('Speed:',speed,'{{((}}#tag:br{{))}}')), |
||
IF(strength=0,'',CONCAT(' |
IF(strength=0,'',CONCAT('Strength:',strength,'{{((}}#tag:br{{))}}')), |
||
IF(armor=0,'',CONCAT(' |
IF(armor=0,'',CONCAT('Armor:',armor,'{{((}}#tag:br{{))}}')), |
||
IF(lDmg=0,'',CONCAT('Lust damage:',lDmg,' |
IF(lDmg=0,'',CONCAT('Lust damage:',lDmg,'{{((}}#tag:br{{))}}')), |
||
IF(lRes=0,'',CONCAT('Lust |
IF(lRes=0,'',CONCAT('Lust resistance:',lRes,'{{((}}#tag:br{{))}}')), |
||
IF(magicStrength=0,'',CONCAT('Magic strength:',magicStrength,' |
IF(magicStrength=0,'',CONCAT('Magic strength:',magicStrength,'{{((}}#tag:br{{))}}')))=Modifiers, |
||
CONCAT(activeSkill,' |
CONCAT(activeSkill,'{{((}}#tag:br{{))}}','range:',itemRange,' mana cost:',manaCost,' ap cost:',apCost,' uses:',uses,'{{((}}#tag:br{{))}}',description)=Skill, |
||
passiveEffect=Passive effect |
passiveEffect=Passive effect |
||
|where=itemType=3 |
|where=itemType=3 |
||
|order by= |
|order by=name |
||
|format= |
|format=template |
||
|template=Cargo Table |
|||
}} |
}} |
||
|} |
|||
==='''Consumables'''=== |
==='''Consumables'''=== |
||
{| class="article-table sortable table-image-col" |
|||
! class="unsortable" | Image |
|||
! data-sort-type="text" | Name |
|||
! data-sort-type="text" | Rarity |
|||
! data-sort-type="number" | Value |
|||
! class="unsortable | Effect |
|||
! data-sort-type="text" | Can be used in |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables=items |
tables=items |
||
|fields= |
|fields= |
||
'6'=colNum, |
|||
CONCAT('<div style="width:64px">',icon,'</div>')=Image, |
|||
icon=Image, |
|||
name=Name, |
name=Name, |
||
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
IF(rarity=0,'Common',IF(rarity=1,'Rare',IF(rarity=2,'Legendary',IF(rarity=3,'Special',IF(rarity=4,'Mythical',rarity)))))=Rarity, |
||
Line 89: | Line 139: | ||
IF(CONCAT(inPortal,inTown,inBattle) = '000' ,'Nowhere',''))))))))=Can be used in |
IF(CONCAT(inPortal,inTown,inBattle) = '000' ,'Nowhere',''))))))))=Can be used in |
||
|where=itemType=4 |
|where=itemType=4 |
||
|order by= |
|order by=name |
||
|format= |
|format=template |
||
|template=Cargo Table |
|||
}} |
}} |
||
|} |
Revision as of 23:40, 27 December 2020
Equipment
Weapons
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Armor
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Image | Name | Rarity | Value | Modifiers | Skill | Passive effect |
---|
Miscellaneous
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Image | Name | Rarity | Value | Modifiers | Skill | Passive effect |
---|
Consumables
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Maximum number of loops have been performed
Image | Name | Rarity | Value | Effect | Can be used in |
---|