I make this query in [usp_Insert_Action_Log_E] but this with query work only first part with Status='251', work only with ActionType='108'. Any idea why?
if (@ActionType='111' and @[Only registered and activated users can see links. Click Here To Register...]='Remake')
Begin
Update PS_userdata.dbo.users_master
Set Status='251'
Where UserUID=@UserUID
if (@@ROWCOUNT=1)
begin
update PS_GameData.dbo.CharItems
Set Type='100',TypeID='1'
where ItemUID in ((select top 9999999 value1 from PS_GameLog.dbo.actionlog
where ActionType = ('111') and Text2 =('remake')))
UPDATE Fail SET Fail = 1;
END
END
if (@ActionType='111' and @[Only registered and activated users can see links. Click Here To Register...]='Remake')
Begin
Update PS_userdata.dbo.users_master
Set Status='251'
Where UserUID=@UserUID
if (@@ROWCOUNT=1)
begin
update PS_GameData.dbo.CharItems
Set Type='100',TypeID='1'
where ItemUID in ((select top 9999999 value1 from PS_GameLog.dbo.actionlog
where ActionType = ('111') and Text2 =('remake')))
UPDATE Fail SET Fail = 1;
END
END