Buffzeug und Reagenzienvendor

n1_Roxxer · 04/28/2011, 11:10

Ich habe einen Vendor erstellt, welcher Buffzeug und Reagenzien verkäuft. Er enthält folgendes in 255er Stacks (vorrausgesetzt ihr batcht das UPDATE mit):

-Das beste Kochkunstessen
-Die 4 guten Alchitränke (also Frostwyrm etc.)
-Die 6 Schriftrollen für Ausdauer, Beweglichkeit usw.
-Die 2 Trommeln der Lederverarbeitung
-Reagenzien für die Klassen (für Battlerez, grp. Buff, Ankh undso)

Die SQL stammt von mir, ihr dürft sie gerne verwenden und weiterbearbeiten aber ich fände es angebracht wenn ihr sie nicht als euer Eigentum, sondern eher als meine Arbeit verwenden/weitergeben würdet.

LG

Code:

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 (80100, 0, 0, 0, 0, 0, 15369, 0, 0, 0, 'Harald', 'Buffzeug und Reagenzien', '', 0, 75, 75, 2, 35, 35, 128, 1, 1.14286, 2.5, 0, 342, 485, 0, 392, 1, 2000, 0, 1, 0, 8, 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, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 12340);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 5565, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 16583, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 17033, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 17031, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 17030, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 17029, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 17020, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 42996, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 43000, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 43001, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34767, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 42999, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 43005, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34758, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 42995, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34754, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34766, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 42994, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 42997, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34757, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 42998, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34769, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34768, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 42993, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34756, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 34755, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 44953, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 46377, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 46376, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 46378, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 46379, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 40195, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 49632, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 43464, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 43466, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 37092, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 37098, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 37094, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 49633, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 49634, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 6265, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 17032, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 21177, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 22147, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 22148, 0, 0, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (80100, 0, 37201, 0, 0, 0);
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=42996;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=43000;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=43001;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34767;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=42999;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=43005;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34758;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=42995;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34754;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34766;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=42994;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=42997;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34757;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=42998;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34769;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34768;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=42993;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34756;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=34755;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=44953;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=46377;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=46376;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=46378;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=46379;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=40195;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=49632;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=43464;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=43466;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=37092;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=37098;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=37094;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=49633;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=49634;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=6265;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=17032;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=21177;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=22147;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=22148;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=37201;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=5565;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=16583;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=17033;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=17031;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=17030;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=17029;
UPDATE `item_template` SET `buycount`=255, `maxcount`=5000, `stackable`=255 WHERE `entry`=17020;

°"Crazy"° · 04/29/2011, 21:05

Sehr gute Arbeit, großer!