Ru-MaNGOS

Ru-MaNGOS (http://mangos.ytdb.ru/index.php)
-   MaNGOSZero (1.12.X) (http://mangos.ytdb.ru/forumdisplay.php?f=48)
-   -   [FAN] Loot & items ... и прочие хаки. (http://mangos.ytdb.ru/showthread.php?t=3880)

Mediv 12.03.2011 20:21
[FAN] Loot & items ... и прочие хаки.
 
Desecrated items FIX

Делает Desecrated формы контейнерами с флагом 4 и добавляет рандомное выпадение 1-й вещи из всех возможных.

Избавляет от проблемы нехватки нужных квестов или невозможности обменять формы на вещи (в базе не реализована такая возможность).

После применения нужно стереть папку WDB (кэш) у клиента.

=DOWNLOAD=

Код:
UPDATE `item_template` SET `Flags` = 4 WHERE `entry` IN (22370, 22369, 22365, 22355, 22349, 22367, 22357, 22363, 22371, 22364, 22360, 22353, 22366, 22359, 22352, 22354, 22351, 22358, 22372, 22368, 22361, 22350, 22356, 22362);

INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('22370','22502','0','1','1','1','0','0','0'),
('22370','22510','0','1','1','1','0','0','0'),
('22370','22518','0','1','1','1','0','0','0'),
('22369','22503','0','1','1','1','0','0','0'),
('22369','22511','0','1','1','1','0','0','0'),
('22369','22519','0','1','1','1','0','0','0'),
('22365','22430','0','1','1','1','0','0','0'),
('22365','22440','0','1','1','1','0','0','0'),
('22365','22468','0','1','1','1','0','0','0'),
('22365','22492','0','1','1','1','0','0','0'),
('22355','22423','0','1','1','1','0','0','0'),
('22355','22483','0','1','1','1','0','0','0'),
('22349','22416','0','1','1','1','0','0','0'),
('22349','22476','0','1','1','1','0','0','0'),
('22367','22498','0','1','1','1','0','0','0'),
('22367','22506','0','1','1','1','0','0','0'),
('22367','22514','0','1','1','1','0','0','0'),
('22357','22421','0','1','1','1','0','0','0'),
('22357','22481','0','1','1','1','0','0','0'),
('22363','22431','0','1','1','1','0','0','0'),
('22363','22442','0','1','1','1','0','0','0'),
('22363','22470','0','1','1','1','0','0','0'),
('22363','22494','0','1','1','1','0','0','0'),
('22371','22501','0','1','1','1','0','0','0'),
('22371','22509','0','1','1','1','0','0','0'),
('22371','22517','0','1','1','1','0','0','0'),
('22364','22426','0','1','1','1','0','0','0'),
('22364','22441','0','1','1','1','0','0','0'),
('22364','22469','0','1','1','1','0','0','0'),
('22364','22493','0','1','1','1','0','0','0'),
('22360','22428','0','1','1','1','0','0','0'),
('22360','22438','0','1','1','1','0','0','0'),
('22360','22466','0','1','1','1','0','0','0'),
('22360','22490','0','1','1','1','0','0','0'),
('22353','22418','0','1','1','1','0','0','0'),
('22353','22478','0','1','1','1','0','0','0'),
('22366','22497','0','1','1','1','0','0','0'),
('22366','22505','0','1','1','1','0','0','0'),
('22366','22513','0','1','1','1','0','0','0'),
('22359','22427','0','1','1','1','0','0','0'),
('22359','22437','0','1','1','1','0','0','0'),
('22359','22465','0','1','1','1','0','0','0'),
('22359','22489','0','1','1','1','0','0','0'),
('22352','22417','0','1','1','1','0','0','0'),
('22352','22477','0','1','1','1','0','0','0'),
('22354','22419','0','1','1','1','0','0','0'),
('22354','22479','0','1','1','1','0','0','0'),
('22351','22496','0','1','1','1','0','0','0'),
('22351','22504','0','1','1','1','0','0','0'),
('22351','22512','0','1','1','1','0','0','0'),
('22358','22420','0','1','1','1','0','0','0'),
('22358','22480','0','1','1','1','0','0','0'),
('22372','22500','0','1','1','1','0','0','0'),
('22372','22508','0','1','1','1','0','0','0'),
('22372','22516','0','1','1','1','0','0','0'),
('22368','22499','0','1','1','1','0','0','0'),
('22368','22507','0','1','1','1','0','0','0'),
('22368','22515','0','1','1','1','0','0','0'),
('22361','22429','0','1','1','1','0','0','0'),
('22361','22439','0','1','1','1','0','0','0'),
('22361','22467','0','1','1','1','0','0','0'),
('22361','22491','0','1','1','1','0','0','0'),
('22350','22425','0','1','1','1','0','0','0'),
('22350','22436','0','1','1','1','0','0','0'),
('22350','22464','0','1','1','1','0','0','0'),
('22350','22488','0','1','1','1','0','0','0'),
('22356','22422','0','1','1','1','0','0','0'),
('22356','22482','0','1','1','1','0','0','0'),
('22362','22424','0','1','1','1','0','0','0'),
('22362','22443','0','1','1','1','0','0','0'),
('22362','22495','0','1','1','1','0','0','0'),
('22362','22471','0','1','1','1','0','0','0');

Mediv 13.03.2011 21:02
Sir Zeliek and Lady Blaumeux loot FIX

Удаляет ящик с Ашбрингером и распределяет его лут по 2-м боссам.

Исключает возможность халявно нажиться используя стелс или бабл.

=DOWNLOAD=

Код:
DELETE FROM `gameobject` WHERE `id` IN (181366);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('16063','22691','0','2','1','1','0','0','0'),
('16063','22726','30','0','1','1','0','0','0'),
('16063','23027','0','2','1','1','0','0','0'),
('16063','22811','0','2','1','1','0','0','0'),
('16065','12002','100','1','-12002','2','0','0','0'),
('16065','22809','0','2','1','1','0','0','0'),
('16065','23025','0','2','1','1','0','0','0'),
('16065','23071','0','2','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 16063 WHERE `entry` IN (16063);
UPDATE `creature_template` SET `lootid` = 16065 WHERE `entry` IN (16065);

YuruY 13.03.2011 21:33
Както несерьезно оформил.

Mediv 13.03.2011 21:34
Цитата:
Сообщение от YuruY (Сообщение 19945)
Както несерьезно оформил.
Косяк исправил, перезалил.

В смысле?) Поправляй если что) Это первый опыт так сказать =)))

Mediv 08.04.2011 19:29
Balnazaar, Sothos and Jarien loot FIX
 
Balnazaar, Sothos and Jarien loot FIX

Патч исправляет отсутствие/кривой лут этих трех НПС (Stratholme).

=DOWNLOAD=

