View Single Post
  #4  
Old 09-30-2014, 09:47 AM
nilbog nilbog is offline
Project Manager

nilbog's Avatar

Join Date: Oct 2009
Posts: 14,657
Default

The only item that fixed was Spirit of Sloth. I don't know much about poisons but I'll explain how these can be changed.

The poisons have different proc effects. For Spirit of Sloth, it happened to be Muscle Lock I. The fix was to change I to IV. For the rest of these, I need someone familiar with them to help determine what might be broken.

The following query shows what poisons might be in error, based on names from the link provided earlier in thread: http://kikyara.tripod.com/poisons/effects.html

Code:
select i.id,i.name,i.proceffect,sn.name from items i
left join spells_new sn on (sn.id = i.proceffect)
where i.itemtype = '42'
and
sn.name regexp 'muscle lock.*|berserker madness.*|blinding poison.*|brittle haste.*|contact poison.*|dizzy.*|feeble mind.*|flesh rot.*|injected.*|liquid silver.*|lower resist.*|paralyzing root.*|poison animal.*|poison summoned.*|system shock.*|weaken.*'
order by sn.name
Code:
14056        Maddening Sap        1836        Berserker Madness I
14072        Zek Frost        1858        Berserker Madness II
14088        Essence of Rallos        1859        Berserker Madness III
14096        Warlords Rage        1879        Berserker Madness IV
14050        Retinal Deactivator        1832        Blinding Poison I
14059        Eyeburn Solution        1839        Blinding Poison II
14074        Shadowveil Hemlock        1840        Blinding Poison III
14053        Delusional Swiftness        1838        Brittle Haste I
14067        Xegony's Curse        1849        Brittle Haste II
14082        Paradoxical Peptide        1850        Brittle Haste III
14097        Rending Swiftness        1880        Brittle Haste IV
14095        Soul Burn        761        Contact Poison
14024        Giant Wasp Venom        761        Contact Poison
14033        Asp Poison        761        Contact Poison
14058        Aching Blood        761        Contact Poison
14076        Visionistic Pain        761        Contact Poison
14038        Sweet Lathyris        766        Dizzy
14066        Languid Lixt Wing        766        Dizzy
14083        Crippling Peptide        766        Dizzy
14099        Twisting Disorientation        766        Dizzy
14036        Cyclan Butil        764        Feeble Mind
14079        Cranial Cryofrost        764        Feeble Mind
14064        Powdered Banality        764        Feeble Mind
14092        Mages Bane        764        Feeble Mind
14309        Crookstinger Poison        764        Feeble Mind
14052        Solvent Gangrene        1837        Flesh Rot I
14063        Leprous Pus        1847        Flesh Rot II
14080        Visceral Rot        1848        Flesh Rot III
14037        Putrid Bane        765        Injected Poison
14016        Snake Venom        765        Injected Poison
14065        Choking Asmag        765        Injected Poison
14081        Amnesic Lolium        765        Injected Poison
14089        Smoldering Cyanide        1867        Injected Poison IV
14049        Inferno Blood        1883        Injected Poison V
14039        Lixt Wing Dust        767        Liquid Silver
14084        Temporal Rot        767        Liquid Silver
14068        Calcium Rot        767        Liquid Silver
14093        Susceptible Essence        768        Lower Resists
14071        Dilapidating Ash        768        Lower Resists
14040        Festering Nettle        768        Lower Resists
14085        Cyclic Vertigo        768        Lower Resists
14061        Lethargic Bliss        762        Muscle Lock
14078        Pacifying Whisper        762        Muscle Lock
14034        Basilisk Poison        762        Muscle Lock
14091        Spirit of Sloth        1875        Muscle Lock IV
14054        Rancid Wolfkiller        1834        Poison Animal I
14069        Beastchoker        1843        Poison Animal II
14086        Carnivore Mortis        1844        Poison Animal III
14055        Anti-Element        1835        Poison Summoned I
14070        Corrosive Solvent        1845        Poison Summoned II
14087        Acidic Dissolver        1846        Poison Summoned III
14035        Crystal Eritus        763        System Shock
14098        Mind Melt        763        System Shock
14301        Vial of Rabid Froth        763        System Shock
14077        Metallic Alkaloid        763        System Shock
14062        Brain Freeze        763        System Shock
14090        Iron Dimethyl        763        System Shock
14094        Horrendous Atrophy        760        Weakening Poison
14032        Regalis Poison        760        Weakening Poison
14057        Atrophic Sap        760        Weakening Poison
14015        Spider Venom        760        Weakening Poison
14073        Monk's Hood Aconite        760        Weakening Poison
What should have IIs, IIIs, or IVs where there are only I?