#Nerd Admin
Mensagens : 123 Reputacao : 10357 Agradescido : 2 Data de inscrição : 07/08/2010 Idade : 28 Localização : Games Trinyon
| Assunto: Correçoes ICC 3.3.3a Sáb Ago 07, 2010 9:21 am | |
| Opa galera! Estou fazendo umas correções em Icecrown Citadel e tem algumas outras correções de outras instances, são correções pequenas que você vão ver abaixo, já as de Icecrown Citadel, vou tentar fazer o máximo que consigo fazer. Algumas ja terminei, quando eu consegui fazer novas eu edito este primeiro post e crio mais um post dizendo que postei uma nova correção. Lembrando que usei este instalador:http://cca-server.playogame.com/instaladores-cca-server-f1/mangos-9359-332-psdb-292-t824.htm( MaNGOS-9359 (3.3.2) + PSDB-292 ) Em outros cores e outros repacks este bugs podem estar arrumados já Não postei no tópico próprio do MaNGOS, porque lá é só pra YTDB, e como o CCA compilou com a PSDB, então fiz em um tópico separado. Vou tentar fazer outras correções, mais por enquanto vocês podem ficar com estas Estou fazendo de tudo para desbugar ICC para vocês. O mais díficil de arrumar vai ser os scripts de falas, movimentos, etc. vou ver se consigo algo nisto. Vamos as correções:
NPC's que estavam como aliados e agora inimigos: - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=37011); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (37011, 0, 0, 0, 0, 0, 31092, 0, 31092, 0, 'The Damned', '', '', 0, 76, 80, 478800, 1575000, 0, 0, 9729, 14, 1, 0, 1, 1, 1, 3131, 3582, 0, 1060, 1, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 1701, 2073, 871, 6, 72, 37011, 0, 0, 0, 0, 0, 0, 0, 0, 70960, 70961, 71203, 0, 0, 7652, 7652, '', 0, 3, 38, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'generic_creature');
The Damned - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=37012); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (37012, 0, 0, 0, 0, 0, 30616, 30617, 30616, 30617, 'Ancient Skeletal Soldier', '', '', 0, 79, 80, 315000, 1134000, 0, 0, 9729, 14, 14, 0, 1, 1, 1, 3131, 3582, 0, 1060, 1, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 1701, 2073, 871, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 70964, 71203, 0, 0, 0, 0, 0, '', 0, 3, 25, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'generic_creature');
Ancient Skeletal Soldie - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=36724); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (36724, 0, 0, 0, 0, 0, 26919, 0, 26919, 0, 'Servant of the Throne', '', '', 0, 77, 80, 378000, 1260000, 99850, 99850, 9729, 14, 14, 0, 1, 1, 1, 3131, 3582, 0, 1060, 1, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 1701, 2073, 871, 6, 0, 36724, 0, 0, 0, 0, 0, 0, 0, 0, 71029, 71203, 0, 0, 0, 7604, 7604, '', 0, 3, 30, 25, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'generic_creature');
Servant of the Throne - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=36725); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (36725, 0, 0, 0, 0, 0, 30885, 0, 30885, 0, 'Nerub'ar Broodkeeper', '', '', 0, 78, 80, 315000, 1134000, 3994, 3994, 9729, 14, 14, 0, 1, 1, 1, 3131, 3582, 0, 1060, 1, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 1701, 2073, 871, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 70965, 71020, 70980, 71203, 0, 0, 0, '', 0, 3, 25, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'generic_creature');
Nerub'ar Bloodkeeper NPC Deathbound Ward não dava pra selecionar nem atacar, correção disso: - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=37007); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (37007, 14782, 14783, 14784, 0, 0, 30459, 0, 30459, 0, 'Deathbound Ward', '', '', 0, 81, 82, 1685125, 1685125, 0, 0, 10356, 14, 14, 0, 1.5, 1, 1, 3211, 3673, 0, 1087, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 1744, 2125, 893, 6, 72, 37007, 0, 0, 0, 0, 0, 0, 0, 0, 71022, 71021, 71203, 0, 0, 0, 0, '', 0, 3, 125, 1, 0, 0, 0, 0, 0, 0, 0, 381, 1, 0, 0, 0, 'generic_creature');
Instances de ICC pedindo level 80+ (ex: 90, 100 etc.) (também incluso correção de outras intances que estão pedindo level maior que 80 (ex: ToC) correção: - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5688 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5683 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5670 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5637 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5636 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5505 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5503 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5243 LIMIT 1 ; - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_level` = '80' WHERE `areatrigger_teleport`.`id` =5209 LIMIT 1 ; Trial of The champion precisa de Level 80 para entrar, o texto de falha estava falando que precisava de level 75, correção: - Código:
-
UPDATE `mangos`.`areatrigger_teleport` SET `required_failed_text` = 'You must be at least level 80 to enter.' WHERE `areatrigger_teleport`.`id` =5505 LIMIT 1 ; Tele's (IcecrownCitadel e IcecrownCitadelTheFrozenHalls) - Código:
-
INSERT INTO game_tele (id,position_x,position_y,position_z,orientation,map,name) VALUES (9438,5790.000000,2071.479980,636.064758,3.588925,571,'IcecrownCitadel'); - Código:
-
INSERT INTO game_tele (id,position_x,position_y,position_z,orientation,map,name) VALUES (9439,5635.037109,2047.051392,798.269897,4.586382,571,'IcecrownCitadelTheFrozenHalls'); ============================ATUALIZADO============================ Mais correções! NPC's que estavam aliados e agora inimigos:Spire Frostwyrm: - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=37230); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (37230, 0, 0, 0, 0, 0, 30902, 0, 30902, 0, 'Spire Frostwyrm', '', '', 0, 82, 82, 1078480, 5392400, 41690, 41690, 10356, 14, 14, 0, 1, 1, 1, 3211, 3673, 0, 1087, 1, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 1744, 2125, 893, 6, 72, 37230, 0, 0, 0, 0, 0, 0, 0, 0, 70362, 71118, 70361, 70116, 0, 0, 0, '', 0, 3, 80, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'generic_creature'); Spire Minion: - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=37545); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (37545, 0, 0, 0, 0, 0, 30656, 0, 30656, 0, 'Spire Minion', '', '', 0, 82, 82, 337025, 1213290, 41690, 41690, 10356, 14, 14, 0, 1, 1, 1, 3211, 3673, 0, 1087, 1, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 1744, 2125, 893, 6, 72, 37545, 0, 0, 0, 0, 0, 0, 0, 0, 70363, 70396, 71203, 0, 0, 8209, 8209, '', 0, 3, 25, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'generic_creature'); Spire Gargoyle - Código:
-
DELETE FROM `creature_template` WHERE (`entry`=37544); INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (37544, 0, 0, 0, 0, 0, 14696, 0, 14696, 0, 'Spire Gargoyle', '', '', 0, 82, 82, 337025, 1213290, 41690, 41690, 10356, 14, 14, 0, 1, 1, 1, 3211, 3673, 0, 1087, 1, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 1744, 2125, 893, 6, 72, 37544, 0, 0, 0, 0, 0, 0, 0, 0, 70189, 71203, 0, 0, 0, 8736, 8736, '', 0, 3, 25, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'generic_creature'); Como alguns sabe, tem a parte de ICC depois do elevador, onde tem aqueles Ghoul's, Frostwyrm's e Abomination, lá tem npc's um dentro do outro (repetidos) então aqui está um script para ficar só 1 e não um dentro do outro! ATENÇÃO!Este script é um script para teste, não foi testado se está funcionando corretamente, eu simplesmente fui no jogo e deletei os repetidos, ai o script peguei no log, não sei se vai adiantar! Então antes de tudo faça Backup da sua DB MaNGOS, para que se acontecer algo errado basta colocar o backup! Script: - Código:
-
DELETE FROM creature WHERE guid = '141436'; DELETE FROM creature_addon WHERE guid = '141436'; DELETE FROM creature_movement WHERE id = '141436'; DELETE FROM game_event_creature WHERE guid = '141436'; DELETE FROM game_event_model_equip WHERE guid = '141436'; DELETE FROM creature_battleground WHERE guid = '141436'; DELETE FROM creature WHERE guid = '140918'; DELETE FROM creature_addon WHERE guid = '140918'; DELETE FROM creature_movement WHERE id = '140918'; DELETE FROM game_event_creature WHERE guid = '140918'; DELETE FROM game_event_model_equip WHERE guid = '140918'; DELETE FROM creature_battleground WHERE guid = '140918'; DELETE FROM creature WHERE guid = '140894'; DELETE FROM creature_addon WHERE guid = '140894'; DELETE FROM creature_movement WHERE id = '140894'; DELETE FROM game_event_creature WHERE guid = '140894'; DELETE FROM game_event_model_equip WHERE guid = '140894'; DELETE FROM creature_battleground WHERE guid = '140894'; DELETE FROM creature WHERE guid = '140893'; DELETE FROM creature_addon WHERE guid = '140893'; DELETE FROM creature_movement WHERE id = '140893'; DELETE FROM game_event_creature WHERE guid = '140893'; DELETE FROM game_event_model_equip WHERE guid = '140893'; DELETE FROM creature_battleground WHERE guid = '140893'; DELETE FROM creature WHERE guid = '140912'; DELETE FROM creature_addon WHERE guid = '140912'; DELETE FROM creature_movement WHERE id = '140912'; DELETE FROM game_event_creature WHERE guid = '140912'; DELETE FROM game_event_model_equip WHERE guid = '140912'; DELETE FROM creature_battleground WHERE guid = '140912'; DELETE FROM creature WHERE guid = '140885'; DELETE FROM creature_addon WHERE guid = '140885'; DELETE FROM creature_movement WHERE id = '140885'; DELETE FROM game_event_creature WHERE guid = '140885'; DELETE FROM game_event_model_equip WHERE guid = '140885'; DELETE FROM creature_battleground WHERE guid = '140885'; DELETE FROM creature WHERE guid = '140895'; DELETE FROM creature_addon WHERE guid = '140895'; DELETE FROM creature_movement WHERE id = '140895'; DELETE FROM game_event_creature WHERE guid = '140895'; DELETE FROM game_event_model_equip WHERE guid = '140895'; DELETE FROM creature_battleground WHERE guid = '140895'; DELETE FROM creature WHERE guid = '140887'; DELETE FROM creature_addon WHERE guid = '140887'; DELETE FROM creature_movement WHERE id = '140887'; DELETE FROM game_event_creature WHERE guid = '140887'; DELETE FROM game_event_model_equip WHERE guid = '140887'; DELETE FROM creature_battleground WHERE guid = '140887'; DELETE FROM creature WHERE guid = '140899'; DELETE FROM creature_addon WHERE guid = '140899'; DELETE FROM creature_movement WHERE id = '140899'; DELETE FROM game_event_creature WHERE guid = '140899'; DELETE FROM game_event_model_equip WHERE guid = '140899'; DELETE FROM creature_battleground WHERE guid = '140899'; DELETE FROM creature WHERE guid = '140908'; DELETE FROM creature_addon WHERE guid = '140908'; DELETE FROM creature_movement WHERE id = '140908'; DELETE FROM game_event_creature WHERE guid = '140908'; DELETE FROM game_event_model_equip WHERE guid = '140908'; DELETE FROM creature_battleground WHERE guid = '140908'; DELETE FROM creature WHERE guid = '140907'; DELETE FROM creature_addon WHERE guid = '140907'; DELETE FROM creature_movement WHERE id = '140907'; DELETE FROM game_event_creature WHERE guid = '140907'; DELETE FROM game_event_model_equip WHERE guid = '140907'; DELETE FROM creature_battleground WHERE guid = '140907'; DELETE FROM creature WHERE guid = '140886'; DELETE FROM creature_addon WHERE guid = '140886'; DELETE FROM creature_movement WHERE id = '140886'; DELETE FROM game_event_creature WHERE guid = '140886'; DELETE FROM game_event_model_equip WHERE guid = '140886'; DELETE FROM creature_battleground WHERE guid = '140886'; DELETE FROM creature WHERE guid = '141440'; DELETE FROM creature_addon WHERE guid = '141440'; DELETE FROM creature_movement WHERE id = '141440'; DELETE FROM game_event_creature WHERE guid = '141440'; DELETE FROM game_event_model_equip WHERE guid = '141440'; DELETE FROM creature_battleground WHERE guid = '141440'; DELETE FROM creature WHERE guid = '141441'; DELETE FROM creature_addon WHERE guid = '141441'; DELETE FROM creature_movement WHERE id = '141441'; DELETE FROM game_event_creature WHERE guid = '141441'; DELETE FROM game_event_model_equip WHERE guid = '141441'; DELETE FROM creature_battleground WHERE guid = '141441'; DELETE FROM creature WHERE guid = '140916'; DELETE FROM creature_addon WHERE guid = '140916'; DELETE FROM creature_movement WHERE id = '140916'; DELETE FROM game_event_creature WHERE guid = '140916'; DELETE FROM game_event_model_equip WHERE guid = '140916'; DELETE FROM creature_battleground WHERE guid = '140916'; DELETE FROM creature WHERE guid = '140902'; DELETE FROM creature_addon WHERE guid = '140902'; DELETE FROM creature_movement WHERE id = '140902'; DELETE FROM game_event_creature WHERE guid = '140902'; DELETE FROM game_event_model_equip WHERE guid = '140902'; DELETE FROM creature_battleground WHERE guid = '140902'; DELETE FROM creature WHERE guid = '140913'; DELETE FROM creature_addon WHERE guid = '140913'; DELETE FROM creature_movement WHERE id = '140913'; DELETE FROM game_event_creature WHERE guid = '140913'; DELETE FROM game_event_model_equip WHERE guid = '140913'; DELETE FROM creature_battleground WHERE guid = '140913'; DELETE FROM creature WHERE guid = '140888'; DELETE FROM creature_addon WHERE guid = '140888'; DELETE FROM creature_movement WHERE id = '140888'; DELETE FROM game_event_creature WHERE guid = '140888'; DELETE FROM game_event_model_equip WHERE guid = '140888'; DELETE FROM creature_battleground WHERE guid = '140888'; DELETE FROM creature WHERE guid = '140891'; DELETE FROM creature_addon WHERE guid = '140891'; DELETE FROM creature_movement WHERE id = '140891'; DELETE FROM game_event_creature WHERE guid = '140891'; DELETE FROM game_event_model_equip WHERE guid = '140891'; DELETE FROM creature_battleground WHERE guid = '140891'; DELETE FROM creature WHERE guid = '140889'; DELETE FROM creature_addon WHERE guid = '140889'; DELETE FROM creature_movement WHERE id = '140889'; DELETE FROM game_event_creature WHERE guid = '140889'; DELETE FROM game_event_model_equip WHERE guid = '140889'; DELETE FROM creature_battleground WHERE guid = '140889'; DELETE FROM creature WHERE guid = '140884'; DELETE FROM creature_addon WHERE guid = '140884'; DELETE FROM creature_movement WHERE id = '140884'; DELETE FROM game_event_creature WHERE guid = '140884'; DELETE FROM game_event_model_equip WHERE guid = '140884'; DELETE FROM creature_battleground WHERE guid = '140884'; DELETE FROM creature WHERE guid = '140890'; DELETE FROM creature_addon WHERE guid = '140890'; DELETE FROM creature_movement WHERE id = '140890'; DELETE FROM game_event_creature WHERE guid = '140890'; DELETE FROM game_event_model_equip WHERE guid = '140890'; DELETE FROM creature_battleground WHERE guid = '140890';
Em breve posto mais correções! |
|