Advertisement
Guest User

Untitled

a guest
May 28th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.77 KB | None | 0 0
  1. DELETE FROM `creature_template` WHERE (`entry`=35613);
  2. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (35613, 0, 0, 0, 0, 0, 24124, 0, 24124, 0, 'Valhalla PvP S7', 'Season Informer', '', 3, 75, 75, 10635, 10635, 0, 0, 8219, 35, 35, 1, 1, 1.14286, 1, 0, 342, 485, 0, 392, 1, 2000, 0, 1, 33024, 0, 0, 0, 0, 0, 0, 295, 438, 68, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
  3.  
  4. DELETE FROM `creature` WHERE `id`=35613;
  5. //INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (15893688, 35613, 530, 1, 1, 0, 0, -1955.1, 5162.83, -38.0777, 1.30189, 25, 5, 0, 10635, 0, 0, 0);
  6.  
  7. DELETE FROM gossip_menu WHERE entry = 3;
  8. INSERT INTO gossip_menu VALUES (3, 3, 0, 0, 0, 0, 0, 0);
  9.  
  10. DELETE FROM `npc_text` WHERE (`ID`=3);
  11. INSERT INTO `npc_text` VALUES ('3','Informace o Season 7 na Valhalle:$BSezona zaciná 1.cervna a konci 31.zari. U nekterych itemu u vendoru neni zobrazen potrebny rating, ten najdete zde nebo na foru. $B$BCeny:$BLow Relentless zbrane: 1800 rating$B-- One Hand(38500 honoru, 1090 ap)$B-- Off Hand(16500 honoru, 450 ap)$B-- Caster 1H(50000 honoru, 1400 ap)$B-- Two Hand(55000 honoru, 1540 ap)$B$BHigh Relentless zbrane: 2100 rating$B-- One Hand(2283 ap)$B-- Off Hand(978 ap)$B-- Caster 1H(2739 ap)$B-- Two Hand(3261 ap)$B$BRelentless set itemy:$B-- Legy (2150ap, 1550 rat)$B-- Head (2150ap, 1900 rat)$B-- Chest (2150ap, 1700 rat)$B-- Rukavice (1300ap, 1400 rat)$B-- Ramena (1750ap, 2050 rat)$B$BRelentless doplnky:$B-- Wrist (31000 honoru, 1630 rat)$B-- Waist (47400 honoru, 1650 rat)$B-- Boty (47400 honoru, 1690 rat)$B-- Neck (47000 honoru, 1750 rat)$B-- Finger (31000 honoru, 1720 rat)$B-- Back (47400 honoru, 1750 rat)$B$BRelentless tabard: 600 ap, 2150 rat$B$BDeadly zbrane:$B-- One Hand(43300 honoru)$B-- Off Hand(21000 honoru)$B-- Caster 1H(54500 honoru)$B-- Two Hand(68200 honoru)$B$BOdmeny za rating ziskany v 3v3 a 5v5:$B-- Titan-Forged ramena (1750ap, 2000 rat)$B-- Alternativní "Medallion" (60000 honoru, 1700 rat)$B-- WG neck (52200 honoru, 1600 rat)$B-- WG back (43400 honoru, 1500 rat)$B$B ceny u furi itemu jsou stejne jako byli v minule sezone u deadly$B$Bpresnejsi informace o sezone najdete na forku$B', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement