[SQL Event]Trade_ship_7319 - Форум

Страница 1 из 1 1	Архив - только для чтения
Модератор форума: andycrowz

[SQL Event]Trade_ship_7319 (В Booty Bay раз в 3 дня ...)

[SQL Event]Trade_ship_7319

Orionen

Mangos Site Master

Репутация: 484

Название эвента:
Trade_ship_7319
Описание эвента:
"Booty Bay" раз в 3 дня приплывает торговый корабль пиратов, где игроки могут купить редкие вещи (вещи добавить можете сами, изменить время эвента также).
Автор Эвента:
Автора эвента не знаю, врать не буду !
Скачать:

Прикрепления: trade_ship_7319.zip (2.5 Kb)

Сообщение # 1 отредактировано Orionen - Суббота, 25.04.2009, 09:20

pro100Witya

Старейшина форума

Репутация: 2406

Quote (Orionen)

В Локации "Booty Bay"

по-моему бути не локация happy

shatunoff95 (профиль вк)

Сообщение # 2 написано 25.04.2009 в 06:53

Orionen

Mangos Site Master

Репутация: 484

Quote (pro100Witya)

по-моему бути не локация

Хех ну а что же это cool

Сообщение # 3 написано 25.04.2009 в 09:05

pro100Witya

Старейшина форума

Репутация: 2406

Quote (Orionen)

Хех ну а что же это

эм...вообще-то Booty Bay - это Бухта Пиратов(Перевод официальный) - порт.....а локация - Stragenton Valey(Тернистая долина)...

shatunoff95 (профиль вк)

Сообщение # 4 написано 25.04.2009 в 09:19

Orionen

Mangos Site Master

Репутация: 484

Аа точно =)

Сообщение # 5 написано 25.04.2009 в 09:20

Fugu1

Царь, просто Царь.

Репутация: 534

Объясните дураку про шмот какие редкие вещи?

Счастье - это, когда: в доме - нет больных, в тюрьме - нет родных, среди друзей - нет гнилых!

Сообщение # 6 написано 26.04.2009 в 17:18

ForNoK

Центурион

Репутация: 289

А как время изменить?

Сообщение # 7 написано 13.05.2009 в 18:23

Fixxxer

Сержант

Репутация: 30

Ващи там только сет т2. Книги всякие до 70 уровня. и бутыли. Сам эвент сделан ещё до ВОТЛК.
Советую что-нибудь поменять там.

Code

INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES (280, '2008-05-08 12:00:00', '2020-12-31 09:00:00', 7200, 30, 'Trade ship in Booty bay');

Значит так: 2008-05-08 12:00:00 - дата и время первого старта.
7200 - через какие время он повториться в минутах.
30 - сколько будет идти в минутах.

Разные пути... и все ведут на кладбище....

Сообщение # 8 написано 14.05.2009 в 00:55

Оби_ВаН

Чемпион

Репутация: 185

Народ срочно нужен этот эвент на 3.1.3 сборка антипа:)))!!!!
Кто дас тому дам ++ с двух акков

Помог?Ставь +!

Сообщение # 9 написано 16.09.2009 в 19:41

K1T

Рыцарь

Репутация: 63

зАЧЕТНАЯ ИДЕЯ !

ApolloDays - У нас вы найдете самые интересные новостные,фото,видео Факты.
Будьте с нами и мы покажем вам мир с другой стороны.
Обновляем наши разделы каждый день что бы всегда держать вас в потоке информации.

Сообщение # 10 написано 17.09.2009 в 00:18

PANASUN

Капрал

Репутация: 31

А как вещи поменять????

помог ставь +

Сообщение # 11 написано 24.09.2009 в 08:19

Deviljin844

Скаут

Репутация: 32

При добавление в БД пишет

Code

Ошибка

SQL-запрос:

INSERT INTO `gameobject_template` ( `entry` , `type` , `displayId` , `name` , `castBarCaption` , `faction` , `flags` , `size` , `data0` , `data1` , `data2` , `data3` , `data4` , `data5` , `data6` , `data7` , `data8` , `data9` , `data10` , `data11` , `data12` , `data13` , `data14` , `data15` , `data16` , `data17` , `data18` , `data19` , `data20` , `data21` , `data22` , `data23` , `ScriptName` )
VALUES ( 800001, 15, 3015, 'TradeShip', '', 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '' ) ;

Ответ MySQL: Документация
#1062 - Duplicate entry '800001' for key 1

