API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 21st, 2014
269
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.33 KB | None | 0 0
raw download clone embed print report
  1. SET @ENTRY = 985037; -- // CAMBIAR VALOR
  2.      
  3. -- Item
  4.     REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`)
  5.     VALUES
  6.     (@ENTRY, -- Entry    // CAMBIAR VALOR
  7.     0, -- class
  8.     0, -- subclass
  9.     -1,
  10.     'Silbato', -- Name   // CAMBIAR VALOR
  11.     46787, -- displayid
  12.     4, -- Quality
  13.     72, -- Flags
  14.     0, -- FlagsExtra
  15.     1, -- BuyCount
  16.     0, -- BuyPrice
  17.     0, -- SellPrice
  18.     0, -- InventoryType
  19.     -1, -- AllowableClass
  20.     -1, -- AllowableRace
  21.     1, -- ItemLevel
  22.     1, -- RequiredLevel
  23.     0, -- RequiredSkill
  24.     0, -- RequiredSkillRank
  25.     0, -- requiredspell
  26.     0, -- requiredhonorrank
  27.     0, -- RequiredCityRank
  28.     0, -- RequiredReputationFaction
  29.     6, -- RequiredReputationRank
  30.     1, -- maxcount
  31.     1, -- stackable
  32.     0, -- ContainerSlots
  33.     0, -- StatsCount
  34.     0, -- stat_type1
  35.     0, -- stat_value1
  36.     0, -- stat_type2
  37.     0, -- stat_value2
  38.     0, -- stat_type3
  39.     0, -- stat_value3
  40.     0, -- stat_type4
  41.     0, -- stat_value4
  42.     0, -- stat_type5
  43.     0, -- stat_value5
  44.     0, -- stat_type6
  45.     0, -- stat_value6
  46.     0, -- stat_type7
  47.     0, -- stat_value7
  48.     0, -- stat_type8
  49.     0, -- stat_value8
  50.     0, -- stat_type9
  51.     0, -- stat_value9
  52.     0, -- stat_type10
  53.     0, -- stat_value10
  54.     0, -- ScalingStatDistribution`
  55.     0, -- ScalingStatValue
  56.     0, -- dmg_min1
  57.     0, -- dmg_max1
  58.     0, -- dmg_type1
  59.     0, -- dmg_min2
  60.     0, -- dmg_max2
  61.     0, -- dmg_type2
  62.     0, -- armor
  63.     0, -- Holy res
  64.     0, -- fire res
  65.     0, -- nature res
  66.     0, -- frost res
  67.     0, -- shadow res
  68.     0, -- arcane res
  69.     0, -- delay
  70.     0, -- ammo type
  71.     0, -- rangedmodrange
  72.     18282, -- spellid_1
  73.     0, -- spelltrigger_1
  74.     0, --  spellcharges_1
  75.     0, -- spellppmRate_1
  76.     10, -- spellcooldown_1
  77.     0, -- spellcategory_1
  78.     -1, -- spellcategorycooldown_1
  79.     0, -- spellid_2
  80.     0, -- spelltrigger_2
  81.     0, --  spellcharges_2
  82.     0, -- spellppmRate_2
  83.     0, -- spellcooldown_2
  84.     0, -- spellcategory_2
  85.     0, -- spellcategorycooldown_2
  86.     0, -- 3
  87.     0, -- 3
  88.     0, -- 3
  89.     0, -- 3
  90.     0, -- 3
  91.     0, -- 3
  92.     0, -- 3
  93.     0, -- 4
  94.     0, -- 4
  95.     0, -- 4
  96.     0, -- 4
  97.     0, -- 4
  98.     0, -- 4
  99.     0, -- 4
  100.     0, -- 5
  101.     0, -- 5
  102.     0, -- 5
  103.     0, -- 5
  104.     0, -- 5
  105.     0, -- 5
  106.     0, -- 5
  107.     1, -- bonding
  108.     'Summonea a tu companion personalizado (Requiere VIP activo en la cuenta).', -- description
  109.     0, -- PageText
  110.     0, -- LanguageID
  111.     0, -- PageMaterial
  112.     0, -- startquest
  113.     0, -- lockid
  114.     8, -- Material
  115.     0, -- sheath
  116.     0, -- RandomProperty
  117.     0, -- RandomSuffix
  118.     0, -- block
  119.     0, -- itemset
  120.     0, -- MaxDurability
  121.     0, -- area
  122.     0, -- Map
  123.     0, -- BagFamily
  124.     0, -- TotemCategory
  125.     0, -- socketColor_1
  126.     0, -- socketContent_1
  127.     0, -- 2
  128.     0, -- 2
  129.     0, -- 3
  130.     0, -- 3
  131.     0, -- socketBonus
  132.     0, -- GemProperties
  133.     -1, -- RequiredDisenchantSkill
  134.     0, -- ArmorDamageMODIFIER
  135.     0, -- Duration
  136.     0, -- ItemLimitCategory
  137.     0, -- HolidayId
  138.     'summon_custom_companion_Crt_Wolf', -- ScriptName   // CAMBIAR VALOR
  139.     0, -- DisenchantID
  140.     0, -- FoodType
  141.     0, -- minMoneyLoot
  142.     0, -- maxMoneyLoot
  143.     -4); -- WDBVerified
  144.      
  145.      UPDATE item_template SET NAME = 'Silbato de Pichicho' WHERE entry = @ENTRY; -- Nombre
  146.      UPDATE item_template SET ScriptName = 'summon_custom_companion_repair' WHERE entry = @ENTRY; -- Script en .CPP
  147.      
  148. -- Icerune Creature Summon
  149.      
  150.     REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`)
  151.     VALUES
  152.     (@ENTRY, -- Entry   // CAMBIAR VALOR
  153.     0, -- difi entry1
  154.     0, -- 2
  155.     0, -- 3
  156.     0, -- kill credit 1
  157.     0, -- 2
  158.     29673, -- modelid   // CAMBIAR VALOR
  159.     0, -- 2
  160.     0, -- 3
  161.     0, -- 4
  162.     'Crt Wolf', -- name       // CAMBIAR VALOR                            
  163.     'Mandame pm y en la semana lo vemos', -- subname        // CAMBIAR VALOR
  164.     '', -- `IconName`
  165.     0, -- `gossip_menu_id`
  166.     80, -- minlevel
  167.     80, -- maxlevel
  168.     2, -- exp
  169.     35, -- faction a
  170.     35, -- faction h
  171.     4225, -- npcflag
  172.     2.5, -- speed_walk
  173.     2.64286, -- speed_run
  174.     0.29, -- scale              // CAMBIAR VALOR
  175.     0, -- rank
  176.     1000, -- mindmg
  177.     1000, -- maxdmg
  178.     0, -- dmgschool
  179.     1000, -- attackpower
  180.     100, -- dmg_multiplier
  181.     2000, -- baseattacktime
  182.     0, -- rangeattacktime
  183.     0, -- unit_class
  184.     2, -- unit_flags
  185.     8, -- dynamicflags
  186.     0, -- family
  187.     0, -- trainer_type
  188.     0, -- trainer_spell
  189.     0, -- trainer_class
  190.     0, -- trainer_race
  191.     1000, -- minrangedmg
  192.     1000, -- maxrangedmg
  193.     100, -- rangedattackpower
  194.     12, -- type
  195.     1048576, -- type_flags
  196.     0, -- lootid`
  197.     0, -- `pickpocketloot`
  198.     0, -- `skinloot
  199.     0, -- resistance1
  200.     0, -- 2
  201.     0, -- 3
  202.     0, -- 4
  203.     0, -- 5
  204.     0, -- 6
  205.     0, -- spell1
  206.     0, -- 2
  207.     0, -- 3
  208.     0, -- 4
  209.     0, -- 5
  210.     0, -- 6
  211.     0, -- 7
  212.     0, -- 8
  213.     0, -- PetSpellDataId
  214.     0, -- VehicleId
  215.     0, -- `mingold
  216.     0, -- maxgold
  217.     '', -- AIName // PetAI o GuardAI o
  218.     1, -- MovementType
  219.     3, -- InhabitType
  220.     8, -- Health_mod
  221.     1, -- Mana_mod
  222.     1, -- Armor_mod
  223.     0, --   RacialLeader
  224.     0, -- questItem1
  225.     0, -- 2
  226.     0, -- 3
  227.     0, -- 4
  228.     0, -- 5
  229.     0, -- 6
  230.     0, -- movementId
  231.     1, -- RegenHealth
  232.     0, -- mechanic_immune_mask
  233.     2, -- flags_extra
  234.     'npc_custom_companion_Crt_Wolf', -- ScriptName  // CAMBIAR VALOR
  235.     -4); -- WDBVerified`
  236.      
  237.     UPDATE creature_template SET modelid1 = 29673 WHERE entry = @ENTRY; -- Modelo
  238.     UPDATE creature_template SET NAME = 'Pichicho' WHERE entry = @ENTRY; -- Nombre
  239.     UPDATE creature_template SET subname = 'Guardian Feroz' WHERE entry = @ENTRY; -- Sub Nombre
  240.     UPDATE creature_template SET scale = 0.3 WHERE entry = @ENTRY; -- Scale
  241.     UPDATE creature_template SET speed_walk = 1.3 WHERE entry = @ENTRY; --
  242.     UPDATE creature_template SET speed_run = 1.3 WHERE entry = @ENTRY; --
  243.     UPDATE creature_template SET InhabitType = 3 WHERE entry = @ENTRY; -- 3 para tierra, 4 para voladores
  244.     UPDATE creature_template SET ScriptName = 'npc_custom_companion_repair' WHERE entry = @ENTRY; -- Script en .CPP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!