WoWlord | Дата: Четверг, 27.05.2010, 14:05 | Сообщение # 1 |
Группа: Проверенные
Сообщений: 109
Награды: 2
Репутация: 6
Статус:
| Дроп С мобов! Code -- Ключ Куэрго DELETE FROM `creature_loot_template` WHERE (`entry`=7902) AND (`item`=9275); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7902, 9275, 28, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=7899) AND (`item`=9275); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7899, 9275, 28, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=7901) AND (`item`=9275); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7901, 9275, 25, 0, 1, 1, 0, 0, 0); -- Шляпа пирата Южных морей Code DELETE FROM `creature_loot_template` WHERE (`entry`=7855) AND (`item`=20519); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7855, 20519, -25, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=7856) AND (`item`=20519); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7856, 20519, -24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=7858) AND (`item`=20519); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7858, 20519, -21, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=7857) AND (`item`=20519); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7857, 20519, -21, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=7883) AND (`item`=20519); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7883, 20519, -20, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=8203) AND (`item`=20519); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (8203, 20519, -16, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=15685) AND (`item`=20519); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (15685, 20519, -10, 0, 1, 1, 0, 0, 0); -- Бурдюк с водой Скитальцев Пустыни Code DELETE FROM `creature_loot_template` WHERE (`entry`=7805) AND (`item`=8483); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7805, 8483, -39, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=5615) AND (`item`=8483); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5615, 8483, -38, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=5623) AND (`item`=8483); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5623, 8483, -38, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=5616) AND (`item`=8483); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5616, 8483, -38, 0, 1, 3, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=5617) AND (`item`=8483); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5617, 8483, -38, 0, 1, 3, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=5618) AND (`item`=8483); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5618, 8483, -38, 0, 1, 1, 0, 0, 0); ================================================================================================ Огрримар Фикс Мобов Правельность мобов где они должны стоять! Quote -- Оргриммар -- Харрук (офф) UPDATE creature SET position_x = '273.168976', position_y = '-4713.710449', position_z = '11.627667', orientation = '1.101132' WHERE guid = '37927'; -- Джо'ма (офф) UPDATE creature SET position_x = '1839.458496', position_y = '-4466.385254', position_z = '47.416718', orientation = '3.335550' WHERE guid = '154663'; -- Белгром Каменная Булава (офф) UPDATE creature SET position_x = '1953.493042', position_y = '-4735.413086', position_z = '48.314331', orientation = '1.046110' WHERE guid = '40495'; -- Ордынский Вестник Войны (офф) UPDATE creature SET position_x = '1988.952515', position_y = '-4799.268066', position_z = '55.818367', orientation = '2.320023' WHERE guid = '40522'; -- Зеггон Трестокун (офф) UPDATE creature SET position_x = '1987.763184', position_y = '-4813.386719', position_z = '56.765160', orientation = '1.770240' WHERE guid = '85513'; -- Андрисса (офф) UPDATE creature SET position_x = '2002.502075', position_y = '-4791.190430', position_z = '56.764801', orientation = '3.179264' WHERE guid = '284937'; -- Атурк Наковальня (офф) UPDATE creature SET position_x = '2054.506104', position_y = '-4817.099121', position_z = '22.786383', orientation = '0.578818' WHERE guid = '102514'; -- Орокк Омош (офф) UPDATE creature SET position_x = '2062.265137', position_y = '-4792.109863', position_z = '22.981644', orientation = '5.888895' WHERE guid = '40597'; -- Шанкис (офф) UPDATE creature SET position_x = '1995.290771', position_y = '-4662.221680', position_z = '26.819860', orientation = '1.229912' WHERE guid = '40526'; -- Зас'тиш (офф) UPDATE creature SET position_x = '1991.060181', position_y = '-4652.371582', position_z = '27.069012', orientation = '6.272167' WHERE guid = '284933'; -- Мурчаль (офф) DELETE FROM creature WHERE guid = '4456716'; INSERT INTO creature VALUES (4456716,15186,1,1,1,0,3915,1991.73,-4651.38,27.0136,6.11115,25,0,0,42,0,0,0); -- Гурчаль (офф) DELETE FROM creature WHERE guid = '4456718'; INSERT INTO creature VALUES (4456718,16069,1,1,1,0,3915,1989.66,-4657.17,27.346,0.607085,25,0,0,42,0,0,0); -- Ксон'ча (офф) UPDATE creature SET position_x = '2140.487061', position_y = '-4651.901367', position_z = '50.234417', orientation = '1.927016' WHERE guid = '40676'; -- Огунаро Волкопас (офф) UPDATE creature SET position_x = '2160.095947', position_y = '-4654.399414', position_z = '49.623714', orientation = '2.857707' WHERE guid = '40698'; -- Волки (офф) DELETE FROM creature WHERE guid = '40692'; DELETE FROM creature_addon WHERE guid = '40692'; DELETE FROM creature_movement WHERE id = '40692'; DELETE FROM game_event_creature WHERE guid = '40692'; DELETE FROM game_event_model_equip WHERE guid = '40692'; DELETE FROM creature WHERE guid = '40706'; DELETE FROM creature_addon WHERE guid = '40706'; DELETE FROM creature_movement WHERE id = '40706'; DELETE FROM game_event_creature WHERE guid = '40706'; DELETE FROM game_event_model_equip WHERE guid = '40706'; DELETE FROM creature WHERE guid = '40704'; DELETE FROM creature_addon WHERE guid = '40704'; DELETE FROM creature_movement WHERE id = '40704'; DELETE FROM game_event_creature WHERE guid = '40704'; DELETE FROM game_event_model_equip WHERE guid = '40704'; DELETE FROM creature WHERE guid = '40693'; DELETE FROM creature_addon WHERE guid = '40693'; DELETE FROM creature_movement WHERE id = '40693'; DELETE FROM game_event_creature WHERE guid = '40693'; DELETE FROM game_event_model_equip WHERE guid = '40693'; UPDATE creature SET position_x = '2155.091309', position_y = '-4649.602539', position_z = '49.996510', orientation = '5.108641' WHERE guid = '40695'; -- Казул (офф) UPDATE creature SET position_x = '1838.718994', position_y = '-4341.520020', position_z = '-15.475355', orientation = '3.528423' WHERE guid = '40393'; -- Кургул (офф) UPDATE creature SET position_x = '1836.726196', position_y = '-4346.905273', position_z = '-14.854283', orientation = '3.654094' WHERE guid = '40397'; -- Кор'хус (офф) UPDATE creature SET position_x = '1767.226440', position_y = '-4367.143066', position_z = '-16.019903', orientation = '5.530743' WHERE guid = '40310'; -- Кор'гхан (офф) UPDATE creature SET position_x = '1805.453491', position_y = '-4285.564453', position_z = '6.843641', orientation = '3.251528' WHERE guid = '40319'; -- Гест (офф) UPDATE creature SET position_x = '1792.051636', position_y = '-4278.662598', position_z = '7.283041', orientation = '4.763422' WHERE guid = '40356'; -- Кардрис Сновидец (офф) UPDATE creature SET position_x = '1933.414307', position_y = '-4224.869629', position_z = '42.095337', orientation = '0.164915' WHERE guid = '40482'; -- Шиан'цу (офф) UPDATE creature SET position_x = '1933.002808', position_y = '-4211.210449', position_z = '42.095711', orientation = '0.003906' WHERE guid = '40487'; -- Огнир Хранитель Огня (офф) UPDATE creature SET position_x = '1921.294189', position_y = '-4212.276855', position_z = '42.095711', orientation = '5.354819' WHERE guid = '40455'; -- Кор'кронский гвардеец (офф) UPDATE creature SET position_x = '1912.393188', position_y = '-4124.594727', position_z = '43.031418', orientation = '5.068145' WHERE guid = '40453'; -- Посол Певица Рассвета (офф) UPDATE creature SET position_x = '1914.924438', position_y = '-4124.106445', position_z = '42.991863', orientation = '5.068148' WHERE guid = '55704'; -- Наставник Огненор (офф) UPDATE creature SET position_x = '1939.075684', position_y = '-4133.517090', position_z = '40.917095', orientation = '4.039293' WHERE guid = '283828'; -- Отважный страж-рыцарь крови (офф) DELETE FROM creature WHERE guid = '4456719'; INSERT INTO creature VALUES (4456719,23131,1,1,1,0,491,1938.63,-4131.95,40.9132,4.13746,25,0,0,4400,3155,0,0); UPDATE creature SET position_x = '1940.688110', position_y = '-4133.651855', position_z = '40.920368', orientation = '4.039280' WHERE guid = '284655'; -- Вол'джин (офф) UPDATE creature SET position_x = '1934.175049', position_y = '-4162.474121', position_z = '40.912605', orientation = '2.503833' WHERE guid = '40480'; -- Эйтригг (офф) UPDATE creature SET position_x = '1906.457397', position_y = '-4161.517090', position_z = '40.919971', orientation = '0.858423' WHERE guid = '40484'; -- Моквар (офф) UPDATE creature SET position_x = '1916.160400', position_y = '-4171.102539', position_z = '40.923264', orientation = '0.840355' WHERE guid = '51370'; -- Магениус (офф) UPDATE creature SET position_x = '1890.352661', position_y = '-4321.363281', position_z = '23.169222', orientation = '4.508174' WHERE guid = '40441'; -- Энио (офф) UPDATE creature SET position_x = '1472.646484', position_y = '-4224.073242', position_z = '42.959274', orientation = '2.067924' WHERE guid = '40050'; -- Продавец пива (офф) DELETE FROM creature WHERE guid = '153999'; DELETE FROM creature_addon WHERE guid = '153999'; DELETE FROM creature_movement WHERE id = '153999'; DELETE FROM game_event_creature WHERE guid = '153999'; DELETE FROM game_event_model_equip WHERE guid = '153999'; -- Арнок (офф) UPDATE creature SET position_x = '1482.352661', position_y = '-4159.618652', position_z = '43.793873', orientation = '0.704466' WHERE guid = '40065'; ================================================================================================ Honor Quests для вов бк Code UPDATE `quest_template` SET `ExclusiveGroup` = 11335 WHERE `entry` IN (11335, 11336, 11337, 11338); UPDATE `quest_template` SET `ExclusiveGroup` = 11339 WHERE `entry` IN (11339, 11340, 11341, 11342);
|
|
| |