Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Днем если проснусь сниффану еще раз первым лвлом, а то на персе уже со всеми поговорил, госсип итемов нема))
ПыСЫ: с кешем протупил: забыл удалить старый. Вместо того, что я выложил выше можно этот использовать.
Код:
UPDATE `creature_template` SET `gossip_menu_id` = 7260 WHERE `entry` = 16501;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7260, 8584);
UPDATE `creature_template` SET `gossip_menu_id` = 7264 WHERE `entry` = 16500;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7264, 8590);
UPDATE `creature_template` SET `gossip_menu_id` = 7522 WHERE `entry` = 17089;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7522, 8785);
UPDATE `creature_template` SET `gossip_menu_id` = 7263 WHERE `entry` = 16503;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7263, 8588);
UPDATE `creature_template` SET `gossip_menu_id` = 7262 WHERE `entry` = 16499;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7262, 8586);
UPDATE `creature_template` SET `gossip_menu_id` = 7349 WHERE `entry` = 16502;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7349, 8591);
UPDATE `creature_template` SET `gossip_menu_id` = 7368 WHERE `entry` = 17110;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7368, 8804);
UPDATE `creature_template` SET `gossip_menu_id` = 7467 WHERE `entry` = 17212;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7467, 8785);
UPDATE `creature_template` SET `gossip_menu_id` = 7260 WHERE `entry` = 17483;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7260, 8584);
UPDATE `creature_template` SET `gossip_menu_id` = 7265 WHERE `entry` = 17482;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7265, 8591);
UPDATE `creature_template` SET `gossip_menu_id` = 7922 WHERE `entry` = 19171;
UPDATE `gossip_menu` SET entry = 7922, text_id = 9696 WHERE entry = 10245;
UPDATE `creature_template` SET `gossip_menu_id` = 7264 WHERE `entry` = 16749;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7264, 8590);
UPDATE `creature_template` SET `gossip_menu_id` = 7264 WHERE `entry` = 17513;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7264, 8590);
UPDATE `creature_template` SET `gossip_menu_id` = 7264 WHERE `entry` = 17514;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7264, 8590);
UPDATE `creature_template` SET `gossip_menu_id` = 7260 WHERE `entry` = 17121;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7260, 8584);
UPDATE `creature_template` SET `gossip_menu_id` = 7260 WHERE `entry` = 17509;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7260, 8584);
UPDATE `creature_template` SET `gossip_menu_id` = 7260 WHERE `entry` = 16761;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7260, 8584);
UPDATE `creature_template` SET `gossip_menu_id` = 7777 WHERE `entry` = 20674;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7777, 9551);
UPDATE `creature_template` SET `gossip_menu_id` = 7859 WHERE `entry` = 18985;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7859, 9622);
Цитата:
Menus items
0: Покажите мне, Провидец!
Menu Id: 7858, Text Id: 9623
Дальше кастит 33137(в ДБС нету) и дает итем
http://www.wowhead.com/item=27317
|
UPDATE `creature_template` SET `gossip_menu_id` = 7357 WHERE `entry` = 17520;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7357, 8785);
UPDATE `creature_template` SET `gossip_menu_id` = 7357 WHERE `entry` = 17519;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7357, 8785);
UPDATE `creature_template` SET `gossip_menu_id` = 11902 WHERE `entry` = 15278;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (11902, 16703);
UPDATE `creature_template` SET `gossip_menu_id` = 6650 WHERE `entry` = 15285;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6650, 9187);
UPDATE `creature_template` SET `gossip_menu_id` = 6652 WHERE `entry` = 15513;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6652, 9189);
UPDATE `creature_template` SET `gossip_menu_id` = 6649 WHERE `entry` = 15284;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6649, 9007);
UPDATE `creature_template` SET `gossip_menu_id` = 6647 WHERE `entry` = 15280;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6647, 9193);
UPDATE `creature_template` SET `gossip_menu_id` = 6648 WHERE `entry` = 15279;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6648, 9191);
UPDATE `creature_template` SET `gossip_menu_id` = 6628 WHERE `entry` = 15283;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6628, 7903);
UPDATE `creature_template` SET `gossip_menu_id` = 12670 WHERE `entry` = 15494;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (12670, 12549);
UPDATE `creature_template` SET `gossip_menu_id` = 6570 WHERE `entry` = 15281;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6570, 7868);
UPDATE `creature_template` SET `gossip_menu_id` = 6573 WHERE `entry` = 15301;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6573, 7788);
UPDATE `creature_template` SET `gossip_menu_id` = 7323 WHERE `entry` = 16924;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7323, 8698);
UPDATE `creature_template` SET `gossip_menu_id` = 6652 WHERE `entry` = 16270;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6652, 9189);
UPDATE `creature_template` SET `gossip_menu_id` = 6647 WHERE `entry` = 16275;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6647, 9193);
UPDATE `creature_template` SET `gossip_menu_id` = 6650 WHERE `entry` = 16279;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6650, 9187);
UPDATE `creature_template` SET `gossip_menu_id` = 7566 WHERE `entry` = 16266;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7566, 9185);
UPDATE `creature_template` SET `gossip_menu_id` = 12670 WHERE `entry` = 16267;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (12670, 12549);
UPDATE `creature_template` SET `gossip_menu_id` = 6648 WHERE `entry` = 16269;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6648, 9191);
UPDATE `creature_template` SET `gossip_menu_id` = 6648 WHERE `entry` = 16269;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6648, 9191);
UPDATE `creature_template` SET `gossip_menu_id` = 7141 WHERE `entry` = 15416;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7141, 8403);
UPDATE `creature_template` SET `gossip_menu_id` = 7921 WHERE `entry` = 19169;
UPDATE `gossip_menu` SET `entry`=7921, `text_id`= 9700 WHERE entry = 50166;
UPDATE gossip_menu_option SET menu_id = 7921 WHERE menu_id = 50166
UPDATE `creature_template` SET `gossip_menu_id` = 7440 WHERE `entry` = 16568;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7440, 9008);
UPDATE `creature_template` SET `gossip_menu_id` = 9821 WHERE `entry` = 16656;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (9821, 13584);
UPDATE `creature_template` SET `gossip_menu_id` = 6652 WHERE `entry` = 16672;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6652, 9189);
UPDATE `creature_template` SET `gossip_menu_id` = 4783 WHERE `entry` = 16675;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4783, 5839);
UPDATE `creature_template` SET `gossip_menu_id` = 6647 WHERE `entry` = 16680;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6647, 9193);
UPDATE `creature_template` SET `gossip_menu_id` = 6647 WHERE `entry` = 16679;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6647, 9193);
UPDATE `creature_template` SET `gossip_menu_id` = 6647 WHERE `entry` = 16681;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6647, 9193);
UPDATE `creature_template` SET `gossip_menu_id` = 6650 WHERE `entry` = 16685;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6650, 9187);
UPDATE `creature_template` SET `gossip_menu_id` = 6650 WHERE `entry` = 16686;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6650, 9187);
UPDATE `creature_template` SET `gossip_menu_id` = 6650 WHERE `entry` = 16684;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6650, 9187);
UPDATE `creature_template` SET `gossip_menu_id` = 4605 WHERE `entry` = 16655;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4605, 5717);
UPDATE `creature_template` SET `gossip_menu_id` = 6832 WHERE `entry` = 15564;
UPDATE gossip_menu SET entry = 6832 WHERE entry = 15564;
UPDATE gossip_menu_option SET menu_id = 6832 WHERE menu_id =15564;
UPDATE gossip_menu_option SET action_menu_id = 6896 WHERE action_menu_id = 50067;
UPDATE gossip_menu_option SET action_menu_id = 6842 WHERE action_menu_id = 50073;
UPDATE gossip_menu_option SET action_menu_id = 6854 WHERE action_menu_id = 50080;
UPDATE gossip_menu_option SET action_menu_id = 6843 WHERE action_menu_id = 50086;
UPDATE gossip_menu_option SET action_menu_id = 6895 WHERE action_menu_id = 50123;
UPDATE gossip_menu SET entry = 6896 WHERE entry = 50067;
UPDATE gossip_menu SET entry = 6842 WHERE entry = 50073;
UPDATE gossip_menu SET entry = 6854 WHERE entry = 50080;
UPDATE gossip_menu SET entry = 6843 WHERE entry = 50086;
UPDATE gossip_menu SET entry = 6895 WHERE entry = 50123;
UPDATE `creature_template` SET `gossip_menu_id` = 10991 WHERE `entry` = 38295;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (10991, 15284);
UPDATE `creature_template` SET `gossip_menu_id` = 7927 WHERE `entry` = 19178;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7927, 9712);
UPDATE gossip_menu_option SET menu_id = 7927 WHERE menu_id = 50168;
UPDATE `creature_template` SET `gossip_menu_id` = 4542 WHERE `entry` = 4582;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4542, 4796);
UPDATE `creature_template` SET `gossip_menu_id` = 4541 WHERE `entry` = 4584;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4541, 4796);
UPDATE `creature_template` SET `gossip_menu_id` = 4540 WHERE `entry` = 4583;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4540, 4796);
UPDATE `creature_template` SET `gossip_menu_id` = 2383 WHERE `entry` = 4563;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (2383, 5715);
UPDATE `creature_template` SET `gossip_menu_id` = 4609 WHERE `entry` = 4564;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4609, 5720);
UPDATE `creature_template` SET `gossip_menu_id` = 4537 WHERE `entry` = 4568;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4537, 563);
UPDATE `creature_template` SET `gossip_menu_id` = 12670 WHERE `entry` = 5753;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (12670, 12549);
UPDATE `creature_template` SET `gossip_menu_id` = 4547 WHERE `entry` = 4595;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4547, 4984);
UPDATE `creature_template` SET `gossip_menu_id` = 4546 WHERE `entry` = 4594;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4546, 4984);
UPDATE `creature_template` SET `gossip_menu_id` = 4548 WHERE `entry` = 4593;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4548, 4984);
UPDATE `creature_template` SET `gossip_menu_id` = 4539 WHERE `entry` = 4566;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4539, 563);
UPDATE `creature_template` SET `gossip_menu_id` = 4538 WHERE `entry` = 4567;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4538, 563);
UPDATE `creature_template` SET `gossip_menu_id` = 4511 WHERE `entry` = 3354;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4511, 4985);
UPDATE `creature_template` SET `gossip_menu_id` = 4509 WHERE `entry` = 3353;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (4509, 4985);
UPDATE `creature_template` SET `gossip_menu_id` = 7925 WHERE `entry` = 19175;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7925, 9704);
UPDATE gossip_menu_option SET menu_id = 7925 WHERE menu_id =50167;
UPDATE `creature_template` SET `gossip_menu_id` = 1626 WHERE `entry` = 3370;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (1626, 2280);
UPDATE gossip_menu_option SET menu_id = 1626 WHERE menu_id =50173;
UPDATE `creature_template` SET `gossip_menu_id` = 6899 WHERE `entry` = 15579;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6899, 7935);
UPDATE gossip_menu_option SET menu_id = 6899 WHERE menu_id =15579;
UPDATE `creature_template` SET `gossip_menu_id` = 7935 WHERE `entry` = 19177;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (7935, 9716);
UPDATE gossip_menu_option SET menu_id = 7935 WHERE menu_id =50261;
UPDATE `creature_template` SET `gossip_menu_id` = 6815 WHERE `entry` = 15572;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6815, 7935);
UPDATE gossip_menu_option SET menu_id = 6815 WHERE menu_id =15572;
UPDATE `creature_template` SET `gossip_menu_id` = 64 WHERE `entry` = 5880;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (64, 565);
UPDATE `creature_template` SET `gossip_menu_id` = 6817 WHERE `entry` = 15597;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (6817, 7956);
UPDATE gossip_menu_option SET menu_id = 6817 WHERE menu_id =15597;
UPDATE `creature_template` SET `gossip_menu_id` = 9656 WHERE `entry` = 28126;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (9656, 13079);
UPDATE `creature_template` SET `gossip_menu_id` = 8064 WHERE `entry` = 20102;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (8064, 9964);
UPDATE gossip_menu_option SET menu_id = 8064 WHERE menu_id =50170;
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Последний раз редактировалось Heisenberg; 09.02.2011 в 04:32.
|