Tbc > Expansion

7 posts

1. Samories
   
   Regular
   Joined: Jul '08
   Posts: 91

   Greetings!

   Im having an issue with the latest realm, I have 3 other realms using the same "account" table ofc. but the column "Tbc" is changed in the later versions of mangos to "Expansion". this issue will fail if I start the 4;e realm since it cant find the "Expansion" column, which is namned "Tbc" as it was before. I cant change the name of that column since then will the 3 other realms wont be able to connect.

   is there a way to change the way mango points at? so instead of point to "expansion" will it point to "Tbc" like the old column in "accounts".?

   Posted 11 months ago » Permalink

2. daggo
   
   Regular
   Joined: May '08
   Posts: 156

   I may not know a solution to this issue, I may have an idea. From what I understand you are using only one realmd table for your realms using "tbc" in the accounts table. The older realmd uses "tbc" and the newer "expansion". correct?
   A possible solution would be to clone your current realmd table and change the data to that one to TBC. Then on the newer mangosd.conf realm, have it point to the newer realmd table (possibly names realmd2).
   That way, your three other realms are still pointed to the older realmd table with the accounts using "TBC" and the newer realm to the realmd2 table with the accounts with "Expansion".
   Just a thought.

   Posted 11 months ago » Permalink

3. Samories
   
   Regular
   Joined: Jul '08
   Posts: 91

   yeah it something like this I was thinking first to,
   but since there is thousands of accounts and hundreds of new every day,
   will it be a problem since when they create a new account the cant see all realm with same account. they will only be able to use same account on one realm or the three others.

   Posted 11 months ago » Permalink

4. daggo
   
   Regular
   Joined: May '08
   Posts: 156

   you are correct in that they will need two seperate accounts in order to have access to the three pre-wotlk and the wotkl. But think of it this way. The majority of players only play using one client version. You can either require your users to 'upgrade' to the newer release ( like blizz does) or you can script a php/SQL script to have individual users transfer characters to the newer realm if they choose to do so through your web server. This is the primary reason why blizz requires everyone to be on the same version, they don't host multiple versions to avoid account conflicts. You may have better luck searching in the db or mangos forums for a solution. Good luck, and if you find a solution please share.

   Posted 11 months ago » Permalink

5. Samories
   
   Regular
   Joined: Jul '08
   Posts: 91

   found a solution now, by adding another column in the account table named "expansion", was it able to work. it skips the "Tbc" and the old realms skip the "expansion" so works great. now I just need to find a way to make all the account have the value "2" in the expansion column, with some kind of page where they can active like with wotlk I did.

   Posted 11 months ago » Permalink

6. daggo
   
   Regular
   Joined: May '08
   Posts: 156

   how would this affect future realm updates? I know usually the update scripts are very strict about the tables they are importing into. Will adding a new column cause an issue? You can alter the update scripts but can be tedious after a while.

   Awesome that you did find a fix!

   Posted 11 months ago » Permalink

7. BmmB
   
   Regular
   Joined: Feb '08
   Posts: 141

   @Samories

   Or you can fix that in mangos source code and compile it on your own.
   But, I guess that's a little bit more of a work than what you did in the first place.

   Best regards...

   Posted 11 months ago » Permalink

RSS feed for this topic

Reply

You must log in to post.