Сообщение # 12 написано 23.10.2009 в 12:47

Дзирт

Центурион

Репутация: 857

Deviljin844, если еще зам не понял измени номер 800001 на какой-то другой

Сообщение # 13 написано 23.10.2009 в 16:51

Deviljin844

Скаут

Репутация: 32

Quote (Дзирт)

eviljin844, если еще зам не понял измени номер 800001 на какой-то другой

спс,я просто в MySQL слабоват,я больше в php и html.С одним решено появилось другое

Code

Ошибка

SQL-запрос:

INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800005, 0, 4489, '', 4489, '', 'Black Hawk', 'Sea Wolf', '', 55, 55, 17000, 17000, '', '', '', 120, 120, '', '', 1, 1,[...]

Ответ MySQL: Документация
#1054 - Unknown column 'class' in 'field list'

Сообщение # 14 отредактировано Deviljin844 - Пятница, 23.10.2009, 17:08

Дзирт

Центурион

Репутация: 857

Перевод: неузнаваемая колонка "Class"
Сам не врубаюсь почему

Сообщение # 15 написано 23.10.2009 в 20:14

Unlimited

trinity@localhost

Репутация: 1402

норм

Сообщение # 16 написано 24.10.2009 в 17:33

Deviljin844

Скаут

Репутация: 32

У меня сервак 3.2.2а

Сообщение # 17 написано 24.10.2009 в 21:12

Дзирт

Центурион

Репутация: 857

Я переделал под 3.2.2а вроде должно пахать
кому надо берите:

Code

INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (800001, 15, 3015, 'TradeShip', '', 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800005, 0, 4489, '', 4489, '', 'Black Hawk', 'Sea Wolf', '', 55, 55, 17000, 17000, '', '', '', 120, 120, '', '', 1, 1, 500, 500, '', 800, 1, '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, 0, '', '', 0, 0, '');

INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800006, 0, 797, '', 797, '','Captain Jack Low','Sea Wolf','',55, 55, 17000, 17000, '', '', '', 120, 120, '', '', 1, 1, 500, 500, '', 800, 1, '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, 0, '', '', 0, 0, '');

INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800007, 0, 7993, '', 7993, '', 'Juzz Lamstone','Sea Wolf','',55, 55, 17000, 17000, '', '', '', 120, 120, '', '', 1, 1, 500, 500, '', 800, 1, '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, 0, '', '', 0, 0, '');

INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800008, 0, 7161, 0, 7161, 0, 'Travellier', 'Sea Wolf', '',60, 60, 66000, 66000, 0, 0, 0, 120, 120,  128, '',0, 1, 600, 600, 0, 800, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 100, '', 0, 1, 0, 0, 0, 0, 0, '');

INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800009, 0, 11375, 0, 11375, 0, 'Bookmaker', 'Sea Wolf', '',60, 60, 66000, 66000, 0, 0, 0, 120, 120, 128, '',0, 1, 600, 600, 0, 800, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 100, '', 0, 1, 0, 0, 0, 0, 0, '');

INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800010, 0, 19539, 0, 19539, 0, 'Bob michal', 'Sea Wolf', '',60, 60, 66000, 66000, 0, 0, 0, 120, 120, 128, '',0, 1, 600, 600, 0, 800, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 100, '', 0, 1, 0, 0, 0, 0, 0, '');

INSERT INTO `gameobject` (`guid`,`id`,`map`, `spawnMask`, `position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`)  VALUES
('90142', '800001', '0', '1', '-14332.6', '512.695', '2.66028', '1.22823', '0', '0', '0.576237', '0.817283', '25', '0', '1');

INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES
(90142,280);

INSERT INTO `npc_vendor` VALUES (800008, 21994 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 21995 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 21996 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 21997 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 21998 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 21999 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22000 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22001 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22002 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22003 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22004 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22005 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22006 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22007 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22008 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22009 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22010 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22011 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22013 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22015 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22016 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22017 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22060 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22061 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22062 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22063 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22064 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22065 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22066 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22067 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22068 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22069 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22070 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22071 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22072 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22073 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22074 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22075 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22076 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22077 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22078 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22079 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22080 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22081 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22082 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22083 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22084 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22085 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22086 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22087 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22088 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22089 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22090 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22091 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22092 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22093 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22095 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22096 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22097 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22098 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22099 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22100 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22101 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22102 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22106 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22107 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22108 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22109 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22110 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22111 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22112 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800008, 22113, 0, 0, 0);

