ok here iS a Fix
UPDATE `l2jdb`.`npc` SET `str` = '50', `con` = '60', `men` = '60', `patk` = '99999', `pdef` = '99999',
`mdef` = '99999', `atkspd` = '999', `runspd` = '500', 'HP' = '99999' WHERE `npc`.`type` = 'L2Guard' ;
this isn't for l2jacrhid OMG guyz wake up :D
code says UPDATE 'l2jarchid_db' you just change the db where u want to make the update