Ahoj,pls chtel bych udelat,ze by tyto itemy co jsou ve vendorovi stali 40g(Všechny)PLS upravil by mi to nekdo ja jsem zkousel
(500006, 28963, 0, tohle, 0),
a
(500006, 28963, tohle, 0, 0),
ale ani jedno
DELETE FROM `creature_template` WHERE (`entry`=500006);
INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (500006, 0, 15511, 0, 15511, 0, 'Raid Tier 4 Vendor', 'Server Vendors', '', 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4225, 1.15, 1, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 0, 1, 0, 0, 0, '');
-- 21.8.2008 22:38:15
DELETE FROM `npc_vendor` WHERE (`entry`=500006);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES
(500006, 28963, 0, 0, 0),
(500006, 28964, 0, 0, 0),
(500006, 28966, 0, 0, 0),
(500006, 28967, 0, 0, 0),
(500006, 28968, 0, 0, 0),
(500006, 29011, 0, 0, 0),
(500006, 29012, 0, 0, 0),
(500006, 29015, 0, 0, 0),
(500006, 29016, 0, 0, 0),
(500006, 29017, 0, 0, 0),
(500006, 29019, 0, 0, 0),
(500006, 29020, 0, 0, 0),
(500006, 29021, 0, 0, 0),
(500006, 29022, 0, 0, 0),
(500006, 29023, 0, 0, 0),
(500006, 29028, 0, 0, 0),
(500006, 29029, 0, 0, 0),
(500006, 29030, 0, 0, 0),
(500006, 29031, 0, 0, 0),
(500006, 29032, 0, 0, 0),
(500006, 29033, 0, 0, 0),
(500006, 29034, 0, 0, 0),
(500006, 29035, 0, 0, 0),
(500006, 29036, 0, 0, 0),
(500006, 29037, 0, 0, 0),
(500006, 29038, 0, 0, 0),
(500006, 29039, 0, 0, 0),
(500006, 29040, 0, 0, 0),
(500006, 29042, 0, 0, 0),
(500006, 29043, 0, 0, 0),
(500006, 29044, 0, 0, 0),
(500006, 29045, 0, 0, 0),
(500006, 29046, 0, 0, 0),
(500006, 29047, 0, 0, 0),
(500006, 29048, 0, 0, 0),
(500006, 29049, 0, 0, 0),
(500006, 29050, 0, 0, 0),
(500006, 29053, 0, 0, 0),
(500006, 29054, 0, 0, 0),
(500006, 29055, 0, 0, 0),
(500006, 29056, 0, 0, 0),
(500006, 29057, 0, 0, 0),
(500006, 29058, 0, 0, 0),
(500006, 29059, 0, 0, 0),
(500006, 29060, 0, 0, 0),
(500006, 29061, 0, 0, 0),
(500006, 29062, 0, 0, 0),
(500006, 29063, 0, 0, 0),
(500006, 29064, 0, 0, 0),
(500006, 29065, 0, 0, 0),
(500006, 29066, 0, 0, 0),
(500006, 29067, 0, 0, 0),
(500006, 29068, 0, 0, 0),
(500006, 29069, 0, 0, 0),
(500006, 29070, 0, 0, 0),
(500006, 29071, 0, 0, 0),
(500006, 29072, 0, 0, 0),
(500006, 29073, 0, 0, 0),
(500006, 29074, 0, 0, 0),
(500006, 29075, 0, 0, 0),
(500006, 29076, 0, 0, 0),
(500006, 29077, 0, 0, 0),
(500006, 29078, 0, 0, 0),
(500006, 29079, 0, 0, 0),
(500006, 29080, 0, 0, 0),
(500006, 29081, 0, 0, 0),
(500006, 29082, 0, 0, 0),
(500006, 29083, 0, 0, 0),
(500006, 29084, 0, 0, 0),
(500006, 29085, 0, 0, 0),
(500006, 29086, 0, 0, 0),
(500006, 29087, 0, 0, 0),
(500006, 29088, 0, 0, 0),
(500006, 29089, 0, 0, 0),
(500006, 29090, 0, 0, 0),
(500006, 29091, 0, 0, 0),
(500006, 29092, 0, 0, 0),
(500006, 29093, 0, 0, 0),
(500006, 29094, 0, 0, 0),
(500006, 29095, 0, 0, 0),
(500006, 29096, 0, 0, 0),
(500006, 29097, 0, 0, 0),
(500006, 29098, 0, 0, 0),
(500006, 29099, 0, 0, 0),
(500006, 29100, 0, 0, 0);