Bots not following after zoning, definitely my database

**Derision** · #1 01-10-2010, 02:44 PM

The issue with getting the 'Bot name is already in use' message may be a case sensitivity thing on Linux.

The query that is being used to check if the name is available is:

Code:

SELECT COUNT(id) FROM vwbotcharactermobs WHERE name LIKE '%s'

But the view name is actually mixed case:

Code:

CREATE VIEW `vwBotCharacterMobs` AS ...

You could try changing the query on line 928 in bot.cpp to:

Code:

SELECT COUNT(id) FROM vwBotCharacterMobs WHERE name LIKE '%s'

and recompiling.

provocating · #2 01-10-2010, 02:53 PM

Thank god that part is over. You are a master at your craft.

Anyone have an idea on the bot following thing ? I can call it a day and maybe even be able to squeeze in play time tonight if I can get this fixed.

**WildcardX** · #3 01-10-2010, 02:53 PM

Derision is correct. I just tried that query under the same version of MySQL but with one running on a windows server and the other on a linux server and to my surprise, the query works fine for MySQL running on Windows, but fails on MySQL running on linux. Looks like I get to look at all the queries now to make sure the case sensitivity matches to the actual SQL create statements.

provocating · #4 01-10-2010, 02:54 PM

Yeah it fixed my problem too.

Any idea on the bots following thing ?

**WildcardX** · #5 01-10-2010, 03:26 PM

I checked all the other bot queries and this one case appears to be the only query that needs to be changed to be case sensitive to its database object. I'll commit this fix later when I am ready to commit some other code I am working on now.