[Release] Never ending 30 day items

[Mark.Teal1982]

Just another small release for those who have been looking for it

 Spoiler

USE [PS_GameData]
GO

Create trigger [dbo].[30DayItems] on [PS_gameData].[dbo].[chars]
after Update
as
if (update(JoinDate))
begin
declare
@CharID INT

set @charid = (select charid from inserted)

UPDATE PS_GameData.dbo.CharApplySkills
set LeftResetTime = 2592000
WHERE CHARID = @CHARID AND SkillID = 225

UPDATE PS_GameData.dbo.CharApplySkills
set LeftResetTime = 2592000
WHERE CHARID = @CHARID AND SkillID = 227

UPDATE PS_GameData.dbo.CharApplySkills
set LeftResetTime = 2592000
WHERE CHARID = @CHARID AND SkillID = 233

UPDATE PS_GameData.dbo.CharApplySkills
set LeftResetTime = 2592000
WHERE CHARID = @CHARID AND SkillID = 286
END

what this does is everytime a user char is logout and back in it resets the 30 day items I listed so they never end unless a char isn't logged in at all for 30 days or so

please note: if this is not working for you check the skill ids to the skill ids of your current 30 day items

[SkuulCandy]

Thanks, but that´s exist ..

[AxelMac]

working only for who has 30 day, add set skillid=**

[[Alcatraz]]

this release was only for the never ending part there was already a release for the new chars to add the skillid in the table by someone else I didn't want to release someone elses work that's why I didn't add it

[[ADM]TW]

How can I cancel the 30-day never ending?