ArcEmu: [fix] Training Dummy Npc - 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

[fix] Training Dummy Npc They will no longer attack

#1 User is offline   Akamaran 

  • Member
  • Pip
  • Group: Members
  • Posts: 56
  • Joined: 26-August 08
  • Gender:Male
  • Location:Canada

Posted 13 August 2010 - 02:44 PM

[Fix] Training Dummy NPC
They will no longer attack

Have some of you probably noticed some of the training dummies attack the players back, Here is a fix for that following issue.

UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '4952';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32547';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32541';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32545';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32667';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '33229';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '19139';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '16211';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '25225';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '18504';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '30527';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '5652';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '1921';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '24792';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32542';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '25297';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32546';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32666';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '31144';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '17059';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '17060';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '17578';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '31146';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '32543';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '5723';
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '2674'; 
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '12426'; 
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '12385'; 
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '11875'; 
UPDATE creature_proto SET istrainingdummy = '1' WHERE entry = '2673';

0

#2 User is offline   Dzjhenghiz 

  • حشّاشين
  • Group: Contributor
  • Posts: 1,936
  • Joined: 07-June 08
  • Gender:Male
  • Location:2nd stone after the 3rd oase western sahara
  • Interests:M.C.S.E :- Minesweeper Consultant & Solitaire Expert
  • Server OS:Other

Posted 14 August 2010 - 05:36 AM

depending on what dbase you use, it should be ok in the dbase project :P
Need Help With Arcemu ? ^^
Posted Image
Concordia res parvae crescunt In varietate concordia
Spoiler

0

#3 User is offline   suchASunthan 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 246
  • Joined: 29-November 08
  • Gender:Male
  • Location:Frankfurt
  • Interests:Vcpp, vb, sql, all programmlanguages
    more informations >:-]

Posted 14 August 2010 - 09:25 AM

UPDATE creature_proto SET istrainingdummy = 1 WHERE creature_names.name LIKE %training dummy%;

should be better
Koninzidenz begründet keine Korrelation und ist kein Beweis für Kausalität!

coincidence causes no correlation and in´t a argument for causality!

Posted Image
Posted Image
0

#4 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 14 August 2010 - 12:12 PM

View PostsuchASunthan, on 14 August 2010 - 09:25 AM, said:

UPDATE creature_proto SET istrainingdummy = 1 WHERE creature_names.name LIKE %training dummy%;

should be better

Not really. Not all training dummy NPCs are actual training dummies, and besides that query will look through all records and do a string search on them = slower by a lot.
"The demand for free goods is infinite."
0

#5 User is offline   suchASunthan 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 246
  • Joined: 29-November 08
  • Gender:Male
  • Location:Frankfurt
  • Interests:Vcpp, vb, sql, all programmlanguages
    more informations >:-]

Posted 14 August 2010 - 12:19 PM

mhm ok, was only an idea to improve the search. so it wouldn't neccessary to find the ids. the way of the first post is the blizzlikest one :)
Koninzidenz begründet keine Korrelation und ist kein Beweis für Kausalität!

coincidence causes no correlation and in´t a argument for causality!

Posted Image
Posted Image
0

#6 User is offline   Akamaran 

  • Member
  • Pip
  • Group: Members
  • Posts: 56
  • Joined: 26-August 08
  • Gender:Male
  • Location:Canada

Posted 14 August 2010 - 12:39 PM

If the following gives you any issue feel free to post, I will be glad to assist you
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