|
---|
|
Корзина / Trash can Глупые, устаревшие, неактуальные темы будут тут. Чистится при каждом апдейте базы. Сюда сливается весь треш форума. Если ваш пост оказался здесь, подумайте - стоит ли еще раз писать? |
|
Опции темы | Поиск в этой теме | Опции просмотра |
09.01.2011, 20:40 | #1 |
Мастер выкладывания кешей!
Регистрация: 06.11.2009
Сообщений: 56
Сказал(а) спасибо: 25
Поблагодарили 50 раз(а) в 30 сообщениях
|
Как их "Отбить"
Уже реализовали на тринити.
У меня стоит данный хак, 50% мобов над кораблями парят, а другие нормально стоят. Как их "Отбить" Последний раз редактировалось Norman; 09.01.2011 в 20:50. |
09.01.2011, 20:51 | #2 |
YTDB dev
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
|
Сами ставите - сами думайте, из чистой тринити он давно вроде убран, как таблица эта там появилась...
Отбить просто - заменить знак | на (посмотреть на правку откат в каждом апе, последний абзац, если доки не любите читать) Последний раз редактировалось NeatElves; 09.01.2011 в 20:54. |
09.01.2011, 21:03 | #3 |
Мастер выкладывания кешей!
Регистрация: 06.11.2009
Сообщений: 56
Сказал(а) спасибо: 25
Поблагодарили 50 раз(а) в 30 сообщениях
|
Не понял, какой абзац
|
09.01.2011, 22:59 | #4 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
В каждом апе есть такое
Код:
# NPC_FIX UPDATE `creature_template_addon`, `creature_template` SET `creature_template`.`unit_flags`=IF(`creature_template`.`unit_flags` & 33554432=33554432,570721024,537166592), `creature_template`.`dynamicflags`=`creature_template`.`dynamicflags` | 32 WHERE `creature_template`.`entry`=`creature_template_addon`.`entry` AND `creature_template_addon`.`auras`='29266 0 29266 1'; UPDATE `creature_template` SET `faction_A` = '1802' WHERE `faction_A` = '1732'; UPDATE `creature_template` SET `faction_A` = '1802' WHERE `faction_A` = '1733'; UPDATE `creature_template` SET `faction_A` = '1802' WHERE `faction_A` = '84'; UPDATE `creature_template` SET `faction_H` = '1802' WHERE `faction_H` = '1732'; UPDATE `creature_template` SET `faction_H` = '1802' WHERE `faction_H` = '1733'; UPDATE `creature_template` SET `faction_H` = '1802' WHERE `faction_H` = '84'; UPDATE `creature_template` SET `faction_A` = '1801' WHERE `faction_A` = '1735'; UPDATE `creature_template` SET `faction_A` = '1801' WHERE `faction_A` = '1734'; UPDATE `creature_template` SET `faction_A` = '1801' WHERE `faction_A` = '83'; UPDATE `creature_template` SET `faction_H` = '1801' WHERE `faction_H` = '1735'; UPDATE `creature_template` SET `faction_H` = '1801' WHERE `faction_H` = '1734'; UPDATE `creature_template` SET `faction_H` = '1801' WHERE `faction_H` = '83'; UPDATE `gameobject_template` SET `faction` = '1801' WHERE `faction` = '1735'; UPDATE `gameobject_template` SET `faction` = '1801' WHERE `faction` = '1734'; UPDATE `gameobject_template` SET `faction` = '1801' WHERE `faction` = '83'; UPDATE `gameobject_template` SET `faction` = '1802' WHERE `faction` = '1732'; UPDATE `gameobject_template` SET `faction` = '1802' WHERE `faction` = '1733'; UPDATE `gameobject_template` SET `faction` = '1802' WHERE `faction` = '84'; UPDATE `creature_template`, `creature_template` AS `copy` SET `copy`.`RegenHealth`=`creature_template`.`RegenHealth`, `copy`.`unit_class`=`creature_template`.`unit_class`, `copy`.`unit_flags`=`creature_template`.`unit_flags`, `copy`.`npcflag`=`creature_template`.`npcflag`, `copy`.`dynamicflags`=`creature_template`.`dynamicflags`, `copy`.`equipment_id`=`creature_template`.`equipment_id`, `copy`.`faction_A`=`creature_template`.`faction_A`, `copy`.`faction_H`=`creature_template`.`faction_H`, `copy`.`speed_run`=`creature_template`.`speed_run`, `copy`.`speed_walk`=`creature_template`.`speed_walk`, `copy`.`scale`=`creature_template`.`scale`, `copy`.`dmgschool`=`creature_template`.`dmgschool`, `copy`.`mingold`=`creature_template`.`mingold`, `copy`.`maxgold`=`creature_template`.`maxgold`, `copy`.`VehicleId`=`creature_template`.`VehicleId`, `copy`.`mechanic_immune_mask`=`creature_template`.`mechanic_immune_mask` WHERE `copy`.`entry`=`creature_template`.`difficulty_entry_1`; UPDATE `creature_template`, `creature_template` AS `copy` SET `copy`.`RegenHealth`=`creature_template`.`RegenHealth`, `copy`.`unit_class`=`creature_template`.`unit_class`, `copy`.`unit_flags`=`creature_template`.`unit_flags`, `copy`.`npcflag`=`creature_template`.`npcflag`, `copy`.`dynamicflags`=`creature_template`.`dynamicflags`, `copy`.`equipment_id`=`creature_template`.`equipment_id`, `copy`.`faction_A`=`creature_template`.`faction_A`, `copy`.`faction_H`=`creature_template`.`faction_H`, `copy`.`speed_run`=`creature_template`.`speed_run`, `copy`.`speed_walk`=`creature_template`.`speed_walk`, `copy`.`scale`=`creature_template`.`scale`, `copy`.`dmgschool`=`creature_template`.`dmgschool`, `copy`.`mingold`=`creature_template`.`mingold`, `copy`.`maxgold`=`creature_template`.`maxgold`, `copy`.`VehicleId`=`creature_template`.`VehicleId`, `copy`.`mechanic_immune_mask`=`creature_template`.`mechanic_immune_mask` WHERE `copy`.`entry`=`creature_template`.`difficulty_entry_2`; UPDATE `creature_template`, `creature_template` AS `copy` SET `copy`.`RegenHealth`=`creature_template`.`RegenHealth`, `copy`.`unit_class`=`creature_template`.`unit_class`, `copy`.`unit_flags`=`creature_template`.`unit_flags`, `copy`.`npcflag`=`creature_template`.`npcflag`, `copy`.`dynamicflags`=`creature_template`.`dynamicflags`, `copy`.`equipment_id`=`creature_template`.`equipment_id`, `copy`.`faction_A`=`creature_template`.`faction_A`, `copy`.`faction_H`=`creature_template`.`faction_H`, `copy`.`speed_run`=`creature_template`.`speed_run`, `copy`.`speed_walk`=`creature_template`.`speed_walk`, `copy`.`scale`=`creature_template`.`scale`, `copy`.`dmgschool`=`creature_template`.`dmgschool`, `copy`.`mingold`=`creature_template`.`mingold`, `copy`.`maxgold`=`creature_template`.`maxgold`, `copy`.`VehicleId`=`creature_template`.`VehicleId`, `copy`.`mechanic_immune_mask`=`creature_template`.`mechanic_immune_mask` WHERE `copy`.`entry`=`creature_template`.`difficulty_entry_3`; # FINAL_ITEM_FIX UPDATE `item_template` SET `StatsCount`=1 WHERE `stat_type1`>0 AND `stat_value1`<>0; UPDATE `item_template` SET `StatsCount`=2 WHERE `stat_type2`>0 AND `stat_value2`<>0; UPDATE `item_template` SET `StatsCount`=3 WHERE `stat_type3`>0 AND `stat_value3`<>0; UPDATE `item_template` SET `StatsCount`=4 WHERE `stat_type4`>0 AND `stat_value4`<>0; UPDATE `item_template` SET `StatsCount`=5 WHERE `stat_type5`>0 AND `stat_value5`<>0; UPDATE `item_template` SET `StatsCount`=6 WHERE `stat_type6`>0 AND `stat_value6`<>0; UPDATE `item_template` SET `StatsCount`=7 WHERE `stat_type7`>0 AND `stat_value7`<>0; UPDATE `item_template` SET `StatsCount`=8 WHERE `stat_type8`>0 AND `stat_value8`<>0; UPDATE `item_template` SET `StatsCount`=9 WHERE `stat_type9`>0 AND `stat_value9`<>0; UPDATE `item_template` SET `StatsCount`=10 WHERE `stat_type10`>0 AND `stat_value10`<>0; UPDATE `item_template` SET `DisenchantID` = 0 WHERE `RequiredDisenchantSkill` = -1; # Final_FIX UPDATE quest_template SET SpecialFlags=SpecialFlags|1 WHERE QuestFlags=QuestFlags|4096; UPDATE quest_template SET SpecialFlags=SpecialFlags|1 WHERE QuestFlags=QuestFlags|32768; DELETE FROM `creature_addon` WHERE `guid` NOT IN (SELECT `guid` FROM `creature`); DELETE FROM `linked_respawn` WHERE `guid` NOT IN (SELECT `guid` FROM `creature`); DELETE FROM `linked_respawn` WHERE `linkedGuid` NOT IN (SELECT `guid` FROM `creature`); DELETE FROM `npc_gossip` WHERE `npc_guid` NOT IN (SELECT `guid` FROM `creature`); DELETE FROM `game_event_gameobject` WHERE `guid` NOT IN (SELECT `guid` FROM `gameobject`); DELETE FROM `game_event_creature` WHERE `guid` NOT IN (SELECT `guid` FROM `creature`); UPDATE creature_template SET unit_flags=unit_flags&~2048 WHERE unit_flags&2048=2048; UPDATE creature_template SET unit_flags=unit_flags&~524288 WHERE unit_flags&524288=524288; UPDATE creature_template SET unit_flags=unit_flags&~67108864 WHERE unit_flags&67108864=67108864; UPDATE creature_template SET unit_flags=unit_flags&~8388608 WHERE unit_flags&8388608=8388608; UPDATE `creature` SET `MovementType` = 0 WHERE `spawndist` = 0 AND `MovementType`=1; UPDATE `creature` SET `spawndist`=0 WHERE `MovementType`=0; UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 25; UPDATE `gameobject` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 25; UPDATE `creature_template` SET `scale` = 1 WHERE `scale` = 0; update gameobject_template, gameobject set gameobject.animprogress = 100 where gameobject_template.entry = gameobject.id and gameobject_template.type = 0; update gameobject_template, gameobject set gameobject.animprogress = 100 where gameobject_template.entry = gameobject.id and gameobject_template.type = 3; update gameobject_template, gameobject set gameobject.animprogress = 100 where gameobject_template.entry = gameobject.id and gameobject_template.type = 10; update gameobject_template, gameobject set gameobject.animprogress = 100 where gameobject_template.entry = gameobject.id and gameobject_template.type = 25; UPDATE `gameobject` SET `state`=1 WHERE `state`=0 AND `id` IN (SELECT entry FROM `gameobject_template` WHERE `type`=3); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` IN (SELECT `id` FROM `creature_questrelation`); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` IN (SELECT `id` FROM `creature_involvedrelation`); UPDATE `gameobject` SET `state` = 0 WHERE `id` IN (SELECT `entry` FROM `gameobject_template` WHERE `type` = 0 AND `data0` = 1); UPDATE `gameobject_template` SET `flags`=`flags`&~4 WHERE `type` IN (2,19,17); DELETE FROM `gameobject_scripts` WHERE `id` NOT IN (SELECT `guid` FROM `gameobject`); DELETE FROM `gameobject_scripts` WHERE `command` in (11, 12) and `datalong` NOT IN (SELECT `guid` FROM `gameobject`); DELETE FROM `creature_onkill_reputation` WHERE `creature_id` NOT IN (SELECT `entry` FROM `creature_template`); UPDATE `item_template` SET `spelltrigger_2` = 0 WHERE `spellid_2` = 0 AND `spelltrigger_2` = 6; UPDATE `creature_template` SET `ScriptName` = '' WHERE `AIName` = 'EventAI' AND `ScriptName` = 'generic_creature'; UPDATE `creature_template` SET npcflag = npcflag|1 WHERE `gossip_menu_id` > 0; UPDATE `creature`, `waypoint_data` SET `creature`.`spawndist`=0, `creature`.`MovementType`=2 WHERE `creature`.`guid`=`waypoint_data`.`id`; DELETE `waypoint_data` FROM `waypoint_data` LEFT JOIN (`creature`) ON (`creature`.`guid`=`waypoint_data`.`id`) WHERE `creature`.`guid` IS NULL; ALTER TABLE `waypoint_data` ADD INDEX `temp_action` (`action`); ALTER TABLE `waypoint_scripts` ADD INDEX `temp_id` (`id`); DELETE `waypoint_scripts` FROM `waypoint_scripts` LEFT JOIN (`waypoint_data`) ON (`waypoint_data`.`action`=`waypoint_scripts`.`id`) WHERE `waypoint_data`.`action` IS NULL; ALTER TABLE `waypoint_data` DROP INDEX `temp_action`; ALTER TABLE `waypoint_scripts` DROP INDEX `temp_id`; update creature_addon set path_id=0; UPDATE `creature_addon`, `waypoint_data` SET `creature_addon`.`path_id`=`creature_addon`.`guid` WHERE `creature_addon`.`guid`=`waypoint_data`.`id`;
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
|
|
Похожие темы | ||||
Тема | Автор | Раздел | Ответов | Последнее сообщение |
[10678] Revert "[10675] Ignore BOA items reputation requirements at use." | newsbot | CMaNGOS Commits | 0 | 04.11.2010 13:20 |
[10558] Fix spell "Spinning" (64385) for item "Unusual Compass" (45984) | newsbot | CMaNGOS Commits | 0 | 30.09.2010 00:22 |
[10179] Add "missing" spells in commented form for Aura::TriggerSpell() | newsbot | CMaNGOS Commits | 0 | 11.07.2010 14:40 |
[9272] Revert "[9265] * Call Database::ThreadStart()/ThreadEnd() for all DBs." | newsbot | CMaNGOS Commits | 0 | 30.01.2010 18:10 |