kdmxp192 icon

Iron Phial of Imperil and Phial's Accuracy correction

kdmxp192 | PRO | 05/20/19 05:49:18 AM UTC | 0 ⭐ | 6684 👁️ | Never ⏰ | []
SQL |

3.89 KB

|

None

|

0 👍

/

0 👎

DELETE FROM `weenie` WHERE `class_Id` = 33917;
 
INSERT INTO `weenie` (`class_Id`, `class_Name`, `type`, `last_Modified`)
VALUES (33917, 'ace33917-ironphialofimperil', 4, '2019-05-19 00:00:00') /* Missile */;
 
INSERT INTO `weenie_properties_int` (`object_Id`, `type`, `value`)
VALUES (33917,   1,        256) /* ItemType - MissileWeapon */
     , (33917,   3,         80) /* PaletteTemplate - Iron */
     , (33917,   5,         10) /* EncumbranceVal */
     , (33917,   9,    4194304) /* ValidLocations - MissileWeapon */
     , (33917,  11,        250) /* MaxStackSize */
     , (33917,  12,          1) /* StackSize */
     , (33917,  13,         10) /* StackUnitEncumbrance */
     , (33917,  15,         25) /* StackUnitValue */
     , (33917,  16,          1) /* ItemUseable - No */
     , (33917,  19,         25) /* Value */
     , (33917,  44,          1) /* Damage */
     , (33917,  45,          4) /* DamageType - Bludgeon */
     , (33917,  46,        128) /* DefaultCombatStyle - ThrownWeapon */
     , (33917,  48,         47) /* WeaponSkill - MissileWeapons */
     , (33917,  49,          5) /* WeaponTime */
     , (33917,  51,          2) /* CombatUse - Missile */
     , (33917,  65,          1) /* Placement - RightHandCombat */
     , (33917,  93,     132116) /* PhysicsState - Ethereal, IgnoreCollisions, Gravity, Inelastic */
     , (33917, 106,        270) /* ItemSpellcraft */
     , (33917, 107,        150) /* ItemCurMana */
     , (33917, 108,        150) /* ItemMaxMana */
     , (33917, 158,          2) /* WieldRequirements - RawSkill */
     , (33917, 159,         38) /* WieldSkillType - Alchemy */
     , (33917, 160,         75) /* WieldDifficulty */
     , (33917, 353,         10) /* WeaponType - Thrown */;
 
INSERT INTO `weenie_properties_bool` (`object_Id`, `type`, `value`)
VALUES (33917,   1, FALSE) /* Stuck */
     , (33917,  11, TRUE ) /* IgnoreCollisions */
     , (33917,  13, TRUE ) /* Ethereal */
     , (33917,  14, TRUE ) /* GravityStatus */
     , (33917,  17, TRUE ) /* Inelastic */
     , (33917,  19, TRUE ) /* Attackable */
     , (33917,  69, FALSE) /* IsSellable */;
 
INSERT INTO `weenie_properties_float` (`object_Id`, `type`, `value`)
VALUES (33917,  21,       0) /* WeaponLength */
     , (33917,  22,     0.5) /* DamageVariance */
     , (33917,  26,      15) /* MaximumVelocity */
     , (33917,  29,    0.90) /* WeaponDefense */
     , (33917,  39,     0.5) /* DefaultScale */
     , (33917,  62,       1) /* WeaponOffense */
     , (33917,  63,       1) /* DamageMod */
     , (33917,  78,       1) /* Friction */
     , (33917,  79,       0) /* Elasticity */
     , (33917, 156,       1) /* ProcSpellRate */;
 
INSERT INTO `weenie_properties_string` (`object_Id`, `type`, `value`)
VALUES (33917,   1, 'Iron Phial of Imperil') /* Name */
     , (33917,  16, 'An Iron Phial, filled with an alchemical mixture designed to temporarily weaken the armor of those coated in the fluid.') /* LongDesc */
     , (33917,  20, 'Iron Phials of Imperil') /* PluralName */;
 
INSERT INTO `weenie_properties_d_i_d` (`object_Id`, `type`, `value`)
VALUES (33917,   1,   33560312) /* Setup */
     , (33917,   3,  536870932) /* SoundTable */
     , (33917,   6,   67111919) /* PaletteBase */
     , (33917,   8,  100689522) /* Icon */
     , (33917,  22,  872415275) /* PhysicsEffectTable */
     , (33917,  50,  100689523) /* IconOverlay */
     , (33917,  55,       1323) /* ProcSpell - Imperil Other 2 */;
 
INSERT INTO `weenie_properties_spell_book` (`object_Id`, `spell`, `probability`)
VALUES (33917,  1323,      0) /* Imperil Other 2 */
     , (33917,  4017,      2) /* Phial's Accuracy */;
 
DELETE FROM `spell` WHERE `id` = 4017;
 
INSERT INTO `spell` (`id`, `name`, `stat_Mod_Type`, `stat_Mod_Key`, `stat_Mod_Val`, `last_Modified`)
VALUES (4017, 'Phial''s Accuracy', 36880 /* Skill, SingleStat, Additive */, 47 /* MissileWeapons */, 800, '2019-03-18 09:00:00');

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