[Yafdotnet-cvs] yafsrc/install triggers.sql,1.1.2.2,1.1.2.3

[Jaben C. <ja...@us...>]

Update of /cvsroot/yafdotnet/yafsrc/install
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20603/yafsrc/install

Modified Files:
      Tag: v1_0_2_NETv2
	triggers.sql 
Log Message:
fixed issues with updated registry table being ntext now

Index: triggers.sql
===================================================================
RCS file: /cvsroot/yafdotnet/yafsrc/install/triggers.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -C2 -d -r1.1.2.2 -r1.1.2.3
*** triggers.sql	13 Sep 2006 11:03:27 -0000	1.1.2.2
--- triggers.sql	22 Feb 2007 08:33:52 -0000	1.1.2.3
***************
*** 9,13 ****
  create trigger yaf_Active_insert on dbo.yaf_Active for insert as
  begin
! 	declare @BoardID int, @count int, @max int
  
  	-- Assumes only one row was inserted - shouldn't be a problem?
--- 9,13 ----
  create trigger yaf_Active_insert on dbo.yaf_Active for insert as
  begin
! 	declare @BoardID int, @count int, @max int, @maxStr nvarchar(255), @countStr nvarchar(255), @dtStr nvarchar(255)
  
  	-- Assumes only one row was inserted - shouldn't be a problem?
***************
*** 15,27 ****
  	
  	select @count = count(distinct IP) from yaf_Active with(nolock) where BoardID=@BoardID
! 	select @max = cast(Value as int) from yaf_Registry where BoardID=@BoardID and Name=N'maxusers'
  	if @@rowcount=0
  	begin
! 		insert into yaf_Registry(BoardID,Name,Value) values(@BoardID,N'maxusers',cast(@count as nvarchar))
! 		insert into yaf_Registry(BoardID,Name,Value) values(@BoardID,N'maxuserswhen',convert(nvarchar,getdate(),126))
  	end else if @count>@max
  	begin
! 		update yaf_Registry set Value=cast(@count as nvarchar) where BoardID=@BoardID and Name=N'maxusers'
! 		update yaf_Registry set Value=convert(nvarchar,getdate(),126) where BoardID=@BoardID and Name=N'maxuserswhen'
  	end
  end
--- 15,31 ----
  	
  	select @count = count(distinct IP) from yaf_Active with(nolock) where BoardID=@BoardID
! 	select @maxStr = cast(Value as nvarchar) from yaf_Registry where BoardID=@BoardID and Name=N'maxusers'
! 	select @max = cast(@maxStr as int)
! 	select @countStr = cast(@count as nvarchar)
! 	select @dtStr = convert(nvarchar,getdate(),126)
! 
  	if @@rowcount=0
  	begin
! 		insert into yaf_Registry(BoardID,Name,Value) values(@BoardID,N'maxusers',cast(@countStr as ntext))
! 		insert into yaf_Registry(BoardID,Name,Value) values(@BoardID,N'maxuserswhen',cast(@dtStr as ntext))
  	end else if @count>@max
  	begin
! 		update yaf_Registry set Value=cast(@countStr as ntext) where BoardID=@BoardID and Name=N'maxusers'
! 		update yaf_Registry set Value=cast(@dtStr as ntext) where BoardID=@BoardID and Name=N'maxuserswhen'
  	end
  end