-- Copyright Gavin Joyce - gavinjoyce@gmail.com - www.incremental.ie -- The DotNetKicks source will soon be released as an open source project, please see http://www.dotnetkicks.com/ for more information GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_UserID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_UserID_Paged] ( @UserID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE [UserID] = @UserID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_TagID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_TagID_Paged] ( @TagID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE [TagID] = @TagID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_HostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_HostID_Paged] ( @HostID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, HostID int, UserID int, TotalSubmittedStoryCount smallint, TotalKickedStoryCount smallint, TotalCommentCount smallint, TotalKarma smallint, TotalScore smallint, YearlySubmittedStoryCount smallint, YearlyKickedStoryCount smallint, YearlyCommentCount smallint, YearlyKarma smallint, YearlyScore smallint, MonthlySubmittedStoryCount smallint, MonthlyKickedStoryCount smallint, MonthlyCommentCount smallint, MonthlyKarma smallint, MonthlyTotal smallint, WeeklySubmittedStoryCount smallint, WeeklyKickedStoryCount smallint, WeeklyCommentCount smallint, WeeklyKarma smallint, WeeklyTotal smallint, DailySubmittedStoryCount smallint, DailyKickedStoryCount smallint, DailyCommentCount smallint, DailyKarma smallint, DailyTotal smallint ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT HostID, UserID, TotalSubmittedStoryCount, TotalKickedStoryCount, TotalCommentCount, TotalKarma, TotalScore, YearlySubmittedStoryCount, YearlyKickedStoryCount, YearlyCommentCount, YearlyKarma, YearlyScore, MonthlySubmittedStoryCount, MonthlyKickedStoryCount, MonthlyCommentCount, MonthlyKarma, MonthlyTotal, WeeklySubmittedStoryCount, WeeklyKickedStoryCount, WeeklyCommentCount, WeeklyKarma, WeeklyTotal, DailySubmittedStoryCount, DailyKickedStoryCount, DailyCommentCount, DailyKarma, DailyTotal FROM [Kick_HostUserStatistics] WHERE [HostID] = @HostID IF @@ERROR <> 0 GOTO ErrorHandler SELECT HostID, UserID, TotalSubmittedStoryCount, TotalKickedStoryCount, TotalCommentCount, TotalKarma, TotalScore, YearlySubmittedStoryCount, YearlyKickedStoryCount, YearlyCommentCount, YearlyKarma, YearlyScore, MonthlySubmittedStoryCount, MonthlyKickedStoryCount, MonthlyCommentCount, MonthlyKarma, MonthlyTotal, WeeklySubmittedStoryCount, WeeklyKickedStoryCount, WeeklyCommentCount, WeeklyKarma, WeeklyTotal, DailySubmittedStoryCount, DailyKickedStoryCount, DailyCommentCount, DailyKarma, DailyTotal FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_UserID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_UserID_Paged] ( @UserID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, HostID int, UserID int, TotalSubmittedStoryCount smallint, TotalKickedStoryCount smallint, TotalCommentCount smallint, TotalKarma smallint, TotalScore smallint, YearlySubmittedStoryCount smallint, YearlyKickedStoryCount smallint, YearlyCommentCount smallint, YearlyKarma smallint, YearlyScore smallint, MonthlySubmittedStoryCount smallint, MonthlyKickedStoryCount smallint, MonthlyCommentCount smallint, MonthlyKarma smallint, MonthlyTotal smallint, WeeklySubmittedStoryCount smallint, WeeklyKickedStoryCount smallint, WeeklyCommentCount smallint, WeeklyKarma smallint, WeeklyTotal smallint, DailySubmittedStoryCount smallint, DailyKickedStoryCount smallint, DailyCommentCount smallint, DailyKarma smallint, DailyTotal smallint ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT HostID, UserID, TotalSubmittedStoryCount, TotalKickedStoryCount, TotalCommentCount, TotalKarma, TotalScore, YearlySubmittedStoryCount, YearlyKickedStoryCount, YearlyCommentCount, YearlyKarma, YearlyScore, MonthlySubmittedStoryCount, MonthlyKickedStoryCount, MonthlyCommentCount, MonthlyKarma, MonthlyTotal, WeeklySubmittedStoryCount, WeeklyKickedStoryCount, WeeklyCommentCount, WeeklyKarma, WeeklyTotal, DailySubmittedStoryCount, DailyKickedStoryCount, DailyCommentCount, DailyKarma, DailyTotal FROM [Kick_HostUserStatistics] WHERE [UserID] = @UserID IF @@ERROR <> 0 GOTO ErrorHandler SELECT HostID, UserID, TotalSubmittedStoryCount, TotalKickedStoryCount, TotalCommentCount, TotalKarma, TotalScore, YearlySubmittedStoryCount, YearlyKickedStoryCount, YearlyCommentCount, YearlyKarma, YearlyScore, MonthlySubmittedStoryCount, MonthlyKickedStoryCount, MonthlyCommentCount, MonthlyKarma, MonthlyTotal, WeeklySubmittedStoryCount, WeeklyKickedStoryCount, WeeklyCommentCount, WeeklyKarma, WeeklyTotal, DailySubmittedStoryCount, DailyKickedStoryCount, DailyCommentCount, DailyKarma, DailyTotal FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetCategoriesByHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetCategoriesByHostID_Paged] ( @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, CategoryID smallint, HostID int, CategoryIdentifier nvarchar(50), Name nvarchar(50), Description nvarchar(4000), OrderPriority smallint ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT CategoryID, HostID, CategoryIdentifier, Name, Description, OrderPriority FROM [Kick_Category] WHERE ( ( ([HostID] LIKE @HostID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT CategoryID, HostID, CategoryIdentifier, Name, Description, OrderPriority FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryByIdentifier_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryByIdentifier_Paged] ( @StoryIdentifier_Match nvarchar(255), @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([StoryIdentifier] LIKE @StoryIdentifier_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByUsernameAndHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByUsernameAndHostID_Paged] ( @Username_Match nvarchar(50), @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([Username] LIKE @Username_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_UserHostTag_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_UserHostTag_ByID] ( @UserID int, @HostID int, @TagID int ) AS SELECT [UserID], [HostID], [TagID] FROM [Kick_UserHostTag] WHERE [UserID] = @UserID AND [HostID] = @HostID AND [TagID] = @TagID ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByUsernameKickedStateAndHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByUsernameKickedStateAndHostID_Paged] ( @Username_Match nvarchar(50), @IsKicked_Match bit, @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([Username] LIKE @Username_Match) ) AND ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickStoryAndHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickStoryAndHostID_Paged] ( @IsKickStory_Match bit, @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([IsKickStory] LIKE @IsKickStory_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) Order by PublishedDateTime DESC IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByCategoryKickedStateAndHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByCategoryKickedStateAndHostID_Paged] ( @CategoryID_Match smallint, @IsKicked_Match bit, @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([CategoryID] LIKE @CategoryID_Match) ) AND ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ORDER BY PublishedDateTime DESC IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Categorys_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Categorys_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, CategoryID smallint, HostID int, CategoryIdentifier nvarchar(50), Name nvarchar(50), Description nvarchar(4000), OrderPriority smallint ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT CategoryID, HostID, CategoryIdentifier, Name, Description, OrderPriority FROM [Kick_Category] IF @@ERROR <> 0 GOTO ErrorHandler SELECT CategoryID, HostID, CategoryIdentifier, Name, Description, OrderPriority FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickedHostIDAndPostedDateTime_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickedHostIDAndPostedDateTime_Paged] ( @IsKicked_Match bit, @HostID_Match int, @PostedDateTime_Upper datetime, @PostedDateTime_Lower datetime, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) AND ( ([PostedDateTime] >= @PostedDateTime_Lower) AND ([PostedDateTime] <= @PostedDateTime_Upper) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickedAndHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickedAndHostID_Paged] ( @IsKicked_Match bit, @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) Order by PublishedDateTime DESC IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Comments_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Comments_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, CommentID int, StoryID int, UserID int, Username nvarchar(50), Comment nvarchar(4000), PostedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT CommentID, StoryID, UserID, Username, Comment, PostedDateTime FROM [Kick_Comment] IF @@ERROR <> 0 GOTO ErrorHandler SELECT CommentID, StoryID, UserID, Username, Comment, PostedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryByUrl_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryByUrl_Paged] ( @Url_Match nvarchar(1000), @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE ( ( ([Url] LIKE @Url_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryKicksByUserIDAndHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryKicksByUserIDAndHostID_Paged] ( @UserID_Match int, @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, StoryKickID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM [Kick_StoryKick] WHERE ( ( ([UserID] LIKE @UserID_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByHostID_Paged] ( @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE ( ( ([HostID] LIKE @HostID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Hosts_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Hosts_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, HostID int, HostName nvarchar(255), RootUrl nvarchar(50), SiteTitle nvarchar(255), SiteDescription nvarchar(2000), TagLine nvarchar(255), LogoPath nvarchar(255), CreatedDateTime datetime, BlogUrl nvarchar(255), Email nvarchar(255), Skin nvarchar(50), Theme nvarchar(50), ShowAds bit, Culture nvarchar(50), UICulture nvarchar(50), Publish_MinimumStoryAgeInHours smallint, Publish_MaximumStoryAgeInHours smallint, Publish_MaximumSimiltanousStoryPublishCount smallint, Publish_MinimumStoryScore smallint, Publish_MinimumStoryKickCount smallint, Publish_MinimumStoryCommentCount smallint, Publish_MinimumAverageStoryKicksPerHour smallint, Publish_MinimunAverageCommentsPerHour smallint, Publish_MinimumViewCount smallint, Publish_KickScore smallint, Publish_CommentScore smallint, AdsenseID nvarchar(30), TrackingHtml text ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT HostID, HostName, RootUrl, SiteTitle, SiteDescription, TagLine, LogoPath, CreatedDateTime, BlogUrl, Email, Skin, Theme, ShowAds, Culture, UICulture, Publish_MinimumStoryAgeInHours, Publish_MaximumStoryAgeInHours, Publish_MaximumSimiltanousStoryPublishCount, Publish_MinimumStoryScore, Publish_MinimumStoryKickCount, Publish_MinimumStoryCommentCount, Publish_MinimumAverageStoryKicksPerHour, Publish_MinimunAverageCommentsPerHour, Publish_MinimumViewCount, Publish_KickScore, Publish_CommentScore, AdsenseID, TrackingHtml FROM [Kick_Host] IF @@ERROR <> 0 GOTO ErrorHandler SELECT HostID, HostName, RootUrl, SiteTitle, SiteDescription, TagLine, LogoPath, CreatedDateTime, BlogUrl, Email, Skin, Theme, ShowAds, Culture, UICulture, Publish_MinimumStoryAgeInHours, Publish_MaximumStoryAgeInHours, Publish_MaximumSimiltanousStoryPublishCount, Publish_MinimumStoryScore, Publish_MinimumStoryKickCount, Publish_MinimumStoryCommentCount, Publish_MinimumAverageStoryKicksPerHour, Publish_MinimunAverageCommentsPerHour, Publish_MinimumViewCount, Publish_KickScore, Publish_CommentScore, AdsenseID, TrackingHtml FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByUserIDAndHostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByUserIDAndHostID_Paged] ( @UserID_Match int, @HostID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE ( ( ([UserID] LIKE @UserID_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByStoryID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByStoryID_Paged] ( @StoryID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE ( ( ([StoryID] LIKE @StoryID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Storys_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Storys_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByStoryIDAndUserID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByStoryIDAndUserID_Paged] ( @StoryID_Match int, @UserID_Match int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE ( ( ([StoryID] LIKE @StoryID_Match) ) AND ( ([UserID] LIKE @UserID_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByHostIDAndDateRange_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByHostIDAndDateRange_Paged] ( @HostID_Match int, @CreatedDateTime_Upper datetime, @CreatedDateTime_Lower datetime, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE ( ( ([HostID] LIKE @HostID_Match) ) AND ( ([CreatedDateTime] >= @CreatedDateTime_Lower) AND ([CreatedDateTime] <= @CreatedDateTime_Upper) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_StoryKicks_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_StoryKicks_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, StoryKickID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM [Kick_StoryKick] IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetTagByTagIdentifier_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetTagByTagIdentifier_Paged] ( @TagIdentifier_Match nvarchar(40), @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, TagID int, TagIdentifier nvarchar(40) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT TagID, TagIdentifier FROM [Kick_Tag] WHERE ( ( ([TagIdentifier] LIKE @TagIdentifier_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT TagID, TagIdentifier FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByUsername_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByUsername_Paged] ( @Username_Match nvarchar(50), @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, UserID int, Username nvarchar(50), Email nvarchar(255), Password nvarchar(50), PasswordSalt nvarchar(50), IsGeneratedPassword bit, IsValidated bit, IsBanned bit, AdsenseID nvarchar(30), ReceiveEmailNewsletter bit, Roles nvarchar(100), CreatedDateTime datetime, LastActiveDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM [Kick_User] WHERE ( ( ([Username] LIKE @Username_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByEmail_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByEmail_Paged] ( @Email_Match nvarchar(255), @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, UserID int, Username nvarchar(50), Email nvarchar(255), Password nvarchar(50), PasswordSalt nvarchar(50), IsGeneratedPassword bit, IsValidated bit, IsBanned bit, AdsenseID nvarchar(30), ReceiveEmailNewsletter bit, Roles nvarchar(100), CreatedDateTime datetime, LastActiveDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM [Kick_User] WHERE ( ( ([Email] LIKE @Email_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_StoryUserHostTags_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_StoryUserHostTags_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByReceiveEmailNewsletter_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByReceiveEmailNewsletter_Paged] ( @ReceiveEmailNewsletter_Match bit, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, UserID int, Username nvarchar(50), Email nvarchar(255), Password nvarchar(50), PasswordSalt nvarchar(50), IsGeneratedPassword bit, IsValidated bit, IsBanned bit, AdsenseID nvarchar(30), ReceiveEmailNewsletter bit, Roles nvarchar(100), CreatedDateTime datetime, LastActiveDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM [Kick_User] WHERE ( ( ([ReceiveEmailNewsletter] LIKE @ReceiveEmailNewsletter_Match) ) ) IF @@ERROR <> 0 GOTO ErrorHandler SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_UserHostTag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_UserHostTag] ( @UserID int, @HostID int, @TagID int ) AS INSERT INTO [Kick_UserHostTag] ( [UserID], [HostID], [TagID] ) VALUES ( @UserID, @HostID, @TagID ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Tags_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Tags_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, TagID int, TagIdentifier nvarchar(40) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT TagID, TagIdentifier FROM [Kick_Tag] IF @@ERROR <> 0 GOTO ErrorHandler SELECT TagID, TagIdentifier FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_UserHostTag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_UserHostTag] ( @UserID int, @HostID int, @TagID int ) AS DELETE [Kick_UserHostTag] WHERE [UserID] = @UserID AND [HostID] = @HostID AND [TagID] = @TagID ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Users_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Users_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, UserID int, Username nvarchar(50), Email nvarchar(255), Password nvarchar(50), PasswordSalt nvarchar(50), IsGeneratedPassword bit, IsValidated bit, IsBanned bit, AdsenseID nvarchar(30), ReceiveEmailNewsletter bit, Roles nvarchar(100), CreatedDateTime datetime, LastActiveDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM [Kick_User] IF @@ERROR <> 0 GOTO ErrorHandler SELECT UserID, Username, Email, Password, PasswordSalt, IsGeneratedPassword, IsValidated, IsBanned, AdsenseID, ReceiveEmailNewsletter, Roles, CreatedDateTime, LastActiveDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_UserHostTag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_UserHostTag] ( @UserID int, @HostID int, @TagID int ) AS UPDATE [Kick_UserHostTag] SET [UserID] = @UserID, [HostID] = @HostID, [TagID] = @TagID WHERE [UserID] = @UserID AND [HostID] = @HostID AND [TagID] = @TagID ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_HostUserStatisticss_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_HostUserStatisticss_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, HostID int, UserID int, TotalSubmittedStoryCount smallint, TotalKickedStoryCount smallint, TotalCommentCount smallint, TotalKarma smallint, TotalScore smallint, YearlySubmittedStoryCount smallint, YearlyKickedStoryCount smallint, YearlyCommentCount smallint, YearlyKarma smallint, YearlyScore smallint, MonthlySubmittedStoryCount smallint, MonthlyKickedStoryCount smallint, MonthlyCommentCount smallint, MonthlyKarma smallint, MonthlyTotal smallint, WeeklySubmittedStoryCount smallint, WeeklyKickedStoryCount smallint, WeeklyCommentCount smallint, WeeklyKarma smallint, WeeklyTotal smallint, DailySubmittedStoryCount smallint, DailyKickedStoryCount smallint, DailyCommentCount smallint, DailyKarma smallint, DailyTotal smallint ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT HostID, UserID, TotalSubmittedStoryCount, TotalKickedStoryCount, TotalCommentCount, TotalKarma, TotalScore, YearlySubmittedStoryCount, YearlyKickedStoryCount, YearlyCommentCount, YearlyKarma, YearlyScore, MonthlySubmittedStoryCount, MonthlyKickedStoryCount, MonthlyCommentCount, MonthlyKarma, MonthlyTotal, WeeklySubmittedStoryCount, WeeklyKickedStoryCount, WeeklyCommentCount, WeeklyKarma, WeeklyTotal, DailySubmittedStoryCount, DailyKickedStoryCount, DailyCommentCount, DailyKarma, DailyTotal FROM [Kick_HostUserStatistics] IF @@ERROR <> 0 GOTO ErrorHandler SELECT HostID, UserID, TotalSubmittedStoryCount, TotalKickedStoryCount, TotalCommentCount, TotalKarma, TotalScore, YearlySubmittedStoryCount, YearlyKickedStoryCount, YearlyCommentCount, YearlyKarma, YearlyScore, MonthlySubmittedStoryCount, MonthlyKickedStoryCount, MonthlyCommentCount, MonthlyKarma, MonthlyTotal, WeeklySubmittedStoryCount, WeeklyKickedStoryCount, WeeklyCommentCount, WeeklyKarma, WeeklyTotal, DailySubmittedStoryCount, DailyKickedStoryCount, DailyCommentCount, DailyKarma, DailyTotal FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Categorys_ByFK_HostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Categorys_ByFK_HostID_Paged] ( @HostID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, CategoryID smallint, HostID int, CategoryIdentifier nvarchar(50), Name nvarchar(50), Description nvarchar(4000), OrderPriority smallint ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT CategoryID, HostID, CategoryIdentifier, Name, Description, OrderPriority FROM [Kick_Category] WHERE [HostID] = @HostID IF @@ERROR <> 0 GOTO ErrorHandler SELECT CategoryID, HostID, CategoryIdentifier, Name, Description, OrderPriority FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Comments_ByFK_StoryID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Comments_ByFK_StoryID_Paged] ( @StoryID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, CommentID int, StoryID int, UserID int, Username nvarchar(50), Comment nvarchar(4000), PostedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT CommentID, StoryID, UserID, Username, Comment, PostedDateTime FROM [Kick_Comment] WHERE [StoryID] = @StoryID IF @@ERROR <> 0 GOTO ErrorHandler SELECT CommentID, StoryID, UserID, Username, Comment, PostedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_UserHostTags]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_UserHostTags] AS SELECT [UserID], [HostID], [TagID] FROM [Kick_UserHostTag] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Comments_ByFK_UserID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Comments_ByFK_UserID_Paged] ( @UserID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, CommentID int, StoryID int, UserID int, Username nvarchar(50), Comment nvarchar(4000), PostedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT CommentID, StoryID, UserID, Username, Comment, PostedDateTime FROM [Kick_Comment] WHERE [UserID] = @UserID IF @@ERROR <> 0 GOTO ErrorHandler SELECT CommentID, StoryID, UserID, Username, Comment, PostedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_HostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_HostID_Paged] ( @HostID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE [HostID] = @HostID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_UserHostTags_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_UserHostTags_Count] AS SELECT COUNT(*) FROM [Kick_UserHostTag] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_CategoryID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_CategoryID_Paged] ( @CategoryID smallint, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE [CategoryID] = @CategoryID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_UserHostTags_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_UserHostTags_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, UserID int, HostID int, TagID int ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT UserID, HostID, TagID FROM [Kick_UserHostTag] IF @@ERROR <> 0 GOTO ErrorHandler SELECT UserID, HostID, TagID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_UserID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_UserID_Paged] ( @UserID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, HostID int, StoryIdentifier nvarchar(255), Title nvarchar(255), Description nvarchar(4000), Url nvarchar(1000), CategoryID smallint, UserID int, Username nvarchar(50), PostedDateTime datetime, PublishedDateTime datetime, KickCount int, AutoKickCount int, SpamCount int, ViewCount int, CommentCount int, IsKicked bit, IsSpam bit, IsKickStory bit, AdsenseID nvarchar(30) ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM [Kick_Story] WHERE [UserID] = @UserID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, HostID, StoryIdentifier, Title, Description, Url, CategoryID, UserID, Username, PostedDateTime, PublishedDateTime, KickCount, AutoKickCount, SpamCount, ViewCount, CommentCount, IsKicked, IsSpam, IsKickStory, AdsenseID FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryKicks_ByFK_StoryID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryKicks_ByFK_StoryID_Paged] ( @StoryID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, StoryKickID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM [Kick_StoryKick] WHERE [StoryID] = @StoryID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_sysdiagramss_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_sysdiagramss_Paged] ( @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, name sysname, principal_id int, diagram_id int, version int, definition varbinary ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT name, principal_id, diagram_id, version, definition FROM [sysdiagrams] IF @@ERROR <> 0 GOTO ErrorHandler SELECT name, principal_id, diagram_id, version, definition FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryKicks_ByFK_UserID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryKicks_ByFK_UserID_Paged] ( @UserID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, StoryKickID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM [Kick_StoryKick] WHERE [UserID] = @UserID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, StoryKickID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_HostID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_HostID_Paged] ( @HostID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE [HostID] = @HostID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_StoryID_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_StoryID_Paged] ( @StoryID int, @__PageNumber int, @__PageSize int ) AS DECLARE @Start int, @End int BEGIN TRANSACTION GetDataSet SET @Start = (((@__PageNumber - 1) * @__PageSize) + 1) IF @@ERROR <> 0 GOTO ErrorHandler SET @End = (@Start + @__PageSize - 1) IF @@ERROR <> 0 GOTO ErrorHandler CREATE TABLE #TemporaryTable ( Row int IDENTITY(1,1) PRIMARY KEY, StoryID int, UserID int, HostID int, TagID int, CreatedDateTime datetime ) IF @@ERROR <> 0 GOTO ErrorHandler INSERT INTO #TemporaryTable SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM [Kick_StoryUserHostTag] WHERE [StoryID] = @StoryID IF @@ERROR <> 0 GOTO ErrorHandler SELECT StoryID, UserID, HostID, TagID, CreatedDateTime FROM #TemporaryTable WHERE (Row >= @Start) AND (Row <= @End) IF @@ERROR <> 0 GOTO ErrorHandler DROP TABLE #TemporaryTable COMMIT TRANSACTION GetDataSet RETURN 0 ErrorHandler: ROLLBACK TRANSACTION GetDataSet RETURN @@ERROR ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Host]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_Host]( [HostID] [int] IDENTITY(1,1) NOT NULL, [HostName] [nvarchar](255) NOT NULL, [RootUrl] [nvarchar](50) NOT NULL, [SiteTitle] [nvarchar](255) NOT NULL, [SiteDescription] [nvarchar](2000) NOT NULL, [TagLine] [nvarchar](255) NOT NULL, [LogoPath] [nvarchar](255) NOT NULL CONSTRAINT [DF_Kick_Host_LogoPath] DEFAULT (''), [CreatedDateTime] [datetime] NOT NULL CONSTRAINT [DF_Kick_Host_CreatedDateTime] DEFAULT (getdate()), [BlogUrl] [nvarchar](255) NOT NULL, [Email] [nvarchar](255) NOT NULL, [Skin] [nvarchar](50) NOT NULL, [Theme] [nvarchar](50) NOT NULL, [ShowAds] [bit] NOT NULL, [Culture] [nvarchar](50) NOT NULL, [UICulture] [nvarchar](50) NOT NULL, [Publish_MinimumStoryAgeInHours] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_MinimumStoryAgeInHours] DEFAULT ((0)), [Publish_MaximumStoryAgeInHours] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MaximumStoryAgeInHours] DEFAULT ((48)), [Publish_MaximumSimiltanousStoryPublishCount] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MaximumSimiltanousStoryPublishCount] DEFAULT ((1)), [Publish_MinimumStoryScore] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MinimumStoryScore] DEFAULT ((50)), [Publish_MinimumStoryKickCount] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MinimumStoryKickCount] DEFAULT ((5)), [Publish_MinimumStoryCommentCount] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MinimumStoryCommentCount] DEFAULT ((0)), [Publish_MinimumAverageStoryKicksPerHour] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MinimumAverageStoryKicksPerHour] DEFAULT ((0)), [Publish_MinimunAverageCommentsPerHour] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MinimunAverageCommentsPerHour] DEFAULT ((0)), [Publish_MinimumViewCount] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_MinimumViewCount] DEFAULT ((0)), [Publish_KickScore] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_KickScore] DEFAULT ((5)), [Publish_CommentScore] [smallint] NOT NULL CONSTRAINT [DF_Kick_Host_Publish_CommentScore] DEFAULT ((2)), [AdsenseID] [nvarchar](30) NOT NULL CONSTRAINT [DF_Kick_Host_AdsenseID] DEFAULT (''), [TrackingHtml] [text] NOT NULL CONSTRAINT [DF_Kick_Host_TrackingHtml] DEFAULT (''), CONSTRAINT [PK_Kick_Host] PRIMARY KEY CLUSTERED ( [HostID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_User]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_User]( [UserID] [int] IDENTITY(1,1) NOT NULL, [Username] [nvarchar](50) NOT NULL, [Email] [nvarchar](255) NOT NULL, [Password] [nvarchar](50) NOT NULL, [PasswordSalt] [nvarchar](50) NOT NULL, [IsGeneratedPassword] [bit] NOT NULL CONSTRAINT [DF_Kick_User_IsGeneratedPassword] DEFAULT ((1)), [IsValidated] [bit] NOT NULL, [IsBanned] [bit] NOT NULL, [AdsenseID] [nvarchar](30) NOT NULL CONSTRAINT [DF_Kick_User_AdsenseID] DEFAULT (''), [ReceiveEmailNewsletter] [bit] NOT NULL CONSTRAINT [DF_Kick_User_ReceiveEmailNewsletter] DEFAULT ((1)), [Roles] [nvarchar](100) NOT NULL, [CreatedDateTime] [datetime] NOT NULL, [LastActiveDateTime] [datetime] NOT NULL, CONSTRAINT [PK_Kick_User] PRIMARY KEY CLUSTERED ( [UserID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Kick_User]') AND name = N'Unique_Email') CREATE UNIQUE NONCLUSTERED INDEX [Unique_Email] ON [dbo].[Kick_User] ( [Email] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] GO IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Kick_User]') AND name = N'Unique_Username') CREATE UNIQUE NONCLUSTERED INDEX [Unique_Username] ON [dbo].[Kick_User] ( [Username] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Tag]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_Tag]( [TagID] [int] IDENTITY(1,1) NOT NULL, [TagIdentifier] [nvarchar](40) NOT NULL, CONSTRAINT [PK_Kick_Tag] PRIMARY KEY CLUSTERED ( [TagID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_StoryUserHostTag]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_StoryUserHostTag]( [StoryID] [int] NOT NULL, [UserID] [int] NOT NULL, [HostID] [int] NOT NULL, [TagID] [int] NOT NULL, [CreatedDateTime] [datetime] NOT NULL, CONSTRAINT [PK_Kick_StoryUserTag] PRIMARY KEY CLUSTERED ( [StoryID] ASC, [UserID] ASC, [HostID] ASC, [TagID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Comment]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_Comment]( [CommentID] [int] IDENTITY(1,1) NOT NULL, [StoryID] [int] NOT NULL, [UserID] [int] NOT NULL, [Username] [nvarchar](50) NOT NULL, [Comment] [nvarchar](4000) NOT NULL, [PostedDateTime] [datetime] NOT NULL, CONSTRAINT [PK_Comment] PRIMARY KEY CLUSTERED ( [CommentID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_StoryKick]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_StoryKick]( [StoryID] [int] NOT NULL, [UserID] [int] NOT NULL, [HostID] [int] NOT NULL CONSTRAINT [DF_Kick_StoryKick_HostID] DEFAULT ((2)), [StoryKickID] [int] IDENTITY(1,1) NOT NULL, [CreatedDateTime] [datetime] NOT NULL CONSTRAINT [DF_Kick_StoryKick_CreatedDateTime] DEFAULT (((1)/(1))/(2000)), CONSTRAINT [PK_Kick_StoryKick_1] PRIMARY KEY CLUSTERED ( [StoryID] ASC, [UserID] ASC, [HostID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Story]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_Story]( [StoryID] [int] IDENTITY(1,1) NOT NULL, [HostID] [int] NOT NULL, [StoryIdentifier] [nvarchar](255) NOT NULL, [Title] [nvarchar](255) NOT NULL, [Description] [nvarchar](4000) NOT NULL, [Url] [nvarchar](1000) NOT NULL, [CategoryID] [smallint] NOT NULL, [UserID] [int] NOT NULL CONSTRAINT [DF_Kick_Story_UserID] DEFAULT ((1)), [Username] [nvarchar](50) NOT NULL, [PostedDateTime] [datetime] NOT NULL, [PublishedDateTime] [datetime] NOT NULL, [KickCount] [int] NOT NULL, [AutoKickCount] [int] NOT NULL CONSTRAINT [DF_Kick_Story_AutoKickCount] DEFAULT ((0)), [SpamCount] [int] NOT NULL, [ViewCount] [int] NOT NULL, [CommentCount] [int] NOT NULL, [IsKicked] [bit] NOT NULL, [IsSpam] [bit] NOT NULL, [IsKickStory] [bit] NOT NULL CONSTRAINT [DF_Kick_Story_IsKickStory] DEFAULT ((0)), [AdsenseID] [nvarchar](30) NOT NULL CONSTRAINT [DF_Kick_Story_AdsenseID] DEFAULT (''), CONSTRAINT [PK_Kick_Story] PRIMARY KEY CLUSTERED ( [StoryID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Category]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_Category]( [CategoryID] [smallint] IDENTITY(1,1) NOT NULL, [HostID] [int] NOT NULL, [CategoryIdentifier] [nvarchar](50) NOT NULL, [Name] [nvarchar](50) NOT NULL, [Description] [nvarchar](4000) NOT NULL, [OrderPriority] [smallint] NOT NULL CONSTRAINT [DF_Kick_Category_OrderPriority] DEFAULT (100), CONSTRAINT [PK_Kick_Category] PRIMARY KEY CLUSTERED ( [CategoryID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_HostUserStatistics]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Kick_HostUserStatistics]( [HostID] [int] NOT NULL, [UserID] [int] NOT NULL, [TotalSubmittedStoryCount] [smallint] NOT NULL, [TotalKickedStoryCount] [smallint] NOT NULL, [TotalCommentCount] [smallint] NOT NULL, [TotalKarma] [smallint] NOT NULL, [TotalScore] [smallint] NOT NULL, [YearlySubmittedStoryCount] [smallint] NOT NULL, [YearlyKickedStoryCount] [smallint] NOT NULL, [YearlyCommentCount] [smallint] NOT NULL, [YearlyKarma] [smallint] NOT NULL, [YearlyScore] [smallint] NOT NULL, [MonthlySubmittedStoryCount] [smallint] NOT NULL, [MonthlyKickedStoryCount] [smallint] NOT NULL, [MonthlyCommentCount] [smallint] NOT NULL, [MonthlyKarma] [smallint] NOT NULL, [MonthlyTotal] [smallint] NOT NULL, [WeeklySubmittedStoryCount] [smallint] NOT NULL, [WeeklyKickedStoryCount] [smallint] NOT NULL, [WeeklyCommentCount] [smallint] NOT NULL, [WeeklyKarma] [smallint] NOT NULL, [WeeklyTotal] [smallint] NOT NULL, [DailySubmittedStoryCount] [smallint] NOT NULL, [DailyKickedStoryCount] [smallint] NOT NULL, [DailyCommentCount] [smallint] NOT NULL, [DailyKarma] [smallint] NOT NULL, [DailyTotal] [smallint] NOT NULL, CONSTRAINT [PK_Kick_HostUserStatistics] PRIMARY KEY CLUSTERED ( [HostID] ASC, [UserID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByUsernameKickedStateAndHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByUsernameKickedStateAndHostID_Count] ( @Username_Match nvarchar(50), @IsKicked_Match bit, @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([Username] LIKE @Username_Match) ) AND ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByUsernameAndHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByUsernameAndHostID] ( @Username_Match nvarchar(50), @HostID_Match int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([Username] LIKE @Username_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByUsernameAndHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByUsernameAndHostID_Count] ( @Username_Match nvarchar(50), @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([Username] LIKE @Username_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryByIdentifier]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryByIdentifier] ( @StoryIdentifier_Match nvarchar(255) ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([StoryIdentifier] LIKE @StoryIdentifier_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryByIdentifier_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryByIdentifier_Count] ( @StoryIdentifier_Match nvarchar(255) ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([StoryIdentifier] LIKE @StoryIdentifier_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByPK_StoryID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByPK_StoryID] ( @StoryID int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByCategoryKickedStateAndHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByCategoryKickedStateAndHostID_Count] ( @CategoryID_Match smallint, @IsKicked_Match bit, @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([CategoryID] LIKE @CategoryID_Match) ) AND ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByCategoryKickedStateAndHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByCategoryKickedStateAndHostID] ( @CategoryID_Match smallint, @IsKicked_Match bit, @HostID_Match int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([CategoryID] LIKE @CategoryID_Match) ) AND ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickStoryAndHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickStoryAndHostID] ( @IsKickStory_Match bit, @HostID_Match int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([IsKickStory] LIKE @IsKickStory_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickStoryAndHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickStoryAndHostID_Count] ( @IsKickStory_Match bit, @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([IsKickStory] LIKE @IsKickStory_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByUsernameKickedStateAndHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByUsernameKickedStateAndHostID] ( @Username_Match nvarchar(50), @IsKicked_Match bit, @HostID_Match int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([Username] LIKE @Username_Match) ) AND ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_Story]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_Story] ( @StoryID int, @HostID int, @StoryIdentifier nvarchar(255), @Title nvarchar(255), @Description nvarchar(4000), @Url nvarchar(1000), @CategoryID smallint, @UserID int, @Username nvarchar(50), @PostedDateTime datetime, @PublishedDateTime datetime, @KickCount int, @AutoKickCount int, @SpamCount int, @ViewCount int, @CommentCount int, @IsKicked bit, @IsSpam bit, @IsKickStory bit, @AdsenseID nvarchar(30) ) AS UPDATE [Kick_Story] SET [HostID] = @HostID, [StoryIdentifier] = @StoryIdentifier, [Title] = @Title, [Description] = @Description, [Url] = @Url, [CategoryID] = @CategoryID, [UserID] = @UserID, [Username] = @Username, [PostedDateTime] = @PostedDateTime, [PublishedDateTime] = @PublishedDateTime, [KickCount] = @KickCount, [AutoKickCount] = @AutoKickCount, [SpamCount] = @SpamCount, [ViewCount] = @ViewCount, [CommentCount] = @CommentCount, [IsKicked] = @IsKicked, [IsSpam] = @IsSpam, [IsKickStory] = @IsKickStory, [AdsenseID] = @AdsenseID WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_Story]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_Story] ( @StoryID int OUTPUT, @HostID int, @StoryIdentifier nvarchar(255), @Title nvarchar(255), @Description nvarchar(4000), @Url nvarchar(1000), @CategoryID smallint, @UserID int, @Username nvarchar(50), @PostedDateTime datetime, @PublishedDateTime datetime, @KickCount int, @AutoKickCount int, @SpamCount int, @ViewCount int, @CommentCount int, @IsKicked bit, @IsSpam bit, @IsKickStory bit, @AdsenseID nvarchar(30) ) AS INSERT INTO [Kick_Story] ( [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] ) VALUES ( @HostID, @StoryIdentifier, @Title, @Description, @Url, @CategoryID, @UserID, @Username, @PostedDateTime, @PublishedDateTime, @KickCount, @AutoKickCount, @SpamCount, @ViewCount, @CommentCount, @IsKicked, @IsSpam, @IsKickStory, @AdsenseID ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Storys]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Storys] AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Story_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Story_ByID] ( @StoryID int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_Story]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_Story] ( @StoryID int ) AS DELETE [Kick_Story] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Storys_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Storys_Count] AS SELECT COUNT(*) FROM [Kick_Story] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_Kick_Get_User_Kicked_Stories_Paged]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' CREATE PROCEDURE [dbo].[_Kick_Get_User_Kicked_Stories_Paged] @UserID int, @HostID int, @PageNumber int, @PageSize int AS BEGIN DECLARE @StartRow int, @EndRow int SET @StartRow = (((@PageNumber - 1) * @PageSize) + 1); SET @EndRow = (@StartRow + @PageSize - 1); WITH KickedStories AS (SELECT ROW_NUMBER() OVER (ORDER BY CreatedDateTime DESC) AS Row, dbo.Kick_Story.* FROM dbo.Kick_Story INNER JOIN dbo.Kick_StoryKick ON dbo.Kick_Story.StoryID = dbo.Kick_StoryKick.StoryID WHERE dbo.Kick_StoryKick.UserID=@UserID AND dbo.Kick_StoryKick.HostID=@HostID) SELECT * FROM KickedStories WHERE ROW between @StartRow AND @EndRow END ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryByUrl]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryByUrl] ( @Url_Match nvarchar(1000) ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([Url] LIKE @Url_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickedHostIDAndPostedDateTime]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickedHostIDAndPostedDateTime] ( @IsKicked_Match bit, @HostID_Match int, @PostedDateTime_Upper datetime, @PostedDateTime_Lower datetime ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) AND ( ([PostedDateTime] >= @PostedDateTime_Lower) AND ([PostedDateTime] <= @PostedDateTime_Upper) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryByUrl_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryByUrl_Count] ( @Url_Match nvarchar(1000) ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([Url] LIKE @Url_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickedHostIDAndPostedDateTime_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickedHostIDAndPostedDateTime_Count] ( @IsKicked_Match bit, @HostID_Match int, @PostedDateTime_Upper datetime, @PostedDateTime_Lower datetime ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) AND ( ([PostedDateTime] >= @PostedDateTime_Lower) AND ([PostedDateTime] <= @PostedDateTime_Upper) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickedAndHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickedAndHostID] ( @IsKicked_Match bit, @HostID_Match int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE ( ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoriesByIsKickedAndHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoriesByIsKickedAndHostID_Count] ( @IsKicked_Match bit, @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE ( ( ([IsKicked] LIKE @IsKicked_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_CategoryID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_CategoryID] ( @CategoryID smallint ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE [CategoryID] = @CategoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_CategoryID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_CategoryID_Count] ( @CategoryID smallint ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE [CategoryID] = @CategoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_UserID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_UserID_Count] ( @UserID int ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_HostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_HostID] ( @HostID int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_HostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_HostID_Count] ( @HostID int ) AS SELECT COUNT(*) FROM [Kick_Story] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Storys_ByFK_UserID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Storys_ByFK_UserID] ( @UserID int ) AS SELECT [StoryID], [HostID], [StoryIdentifier], [Title], [Description], [Url], [CategoryID], [UserID], [Username], [PostedDateTime], [PublishedDateTime], [KickCount], [AutoKickCount], [SpamCount], [ViewCount], [CommentCount], [IsKicked], [IsSpam], [IsKickStory], [AdsenseID] FROM [Kick_Story] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Hosts]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Hosts] AS SELECT [HostID], [HostName], [RootUrl], [SiteTitle], [SiteDescription], [TagLine], [LogoPath], [CreatedDateTime], [BlogUrl], [Email], [Skin], [Theme], [ShowAds], [Culture], [UICulture], [Publish_MinimumStoryAgeInHours], [Publish_MaximumStoryAgeInHours], [Publish_MaximumSimiltanousStoryPublishCount], [Publish_MinimumStoryScore], [Publish_MinimumStoryKickCount], [Publish_MinimumStoryCommentCount], [Publish_MinimumAverageStoryKicksPerHour], [Publish_MinimunAverageCommentsPerHour], [Publish_MinimumViewCount], [Publish_KickScore], [Publish_CommentScore], [AdsenseID], [TrackingHtml] FROM [Kick_Host] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Host_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Host_ByID] ( @HostID int ) AS SELECT [HostID], [HostName], [RootUrl], [SiteTitle], [SiteDescription], [TagLine], [LogoPath], [CreatedDateTime], [BlogUrl], [Email], [Skin], [Theme], [ShowAds], [Culture], [UICulture], [Publish_MinimumStoryAgeInHours], [Publish_MaximumStoryAgeInHours], [Publish_MaximumSimiltanousStoryPublishCount], [Publish_MinimumStoryScore], [Publish_MinimumStoryKickCount], [Publish_MinimumStoryCommentCount], [Publish_MinimumAverageStoryKicksPerHour], [Publish_MinimunAverageCommentsPerHour], [Publish_MinimumViewCount], [Publish_KickScore], [Publish_CommentScore], [AdsenseID], [TrackingHtml] FROM [Kick_Host] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_Host]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_Host] ( @HostID int ) AS DELETE [Kick_Host] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Hosts_ByPK_HostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Hosts_ByPK_HostID] ( @HostID int ) AS SELECT [HostID], [HostName], [RootUrl], [SiteTitle], [SiteDescription], [TagLine], [LogoPath], [CreatedDateTime], [BlogUrl], [Email], [Skin], [Theme], [ShowAds], [Culture], [UICulture], [Publish_MinimumStoryAgeInHours], [Publish_MaximumStoryAgeInHours], [Publish_MaximumSimiltanousStoryPublishCount], [Publish_MinimumStoryScore], [Publish_MinimumStoryKickCount], [Publish_MinimumStoryCommentCount], [Publish_MinimumAverageStoryKicksPerHour], [Publish_MinimunAverageCommentsPerHour], [Publish_MinimumViewCount], [Publish_KickScore], [Publish_CommentScore], [AdsenseID], [TrackingHtml] FROM [Kick_Host] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_Host]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_Host] ( @HostID int, @HostName nvarchar(255), @RootUrl nvarchar(50), @SiteTitle nvarchar(255), @SiteDescription nvarchar(2000), @TagLine nvarchar(255), @LogoPath nvarchar(255), @CreatedDateTime datetime, @BlogUrl nvarchar(255), @Email nvarchar(255), @Skin nvarchar(50), @Theme nvarchar(50), @ShowAds bit, @Culture nvarchar(50), @UICulture nvarchar(50), @Publish_MinimumStoryAgeInHours smallint, @Publish_MaximumStoryAgeInHours smallint, @Publish_MaximumSimiltanousStoryPublishCount smallint, @Publish_MinimumStoryScore smallint, @Publish_MinimumStoryKickCount smallint, @Publish_MinimumStoryCommentCount smallint, @Publish_MinimumAverageStoryKicksPerHour smallint, @Publish_MinimunAverageCommentsPerHour smallint, @Publish_MinimumViewCount smallint, @Publish_KickScore smallint, @Publish_CommentScore smallint, @AdsenseID nvarchar(30), @TrackingHtml text ) AS UPDATE [Kick_Host] SET [HostName] = @HostName, [RootUrl] = @RootUrl, [SiteTitle] = @SiteTitle, [SiteDescription] = @SiteDescription, [TagLine] = @TagLine, [LogoPath] = @LogoPath, [CreatedDateTime] = @CreatedDateTime, [BlogUrl] = @BlogUrl, [Email] = @Email, [Skin] = @Skin, [Theme] = @Theme, [ShowAds] = @ShowAds, [Culture] = @Culture, [UICulture] = @UICulture, [Publish_MinimumStoryAgeInHours] = @Publish_MinimumStoryAgeInHours, [Publish_MaximumStoryAgeInHours] = @Publish_MaximumStoryAgeInHours, [Publish_MaximumSimiltanousStoryPublishCount] = @Publish_MaximumSimiltanousStoryPublishCount, [Publish_MinimumStoryScore] = @Publish_MinimumStoryScore, [Publish_MinimumStoryKickCount] = @Publish_MinimumStoryKickCount, [Publish_MinimumStoryCommentCount] = @Publish_MinimumStoryCommentCount, [Publish_MinimumAverageStoryKicksPerHour] = @Publish_MinimumAverageStoryKicksPerHour, [Publish_MinimunAverageCommentsPerHour] = @Publish_MinimunAverageCommentsPerHour, [Publish_MinimumViewCount] = @Publish_MinimumViewCount, [Publish_KickScore] = @Publish_KickScore, [Publish_CommentScore] = @Publish_CommentScore, [AdsenseID] = @AdsenseID, [TrackingHtml] = @TrackingHtml WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Hosts_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Hosts_Count] AS SELECT COUNT(*) FROM [Kick_Host] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_Host]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_Host] ( @HostID int OUTPUT, @HostName nvarchar(255), @RootUrl nvarchar(50), @SiteTitle nvarchar(255), @SiteDescription nvarchar(2000), @TagLine nvarchar(255), @LogoPath nvarchar(255), @CreatedDateTime datetime, @BlogUrl nvarchar(255), @Email nvarchar(255), @Skin nvarchar(50), @Theme nvarchar(50), @ShowAds bit, @Culture nvarchar(50), @UICulture nvarchar(50), @Publish_MinimumStoryAgeInHours smallint, @Publish_MaximumStoryAgeInHours smallint, @Publish_MaximumSimiltanousStoryPublishCount smallint, @Publish_MinimumStoryScore smallint, @Publish_MinimumStoryKickCount smallint, @Publish_MinimumStoryCommentCount smallint, @Publish_MinimumAverageStoryKicksPerHour smallint, @Publish_MinimunAverageCommentsPerHour smallint, @Publish_MinimumViewCount smallint, @Publish_KickScore smallint, @Publish_CommentScore smallint, @AdsenseID nvarchar(30), @TrackingHtml text ) AS INSERT INTO [Kick_Host] ( [HostName], [RootUrl], [SiteTitle], [SiteDescription], [TagLine], [LogoPath], [CreatedDateTime], [BlogUrl], [Email], [Skin], [Theme], [ShowAds], [Culture], [UICulture], [Publish_MinimumStoryAgeInHours], [Publish_MaximumStoryAgeInHours], [Publish_MaximumSimiltanousStoryPublishCount], [Publish_MinimumStoryScore], [Publish_MinimumStoryKickCount], [Publish_MinimumStoryCommentCount], [Publish_MinimumAverageStoryKicksPerHour], [Publish_MinimunAverageCommentsPerHour], [Publish_MinimumViewCount], [Publish_KickScore], [Publish_CommentScore], [AdsenseID], [TrackingHtml] ) VALUES ( @HostName, @RootUrl, @SiteTitle, @SiteDescription, @TagLine, @LogoPath, @CreatedDateTime, @BlogUrl, @Email, @Skin, @Theme, @ShowAds, @Culture, @UICulture, @Publish_MinimumStoryAgeInHours, @Publish_MaximumStoryAgeInHours, @Publish_MaximumSimiltanousStoryPublishCount, @Publish_MinimumStoryScore, @Publish_MinimumStoryKickCount, @Publish_MinimumStoryCommentCount, @Publish_MinimumAverageStoryKicksPerHour, @Publish_MinimunAverageCommentsPerHour, @Publish_MinimumViewCount, @Publish_KickScore, @Publish_CommentScore, @AdsenseID, @TrackingHtml ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_sysdiagrams]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_sysdiagrams] ( @name sysname, @principal_id int, @diagram_id int OUTPUT, @version int, @definition varbinary ) AS INSERT INTO [sysdiagrams] ( [name], [principal_id], [version], [definition] ) VALUES ( @name, @principal_id, @version, @definition ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_sysdiagrams_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_sysdiagrams_ByID] ( @diagram_id int ) AS SELECT [name], [principal_id], [diagram_id], [version], [definition] FROM [sysdiagrams] WHERE [diagram_id] = @diagram_id ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_sysdiagrams]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_sysdiagrams] ( @diagram_id int ) AS DELETE [sysdiagrams] WHERE [diagram_id] = @diagram_id ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_sysdiagrams]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_sysdiagrams] ( @name sysname, @principal_id int, @diagram_id int, @version int, @definition varbinary ) AS UPDATE [sysdiagrams] SET [name] = @name, [principal_id] = @principal_id, [version] = @version, [definition] = @definition WHERE [diagram_id] = @diagram_id' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_sysdiagramss]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_sysdiagramss] AS SELECT [name], [principal_id], [diagram_id], [version], [definition] FROM [sysdiagrams] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_sysdiagramss_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_sysdiagramss_Count] AS SELECT COUNT(*) FROM [sysdiagrams] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Users_ByPK_UserID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Users_ByPK_UserID] ( @UserID int ) AS SELECT [UserID], [Username], [Email], [Password], [PasswordSalt], [IsGeneratedPassword], [IsValidated], [IsBanned], [AdsenseID], [ReceiveEmailNewsletter], [Roles], [CreatedDateTime], [LastActiveDateTime] FROM [Kick_User] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Users_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Users_Count] AS SELECT COUNT(*) FROM [Kick_User] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_User_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_User_ByID] ( @UserID int ) AS SELECT [UserID], [Username], [Email], [Password], [PasswordSalt], [IsGeneratedPassword], [IsValidated], [IsBanned], [AdsenseID], [ReceiveEmailNewsletter], [Roles], [CreatedDateTime], [LastActiveDateTime] FROM [Kick_User] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_User]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_User] ( @UserID int OUTPUT, @Username nvarchar(50), @Email nvarchar(255), @Password nvarchar(50), @PasswordSalt nvarchar(50), @IsGeneratedPassword bit, @IsValidated bit, @IsBanned bit, @AdsenseID nvarchar(30), @ReceiveEmailNewsletter bit, @Roles nvarchar(100), @CreatedDateTime datetime, @LastActiveDateTime datetime ) AS INSERT INTO [Kick_User] ( [Username], [Email], [Password], [PasswordSalt], [IsGeneratedPassword], [IsValidated], [IsBanned], [AdsenseID], [ReceiveEmailNewsletter], [Roles], [CreatedDateTime], [LastActiveDateTime] ) VALUES ( @Username, @Email, @Password, @PasswordSalt, @IsGeneratedPassword, @IsValidated, @IsBanned, @AdsenseID, @ReceiveEmailNewsletter, @Roles, @CreatedDateTime, @LastActiveDateTime ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_User]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_User] ( @UserID int, @Username nvarchar(50), @Email nvarchar(255), @Password nvarchar(50), @PasswordSalt nvarchar(50), @IsGeneratedPassword bit, @IsValidated bit, @IsBanned bit, @AdsenseID nvarchar(30), @ReceiveEmailNewsletter bit, @Roles nvarchar(100), @CreatedDateTime datetime, @LastActiveDateTime datetime ) AS UPDATE [Kick_User] SET [Username] = @Username, [Email] = @Email, [Password] = @Password, [PasswordSalt] = @PasswordSalt, [IsGeneratedPassword] = @IsGeneratedPassword, [IsValidated] = @IsValidated, [IsBanned] = @IsBanned, [AdsenseID] = @AdsenseID, [ReceiveEmailNewsletter] = @ReceiveEmailNewsletter, [Roles] = @Roles, [CreatedDateTime] = @CreatedDateTime, [LastActiveDateTime] = @LastActiveDateTime WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_User]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_User] ( @UserID int ) AS DELETE [Kick_User] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Users]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Users] AS SELECT [UserID], [Username], [Email], [Password], [PasswordSalt], [IsGeneratedPassword], [IsValidated], [IsBanned], [AdsenseID], [ReceiveEmailNewsletter], [Roles], [CreatedDateTime], [LastActiveDateTime] FROM [Kick_User] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByReceiveEmailNewsletter_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByReceiveEmailNewsletter_Count] ( @ReceiveEmailNewsletter_Match bit ) AS SELECT COUNT(*) FROM [Kick_User] WHERE ( ( ([ReceiveEmailNewsletter] LIKE @ReceiveEmailNewsletter_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByReceiveEmailNewsletter]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByReceiveEmailNewsletter] ( @ReceiveEmailNewsletter_Match bit ) AS SELECT [UserID], [Username], [Email], [Password], [PasswordSalt], [IsGeneratedPassword], [IsValidated], [IsBanned], [AdsenseID], [ReceiveEmailNewsletter], [Roles], [CreatedDateTime], [LastActiveDateTime] FROM [Kick_User] WHERE ( ( ([ReceiveEmailNewsletter] LIKE @ReceiveEmailNewsletter_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByEmail]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByEmail] ( @Email_Match nvarchar(255) ) AS SELECT [UserID], [Username], [Email], [Password], [PasswordSalt], [IsGeneratedPassword], [IsValidated], [IsBanned], [AdsenseID], [ReceiveEmailNewsletter], [Roles], [CreatedDateTime], [LastActiveDateTime] FROM [Kick_User] WHERE ( ( ([Email] LIKE @Email_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByEmail_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByEmail_Count] ( @Email_Match nvarchar(255) ) AS SELECT COUNT(*) FROM [Kick_User] WHERE ( ( ([Email] LIKE @Email_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByUsername_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByUsername_Count] ( @Username_Match nvarchar(50) ) AS SELECT COUNT(*) FROM [Kick_User] WHERE ( ( ([Username] LIKE @Username_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetUserByUsername]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetUserByUsername] ( @Username_Match nvarchar(50) ) AS SELECT [UserID], [Username], [Email], [Password], [PasswordSalt], [IsGeneratedPassword], [IsValidated], [IsBanned], [AdsenseID], [ReceiveEmailNewsletter], [Roles], [CreatedDateTime], [LastActiveDateTime] FROM [Kick_User] WHERE ( ( ([Username] LIKE @Username_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_StoryKick]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_StoryKick] ( @StoryID int, @UserID int, @HostID int, @StoryKickID int OUTPUT, @CreatedDateTime datetime ) AS INSERT INTO [Kick_StoryKick] ( [StoryID], [UserID], [HostID], [CreatedDateTime] ) VALUES ( @StoryID, @UserID, @HostID, @CreatedDateTime ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryKick_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryKick_ByID] ( @StoryID int, @UserID int, @HostID int ) AS SELECT [StoryID], [UserID], [HostID], [StoryKickID], [CreatedDateTime] FROM [Kick_StoryKick] WHERE [StoryID] = @StoryID AND [UserID] = @UserID AND [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_StoryKick]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_StoryKick] ( @StoryID int, @UserID int, @HostID int, @StoryKickID int, @CreatedDateTime datetime ) AS UPDATE [Kick_StoryKick] SET [StoryID] = @StoryID, [UserID] = @UserID, [HostID] = @HostID, [CreatedDateTime] = @CreatedDateTime WHERE [StoryID] = @StoryID AND [UserID] = @UserID AND [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_StoryKicks]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_StoryKicks] AS SELECT [StoryID], [UserID], [HostID], [StoryKickID], [CreatedDateTime] FROM [Kick_StoryKick] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_StoryKick]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_StoryKick] ( @StoryID int, @UserID int, @HostID int ) AS DELETE [Kick_StoryKick] WHERE [StoryID] = @StoryID AND [UserID] = @UserID AND [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_StoryKicks_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_StoryKicks_Count] AS SELECT COUNT(*) FROM [Kick_StoryKick] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryKicksByUserIDAndHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryKicksByUserIDAndHostID_Count] ( @UserID_Match int, @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_StoryKick] WHERE ( ( ([UserID] LIKE @UserID_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryKicksByUserIDAndHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryKicksByUserIDAndHostID] ( @UserID_Match int, @HostID_Match int ) AS SELECT [StoryID], [UserID], [HostID], [StoryKickID], [CreatedDateTime] FROM [Kick_StoryKick] WHERE ( ( ([UserID] LIKE @UserID_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryKicks_ByFK_UserID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryKicks_ByFK_UserID] ( @UserID int ) AS SELECT [StoryID], [UserID], [HostID], [StoryKickID], [CreatedDateTime] FROM [Kick_StoryKick] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryKicks_ByFK_StoryID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryKicks_ByFK_StoryID] ( @StoryID int ) AS SELECT [StoryID], [UserID], [HostID], [StoryKickID], [CreatedDateTime] FROM [Kick_StoryKick] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryKicks_ByFK_StoryID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryKicks_ByFK_StoryID_Count] ( @StoryID int ) AS SELECT COUNT(*) FROM [Kick_StoryKick] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryKicks_ByFK_UserID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryKicks_ByFK_UserID_Count] ( @UserID int ) AS SELECT COUNT(*) FROM [Kick_StoryKick] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Comments]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Comments] AS SELECT [CommentID], [StoryID], [UserID], [Username], [Comment], [PostedDateTime] FROM [Kick_Comment] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Comments_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Comments_Count] AS SELECT COUNT(*) FROM [Kick_Comment] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Comments_ByFK_UserID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Comments_ByFK_UserID] ( @UserID int ) AS SELECT [CommentID], [StoryID], [UserID], [Username], [Comment], [PostedDateTime] FROM [Kick_Comment] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Comments_ByFK_StoryID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Comments_ByFK_StoryID] ( @StoryID int ) AS SELECT [CommentID], [StoryID], [UserID], [Username], [Comment], [PostedDateTime] FROM [Kick_Comment] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Comments_ByFK_StoryID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Comments_ByFK_StoryID_Count] ( @StoryID int ) AS SELECT COUNT(*) FROM [Kick_Comment] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Comments_ByFK_UserID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Comments_ByFK_UserID_Count] ( @UserID int ) AS SELECT COUNT(*) FROM [Kick_Comment] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_Comment]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_Comment] ( @CommentID int OUTPUT, @StoryID int, @UserID int, @Username nvarchar(50), @Comment nvarchar(4000), @PostedDateTime datetime ) AS INSERT INTO [Kick_Comment] ( [StoryID], [UserID], [Username], [Comment], [PostedDateTime] ) VALUES ( @StoryID, @UserID, @Username, @Comment, @PostedDateTime ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Comment_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Comment_ByID] ( @CommentID int ) AS SELECT [CommentID], [StoryID], [UserID], [Username], [Comment], [PostedDateTime] FROM [Kick_Comment] WHERE [CommentID] = @CommentID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_Comment]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_Comment] ( @CommentID int, @StoryID int, @UserID int, @Username nvarchar(50), @Comment nvarchar(4000), @PostedDateTime datetime ) AS UPDATE [Kick_Comment] SET [StoryID] = @StoryID, [UserID] = @UserID, [Username] = @Username, [Comment] = @Comment, [PostedDateTime] = @PostedDateTime WHERE [CommentID] = @CommentID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_Comment]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_Comment] ( @CommentID int ) AS DELETE [Kick_Comment] WHERE [CommentID] = @CommentID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_Tag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_Tag] ( @TagID int OUTPUT, @TagIdentifier nvarchar(40) ) AS INSERT INTO [Kick_Tag] ( [TagIdentifier] ) VALUES ( @TagIdentifier ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_Tag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_Tag] ( @TagID int, @TagIdentifier nvarchar(40) ) AS UPDATE [Kick_Tag] SET [TagIdentifier] = @TagIdentifier WHERE [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetTagByTagIdentifier]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetTagByTagIdentifier] ( @TagIdentifier_Match nvarchar(40) ) AS SELECT [TagID], [TagIdentifier] FROM [Kick_Tag] WHERE ( ( ([TagIdentifier] LIKE @TagIdentifier_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetTagByTagIdentifier_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetTagByTagIdentifier_Count] ( @TagIdentifier_Match nvarchar(40) ) AS SELECT COUNT(*) FROM [Kick_Tag] WHERE ( ( ([TagIdentifier] LIKE @TagIdentifier_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Tags_ByPK_TagID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Tags_ByPK_TagID] ( @TagID int ) AS SELECT [TagID], [TagIdentifier] FROM [Kick_Tag] WHERE [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_Tag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_Tag] ( @TagID int ) AS DELETE [Kick_Tag] WHERE [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Tags]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Tags] AS SELECT [TagID], [TagIdentifier] FROM [Kick_Tag] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Tags_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Tags_Count] AS SELECT COUNT(*) FROM [Kick_Tag] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Tag_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Tag_ByID] ( @TagID int ) AS SELECT [TagID], [TagIdentifier] FROM [Kick_Tag] WHERE [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Category_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Category_ByID] ( @CategoryID smallint ) AS SELECT [CategoryID], [HostID], [CategoryIdentifier], [Name], [Description], [OrderPriority] FROM [Kick_Category] WHERE [CategoryID] = @CategoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_Category]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_Category] ( @CategoryID smallint, @HostID int, @CategoryIdentifier nvarchar(50), @Name nvarchar(50), @Description nvarchar(4000), @OrderPriority smallint ) AS UPDATE [Kick_Category] SET [HostID] = @HostID, [CategoryIdentifier] = @CategoryIdentifier, [Name] = @Name, [Description] = @Description, [OrderPriority] = @OrderPriority WHERE [CategoryID] = @CategoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Categorys_ByFK_HostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Categorys_ByFK_HostID] ( @HostID int ) AS SELECT [CategoryID], [HostID], [CategoryIdentifier], [Name], [Description], [OrderPriority] FROM [Kick_Category] WHERE [HostID] = @HostID Order by [OrderPriority], [Name]' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Categorys_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Categorys_Count] AS SELECT COUNT(*) FROM [Kick_Category] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_Categorys]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_Categorys] AS SELECT [CategoryID], [HostID], [CategoryIdentifier], [Name], [Description], [OrderPriority] FROM [Kick_Category] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_Category]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_Category] ( @CategoryID smallint ) AS DELETE [Kick_Category] WHERE [CategoryID] = @CategoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Categorys_ByPK_CategoryID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Categorys_ByPK_CategoryID] ( @CategoryID smallint ) AS SELECT [CategoryID], [HostID], [CategoryIdentifier], [Name], [Description], [OrderPriority] FROM [Kick_Category] WHERE [CategoryID] = @CategoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetCategoriesByHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetCategoriesByHostID_Count] ( @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_Category] WHERE ( ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetCategoriesByHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetCategoriesByHostID] ( @HostID_Match int ) AS SELECT [CategoryID], [HostID], [CategoryIdentifier], [Name], [Description], [OrderPriority] FROM [Kick_Category] WHERE ( ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_Category]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_Category] ( @CategoryID smallint OUTPUT, @HostID int, @CategoryIdentifier nvarchar(50), @Name nvarchar(50), @Description nvarchar(4000), @OrderPriority smallint ) AS INSERT INTO [Kick_Category] ( [HostID], [CategoryIdentifier], [Name], [Description], [OrderPriority] ) VALUES ( @HostID, @CategoryIdentifier, @Name, @Description, @OrderPriority ) SELECT CAST(SCOPE_IDENTITY() AS INTEGER) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_Categorys_ByFK_HostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_Categorys_ByFK_HostID_Count] ( @HostID int ) AS SELECT COUNT(*) FROM [Kick_Category] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_HostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_HostID] ( @HostID int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_UserID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_UserID] ( @UserID int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_HostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_HostID_Count] ( @HostID int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_TagID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_TagID] ( @TagID int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_StoryID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_StoryID_Count] ( @StoryID int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_StoryID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_StoryID] ( @StoryID int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE [StoryID] = @StoryID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_UserID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_UserID_Count] ( @UserID int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_StoryUserHostTags_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_StoryUserHostTags_Count] AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_StoryUserHostTag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_StoryUserHostTag] ( @StoryID int, @UserID int, @HostID int, @TagID int, @CreatedDateTime datetime ) AS INSERT INTO [Kick_StoryUserHostTag] ( [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] ) VALUES ( @StoryID, @UserID, @HostID, @TagID, @CreatedDateTime ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_StoryUserHostTag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_StoryUserHostTag] ( @StoryID int, @UserID int, @HostID int, @TagID int, @CreatedDateTime datetime ) AS UPDATE [Kick_StoryUserHostTag] SET [StoryID] = @StoryID, [UserID] = @UserID, [HostID] = @HostID, [TagID] = @TagID, [CreatedDateTime] = @CreatedDateTime WHERE [StoryID] = @StoryID AND [UserID] = @UserID AND [HostID] = @HostID AND [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByUserIDAndHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByUserIDAndHostID] ( @UserID_Match int, @HostID_Match int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE ( ( ([UserID] LIKE @UserID_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByHostID_Count] ( @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE ( ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByUserIDAndHostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByUserIDAndHostID_Count] ( @UserID_Match int, @HostID_Match int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE ( ( ([UserID] LIKE @UserID_Match) ) AND ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByHostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByHostID] ( @HostID_Match int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE ( ( ([HostID] LIKE @HostID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_TagID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTags_ByFK_TagID_Count] ( @TagID int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByHostIDAndDateRange]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByHostIDAndDateRange] ( @HostID_Match int, @CreatedDateTime_Upper datetime, @CreatedDateTime_Lower datetime ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE ( ( ([HostID] LIKE @HostID_Match) ) AND ( ([CreatedDateTime] >= @CreatedDateTime_Lower) AND ([CreatedDateTime] <= @CreatedDateTime_Upper) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByStoryIDAndUserID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByStoryIDAndUserID_Count] ( @StoryID_Match int, @UserID_Match int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE ( ( ([StoryID] LIKE @StoryID_Match) ) AND ( ([UserID] LIKE @UserID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByStoryID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByStoryID_Count] ( @StoryID_Match int ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE ( ( ([StoryID] LIKE @StoryID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByStoryIDAndUserID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByStoryIDAndUserID] ( @StoryID_Match int, @UserID_Match int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE ( ( ([StoryID] LIKE @StoryID_Match) ) AND ( ([UserID] LIKE @UserID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByStoryID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByStoryID] ( @StoryID_Match int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE ( ( ([StoryID] LIKE @StoryID_Match) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_StoryUserHostTag]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_StoryUserHostTag] ( @StoryID int, @UserID int, @HostID int, @TagID int ) AS DELETE [Kick_StoryUserHostTag] WHERE [StoryID] = @StoryID AND [UserID] = @UserID AND [HostID] = @HostID AND [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_GetStoryUserHostTagsByHostIDAndDateRange_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_GetStoryUserHostTagsByHostIDAndDateRange_Count] ( @HostID_Match int, @CreatedDateTime_Upper datetime, @CreatedDateTime_Lower datetime ) AS SELECT COUNT(*) FROM [Kick_StoryUserHostTag] WHERE ( ( ([HostID] LIKE @HostID_Match) ) AND ( ([CreatedDateTime] >= @CreatedDateTime_Lower) AND ([CreatedDateTime] <= @CreatedDateTime_Upper) ) ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_StoryUserHostTag_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_StoryUserHostTag_ByID] ( @StoryID int, @UserID int, @HostID int, @TagID int ) AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] WHERE [StoryID] = @StoryID AND [UserID] = @UserID AND [HostID] = @HostID AND [TagID] = @TagID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_StoryUserHostTags]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_StoryUserHostTags] AS SELECT [StoryID], [UserID], [HostID], [TagID], [CreatedDateTime] FROM [Kick_StoryUserHostTag] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_HostID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_HostID] ( @HostID int ) AS SELECT [HostID], [UserID], [TotalSubmittedStoryCount], [TotalKickedStoryCount], [TotalCommentCount], [TotalKarma], [TotalScore], [YearlySubmittedStoryCount], [YearlyKickedStoryCount], [YearlyCommentCount], [YearlyKarma], [YearlyScore], [MonthlySubmittedStoryCount], [MonthlyKickedStoryCount], [MonthlyCommentCount], [MonthlyKarma], [MonthlyTotal], [WeeklySubmittedStoryCount], [WeeklyKickedStoryCount], [WeeklyCommentCount], [WeeklyKarma], [WeeklyTotal], [DailySubmittedStoryCount], [DailyKickedStoryCount], [DailyCommentCount], [DailyKarma], [DailyTotal] FROM [Kick_HostUserStatistics] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_UserID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_UserID] ( @UserID int ) AS SELECT [HostID], [UserID], [TotalSubmittedStoryCount], [TotalKickedStoryCount], [TotalCommentCount], [TotalKarma], [TotalScore], [YearlySubmittedStoryCount], [YearlyKickedStoryCount], [YearlyCommentCount], [YearlyKarma], [YearlyScore], [MonthlySubmittedStoryCount], [MonthlyKickedStoryCount], [MonthlyCommentCount], [MonthlyKarma], [MonthlyTotal], [WeeklySubmittedStoryCount], [WeeklyKickedStoryCount], [WeeklyCommentCount], [WeeklyKarma], [WeeklyTotal], [DailySubmittedStoryCount], [DailyKickedStoryCount], [DailyCommentCount], [DailyKarma], [DailyTotal] FROM [Kick_HostUserStatistics] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_HostUserStatisticss_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_HostUserStatisticss_Count] AS SELECT COUNT(*) FROM [Kick_HostUserStatistics] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_All_Kick_HostUserStatisticss]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_All_Kick_HostUserStatisticss] AS SELECT [HostID], [UserID], [TotalSubmittedStoryCount], [TotalKickedStoryCount], [TotalCommentCount], [TotalKarma], [TotalScore], [YearlySubmittedStoryCount], [YearlyKickedStoryCount], [YearlyCommentCount], [YearlyKarma], [YearlyScore], [MonthlySubmittedStoryCount], [MonthlyKickedStoryCount], [MonthlyCommentCount], [MonthlyKarma], [MonthlyTotal], [WeeklySubmittedStoryCount], [WeeklyKickedStoryCount], [WeeklyCommentCount], [WeeklyKarma], [WeeklyTotal], [DailySubmittedStoryCount], [DailyKickedStoryCount], [DailyCommentCount], [DailyKarma], [DailyTotal] FROM [Kick_HostUserStatistics] ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_UserID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_UserID_Count] ( @UserID int ) AS SELECT COUNT(*) FROM [Kick_HostUserStatistics] WHERE [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_HostID_Count]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_HostUserStatisticss_ByFK_HostID_Count] ( @HostID int ) AS SELECT COUNT(*) FROM [Kick_HostUserStatistics] WHERE [HostID] = @HostID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Update_Kick_HostUserStatistics]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Update_Kick_HostUserStatistics] ( @HostID int, @UserID int, @TotalSubmittedStoryCount smallint, @TotalKickedStoryCount smallint, @TotalCommentCount smallint, @TotalKarma smallint, @TotalScore smallint, @YearlySubmittedStoryCount smallint, @YearlyKickedStoryCount smallint, @YearlyCommentCount smallint, @YearlyKarma smallint, @YearlyScore smallint, @MonthlySubmittedStoryCount smallint, @MonthlyKickedStoryCount smallint, @MonthlyCommentCount smallint, @MonthlyKarma smallint, @MonthlyTotal smallint, @WeeklySubmittedStoryCount smallint, @WeeklyKickedStoryCount smallint, @WeeklyCommentCount smallint, @WeeklyKarma smallint, @WeeklyTotal smallint, @DailySubmittedStoryCount smallint, @DailyKickedStoryCount smallint, @DailyCommentCount smallint, @DailyKarma smallint, @DailyTotal smallint ) AS UPDATE [Kick_HostUserStatistics] SET [HostID] = @HostID, [UserID] = @UserID, [TotalSubmittedStoryCount] = @TotalSubmittedStoryCount, [TotalKickedStoryCount] = @TotalKickedStoryCount, [TotalCommentCount] = @TotalCommentCount, [TotalKarma] = @TotalKarma, [TotalScore] = @TotalScore, [YearlySubmittedStoryCount] = @YearlySubmittedStoryCount, [YearlyKickedStoryCount] = @YearlyKickedStoryCount, [YearlyCommentCount] = @YearlyCommentCount, [YearlyKarma] = @YearlyKarma, [YearlyScore] = @YearlyScore, [MonthlySubmittedStoryCount] = @MonthlySubmittedStoryCount, [MonthlyKickedStoryCount] = @MonthlyKickedStoryCount, [MonthlyCommentCount] = @MonthlyCommentCount, [MonthlyKarma] = @MonthlyKarma, [MonthlyTotal] = @MonthlyTotal, [WeeklySubmittedStoryCount] = @WeeklySubmittedStoryCount, [WeeklyKickedStoryCount] = @WeeklyKickedStoryCount, [WeeklyCommentCount] = @WeeklyCommentCount, [WeeklyKarma] = @WeeklyKarma, [WeeklyTotal] = @WeeklyTotal, [DailySubmittedStoryCount] = @DailySubmittedStoryCount, [DailyKickedStoryCount] = @DailyKickedStoryCount, [DailyCommentCount] = @DailyCommentCount, [DailyKarma] = @DailyKarma, [DailyTotal] = @DailyTotal WHERE [HostID] = @HostID AND [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Insert_Kick_HostUserStatistics]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Insert_Kick_HostUserStatistics] ( @HostID int, @UserID int, @TotalSubmittedStoryCount smallint, @TotalKickedStoryCount smallint, @TotalCommentCount smallint, @TotalKarma smallint, @TotalScore smallint, @YearlySubmittedStoryCount smallint, @YearlyKickedStoryCount smallint, @YearlyCommentCount smallint, @YearlyKarma smallint, @YearlyScore smallint, @MonthlySubmittedStoryCount smallint, @MonthlyKickedStoryCount smallint, @MonthlyCommentCount smallint, @MonthlyKarma smallint, @MonthlyTotal smallint, @WeeklySubmittedStoryCount smallint, @WeeklyKickedStoryCount smallint, @WeeklyCommentCount smallint, @WeeklyKarma smallint, @WeeklyTotal smallint, @DailySubmittedStoryCount smallint, @DailyKickedStoryCount smallint, @DailyCommentCount smallint, @DailyKarma smallint, @DailyTotal smallint ) AS INSERT INTO [Kick_HostUserStatistics] ( [HostID], [UserID], [TotalSubmittedStoryCount], [TotalKickedStoryCount], [TotalCommentCount], [TotalKarma], [TotalScore], [YearlySubmittedStoryCount], [YearlyKickedStoryCount], [YearlyCommentCount], [YearlyKarma], [YearlyScore], [MonthlySubmittedStoryCount], [MonthlyKickedStoryCount], [MonthlyCommentCount], [MonthlyKarma], [MonthlyTotal], [WeeklySubmittedStoryCount], [WeeklyKickedStoryCount], [WeeklyCommentCount], [WeeklyKarma], [WeeklyTotal], [DailySubmittedStoryCount], [DailyKickedStoryCount], [DailyCommentCount], [DailyKarma], [DailyTotal] ) VALUES ( @HostID, @UserID, @TotalSubmittedStoryCount, @TotalKickedStoryCount, @TotalCommentCount, @TotalKarma, @TotalScore, @YearlySubmittedStoryCount, @YearlyKickedStoryCount, @YearlyCommentCount, @YearlyKarma, @YearlyScore, @MonthlySubmittedStoryCount, @MonthlyKickedStoryCount, @MonthlyCommentCount, @MonthlyKarma, @MonthlyTotal, @WeeklySubmittedStoryCount, @WeeklyKickedStoryCount, @WeeklyCommentCount, @WeeklyKarma, @WeeklyTotal, @DailySubmittedStoryCount, @DailyKickedStoryCount, @DailyCommentCount, @DailyKarma, @DailyTotal ) ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Get_Kick_HostUserStatistics_ByID]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Get_Kick_HostUserStatistics_ByID] ( @HostID int, @UserID int ) AS SELECT [HostID], [UserID], [TotalSubmittedStoryCount], [TotalKickedStoryCount], [TotalCommentCount], [TotalKarma], [TotalScore], [YearlySubmittedStoryCount], [YearlyKickedStoryCount], [YearlyCommentCount], [YearlyKarma], [YearlyScore], [MonthlySubmittedStoryCount], [MonthlyKickedStoryCount], [MonthlyCommentCount], [MonthlyKarma], [MonthlyTotal], [WeeklySubmittedStoryCount], [WeeklyKickedStoryCount], [WeeklyCommentCount], [WeeklyKarma], [WeeklyTotal], [DailySubmittedStoryCount], [DailyKickedStoryCount], [DailyCommentCount], [DailyKarma], [DailyTotal] FROM [Kick_HostUserStatistics] WHERE [HostID] = @HostID AND [UserID] = @UserID' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kick_Delete_Kick_HostUserStatistics]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'----------------------------------------------------------------------------------- -- This stored procedure was auto-generated by nTierGen.NET Framework Generator v1.5 -- web: http://www.nTierGen.NET/ -- email: mailto:support@gavinjoyce.com -- forums: http://www.gavinjoyce.com/forums/ ----------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[Kick_Delete_Kick_HostUserStatistics] ( @HostID int, @UserID int ) AS DELETE [Kick_HostUserStatistics] WHERE [HostID] = @HostID AND [UserID] = @UserID' END GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_StoryUserHostTag_Kick_Host]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_StoryUserHostTag]')) ALTER TABLE [dbo].[Kick_StoryUserHostTag] WITH CHECK ADD CONSTRAINT [FK_Kick_StoryUserHostTag_Kick_Host] FOREIGN KEY([HostID]) REFERENCES [dbo].[Kick_Host] ([HostID]) GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_StoryUserHostTag_Kick_Story]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_StoryUserHostTag]')) ALTER TABLE [dbo].[Kick_StoryUserHostTag] WITH CHECK ADD CONSTRAINT [FK_Kick_StoryUserHostTag_Kick_Story] FOREIGN KEY([StoryID]) REFERENCES [dbo].[Kick_Story] ([StoryID]) ON DELETE CASCADE GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_StoryUserHostTag_Kick_Tag]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_StoryUserHostTag]')) ALTER TABLE [dbo].[Kick_StoryUserHostTag] WITH CHECK ADD CONSTRAINT [FK_Kick_StoryUserHostTag_Kick_Tag] FOREIGN KEY([TagID]) REFERENCES [dbo].[Kick_Tag] ([TagID]) GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_StoryUserHostTag_Kick_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_StoryUserHostTag]')) ALTER TABLE [dbo].[Kick_StoryUserHostTag] WITH CHECK ADD CONSTRAINT [FK_Kick_StoryUserHostTag_Kick_User] FOREIGN KEY([UserID]) REFERENCES [dbo].[Kick_User] ([UserID]) GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_Comment_Kick_Story]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_Comment]')) ALTER TABLE [dbo].[Kick_Comment] WITH NOCHECK ADD CONSTRAINT [FK_Kick_Comment_Kick_Story] FOREIGN KEY([StoryID]) REFERENCES [dbo].[Kick_Story] ([StoryID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[Kick_Comment] CHECK CONSTRAINT [FK_Kick_Comment_Kick_Story] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_Comment_Kick_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_Comment]')) ALTER TABLE [dbo].[Kick_Comment] WITH NOCHECK ADD CONSTRAINT [FK_Kick_Comment_Kick_User] FOREIGN KEY([UserID]) REFERENCES [dbo].[Kick_User] ([UserID]) GO ALTER TABLE [dbo].[Kick_Comment] CHECK CONSTRAINT [FK_Kick_Comment_Kick_User] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_StoryKick_Kick_Story]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_StoryKick]')) ALTER TABLE [dbo].[Kick_StoryKick] WITH NOCHECK ADD CONSTRAINT [FK_Kick_StoryKick_Kick_Story] FOREIGN KEY([StoryID]) REFERENCES [dbo].[Kick_Story] ([StoryID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[Kick_StoryKick] CHECK CONSTRAINT [FK_Kick_StoryKick_Kick_Story] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_StoryKick_Kick_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_StoryKick]')) ALTER TABLE [dbo].[Kick_StoryKick] WITH NOCHECK ADD CONSTRAINT [FK_Kick_StoryKick_Kick_User] FOREIGN KEY([UserID]) REFERENCES [dbo].[Kick_User] ([UserID]) GO ALTER TABLE [dbo].[Kick_StoryKick] CHECK CONSTRAINT [FK_Kick_StoryKick_Kick_User] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_Story_Kick_Category]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_Story]')) ALTER TABLE [dbo].[Kick_Story] WITH NOCHECK ADD CONSTRAINT [FK_Kick_Story_Kick_Category] FOREIGN KEY([CategoryID]) REFERENCES [dbo].[Kick_Category] ([CategoryID]) GO ALTER TABLE [dbo].[Kick_Story] CHECK CONSTRAINT [FK_Kick_Story_Kick_Category] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_Story_Kick_Host]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_Story]')) ALTER TABLE [dbo].[Kick_Story] WITH NOCHECK ADD CONSTRAINT [FK_Kick_Story_Kick_Host] FOREIGN KEY([HostID]) REFERENCES [dbo].[Kick_Host] ([HostID]) GO ALTER TABLE [dbo].[Kick_Story] CHECK CONSTRAINT [FK_Kick_Story_Kick_Host] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_Story_Kick_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_Story]')) ALTER TABLE [dbo].[Kick_Story] WITH NOCHECK ADD CONSTRAINT [FK_Kick_Story_Kick_User] FOREIGN KEY([UserID]) REFERENCES [dbo].[Kick_User] ([UserID]) GO ALTER TABLE [dbo].[Kick_Story] CHECK CONSTRAINT [FK_Kick_Story_Kick_User] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_Category_Kick_Host]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_Category]')) ALTER TABLE [dbo].[Kick_Category] WITH NOCHECK ADD CONSTRAINT [FK_Kick_Category_Kick_Host] FOREIGN KEY([HostID]) REFERENCES [dbo].[Kick_Host] ([HostID]) GO ALTER TABLE [dbo].[Kick_Category] CHECK CONSTRAINT [FK_Kick_Category_Kick_Host] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_HostUserStatistics_Kick_Host]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_HostUserStatistics]')) ALTER TABLE [dbo].[Kick_HostUserStatistics] WITH CHECK ADD CONSTRAINT [FK_Kick_HostUserStatistics_Kick_Host] FOREIGN KEY([HostID]) REFERENCES [dbo].[Kick_Host] ([HostID]) GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Kick_HostUserStatistics_Kick_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[Kick_HostUserStatistics]')) ALTER TABLE [dbo].[Kick_HostUserStatistics] WITH NOCHECK ADD CONSTRAINT [FK_Kick_HostUserStatistics_Kick_User] FOREIGN KEY([UserID]) REFERENCES [dbo].[Kick_User] ([UserID]) GO ALTER TABLE [dbo].[Kick_HostUserStatistics] CHECK CONSTRAINT [FK_Kick_HostUserStatistics_Kick_User]