Код:
DELETE FROM `creature_loot_template` WHERE `entry` IN (10813, 16101, 16102);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('10813','13353','1.37','0','1','1','0','0','0'),
('10813','14512','3.02','0','1','1','0','0','0'),
('10813','14154','10','0','1','1','0','0','0'),
('10813','16725','11.11','0','1','1','0','0','0'),
('10813','13369','14.84','0','1','1','0','0','0'),
('10813','18720','10.54','0','1','1','0','0','0'),
('10813','13358','11.58','0','1','1','0','0','0'),
('10813','13359','13.94','0','1','1','0','0','0'),
('10813','18718','10.16','0','1','1','0','0','0'),
('10813','13360','13.66','0','1','1','0','0','0'),
('10813','13348','13.94','0','1','1','0','0','0'),
('10813','18717','11.91','0','1','1','0','0','0'),
('10813','12103','12.48','0','1','1','0','0','0'),
('10813','13520','1.94','0','1','1','0','0','0'),
('16101','22301','19','0','1','1','0','0','0'),
('16101','22328','21.27','0','1','1','0','0','0'),
('16101','22329','28.51','0','1','1','0','0','0'),
('16101','22334','17.19','0','1','1','0','0','0'),
('16101','22327','14.03','0','1','1','0','0','0'),
('16101','21984','-100','0','1','1','0','0','0'),
('16101','22046','-100','0','1','1','0','0','0'),
('16102','22301','19','0','1','1','0','0','0'),
('16102','22328','21.27','0','1','1','0','0','0'),
('16102','22329','28.51','0','1','1','0','0','0'),
('16102','22334','17.19','0','1','1','0','0','0'),
('16102','22327','14.03','0','1','1','0','0','0'),
('16102','21984','-100','0','1','1','0','0','0'),
('16102','22046','-100','0','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 10813 WHERE `entry` IN (10813);
UPDATE `creature_template` SET `lootid` = 16101 WHERE `entry` IN (16101);
UPDATE `creature_template` SET `lootid` = 16102 WHERE `entry` IN (16102);

Mediv 10.04.2011 18:52
Lord Valthalak loot FIX
 
Lord Valthalak loot FIX

Добавление отсутствующего лута для босса Lord Valthalak (Black Rock Spire Upper)

=DOWNLOAD=

Код:
DELETE FROM `creature_loot_template` WHERE `entry` IN (16042);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('16042','22302','27.72','0','1','1','0','0','0'),
('16042','22337','23.37','0','1','1','0','0','0'),
('16042','22342','23.10','0','1','1','0','0','0'),
('16042','22343','20.11','0','1','1','0','0','0'),
('16042','22335','14.67','0','1','1','0','0','0'),
('16042','22336','17.66','0','1','1','0','0','0'),
('16042','22339','15.49','0','1','1','0','0','0'),
('16042','22340','17.66','0','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 16042 WHERE `entry` IN (16042);
Warchief Rend Blackhand loot FIX

Фикс добавляет лут боссу, изменяет параметр armor.

=DOWNLOAD=

Код:
DELETE FROM `creature_loot_template` WHERE `entry` IN (10429);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('10429','12590','1.06','0','1','1','0','0','0'),
('10429','16733','13.39','0','1','1','0','0','0'),
('10429','22247','12.71','0','1','1','0','0','0'),
('10429','18102','14.35','0','1','1','0','0','0'),
('10429','12587','14.50','0','1','1','0','0','0'),
('10429','18104','15.30','0','1','1','0','0','0'),
('10429','12588','0.85','0','1','1','0','0','0'),
('10429','12935','15.05','0','1','1','0','0','0'),
('10429','12936','16.96','0','1','1','0','0','0'),
('10429','12939','7.61','0','1','1','0','0','0'),
('10429','12940','6.79','0','1','1','0','0','0'),
('10429','12583','7.44','0','1','1','0','0','0'),
('10429','18103','15.38','0','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 10429 WHERE `entry` IN (10429);

UPDATE `creature_template` SET `armor` = 6000 WHERE `entry` IN (10429);
Amulet of Union loot FIX

Исправляет дроп пяти самоцветов и амулета духов для создания Amulet of Union

=DOWNLOAD=

Код:
DELETE FROM `creature_loot_template` WHERE `entry` IN (12240, 13742, 12239, 13741, 12241, 13740, 12242, 13739, 13738, 12243, 13718);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('12240','17761','100','0','1','1','0','0','0'),
('13742','17761','100','0','1','1','0','0','0'),
('12239','17762','100','0','1','1','0','0','0'),
('13741','17762','100','0','1','1','0','0','0'),
('12241','17763','100','0','1','1','0','0','0'),
('13740','17763','100','0','1','1','0','0','0'),
('12242','17764','100','0','1','1','0','0','0'),
('13739','17764','100','0','1','1','0','0','0'),
('13738','17765','100','0','1','1','0','0','0'),
('12243','17765','100','0','1','1','0','0','0'),
('13718','17757','100','0','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 12240 WHERE `entry` IN (12240);
UPDATE `creature_template` SET `lootid` = 13742 WHERE `entry` IN (13742);
UPDATE `creature_template` SET `lootid` = 12239 WHERE `entry` IN (12239);
UPDATE `creature_template` SET `lootid` = 13741 WHERE `entry` IN (13741);
UPDATE `creature_template` SET `lootid` = 12241 WHERE `entry` IN (12241);
UPDATE `creature_template` SET `lootid` = 13740 WHERE `entry` IN (13740);
UPDATE `creature_template` SET `lootid` = 12242 WHERE `entry` IN (12242);
UPDATE `creature_template` SET `lootid` = 13739 WHERE `entry` IN (13739);
UPDATE `creature_template` SET `lootid` = 13738 WHERE `entry` IN (13738);
UPDATE `creature_template` SET `lootid` = 12243 WHERE `entry` IN (12243);
UPDATE `creature_template` SET `lootid` = 13718 WHERE `entry` IN (13718);

BloodWarrior 10.04.2011 18:57
Медив, а может ты на paste2.org буиш распологать свои патчики?
Ну и ссылками сюда.
А то качать микроархивчики с файлбима - какой-то извращенный способ.

Lordronn 10.04.2011 19:40
Ну или в под хайд\ в аттач пихай

Mediv 11.04.2011 12:47
Да вобщем то вроде и так удобно) Я придумаю что-нибудь ещё.

Mediv 13.04.2011 23:49
Portal Spawns

Добавляет порталы по городам в соотношении 3 штуки на город.

=DOWNLOAD=

Код:
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES

('500024','176500','1','1472.4','-4214.37','58.9939','1.18515','0','0','0.5585','0.829505','25','100','1'),
('500022','176497','1','9633.73','2515.15','1331.54','1.31642','0','0','0.611701','0.791089','25','100','1'),
('500020','176296','1','9638.24','2531.07','1331.56','4.45408','0','0','0.79229','-0.610145','25','100','1'),
('500016','176499','1','-953.82','289.415','109.83','5.78068','0','0','0.248619','-0.968601','25','100','1'),
('500014','176501','1','-974.05','296.006','109.817','2.92968','0','0','0.994392','0.10576','25','100','1'),
('500013','176501','1','1467.68','-4227.25','58.9939','1.2087','0','0','0.568229','0.82287','25','100','1'),
('500012','176499','0','1772.22','70.2139','-46.3213','1.51851','0','0','0.688381','0.72535','25','100','1'),
('500011','176500','0','1763.96','62.1076','-46.3213','3.1004','0','0','0.999788','0.0205952','25','100','1'),
('500010','176498','0','-8994.51','844.666','29.6206','4.85493','0','0','0.654959','-0.755665','25','100','1'),
('500008','176497','0','-8981.44','854.3','29.6206','3.31946','0','0','0.996048','-0.0888143','25','100','1'),
('500007','176296','0','-4671.01','-950.097','500.377','5.4351','0','0','0.411449','-0.911433','25','100','1'),
('500006','176498','0','-4659.25','-963.725','500.377','0.722701','0','0','0.353538','0.93542','25','100','1');

UPDATE `gameobject_template` SET `data2` = 0 WHERE `entry` IN (176498,178404,176497,176499,176296,176500,176501);

Mediv 14.04.2011 00:50
Shaman Totems

Добавляет тотемы шаманам при старте.

=DOWNLOAD=

Код:
INSERT INTO `playercreateinfo_item` (`race`, `class`, `itemid`, `amount`) VALUES

('2','7','5175','1'),
('2','7','5176','1'),
('2','7','5177','1'),
('2','7','5178','1'),
('6','7','5175','1'),
('6','7','5176','1'),
('6','7','5177','1'),
('6','7','5178','1'),
('8','7','5175','1'),
('8','7','5176','1'),
('8','7','5177','1'),
('8','7','5178','1');
Спеллы:
Код:
REPLACE INTO npc_trainer SELECT `entry`, '3599', '0', '0', '0', '10' FROM `creature_template` WHERE `subname`='Shaman Trainer';

REPLACE INTO npc_trainer SELECT `entry`, '8071', '0', '0', '0', '4' FROM `creature_template` WHERE `subname`='Shaman Trainer';

REPLACE INTO npc_trainer SELECT `entry`, '5394', '0', '0', '0', '4' FROM `creature_template` WHERE `subname`='Shaman Trainer';

BloodWarrior 14.04.2011 06:12
Это для фан? Или в процессе игры у шоменов выходят всякие косяки с получением тотемов на зеро?

Mediv 14.04.2011 10:02
Цитата:
Сообщение от BloodWarrior (Сообщение 21032)
Это для фан? Или в процессе игры у шоменов выходят всякие косяки с получением тотемов на зеро?
Да именно косяки.

Добавлено через 23 минуты
Error Vendor

Собственно просто вендор (ID 100001)

=DOWNLOAD=

Код:
INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES

('100001','0','0','2345','2345','Error Vendor','Server Vendors','0','81','81','10000','10000','10000','10000','1','35','35','6','1','2','1','1','10000','10000','0','10000','1','1600','1760','0','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','1','0','1','0','0','0','0','0','');

INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`) VALUES

('100001','21210','0','0'),
('100001','21205','0','0'),
('100001','21200','0','0'),
('100001','20867','0','0'),
('100001','16309','0','0'),
('100001','9240','0','0'),
('100001','8529','0','0');
Добавлено через 9 минут
Dungeon 1 Vendor

Добавляет вендора с комплектами сетов Dangeon 0.0, Dangeon 0.5 (ID 100002)

=DOWNLOAD=

1) Создаем контейнеры для сета Dangeon 0.0 (ЧАСТЬ 1)

Код:

INSERT INTO `item_template` (`entry`, `class`, `subclass`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`, `ExtraFlags`) VALUES

('50019','15','0','Tier 0.0 Container Priest','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50018','15','0','Tier 0.0 Container Hunter','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50017','15','0','Tier 0.0 Container Warlock','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50016','15','0','Tier 0.0 Container Rogue','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50015','15','0','Tier 0.0 Container Paladin','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50014','15','0','Tier 0.0 Container Mage','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50013','15','0','Tier 0.0 Container Shaman','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50012','15','0','Tier 0.0 Container Warrior','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50011','15','0','Tier 0.0 Container Druid','12334','1','4','1','25000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0');

Mediv 14.04.2011 10:07
2) Создаем контейнеры для сета Dungeon 0.5 (ЧАСТЬ 2)

Код:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`, `ExtraFlags`) VALUES

('50009','15','0','Tier 0.5 Container Priest','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50008','15','0','Tier 0.5 Container Hunter','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50007','15','0','Tier 0.5 Container Warlock','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50006','15','0','Tier 0.5 Container Rogue','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50005','15','0','Tier 0.5 Container Paladin','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50004','15','0','Tier 0.5 Container Mage','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50003','15','0','Tier 0.5 Container Shaman','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50002','15','0','Tier 0.5 Container Warrior','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0'),
('50001','15','0','Tier 0.5 Container Druid','17329','1','4','1','100000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0');

Mediv 14.04.2011 10:10
3) Добавляем в контейнеры лут (ЧАСТЬ 3)

Код:
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('50019','16697','100','0','1','1','0','0','0'),
('50019','16696','100','0','1','1','0','0','0'),
('50019','16695','100','0','1','1','0','0','0'),
('50019','16694','100','0','1','1','0','0','0'),
('50019','16693','100','0','1','1','0','0','0'),
('50019','16692','100','0','1','1','0','0','0'),
('50019','16691','100','0','1','1','0','0','0'),
('50019','16690','100','0','1','1','0','0','0'),
('50018','16681','100','0','1','1','0','0','0'),
('50018','16680','100','0','1','1','0','0','0'),
('50018','16679','100','0','1','1','0','0','0'),
('50018','16678','100','0','1','1','0','0','0'),
('50018','16677','100','0','1','1','0','0','0'),
('50018','16676','100','0','1','1','0','0','0'),
('50018','16675','100','0','1','1','0','0','0'),
('50018','16674','100','0','1','1','0','0','0'),
('50017','16705','100','0','1','1','0','0','0'),
('50017','16704','100','0','1','1','0','0','0'),
('50017','16703','100','0','1','1','0','0','0'),
('50017','16702','100','0','1','1','0','0','0'),
('50017','16701','100','0','1','1','0','0','0'),
('50017','16700','100','0','1','1','0','0','0'),
('50017','16699','100','0','1','1','0','0','0'),
('50017','16698','100','0','1','1','0','0','0'),
('50016','16721','100','0','1','1','0','0','0'),
('50016','16713','100','0','1','1','0','0','0'),
('50016','16712','100','0','1','1','0','0','0'),
('50016','16711','100','0','1','1','0','0','0'),
('50016','16710','100','0','1','1','0','0','0'),
('50016','16709','100','0','1','1','0','0','0'),
('50016','16708','100','0','1','1','0','0','0'),
('50016','16707','100','0','1','1','0','0','0'),
('50015','16729','100','0','1','1','0','0','0'),
('50015','16728','100','0','1','1','0','0','0'),
('50015','16727','100','0','1','1','0','0','0'),
('50015','16726','100','0','1','1','0','0','0'),
('50015','16725','100','0','1','1','0','0','0'),
('50015','16724','100','0','1','1','0','0','0'),
('50015','16723','100','0','1','1','0','0','0'),
('50015','16722','100','0','1','1','0','0','0'),
('50014','16689','100','0','1','1','0','0','0'),
('50014','16688','100','0','1','1','0','0','0'),
('50014','16687','100','0','1','1','0','0','0'),
('50014','16686','100','0','1','1','0','0','0'),
('50014','16685','100','0','1','1','0','0','0'),
('50014','16684','100','0','1','1','0','0','0'),
('50014','16683','100','0','1','1','0','0','0'),
('50014','16682','100','0','1','1','0','0','0'),
('50013','16673','100','0','1','1','0','0','0'),
('50013','16672','100','0','1','1','0','0','0'),
('50013','16671','100','0','1','1','0','0','0'),
('50013','16670','100','0','1','1','0','0','0'),
('50013','16669','100','0','1','1','0','0','0'),
('50013','16668','100','0','1','1','0','0','0'),
('50013','16667','100','0','1','1','0','0','0'),
('50013','16666','100','0','1','1','0','0','0'),
('50012','16737','100','0','1','1','0','0','0'),
('50012','16736','100','0','1','1','0','0','0'),
('50012','16735','100','0','1','1','0','0','0'),
('50012','16734','100','0','1','1','0','0','0'),
('50012','16733','100','0','1','1','0','0','0'),
('50012','16732','100','0','1','1','0','0','0'),
('50012','16731','100','0','1','1','0','0','0'),
('50012','16730','100','0','1','1','0','0','0'),
('50011','16720','100','0','1','1','0','0','0'),
('50011','16719','100','0','1','1','0','0','0'),
('50011','16718','100','0','1','1','0','0','0'),
('50011','16717','100','0','1','1','0','0','0'),
('50011','16716','100','0','1','1','0','0','0'),
('50011','16715','100','0','1','1','0','0','0'),
('50011','16714','100','0','1','1','0','0','0'),
('50011','16706','100','0','1','1','0','0','0'),
('50009','22085','100','0','1','1','0','0','0'),
('50009','22084','100','0','1','1','0','0','0'),
('50009','22083','100','0','1','1','0','0','0'),
('50009','22082','100','0','1','1','0','0','0'),
('50009','22081','100','0','1','1','0','0','0'),
('50009','22080','100','0','1','1','0','0','0'),
('50009','22079','100','0','1','1','0','0','0'),
('50009','22078','100','0','1','1','0','0','0'),
('50008','22061','100','0','1','1','0','0','0'),
('50008','22060','100','0','1','1','0','0','0'),
('50008','22017','100','0','1','1','0','0','0'),
('50008','22016','100','0','1','1','0','0','0'),
('50008','22015','100','0','1','1','0','0','0'),
('50008','22013','100','0','1','1','0','0','0'),
('50008','22011','100','0','1','1','0','0','0'),
('50008','22010','100','0','1','1','0','0','0'),
('50007','22077','100','0','1','1','0','0','0'),
('50007','22076','100','0','1','1','0','0','0'),
('50007','22075','100','0','1','1','0','0','0'),
('50007','22074','100','0','1','1','0','0','0'),
('50007','22073','100','0','1','1','0','0','0'),
('50007','22072','100','0','1','1','0','0','0'),
('50007','22071','100','0','1','1','0','0','0'),
('50007','22070','100','0','1','1','0','0','0'),
('50006','22009','100','0','1','1','0','0','0'),
('50006','22008','100','0','1','1','0','0','0'),
('50006','22007','100','0','1','1','0','0','0'),
('50006','22006','100','0','1','1','0','0','0'),
('50006','22005','100','0','1','1','0','0','0'),
('50006','22004','100','0','1','1','0','0','0'),
('50006','22003','100','0','1','1','0','0','0'),
('50006','22002','100','0','1','1','0','0','0'),
('50005','22093','100','0','1','1','0','0','0'),
('50005','22092','100','0','1','1','0','0','0'),
('50005','22091','100','0','1','1','0','0','0'),
('50005','22090','100','0','1','1','0','0','0'),
('50005','22089','100','0','1','1','0','0','0'),
('50005','22088','100','0','1','1','0','0','0'),
('50005','22087','100','0','1','1','0','0','0'),
('50005','22086','100','0','1','1','0','0','0'),
('50004','22069','100','0','1','1','0','0','0'),
('50004','22068','100','0','1','1','0','0','0'),
('50004','22067','100','0','1','1','0','0','0'),
('50004','22066','100','0','1','1','0','0','0'),
('50004','22065','100','0','1','1','0','0','0'),
('50004','22064','100','0','1','1','0','0','0'),
('50004','22063','100','0','1','1','0','0','0'),
('50004','22062','100','0','1','1','0','0','0'),
('50003','22102','100','0','1','1','0','0','0'),
('50003','22101','100','0','1','1','0','0','0'),
('50003','22100','100','0','1','1','0','0','0'),
('50003','22099','100','0','1','1','0','0','0'),
('50003','22098','100','0','1','1','0','0','0'),
('50003','22097','100','0','1','1','0','0','0'),
('50003','22096','100','0','1','1','0','0','0'),
('50003','22095','100','0','1','1','0','0','0'),
('50002','22001','100','0','1','1','0','0','0'),
('50002','22000','100','0','1','1','0','0','0'),
('50002','21999','100','0','1','1','0','0','0'),
('50002','21998','100','0','1','1','0','0','0'),
('50002','21997','100','0','1','1','0','0','0'),
('50002','21996','100','0','1','1','0','0','0'),
('50002','21995','100','0','1','1','0','0','0'),
('50002','21994','100','0','1','1','0','0','0'),
('50001','22113','100','0','1','1','0','0','0'),
('50001','22112','100','0','1','1','0','0','0'),
('50001','22111','100','0','1','1','0','0','0'),
('50001','22110','100','0','1','1','0','0','0'),
('50001','22109','100','0','1','1','0','0','0'),
('50001','22108','100','0','1','1','0','0','0'),
('50001','22107','100','0','1','1','0','0','0'),
('50001','22106','100','0','1','1','0','0','0');

Mediv 14.04.2011 10:31
4) Добавляем самого вендора с наборами сетов (ЧАСТЬ 4)

Код:
INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES

('100002','0','0','2345','2345','Dungeon 1 Vendor','Server Vendors','0','81','81','10000','10000','10000','10000','1','35','35','6','1','2','1','1','10000','10000','0','10000','1','1600','1760','0','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','1','0','1','0','0','0','0','0','');

INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`) VALUES

