Bots not following after zoning, definitely my database

[prickle]

ok... hmmm... a lot has changed in the sources since this thread was originally posted...

Let me see if I have everything straight...

DOES WORK:
-Rev1052 Windows Binaries W/ NEW database
-Rev1086 Linux SVN compile W/ NEW database

DOES NOT WORK:
-Rev1052 Windows Binaries W/ OLD database that's been patched
-Rev 1086 Linux SVN compile W/ OLD database that's been patched

Is this correct?

[provocating]

That was too long ago for me to remember. I am pretty confident though this is a database problem. The binaries seem to not matter on this issue.

What are you patched up to, what revision ?

[prickle]

I'm currently on Rev 1085. It's working fine for me.

Do you still have the new database available?

I have an idea that may get you up and running with a new database and allow you keep your current player characters and bots.

[provocating]

Well if you meant how I had it up and running before, no sure do not. I wiped and loaded Debian 5. I am so friggin close right now I just backed this guy up and waiting to figure out this last glitch.

[prickle]

Well, here's my idea:

1) Create the new database
2) Source in the necessary files for the new database
3) Configure the server to use the new database
4) Log into the game and verify the bots are working properly

If the bots work the way then you should do the following:
.Log into MySQL (phpMyAdmin or commandline or use whatever database management tool you prefer)
.Access the OLD database
.Export the following tables as flat sql files:

Bot SQL file:
botinventory
bots

Character Data SQL file:
character_
character_activities
character_enabledtasks
character_tasks
inventory

.Access the NEW database
.Import the SQL files you exported above into the new database

Assuming everything works properly with a fresh database the above should achieve your end goal.

Hope this helps

[provocating]

Yeah, yeah kind of working. I have a new DB and now they zone, cast, group, etc. Trying to get my guys over as we speak.

[provocating]

Okay I think I have it all. I also moved the keyring and bot inventory over, took a while to get that going.

Other than the inventory, keyrings, etc....anything else need to be moved for the players ?

[provocating]

Just and FYI for whoever does the bots. On Linux SQL since it is case sensitive it appears the bot code goes lower case but the view is in camel case so.

DROP VIEW IF EXISTS `vwbotgroups`;
CREATE VIEW `vwbotgroups` AS
select g.BotGroupId,
g.BotGroupName,
g.BotGroupLeaderBotId,
b.Name as BotGroupLeaderName,
b.BotOwnerCharacterId,
c.name as BotOwnerCharacterName
from botgroup as g
join bots as b on g.BotGroupLeaderBotId = b.BotID
join character_ as c on b.BotOwnerCharacterID = c.id
order by b.BotOwnerCharacterId, g.BotGroupName;


Is what I had to doctor to make the grouping work.

[prickle]

Originally Posted by provocating

Okay I think I have it all. I also moved the keyring and bot inventory over, took a while to get that going.

Other than the inventory, keyrings, etc....anything else need to be moved for the players ?

hmmmm... if you have multiple people that play on the server you'll want to copy over the following tables as well:

account
account_ip
account_rewards

Possibly the "mail" table as well.

[provocating]

What goes in account_rewards ?

[prickle]

i'm not entirely sure to be honest. Mine is empty. If yours is empty too, then there is no need to import that data into the new database.