[ Новые сообщения · Участники · Правила форума · Поиск · RSS ]
Страница 1 из 11
Форум » TrinityCore » Разное для TrinityCore » КАК добавитьл эвент (КАК добавитьл эвент)
КАК добавитьл эвент
pomashДата: Воскресенье, 17.07.2011, 04:27 | Сообщение # 1
Нет аватара
Скаут
Группа: Пользователи
Сообщений: 5
Статус: oаff
ктонить можэт обеснить как залить этот эвент
в каких папках в бд размещять

1) Создаем Самолет специально для ивента:
НПС 1.1 МиГ-29 (Entry=700000):

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`) VALUES (700000, 0, 0, 0, 0, 0, 23365, 0, 0, 0, 'МиГ-29', 'Небесный защитник', 'Interact', 0, 83, 83, 2, 35, 35, 33554432, 3, 3, 1, 0, 260, 390, 0, 97, 1, 2000, 2000, 1, 0, 8, 0, 0, 0, 0, 0, 208, 312, 78, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62359, 62346, 51362, 54170, 0, 0, 0, 0, 0, 156, 0, 0, '', 0, 4, 10, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');

2)Ставим самолеты в мир:
НПС 1.1 МиГ-29 (Здесь его GUID=38495..):

INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(3849561, 700000, 0, 1, 1, 0, 0, -10152.4, 1455.07, 39.6742, 3.78558, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849560, 700000, 0, 1, 1, 0, 0, -10213, 1514.94, 39.3384, 3.90731, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849559, 700000, 0, 1, 1, 0, 0, -10224.3, 1525.9, 39.5507, 3.98978, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849558, 700000, 0, 1, 1, 0, 0, -10234.8, 1535.86, 39.5416, 3.9191, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849589, 700000, 0, 1, 1, 0, 0, -10254.6, 1518.35, 39.3984, 3.98431, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849588, 700000, 0, 1, 1, 0, 0, -10245.8, 1510.17, 40.138, 4.00002, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849587, 700000, 0, 1, 1, 0, 0, -10237.2, 1502.15, 40.7875, 3.93483, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849586, 700000, 0, 1, 1, 0, 0, -10228.5, 1493.15, 41.4617, 3.95447, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849585, 700000, 0, 1, 1, 0, 0, -10218.7, 1483.4, 41.364, 3.97803, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849584, 700000, 0, 1, 1, 0, 0, -10208.6, 1473.65, 41.0291, 4.03301, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849583, 700000, 0, 1, 1, 0, 0, -10199.6, 1464.37, 40.7189, 3.89163, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849582, 700000, 0, 1, 1, 0, 0, -10190.3, 1454.43, 40.5316, 3.97017, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849581, 700000, 0, 1, 1, 0, 0, -10180.4, 1444.87, 40.6154, 3.92305, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849580, 700000, 0, 1, 1, 0, 0, -10171.3, 1435.53, 40.4151, 4.03693, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849579, 700000, 0, 1, 1, 0, 0, -10162.3, 1427.43, 39.7815, 3.9309, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849578, 700000, 0, 1, 1, 0, 0, -10156.8, 1442.3, 40.2838, 3.94661, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849577, 700000, 0, 1, 1, 0, 0, -10165.1, 1450.47, 40.8159, 3.88771, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849576, 700000, 0, 1, 1, 0, 0, -10174.8, 1460.03, 40.5789, 3.89556, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849575, 700000, 0, 1, 1, 0, 0, -10183.7, 1469.16, 40.4875, 3.89556, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849574, 700000, 0, 1, 1, 0, 0, -10192.2, 1477.7, 40.6543, 3.89163, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849573, 700000, 0, 1, 1, 0, 0, -10199.1, 1484.75, 40.5302, 3.89949, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849572, 700000, 0, 1, 1, 0, 0, -10207.1, 1492.66, 40.3095, 3.87593, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849571, 700000, 0, 1, 1, 0, 0, -10216.5, 1501.92, 40.5769, 3.95054, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849570, 700000, 0, 1, 1, 0, 0, -10226.3, 1512.05, 40.0229, 3.92305, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849569, 700000, 0, 1, 1, 0, 0, -10236.8, 1521.77, 39.8011, 3.93874, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849568, 700000, 0, 1, 1, 0, 0, -10144.2, 1445.22, 39.199, 3.83664, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849567, 700000, 0, 1, 1, 0, 0, -10163.6, 1463.94, 40.2155, 3.93088, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849566, 700000, 0, 1, 1, 0, 0, -10172.2, 1472.4, 39.5972, 3.93481, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849565, 700000, 0, 1, 1, 0, 0, -10180.4, 1481.26, 39.4981, 3.84449, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849564, 700000, 0, 1, 1, 0, 0, -10187.8, 1489.82, 39.2666, 3.88768, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849563, 700000, 0, 1, 1, 0, 0, -10195.8, 1496.83, 39.2892, 3.93873, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0),
(3849562, 700000, 0, 1, 1, 0, 0, -10204, 1505.05, 39.353, 3.94659, 300, 0, 0, 139450, 0, 0, 0, 0, 0, 0);

3)Добавляем Ивент Небесный защитник, Entry ивента 2011:

INSERT INTO game_event
(`entry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `world_event`)
VALUES
(2011, '2010-10-8 19:00:00', '2020-12-30 20:00:00', 1440, 60, 0, 'Небесный защитник', 0);

6)Связываем ивенты с нпс, Entry ивента 2011:

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849561, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849560, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849559, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849558, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849589, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849588, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849587, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849586, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849585, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849584, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849583, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849582, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849581, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849580, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849579, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849578, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849577, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849576, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849575, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849574, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849573, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849572, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849571, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849570, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849569, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849568, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849567, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849566, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849565, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849564, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849563, 2011);

INSERT INTO game_event_creature
(`guid`, `event`)
VALUES
(3849562, 2011);

 
Форум » TrinityCore » Разное для TrinityCore » КАК добавитьл эвент (КАК добавитьл эвент)
Страница 1 из 11
Поиск: