kdmxp192

Iron Phial of Imperil and Phial's Accuracy correction

May 20th, 2019
716
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.89 KB | None | 0 0
  1. DELETE FROM `weenie` WHERE `class_Id` = 33917;
  2.  
  3. INSERT INTO `weenie` (`class_Id`, `class_Name`, `type`, `last_Modified`)
  4. VALUES (33917, 'ace33917-ironphialofimperil', 4, '2019-05-19 00:00:00') /* Missile */;
  5.  
  6. INSERT INTO `weenie_properties_int` (`object_Id`, `type`, `value`)
  7. VALUES (33917,   1,        256) /* ItemType - MissileWeapon */
  8.      , (33917,   3,         80) /* PaletteTemplate - Iron */
  9.      , (33917,   5,         10) /* EncumbranceVal */
  10.      , (33917,   9,    4194304) /* ValidLocations - MissileWeapon */
  11.      , (33917,  11,        250) /* MaxStackSize */
  12.      , (33917,  12,          1) /* StackSize */
  13.      , (33917,  13,         10) /* StackUnitEncumbrance */
  14.      , (33917,  15,         25) /* StackUnitValue */
  15.      , (33917,  16,          1) /* ItemUseable - No */
  16.      , (33917,  19,         25) /* Value */
  17.      , (33917,  44,          1) /* Damage */
  18.      , (33917,  45,          4) /* DamageType - Bludgeon */
  19.      , (33917,  46,        128) /* DefaultCombatStyle - ThrownWeapon */
  20.      , (33917,  48,         47) /* WeaponSkill - MissileWeapons */
  21.      , (33917,  49,          5) /* WeaponTime */
  22.      , (33917,  51,          2) /* CombatUse - Missile */
  23.      , (33917,  65,          1) /* Placement - RightHandCombat */
  24.      , (33917,  93,     132116) /* PhysicsState - Ethereal, IgnoreCollisions, Gravity, Inelastic */
  25.      , (33917, 106,        270) /* ItemSpellcraft */
  26.      , (33917, 107,        150) /* ItemCurMana */
  27.      , (33917, 108,        150) /* ItemMaxMana */
  28.      , (33917, 158,          2) /* WieldRequirements - RawSkill */
  29.      , (33917, 159,         38) /* WieldSkillType - Alchemy */
  30.      , (33917, 160,         75) /* WieldDifficulty */
  31.      , (33917, 353,         10) /* WeaponType - Thrown */;
  32.  
  33. INSERT INTO `weenie_properties_bool` (`object_Id`, `type`, `value`)
  34. VALUES (33917,   1, FALSE) /* Stuck */
  35.      , (33917,  11, TRUE ) /* IgnoreCollisions */
  36.      , (33917,  13, TRUE ) /* Ethereal */
  37.      , (33917,  14, TRUE ) /* GravityStatus */
  38.      , (33917,  17, TRUE ) /* Inelastic */
  39.      , (33917,  19, TRUE ) /* Attackable */
  40.      , (33917,  69, FALSE) /* IsSellable */;
  41.  
  42. INSERT INTO `weenie_properties_float` (`object_Id`, `type`, `value`)
  43. VALUES (33917,  21,       0) /* WeaponLength */
  44.      , (33917,  22,     0.5) /* DamageVariance */
  45.      , (33917,  26,      15) /* MaximumVelocity */
  46.      , (33917,  29,    0.90) /* WeaponDefense */
  47.      , (33917,  39,     0.5) /* DefaultScale */
  48.      , (33917,  62,       1) /* WeaponOffense */
  49.      , (33917,  63,       1) /* DamageMod */
  50.      , (33917,  78,       1) /* Friction */
  51.      , (33917,  79,       0) /* Elasticity */
  52.      , (33917, 156,       1) /* ProcSpellRate */;
  53.  
  54. INSERT INTO `weenie_properties_string` (`object_Id`, `type`, `value`)
  55. VALUES (33917,   1, 'Iron Phial of Imperil') /* Name */
  56.      , (33917,  16, 'An Iron Phial, filled with an alchemical mixture designed to temporarily weaken the armor of those coated in the fluid.') /* LongDesc */
  57.      , (33917,  20, 'Iron Phials of Imperil') /* PluralName */;
  58.  
  59. INSERT INTO `weenie_properties_d_i_d` (`object_Id`, `type`, `value`)
  60. VALUES (33917,   1,   33560312) /* Setup */
  61.      , (33917,   3,  536870932) /* SoundTable */
  62.      , (33917,   6,   67111919) /* PaletteBase */
  63.      , (33917,   8,  100689522) /* Icon */
  64.      , (33917,  22,  872415275) /* PhysicsEffectTable */
  65.      , (33917,  50,  100689523) /* IconOverlay */
  66.      , (33917,  55,       1323) /* ProcSpell - Imperil Other 2 */;
  67.  
  68. INSERT INTO `weenie_properties_spell_book` (`object_Id`, `spell`, `probability`)
  69. VALUES (33917,  1323,      0) /* Imperil Other 2 */
  70.      , (33917,  4017,      2) /* Phial's Accuracy */;
  71.  
  72. DELETE FROM `spell` WHERE `id` = 4017;
  73.  
  74. INSERT INTO `spell` (`id`, `name`, `stat_Mod_Type`, `stat_Mod_Key`, `stat_Mod_Val`, `last_Modified`)
  75. VALUES (4017, 'Phial''s Accuracy', 36880 /* Skill, SingleStat, Additive */, 47 /* MissileWeapons */, 800, '2019-03-18 09:00:00');
Advertisement