Auto Unban Script

[akeness]

Hi,

I have a ban date and I want to know how to create a trigger that checks the ban date... (which store procedure I will add my code to check)

Appreciating any help.

Thanks ahead.

[beetols]

how to? I can just say u that can add a control on usp_GameLogin_taiwan with a if that check if the ban time is finished before continue, restore the Status and continue to select server or just stop if isn't already expired. of course both time must be same, and i'm not sure how a date will check on a if by SQL, so can be that u need to convert the date before make the control.
good luck about

[sgt_trigger17]

just wonder how to also

[JujiPoli]

I think they asked for help not for speak!

Personaly If I open my login taiwan, you can see blockuser check, just read it, understand it and make it how you want.

 Spoiler

-- BlockUser Check
IF(@Status=-10)
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE @Enddate varchar(max)
SELECT @EndDate = EndDate FROM Check_Ban WHERE UserUID = @UserUID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( @Enddate <= @LoginTime )
BEGIN
SET @Status = 0
UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
DELETE FROM Check_Ban Where UserUID = @UserUID
END
END
END

I wrote this line with help of a friend since I needed an auto unban script. Check_Ban is a new table, and enddate is a colum on the table, use your own table!
You can change status to -5 or other, like you want!

[SkuulCandy]

Originally Posted by JujiPoli

I think they asked for help not for speak!

Personaly If I open my login taiwan, you can see blockuser check, just read it, understand it and make it how you want.

 Spoiler

-- BlockUser Check
IF(@Status=-10)
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE @Enddate varchar(max)
SELECT @EndDate = EndDate FROM Check_Ban WHERE UserUID = @UserUID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( @Enddate <= @LoginTime )
BEGIN
SET @Status = 0
UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
DELETE FROM Check_Ban Where UserUID = @UserUID
END
END
END

I wrote this line with help of a friend since I needed an auto unban script. Check_Ban is a new table, and enddate is a colum on the table, use your own table!
You can change status to -5 or other, like you want!

Thanks you!