Bots not following after zoning, definitely my database

[provocating]

Well maybe I can help you out and let you know how it goes. So far so good, Debian 5 loaded....compiling is going okay. Just running all of these patches....I never seem to get it right.

[provocating]

Okay I am back to the pointer error.

[Debug] Member of group 1001 named 'Provocating' had an out of date pointer!!
[Debug] Member of group 1001 named 'Wundred' had an out of date pointer!!

I went back through my notes and I have no idea how I solved it last time.

This is what is working and what is not.

WORKING
Bots have inventory.
All bots converted over from old system.
Bots are now zoning.

NOT WORKING
Bots do not follow after zoning, noticed an out of date pointer error during zone.
Cannot create any new bots, always says the name is in use.

Patches I recently went back through to make sure they are there.

1022_botadventuring.sql
1027_botactives.sql
1030_botzoningsupport.sql
1036_botbuffs.sql
1038_botpetstatepersists.sql
1040_DeprecatedBotRaidsSystems.sql
1077_botgroups.sql still not following

[provocating]

Also I wanted to add I am using r1086 of the source.

I just compiled and added my -DBOTS and bots.o to the makefile / makefile.common and recompiled, all went well but still the bots are not following, cannot create new bots and the out of date pointer error.

[provocating]

Well I thought I had it fixed, false call.....still broken.

[Derision]

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:

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

But the view name is actually mixed case:

CREATE VIEW `vwBotCharacterMobs` AS ...

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

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

and recompiling.

[provocating]

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]

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]

Yeah it fixed my problem too.

Any idea on the bots following thing ?

[prickle]

Originally Posted by provocating

Also I wanted to add I am using r1086 of the source.

I just compiled and added my -DBOTS and bots.o to the makefile / makefile.common and recompiled, all went well but still the bots are not following, cannot create new bots and the out of date pointer error.

Did you also add -DBOTS to your world/makefile file as well?

Sounds like you've got all the necessary sql patches in, but you're bots aren't cooperating properly.

Here are a couple of things that I had to do to get mine working:

.add -DBOTS to BOTH the world/makefile AND the zone/makefile
.add bots.o to zone/makefile.common
.remove the "-g" and "-O" flags from BOTH the world/makefile and the zone/makefile

hope this helps

[provocating]

World makefile section

DFLAGS=-DDEBUG=5 -DBOTS -DEQDEBUG=5 -DSHAREMEM -DCATCH_CRASH -DNO_PIDLOG -DFIELD_ITEMS -DIRC -Di386 -DAPP_OPCODE_SIZE=2

Zone makefile section

DFLAGS=-DEQDEBUG=5 -DBOTS -DCATCH_CRASH -DNO_PIDLOG -DSHAREMEM -DFIELD_ITEMS -DCOMBINED -DAPP_OPCODE_SIZE=2 -Di386
#

Zone makefile.common - Note I think you mean bot.o, not bots.o

 ../common/guild_base.o bot.o \^M

On this part

.remove the "-g" and "-O" flags from BOTH the world/makefile and the zone/makefile

I had never done that before, but I tried it and it did not make any difference. The bots still hang around the entrance of the zone like a bunch of State workers.