Register for your free account! | Forgot your password?

You last visited: Today at 04:54

  • Please register to post and access all features, it's quick, easy and FREE!


Buffzeug und Reagenzienvendor

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2010
Posts: 477
Received Thanks: 133
Buffzeug und Reagenzienvendor

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;



n1_Roxxer is offline  
Thanks
1 User
Old 04/29/2011, 21:05   #2
Veteran


 
elite*gold: 1553
Join Date: Jul 2010
Posts: 6,639
Received Thanks: 1,303
Sehr gute Arbeit, großer!


°"Crazy"° is offline  
Thanks
1 User
Reply



« Project of new International server ! NEED HELP | WoW Mangos Items Einfügen »



All times are GMT +2. The time now is 04:54.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.