BattleGround NPCFlags Fix - Arcemu

[x1lla]

If your BG Npcs Just respond with a normal Text message or nothing, and you cant get to the Battleground Screen, here is a simple query that will fix it.

Apply the Query in your arcemuworld db

UPDATE `creature_proto` SET `NpcFlags` = `NpcFlags`|'1048576' WHERE `entry` IN (SELECT `entry` FROM `creature_names` WHERE `subname` LIKE 'Battlemaster') OR `entry` IN (7410,15008,14981,20381,30578,12197,20374,857,14982,20118,30581,20120,14942,3058 2,15006,20385,15105,347,15007,20386,2804,20274,20384,20276,20269,22015,10360,742 7,12198,20388,16696,20390,16695,16694,19905,14990,14991,15102,15103,15105,15106, 22013);

Its my first post and own work, so dont flame please. i just want to share to make the community a better place.


x1LLa

[Jackie Moon]

Doesnt Work for me

Got Syntax Error.

[x1lla]

what errors, giv a little detail.

[Choices]

It's because the quote tags you used messes up the query and spaces some numbers out

So if you see a space between 2 numbers clear it

UPDATE `creature_proto` SET `NpcFlags` = `NpcFlags`|'1048576' WHERE `entry` IN (SELECT `entry` FROM `creature_names` WHERE `subname` LIKE 'Battlemaster') OR `entry` IN (7410,15008,14981,20381,30578,12197,20374,857,14982,20118,30581,20120,14942,30582,15006,20385,15105,347,15007,20386,2804,20274,20384,20276,20269,22015,10360,7427,12198,20388,16696,20390,16695,16694,19905,14990,14991,15102,15103,15105,15106, 22013);

[x1lla]

oh, yes remove the spaces and it works, if u still get a error plz post here then

[hellireas]

If your BG Npcs Just respond with a normal Text message or nothing, and you cant get to the Battleground Screen, here is a simple query that will fix it.

Apply the Query in your arcemuworld db




Its my first post and own work, so dont flame please. i just want to share to make the community a better place.


x1LLa

Hi i got an error not sure if its my repack or i did something wrong, i'm using arcemu repack 2003 with 2004 revision, this is my error,

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2,15006,20385,15105,347,15007,20386,2804,20274,20384,20276,20269,22015,10360,74 2' at line 1

Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000



sorry it now works, i didnt see the other posts and replys when i 1st got here

ok i have this issue with the battlegrounds this is where they ask you to go, any ideas +rep for the fix =)
AV = WSG
AB = AB
WSG = WSG
EoS = EoS
SoA = WSG

[Bunster]

Repost, i did this post not logn ago.