Buffer Npc

[IrOn]

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:

SET @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);

[paladin]

oregon-Trinity the burning crusrade 2.4.3 as szerveremre is lenne egy ilyen buffer npc? (level 70 es buffokal)?

[LuXXoR]

paladin: Természetesen lehet! De nem tudom hogy hány ember fogja megcsinálni neked itt ...De lehetséges olyat készíteni

[paladin]

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...

[Methos]

tiszta dj XD

[LuXXoR]

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

[Explo]

Szép munka ; +1!

[Hex]

Frissítve SAI-ra

Kód Kijelölés Kibont


-- 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');

[xD]

Szuper az npc... nálam igen jó.. köszi.