('100002','50019','0','0'),
('100002','50018','0','0'),
('100002','50017','0','0'),
('100002','50016','0','0'),
('100002','50015','0','0'),
('100002','50014','0','0'),
('100002','50013','0','0'),
('100002','50012','0','0'),
('100002','50011','0','0'),
('100002','50009','0','0'),
('100002','50008','0','0'),
('100002','50007','0','0'),
('100002','50006','0','0'),
('100002','50005','0','0'),
('100002','50004','0','0'),
('100002','50003','0','0'),
('100002','50002','0','0'),
('100002','50001','0','0');
Добавлено через 17 минут
Keys Vendor

Вендоры ключей для орды и альянса (ID 100003, ID 100004)

=DOWNLOAD=

Код:
DELETE FROM `creature_template` WHERE (`entry`=100003);
INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES ('100003', '0', '0', '7895', '7895', 'Keys Vendor', 'Server Vendors','0', '81', '81', '10000', '10000', '10000', '10000', '1', '35', '35', '6', '1', '2', '1', '1', '10000', '10000', '0', '10000', '1', '1600', '1760', '0', '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', '1', '0', '1', '0', '0', '0', '0', '0', '');

DELETE FROM `npc_vendor` WHERE (`entry`=100003);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES 

(100003, 18249, 0, 0),
(100003, 13873, 0, 0),
(100003, 7146, 0, 0),
(100003, 12382, 0, 0),
(100003, 11000, 0, 0),
(100003, 11140, 0, 0),
(100003, 12344, 0, 0),
(100003, 50021, 0, 0);

