May be fix

[zhanhang02]

update creature_template set faction_A=17 where entry=38;
update creature_template set faction_H=17 where entry=38;
update creature_template set faction_A=17 where entry=103;
update creature_template set faction_H=17 where entry=103;



I'm not sure whether it is the correct fix, a friend to correct it?

[zhanhang02]

UPDATE `creature_template` SET `faction_A`='35', `faction_H`='35' WHERE (`entry`='15730');
UPDATE `creature_template` SET `faction_A`='35', `faction_H`='35' WHERE (`entry`='15897');



I'm not sure whether it is the correct fix, a friend to correct it?

[YuruY]

http://www.wowhead.com/npc=38#comments
They are Neutral as of 3.3.

[zhanhang02]

UPDATE `creature_template` SET `modelid2`='0' WHERE (`entry`='25038');


For tc2

[YuruY]

UPDATE `creature_template` SET `modelid2`='0' WHERE (`entry`='25038');


For tc2

WDB:

[zhanhang02]

When using modelid2, the model shows that when the call came out wrong, is like a broom. Perhaps the fix is a Hack, but completely normal.

[YuruY]

is like a broom :laugh3:

[zhanhang02]

.go 1596.8 110.2 -62.2 0

You will find a lot of duplication of road signs throughout the city, not just this one place.

This will be a big workload.

[NeatElves]

DELETE FROM gameobject WHERE guid = '47882';
DELETE FROM game_event_gameobject WHERE guid = '47882';
DELETE FROM gameobject_battleground WHERE guid = '47882';
DELETE FROM gameobject WHERE guid = '47881';
DELETE FROM game_event_gameobject WHERE guid = '47881';
DELETE FROM gameobject_battleground WHERE guid = '47881';

[zhanhang02]

.go 1593.45 178.03 -62.18 0

.go 1648.76 292.87 -62.18 0

.go 1543.50 291.50 -62.18 0

You will find a lot of duplication of road signs throughout the city, not just this one place

There are other areas, waiting to submit the address of the test

[NeatElves]

DELETE FROM gameobject WHERE guid = '47899';
DELETE FROM game_event_gameobject WHERE guid = '47899';
DELETE FROM gameobject_battleground WHERE guid = '47899';
DELETE FROM gameobject WHERE guid = '47905';
DELETE FROM game_event_gameobject WHERE guid = '47905';
DELETE FROM gameobject_battleground WHERE guid = '47905';
DELETE FROM gameobject WHERE guid = '47908';
DELETE FROM game_event_gameobject WHERE guid = '47908';
DELETE FROM gameobject_battleground WHERE guid = '47908';
DELETE FROM gameobject WHERE guid = '47907';
DELETE FROM game_event_gameobject WHERE guid = '47907';
DELETE FROM gameobject_battleground WHERE guid = '47907';
DELETE FROM gameobject WHERE guid = '47892';
DELETE FROM game_event_gameobject WHERE guid = '47892';
DELETE FROM gameobject_battleground WHERE guid = '47892';
DELETE FROM gameobject WHERE guid = '47893';
DELETE FROM game_event_gameobject WHERE guid = '47893';
DELETE FROM gameobject_battleground WHERE guid = '47893';
DELETE FROM gameobject WHERE guid = '47901';
DELETE FROM game_event_gameobject WHERE guid = '47901';
DELETE FROM gameobject_battleground WHERE guid = '47901';
DELETE FROM gameobject WHERE guid = '47462';
DELETE FROM game_event_gameobject WHERE guid = '47462';
DELETE FROM gameobject_battleground WHERE guid = '47462';
DELETE FROM gameobject WHERE guid = '47457';
DELETE FROM game_event_gameobject WHERE guid = '47457';
DELETE FROM gameobject_battleground WHERE guid = '47457';
DELETE FROM gameobject WHERE guid = '47458';
DELETE FROM game_event_gameobject WHERE guid = '47458';
DELETE FROM gameobject_battleground WHERE guid = '47458';
DELETE FROM gameobject WHERE guid = '47459';
DELETE FROM game_event_gameobject WHERE guid = '47459';
DELETE FROM gameobject_battleground WHERE guid = '47459';

[zhanhang02]

Quest: 8746/8762

Can not be completed.

A friend can fix it?

[YuruY]

http://ytdb.ru/showthread.php?t=9211