[Question]How to change mob HP-Lv ?

03/08/2012 09:45 akrep_kral_16#1

How to change mob HP-Lv ?:mad:

03/08/2012 10:54 jockeyrullz#2

Wrong section :mofo:

03/09/2012 20:44 IceAmStiel#3

PHP Code:


			
SELECT rchar.ID, ref.CodeName128, rchar.MaxHP, rchar.Lvl 
FROM _RefObjCommon as ref
JOIN _RefObjChar as rchar on ref.Link = rchar.ID
WHERE ref.CodeName128 like '%MOB%'
ORDER BY rchar.ID asc

use the Update + Set statement and add your desired requirements to the WHERE clause - however you want.

08/05/2013 00:59 carmenjason#4

Quote:

UPDATE _RefObjChar
SET Lvl = 20,
MaxHP = 598720 -->...just an example etc.
FROM _RefObjChar as objchar
JOIN _RefObjCommon as ref on objchar.ID = ref.Link
WHERE ref.CodeName128 like 'MOB_CH_TIGERWOMAN'

change MOB_CH_TIGERWOMAN
change SET Lvl = 20,
MaxHP = 598720

08/05/2013 02:04 .iGold#5

Why would you bump 1 year old thread? ._.

08/05/2013 13:32 carmenjason#6

didn't notice the date .. just wanted to help .. not a crime