What's the initial value for realmd.realmlist table?

[joshbloche]

There's no data for realmd.realmlist table in current database version(mangostwo).

or can you tell me what's the value for realmd.realmlist.realmbuilds? 

 

I've tried to use '12340' or '', but while i came into The Dark Portal to Hellfire, it's told me that : you must have The Burning Crusade expansion installed to access this area.

while my client is 3.3.5a(12340). also i cann't create dk character.

[onixiya]

did you set the expansion thing in the account when making it?

[joshbloche]

5 minutes ago, onixiya said:

did you set the expansion thing in the account when making it?

How to set it ? I have just created my first count on mangosd.exe console with comand simply without doing anything more.

[joshbloche]

8 minutes ago, onixiya said:

did you set the expansion thing in the account when making it?

should i set realmd.account.expansion=2? current default value is 0.

[onixiya]

account create name password 2

type that command in the mangosd console and try testing it out

[joshbloche]

Just now, onixiya said:

ype that command in the mangosd console and try testing it out

 

4 minutes ago, onixiya said:

account create name password 2

type that command in the mangosd console and try testing it out

Fail with nothing output.  And no new-created name in the realmd.account table. 

[onixiya]

how did you make a account then if account create didn't work?

[joshbloche]

3 minutes ago, onixiya said:

how did you make a account then if account create didn't work?

My fault. Now can work with your command.  And It's equivalent to "update realmd.account set expansion=2 where id=MY_ACCOUNT_ID"

Last time maybe i'm trying to enter The Dark Portal and both mangosd-server/wow-client are stuck there.

 

however, I still cant be transport to Hellfire. (server is " Mangos Two Server 0.21.GitHub").  Anything else to be set?

[onixiya]

thats a old version, build from source to get the new stuff and bug fixes

[joshbloche]

Just now, onixiya said:

thats a old version, build from source to get the new stuff and bug fixes

ok, Thanks,

I'll try to compile from source  later.

[joshbloche]

6 minutes ago, onixiya said:

thats a old version, build from source to get the new stuff and bug fixes

And still, what's the value for realmlist.realmbuilds? '' or '12340' or else?

new compile one should still be empty too, cause there's no data initialize sql for realmd.realmlist.

[onixiya]

its whatever client version you need, i don't believe you need to set it tho

[antz]

If you use the windows database to load the database and leave option 'L' as Yes, there is an additional script which is run:

 

The SQL script is located in:

https://github.com/mangostwo/database/blob/master/Tools/updateRealm.sql

I believe the linux load database scripts are missing a call to this vital file

[antz]

As has been said before, setting the Expansion column also dictates which expansion you can select:

Please see the Wiki article:

realmbuilds

[joshbloche]

2 minutes ago, antz said:

If you use the windows database to load the database and leave option 'L' as Yes, there is an additional script which is run:

 

The SQL script is located in:

https://github.com/mangostwo/database/blob/master/Tools/updateRealm.sql

I believe the linux load database scripts are missing a call to this vital file

Get it, Thanks.