Jump to content

Maintaince Question - "with release in it"


Recommended Posts

Following Situation with 3,000 Users:
I wanna maintain somenthing and wanna that all players are not able to connect (Server is Online)
only the Team such as "GM's", "Developers", "SA's" can login to the Server and after i maintain it i wanna
have a option to make the server online again for all normal players (over a quest or somenthing)

Have someone a idea how i can make that happen? I hope its not only intressting for me and will be intresting
for others too! (i know about the ability to have a test server but i realy wanna make it like that.) and sorry about my
bad english "sometimes".

Sincerly
Stoopid Meleys

Link to comment
Share on other sites

vor 50 Minuten schrieb tierrilopes:

Just lock the accounts.

3k account, thats less then 2 seconds to update all to lock the account in database and done.

No need to make shitty systems or quests for something that simple.

wow.. (writing my text for nothing "yeah meleys think over it")

I am not seeing that option before in my mind..
you can simply run the command over the mysql command line
awesome you are great thank you for saying me it ! i love you xD
 

Link to comment
Share on other sites

  • Silver
1 hour ago, iMeleys said:

wow.. (writing my text for nothing "yeah meleys think over it")

I am not seeing that option before in my mind..
you can simply run the command over the mysql command line
awesome you are great thank you for saying me it ! i love you xD
 

Just open: root->intrologin.py

#find this
"BLOCK"		: localeInfo.LOGIN_FAILURE_BLOCK_ID,

#and add this after

"MAINTENANCE"	: localeInfo.LOGIN_FAILURE_MAINTENANCE,


and add this into your locale: locale_game.txt
 

LOGIN_FAILURE_MAINTENANCE    Server maintenance is in progress.


Open Navicat press F5 (open Console and RUN this SQL command):

ALTER TABLE account.account MODIFY COLUMN status varchar(11) NOT NULL;

 

Now You must do this SQL command for maintenance:

UPDATE account.account SET status = "MAINTENANCE" WHERE login NOT IN (SELECT mAccount FROM common.gmlist);

AFTER MAINTENANCE RUN THIS SQL:
 

UPDATE account.account SET status = "OK";

aGt0WKF.png

 

Enjoy! ?

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 2
Link to comment
Share on other sites

  • Premium
37 minutes ago, Helia01 said:

Just open: root->intrologin.py


#find this
"BLOCK"		: localeInfo.LOGIN_FAILURE_BLOCK_ID,

#and add this after

"MAINTENANCE"	: localeInfo.LOGIN_FAILURE_MAINTENANCE,


and add this into your locale: locale_game.txt
 


LOGIN_FAILURE_MAINTENANCE    Server maintenance is in progress.


Open Navicat press F5 (open Console and RUN this SQL command):


ALTER TABLE account.account MODIFY COLUMN status varchar(11) NOT NULL;

 

Now You must do this SQL command for maintenance:


UPDATE account.account SET status = "MAINTENANCE" WHERE login NOT IN (SELECT mAccount FROM common.gmlist);

AFTER MAINTENANCE RUN THIS SQL:
 


UPDATE account.account SET status = "OK";

aGt0WKF.png

 

Enjoy! ?

Bad, for "BLOCK" users.

UPDATE account.account SET status = "OK";
Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 1


 

Link to comment
Share on other sites

  • Silver
14 minutes ago, iMeleys said:

you are right.. if i try to block users and make a maintaince
the blocked users will be free again...

Maybe a Solution: Does it give a MYSQL command to ignore the users with the value "BLOCK" ?

UPDATE account.account SET status = "MAINTENANCE" WHERE login NOT IN (SELECT mAccount FROM common.gmlist) AND status NOT LIKE "BLOCK";

 

UPDATE account.account SET status = "OK" WHERE status NOT LIKE "BLOCK";

try this.

  • Love 1
Link to comment
Share on other sites

  • Premium
3 hours ago, iMeleys said:

wow.. (writing my text for nothing "yeah meleys think over it")

I am not seeing that option before in my mind..
you can simply run the command over the mysql command line
awesome you are great thank you for saying me it ! i love you xD
 

ahah wasnt my intention to be mean or something like that, sorry if you understood it that way.

most of time im on phone and i just write fast and send

  • Love 1
Link to comment
Share on other sites

vor 1 Stunde schrieb tierrilopes:

ahah wasnt my intention to be mean or something like that, sorry if you understood it that way.

most of time im on phone and i just write fast and send

i mean it different to myself that im stupid and not thinking enough
over my ideas i would come on this if i think enough but yeah dont worry
about what i write to you buddy it was not your fault !

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / 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.