Berkut_1 | Дата: Воскресенье, 29.11.2009, 19:13 | Сообщение # 1 |
Скаут
Группа: Пользователи
Сообщений: 10
Награды: 0
Репутация: 2
Статус:
| Code #-- Alterac Valley #Wintergrasp INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32616, 7); INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32617, 7); #Dalaran UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29669; UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29674; #поменял местами были попутаны UPDATE `creature` SET `id`=29669 WHERE `guid` = 137926; UPDATE `creature` SET `id`=29674 WHERE `guid` = 113465;
#-- Strand of the Ancients #Wintergrasp INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32622, 9); INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32623, 9); #Dalaran UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29671; UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29676; #орды и альянса стояли в одной точке спауна, перенес на свое место орды DELETE FROM `creature` WHERE `id`=29676; 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`) VALUES (113664, 29676, 571, 1, 1, 0, 0, 5974.76, 544.652, 661.779, 1.97222, 300, 0, 0, 5342, 0, 0, 0);
#-- Eye of the Storm #Wintergrasp INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32620, 1); INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32621, 1); #Dalaran UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29670; UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29675;
#-- Arathi Basin #Wintergrasp INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32618, 3); INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32619, 3); #Dalaran UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29668; UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29673;
#-- Strand of the Ancients #Wintergrasp INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32624, 2); INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES (32625, 2); #Dalaran UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29667; UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29672;
#-- расстановка флагов (так как gossip_ом туго поставил все-таки 1048576) #чтобы отключить ставим `npcflag` = 1048577 будет просто приветствовать UPDATE `creature_template` SET `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` in (29667, 29668, 29670, 29671,29672, 29673, 29675, 29676, 32616, 32617,32618,32619,32620,32621,32622,32623,32624,32625);
|
|
| |