Buffer NPC pár darab buffal
Letöltés: http://filebeam.com/6a57ffc7e08838973a0ee7c2d08945cc
Importáljátok be adatbázisba, indítsátok újra a szervert és tegyétek le.
ID: 400000
SQL Tartalma:
IdézSET @BUFFNPC := 400000; -- # (Entry ID of the NPC)
SET @GOPTION := 40000; -- # (--)
SET @GMENU := @GOPTION; -- # (--) Changes as Goption changes
SET @GSCRIPT := 40000; -- # (--)
SET @NPCTXT := 400000; -- # (--)
SET @DISPLAY := 28213; -- # (DisplayID of the NPC)
DELETE FROM creature_template WHERE entry=@BUFFNPC;
DELETE FROM gossip_menu WHERE entry=@GMENU OR entry=@GMENU+1 OR entry=@GMENU+2 OR entry=@GMENU+3 OR entry=@GMENU+4 OR entry=@GMENU+5 OR entry=@GMENU+6 OR entry=@GMENU+7 OR entry=@GMENU+8;
DELETE FROM gossip_menu_option WHERE menu_id=@GOPTION OR menu_id=@GOPTION+1 OR menu_id=@GOPTION+2 OR menu_id=@GOPTION+3 OR menu_id=@GOPTION+4 OR menu_id=@GOPTION+5 OR menu_id=@GOPTION+6 OR menu_id=@GOPTION+7 OR menu_id=@GOPTION+8;
DELETE FROM gossip_scripts WHERE id>@GSCRIPT-1 AND id<@GSCRIPT+135;
DELETE FROM npc_text WHERE ID=@NPCTXT OR ID=@NPCTXT+1 OR ID=@NPCTXT+2 OR ID=@NPCTXT+3 OR ID=@NPCTXT+4;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup>=@GOPTION AND SourceGroup<=@GOPTION+6 AND ConditionTypeOrReference=6 AND (ConditionValue1=469 OR ConditionValue1=67);
DELETE FROM conditions WHERE SourceTypeOrReferenceId=14 AND SourceGroup=@GMENU AND (SourceEntry=@NPCTXT+1 OR SourceEntry=@NPCTXT) AND ConditionTypeOrReference=6 AND (ConditionValue1=469 OR ConditionValue1=67);
INSERT INTO creature_template (entry,modelid1,name,subname,IconName,gossip_menu_id,minlevel,maxlevel,Health_mod,Mana_mod,Armor_mod,faction_A,faction_H,npcflag,speed_walk,speed_run,scale,rank,dmg_multiplier,unit_class,unit_flags,type,type_flags,InhabitType,RegenHealth,flags_extra)
VALUES (@BUFFNPC,@DISPLAY,'Bubblez','Buffer','Directions',@GMENU,71,71,1.56,1.56,1.56,35,35,3,1,1.14286,1,1,1,1,2,7,138936390,3,1,2);
-- # Linking texts to the menus
INSERT INTO gossip_menu (entry, text_id)
VALUES (@GMENU, @NPCTXT);
-- # Gossip options
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text)
VALUES
(@GOPTION, 1, 2, '|cffffffffPower Word: Fortitude', 1, 1, @GOPTION, 0, @GSCRIPT, 0, 0, NULL),
(@GOPTION, 2, 2, '|cffffffffDivine Spirit', 1, 1, @GOPTION, 0, @GSCRIPT+1, 0, 0, NULL),
(@GOPTION, 3, 2, '|cffffffffShadow Protection', 1, 1, @GOPTION, 0, @GSCRIPT+2, 0, 0, NULL),
(@GOPTION, 4, 2, '|cffffffffArcane Intellect', 1, 1, @GOPTION, 0, @GSCRIPT+3, 0, 0, NULL),
(@GOPTION, 5, 2, '|cffffffffDalaran Inellect', 1, 1, @GOPTION, 0, @GSCRIPT+4, 0, 0, NULL),
(@GOPTION, 6, 2, '|cffffffffBlessing of Kings', 1, 1, @GOPTION, 0, @GSCRIPT+5, 0, 0, NULL),
(@GOPTION, 7, 2, '|cffffffffBlessing of Might', 1, 1, @GOPTION, 0, @GSCRIPT+6, 0, 0, NULL),
(@GOPTION, 8, 2, '|cffffffffBlessing of Wisdom', 1, 1, @GOPTION, 0, @GSCRIPT+7, 0, 0, NULL),
(@GOPTION, 9, 2, '|cffffffffBlessing of Santuary', 1, 1, @GOPTION, 0, @GSCRIPT+8, 0, 0, NULL),
(@GOPTION, 10, 2, '|cffffffffMark of the Wild', 1, 1, @GOPTION, 0, @GSCRIPT+9, 0, 0, NULL);
-- # Text shown in the menus
INSERT INTO npc_text (ID, text0_0, em0_1)
VALUES
(@NPCTXT, '$B |cff00ff00Azeroth-Gaming!$B $B Buffer $B', 6);
-- -----------------------------------------------------------------------------------------------------------------------------
-- # Buffing scripts
INSERT INTO gossip_scripts (id, delay, command, datalong, datalong2, dataint, x, y, z, o)
VALUES (@GSCRIPT, 0, 15, 48161, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+1, 0, 15, 48073, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+2, 0, 15, 48169, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+3, 0, 15, 42995, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+4, 0, 15, 61024, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+5, 0, 15, 25898, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+6, 0, 15, 48934, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+7, 0, 15, 48938, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+8, 0, 15, 25899, 3, 0, 0, 0, 0, 0),
(@GSCRIPT+9, 0, 15, 48469, 3, 0, 0, 0, 0, 0);
oregon-Trinity the burning crusrade 2.4.3 as szerveremre is lenne egy ilyen buffer npc? (level 70 es buffokal)?
paladin: Természetesen lehet! De nem tudom hogy hány ember fogja megcsinálni neked itt ...De lehetséges olyat készíteni
Ha nem csinálja meg senki az se baj, mert igazából készítettem egy vendort és abba szerettem volna rakni ingyen megvásárolhato buffokat.. (tekercsfélék tod ) megveszed felrakod amagdra a buffot és éljen!... De wowheadon nem találok level 70 es buffot ami jó 2.4.3-ra, Hol keressek? 2.4.3 as a szerom...
tiszta dj XD
paladin: Ennyire butus vagy? XD Keress a játékba :) Nem hiszem el hogy a te 2.4.3 as szerodon nincs olyan kaszt aminek van buffja :S
Methos: Arra nem gondoltál h ő DJ ? XD
Szép munka ; +1!
Frissítve SAI-ra
-- Based on the work of hrr_95
-- Copyright © Hex.
-- Permission is granted to copy, distribute and/or modify this document
-- under the terms of the GNU Free Documentation License, Version 1.3
-- or any later version published by the Free Software Foundation;
-- with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts.
-- A copy of the license is included in the section entitled "GNU
-- Free Documentation License".
SET @NPC :=xxx; -- Entry of the creature.
SET @DISPLAY :=xxx; -- Modellid of the creature
SET @GOPTION :=xxx; -- Gossip_menu_option /needed 10/
SET @GOMENU :=@GOPTION; -- Gossip_menu entry
SET @NPCTEXT :=xxx; -- Displayed text
INSERT 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`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
(@NPC, 0, 0, 0, 0, 0, @DISPLAY, 0, 0, 0, 'Buffer Mage', 'Since PreBC', NULL, @GOMENU, 80, 80, 2, 35, 35, 3, 1, 1, 1, 1, 422, 586, 0, 642, 1, 2000, 2200, 2, 8, 4, 0, 0, 0, 0, 0, 345, 509, 103, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 0);
--
INSERT INTO gossip_menu (entry, text_id)
VALUES (@GOMENU, @NPCTEXT);
--
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text)
VALUES
(@GOPTION, 1, 0, 'Power Word: Fortitude', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 2, 0, 'Divine Spirit', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 3, 0, 'Shadow Protection', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 4, 0, 'Arcane Intellect', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 5, 0, 'Dalaran Inellect', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 6, 0, 'Blessing of Kings', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 7, 0, 'Blessing of Might', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 8, 0, 'Blessing of Wisdom', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 9, 0, 'Blessing of Santuary', 1, 1, 0, 0, 0, 0, 0, NULL),
(@GOPTION, 10, 0, 'Mark of the Wild', 1, 1, 0, 0, 0, 0, 0, NULL);
--
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 0, 0, 62, 0, 100, 1, @GOPTION, 1, 0, 0, 85, 48161, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Power of Word:Fortitude');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 1, 0, 62, 0, 100, 1, @GOPTION, 2, 0, 0, 85, 48073, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Divine Spirit');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 2, 0, 62, 0, 100, 1, @GOPTION, 3, 0, 0, 85, 48169, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Shadow Protection');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 3, 0, 62, 0, 100, 1, @GOPTION, 4, 0, 0, 85, 42995, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Arcane Intellect');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 4, 0, 62, 0, 100, 1, @GOPTION, 5, 0, 0, 85, 61024, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Dalaran Intellect');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 5, 0, 62, 0, 100, 1, @GOPTION, 6, 0, 0, 85, 20217, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Kings');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 6, 0, 62, 0, 100, 1, @GOPTION, 7, 0, 0, 85, 48932, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Might');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 7, 0, 62, 0, 100, 1, @GOPTION, 8, 0, 0, 85, 48936, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Wisdom');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 8, 0, 62, 0, 100, 1, @GOPTION, 9, 0, 0, 85, 20911, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Sanctuary');
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NPC, 0, 9, 0, 62, 0, 100, 1, @GOPTION, 10, 0, 0, 85, 48469, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Mark of the Wild');
Szuper az npc... nálam igen jó.. köszi.:)