DELETE FROM `creature_template` WHERE (`entry`=100004);
INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES ('100004', '0', '0', '14415', '14415', 'Keys Vendor', 'Server Vendors','0', '81', '81', '10000', '10000', '10000', '10000', '1', '35', '35', '6', '1', '2', '1', '1', '10000', '10000', '0', '10000', '1', '1600', '1760', '0', '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', '1', '0', '1', '0', '0', '0', '0', '0', '');

DELETE FROM `npc_vendor` WHERE (`entry`=100004);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES 

(100004, 18249, 0, 0),
(100004, 13873, 0, 0),
(100004, 7146, 0, 0),
(100004, 12382, 0, 0),
(100004, 11000, 0, 0),
(100004, 11140, 0, 0),
(100004, 12344, 0, 0),
(100004, 50021, 0, 0);

UPDATE `item_template` SET `BuyPrice` = 500000 WHERE `entry` IN (18249, 13873, 7146, 12382, 11000, 11140);

UPDATE `item_template` SET `BuyPrice` = 1000000 WHERE `entry` IN (12344);


DELETE FROM `item_template` WHERE `entry` IN (50021);
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`, `ExtraFlags`) VALUES

('50021','15','0','QuestContainer for Naxxramas','15692','1','4','1','15000000','12','0','-1','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','internalitemhandler','0','0','0','0','0','0');

DELETE FROM `item_loot_template` WHERE `entry` IN (50021);
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('50021','12363','100','0','5','5','0','0','0'),
('50021','20725','100','0','2','2','0','0','0'),
('50021','12811','100','0','1','1','0','0','0');

DELETE FROM `creature` WHERE id IN (100003, 100004) AND guid IN (160389, 160390);

INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES

('160389','100003','0','0','0','-9445.29','96.7302','56.8768','5.79895','300','5','0','3000','10000','0','0'),
('160390','100004','1','0','0','1584.65','-4390.84','5.68912','5.00138','300','5','0','3000','10000','0','0');

Mediv 01.05.2011 12:24
First Aid Artisan HACK (Все тренеры)

Добавляет скилл First Aid Artisan всем тренерам. Требует навык First Aid = 200.

Код:
REPLACE INTO `npc_trainer` SELECT `entry`, '10847', '0', '129', '200', '0' FROM `creature_template` WHERE `subname`='First Aid Trainer';

Mediv 01.05.2011 13:07
Ragnaros loot FIX

Фикс добавляет лут и самого босса.

Код:
DELETE FROM `creature` WHERE `id` IN (11502);

DELETE FROM `creature_loot_template` WHERE `entry` IN (11502);

INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES ('160386','11502','409','0','0','838.384','-830.921','-232.181','2.52474','1000000','5','0','330000','0','0','1');

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

(11502,16915,17,0,1,1,0,0,0),
(11502,16922,17,0,1,1,0,0,0),
(11502,16930,17,0,1,1,0,0,0),
(11502,16909,17,0,1,1,0,0,0),
(11502,16901,17,0,1,1,0,0,0),
(11502,16938,17,0,1,1,0,0,0),
(11502,16946,17,0,1,1,0,0,0),
(11502,16962,17,0,1,1,0,0,0),
(11502,16954,17,0,1,1,0,0,0),
(11502,17204,1,0,1,1,0,0,0),
(11502,17182,1,0,1,1,0,0,0),
(11502,19017,-100,0,1,1,0,0,0),
(11502,19019,1,0,1,1,0,0,0),
(11502,17102,14,0,1,1,0,0,0),
(11502,17107,15,0,1,1,0,0,0),
(11502,18817,17,0,1,1,0,0,0),
(11502,19137,13,0,1,1,0,0,0),
(11502,17104,4,0,1,1,0,0,0),
(11502,17076,5,0,1,1,0,0,0),
(11502,18816,16,0,1,1,0,0,0),
(11502,17106,14,0,1,1,0,0,0),
(11502,18815,18,0,1,1,0,0,0),
(11502,18814,16,0,1,1,0,0,0),
(11502,19138,15,0,1,1,0,0,0),
(11502,17063,15,0,1,1,0,0,0),
(11502,17082,5,0,1,1,0,0,0);

UPDATE `creature_template` SET `lootid` = 11502 WHERE `entry` IN (11502);

Mediv 01.05.2011 13:40
Квест Kroshius' Infernal Core HACK

В случае если не юзается Fel Fire на останках.

Код:
DELETE FROM `creature` WHERE `id` IN (14467);

INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('160387','14467','1','0','0','5786.11','-958.11','415.142','3.5292','300','5','0','4785','0','0','0');

DELETE FROM `creature_template` WHERE `entry` IN (14467);

INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) values('14467','0','0','14520','0','Kroshius',NULL,'0','55','55','15953','15953','0','0','3271','14','14','0','1.1','1.14286','0','1','310','400','0','164','1','1216','0','1','0','0','0','0','0','0','0','0','0','0','3','0','14467','0','0','0','300','0','0','0','0','10101','0','0','0','0','0','0','','0','3','0','0','1','0','0','0','0','0','');

Mediv 02.05.2011 13:18
Teleport Master Patch

Создает телепорт мастера (Оргриммар, Голдшир), который умеет телепортировать в кучу различных мест по всему миру.

ЧАСТЬ 1

Код:
DELETE FROM creature_template WHERE `entry`=300000;
DELETE FROM creature WHERE `id`=300000;
DELETE FROM gossip_menu WHERE `entry` IN (30000,30001,30002,30003,30004,30005,30006,30007);
DELETE FROM gossip_menu_option WHERE `menu_id` IN (30000,30001,30002,30003,30004,30005,30006,30007);
DELETE FROM gossip_scripts WHERE id>30000-1 AND id<3000076;
DELETE FROM npc_text WHERE `id` IN (300000,300001,300002,300003,300004,300005,300006,300007);

INSERT INTO creature_template (entry, modelid_1, name, subname, gossip_menu_id, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, dmg_multiplier, unit_flags, type, type_flags, InhabitType, flags_extra) VALUES
(300000, '7857', "Portal Master", "Server Service", '30000', 71, 71, 13700, 13700, 6540, 6540, 5700, 35, 35, 3, 1, 1.14286, 1.25, 1, 1, 2, 7, 138936390, 3, 2);

INSERT INTO gossip_menu (entry, text_id) VALUES
(30000, 300000),
(30001, 300001),
(30002, 300002),
(30003, 300003),
(30004, 300004),
(30005, 300005),
(30006, 300006),
(30007, 300007);

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
(30000, 1, 2, 'Stormwind', 1, 1, 30000, 0, 30000, 0, 0, 'Вы уверены что хотите отправиться в Stormwind?'),
(30000, 2, 2, 'Orgrimmar', 1, 1, 30000, 0, 30001, 0, 0, 'Вы уверены что хотите отправиться в Orgrimmar?'),
(30000, 3, 2, 'Darnassus', 1, 1, 30000, 0, 30002, 0, 0, 'Вы уверены что хотите отправиться в Darnassus?'),
(30000, 4, 2, 'Ironforge', 1, 1, 30000, 0, 30003, 0, 0, 'Вы уверены что хотите отправиться в Ironforge?'),
(30000, 5, 2, 'Thunder bluff', 1, 1, 30000, 0, 30004, 0, 0, 'Вы уверены что хотите отправиться в Thunder bluff?'),
(30000, 6, 2, 'Undercity', 1, 1, 30000, 0, 30005, 0, 0, 'Вы уверены что хотите отправиться в Undercity?'),
(30000, 7, 2, 'Booty bay', 1, 1, 30000, 0, 30006, 0, 0, 'Вы уверены что хотите отправиться в Booty bay?'),
(30000, 8, 2, 'Gurubashi arena', 1, 1, 30000, 0, 30007, 0, 0, 'Вы уверены что хотите отправиться в Arena?'),
(30000, 9, 3, 'Eastern Kingdoms A-H', 1, 1, 30001, 0, 0, 0, 0, NULL),

(30001, 1, 2, 'Alterac Mountains', 1, 1, 0, 0, 30018, 0, 0, 'Вы уверены что хотите отправиться в Alterac Mountains?'),
(30001, 2, 2, 'Arathi Highlands', 1, 1, 0, 0, 30019, 0, 0, 'Вы уверены что хотите отправиться в Arathi Highlands?'),
(30001, 3, 2, 'Badlands', 1, 1, 0, 0, 30021, 0, 0, 'Вы уверены что хотите отправиться в Badlands?'),
(30001, 4, 2, 'Blasted Lands', 1, 1, 0, 0, 30068, 0, 0, 'Вы уверены что хотите отправиться в Blasted Lands?'),
(30001, 5, 2, 'Burning Steppes', 1, 1, 0, 0, 30069, 0, 0, 'Вы уверены что хотите отправиться в Burning Steppes?'),
(30001, 6, 2, 'Deadwind Pass', 1, 1, 0, 0, 30070, 0, 0, 'Вы уверены что хотите отправиться в Deadwind Pass?'),
(30001, 7, 2, 'Dun Morogh', 1, 1, 0, 0, 30009, 0, 0, 'Вы уверены что хотите отправиться в Dun Morogh?'),
(30001, 8, 2, 'Duskwood', 1, 1, 0, 0, 30015, 0, 0, 'Вы уверены что хотите отправиться в Duskwood?'),
(30001, 9, 2, 'Eastern Plaguelands', 1, 1, 0, 0, 30064, 0, 0, 'Вы уверены что хотите отправиться в Eastern Plaguelands?'),
(30001, 10, 2, 'Elwynn Forest', 1, 1, 0, 0, 30008, 0, 0, 'Вы уверены что хотите отправиться в Elwynn Forest?'),
(30001, 11, 2, 'Hillsbrad Foothills', 1, 1, 0, 0, 30016, 0, 0, 'Вы уверены что хотите отправиться в Hillsbrad Foothills?'),
(30001, 12, 7, 'Back..', 1, 1, 30000, 0, 0, 0, 0, NULL),

(30000, 10, 3, 'Eastern Kingdoms L-W', 1, 1, 30002, 0, 0, 0, 0, NULL),
(30002, 1, 2, 'Loch modan', 1, 1, 0, 0, 30011, 0, 0, 'Вы уверены что хотите отправиться в Loch Modan?'),
(30002, 2, 2, 'Redridge mountains', 1, 1, 0, 0, 30014, 0, 0, 'Вы уверены что хотите отправиться в Redridge mountains?'),
(30002, 3, 2, 'Searing Gorge', 1, 1, 0, 0, 30071, 0, 0, 'Вы уверены что хотите отправиться в Searing Gorge?'),
(30002, 4, 2, 'Silverpine Forest', 1, 1, 0, 0, 30012, 0, 0, 'Вы уверены что хотите отправиться в Silverpine Forest?'),
(30002, 5, 2, 'Stranglethorn Vale', 1, 1, 0, 0, 30020, 0, 0, 'Вы уверены что хотите отправиться в Stranglethorn Vale?'),
(30002, 6, 2, 'Swamp of Sorrows', 1, 1, 0, 0, 30022, 0, 0, 'Вы уверены что хотите отправиться в Swamp of Sorrows?'),
(30002, 7, 2, 'The Hinterlands', 1, 1, 0, 0, 30072, 0, 0, 'Вы уверены что хотите отправиться в The Hinterlands?'),
(30002, 8, 2, 'Tirisfal Glades', 1, 1, 0, 0, 30010, 0, 0, 'Вы уверены что хотите отправиться в Tirisfal Glades?'),
(30002, 9, 2, 'Western Plaguelands', 1, 1, 0, 0, 30073, 0, 0, 'Вы уверены что хотите отправиться в Western Plaguelands?'),
(30002, 10, 2, 'Westfall', 1, 1, 0, 0, 30013, 0, 0, 'Вы уверены что хотите отправиться в Westfall?'),
(30002, 11, 2, 'Wetlands', 1, 1, 0, 0, 30017, 0, 0, 'Вы уверены что хотите отправиться в Wetlands?'),
(30002, 12, 7, 'Back..', 1, 1, 30000, 0, 0, 0, 0, NULL),

(30000, 11, 3, 'Kalimdor A-M', 1, 1, 30003, 0, 0, 0, 0, NULL),
(30003, 1, 2, 'Ashenvale Forest', 1, 1, 0, 0, 30029, 0, 0, 'Вы уверены что хотите отправиться в Ashenvale Forest?'),
(30003, 2, 2, 'Azshara', 1, 1, 0, 0, 30035, 0, 0, 'Вы уверены что хотите отправиться в Azshara?'),
(30003, 3, 2, 'Darkshore', 1, 1, 0, 0, 30026, 0, 0, 'Вы уверены что хотите отправиться в Darkshore?'),
(30003, 4, 2, 'Desolace', 1, 1, 0, 0, 30031, 0, 0, 'Вы уверены что хотите отправиться в Desolace?'),
(30003, 5, 2, 'Durotar', 1, 1, 0, 0, 30024, 0, 0, 'Вы уверены что хотите отправиться в Durotar?'),
(30003, 6, 2, 'Dustwallow Marsh', 1, 1, 0, 0, 30032, 0, 0, 'Вы уверены что хотите отправиться в Dustwallow Marsh?'),
(30003, 7, 2, 'Felwood', 1, 1, 0, 0, 30036, 0, 0, 'Вы уверены что хотите отправиться в Felwood?'),
(30003, 8, 2, 'Feralas', 1, 1, 0, 0, 30033, 0, 0, 'Вы уверены что хотите отправиться в Feralas?'),
(30003, 9, 2, 'Moonglade', 1, 1, 0, 0, 30074, 0, 0, 'Вы уверены что хотите отправиться в Moonglade?'),
(30003, 10, 2, 'Mulgore', 1, 1, 0, 0, 30025, 0, 0, 'Вы уверены что хотите отправиться в Mulgore?'),
(30003, 11, 7, 'Back..', 1, 1, 30000, 0, 0, 0, 0, NULL),

(30000, 12, 3, 'Kalimdor S-W', 1, 1, 30004, 0, 0, 0, 0, NULL),
(30004, 1, 2, 'Silithus', 1, 1, 0, 0, 30075, 0, 0, 'Вы уверены что хотите отправиться в Silithus?'),
(30004, 2, 2, 'Stonetalon Mountains', 1, 1, 0, 0, 30028, 0, 0, 'Вы уверены что хотите отправиться в Stonetalon Mountains?'),
(30004, 3, 2, 'Tanaris Desert', 1, 1, 0, 0, 30034, 0, 0, 'Вы уверены что хотите отправиться в Tanaris Desert?'),
(30004, 4, 2, 'Teldrassil', 1, 1, 0, 0, 30023, 0, 0, 'Вы уверены что хотите отправиться в Teldrassil?'),
(30004, 5, 2, 'The Barrens', 1, 1, 0, 0, 30027, 0, 0, 'Вы уверены что хотите отправиться в The Barrens?'),
(30004, 6, 2, 'Thousand Needles', 1, 1, 0, 0, 30030, 0, 0, 'Вы уверены что хотите отправиться в Thousand Needles?'),
(30004, 7, 2, 'Un''Goro Crater', 1, 1, 0, 0, 30037, 0, 0, 'Вы уверены что хотите отправиться в Un''Goro Crater?'),
(30004, 8, 2, 'Winterspring', 1, 1, 0, 0, 30076, 0, 0, 'Вы уверены что хотите отправиться в Winterspring?'),
(30004, 9, 7, 'Back..', 1, 1, 30000, 0, 0, 0, 0, NULL),

(30000, 13, 9, 'Dungeon Locations (Azeroth)', 1, 1, 30005, 0, 0, 0, 0, NULL),
(30005, 1, 2, 'Blackrock Depths 48-56 (5 man)', 1, 1, 0, 0, 30048, 0, 0, 'Вы уверены что хотите отправиться в Blackrock Depths?'),
(30005, 2, 2, 'Blackrock Spire 53-60 (10 man)', 1, 1, 0, 0, 30049, 0, 0, 'Вы уверены что хотите отправиться в Blackrock Spire?'),
(30005, 3, 2, 'The Deadmines 15-20 (10 man)', 1, 1, 0, 0, 30039, 0, 0, 'Вы уверены что хотите отправиться в The Deadmines?'),
(30005, 4, 2, 'Gnomeregan 24-33 (10 man)', 1, 1, 0, 0, 30038, 0, 0, 'Вы уверены что хотите отправиться в Gnomeregan?'),
(30005, 5, 2, 'Scarlet Monastery 30-40 (10 man)', 1, 1, 0, 0, 30044, 0, 0, 'Вы уверены что хотите отправиться в Scarlet Monastery?'),
(30005, 6, 2, 'Scholomance 58-60 (5 man)', 1, 1, 0, 0, 30052, 0, 0, 'Вы уверены что хотите отправиться в Scholomance?'),
(30005, 7, 2, 'Shadowfang Keep 18-25 (10 man)', 1, 1, 0, 0, 30045, 0, 0, 'Вы уверены что хотите отправиться в Shadowfang Keep?'),
(30005, 8, 2, 'The Stockade 23-26 (10 man)', 1, 1, 0, 0, 30040, 0, 0, 'Вы уверены что хотите отправиться в The Stockade?'),
(30005, 9, 2, 'Stratholme 55-60 (5 man)', 1, 1, 0, 0, 30065, 0, 0, 'Вы уверены что хотите отправиться в The Stockade?'),
(30005, 10, 2, 'The Temple of Atal''Hakkar (10 man)', 1, 1, 0, 0, 30066, 0, 0, 'Вы уверены что хотите отправиться в The Stockade?'),
(30005, 11, 2, 'Uldaman 35-45 (10 man)', 1, 1, 0, 0, 30067, 0, 0, 'Вы уверены что хотите отправиться в The Stockade?'),
(30005, 12, 7, 'Back..', 1, 1, 30000, 0, 0, 0, 0, NULL),

(30000, 14, 9, 'Dungeon Locations (Kalimdor)', 1, 1, 30006, 0, 0, 0, 0, NULL),
(30006, 1, 2, 'Blackfathom Deeps 20-27 (10 man)', 1, 1, 0, 0, 30047, 0, 0, 'Вы уверены что хотите отправиться в Blackfathom Deeps?'),
(30006, 2, 2, 'Dire Maul 56-60 (5 man)', 1, 1, 0, 0, 30050, 0, 0, 'Вы уверены что хотите отправиться в Dire Maul?'),
(30006, 3, 2, 'Maraudon 40-49 (10 man)', 1, 1, 0, 0, 30051, 0, 0, 'Вы уверены что хотите отправиться в Maraudon?'),
(30006, 4, 2, 'Ragefire Chasm 13-15 (10 man)', 1, 1, 0, 0, 30041, 0, 0, 'Вы уверены что хотите отправиться в Ragefire Chasm?'),
(30006, 5, 2, 'Razorfen Downs 35-45 (10 man)', 1, 1, 0, 0, 30042, 0, 0, 'Вы уверены что хотите отправиться в Razorfen Downs?'),
(30006, 6, 2, 'Razorfen Kraul 25-35 (10 man)', 1, 1, 0, 0, 30043, 0, 0, 'Вы уверены что хотите отправиться в Razorfen Kraul?'),
(30006, 7, 2, 'Wailing Caverns 15-21 (10 man)', 1, 1, 0, 0, 30046, 0, 0, 'Вы уверены что хотите отправиться в Wailing Caverns?'),

Mediv 02.05.2011 13:19
Вложений: 1
ЧАСТЬ 2

Код:
(30006, 8, 2, 'Zul''Farrak 43-47 (10 man)', 1, 1, 0, 0, 30063, 0, 0, 'Вы уверены что хотите отправиться в Zul''Farrak?'),
(30006, 9, 7, 'Back..', 1, 1, 30000, 0, 0, 0, 0, NULL),

(30000, 15, 9, 'Raid Teleports', 1, 1, 30007, 0, 0, 0, 0, NULL),
(30007, 1, 2, 'Naxxramas 60-70 (40 man)', 1, 1, 0, 0, 30058, 0, 0, 'Вы уверены что хотите отправиться в Naxxramas?'),
(30007, 2, 2, 'Molten Core 60-62 (40 man)', 1, 1, 0, 0, 30057, 0, 0, 'Вы уверены что хотите отправиться в Molten Core?'),
(30007, 3, 2, 'Blackwing Lair 60-62 (40 man)', 1, 1, 0, 0, 30054, 0, 0, 'Вы уверены что хотите отправиться в Blackwing Lair?'),
(30007, 4, 2, 'Temple of Ahn''Qiraj 60-65 (40 man)', 1, 1, 0, 0, 30061, 0, 0, 'Вы уверены что хотите отправиться в Temple of Ahn''Qiraj?'),
(30007, 5, 2, 'Onyxia''s Lair 60-62 (40 man)', 1, 1, 0, 0, 30059, 0, 0, 'Вы уверены что хотите отправиться в Onyxia''s Lair?'),
(30007, 6, 2, 'Ruins of Ahn''Qiraj 60-65 (20 man)', 1, 1, 0, 0, 30060, 0, 0, 'Вы уверены что хотите отправиться в Ruins of Ahn''Qiraj?'),
(30007, 7, 2, 'Zul''Gurub 60-62 (20 man)', 1, 1, 0, 0, 30062, 0, 0, 'Вы уверены что хотите отправиться в Zul''Gurub?'),
(30007, 8, 7, 'Back..', 1, 1, 30000, 0, 0, 0, 0, NULL);

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES
(300000, '$BДобро пожаловать!$B', 0),
(300001, '$BЛокации Восточного Королевства A-H$B', 0),
(300002, '$BЛокации Восточного Королевства L-W$B', 0),
(300003, '$BЛокации Калимдора A-M$B', 0),
(300004, '$BЛокации Калимдора S-W$B', 0),
(300005, '$BПодземелья Азерота$B', 0),
(300006, '$BПодземелья Калимдора$B', 0),
(300007, '$BРейдовые подземелья$B', 0);

INSERT INTO gossip_scripts (id, delay, command, datalong, datalong2, dataint, x, y, z, o, comments) VALUES
(30000, 0, 6, 0, 0, 0, -8842.09, 626.358, 94.0867, 3.61363, 'Stormwind'),
(30001, 0, 6, 1, 0, 0, 1601.08, -4378.69, 9.9846, 2.14362, 'Orgrimmar'),
(30002, 0, 6, 1, 0, 0, 9869.91, 2493.58, 1315.88, 2.78897, 'Darnassus'),
(30003, 0, 6, 0, 0, 0, -4919.94, -982.083, 501.46, 5.12894, 'Ironforge'),
(30004, 0, 6, 1, 0, 0, -1274.45, 71.8601, 128.159, 2.80623, 'Thunder bluff'),
(30005, 0, 6, 0, 0, 0, 1633.75, 240.167, -43.1034, 6.26128, 'Undercity'),
(30006, 0, 6, 0, 0, 0, -14281.9, 552.564, 8.90422, 0.860144, 'Booty bay'),
(30007, 0, 6, 0, 0, 0, -13181.8, 339.356, 42.9805, 1.18013, 'Gurubashi arena'),
(30008, 0, 6, 0, 0, 0, -9449.06, 64.8392, 56.3581, 3.07047, 'Elwynn Forest'),
(30009, 0, 6, 0, 0, 0, -5603.76, -482.704, 396.98, 5.23499, 'Dun Morogh'),
(30010, 0, 6, 0, 0, 0, 2274.95, 323.918, 34.1137, 4.24367, 'Tirisfal Glades'),

(30011, 0, 6, 0, 0, 0, -5405.85, -2894.15, 341.972, 5.48238, 'Loch modan'),
(30012, 0, 6, 0, 0, 0, 505.126, 1504.63, 124.808, 1.77987, 'Silverpine Forest'),
(30013, 0, 6, 0, 0, 0, -10684.9, 1033.63, 32.5389, 6.07384, 'Westfall'),
(30014, 0, 6, 0, 0, 0, -9447.8, -2270.85, 71.8224, 0.283853, 'Redridge mountains'),
(30015, 0, 6, 0, 0, 0, -10531.7, -1281.91, 38.8647, 1.56959, 'Duskwood'),
(30016, 0, 6, 0, 0, 0, -385.805, -787.954, 54.6655, 1.03926, 'Hillsbrad Foothills'),
(30017, 0, 6, 0, 0, 0, -3517.75, -913.401, 8.86625, 2.60705, 'Wetland'),
(30018, 0, 6, 0, 0, 0, 275.049, -652.044, 130.296, 0.502032, 'Alterac Mountains'),
(30019, 0, 6, 0, 0, 0, -1581.45, -2704.06, 35.4168, 0.490373, 'Arathi Highlands'),
(30020, 0, 6, 0, 0, 0, -11921.7, -59.544, 39.7262, 3.73574, 'Stranglethorn Vale'),

(30021, 0, 6, 0, 0, 0, -6782.56, -3128.14, 240.48, 5.65912, 'Badlands'),
(30022, 0, 6, 0, 0, 0, -10368.6, -2731.3, 21.6537, 5.29238, 'Swamp of Sorrows'),
(30023, 0, 6, 1, 0, 0, 9889.03, 915.869, 1307.43, 1.9336, 'Teldrassil'),
(30024, 0, 6, 1, 0, 0, 228.978, -4741.87, 10.1027, 0.416883, 'Durotar'),
(30025, 0, 6, 1, 0, 0, -2473.87, -501.225, -9.42465, 0.6525, 'Mulgore'),
(30026, 0, 6, 1, 0, 0, 6463.25, 683.986, 8.92792, 4.33534, 'Darkshore'),
(30027, 0, 6, 1, 0, 0, -575.772, -2652.45, 95.6384, 0.006469, 'The Barrens'),
(30028, 0, 6, 1, 0, 0, 1574.89, 1031.57, 137.442, 3.8013, 'Stonetalon Mountains'),
(30029, 0, 6, 1, 0, 0, 1919.77, -2169.68, 94.6729, 6.14177, 'Ashenvale Forest'),
(30030, 0, 6, 1, 0, 0, -5375.53, -2509.2, -40.432, 2.41885, 'Thousand Needles'),

(30031, 0, 6, 1, 0, 0, -656.056, 1510.12, 88.3746, 3.29553, 'Desolace'),
(30032, 0, 6, 1, 0, 0, -3350.12, -3064.85, 33.0364, 5.12666, 'Dustwallow Marsh'),
(30033, 0, 6, 1, 0, 0, -4808.31, 1040.51, 103.769, 2.90655, 'Feralas'),
(30034, 0, 6, 1, 0, 0, -6940.91, -3725.7, 48.9381, 3.11174, 'Tanaris Desert'),
(30035, 0, 6, 1, 0, 0, 3117.12, -4387.97, 91.9059, 5.49897, 'Azshara'),
(30036, 0, 6, 1, 0, 0, 3898.8, -1283.33, 220.519, 6.24307, 'Felwood'),
(30037, 0, 6, 1, 0, 0, -6291.55, -1158.62, -258.138, 0.457099, 'Un''Goro Crater'),
(30038, 0, 6, 0, 0, 0, -5163.54, 925.423, 257.181, 1.57423, 'Gnomeregan'),
(30039, 0, 6, 0, 0, 0, -11209.6, 1666.54, 24.6974, 1.42053, 'The Deadmines'),
(30040, 0, 6, 0, 0, 0, -8799.15, 832.718, 97.6348, 6.04085, 'The Stockade'),

(30041, 0, 6, 1, 0, 0, 1811.78, -4410.5, -18.4704, 5.20165, 'Ragefire Chasm'),
(30042, 0, 6, 1, 0, 0, -4657.3, -2519.35, 81.0529, 4.54808, 'Razorfen Downs'),
(30043, 0, 6, 1, 0, 0, -4470.28, -1677.77, 81.3925, 1.16302, 'Razorfen Kraul'),
(30044, 0, 6, 0, 0, 0, 2873.15, -764.523, 160.332, 5.10447, 'Scarlet Monastery'),
(30045, 0, 6, 0, 0, 0, -234.675, 1561.63, 76.8921, 1.24031, 'Shadowfang Keep'),
(30046, 0, 6, 1, 0, 0, -731.607, -2218.39, 17.0281, 2.78486, 'Wailing Caverns'),
(30047, 0, 6, 1, 0, 0, 4249.99, 740.102, -25.671, 1.34062, 'Blackfathom Deeps'),
(30048, 0, 6, 0, 0, 0, -7179.34, -921.212, 165.821, 5.09599, 'Blackrock Depths'),
(30049, 0, 6, 0, 0, 0, -7527.05, -1226.77, 285.732, 5.29626, 'Blackrock Spire'),
(30050, 0, 6, 1, 0, 0, -3520.14, 1119.38, 161.025, 4.70454, 'Dire Maul'),

(30051, 0, 6, 1, 0, 0, -1421.42, 2907.83, 137.415, 1.70718, 'Maraudon'),
(30052, 0, 6, 0, 0, 0, 1269.64, -2556.21, 93.6088, 0.620623, 'Scholomance'),
(30053, 0, 6, 1, 0, 0, -8177.89, -4181.23, -167.552, 0.913338, 'Caverns of Time'),
(30054, 0, 6, 229, 0, 0, 164.789, -475.305, 116.842, 0.022714, 'Blackwing Lair'),
(30057, 0, 6, 230, 0, 0, 1126.64, -459.94, -102.535, 3.46095, 'Molten Core'),
(30058, 0, 6, 0, 0, 0, 3120.16, -3724.93, 137.66, 5.83567, 'Naxxramas'),
(30059, 0, 6, 1, 0, 0, -4708.27, -3727.64, 54.5589, 3.72786, 'Onyxia''s Lair'),
(30060, 0, 6, 1, 0, 0, -8409.82, 1499.06, 27.7179, 2.51868, 'Ruins of Ahn''Qiraj'),

(30061, 0, 6, 1, 0, 0, -8240.09, 1991.32, 129.072, 0.941603, 'Temple of Ahn''Qiraj'),
(30062, 0, 6, 0, 0, 0, -11916.7, -1215.72, 92.289, 4.72454, 'Zul''Gurub'),
(30063, 0, 6, 1, 0, 0, -6801.19, -2893.02, 9.00388, 0.158639, 'Zul''Farrak'),
(30064, 0, 6, 0, 0, 0, 2300.97, -4613.36, 73.6231, 0.367722, 'Eastern Plaguelands'),
(30065, 0, 6, 0, 0, 0, 3352.92, -3379.03, 144.782, 6.25978, 'Stratholme'),
(30066, 0, 6, 0, 0, 0, -10177.9, -3994.9, -111.239, 6.01885, 'The Sunken Temple'),
(30067, 0, 6, 0, 0, 0, -6071.37, -2955.16, 209.782, 0.015708, 'Uldaman'),
(30068, 0, 6, 0, 0, 0, -11182.5, -3016.67, 7.42235, 4.0004, 'Blasted Lands'),
(30069, 0, 6, 0, 0, 0, -8118.54, -1633.83, 132.996, 0.089067, 'Burning Steppes'),
(30070, 0, 6, 0, 0, 0, -10438.8, -1932.75, 104.617, 4.77402, 'Deadwind Pass'),

(30071, 0, 6, 0, 0, 0, -7012.47, -1065.13, 241.786, 5.63162, 'Searing Gorge'),
(30072, 0, 6, 0, 0, 0, 119.387, -3190.37, 117.331, 2.34064, 'The Hinterlands'),
(30073, 0, 6, 0, 0, 0, 1728.65, -1602.25, 63.429, 1.6558, 'Western Plaguelands'),
(30074, 0, 6, 1, 0, 0, 7654.3, -2232.87, 462.107, 5.96786, 'Moonglade'),
(30075, 0, 6, 1, 0, 0, -6820.55, 823.365, 49.6003, 1.19764, 'Silithus'),
(30076, 0, 6, 1, 0, 0, 6759.18, -4419.63, 763.214, 4.43476, 'Winterspring');

INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
('160382','300000','0','0','0','-9431.75','63.548','56.6556','3.13644','25','5','0','5000','10000','0','0'),
('160342','300000','1','0','0','1586.63','-4415.29','8.34254','3.30884','25','5','0','685','6540','0','0');

Mediv 05.05.2011 19:34
Large Scarab Coffer FIX

Добавляет в сундуки Large Scarab Coffer находящиеся в Temple of Ahn'Qiraj отсутствующий лут.

Код:
UPDATE `gameobject_template` SET `Flags` = 4 WHERE `entry` IN (180690);

DELETE FROM `gameobject_loot_template` WHERE `entry` IN (180690);

INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('180690','21156','87','1','1','1','0','0','0'),
('180690','20878','29','1','1','3','0','0','0'),
('180690','20881','26','1','1','3','0','0','0'),
('180690','20882','25','1','1','3','0','0','0'),
('180690','20876','24','1','1','3','0','0','0'),
('180690','20875','23','1','1','3','0','0','0'),
('180690','20877','23','1','1','3','0','0','0'),
('180690','20879','22','1','1','3','0','0','0'),
('180690','20874','22','1','1','3','0','0','0');

Mediv 05.05.2011 20:17
Quest Striker's Pauldrons FIX

Добавляет нпс с id=15502 квест Quest Striker's Pauldrons.

Код:
REPLACE INTO `creature_questrelation` (`id`,`quest`) VALUES
(15502,8659);

Mediv 05.05.2011 20:43
Spawntime FIX

Исправление время спавна существ. Избавление от мгновенного респауна мобов после убийства.

Код:
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs`<300;

