The Most Important Querry

[Wizatek]

ooops ...for the ones that you set with zeros that u find that are eather too strong or what ever use these to fine tune what ever npc you find 

-- update a single Npc just change the number on the end to match,
-- a_index 0 would be the Number,
-- Werewolf is a_index 1 ...to update just that one change 0 to 1.
UPDATE t_npc SET a_hit = a_hit - 10 WHERE a_index = 0;
UPDATE t_npc SET a_attack = a_attack / 3 WHERE a_index = 0;
UPDATE t_npc SET a_attacklevel = a_attacklevel / 2 WHERE a_index = 0;
UPDATE t_npc SET a_attackSpeed = a_attackSpeed / 2 WHERE a_index = 0;
UPDATE t_npc SET a_magic = a_magic / 2 WHERE a_index = 0;Jane

 

 

UPDATE
t_npc
SET
a_hit = a_hit - 10,
a_attack = a_attack / 3,
a_attacklevel = a_attacklevel / 2,
a_attackSpeed = a_attackSpeed / 2,
a_magic = a_magic / 2
WHERE
a_index = 0;

Your mysql server would probably like u more if u would edit the data from the same record in 1 query