WoW JP

External Mail?

djonii — Sat, 30 Apr 2016 13:47:15 GMT

Форум: Патчи / Моды / Фиксы для SkyFire
Автор темы: djonii
Автор последнего сообщения: Teaching_shop
Количество ответов: 3

Мой НПС такого еще нигде не видал

nekropolis — Sat, 26 Jan 2013 11:05:38 GMT

Вообщем суть такова НПС под видом Паладина стоит там где поставите)
Игрок подходит и кидает ему дуэль))
кастует как паладин)
Убил 2 часа) на скриптовку так как в программировании не особо силен )

При 10% жизней у моба или у игрока дуэль отменяется выигрывает тот у кого осталось больше 10%
При несчастном случае то есть ударил в конце очень сильно моб умер ) поставил функцию авто респавна
Немного поработал над комбо в кастах , он сначала кидает стан , потом экзорцизм, и сразу открывается хилка мгновенка он ее и юзает )
Берите может кому пригодится, а может кто то допишет или улучшит) я думаю сделать под все классы по такому мобу)

SQL

Code

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `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`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (900111, 0, 0, 0, 0, 0, 30199, 0, 0, 0, 'Paladin', 'FreeDom', 'pvp', 0, 85, 85, 0, 35, 35, 1, 1, 1, 1, 1, 2500.4, 2790.2, 0, 4600, 1, 2000, 0, 1, 0, 0, 0, 0, 0, 2, 0, 720, 1050.6, 320, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, 68000, 20000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 363, 0, 0, 'test_npc_mikolas', 12340);

test_npc_mikolas.cpp

Code

/*######
       ## test_npc_mikolas
       ######*/
#include "ScriptPCH.h"

#define SAY_ENTER1                  -1560013
#define SAY_ENTER2                  -1560014
#define SAY_ENTER3                  -1560015
#define SAY_AGGRO1                  -1560016
#define SAY_AGGRO2                  -1560017
#define SAY_SLAY1                   -1560018
#define SAY_SLAY2                   -1560019
#define SAY_BREATH1                 -1560020
#define SAY_BREATH2                 -1560021
#define SAY_DEATH                   -1560022

#define SPELL_SAND_BREATH           853
#define SPELL_HILKA           635
#define SPELL_MAGIC_DISRUPTION_AURA 31801
#define SPELL_WING_BUFFET           879

/// айди спелов дуэлей не трогайте!!
#define SPELL_DUEL  52996   ///
#define SPELL_DUELS 52996   ///
#define SPELL_DUEL_VICTORY  52994   ///
#define SPELL_DUEL_FLAG  52991  ///
///-----------------------------------

#define SPELL_IMUN                  26573
#define SPELL_HVATKA                24275
#define SPELL_UDARCHUMI             31884
#define SPELL_PANSIR                20271
#define SPELL_STOIKA    7294

#define GOSSIP_HAH "Ti to4no hotish PVP?"
#define GOSSIP_SAH "Nu davai posmotrim)."

class test_npc_mikolas: public CreatureScript {
public:
          test_npc_mikolas() :
                  CreatureScript("test_npc_mikolas") {
          }

          CreatureAI* GetAI(Creature* pCreature) const {
              return new test_npc_mikolasAI(pCreature);
          }
       // второе меню госипа
          bool OnGossipSelect(Player* pPlayer, Creature* pCreature,
                  uint32 /*uiSender*/, uint32 uiAction) {
              pPlayer->PlayerTalkClass->ClearMenus();
              switch (uiAction) {
              case GOSSIP_ACTION_INFO_DEF + 1:
                  pPlayer->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, GOSSIP_SAH, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF + 2);
                  pPlayer->SEND_GOSSIP_MENU(624, pCreature->GetGUID());
                  break;
              case GOSSIP_ACTION_INFO_DEF + 2:
                  pPlayer->CLOSE_GOSSIP_MENU();
         pPlayer->CastSpell(pPlayer, SPELL_DUEL_FLAG, true);
                  pCreature->setFaction(21);
                  if (pPlayer)
                      CAST_AI(test_npc_mikolas::test_npc_mikolasAI, pCreature->AI())->AttackStart(pPlayer);
                  break;
              }
              return true;
          }

       // Первое меню госипа

          bool OnGossipHello(Player* pPlayer, Creature* pCreature) {

                  pPlayer->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, GOSSIP_HAH, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF + 1);

              pPlayer->SEND_GOSSIP_MENU(623, pCreature->GetGUID());


              return true;
          }

          struct test_npc_mikolasAI: public ScriptedAI {
              test_npc_mikolasAI(Creature *c) :
                      ScriptedAI(c)
          {

                m_bIsDuelInProgress = false;

              }
              bool lose;
              uint64 m_uiDuelerGUID;
              uint32 m_uiDuelTimer;
              bool m_bIsDuelInProgress;
        uint32 SandBreath_Timer;
              uint32 hilka_Timer;
              uint32 WingBuffet_Timer;
              uint32 Mda_Timer;

        uint32 IMUN_Timer;
        uint32 HVATKA_Timer;
        uint32 UDARCHUMI_Timer;
        uint32 PANSIR_Timer;
        uint32 STOIKA_Timer;

// таймеры
              void Reset()
        {
                  me->setFaction(35);
         SandBreath_Timer = 1000 + rand() % 5000;
                  hilka_Timer = 25000 + rand() % 5000;
                  WingBuffet_Timer = 15000;
                  Mda_Timer = 25000;
         IMUN_Timer= 50000;
         HVATKA_Timer= 22000;
         UDARCHUMI_Timer= 13000;
         PANSIR_Timer= 7000;
         STOIKA_Timer= 3000;


              }

/// при входе в комбат варнякаем чет и кастум)

              void EnterCombat(Unit*)
        {
          DoScriptText(RAND(SAY_AGGRO1, SAY_AGGRO2), me);
            DoCast(me->getVictim(), SPELL_STOIKA);

              }




         void SpellHit(Unit* pCaster, const SpellEntry* pSpell)
        {
                  if (!m_bIsDuelInProgress && pSpell->Id == SPELL_DUEL)
         {
                      m_uiDuelerGUID = pCaster->GetGUID();
                      m_bIsDuelInProgress = true;



                  }
              }

         void DamageTaken(Unit* pDoneBy, uint32 &uiDamage)
        {
                  if (m_bIsDuelInProgress && pDoneBy->IsControlledByPlayer())
         {

          // во время дуэли моб зеленый для других игроков

                      if (pDoneBy->GetGUID() != m_uiDuelerGUID && pDoneBy->GetOwnerGUID() != m_uiDuelerGUID)
                          uiDamage = 0;
                      else if (uiDamage >= me->GetHealth())
          {
                          uiDamage = 0;

                          if (!lose)
           {
                    pDoneBy->RemoveGameObject(SPELL_DUEL_FLAG, true);
                    pDoneBy->AttackStop();
                    me->CastSpell(pDoneBy, SPELL_DUEL_VICTORY, true);
                    lose = true;
                    me->CastSpell(me, 7267, true);
                    me->RestoreFaction();

                          }

                      }
                  }
              }

// при смерти говорим SAY_DEATH

              void JustDied(Unit * /*who*/)
        {

           DoScriptText(SAY_DEATH, me);
           me->Respawn();


              }

         void UpdateAI(const uint32 diff)
         {

                  if (!UpdateVictim())
                      return;

///если у игрока  жизней меньше 10 % останавливаем дуэль и плачем)

          else if (me->getVictim()->GetTypeId() == TYPEID_PLAYER
                    && me->getVictim()->HealthBelowPct(10))
          {
                          me->getVictim()->CastSpell(me->getVictim(), 7267, true); // beg
                          me->getVictim()->RemoveGameObject(SPELL_DUEL_FLAG, true);
           me->CastSpell(me, 7267, true);
              me->AttackStop();
                          DoResetThreat();
                          EnterEvadeMode();
                          return;
                      }

///если у моба  жизней меньше 10 % останавливаем дуэль и плачем)

         if (me->HealthBelowPct(10))
         {
         me->AttackStop();
                  DoResetThreat();
                  EnterEvadeMode();
                  return;

         }

                  //Sand Breath
                  if (SandBreath_Timer <= diff) {
                      if (me->IsNonMeleeSpellCasted(false))
                          me->InterruptNonMeleeSpells(false);

                      DoCast(me->getVictim(), SPELL_SAND_BREATH);

                      DoScriptText(RAND(SAY_BREATH1, SAY_BREATH2), me);

                      SandBreath_Timer = 10000 + rand() % 10000;
                  } else
                      SandBreath_Timer -= diff;

                  if (hilka_Timer <= diff)
         {
                     me->CastSpell(me, SPELL_HILKA, true);
                      hilka_Timer = 25000 + rand() % 5000;
                  } else
                      hilka_Timer -= diff;

                  if (WingBuffet_Timer <= diff)
         {
                      if (Unit *pTarget = SelectUnit(SELECT_TARGET_RANDOM, 0))
                          DoCast(pTarget, SPELL_WING_BUFFET);
                      WingBuffet_Timer = 25000 + rand() % 10000;
                  } else
                      WingBuffet_Timer -= diff;

                  if (Mda_Timer <= diff)
         {
                      DoCast(me, SPELL_MAGIC_DISRUPTION_AURA);
                      Mda_Timer = 15000;
                  } else
                      Mda_Timer -= diff;

         //______________________

         if (HVATKA_Timer <= diff)
         {
                      if (Unit *pTarget = SelectUnit(SELECT_TARGET_RANDOM, 0))
                          DoCast(pTarget, SPELL_HVATKA);
                      HVATKA_Timer = 25000 + rand() % 10000;
                  } else
                      HVATKA_Timer -= diff;

         if (IMUN_Timer <= diff)
         {
                      if (Unit *pTarget = SelectUnit(SELECT_TARGET_RANDOM, 0))
                          DoCast(pTarget, SPELL_IMUN);
                      IMUN_Timer = 25000 + rand() % 10000;
                  } else
                      IMUN_Timer -= diff;

         if (UDARCHUMI_Timer <= diff)
         {
                      if (Unit *pTarget = SelectUnit(SELECT_TARGET_RANDOM, 0))
                          DoCast(pTarget, SPELL_UDARCHUMI);
                      UDARCHUMI_Timer = 25000 + rand() % 10000;
                  } else
                      UDARCHUMI_Timer -= diff;

         if (PANSIR_Timer <= diff)
         {
                      if (Unit *pTarget = SelectUnit(SELECT_TARGET_RANDOM, 0))
                          DoCast(pTarget, SPELL_PANSIR);
                      PANSIR_Timer = 25000 + rand() % 10000;
                  } else
                      PANSIR_Timer -= diff;

                  DoMeleeAttackIfReady();
              }

          };
};

