Jump to content

[not working] Outdoor Pvp


Recommended Posts

  • Replies 621
  • Created
  • Last Reply

Top Posters In This Topic

First post updated for rev 6326.

This is a 7k+ line patch, no one's crazy enough to review it wink.gif The copyrighted content Kizura pointed to is in the SQL parts (the announcement texts actually).

And of course it's not made for use with other patches, no patch is made for that actually smile.gif it's just a bonus if they don't interfere with each other.

Link to comment
Share on other sites

<div class='quotetop'>QUOTE (w12x @ May 3 2008, 10:42 PM) <{POST_SNAPBACK}></div>

(this was first implemented with creatures, but there aren't any npcs assigned for halaa or terokkar forest, and db ppl would probably get mad at me for randomly spawning trigger npcs. xD[/b]
And maybe the people who don't want the extra overhead of doing moveinlineofsight for the vast majority of gameobjects that don't need it will get mad at you for NOT spawning trigger npcs. You seem to be doing big changes without discussing it with anyone... IF it's decided that we don't want AI for gameobjects then you did all that for nothing.
Link to comment
Share on other sites

<div class='quotetop'>QUOTE (Wyk3d @ Jul 19 2008, 09:36 AM) <{POST_SNAPBACK}></div>

And maybe the people who don't want the extra overhead of doing moveinlineofsight for the vast majority of gameobjects that don't need it will get mad at you for NOT spawning trigger npcs. You seem to be doing big changes without discussing it with anyone... IF it's decided that we don't want AI for gameobjects then you did all that for nothing.[/b]

right now there is nothing for w12x except maybe respect and thanks from the user of this patch after all this patch are under review section and got changed and update through the time according to core changed and updates. About without discussing it with anyone you/Dev's are discussing with him when you review it, am i wrong about this?. tongue.gif

Link to comment
Share on other sites

<div class='quotetop'>QUOTE (Wyk3d @ Jul 19 2008, 04:36 AM) <{POST_SNAPBACK}></div>

And maybe the people who don't want the extra overhead of doing moveinlineofsight for the vast majority of gameobjects that don't need it will get mad at you for NOT spawning trigger npcs. You seem to be doing big changes without discussing it with anyone... IF it's decided that we don't want AI for gameobjects then you did all that for nothing.[/b]

http://www.mangosproject.org/forum/index.p...c=21760&hl=

Link to comment
Share on other sites

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>

Link to comment
Share on other sites

<div class='quotetop'>QUOTE (opper @ Jul 28 2008, 11:34 AM) <{POST_SNAPBACK}></div>

in the opvp_sql_mangos.sql there's a line:

<div class='sqltop'>SQL

<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>[/b]

I didn't check if the deleted creatures has addons, sorry about that. Since there is only one spawn of the given creature, I think it should have this addon in creature_template_addon and not in creature_addon.

Link to comment
Share on other sites

Copy that. thx smile.gif

<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

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use