Jump to content
  • 0

How to freeze all current account for 2weeks?


hadie

Question


  • Group:  Members
  • Topic Count:  26
  • Topics Per Day:  0.01
  • Content Count:  77
  • Reputation:   1
  • Joined:  03/11/12
  • Last Seen:  

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

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 2

  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  255
  • Reputation:   232
  • Joined:  07/24/13
  • Last Seen:  

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
Link to comment
Share on other sites

  • -2

  • Group:  Members
  • Topic Count:  12
  • Topics Per Day:  0.01
  • Content Count:  233
  • Reputation:   49
  • Joined:  12/20/18
  • Last Seen:  

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

  • -2

  • Group:  Members
  • Topic Count:  58
  • Topics Per Day:  0.01
  • Content Count:  395
  • Reputation:   53
  • Joined:  07/24/12
  • Last Seen:  

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

Link to comment
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.

×
×
  • Create New...