void AddSC_test_npc_mikolas() {
          new test_npc_mikolas();

}

Не забудьте добавить его в скриптлоадер )

Редактор Cataclysm BD

XkillerX — Wed, 09 Jan 2013 22:07:44 GMT

Skystudio,является редактором базы данных, которая стремится быть совместимы с Skyfire и остальных проектов.
Оно может полностью создать или изменить Creatures, Game-объектов, квесты и основные Loot!
Наконец, первый стабильный релиз.
Скачать :
Skystudio

Источник:
SkyFire

Фиксы для ядра Skyfire 4.x.x

Repack — Mon, 05 Nov 2012 19:47:32 GMT

Всем привет!Решил перенести тему в раздел SkyFire
Так же будет дополняться.

Спеллы

Друиды

Друид может войти в стелс без облика кошки:

Code

insert into spell_linked_spell values ('-768', '-5215', '0', 'Druid - Prowl Remove');

Чернокнижники

При создании камня здоровья не появляется сам камень:

Code

insert into spell_linked_spell values ('6201', '34130', '0', 'Warlock - Create Healthstone');

Исправление призыва инфернала

Code

insert into spell_linked_spell values ('1122', '22703', '0', 'Warlock - Summon Infernal');

Воины

Талант "Внезапная смерть" не сбрасывает время восстановления способности "Удар колосса"

Code

insert into spell_linked_spell values ('29723', '52437', '0', 'Warrior - Sudden Death rank 1');
insert into spell_linked_spell values ('29725', '52437', '0', 'Warrior - Sudden Death rank 2');

Итемы

Стреломет

Code

INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(60100, 6, 0, 1, 5, 0, 100, 0, 5, 5, 0, 32201, 0, 0, 0, 0, 0, 0, 0, 11, 32201, 40, 0, 0, 0, 0, 0, 'Dart Gun');

Червленый вяз

Code

INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(74087, 6, 0, 1, 5, 0, 0, 0, 0, 0, 0, 39619, 0, 0, 0, 0, 0, 0, 0, 9, 39619, 0, 5, 0, 0, 0, 0, 'Blackjack');

Так же,вы можете писать о багах,будем исправлять ;)

Трансмогификация. Скрипт для 3.3.5-4.0.6

wlasser — Sat, 01 Sep 2012 09:58:12 GMT

В оригинале взято с форумов ace-web.

Code

/*******************************************************
    * Name: Transmogrification NPC for Legendary Weapons
    * ScriptName:'npc_transmogweap'
    * (c)2012 - JunkyBulgaria
    * Website: www.Hysteria-Gaming.EU
    * E-Mail: developer@hysteria-gaming.eu
    * Skype: jenova_ff
    * script improve by wlasser
    *******************************************************/

       шапка = [PLAYER_VISIBLE_ITEM_1_ENTRYID];
       амулет = [PLAYER_VISIBLE_ITEM_2_ENTRYID];
       плечи = [PLAYER_VISIBLE_ITEM_3_ENTRYID];
       рубашка = [PLAYER_VISIBLE_ITEM_4_ENTRYID];
       нагрудник = [PLAYER_VISIBLE_ITEM_5_ENTRYID];
       пояс = [PLAYER_VISIBLE_ITEM_6_ENTRYID];
       наголеники = [PLAYER_VISIBLE_ITEM_7_ENTRYID];
       обувь = [PLAYER_VISIBLE_ITEM_8_ENTRYID];
       наручники = [PLAYER_VISIBLE_ITEM_9_ENTRYID];
       перчатки = [PLAYER_VISIBLE_ITEM_10_ENTRYID];

       плащ = [PLAYER_VISIBLE_ITEM_15_ENTRYID];
       основная рука (оружие) = [PLAYER_VISIBLE_ITEM_16_ENTRYID];
       левая рука (оффхэнд) = [PLAYER_VISIBLE_ITEM_17_ENTRYID];
       дальний бой = [PLAYER_VISIBLE_ITEM_18_ENTRYID];
       табард = [PLAYER_VISIBLE_ITEM_19_ENTRYID];

*/
#include "ScriptPCH.h"

class npc_transmogweap : public CreatureScript
{
public:
       npc_transmogweap() : CreatureScript("npc_transmogweap") { }

       bool OnGossipHello(Player *player, Creature *_creature)
       {
           if (player->isInCombat())
           {
               player->CLOSE_GOSSIP_MENU();
               _creature->MonsterWhisper("Бой!", player->GetGUID());
               return true;
           }
           else
           {
               player->ADD_GOSSIP_ITEM( 3, "|cffBB0000Легендарки (оружие)"                    , GOSSIP_SENDER_MAIN, 1);
               player->ADD_GOSSIP_ITEM( 3, "Экипировка (Комплект А3 - прист)"                    , GOSSIP_SENDER_MAIN, 2);
               player->ADD_GOSSIP_ITEM( 3, "Экипировка (Т3 - воин)"                    , GOSSIP_SENDER_MAIN, 3);
               player->ADD_GOSSIP_ITEM( 3, "Экипировка (Т6 - паладин)"                    , GOSSIP_SENDER_MAIN, 4);
               player->ADD_GOSSIP_ITEM( 3, "|cffFF0000Спасибо, воздержусь от трансмогификации."                    ,GOSSIP_SENDER_MAIN, 999);
           }

           player->SEND_GOSSIP_MENU(DEFAULT_GOSSIP_MESSAGE, _creature->GetGUID());
           return true;
       }

       bool OnGossipSelect(Player *player, Creature *_creature, uint32 sender, uint32 uiAction)
       {
           if (sender == GOSSIP_SENDER_MAIN)
           {
               player->PlayerTalkClass->ClearMenus();
               switch(uiAction)
               {
      case 999:
                  player->CLOSE_GOSSIP_MENU();
               _creature->MonsterWhisper("Заходи снова друг!", player->GetGUID());
      break;
           case 1://weapons
                           player->ADD_GOSSIP_ITEM( 3, "|cff3300FFГромовая Ярость, благословенный клинок Искателя Ветра" , GOSSIP_SENDER_MAIN, 100);
                           player->ADD_GOSSIP_ITEM( 3, "|cff3300FFБоевой клинок Аззинота (левая рука)"   , GOSSIP_SENDER_MAIN, 101);
                           player->ADD_GOSSIP_ITEM( 3, "|cff3300FFБоевой клинок Аззинота (правая рука)"                      , GOSSIP_SENDER_MAIN, 102);
                           player->ADD_GOSSIP_ITEM( 3, "|cff3300FFТори'дал, Звeздная Ярость (лук)"                      , GOSSIP_SENDER_MAIN, 103);
                           player->ADD_GOSSIP_ITEM( 3, "|cff3300FFДлинный лук Края Пустоты"                    , GOSSIP_SENDER_MAIN, 104);
                           player->ADD_GOSSIP_ITEM( 3, "|cff3300FFСокрушитель"                      , GOSSIP_SENDER_MAIN, 105);
                           player->ADD_GOSSIP_ITEM( 3, "|cff3300FFВал'анир, молот древних королей"                    , GOSSIP_SENDER_MAIN, 106);
                           player->SEND_GOSSIP_MENU(DEFAULT_GOSSIP_MESSAGE, _creature->GetGUID());
                           break;

               case 2://a3 priest
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_1_ENTRYID, 33718);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_3_ENTRYID, 33720);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_5_ENTRYID, 33721);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_10_ENTRYID, 33717);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_7_ENTRYID, 33719);
                     _creature->MonsterWhisper("Экипировка сменилась на А3 жреца", player->GetGUID());
                     break;

               case 3://t2 war
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_1_ENTRYID, 16963);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_3_ENTRYID, 16961);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_5_ENTRYID, 16966);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_10_ENTRYID, 16964);
                     player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_7_ENTRYID, 16962);
                     player->CLOSE_GOSSIP_MENU();
                     _creature->MonsterWhisper("Экипировка сменилась на Т2 воина", player->GetGUID());
                     break;

               case 4://t6 pal
                      player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_1_ENTRYID, 30989);
                      player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_3_ENTRYID, 30997);
                      player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_5_ENTRYID, 30990);
                      player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_10_ENTRYID, 30982);
                      player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_7_ENTRYID, 30993);
                      player->CLOSE_GOSSIP_MENU();
                     _creature->MonsterWhisper("Экипировка сменилась на Т6 паладина", player->GetGUID());
       break;
                   case 100:
             player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_16_ENTRYID, 19019);
       player->CLOSE_GOSSIP_MENU();
             _creature->MonsterWhisper("Оружие трансмогифицировано!", player->GetGUID());
         break;
             case 101:
             player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_16_ENTRYID, 32837);
       player->CLOSE_GOSSIP_MENU();
             _creature->MonsterWhisper("Оружие трансмогифицировано!", player->GetGUID());
         break;
             case 102:
             player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_17_ENTRYID, 32838);
       player->CLOSE_GOSSIP_MENU();
             _creature->MonsterWhisper("Оружие трансмогифицировано!", player->GetGUID());
         break;
             case 103:
             player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_18_ENTRYID, 34334);
       player->CLOSE_GOSSIP_MENU();
             _creature->MonsterWhisper("Оружие трансмогифицировано!", player->GetGUID());
         break;
             case 104:
             player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_18_ENTRYID, 30318);
       player->CLOSE_GOSSIP_MENU();
             _creature->MonsterWhisper("Оружие трансмогифицировано!", player->GetGUID());
         break;
             case 105:
             player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_16_ENTRYID, 30316);
       player->CLOSE_GOSSIP_MENU();
             _creature->MonsterWhisper("Оружие трансмогифицировано!", player->GetGUID());
         break;
             case 106:
             player->UpdateUInt32Value(PLAYER_VISIBLE_ITEM_16_ENTRYID, 46017);
       player->CLOSE_GOSSIP_MENU();
             _creature->MonsterWhisper("Оружие трансмогифицировано!", player->GetGUID());
         break;
           default:
           break;
       }
      }
     return true;
    }
};