Mediv 06.05.2011 01:22
Start Zone MOD

Меняет стартовые зоны игроков на оргриммар и голдшир.

Код:
DELETE FROM `playercreateinfo` WHERE `race` IN (1,2,3,4,5,6,7,8);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES

(1,1,0,12,-9448.55,68.236,56.3225,2.1115),
(1,2,0,12,-9448.55,68.236,56.3225,2.1115),
(1,4,0,12,-9448.55,68.236,56.3225,2.1115),
(1,5,0,12,-9448.55,68.236,56.3225,2.1115),
(1,8,0,12,-9448.55,68.236,56.3225,2.1115),
(1,9,0,12,-9448.55,68.236,56.3225,2.1115),
(2,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(3,1,0,12,-9448.55,68.236,56.3225,2.1115),
(3,2,0,12,-9448.55,68.236,56.3225,2.1115),
(3,3,0,12,-9448.55,68.236,56.3225,2.1115),
(3,4,0,12,-9448.55,68.236,56.3225,2.1115),
(3,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,1,0,12,-9448.55,68.236,56.3225,2.1115),
(4,3,0,12,-9448.55,68.236,56.3225,2.1115),
(4,4,0,12,-9448.55,68.236,56.3225,2.1115),
(4,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,11,0,12,-9448.55,68.236,56.3225,2.1115),
(5,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,11,1,1637,1629.36,-4373.39,31.2564,3.54839),
(7,1,0,12,-9448.55,68.236,56.3225,2.1115),
(7,4,0,12,-9448.55,68.236,56.3225,2.1115),
(7,8,0,12,-9448.55,68.236,56.3225,2.1115),
(7,9,0,12,-9448.55,68.236,56.3225,2.1115),
(8,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,8,1,1637,1629.36,-4373.39,31.2564,3.54839);
BC Версия:

Код:
DELETE FROM `playercreateinfo` WHERE `race` IN (1,2,3,4,5,6,7,8,10,11);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES

(1,1,0,12,-9448.55,68.236,56.3225,2.1115),
(1,2,0,12,-9448.55,68.236,56.3225,2.1115),
(1,4,0,12,-9448.55,68.236,56.3225,2.1115),
(1,5,0,12,-9448.55,68.236,56.3225,2.1115),
(1,8,0,12,-9448.55,68.236,56.3225,2.1115),
(1,9,0,12,-9448.55,68.236,56.3225,2.1115),
(2,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(3,1,0,12,-9448.55,68.236,56.3225,2.1115),
(3,2,0,12,-9448.55,68.236,56.3225,2.1115),
(3,3,0,12,-9448.55,68.236,56.3225,2.1115),
(3,4,0,12,-9448.55,68.236,56.3225,2.1115),
(3,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,1,0,12,-9448.55,68.236,56.3225,2.1115),
(4,3,0,12,-9448.55,68.236,56.3225,2.1115),
(4,4,0,12,-9448.55,68.236,56.3225,2.1115),
(4,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,11,0,12,-9448.55,68.236,56.3225,2.1115),
(5,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,11,1,1637,1629.36,-4373.39,31.2564,3.54839),
(7,1,0,12,-9448.55,68.236,56.3225,2.1115),
(7,4,0,12,-9448.55,68.236,56.3225,2.1115),
(7,8,0,12,-9448.55,68.236,56.3225,2.1115),
(7,9,0,12,-9448.55,68.236,56.3225,2.1115),
(8,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,2,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(11,1,0,12,-9448.55,68.236,56.3225,2.1115),
(11,2,0,12,-9448.55,68.236,56.3225,2.1115),
(11,3,0,12,-9448.55,68.236,56.3225,2.1115),
(11,5,0,12,-9448.55,68.236,56.3225,2.1115),
(11,7,0,12,-9448.55,68.236,56.3225,2.1115),
(11,8,0,12,-9448.55,68.236,56.3225,2.1115);
Вещи не ломаются:
Код:
UPDATE `item_template` SET `MaxDurability` = 0 WHERE `MaxDurability` > 0;

RomanRom2 06.05.2011 01:43
Цитата:
Сообщение от Mediv (Сообщение 21846)
Меняет стартовые зоны игроков на оргриммар и голдшир.
... а зачем?

Mediv 06.05.2011 01:47
Цитата:
Сообщение от RomanRom2 (Сообщение 21848)
... а зачем?
Эмм в далеком далеком прошлом люди на пиратках в основном торчали в голдшире и оргри. Эти 2 места считались сборными пунктами и просто местами прожигания времени.

Зачем идти например с дарнасуса до голдшира, когда можно появиться сразу там?)

Для серверов с мелким онлайном весьма актуально.

RomanRom2 06.05.2011 01:57
ааа, хаки... как то сразу не дошло на ночь глядя =)
я бы все таки сделал стартовые зоны на место, это все таки стартовые зоны. и поставил бы мобов с телепортами. это было бы по феншую хотя бы.

Mediv 06.05.2011 02:09
Ну мод на то и мод, хочешь ставь, хочешь нет)

