ArcEmu: How to: Fix battlemasters - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

How to: Fix battlemasters (Not needed on WhyDB)

#1 User is offline   Azrael 

  • Member
  • Pip
  • Group: Members
  • Posts: 11
  • Joined: 06-July 08

Posted 30 May 2009 - 04:43 AM

Simply run this SQL code and you will be able to talk to battlemasters properly. If you're running WhyDB then you don't need this, but as far as I know all other DBs do need this.
CODE-BOX
-- AB

UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 857;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 907;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 12198;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 14990;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 14991;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 15006;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 15007;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 15008;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 16694;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 19855;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 19905;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20120;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20273;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20274;

-- AV

UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 347;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 5118;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 7410;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 12197;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 14942;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 15103;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 15106;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 16695;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 19906;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 19907;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20119;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20271;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20276;

-- EOTS

UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20362;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20374;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20381;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20382;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20383;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20384;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20385;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20386;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20388;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20390;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 22013;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 22015;

-- SOTA

UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 29234;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30578;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30579;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30580;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30581;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30582;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30583;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30584;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30586;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30587;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 30590;

-- WSG

UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 2302;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 2804;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 3890;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 10360;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 14981;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 14982;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 15102;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 15105;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 16696;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 19908;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 19910;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20118;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20269;
UPDATE `creature_proto` SET `npcflags`= `npcflags`| 1048576 WHERE `entry` = 20272;


(This fix was originally suggested by Wizzs.)
0

#2 User is offline   SB@L 

  • ArcEmu lover
  • PipPipPipPip
  • Group: Developers
  • Posts: 616
  • Joined: 12-June 08
  • Gender:Male
  • Location:Slovakia

Posted 30 May 2009 - 06:02 AM

Is the "|=" valid operator in SQL?
If not, use x = x | flag
You can even use flag in hex format: 0x100000...
SQL scripts: To remove pet spells from player
CRASH REPORTING TUTORIAL
TIP: If your core crashes on startup, its probably an outdated DB, apply recent sql updates.
0

#3 User is offline   Azrael 

  • Member
  • Pip
  • Group: Members
  • Posts: 11
  • Joined: 06-July 08

Posted 30 May 2009 - 10:00 AM

Oh god, you're right! I've made a terrible mistake! Remember, kids, this is why you test your fixes first!

Anyway, I've fixed the fix.
0

#4 User is offline   panos 

  • Member
  • Pip
  • Group: Members
  • Posts: 28
  • Joined: 22-October 08

Posted 31 May 2009 - 03:59 AM

UPDATE `creature_proto` SET `npcflags`= 1048576 WHERE `entry` = 14991;

that would work too easier and simpler
AKA Glad


0

#5 User is offline   Elessar 

  • Newbie
  • Group: Members
  • Posts: 5
  • Joined: 01-October 08

Posted 01 June 2009 - 01:44 AM

You can delete the npc and put it again with GMH.
0

#6 User is offline   SB@L 

  • ArcEmu lover
  • PipPipPipPip
  • Group: Developers
  • Posts: 616
  • Joined: 12-June 08
  • Gender:Male
  • Location:Slovakia

Posted 01 June 2009 - 09:17 AM

View Postpanos, on May 31 2009, 09:59 AM, said:

UPDATE `creature_proto` SET `npcflags`= 1048576 WHERE `entry` = 14991;

that would work too easier and simpler

What about other flags, eg. UNIT_NPC_FLAG_GOSSIP? Not needed?
SQL scripts: To remove pet spells from player
CRASH REPORTING TUTORIAL
TIP: If your core crashes on startup, its probably an outdated DB, apply recent sql updates.
0

#7 User is offline   panos 

  • Member
  • Pip
  • Group: Members
  • Posts: 28
  • Joined: 22-October 08

Posted 02 June 2009 - 03:28 PM

View PostSB@L, on Jun 1 2009, 03:17 PM, said:

What about other flags, eg. UNIT_NPC_FLAG_GOSSIP? Not needed?


i did mistake on my query??? what do you mean explain a little confused here
AKA Glad


0

#8 User is offline   HaKaShi 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 252
  • Joined: 07-June 08
  • Location:Lithuania

Posted 28 November 2009 - 01:27 PM

:D

UPDATE `creature_proto` SET `npcflags`= '1048576' WHERE `entry` = 20272; <--- Right Way !
you douchebags !

Quote

If you give a source to a N00B, He will leech for days... If you teach him how to code, The N00B is gone....

SELECT 'boobs' FROM 'Humans' WHERE 'gender' = 'female' AND 'size' = 'enough' AND 'leftsize' = 'rightsize' LIMIT 2
0

#9 User is offline   Terrorblade 

  • ArcEmu Lover
  • Group: Banned
  • Posts: 440
  • Joined: 07-June 08
  • Gender:Male
  • Location:Arcemu

Posted 28 November 2009 - 02:52 PM

who needs battlemasters when you can que from anywhere?

View PostHasbro, on 14 June 2009 - 01:07 PM, said:

I'm a flaming homosexual.
Do not advertise here by the way.

Posted Image
Posted Image

#10 User is offline   serialnode 

  • Member
  • Pip
  • Group: Members
  • Posts: 29
  • Joined: 24-October 08
  • Gender:Male

Posted 28 November 2009 - 11:48 PM

View PostTerrorblade, on 28 November 2009 - 02:52 PM, said:

who needs battlemasters when you  can que from anywhere?

 the noobs that dont know about the queue from anywhere thingy
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users