Just another small release for those who have been looking for it
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