Jump to content
  • 0
Sign in to follow this  
hadie

How to freeze all current account for 2weeks?

Question

Hi all 

It possible to freeze all current account for 2 weeks?because i need do reopen back server without wipe out all old account

I mean like this freeze account from 2000002 to 2000343 example and account 2000344 new register can be login...but after 2weeks old account can be use as usual

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 2
4 hours ago, hadie said:

Hi all 

It possible to freeze all current account for 2 weeks?because i need do reopen back server without wipe out all old account

I mean like this freeze account from 2000002 to 2000343 example and account 2000344 new register can be login...but after 2weeks old account can be use as usual

Use sql query to ban accounts until 20-02-2020 00:00:00

UPDATE `login` SET `unban_time` = '1582146000' WHERE `account_id` >= 2000002 AND `account_id` <= 2000343;

Accounts automaticly unbanned at '1582146000'  (Use UnixTime converter)

  • MVP 1

Share this post


Link to post
Share on other sites
  • -2
 
save the database logs, when you give the date, you return the information to today's file.

Share this post


Link to post
Share on other sites
  • -2
2 hours ago, hadie said:

Hi all 

It possible to freeze all current account for 2 weeks?because i need do reopen back server without wipe out all old account

I mean like this freeze account from 2000002 to 2000343 example and account 2000344 new register can be login...but after 2weeks old account can be use as usual

starting 200002 to 2000343 make it state 5 temporary block, backup your login table as .sql and open it using notepad++ find the state line and find the 2000002 to 2000343 line and change the state to 5

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.