Mobs with capitalized names

[tegstewart]

DOL checks for capital letters in names to determine if a given mob is a character or not. We have some mobs in the DB which aren't characters and shouldn't have uppercase letters in their names. Here's a query to pull them out, along with their coords and count.

SELECT Mob.Name AS Name,Mob.X AS X,Mob.Y AS Y,Mob.Z AS Z,Mob.Mob_ID AS Mob_ID,COUNT(0) AS cnt
FROM Mob GROUP BY Mob.Name HAVING (COUNT(0) > 1) && BINARY Mob.Name <> BINARY LOWER(Mob.Name) ORDER BY cnt DESC;

Some of these, like Afrits, are epic encounters so the capitalization makes sense, others are characters being duplicated correctly (ie one in each realm's TOA zones), while others are characters that shouldn't be duplicated and a lot of the high count mobs shouldn't have their names capitalized.

[LRFalk01]

What does it mean to be a character?

[tegstewart]

I know it's used by loot generators, but might be used elsewhere as well. Things like more dragon scales drop and the like.

[tegstewart]

It's also one of the things charm spell handlers check. Anything with a cap in it's name can't be charmed.

Of course, most mobs have 0 bodytype which means they can't be charmed anyway, but we should fix it regardless for when somebody decides to tackle that. :-p