void AddSC_npc_transmogweap()
{
       new npc_transmogweap();
}

Файл скрипта необходимо обозвать npc_trans.cpp и поместить в src/scripts/Custom

После чего в ScriptLoader.cpp добавить следующие строчки после

Code

/* This is where custom scripts' loading functions should be declared. */

Code

void AddSC_npc_transmogweap();

и после

Code

/* This is where custom scripts should be added. */

Code

AddSC_npc_transmogweap();

Патч в базу:

Инсты катаклизма 80-85 [100] [100] [100]

Peg — Tue, 14 Aug 2012 16:24:51 GMT

В этой теме буду выкладывать свои наработки в данной сфере. буду обновлять 1-ый пост. ну и последний, чтобы тему поднимать)

p.s. заселял на глаз. где-то не добавил, где-то переборщил. не судите строго. лучше чем ничего

p.s. кто будет думать что я компастер:)) тот неправильно думает.

===========================================================================================
Затерянный город Тол'Вир
почти полностью. кроме сиамата (у меня на серве центральной части инсты нету как текстуры. будто блин вместе с далараном и кусок инсты перенесли куда-то)
настроил гер/нормал. ссылка обновлена.

[superhideII=100]0u%3300u%3600u%5300u%7300u%7300u%1600u%3300u%3300u%3600u%6300u%6300u%5300u%1300u%2300u%7300u%1600u%0300u%1600u%6600u%7300u%2300u%9300u%5600u %5600u%6300u%4300u%4600u%0300u%6600u%f200u%d600u%f600u%3600u%e200u%d600u%1600u%5600u%2600u%5600u%c600u%9600u%6600u%f200u%f200u%a300u%0700u%4 700u%4700u%8600u%3300u%8300u%460[/superhideII]
===========================================================================================

Грим Батол

Настроил нормал/героик. ссылка обновлена

[superhideII=100]0u%4300u%8300u%2300u%5300u%3300u%9300u%8300u%4300u%3300u%7300u%1300u%3300u%0300u%1300u%1600u%1300u%7300u%7300u%0300u%2600u%4600u%1600u%4300u %2600u%2300u%2600u%9300u%9300u%4300u%f200u%d600u%f600u%3600u%e200u%d600u%1600u%5600u%2600u%5600u%c600u%9600u%6600u%f200u%f200u%a300u%0700u%4 700u%4700u%8600u%4600u%4300u%830[/superhideII]
===========================================================================================
Чертоги созидания
не настроен лифт и рычаги для 1-го босса (их нет вообще), не ставил троггов в чертогах огня

[superhideII=100]0u%6600u%5600u%7300u%4300u%6600u%3600u%4600u%1600u%8300u%4300u%6300u%9300u%6300u%9300u%6300u%6300u%2600u%8300u%1300u%3300u%6600u%3600u%3600u %4300u%6300u%4300u%1600u%9300u%4600u%f200u%d600u%f600u%3600u%e200u%d600u%1600u%5600u%2600u%5600u%c600u%9600u%6600u%f200u%f200u%a300u%0700u%4 700u%4700u%8600u%5300u%6300u%530[/superhideII]
===========================================================================================
Исправление лута в героиках которые были настроены мною.

===========================================================================================
Мертвые копи (нормал+гер)

[superhideII=100]0u%0300u%5600u%8300u%3300u%9300u%3600u%2600u%5300u%0300u%4300u%4300u%9300u%5300u%2300u%6600u%4600u%2300u%5600u%4600u%5600u%3300u%6300u%2600u %9300u%4600u%6600u%3300u%5600u%2600u%f200u%d600u%f600u%3600u%e200u%d600u%1600u%5600u%2600u%5600u%c600u%9600u%6600u%f200u%f200u%a300u%0700u%4 700u%4700u%8600u%4300u%5600u%830[/superhideII]

===========================================================================================
Крепость темного клыка (нормал/гер)

[superhideII=100]0u%5300u%7300u%1300u%6600u%4300u%9300u%2300u%3600u%5300u%9300u%2300u%4600u%7300u%9300u%4600u%2600u%3600u%8300u%2600u%5600u%4600u%5600u%0300u %4300u%7300u%5600u%5600u%9300u%1600u%f200u%d600u%f600u%3600u%e200u%d600u%1600u%5600u%2600u%5600u%c600u%9600u%6600u%f200u%f200u%a300u%0700u%4 700u%4700u%8600u%7300u%8300u%560[/superhideII]

правка на 1-го босса фракцию забыл)

===========================================================================================
Пещеры Черной горы
[superhideII=100]0u%4600u%7300u%6600u%4300u%1300u%1600u%0300u%5300u%4600u%0300u%9300u%7300u%8300u%6600u%1600u%4600u%6600u%5600u%7300u%0300u%5300u%1300u%8300u %3600u%1600u%7300u%2300u%7300u%2300u%f200u%d600u%f600u%3600u%e200u%d600u%1600u%5600u%2600u%5600u%c600u%9600u%6600u%f200u%f200u%a300u%0700u%4 700u%4700u%8600u%5300u%4300u%430[/superhideII]

исправление времени спауна в инстах которые были настроены мною

Code

---npc---
update `creature` set `spawntimesecs`= 3600 where `map`= 645;
update `creature` set `spawntimesecs`= 3600 where `map`= 644;
update `creature` set `spawntimesecs`= 3600 where `map`= 670;
update `creature` set `spawntimesecs`= 3600 where `map`= 755;
update `creature` set `spawntimesecs`= 3600 where `map`= 33;
update `creature` set `spawntimesecs`= 3600 where `map`= 36;
---boss---
update `creature` set `spawntimesecs`= 86400 where `id`= 39665;
update `creature` set `spawntimesecs`= 86400 where `id`= 39679;
update `creature` set `spawntimesecs`= 86400 where `id`= 39698;
update `creature` set `spawntimesecs`= 86400 where `id`= 39700;
update `creature` set `spawntimesecs`= 86400 where `id`= 39705;
update `creature` set `spawntimesecs`= 86400 where `id`= 40484;
update `creature` set `spawntimesecs`= 86400 where `id`= 40177;
update `creature` set `spawntimesecs`= 86400 where `id`= 40319;
update `creature` set `spawntimesecs`= 86400 where `id`= 46962;
update `creature` set `spawntimesecs`= 86400 where `id`= 46963;
update `creature` set `spawntimesecs`= 86400 where `id`= 4278;
update `creature` set `spawntimesecs`= 86400 where `id`= 46964;
update `creature` set `spawntimesecs`= 86400 where `id`= 3887;
update `creature` set `spawntimesecs`= 86400 where `id`= 49045;
update `creature` set `spawntimesecs`= 86400 where `id`= 43612;
update `creature` set `spawntimesecs`= 86400 where `id`= 44577;
update `creature` set `spawntimesecs`= 86400 where `id`= 43614;
update `creature` set `spawntimesecs`= 86400 where `id`= 39731;
update `creature` set `spawntimesecs`= 86400 where `id`= 39788;
update `creature` set `spawntimesecs`= 86400 where `id`= 39587;
update `creature` set `spawntimesecs`= 86400 where `id`= 39428;
update `creature` set `spawntimesecs`= 86400 where `id`= 39378;
update `creature` set `spawntimesecs`= 86400 where `id`= 39732;
update `creature` set `spawntimesecs`= 86400 where `id`= 39425;
update `creature` set `spawntimesecs`= 86400 where `id`= 47162;
update `creature` set `spawntimesecs`= 86400 where `id`= 47296;
update `creature` set `spawntimesecs`= 86400 where `id`= 43778;
update `creature` set `spawntimesecs`= 86400 where `id`= 47626;
update `creature` set `spawntimesecs`= 86400 where `id`= 47739;
update `creature` set `spawntimesecs`= 86400 where `id`= 49541;

=======================================================================
Скажем все дружно спасибо =Perfectman'y= за заселение сумеречного бастиона.
Сумеречный бастион

и за заселения трона четырех ветров
ТЧВ

Вопрос по SmartAI

nekropolis — Wed, 01 Aug 2012 09:51:18 GMT

Ребята помогите разобраться почему не стартует SmartAI я написал простенький скрипт мобу , влил в базу в трайсе он отображается а вот при перезапуске сервера моб не исполняет событие
ставил даже при агро 100 % шанс каст спела на цель и все рано ничего.
Использовал программу SmartAI , версия БД Арк коре последняя ревизия
может после влива в базу скрипта нужно где то мобу что то включить ?
Пример
Code

