I was try to repair my problem about Certain Point player always decrease when login with this query
Can someone help me how to reslove that problem.
Thanks
But after that my zone server error and cant running with respond at pic.USE [RF_WORLD_NOVUS]
GO
/** Object: Trigger [LastConnTime] Script Date: 05/01/2010 00:13:05 **/
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE TRIGGER [LastConnTime] ON [dbo].[tbl_base]
FOR UPDATE
AS
SET NOCOUNT ON;
IF UPDATE (LastConnTime)
BEGIN
update
[dbo].[tbl_base]
set LastConnTime = LastConnTime + 1200000000 where LastConnTime < 1200000000
END
Can someone help me how to reslove that problem.
Thanks