[Yafdotnet-cvs] yafsrc/install procedures.sql,1.3.2.10,1.3.2.11

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

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

Modified Files:
      Tag: v1_0_2_NETv2
	procedures.sql 
Log Message:
yaf_Registry fixes

Index: procedures.sql
===================================================================
RCS file: /cvsroot/yafdotnet/yafsrc/install/procedures.sql,v
retrieving revision 1.3.2.10
retrieving revision 1.3.2.11
diff -C2 -d -r1.3.2.10 -r1.3.2.11
*** procedures.sql	8 Feb 2007 00:48:14 -0000	1.3.2.10
--- procedures.sql	12 Mar 2007 10:48:33 -0000	1.3.2.11
***************
*** 918,923 ****
  	declare @UserFlags				int
  
! 	SET @TimeZone = (SELECT CAST(Value as int) FROM yaf_Registry WHERE LOWER(Name) = LOWER('TimeZone'))
! 	SET @ForumEmail = (SELECT Value FROM yaf_Registry WHERE LOWER(Name) = LOWER('ForumEmail'))
  
  	-- yaf_Board
--- 918,923 ----
  	declare @UserFlags				int
  
! 	SET @TimeZone = (SELECT CAST(CAST([Value] as nvarchar(50)) as int) FROM yaf_Registry WHERE LOWER([Name]) = LOWER('TimeZone'))
! 	SET @ForumEmail = (SELECT CAST([Value] as nvarchar(50)) FROM yaf_Registry WHERE LOWER([Name]) = LOWER('ForumEmail'))
  
  	-- yaf_Board
***************
*** 2970,2980 ****
  	@Version		int,
  	@VersionName	nvarchar(50)
! ) as
! begin
! 	EXEC yaf_registry_save 'Version', @Version
  	EXEC yaf_registry_save 'VersionName',@VersionName
- end
- GO
  
  
  CREATE procedure [dbo].[yaf_topic_active](@BoardID int,@UserID int,@Since datetime,@CategoryID int=null) as
--- 2970,2984 ----
  	@Version		int,
  	@VersionName	nvarchar(50)
! ) 
! AS
! BEGIN
! 
! 	DECLARE @tmpValue AS nvarchar(100)
! 	SET @tmpValue = CAST(@Version AS nvarchar(100))
! 	EXEC yaf_registry_save 'Version', @tmpValue
  	EXEC yaf_registry_save 'VersionName',@VersionName
  
+ END
+ GO
  
  CREATE procedure [dbo].[yaf_topic_active](@BoardID int,@UserID int,@Since datetime,@CategoryID int=null) as