[6.x] Alliance - Brawlpub spawns

[ElleEntertainment]

http://pastebin.com/GfNw3CXy

the area is located in storwind tram area, so no need areatriggers

[MitchesD]

it cant be pushed, did you check it for double spawns? also phaseId is not valid

[ElleEntertainment]

there are no double spawn, what should i do now?

[Kinzcool]

SET @CGUID := (select max(guid) from creature);
SET @OGUID := (select max(guid) from gameobject);

....

(@CGUID+0, 68408, 369, 3, 1, '', -79.48066, 2462.06, -43.04464, 0.006766027, 7200, 0, 0), -- 68408 (Area: -1)
(@OGUID+0, 218206, 369, 3, 1, '', -45.40074, 2512.148, 6.988598, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -- 0 (Area: -1)

First of all, this part is going to delete the last guid in the database; don't do that. Instead just set it manually to max guid + 1.

As of the fact of not being able to push it, you just have to remove the PhaseId field as it isn't a text one in the db and is of no matter in this case.

[ElleEntertainment]

oh shit! XD I forgot to edit that! going to fix this and the orgrimmar patch (#14638)

[ghost]

Also: Use "INSERT INTO" instead of your 3 "REPLACE INTO" commands (not used by TC). 😼

[Kinzcool]

9ec07e0