Jump to content

Access account to one realm


Guest EMTEC_GM
 Share

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use