[Guide]Automatic deletion of inactive characters NOTE: Characters not Account

[Ultimate Ran]

add this table under RanGame1

Column Name: LastLoginDate
Data Type: datetime
Allow Nulls: Yes

Next is to create this trigger, make a new query and paste this script:

USE [RanGame1]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[Delete_Char] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].LastLoginDate = GETDATE()
From inserted
Where Inserted.ChaOnline = 1
and Inserted.ChaNum = [ChaInfo].ChaNum

Delete from [ChaInfo]
Where DATEDIFF(day,[ChaInfo].LastLoginDate,GETDATE()) >= 30 -----You can change this to number of days you want

END

if you have an existing trigger in rangame1 under chainfo.. then insert only this script before END

Update [ChaInfo] set [ChaInfo].LastLoginDate = GETDATE()
From inserted
Where Inserted.ChaOnline = 1
and Inserted.ChaNum = [ChaInfo].ChaNum

Delete from [ChaInfo]
Where DATEDIFF(day,[ChaInfo].LastLoginDate,GETDATE()) >= 30 -----You can change this to number of days you want

i've just added some of this existing script found in ragezone.. tnx

 

[GMvincent]

Re: [Share]Automatic deletion of inactive characters NOTE: Characters not Account

i should try this one. ^_^ BTW. thanks for the share bro.. ^_^

 

[Jolin88]

Re: [Share]Automatic deletion of inactive characters NOTE: Characters not Account

You made a big mistake, that would only delete anybody after EVERY player of your server didn't play for 30 days because it sets the lastlogindate on EVERY CHAR to getdate as soon as 1 player is online

change this :
Update [ChaInfo] set [ChaInfo].LastLoginDate = GETDATE()
From inserted
Where Inserted.ChaOnline = 1

into this :

Update [ChaInfo] set [ChaInfo].LastLoginDate = GETDATE()
From inserted
Where Inserted.ChaOnline = 1
and Inserted.chanum = [chainfo].chanum

 

[Ultimate Ran]

Re: [Share]Automatic deletion of inactive characters NOTE: Characters not Account

You made a big mistake, that would only delete anybody after EVERY player of your server didn't play for 30 days because it sets the lastlogindate on EVERY CHAR to getdate as soon as 1 player is online

change this :
Update [ChaInfo] set [ChaInfo].LastLoginDate = GETDATE()
From inserted
Where Inserted.ChaOnline = 1

into this :

Update [ChaInfo] set [ChaInfo].LastLoginDate = GETDATE()
From inserted
Where Inserted.ChaOnline = 1
and Inserted.chanum = [chainfo].chanum

tnx for the correction sir.. sorry for that.. guide updated.. tnx again

 

[smarkies]

Re: [Share]Automatic deletion of inactive characters NOTE: Characters not Account

Waiting for confirmation before it gets to sticky thread.

 

[deadkid03]

Re: [Share]Automatic deletion of inactive characters NOTE: Characters not Account

well thanks ultimate and jolin it worked perfectly with my server but i set the day for 1 day and change my server time but really it's working.. keep it up

 

[Ultimate Ran]

Re: [Share]Automatic deletion of inactive characters NOTE: Characters not Account

well thanks ultimate and jolin it worked perfectly with my server but i set the day for 1 day and change my server time but really it's working.. keep it up

yes that's the way to test it.. and observe it by putting ChaOnline=1 observe that LastLoginDate change.. tnx for the try..

 

[nattapon]

Thank you