INSERT INTO `smart_scripts` VALUES (3322, 0, 0, 0, 10, 0, 100, 0, 100, 0, 600, 0, 11, 100, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Smart Script");

Добавлено (28.07.2012, 23:02)
---------------------------------------------
моб при агре должен кастануть спел стана варовский с айдишником 100

Вот скрны как все выставлено

20 рисовочек

nekropolis — Fri, 27 Jul 2012 14:00:44 GMT

Часть 1

REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900000, 2, 6, -1, 'Vicious Gladiator\'s Pike FreeDom', 79850, 4, 4096, 8192, 1, 2104994, 420998, 17, -1, -1, 359, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 541, 7, 712, 32, 428, 35, 428, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3600, 0, 0, 1, 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, 2, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2802, 1191, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900001, 2, 13, -1, 'Vicious Gladiator\'s Right Ripper FreeDom', 94531, 4, 4096, 8192, 1, 1747364, 349472, 21, 262143, -1, 359, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 346, 7, 419, 32, 97, 35, 97, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2600, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 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, 7, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900002, 2, 13, -1, 'Vicious Gladiator\'s Left Ripper FreeDom', 94534, 4, 4096, 8192, 1, 1753718, 350743, 22, 262143, -1, 359, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 346, 7, 419, 32, 97, 35, 97, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2600, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 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, 7, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900003, 2, 13, -1, 'Vicious Gladiator\'s Right Render FreeDom', 94537, 4, 4096, 8192, 1, 1744141, 348828, 21, 262143, -1, 372, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 365, 7, 448, 32, 310, 35, 310, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2600, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 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, 7, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900004, 2, 13, -1, 'Vicious Gladiator\'s Left Render FreeDom', 94539, 4, 4096, 8192, 1, 1810977, 362195, 22, 262143, -1, 372, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 365, 7, 448, 32, 310, 35, 310, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2600, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 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, 7, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900005, 4, 0, -1, 'Vicious Gladiator\'s Endgame FreeDom', 82631, 4, 4096, 8192, 1, 1, 1, 23, -1, -1, 359, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5, 390, 7, 486, 32, 327, 35, 327, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 1, '', 0, 0, 0, 0, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900006, 4, 6, -1, 'Vicious Gladiator\'s Shield Wall FreeDom', 82965, 4, 4096, 8192, 1, 1073580, 214716, 14, -1, -1, 359, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 390, 7, 486, 32, 327, 35, 327, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 4, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900007, 4, 6, -1, 'Vicious Gladiator\'s Barrier FreeDom', 82963, 4, 4096, 8192, 1, 1150493, 230098, 14, -1, -1, 372, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5, 415, 7, 522, 32, 343, 35, 343, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 4, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `delay`, `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`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (900008, 2, 2, -1, 'Vicious Gladiator\'s Longbow FreeDom', 79854, 4, 4096, 8192, 1, 1229766, 245953, 15, -1, -1, 359, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 307, 7, 361, 32, 272, 35, 272, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3000, 1120400000, 0, 1, 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, 2, 0, 0, 0, 0, 0, 90, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 475, 0, 0, 0, 0, '', 83, 0, 0, 0, 13329);

Вот пример

Я взял 20 Пушек Гладиатора и добавил по 200 к статам ) этим не нарушая баланс.
Айди от 900000 до 900020

Шопы для 4.0.6а База (ArkEmu)

AquaGen — Wed, 11 Jul 2012 11:34:38 GMT

Вендоров делал сам для базы (ArkEmu), телепорт взят с соседней темы...
Приступим:

Скачать

Античит

ArhangelSM — Fri, 06 Jul 2012 09:37:42 GMT

Форум: Патчи / Моды / Фиксы для SkyFire
Автор темы: ArhangelSM
Автор последнего сообщения: doomkas
Количество ответов: 1

Fix "Морской Конёк, дикий гриб"

matovkin — Fri, 22 Jun 2012 18:31:01 GMT

Морской конёк При прибывании в воде - аура спадает. Фикс ниже

Code

