Jump to content

[SQL] Automatic guild purge


 Share

Recommended Posts

Forum users, hello!
In this tutorial, I want to share with you an SQL query, кwhich will help you clear the guilds from players, who have not entered the game for more than three months. And disband the guild if the chapter in it is left alone and has not entered the game for more than three months.

Implementation:

The deadline for removing players and disbanding the guild can be adjusted in the code,
changing the UNIX value (7776000 seconds - 3 months) to your own.

Actually, the query itself:

Hidden Content

    To view, authorization is required.

If you wish, you can create a task in the SQL Server Agent for execution once every 24 hours.

That's all!
Thanks for attention!

PS: don't forget to like it!
This is motivating! 💪

  • Like 3
  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

Board Life Status


Board startup date: May 27, 2020 20:35:04
×
×
  • Create New...