Access account to one realm

[EMTEC_GM]

Hi all.

I wrote a patch for their needs. It involves monitoring the access to appropriate realm.

If there is no entry in the database, your account may go into all the realms.

If it is, the account can access only the specified realm.

The first version of the patch:

http://gist.github.com/228722

+ sql

CREATE TABLE IF NOT EXISTS `account_access` (
 `acc_id` int(11) NOT NULL,
 `realm_id` int(11) NOT NULL,
 UNIQUE KEY `acc_id` (`acc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

With more people online, Mysql or mangos fell.

2009-11-07 12:16:37 ERROR:query ERROR: MySQL server has gone away
2009-11-07 12:16:37 ERROR:WorldSocket::HandleAuthSession: Sent Auth Response (unknown account).
2009-11-07 12:16:39 ERROR:SQL: SELECT id, gmlevel, sessionkey, last_ip, locked, v, s, expansion, mutetime, locale FROM account WHERE username = '******'
2009-11-07 12:16:39 ERROR:query ERROR: MySQL server has gone away
2009-11-07 12:16:39 ERROR:WorldSocket::HandleAuthSession: Sent Auth Response (unknown account).
2009-11-07 12:16:57 ERROR:SQL: SELECT id, gmlevel, sessionkey, last_ip, locked, v, s, expansion, mutetime, locale FROM account WHERE username = '******'
2009-11-07 12:16:57 ERROR:query ERROR: MySQL server has gone away 

I created two versions of the patch

http://gist.github.com/228723

I do not know whether this is a reasonable solution, and that the second version is correct.

I mean, that separate accounts have access only one realm.

I have two realm:

1. 3.1.3

2. 3.2.2a PTR

* Is a common database "realmd"

I want to give some access to the accounts of the PTR expasion 2, but they can not go to 3.1.3

If someone does not understand it sorry in advance.

Thank you for your suggestions.

[EMTEC_GM]

I apologize for the problem.

After removal of patches, then the problems were.

SQL server was corrupted, probably not was doing.

I updated all the packages is on Linux.

Mangos far works without the patch, and it is good.

For some time checked with the second version of the patch.

Regards.