iMeleys 327 Posted July 24, 2019 Share Posted July 24, 2019 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 More sharing options...
Premium tierrilopes 452 Posted July 24, 2019 Premium Share Posted July 24, 2019 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. 2 Link to comment Share on other sites More sharing options...
iMeleys 327 Posted July 24, 2019 Author Share Posted July 24, 2019 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 More sharing options...
Active Member Helia01 2122 Posted July 24, 2019 Active Member Share Posted July 24, 2019 (edited) 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"; Enjoy! Edited August 25, 2022 by Metin2 Dev Core X - External 2 Internal 2 Link to comment Share on other sites More sharing options...
iMeleys 327 Posted July 24, 2019 Author Share Posted July 24, 2019 vor 38 Minuten schrieb Helia01: Enjoy! Wooow that is a greaaaaaaaaat Solution ! *hug you* Thank you very very very much xD EDIT 4 Others: (and no im 24 years old and hugging him yes who doesnt love hugs? xD) 1 Link to comment Share on other sites More sharing options...
Premium TAUMP 825 Posted July 24, 2019 Premium Share Posted July 24, 2019 (edited) 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"; Enjoy! Bad, for "BLOCK" users. UPDATE account.account SET status = "OK"; Edited August 25, 2022 by Metin2 Dev Core X - External 2 Internal 1 Link to comment Share on other sites More sharing options...
iMeleys 327 Posted July 24, 2019 Author Share Posted July 24, 2019 Question/Solution - Does it give a MYSQL command to ignore the users with the value "BLOCK" ? Link to comment Share on other sites More sharing options...
Active Member Helia01 2122 Posted July 24, 2019 Active Member Share Posted July 24, 2019 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. 1 Link to comment Share on other sites More sharing options...
iMeleys 327 Posted July 24, 2019 Author Share Posted July 24, 2019 i solve my stupid mysql error by myself thank you very much for the mysql command it was the solution to the problem that we have @Helia01 ! 1 Link to comment Share on other sites More sharing options...
Premium tierrilopes 452 Posted July 24, 2019 Premium Share Posted July 24, 2019 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 1 Link to comment Share on other sites More sharing options...
iMeleys 327 Posted July 24, 2019 Author Share Posted July 24, 2019 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 More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now