[Question]How to change mob HP-Lv ?

[akrep_kral_16]

How to change mob HP-Lv ?

[jockeyrullz]

Wrong section

[IceAmStiel]

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.

[carmenjason]

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

[.iGold]

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

[carmenjason]

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