Многофункциональный питомец (# Карманный нпц для 3.3.5 #)

RomaN

RomaN

Гл Администратор

Сообщения : 336
Очки : 136436
Репутация : 10
Настроение : Многофункциональный питомец (# Карманный нпц для 3.3.5 #) Fc4c525ff8ae4fbd6459325b3734f974

conditions.sql:

gossip_menu.sql:

gossip_menu_option.sql:

Код:: delete from gossip_menu_option where menu_id between '55000' AND '55020'; REPLACE INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES ('55000', '4', '6', 'Банк', '9', '131072', '0', '0', '0', '0', null), ('55000', '5', '6', 'Аукцион', '13', '2097152', '0', '0', '0', '0', null), ('55001', '1', '3', 'Города Альянса', '1', '1', '55002', '1', '0', '0', null), ('55000', '3', '1', 'Магазин', '3', '128', '0', '0', '0', '0', null), ('55000', '1', '2', 'Телепорт Меню', '1', '1', '55001', '0', '0', '0', null), ('55020', '1', '3', '|TInterface/ICONS/Spell_holy_prayeroffortitude:20|t Молитва стойкости', '1', '1', '55020', '0', '0', '0', ''), ('55001', '2', '3', 'Города Орды', '1', '1', '55003', '0', '0', '0', null), ('55002', '1', '2', '1. Штормград', '1', '1', '55002', '0', '0', '0', 'Телепортировать?'), ('55002', '2', '2', '2. Стальгорн', '1', '1', '55002', '0', '0', '0', 'Телепортировать?'), ('55002', '3', '2', '3. Дарнас', '1', '1', '55002', '0', '0', '0', 'Телепортировать?'), ('55002', '4', '2', '4. Экзодар', '1', '1', '55002', '0', '0', '0', 'Телепортировать?'), ('55004', '1', '2', 'Гонки[1] - Gm ивент', '1', '1', '55004', '0', '111', '0', 'Телепортировать?'), ('55001', '888', '3', 'Евенты', '1', '1', '55004', '0', '0', '0', null), ('55004', '2', '2', 'Jump[1] |cff008000[Easy]|r - Автоивент', '1', '1', '55000', '0', '111', '0', 'Телепортировать?'), ('55004', '3', '2', 'Jump[2] |cffB80A0A[Hard]|r - Автоивент', '1', '1', '55004', '0', '111', '0', null), ('55020', '10', '3', '|TInterface/ICONS/Spell_holy_greaterblessingofwisdom:20|t Благословение мудрости', '1', '1', '55020', '0', '0', '0', null), ('55020', '999', '7', 'Назад...', '1', '1', '55000', '0', '0', '0', null), ('55001', '999', '7', 'Назад...', '1', '1', '55000', '0', '0', '0', null), ('55002', '999', '7', 'Назад...', '1', '1', '55001', '0', '0', '0', null), ('55020', '2', '3', '|TInterface/ICONS/Spell_magic_greaterblessingofkings:20|t Благословение королей', '1', '1', '55020', '0', '0', '0', null), ('55020', '3', '3', '|TInterface/ICONS/Spell_holy_excorcism:20|t Защита от страха', '1', '1', '55020', '0', '0', '0', null), ('55000', '2', '3', 'Баффер', '1', '1', '55020', '0', '0', '0', null), ('55003', '999', '7', 'Назад...', '1', '1', '55001', '0', '0', '0', null), ('55004', '999', '7', 'Назад...', '1', '1', '55001', '0', '0', '0', null), ('55020', '9', '3', '|TInterface/ICONS/Spell_holy_arcaneintellect:20|t Чародейская гениальность', '1', '1', '55020', '0', '0', '0', null), ('55020', '4', '3', '|TInterface/ICONS/Spell_holy_greaterblessingofkings:20|t Благословение могущества', '1', '1', '55020', '0', '0', '0', null), ('55020', '6', '3', '|TInterface/ICONS/Spell_holy_greaterblessingofsanctuary:20|t Благословение неприкосновенности', '1', '1', '55020', '0', '0', '0', null), ('55020', '5', '3', '|TInterface/ICONS/Spell_holy_prayerofspirit:20|t Молитва духа', '1', '1', '55020', '0', '0', '0', null), ('55020', '7', '3', '|TInterface/ICONS/Spell_nature_thorns:20|t Шипи', '1', '1', '55020', '0', '0', '0', null), ('55020', '8', '3', '|TInterface/ICONS/Spell_nature_regeneration:20|t Знак дикой природы', '1', '1', '55020', '0', '0', '0', null), ('55003', '1', '2', '1. Оргриммар', '1', '1', '55003', '0', '0', '0', null), ('55003', '2', '2', '2. Громовой Утес', '1', '1', '55003', '0', '0', '0', null), ('55003', '3', '2', '3. Подгород', '1', '1', '55003', '0', '0', '0', null), ('55003', '4', '2', '4. Луносвет', '1', '1', '55003', '0', '0', '0', null), ('55003', '5', '2', '5. Шаттрат', '1', '1', '55003', '0', '0', '0', null), ('55003', '6', '2', '6. Остров Кель Данас', '1', '1', '55003', '0', '0', '0', null), ('55003', '7', '2', '7. Даларан', '1', '1', '55003', '0', '0', '0', null), ('55002', '5', '2', '5. Шаттрат', '1', '1', '55002', '0', '0', '0', null), ('55002', '6', '2', '6. Остров Кель Данас', '1', '1', '55002', '0', '0', '0', null), ('55002', '7', '2', '7. Даларан', '1', '1', '55002', '0', '0', '0', null), ('55001', '3', '3', 'Арены', '1', '1', '55005', '0', '0', '0', null), ('55005', '1', '2', '1. Арена Гурубаши', '1', '1', '55005', '0', '0', '0', null), ('55005', '2', '2', '2. Арена в Круге Крови', '1', '1', '55005', '0', '0', '0', null), ('55005', '3', '2', '3. Круг испытаний', '1', '1', '55005', '0', '0', '0', null), ('55005', '4', '2', '4. Ристалище', '1', '1', '55005', '0', '0', '0', null), ('55005', '999', '7', 'Назад...', '1', '1', '55001', '0', '0', '0', null), ('55020', '11', '3', '|TInterface/ICONS/Spell_holy_prayerofshadowprotection:20|t Защита от темной магии', '1', '1', '55020', '0', '0', '0', null);

smart_scripts.sql:

Код:: DELETE FROM `smart_scripts` WHERE (`entryorguid`=23909); INSERT INTO `smart_scripts` VALUES ('23909', '0', '18', '0', '62', '0', '100', '0', '55005', '1', '0', '0', '62', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-13261.3', '168.294', '35.0792', '1.00688', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '19', '0', '62', '0', '100', '0', '55005', '2', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '2839.44', '5930.17', '11.1002', '3.16284', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '20', '0', '62', '0', '100', '0', '55005', '3', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-1999.94', '6581.71', '11.32', '2.3', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '21', '0', '62', '0', '100', '0', '55005', '4', '0', '0', '62', '1', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-3739.86', '1093.8', '131.968', '0.155619', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '212', '0', '62', '0', '100', '0', '55020', '11', '0', '0', '11', '48170', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '3', '0', '62', '0', '100', '0', '55002', '3', '0', '0', '62', '1', '0', '0', '0', '0', '0', '7', '0', '0', '0', '8781', '965', '30', '0', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '4', '0', '62', '0', '100', '0', '55002', '4', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-4073', '-12020', '-1', '0', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '5', '0', '62', '0', '100', '0', '55004', '1', '0', '0', '62', '1', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-5258.38', '-4449.28', '86.1115', '3.1947', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '6', '0', '62', '0', '100', '0', '55004', '2', '0', '0', '62', '1', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-2629.25', '2984.89', '232.613', '4.03196', 'Jump'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '200', '0', '62', '0', '100', '0', '55020', '1', '0', '0', '11', '48162', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '201', '0', '62', '0', '100', '0', '55020', '2', '0', '0', '11', '25898', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '202', '0', '62', '0', '100', '0', '55020', '3', '0', '0', '11', '6346', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '208', '0', '62', '0', '100', '0', '55020', '7', '0', '0', '11', '53307', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '204', '0', '62', '0', '100', '0', '55020', '4', '0', '0', '11', '48934', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '206', '0', '62', '0', '100', '0', '55020', '5', '0', '0', '11', '48074', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '207', '0', '62', '0', '100', '0', '55020', '6', '0', '0', '11', '25899', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '209', '0', '62', '0', '100', '0', '55020', '8', '0', '0', '11', '48469', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '210', '0', '62', '0', '100', '0', '55020', '9', '0', '0', '11', '43002', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '211', '0', '62', '0', '100', '0', '55020', '10', '0', '0', '11', '48938', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'buff'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '7', '0', '62', '0', '100', '0', '55004', '3', '0', '0', '62', '1', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-10372.3', '-3915.49', '0.56', '3.85', 'Jump Hard'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '8', '0', '62', '0', '100', '0', '55003', '1', '0', '0', '62', '1', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1377.78', '-4369.87', '26.0264', '0.15315', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '9', '0', '62', '0', '100', '0', '55003', '2', '0', '0', '62', '1', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-1290', '147.034', '129.682', '4.919', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '10', '0', '62', '0', '100', '0', '55003', '3', '0', '0', '62', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1642.13', '239.71', '62.5916', '3.15534', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '11', '0', '62', '0', '100', '0', '55003', '4', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '9338.74', '-7277.27', '13.7895', '0', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '12', '0', '62', '0', '100', '0', '55003', '5', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-1850.21', '5435.82', '-10.9614', '3.40391', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '13', '0', '62', '0', '100', '0', '55003', '6', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '12947.4', '-6893.31', '5.68398', '3.09154', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '14', '0', '62', '0', '100', '0', '55003', '7', '0', '0', '62', '571', '0', '0', '0', '0', '0', '7', '0', '0', '0', '5807.67', '588.207', '660.93', '1.70185', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '15', '0', '62', '0', '100', '0', '55002', '5', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-1850.21', '5435.82', '-10.9614', '3.40391', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '16', '0', '62', '0', '100', '0', '55002', '6', '0', '0', '62', '530', '0', '0', '0', '0', '0', '7', '0', '0', '0', '12947.4', '-6893.31', '5.68398', '3.09154', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '17', '0', '62', '0', '100', '0', '55002', '7', '0', '0', '62', '571', '0', '0', '0', '0', '0', '7', '0', '0', '0', '5807.67', '588.207', '660.93', '1.70185', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '2', '0', '62', '0', '100', '0', '55002', '2', '0', '0', '62', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-4991.78', '-870.59', '496.98', '5.30771', 'TP'); INSERT INTO `smart_scripts` VALUES ('23909', '0', '1', '0', '62', '0', '100', '0', '55002', '1', '0', '0', '62', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-8960.14', '516.266', '96.3568', '0', 'TP');