diff -r b863fb1ab9ef src/server/game/Spells/Spell.cpp
--- a/src/server/game/Spells/Spell.cpp    Sun Dec 04 20:10:25 2011 +0200
+++ b/src/server/game/Spells/Spell.cpp    Sun Dec 04 20:10:54 2011 +0200
@@ -5335,7 +5335,7 @@
                       }
                       case SPELL_AURA_MOUNTED:
                       {
-                if (m_caster->IsInWater())
+                if (m_caster->IsInWater()   && m_spellInfo->Id != 75207)
                     return SPELL_FAILED_ONLY_ABOVEWATER;

                           // Ignore map check if spell have AreaId. AreaId already checked and this prevent special mount spells

Добавлено (05.12.2011, 10:37)
---------------------------------------------
Исправление: Дикий гриб, взрыв диких грибов. Выкладывая этот патч, надеюсь, что кто-нибудь поделится своими наработками.
Патч в ядро.

Sql в базу- скрипт на грибы и Dark Simulacrum

Патч в ядро:

Прошу заметить, что если я увижу свои наработки с вашими копирайтами, я сильно обижусь и больше моей работы вы здесь не увидите.

Добавлено (05.12.2011, 11:19)
---------------------------------------------
Spell.cpp - Подрезать сухожилия

Добавлено (15.12.2011, 18:52)
---------------------------------------------
Сделаю любой фикс, пишите в icq или в лс.

Sexy Custom Teleporter for Cataclysm

Thermaplugg — Tue, 20 Mar 2012 11:33:24 GMT

Это очень хороший телепорт, он был модифицированные мной (Nomad) с более сексуальным NPC и оставлен в оригинальном английском состоянии. Наслаждайтесь!

-- Телепортирует по основному миру
-- Телепортирует по локациям tBC
-- Телепортирует по локациям WotLK
-- Телепортирует по локациям Cataclysm (New!)
-- Телепортирует по инстам и рейдам tBC, WotLK, Cataclysm (New!)
-- Вообще, много куда телепортирует

Code

DELETE FROM creature_template WHERE entry = '95000';

INSERT INTO creature_template (entry, modelid1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, Health_mod, Mana_mod, Armor_mod, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, dmg_multiplier, unit_class, unit_flags, type, type_flags, InhabitType, RegenHealth, flags_extra) VALUES
('95000', '28227', "ViperWow", "Teleportation", 'Directions', '50000', 71, 71, 1.56, 1.56, 1.56, 35, 35, 3, 1, 1.14286, 1.25, 1, 1, 1, 2, 7, 138936390, 3, 1, 2);

DELETE FROM creature_template_addon WHERE Entry = '190000' ;

INSERT INTO creature_template_addon (entry, mount, bytes1, bytes2, emote, path_id, auras) VALUES
('190000', 0, 0, 0, 0, 0, '35766 0');

DELETE FROM gossip_menu WHERE entry>'50000'-1 AND entry<'50000'+9;
DELETE FROM npc_text WHERE ID>'300000'-1 AND ID<'300000'+5;

INSERT INTO gossip_menu (entry, text_id) VALUES
('50000'+4, '300000'+3),
('50000'+3, '300000'+2),
('50000'+2, '300000'+2),
('50000'+1, '300000'+2),
('50000'+8, '300000'+4),
('50000'+7, '300000'+4),
('50000'+6, '300000'+4),
('50000'+5, '300000'+4),
('50000', '300000'+1),
('50000', '300000');

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES
('300000'+4, '$BWhere do you wish to go ?$B', 0),
('300000'+3, '$BBe careful with choosing location,I will not be there to help.$B', 0),
('300000'+2, '$BReady for some dungeon exploring?$B', 0),
('300000'+1, '$BFor the  Alliance!$B', 6),
('300000', '$BFor the Horde!$B', 6);

DELETE FROM gossip_menu_option WHERE menu_id>'50000'-1 AND menu_id<'50000'+9;
DELETE FROM gossip_scripts WHERE id>'50000'-1 AND id<'50000'+135;
DELETE FROM conditions WHERE (SourceTypeOrReferenceId = 15 OR SourceTypeOrReferenceId=14) AND (SourceGroup>'50000'-1 AND SourceGroup<'50000'+9);

INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES
(15, '50000', 1, 6, 469, 'Stormwind'),
(15, '50000'+5, 2, 6, 469, 'Dun Morogh'),
(15, '50000'+5, 3, 6, 67, 'Tirisfal Glades'),
(15, '50000'+5, 4, 6, 67, 'Ghostlands'),
(15, '50000'+5, 5, 6, 469, 'Loch modan'),
(15, '50000'+5, 6, 6, 67, 'Silverpine Forest'),
(15, '50000'+5, 7, 6, 469, 'Westfall'),
(15, '50000'+5, 8, 6, 469, 'Redridge mountains'),
(15, '50000'+5, 9, 6, 469, 'Duskwood'),
(15, '50000'+5, 11, 6, 469, 'Wetlands'),
(15, '50000'+6, 0, 6, 469, 'Azuremyst Isle'),
(15, '50000'+6, 1, 6, 469, 'Teldrassil'),
(15, '50000'+6, 2, 6, 67, 'Durotar'),
(15, '50000'+6, 3, 6, 67, 'Mulgore'),
(15, '50000'+6, 4, 6, 469, 'Bloodmyst Isle'),
(15, '50000'+6, 5, 6, 469, 'Darkshore'),
(15, '50000'+6, 6, 6, 67, 'The Barrens'),
(15, '50000'+5, 1, 6, 67, 'Eversong Woods'),
(15, '50000'+5, 0, 6, 469, 'Elwynn Forest'),
(15, '50000'+4, 22, 6, 67, 'Zul\'Aman'),
(15, '50000', 2, 6, 67, 'Orgrimmar'),
(15, '50000', 3, 6, 469, 'Darnassus'),
(15, '50000', 4, 6, 469, 'Ironforge'),
(15, '50000', 5, 6, 469, 'Exodar'),
(15, '50000', 6, 6, 67, 'Thunder bluff'),
(15, '50000', 7, 6, 67, 'Undercity'),
(15, '50000', 8, 6, 67, 'Silvermoon city'),
(15, '50000'+1, 0, 6, 469, 'Gnomeregan'),
(15, '50000'+1, 1, 6, 469, 'The Deadmines'),
(15, '50000'+1, 2, 6, 469, 'The Stockade'),
(15, '50000'+1, 3, 6, 67, 'Ragefire Chasm'),
(15, '50000'+1, 4, 6, 67, 'Razorfen Downs'),
(15, '50000'+1, 5, 6, 67, 'Razorfen Kraul'),
(15, '50000'+1, 6, 6, 67, 'Scarlet Monastery'),
(15, '50000'+1, 7, 6, 67, 'Shadowfang Keep'),
(15, '50000'+1, 8, 6, 67, 'Wailing Caverns'),
(15, '50000'+6, 9, 6, 67, 'Thousand Needles'),
(14,'50000', '300000'+1, 6, 469, 'Honor and Respect for the Alliance'),
(14, '50000', '300000', 6, 67, 'Honor and Respect for the Horde');

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
('50000', 1, 2, 'Stormwind', 1, 1, '50000', 0, '50000', 0, 0, 'Ready to go in  Stormwind?'),
('50000', 2, 2, 'Orgrimmar', 1, 1, '50000', 0, '50000'+1, 0, 0, 'Ready to go in  Orgrimmar?'),
('50000', 3, 2, 'Darnassus', 1, 1, '50000', 0, '50000'+8, 0, 0, 'Ready to go in  Darnassus?'),
('50000', 4, 2, 'Ironforge', 1, 1, '50000', 0, '50000'+9, 0, 0, 'Ready to go in  Ironforge?'),
('50000', 5, 2, 'Exodar', 1, 1, '50000', 0, '50000'+10, 0, 0, 'Ready to go in  Exodar?'),
('50000', 6, 2, 'Thunder bluff', 1, 1, '50000', 0, '50000'+11, 0, 0, 'Ready to go in  Thunder bluff?'),
('50000', 7, 2, 'Undercity', 1, 1, '50000', 0, '50000'+12, 0, 0, 'Ready to go in  Undercity?'),
('50000', 8, 2, 'Silvermoon city', 1, 1, '50000', 0, '50000'+13, 0, 0, 'Ready to go in  Silvermoon city?'),
('50000', 9, 2, 'Dalaran', 1, 1, '50000', 0, '50000'+5, 0, 0, 'Ready to go in  Dalaran?'),
('50000', 10, 2, 'Shattrath', 1, 1, '50000', 0, '50000'+3, 0, 0, 'Ready to go in  Shattrath?'),
('50000', 11, 2, 'Booty bay', 1, 1, '50000', 0, '50000'+2, 0, 0, 'Ready to go in  Booty bay?'),
('50000', 12, 2, 'Gurubashi arena', 1, 1, '50000', 0, '50000'+6, 0, 0, 'Ready to go in  Arena?'),
('50000', 13, 3, 'Eastern Kingdoms', 1, 1, '50000'+5, 0, 0, 0, 0, NULL),
('50000', 14, 3, 'Kalimdor', 1, 1, '50000'+6, 0, 0, 0, 0, NULL),
('50000', 15, 3, 'Outland', 1, 1, '50000'+7, 0, 0, 0, 0, NULL),
('50000', 16, 3, 'Northrend', 1, 1, '50000'+8, 0, 0, 0, 0, NULL),
('50000', 17, 9, 'Cataclysm Zone', 1, 1, '50000'+1, 0, 0, 0, 0, NULL),
('50000', 18, 9, 'BC Dungeons', 1, 1, '50000'+2, 0, 0, 0, 0, NULL),
('50000', 19, 9, 'Wrath Dungeons', 1, 1, '50000'+3, 0, 0, 0, 0, NULL),
('50000', 20, 9, 'Raid Teleports', 1, 1, '50000'+4, 0, 0, 0, 0, NULL),
('50000'+1, 0, 2, 'Tol Barad', 1, 1, 0, 0, '50000'+14, 0, 0, 'Ready to go in  Tol Barad?'),
('50000'+1, 1, 2, 'The Lost Isles', 1, 1, 0, 0, '50000'+15, 0, 0, 'Ready to go in  The Lost Isles?'),
('50000'+1, 2, 2, 'Grim Batol', 1, 1, 0, 0, '50000'+16, 0, 0, 'Ready to go in  Grim Batol?'),
('50000'+1, 3, 2, 'Tol Barad', 1, 1, 0, 0, '50000'+17, 0, 0, 'Ready to go in  Tol Barad?'),
('50000'+1, 4, 2, 'The Lost Isles', 1, 1, 0, 0, '50000'+18, 0, 0, 'Ready to go in  The Lost Isles?'),
('50000'+1, 5, 2, 'Grim Batol', 1, 1, 0, 0, '50000'+19, 0, 0, 'Ready to go in  Razorfen Grim Batol?'),
('50000'+1, 9, 2, 'The Abyssal Maw', 1, 1, 0, 0, '50000'+23, 0, 0, 'Ready to go in  The Abyssal Maw?'),
('50000'+1, 10, 2, 'Halls of Origination', 1, 1, 0, 0, '50000'+24, 0, 0, 'Ready to go in  Halls of Origination?'),
('50000'+1, 11, 2, 'Ruins of Glineas', 1, 1, 0, 0, '50000'+25, 0, 0, 'Ready to go in  Ruins of Glineas?'),
('50000'+1, 12, 2, 'The Bastion of Twilight', 1, 1, 0, 0, '50000'+26, 0, 0, 'Ready to go in  The Bastion of Twilight?'),
('50000'+1, 13, 2, 'Deepholme', 1, 1, 0, 0, '50000'+27, 0, 0, 'Ready to go in  Deepholme?'),
('50000'+1, 14, 2, 'Blackwing Descent', 1, 1, 0, 0, '50000'+28, 0, 0, 'Ready to go in  Blackwing Descent?'),
('50000'+1, 15, 2, 'The Vortex Pinnacle', 1, 1, 0, 0, '50000'+29, 0, 0, 'Ready to go in  The Vortex Pinnacle?'),
('50000'+1, 16, 2, 'Lost City of the Tolvir', 1, 1, 0, 0, '50000'+30, 0, 0, 'Ready to go in  Lost City of the Tolvir?'),
('50000'+1, 17, 2, 'Mount Hyjal', 1, 1, 0, 0, '50000'+31, 0, 0, 'Ready to go in  Mount Hyjal?'),
('50000'+1, 18, 2, 'The Maelstrom', 1, 1, 0, 0, '50000'+32, 0, 0, 'Ready to go in  The Maelstrom?'),
('50000'+1, 19, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+2, 0, 2, 'Auchindoun', 1, 1, 0, 0, '50000'+33, 0, 0, 'Ready to go in  Auchindoun?'),
('50000'+2, 1, 2, 'Caverns of Time', 1, 1, 0, 0, '50000'+34, 0, 0, 'Ready to go in  Caverns of Time?'),
('50000'+2, 2, 2, 'Coilfang Reservoir', 1, 1, 0, 0, '50000'+35, 0, 0, 'Ready to go in  Coilfang Reservoir?'),
('50000'+2, 3, 2, 'Hellfire Citadel', 1, 1, 0, 0, '50000'+36, 0, 0, 'Ready to go in  Hellfire Citadel?'),
('50000'+2, 4, 2, 'Magisters\' Terrace', 1, 1, 0, 0, '50000'+37, 0, 0, 'Ready to go in  Magisters\' Terrace?'),
('50000'+2, 5, 2, 'Tempest Keep', 1, 1, 0, 0, '50000'+38, 0, 0, 'Ready to go in  Tempest Keep?'),
('50000'+2, 6, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+3, 0, 2, 'Azjol-Nerub', 1, 1, 0, 0, '50000'+39, 0, 0, 'Ready to go in  Azjol-Nerub?'),
('50000'+3, 1, 2, 'The Culling of Stratholme', 1, 1, 0, 0, '50000'+40, 0, 0, 'Ready to go in  The Culling of Stratholme?'),
('50000'+3, 2, 2, 'Trial of the Champion', 1, 1, 0, 0, '50000'+41, 0, 0, 'Ready to go in  Trial of the Champion?'),
('50000'+3, 3, 2, 'Drak\'Tharon Keep', 1, 1, 0, 0, '50000'+42, 0, 0, 'Ready to go in  Drak\'Tharon Keep?'),
('50000'+3, 4, 2, 'Gundrak', 1, 1, 0, 0, '50000'+43, 0, 0, 'Ready to go in  Gundrak?'),
('50000'+3, 5, 2, 'Icecrown Citadel Dungeons', 1, 1, 0, 0, '50000'+44, 0, 0, 'Ready to go in  Icecrown Citadel Dungeons?'),
('50000'+3, 6, 2, 'The Nexus Dungeons', 1, 1, 0, 0, '50000'+45, 0, 0, 'Ready to go in  The Nexus Dungeons?'),
('50000'+3, 7, 2, 'The Violet Hold', 1, 1, 0, 0, '50000'+46, 0, 0, 'Ready to go in  The Violet Hold?'),
('50000'+3, 8, 2, 'Halls of Lightning', 1, 1, 0, 0, '50000'+47, 0, 0, 'Ready to go in  Halls of Lightning?'),
('50000'+3, 9, 2, 'Halls of Stone', 1, 1, 0, 0, '50000'+48, 0, 0, 'Ready to go in  Halls of Stone?'),
('50000'+3, 10, 2, 'Utgarde Keep', 1, 1, 0, 0, '50000'+49, 0, 0, 'Ready to go in  Utgarde Keep?'),
('50000'+3, 11, 2, 'Utgarde Pinnacle', 1, 1, 0, 0, '50000'+50, 0, 0, 'Ready to go in  Utgarde Pinnacle?'),
('50000'+3, 12, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+4, 0, 2, 'Black Temple', 1, 1, 0, 0, '50000'+51, 0, 0, 'Ready to go in  Black Temple?'),
('50000'+4, 1, 2, 'Blackwing Lair', 1, 1, 0, 0, '50000'+52, 0, 0, 'Ready to go in  Blackwing Lair?'),
('50000'+4, 2, 2, 'Hyjal Summit', 1, 1, 0, 0, '50000'+53, 0, 0, 'Ready to go in  Hyjal Summit?'),
('50000'+4, 3, 2, 'Serpentshrine Cavern', 1, 1, 0, 0, '50000'+54, 0, 0, 'Ready to go in  Serpentshrine Cavern?'),
('50000'+4, 4, 2, 'Trial of the Crusader', 1, 1, 0, 0, '50000'+55, 0, 0, 'Ready to go in  Trial of the Crusader?'),
('50000'+4, 5, 2, 'Gruul\'s Lair', 1, 1, 0, 0, '50000'+56, 0, 0, 'Ready to go in  Gruul\'s Lair?'),
('50000'+4, 6, 2, 'Magtheridon\'s Lair', 1, 1, 0, 0, '50000'+57, 0, 0, 'Ready to go in  Magtheridon\'s Lair?'),
('50000'+4, 7, 2, 'Icecrown Citadel', 1, 1, 0, 0, '50000'+58, 0, 0, 'Ready to go in  Icecrown Citadel?'),
('50000'+4, 8, 2, 'Karazhan', 1, 1, 0, 0, '50000'+59, 0, 0, 'Ready to go in  Karazhan?'),
('50000'+4, 9, 2, 'Molten Core', 1, 1, 0, 0, '50000'+60, 0, 0, 'Ready to go in  Molten Core?'),
('50000'+4, 10, 2, 'Naxxramas', 1, 1, 0, 0, '50000'+61, 0, 0, 'Ready to go in  Naxxramas?'),
('50000'+4, 11, 2, 'Onyxia\'s Lair', 1, 1, 0, 0, '50000'+62, 0, 0, 'Ready to go in  Onyxia\'s Lair?'),
('50000'+4, 12, 2, 'Ruins of Ahn\'Qiraj', 1, 1, 0, 0, '50000'+63, 0, 0, 'Ready to go in  Ruins of Ahn\'Qiraj?'),
('50000'+4, 13, 2, 'Sunwell Plateau', 1, 1, 0, 0, '50000'+64, 0, 0, 'Ready to go in  Sunwell Plateau?'),
('50000'+4, 14, 2, 'The Eye', 1, 1, 0, 0, '50000'+65, 0, 0, 'Ready to go in  The Eye?'),
('50000'+4, 15, 2, 'Temple of Ahn\'Qiraj', 1, 1, 0, 0, '50000'+66, 0, 0, 'Ready to go in  Temple of Ahn\'Qiraj?'),
('50000'+4, 16, 2, 'The Eye of Eternity', 1, 1, 0, 0, '50000'+67, 0, 0, 'Ready to go in  The Eye of Eternity?'),
('50000'+4, 17, 2, 'The Obsidian Sanctum', 1, 1, 0, 0, '50000'+68, 0, 0, 'Ready to go in  The Obsidian Sanctum?'),
('50000'+4, 18, 2, 'Ulduar', 1, 1, 0, 0, '50000'+69, 0, 0, 'Ready to go in  Ulduar?'),
('50000'+4, 19, 2, 'Vault of Archavon', 1, 1, 0, 0, '50000'+70, 0, 0, 'Ready to go in  Vault of Archavon?'),
('50000'+4, 21, 2, 'Zul\'Gurub', 1, 1, 0, 0, '50000'+72, 0, 0, 'Ready to go in  Zul\'Gurub?'),
('50000'+4, 22, 2, 'Zul\'Aman', 1, 1, 0, 0, '50000'+73, 0, 0, 'Ready to go in  Zul\'Aman?'),
('50000'+4, 23, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+5, 0, 2, 'Elwynn Forest', 1, 1, 0, 0, '50000'+74, 0, 0, 'Ready to go in  Elwynn Forest?'),
('50000'+5, 1, 2, 'Eversong Woods', 1, 1, 0, 0, '50000'+75, 0, 0, 'Ready to go in  Eversong Woods?'),
('50000'+5, 2, 2, 'Dun Morogh', 1, 1, 0, 0, '50000'+76, 0, 0, 'Ready to go in  Dun Morogh?'),
('50000'+5, 3, 2, 'Tirisfal Glades', 1, 1, 0, 0, '50000'+77, 0, 0, 'Ready to go in  Tirisfal Glades?'),
('50000'+5, 4, 2, 'Ghostlands', 1, 1, 0, 0, '50000'+78, 0, 0, 'Ready to go in  Ghostlands?'),
('50000'+5, 5, 2, 'Loch modan', 1, 1, 0, 0, '50000'+79, 0, 0, 'Ready to go in  Loch modan?'),
('50000'+5, 6, 2, 'Silverpine Forest', 1, 1, 0, 0, '50000'+80, 0, 0, 'Ready to go in  Silverpine Forest?'),
('50000'+5, 7, 2, 'Westfall', 1, 1, 0, 0, '50000'+81, 0, 0, 'Ready to go in  Westfall?'),
('50000'+5, 8, 2, 'Redridge mountains', 1, 1, 0, 0, '50000'+82, 0, 0, 'Ready to go in  Redridge mountains?'),
('50000'+5, 9, 2, 'Duskwood', 1, 1, 0, 0, '50000'+83, 0, 0, 'Ready to go in  Duskwood?'),
('50000'+5, 10, 2, 'Hillsbrad Foothills', 1, 1, 0, 0, '50000'+84, 0, 0, 'Ready to go in  Hillsbrad Foothills?'),
('50000'+5, 11, 2, 'Wetlands', 1, 1, 0, 0, '50000'+85, 0, 0, 'Ready to go in  Wetlands?'),
('50000'+5, 12, 2, 'Alterac Mountains', 1, 1, 0, 0, '50000'+86, 0, 0, 'Ready to go in  Alterac Mountains?'),
('50000'+5, 13, 2, 'Arathi Highlands', 1, 1, 0, 0, '50000'+87, 0, 0, 'Ready to go in  Arathi Highlands?'),
('50000'+5, 14, 2, 'Stranglethorn Vale', 1, 1, 0, 0, '50000'+88, 0, 0, 'Ready to go in  Stranglethorn Vale?'),
('50000'+5, 15, 2, 'Badlands', 1, 1, 0, 0, '50000'+89, 0, 0, 'Ready to go in  Badlands?'),
('50000'+5, 16, 2, 'Swamp of Sorrows', 1, 1, 0, 0, '50000'+90, 0, 0, 'Ready to go in  Swamp of Sorrows?'),
('50000'+5, 17, 2, 'The Hinterlands', 1, 1, 0, 0, '50000'+91, 0, 0, 'Ready to go in  The Hinterlands?'),
('50000'+5, 18, 2, 'Searing Gorge', 1, 1, 0, 0, '50000'+92, 0, 0, 'Ready to go in  Searing Gorge?'),
('50000'+5, 19, 2, 'The Blasted Lands', 1, 1, 0, 0, '50000'+93, 0, 0, 'Ready to go in  The Blasted Lands?'),
('50000'+5, 20, 2, 'Burning Steppes', 1, 1, 0, 0, '50000'+94, 0, 0, 'Ready to go in  Burning Steppes?'),
('50000'+5, 21, 2, 'Western Plaguelands', 1, 1, 0, 0, '50000'+95, 0, 0, 'Ready to go in  Western Plaguelands?'),
('50000'+5, 22, 2, 'Eastern Plaguelands', 1, 1, 0, 0, '50000'+96, 0, 0, 'Ready to go in  Eastern Plaguelands?'),
('50000'+5, 23, 2, 'Isle of Quel\'Danas', 1, 1, 0, 0, '50000'+97, 0, 0, 'Ready to go in  Isle of Quel\'Danas?'),
('50000'+5, 24, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+6, 0, 2, 'Azuremyst Isle', 1, 1, 0, 0, '50000'+98, 0, 0, 'Ready to go in  Azuremyst Isle?'),
('50000'+6, 1, 2, 'Teldrassil', 1, 1, 0, 0, '50000'+99, 0, 0, 'Ready to go in  Teldrassil?'),
('50000'+6, 2, 2, 'Durotar', 1, 1, 0, 0, '50000'+100, 0, 0, 'Ready to go in  Durotar?'),
('50000'+6, 3, 2, 'Mulgore', 1, 1, 0, 0, '50000'+101, 0, 0, 'Ready to go in  Mulgore?'),
('50000'+6, 4, 2, 'Bloodmyst Isle', 1, 1, 0, 0, '50000'+102, 0, 0, 'Ready to go in  Bloodmyst Isle?'),
('50000'+6, 5, 2, 'Darkshore', 1, 1, 0, 0, '50000'+103, 0, 0, 'Ready to go in  Darkshore?'),
('50000'+6, 6, 2, 'The Barrens', 1, 1, 0, 0, '50000'+104, 0, 0, 'Ready to go in  The Barrens?'),
('50000'+6, 7, 2, 'Stonetalon Mountains', 1, 1, 0, 0, '50000'+105, 0, 0, 'Ready to go in  Stonetalon Mountains?'),
('50000'+6, 8, 2, 'Ashenvale Forest', 1, 1, 0, 0, '50000'+106, 0, 0, 'Ready to go in  Ashenvale Forest?'),
('50000'+6, 9, 2, 'Thousand Needles', 1, 1, 0, 0, '50000'+107, 0, 0, 'Ready to go in  Thousand Needles?'),
('50000'+6, 10, 2, 'Desolace', 1, 1, 0, 0, '50000'+108, 0, 0, 'Ready to go in  Desolace?'),
('50000'+6, 11, 2, 'Dustwallow Marsh', 1, 1, 0, 0, '50000'+109, 0, 0, 'Ready to go in  Dustwallow Marsh?'),
('50000'+6, 12, 2, 'Feralas', 1, 1, 0, 0, '50000'+110, 0, 0, 'Ready to go in  Feralas?'),
('50000'+6, 13, 2, 'Tanaris Desert', 1, 1, 0, 0, '50000'+111, 0, 0, 'Ready to go in  Tanaris Desert?'),
('50000'+6, 14, 2, 'Azshara', 1, 1, 0, 0, '50000'+112, 0, 0, 'Ready to go in  Azshara?'),
('50000'+6, 15, 2, 'Felwood', 1, 1, 0, 0, '50000'+113, 0, 0, 'Ready to go in  Felwood?'),
('50000'+6, 16, 2, 'Un\'Goro Crater', 1, 1, 0, 0, '50000'+114, 0, 0, 'Ready to go in  Un\'Goro Crater?'),
('50000'+6, 17, 2, 'Silithus', 1, 1, 0, 0, '50000'+115, 0, 0, 'Ready to go in  Silithus?'),
('50000'+6, 18, 2, 'Winterspring', 1, 1, 0, 0, '50000'+116, 0, 0, 'Ready to go in  Winterspring?'),
('50000'+6, 19, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+7, 0, 2, 'Hellfire Peninsula', 1, 1, 0, 0, '50000'+117, 0, 0, 'Ready to go in  Hellfire Peninsula?'),
('50000'+7, 1, 2, 'Zangarmarsh', 1, 1, 0, 0, '50000'+118, 0, 0, 'Ready to go in  Zangarmarsh?'),
('50000'+7, 2, 2, 'Terokkar Forest', 1, 1, 0, 0, '50000'+119, 0, 0, 'Ready to go in  Terokkar Forest?'),
('50000'+7, 3, 2, 'Nagrand', 1, 1, 0, 0, '50000'+120, 0, 0, 'Ready to go in  Nagrand?'),
('50000'+7, 4, 2, 'Blade\'s Edge Mountains', 1, 1, 0, 0, '50000'+121, 0, 0, 'Ready to go in  Blade\'s Edge Mountains?'),
('50000'+7, 5, 2, 'Netherstorm', 1, 1, 0, 0, '50000'+122, 0, 0, 'Ready to go in  Netherstorm?'),
('50000'+7, 6, 2, 'Shadowmoon Valley', 1, 1, 0, 0, '50000'+123, 0, 0, 'Ready to go in  Shadowmoon Valley?'),
('50000'+7, 7, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+8, 0, 2, 'Borean Tundra', 1, 1, 0, 0, '50000'+124, 0, 0, 'Ready to go in  Borean Tundra?'),
('50000'+8, 1, 2, 'Howling Fjord', 1, 1, 0, 0, '50000'+125, 0, 0, 'Ready to go in  Howling Fjord?'),
('50000'+8, 2, 2, 'Dragonblight', 1, 1, 0, 0, '50000'+126, 0, 0, 'Ready to go in  Dragonblight?'),
('50000'+8, 3, 2, 'Grizzly Hills', 1, 1, 0, 0, '50000'+127, 0, 0, 'Ready to go in  Grizzly Hills?'),
('50000'+8, 4, 2, 'Zul\'Drak', 1, 1, 0, 0, '50000'+128, 0, 0, 'Ready to go in  Zul\'Drak?'),
('50000'+8, 5, 2, 'Sholazar Basin', 1, 1, 0, 0, '50000'+129, 0, 0, 'Ready to go in  Sholazar Basin?'),
('50000'+8, 6, 2, 'Crystalsong Forest', 1, 1, 0, 0, '50000'+130, 0, 0, 'Ready to go in  Crystalsong Forest?'),
('50000'+8, 7, 2, 'Storm Peaks', 1, 1, 0, 0, '50000'+132, 0, 0, 'Ready to go in  Storm Peaks?'),
('50000'+8, 8, 2, 'Icecrown', 1, 1, 0, 0, '50000'+133, 0, 0, 'Ready to go in  Icecrown?'),
('50000'+8, 9, 2, 'Wintergrasp', 1, 1, 0, 0, '50000'+134, 0, 0, 'Ready to go in  Wintergrasp?'),
('50000'+8, 10, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL);

INSERT INTO gossip_scripts (id, delay, command, datalong, datalong2, dataint, x, y, z, o) VALUES
('50000', 0, 6, 0, 0, 0, -8842.09, 626.358, 94.0867, 3.61363),
('50000'+1, 0, 6, 1, 0, 0, 1546.449951, -4404.390137, 18.208300, 1.670500),
('50000'+2, 0, 6, 0, 0, 0, -14281.9, 552.564, 8.90422, 0.860144),
('50000'+3, 0, 6, 530, 0, 0, -1887.62, 5359.09, -12.4279, 4.40435),
('50000'+5, 0, 6, 571, 0, 0, 5809.55, 503.975, 657.526, 2.38338),
('50000'+6, 0, 6, 0, 0, 0, -13181.8, 339.356, 42.9805, 1.18013),
('50000'+8, 0, 6, 1, 0, 0, 9869.91, 2493.58, 1315.88, 2.78897),
('50000'+9, 0, 6, 0, 0, 0, -4900.47, -962.585, 501.455, 5.40538),
('50000'+10, 0, 6, 530, 0, 0, -3864.92, -11643.7, -137.644, 5.50862),
('50000'+11, 0, 6, 1, 0, 0, -1274.45, 71.8601, 128.159, 2.80623),
('50000'+12, 0, 6, 0, 0, 0, 1633.75, 240.167, -43.1034, 6.26128),
('50000'+13, 0, 6, 530, 0, 0, 9738.28, -7454.19, 13.5605, 0.043914),
('50000'+14, 0, 6, 732, 0, 0, -707, 1183, 106, 2),
('50000'+15, 0, 6, 648, 0, 0, 1783, 2278, 192, 5),
('50000'+16, 0, 6, 0, 0, 0, -4060, -3451, 281, 0),
('50000'+17, 0, 6, 732, 0, 0, -707, 1183, 106, 2),
('50000'+18, 0, 6, 648, 0, 0, 1783, 2278, 192, 5),
('50000'+19, 0, 6, 0, 0, 0, -4060, -3451, 281, 0),
('50000'+23, 0, 6, 0, 0, 0, -5596, 5410, -1796, 5),
('50000'+24, 0, 6, 1, 0, 0, -10209, -1839, 20, 3),
('50000'+25, 0, 6, 0, 0, 0, -1936, 1900, 90, 0),
('50000'+26, 0, 6, 0, 0, 0, -4891, -4235, 829, 2),
('50000'+27, 0, 6, 646, 0, 0, 1024, 646, 157, 4),
('50000'+28, 0, 6, 0, 0, 0, -7539, -1196, 477, 2),
('50000'+29, 0, 6, 1, 0, 0, -11511, -2308, 608, 3),
('50000'+30, 0, 6, 1, 0, 0, -10672, -1305, 16, 3),
('50000'+31, 0, 6, 1, 0, 0, 4664, -3685, 957, 3),
('50000'+32, 0, 6, 730, 0, 0, 848, 1052, -6, 5),
('50000'+33, 0, 6, 530, 0, 0, -3324.49, 4943.45, -101.239, 4.63901),
('50000'+34, 0, 6, 1, 0, 0, -8369.65, -4253.11, -204.272, -2.70526),
('50000'+35, 0, 6, 530, 0, 0, 738.865, 6865.77, -69.4659, 6.27655),
('50000'+36, 0, 6, 530, 0, 0, -347.29, 3089.82, 21.394, 5.68114),
('50000'+37, 0, 6, 530, 0, 0, 12884.6, -7317.69, 65.5023, 4.799),
('50000'+38, 0, 6, 530, 0, 0, 3100.48, 1536.49, 190.3, 4.62226),
('50000'+39, 0, 6, 571, 0, 0, 3707.86, 2150.23, 36.76, 3.22),
('50000'+40, 0, 6, 1, 0, 0, -8756.39, -4440.68, -199.489, 4.66289),
('50000'+41, 0, 6, 571, 0, 0, 8590.95, 791.792, 558.235, 3.13127),
('50000'+42, 0, 6, 571, 0, 0, 4765.59, -2038.24, 229.363, 0.887627),
('50000'+43, 0, 6, 571, 0, 0, 6722.44, -4640.67, 450.632, 3.91123),
('50000'+44, 0, 6, 571, 0, 0, 5643.16, 2028.81, 798.274, 4.60242),
('50000'+45, 0, 6, 571, 0, 0, 3782.89, 6965.23, 105.088, 6.14194),
('50000'+46, 0, 6, 571, 0, 0, 5693.08, 502.588, 652.672, 4.0229),
('50000'+47, 0, 6, 571, 0, 0, 9136.52, -1311.81, 1066.29, 5.19113),
('50000'+48, 0, 6, 571, 0, 0, 8922.12, -1009.16, 1039.56, 1.57044),
('50000'+49, 0, 6, 571, 0, 0, 1203.41, -4868.59, 41.2486, 0.283237),
('50000'+50, 0, 6, 571, 0, 0, 1267.24, -4857.3, 215.764, 3.22768),
('50000'+51, 0, 6, 530, 0, 0, -3649.92, 317.469, 35.2827, 2.94285),
('50000'+52, 0, 6, 229, 0, 0, 152.451, -474.881, 116.84, 0.001073),
('50000'+53, 0, 6, 1, 0, 0, -8177.89, -4181.23, -167.552, 0.913338),
('50000'+54, 0, 6, 530, 0, 0, 797.855, 6865.77, -65.4165, 0.005938),
('50000'+55, 0, 6, 571, 0, 0, 8515.61, 714.153, 558.248, 1.57753),
('50000'+56, 0, 6, 530, 0, 0, 3530.06, 5104.08, 3.50861, 5.51117),
('50000'+57, 0, 6, 530, 0, 0, -336.411, 3130.46, -102.928, 5.20322),
('50000'+58, 0, 6, 571, 0, 0, 5855.22, 2102.03, 635.991, 3.57899),
('50000'+59, 0, 6, 0, 0, 0, -11118.9, -2010.33, 47.0819, 0.649895),
('50000'+60, 0, 6, 230, 0, 0, 1126.64, -459.94, -102.535, 3.46095),
('50000'+61, 0, 6, 571, 0, 0, 3668.72, -1262.46, 243.622, 4.785),
('50000'+62, 0, 6, 1, 0, 0, -4708.27, -3727.64, 54.5589, 3.72786),
('50000'+63, 0, 6, 1, 0, 0, -8409.82, 1499.06, 27.7179, 2.51868),
('50000'+64, 0, 6, 530, 0, 0, 12574.1, -6774.81, 15.0904, 3.13788),
('50000'+65, 0, 6, 530, 0, 0, 3088.49, 1381.57, 184.863, 4.61973),
('50000'+66, 0, 6, 1, 0, 0, -8240.09, 1991.32, 129.072, 0.941603),
('50000'+67, 0, 6, 571, 0, 0, 3784.17, 7028.84, 161.258, 5.79993),
('50000'+68, 0, 6, 571, 0, 0, 3472.43, 264.923, -120.146, 3.27923),
('50000'+69, 0, 6, 571, 0, 0, 9222.88, -1113.59, 1216.12, 6.27549),
('50000'+70, 0, 6, 571, 0, 0, 5453.72, 2840.79, 421.28, 0),
('50000'+72, 0, 6, 0, 0, 0, -11916.7, -1215.72, 92.289, 4.72454),
('50000'+73, 0, 6, 530, 0, 0, 6851.78, -7972.57, 179.242, 4.64691),
('50000'+74, 0, 6, 0, 0, 0, -9449.06, 64.8392, 56.3581, 3.07047),
('50000'+75, 0, 6, 530, 0, 0, 9024.37, -6682.55, 16.8973, 3.14131),
('50000'+76, 0, 6, 0, 0, 0, -5603.76, -482.704, 396.98, 5.23499),
('50000'+77, 0, 6, 0, 0, 0, 2274.95, 323.918, 34.1137, 4.24367),
('50000'+78, 0, 6, 530, 0, 0, 7595.73, -6819.6, 84.3718, 2.56561),
('50000'+79, 0, 6, 0, 0, 0, -5405.85, -2894.15, 341.972, 5.48238),
('50000'+80, 0, 6, 0, 0, 0, 505.126, 1504.63, 124.808, 1.77987),
('50000'+81, 0, 6, 0, 0, 0, -10684.9, 1033.63, 32.5389, 6.07384),
('50000'+82, 0, 6, 0, 0, 0, -9447.8, -2270.85, 71.8224, 0.283853),
('50000'+83, 0, 6, 0, 0, 0, -10531.7, -1281.91, 38.8647, 1.56959),
('50000'+84, 0, 6, 0, 0, 0, -385.805, -787.954, 54.6655, 1.03926),
('50000'+85, 0, 6, 0, 0, 0, -3517.75, -913.401, 8.86625, 2.60705),
('50000'+86, 0, 6, 0, 0, 0, 275.049, -652.044, 130.296, 0.502032),
('50000'+87, 0, 6, 0, 0, 0, -1581.45, -2704.06, 35.4168, 0.490373),
('50000'+88, 0, 6, 0, 0, 0, -11921.7, -59.544, 39.7262, 3.73574),
('50000'+89, 0, 6, 0, 0, 0, -6782.56, -3128.14, 240.48, 5.65912),
('50000'+90, 0, 6, 0, 0, 0, -10368.6, -2731.3, 21.6537, 5.29238),
('50000'+91, 0, 6, 0, 0, 0, 112.406, -3929.74, 136.358, 0.981903),
('50000'+92, 0, 6, 0, 0, 0, -6686.33, -1198.55, 240.027, 0.916887),
('50000'+93, 0, 6, 0, 0, 0, -11184.7, -3019.31, 7.29238, 3.20542),
('50000'+94, 0, 6, 0, 0, 0, -7979.78, -2105.72, 127.919, 5.10148),
('50000'+95, 0, 6, 0, 0, 0, 1743.69, -1723.86, 59.6648, 5.23722),
('50000'+96, 0, 6, 0, 0, 0, 2280.64, -5275.05, 82.0166, 4.7479),
('50000'+97, 0, 6, 530, 0, 0, 12806.5, -6911.11, 41.1156, 2.22935),
('50000'+98, 0, 6, 530, 0, 0, -4192.62, -12576.7, 36.7598, 1.62813),
('50000'+99, 0, 6, 1, 0, 0, 9889.03, 915.869, 1307.43, 1.9336),
('50000'+100, 0, 6, 1, 0, 0, 228.978, -4741.87, 10.1027, 0.416883),
('50000'+101, 0, 6, 1, 0, 0, -2473.87, -501.225, -9.42465, 0.6525),
('50000'+102, 0, 6, 530, 0, 0, -2095.7, -11841.1, 51.1557, 6.19288),
('50000'+103, 0, 6, 1, 0, 0, 6463.25, 683.986, 8.92792, 4.33534),
('50000'+104, 0, 6, 1, 0, 0, -575.772, -2652.45, 95.6384, 0.006469),
('50000'+105, 0, 6, 1, 0, 0, 1574.89, 1031.57, 137.442, 3.8013),
('50000'+106, 0, 6, 1, 0, 0, 1919.77, -2169.68, 94.6729, 6.14177),
('50000'+107, 0, 6, 1, 0, 0, -5375.53, -2509.2, -40.432, 2.41885),
('50000'+108, 0, 6, 1, 0, 0, -656.056, 1510.12, 88.3746, 3.29553),
('50000'+109, 0, 6, 1, 0, 0, -3350.12, -3064.85, 33.0364, 5.12666),
('50000'+110, 0, 6, 1, 0, 0, -4808.31, 1040.51, 103.769, 2.90655),
('50000'+111, 0, 6, 1, 0, 0, -6940.91, -3725.7, 48.9381, 3.11174),
('50000'+112, 0, 6, 1, 0, 0, 3117.12, -4387.97, 91.9059, 5.49897),
('50000'+113, 0, 6, 1, 0, 0, 3898.8, -1283.33, 220.519, 6.24307),
('50000'+114, 0, 6, 1, 0, 0, -6291.55, -1158.62, -258.138, 0.457099),
('50000'+115, 0, 6, 1, 0, 0, -6815.25, 730.015, 40.9483, 2.39066),
('50000'+116, 0, 6, 1, 0, 0, 6658.57, -4553.48, 718.019, 5.18088),
('50000'+117, 0, 6, 530, 0, 0, -207.335, 2035.92, 96.464, 1.59676),
('50000'+118, 0, 6, 530, 0, 0, -220.297, 5378.58, 23.3223, 1.61718),
('50000'+119, 0, 6, 530, 0, 0, -2266.23, 4244.73, 1.47728, 3.68426),
('50000'+120, 0, 6, 530, 0, 0, -1610.85, 7733.62, -17.2773, 1.33522),
('50000'+121, 0, 6, 530, 0, 0, 2029.75, 6232.07, 133.495, 1.30395),
('50000'+122, 0, 6, 530, 0, 0, 3271.2, 3811.61, 143.153, 3.44101),
('50000'+123, 0, 6, 530, 0, 0, -3681.01, 2350.76, 76.587, 4.25995),
('50000'+124, 0, 6, 571, 0, 0, 2954.24, 5379.13, 60.4538, 2.55544),
('50000'+125, 0, 6, 571, 0, 0, 682.848, -3978.3, 230.161, 1.54207),
('50000'+126, 0, 6, 571, 0, 0, 2678.17, 891.826, 4.37494, 0.101121),
('50000'+127, 0, 6, 571, 0, 0, 4017.35, -3403.85, 290, 5.35431),
('50000'+128, 0, 6, 571, 0, 0, 5560.23, -3211.66, 371.709, 5.55055),
('50000'+129, 0, 6, 571, 0, 0, 5614.67, 5818.86, -69.722, 3.60807),
('50000'+130, 0, 6, 571, 0, 0, 5411.17, -966.37, 167.082, 1.57167),
('50000'+132, 0, 6, 571, 0, 0, 6120.46, -1013.89, 408.39, 5.12322),
('50000'+133, 0, 6, 571, 0, 0, 8323.28, 2763.5, 655.093, 2.87223),
('50000'+134, 0, 6, 571, 0, 0, 4522.23, 2828.01, 389.975, 0.215009);

Fix Погоня за справедливостью.

StrongBitch — Sat, 07 Jan 2012 09:14:29 GMT

sql/updates/world/11_11_22_world_spell_proc_event.sql

Что касаемо остального:На данный момент проблемы с машиной и я выложу вам сами репозиты:
Репо

Патчи под SkyFire

EpIlEpT — Mon, 12 Dec 2011 12:49:32 GMT

Доброй Ночи уважаемые пользователи портала WoWJP
Сами Патчи :
AC2-TeleNPC2-Jail-XP.patch
All.patch
City-Conquest.patch
Fatigue.patch
AHBot-VIP-Playerbots.patch
PlayerBots.patch
Скачать
Если было Удалите
Кому нужна помощь Мне в асю или Пм

Правила

_dm666 — Wed, 30 Nov 2011 20:13:27 GMT

Выкладывайте свои наработки, фиксы, патчи.

Просьба указывать копирайты(если работа не ваша), а также, по возможности, указать ссылку на источник.

Запрещено

Просить фиксы и т.д. Для этого есть раздел хелпа

Апать старые темы, флудить, торговать.