INSERT INTO `npc_vendor` VALUES (800009, 4213 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 6345 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 6376 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 6454 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 7192 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 9214 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 16083 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 16084 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 16112 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 16113 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 16665 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 17413 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 17414 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 17682 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 17683 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 18600 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 19442 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21214 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21279 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21280 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21281 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21282 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21283 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21284 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21285 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21287 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21288 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21289 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21290 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21291 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21292 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21293 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21294 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21295 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21296 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21297 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21298 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21299 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21300 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21302 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21303 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21304 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21306 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21307 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21992 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 21993 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22012 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22146 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22153 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22393 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22739 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22890 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22891 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 22897 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 23320 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 24101 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 24102 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 24345 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 27532 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 29549 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 29550 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 31501 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800009, 31837 , 0, 0, 0);

INSERT INTO `npc_vendor` VALUES (800010, 2459 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 3384 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 3387 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 3826 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 6372 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 9036 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 25539 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 22829 , 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (800010, 22832, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1303022, 800005, 0, 1, 0, 0, -14343.2, 503.783, 8.75854, 1.40271, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302962, 800005, 0, 1, 0, 0, -14330.7, 538.237, 18.7186, 0.197135, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302952, 800005, 0, 1, 0, 0, -14318.2, 528.801, 14.8072, 3.80212, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302942, 800005, 0, 1, 0, 0, -14324, 541.965, 13.8094, 3.4212, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302932, 800005, 0, 1, 0, 0, -14320.1, 526.375, 8.75803, 3.63719, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302922, 800005, 0, 1, 0, 0, -14342.9, 517.161, 8.75235, 5.37683, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1303002, 800005, 0, 1, 0, 0, -14332.4, 499.073, 19.1151, 3.69607, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302992, 800005, 0, 1, 0, 0, -14341.2, 502.072, 19.1405, 5.07837, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302982, 800005, 0, 1, 0, 0, -14339.5, 519.415, 14.0858, 6.20149, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302972, 800005, 0, 1, 0, 0, -14317.5, 533.755, 18.695, 2.26666, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302622, 800005, 0, 1, 0, 0, -14328.8, 502.303, 8.75843, 0.723227, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1303032, 800005, 0, 1, 0, 0, -14334.8, 534.377, 8.75807, 4.95743, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1303052, 800005, 0, 1, 0, 0, -14325.5, 510.424, 8.75822, 6.11118, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1303042, 800005, 0, 1, 0, 0, -14336.1, 508.417, 15.7335, 1.31632, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1303012, 800005, 0, 1, 0, 0, -14323.1, 513.803, 14.0979, 2.3609, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302642, 800005, 0, 1, 0, 0, -14321.2, 545.22, 20.9473, 4.31644, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302612, 800006, 0, 1, 0, 0, -14322, 547.425, 8.75588, 4.29679, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302632, 800007, 0, 1, 0, 0, -14331.5, 532.461, 14.7758, 4.85303, 25, 0, 0, 17000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302802, 800008, 0, 1, 0, 0, -14329.6, 520.943, 14.454, 1.29439, 25, 0, 0, 66000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302842, 800009, 0, 1, 0, 0, -14314.7, 545.586, 8.75255, 3.27902, 25, 0, 0, 66000, 0, 0, 0);

INSERT INTO creature
   (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
VALUES
   (1302892, 800010, 0, 1, 0, 0, -14320, 524.488, 8.75886, 3.96078, 25, 0, 0, 66000, 0, 0, 0);

INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1303022 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302962 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302952 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302942 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302932,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302922 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1303002 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302992 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302982 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302972 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302622 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1303032 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1303052 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1303042 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1303012 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302642 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302612 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302632 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302802 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302842 ,280);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (1302892 ,280);

DELETE FROM `game_event` WHERE (`entry`=280);
INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES (280, '2008-02-17 15:00:00', '2020-12-31 09:00:00', 1440, 60, 'Trade ship in Booty bay');

Не забывает ставить +

Сообщение # 18 отредактировано Дзирт - Понедельник, 26.10.2009, 10:13

ph3n

Developer

Репутация: 1543

Данная тема была перемещена из раздела Ивенты(Events) MaNGOS.
Причина перемещения: устарело

Переместил: ph3n.

Сообщение # 19 написано 16.10.2012 в 18:30

[SQL Event]Trade_ship_7319 (В Booty Bay раз в 3 дня ...)

Страница 1 из 1
1

Вход на портал