Register for your free account! | Forgot your password?

You last visited: Today at 00:42

  • 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   #2
 
elite*gold: 2693
Join Date: Jul 2010
Posts: 6,449
Received Thanks: 1,224
Sehr gute Arbeit, großer!


°"Crazy"° is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 00:42.


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

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