Я предлагаю то что мне приходит в голову как варианты)

tempura 06.05.2011 08:04
Надо бы мод сделать, чтобы ВорлдБоссы стояли вокруг Голдшира - тоже чтобы далеко не бегать. Где-то там слева пещерка была - в ней Рагнарос отлично бы встал. А у ворот Шторма поставить еще какую-нибудь страхолюду - чтобы вообще жизнь медом не казалась.

А то бегать по всей карте, когда можно вокруг Голдшира все сделать - скучно.

BloodWarrior 06.05.2011 08:09
tempura

Помню помню)) Проделывал подобные штуки во времена вад-эму.))
Ну у меня на сервере ну хотели люди создавать себе игроков именно за альянс и именно хуманов, да и вообще альянс был порядка 90% на сервере.

Пришлось, стартовые локации были заселены ворлд босами, которые испепеляли все живое и на время доступ для тех крабиков которые до спирит хилера соседнего не добегали - был закрыт)

KiriX 06.05.2011 10:02

RomanRom2 06.05.2011 13:11

Mediv 08.05.2011 19:22
Вложений: 1
Все кроме портал мастера в 1-м файле

Mediv 28.02.2013 16:52
Вложений: 1
Недавно поставил у себя 1.12.2, сделал первое обновление БД. Решил продолжить свою нуботему с хаками и прочей ерундой :D

Возможно кому-то пригодится, бд 1.12.2 не идеальна, это скажем так, временная заплатка, страхующая игроков.

Список изменений не очень большой, но все же:

Классовые квестовые спеллы теперь у тренеров
Допиленый телепорт мастер
Сумка при старте на 18 слотов

Ставится на чистую ZeroDB.


Текущее время: 10:58. Часовой пояс GMT +3.

ru-mangos.ru - Русское сообщество MaNGOS