I noticed an odd thing about some NPC's
 

Running on Akka's Installer
Running around as a low level. I found myself wandering bored, thinking of what to test.

I decided to start randomly attacking people.
Eventually i found a red npc that i was able to hit. and hit. and hit.
For some reason he was missing me. I'm only level 8!

I decided to log in my GM account.

#showstats
Level 61
192 str
compute_tohit: 7
compute_defense: 33



I have only noticed this in starter zones, but this is reoccurring through many of them. There are dozens of NPC's like this. I wont post specific NPC's because they are all over the place.

This explains why my level 8 could get off 10-20 hits before it was even able to hit me.
---------------------------------------------------------
Now that i know about it. What can i do about it?
I attempted to go into the database, find their stats, and update them. Sadly there wasn't a compute_tohit cell. I increased attack speed and strength, but this did not change thier compute_tohit.

If anyone has any advice i would love to hear it. I wouldn't mind manually updating each one(i'm sure there are a few hundred). As long as i could figure out how to update the chance to hit.

Thanks for listening!

Well without NPCs listed, we can't check.

Bartle_Barnick 19043
Uner_Gnarltrunk 19053
Fento_Jalla 19030
Bodbin_Gimple 19074
Daleen_Leafsway 19079
Crista_Tagglefoot 19072
Bumpy_Quickfinger 19029
Staria_Longhair 19028
Martyn_Firechaser 38063
Tran_Lilspin 38036
Cyria_Lorewhisper 38069
Xylania_Rainsparkle 38071
Valani_Gadriek 24096
Geoard_BlueHawk 24068
Helia_BlueHawk 24067
Luren_Renthalis 24070
Inkeep_Roster 21061
Inkeep_Seke 21060
Sorsha_Hobbitfriend 21059
Slea_Pinewhisper 21053
Katha_Firespinner 22092
Lyth_Spellstar 22093
Inkeep_Juna 22096

Now that i am exploring the world a bit more. 90% of all non-guard, non-monster NPC's have 7 to hit. (Example: Level 1 rats have 21 to hit*) And many of these NPC's are level 40+
Can I update the compute_hit somewhere?
Would be nice if i could find compute_tohit in the database. Then i could just run a script based on level and tohit, just update them all.

This is because of their skills are super low being a class not in skill caps. compute_tohit is the base accuracy calculation based on skill and accuracy field.

Thanks for the reply demonstar55.

I found the accuracy fields. That probably doesn't need to be touched, as long as i can update the skill field to max them.
I'm unable to locate the skill field for npc_types. Once i can find that i can just do a run a query in HeidiSQL and update them all by level brackets.

>>Wait are you saying they need to be set to a different class?

There is no skill fields. This is something we need to implement though.

Is there any way i can update them? manual or otherwise? Or should i just overcompensate the lack of stats with the accuracy stat?

UPDATE: Attempting to #npcedit i can't give them attack or accuracy. Probably user error. It would take a few weeks to go through the thousands of NPC's with this bug though, so maybe i should wait for a fix.