BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.4 support => Topic started by: lulifuz on August 25, 2007, 10:53:52 am

Title: database migration when upgrading from 0.2 to 0.4
Post by: lulifuz on August 25, 2007, 10:53:52 am

Hi there,

now that I got BeBot 0.4.1 running I wonder if someone can give me a hint how to get the old database into the new one.
I did not find any post here, but I think this should be of generally interest.

Thanks,

 lulifuz

Title: Re: database migration when upgrading from 0.2 to 0.4
Post by: Ebag333 on August 25, 2007, 06:56:50 pm

There's really not much that needs to be converted.

Basically the only way would be to use a data transformation tool, or simply manually do it yourself. :)

Title: Re: database migration when upgrading from 0.2 to 0.4
Post by: lulifuz on August 26, 2007, 11:54:54 am

Hi again,

ups, sorry, I asked before I looked.
Now I did and found out, that the table structure staid the same for the relevant tables. I assumed there was some change.
So I will do it manually to.
To be sure, I list the tables to be ex/imported here and ask for your confirmation:

0.2.x	0.4.1
alts	alts
logon	<dbname>_logon
news	<dbname>_news
org_city	<dbname>_org_city
raid_points	<dbname>_raid_points
tower_attack	<dbname>_tower_attack
tower_result	<dbname>_tower_result

Hm, where are the guests gone? I assume they go into <db-name>_users with a userlevel of 1.

Thanks allot and regards,

 lulifuz

Title: Re: database migration when upgrading from 0.2 to 0.4
Post by: Alreadythere on August 26, 2007, 12:53:11 pm

Yes, guests and members (and all characters on notify) are stored in the users table now. user_level 2 means member, 1 means guest.

Admin groups were changed to the new security system, best is to readd people there though.