BattleGround NPCFlags Fix - Arcemu menu

Shout-Out

User Tag List

Results 1 to 7 of 7
  1. #1
    x1lla's Avatar Member
    Reputation
    6
    Join Date
    Dec 2008
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    BattleGround NPCFlags Fix - Arcemu

    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

    BattleGround NPCFlags Fix - Arcemu
  2. #2
    Jackie Moon's Avatar Elite User
    Reputation
    407
    Join Date
    May 2008
    Posts
    923
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Doesnt Work for me

    Got Syntax Error.
    Check out my YouTube: SkeetzGaming

  3. #3
    x1lla's Avatar Member
    Reputation
    6
    Join Date
    Dec 2008
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    what errors, giv a little detail.

  4. #4
    Choices's Avatar Member
    Reputation
    94
    Join Date
    Apr 2008
    Posts
    231
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

    Code:
    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);

  5. #5
    x1lla's Avatar Member
    Reputation
    6
    Join Date
    Dec 2008
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh, yes remove the spaces and it works, if u still get a error plz post here then

  6. #6
    hellireas's Avatar Member
    Reputation
    1
    Join Date
    Sep 2008
    Posts
    2
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by x1lla View Post
    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
    Last edited by hellireas; 01-23-2009 at 05:09 AM.

  7. #7
    Bunster's Avatar Active Member
    Reputation
    19
    Join Date
    May 2008
    Posts
    553
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Repost, i did this post not logn ago.

Similar Threads

  1. [C++] Instances Fix ArcEmu
    By P1raten in forum WoW EMU General Releases
    Replies: 10
    Last Post: 04-15-2010, 08:00 PM
  2. Runic Power Fix ARCemu
    By emil090 in forum WoW EMU General Releases
    Replies: 26
    Last Post: 01-05-2009, 10:11 PM
  3. ArcEmu 2.4.3 Crashing - Found a Fix
    By arcticwolf8 in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 07-23-2008, 03:35 AM
  4. [Release]Arcemu r301 stats bugg fixed + teleporter npc
    By soul02 in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 07-17-2008, 11:43 AM
  5. Fix The BattleGround Model Edit Please
    By elitee in forum WoW ME Questions and Requests
    Replies: 0
    Last Post: 09-22-2007, 06:42 PM
All times are GMT -5. The time now is 01:23 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search