![](https://www.getmangos.eu/uploads/set_resources_27/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
![](https://www.getmangos.eu/uploads/set_resources_27/84c1e40ea0e759e3f1505eb1788ddf3c_default_photo.png)
opper
Members-
Posts
5 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
opper's Achievements
![Rank: Newbie (1/3) Newbie](https://www.getmangos.eu/uploads/set_resources_27/84c1e40ea0e759e3f1505eb1788ddf3c_default_rank.png)
Newbie (1/3)
0
Reputation
-
Copy that. thx <div class='sqltop'>SQL</div><div class='sqlmain'>INSERT INTO creature_template_addon (`entry`, `mount`, `bytes0`, `bytes1`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES('17209','0','16777472','0','4097','0','0','17327 0'); </div> <div class='sqltop'>SQL</div><div class='sqlmain'>DELETE FROM creature_addon WHERE guid = 91885; </div>or <div class='sqltop'>SQL</div><div class='sqlmain'>DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id = 17209); </div>if editing into the original opvp_sql_mangos.sql
-
in the opvp_sql_mangos.sql there's a line: <div class='sqltop'>SQL</div><div class='sqlmain'>delete from creature where id = 17209; -- delete the flight master that is spawned by the opvp </div> which has a spawn, creature guid 91885 that will be deleted by the query above but creature guid 91885 also has an entry in creature_addon (guid 91885) which I can't find anywhere else in the sql that removes it? thus get this on startup: ERROR:Creature (GUID: 91885) does not exist but has a record in `creature_addon` is that creature_addon entry suppose to remain there for some reasons or are we suppose to do this? <div class='sqltop'>SQL</div><div class='sqlmain'>DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id = 17209); </div>
-
Yes you need to write a patch for that as current revisions (since 60xx?) reads/re-calculate and set (default) reputation flags from dbc everytime a character logs in.
-
<div class='quotetop'>QUOTE (w12x @ Jul 7 2008, 11:53 AM) <{POST_SNAPBACK}></div> yum yum
-
Cheers to w12x for making yet another wish coming true
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
![](https://app.statuscake.com/button/index.php?Track=rY8W3bU5Dn&Days=1&Design=6)
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®