Akuma rolback sistemi paylasım

KoDestekGm · 13 May 2009

MERHABALAR
AYHAN ABİNİN PAYLAŞTIĞI DATABASE DE BİLDİĞİNİZ GİBİ ROLLBACK SİSTEMİDE VAR. BELKİ SQL 2021 İNDİRMEYE ÜŞENENLER VAR. O YÜZDEN BENDE BU SİSTEMİ SİZİNLE PAYLAŞAYIM DEDİM...

1.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_FRI]    Script Date: 12/11/2021 04:55:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[BACKUP_FRI]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
declare @strUserID char(21), @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @City tinyint, @Knights smallint, @Fame tinyint
declare @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Points tinyint, @Gold int, @strSkill varchar(10), @strItem varchar(400), @strSerial varchar(400)

SET @strUserID = null SET @Rank = 0 SET @Title = 0 SET @Level = 0 SET @Exp = 0 SET @Loyalty = 0 SET @City = 0 SET @Knights = 0 SET @Fame = 0
SET @Str = 0 SET @Sta = 0 SET @Dex = 0 SET @Intel = 0 SET @Cha = 0 SET @Points = 0 SET @Gold = 0 SET @strSkill = null SET @strItem = null SET @strSerial = null

declare @row tinyint
SET @row = 0

DECLARE Backup_Cursor CURSOR
	FOR
	SELECT strUserId, Rank, Title, [Level], [Exp], Loyalty, City, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial FROM USERDATA

	OPEN Backup_Cursor

	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_FRI_USERDATA where strUserID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_FRI_USERDATA (strUserID, Rank, Title, [Level], [Exp], Loyalty, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial)
		VALUES (@strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial)
	END
	IF @row > 0 and @City <> 255
	BEGIN
		UPDATE BK_FRI_USERDATA 
		SET Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Knights = @Knights, Fame = @Fame, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Points = @Points, Gold = @Gold, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial
		WHERE strUserID = @strUserID
	END
	
	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial
END

CLOSE Backup_Cursor
DEALLOCATE Backup_Cursor

declare @nMoney int, @WarehouseData varchar(1600), @strWareSerial varchar(1600)
SET @nMoney = 0 SET @WarehouseData = null SET @strWareSerial = null

DECLARE Backup_Item_Cursor CURSOR
	FOR
	SELECT strAccountID, nMoney, WarehouseData, strSerial FROM WAREHOUSE

	OPEN Backup_Item_Cursor

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_FRI_WAREHOUSE where strAccountID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_FRI_WAREHOUSE (strAccountID, nMoney, warehouseData, strSerial)
		VALUES (@strUserID, @nMoney, @WarehouseData, @strWareSerial)
	END
	IF @row > 0
	BEGIN
		UPDATE BK_FRI_WAREHOUSE
		SET nMoney = @nMoney, warehouseData = @WarehouseData, strSerial = @strWareSerial WHERE strAccountID = @strUserID
	END

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial
END

CLOSE Backup_Item_Cursor
DEALLOCATE Backup_Item_Cursor

2.adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_MON]    Script Date: 12/11/2021 04:55:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[BACKUP_MON]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
declare @strUserID char(21), @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @City tinyint, @Knights smallint, @Fame tinyint
declare @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Points tinyint, @Gold int, @strSkill varchar(10), @strItem varchar(400), @strSerial varchar(400)

SET @strUserID = null SET @Rank = 0 SET @Title = 0 SET @Level = 0 SET @Exp = 0 SET @Loyalty = 0 SET @City = 0 SET @Knights = 0 SET @Fame = 0
SET @Str = 0 SET @Sta = 0 SET @Dex = 0 SET @Intel = 0 SET @Cha = 0 SET @Points = 0 SET @Gold = 0 SET @strSkill = null SET @strItem = null SET @strSerial = null

declare @row tinyint
SET @row = 0

DECLARE Backup_Cursor CURSOR
	FOR
	SELECT strUserId, Rank, Title, [Level], [Exp], Loyalty, City, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial FROM USERDATA

	OPEN Backup_Cursor

	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_MON_USERDATA where strUserID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_MON_USERDATA (strUserID, Rank, Title, [Level], [Exp], Loyalty, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial)
		VALUES (@strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial)
	END
	IF @row > 0 and @City <> 255
	BEGIN
		UPDATE BK_MON_USERDATA 
		SET Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Knights = @Knights, Fame = @Fame, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Points = @Points, Gold = @Gold, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial
		WHERE strUserID = @strUserID
	END
	
	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial
END

CLOSE Backup_Cursor
DEALLOCATE Backup_Cursor

declare @nMoney int, @WarehouseData varchar(1600), @strWareSerial varchar(1600)
SET @nMoney = 0 SET @WarehouseData = null SET @strWareSerial = null

DECLARE Backup_Item_Cursor CURSOR
	FOR
	SELECT strAccountID, nMoney, WarehouseData, strSerial FROM WAREHOUSE

	OPEN Backup_Item_Cursor

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_MON_WAREHOUSE where strAccountID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_MON_WAREHOUSE (strAccountID, nMoney, warehouseData, strSerial)
		VALUES (@strUserID, @nMoney, @WarehouseData, @strWareSerial)
	END
	IF @row > 0
	BEGIN
		UPDATE BK_MON_WAREHOUSE
		SET nMoney = @nMoney, warehouseData = @WarehouseData, strSerial = @strWareSerial WHERE strAccountID = @strUserID
	END

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial
END

CLOSE Backup_Item_Cursor
DEALLOCATE Backup_Item_Cursor

3.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_SAT]    Script Date: 12/11/2021 04:55:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[BACKUP_SAT]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
declare @strUserID char(21), @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @City tinyint, @Knights smallint, @Fame tinyint
declare @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Points tinyint, @Gold int, @strSkill varchar(10), @strItem varchar(400), @strSerial varchar(400)

SET @strUserID = null SET @Rank = 0 SET @Title = 0 SET @Level = 0 SET @Exp = 0 SET @Loyalty = 0 SET @City = 0 SET @Knights = 0 SET @Fame = 0
SET @Str = 0 SET @Sta = 0 SET @Dex = 0 SET @Intel = 0 SET @Cha = 0 SET @Points = 0 SET @Gold = 0 SET @strSkill = null SET @strItem = null SET @strSerial = null

declare @row tinyint
SET @row = 0

DECLARE Backup_Cursor CURSOR
	FOR
	SELECT strUserId, Rank, Title, [Level], [Exp], Loyalty, City, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial FROM USERDATA

	OPEN Backup_Cursor

	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_SAT_USERDATA where strUserID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_SAT_USERDATA (strUserID, Rank, Title, [Level], [Exp], Loyalty, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial)
		VALUES (@strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial)
	END
	IF @row > 0 and @City <> 255
	BEGIN
		UPDATE BK_SAT_USERDATA 
		SET Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Knights = @Knights, Fame = @Fame, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Points = @Points, Gold = @Gold, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial
		WHERE strUserID = @strUserID
	END
	
	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial
END

CLOSE Backup_Cursor
DEALLOCATE Backup_Cursor

declare @nMoney int, @WarehouseData varchar(1600), @strWareSerial varchar(1600)
SET @nMoney = 0 SET @WarehouseData = null SET @strWareSerial = null

DECLARE Backup_Item_Cursor CURSOR
	FOR
	SELECT strAccountID, nMoney, WarehouseData, strSerial FROM WAREHOUSE

	OPEN Backup_Item_Cursor

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_SAT_WAREHOUSE where strAccountID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_SAT_WAREHOUSE (strAccountID, nMoney, warehouseData, strSerial)
		VALUES (@strUserID, @nMoney, @WarehouseData, @strWareSerial)
	END
	IF @row > 0
	BEGIN
		UPDATE BK_SAT_WAREHOUSE
		SET nMoney = @nMoney, warehouseData = @WarehouseData, strSerial = @strWareSerial WHERE strAccountID = @strUserID
	END

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial
END

CLOSE Backup_Item_Cursor
DEALLOCATE Backup_Item_Cursor

4.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_SUN]    Script Date: 12/11/2021 04:56:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[BACKUP_SUN]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
declare @strUserID char(21), @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @City tinyint, @Knights smallint, @Fame tinyint
declare @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Points tinyint, @Gold int, @strSkill varchar(10), @strItem varchar(400), @strSerial varchar(400)

SET @strUserID = null SET @Rank = 0 SET @Title = 0 SET @Level = 0 SET @Exp = 0 SET @Loyalty = 0 SET @City = 0 SET @Knights = 0 SET @Fame = 0
SET @Str = 0 SET @Sta = 0 SET @Dex = 0 SET @Intel = 0 SET @Cha = 0 SET @Points = 0 SET @Gold = 0 SET @strSkill = null SET @strItem = null SET @strSerial = null

declare @row tinyint
SET @row = 0

DECLARE Backup_Cursor CURSOR
	FOR
	SELECT strUserId, Rank, Title, [Level], [Exp], Loyalty, City, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial FROM USERDATA

	OPEN Backup_Cursor

	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_SUN_USERDATA where strUserID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_SUN_USERDATA (strUserID, Rank, Title, [Level], [Exp], Loyalty, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial)
		VALUES (@strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial)
	END
	IF @row > 0 and @City <> 255
	BEGIN
		UPDATE BK_SUN_USERDATA 
		SET Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Knights = @Knights, Fame = @Fame, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Points = @Points, Gold = @Gold, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial
		WHERE strUserID = @strUserID
	END
	
	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial
END

CLOSE Backup_Cursor
DEALLOCATE Backup_Cursor

declare @nMoney int, @WarehouseData varchar(1600), @strWareSerial varchar(1600)
SET @nMoney = 0 SET @WarehouseData = null SET @strWareSerial = null

DECLARE Backup_Item_Cursor CURSOR
	FOR
	SELECT strAccountID, nMoney, WarehouseData, strSerial FROM WAREHOUSE

	OPEN Backup_Item_Cursor

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_SUN_WAREHOUSE where strAccountID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_SUN_WAREHOUSE (strAccountID, nMoney, warehouseData, strSerial)
		VALUES (@strUserID, @nMoney, @WarehouseData, @strWareSerial)
	END
	IF @row > 0
	BEGIN
		UPDATE BK_SUN_WAREHOUSE
		SET nMoney = @nMoney, warehouseData = @WarehouseData, strSerial = @strWareSerial WHERE strAccountID = @strUserID
	END

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial
END

CLOSE Backup_Item_Cursor
DEALLOCATE Backup_Item_Cursor

5.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_THU]    Script Date: 12/11/2021 04:56:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[BACKUP_THU]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
declare @strUserID char(21), @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @City tinyint, @Knights smallint, @Fame tinyint
declare @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Points tinyint, @Gold int, @strSkill varchar(10), @strItem varchar(400), @strSerial varchar(400)

SET @strUserID = null SET @Rank = 0 SET @Title = 0 SET @Level = 0 SET @Exp = 0 SET @Loyalty = 0 SET @City = 0 SET @Knights = 0 SET @Fame = 0
SET @Str = 0 SET @Sta = 0 SET @Dex = 0 SET @Intel = 0 SET @Cha = 0 SET @Points = 0 SET @Gold = 0 SET @strSkill = null SET @strItem = null SET @strSerial = null

declare @row tinyint
SET @row = 0

DECLARE Backup_Cursor CURSOR
	FOR
	SELECT strUserId, Rank, Title, [Level], [Exp], Loyalty, City, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial FROM USERDATA

	OPEN Backup_Cursor

	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_THU_USERDATA where strUserID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_THU_USERDATA (strUserID, Rank, Title, [Level], [Exp], Loyalty, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial)
		VALUES (@strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial)
	END
	IF @row > 0 and @City <> 255 -- City == 255 => ID Changed User
	BEGIN
		UPDATE BK_THU_USERDATA 
		SET Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Knights = @Knights, Fame = @Fame, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Points = @Points, Gold = @Gold, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial
		WHERE strUserID = @strUserID
	END
	
	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial
END

CLOSE Backup_Cursor
DEALLOCATE Backup_Cursor

declare @nMoney int, @WarehouseData varchar(1600), @strWareSerial varchar(1600)
SET @nMoney = 0 SET @WarehouseData = null SET @strWareSerial = null

DECLARE Backup_Item_Cursor CURSOR
	FOR
	SELECT strAccountID, nMoney, WarehouseData, strSerial FROM WAREHOUSE

	OPEN Backup_Item_Cursor

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_THU_WAREHOUSE where strAccountID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_THU_WAREHOUSE (strAccountID, nMoney, warehouseData, strSerial)
		VALUES (@strUserID, @nMoney, @WarehouseData, @strWareSerial)
	END
	IF @row > 0
	BEGIN
		UPDATE BK_THU_WAREHOUSE
		SET nMoney = @nMoney, warehouseData = @WarehouseData, strSerial = @strWareSerial WHERE strAccountID = @strUserID
	END

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial
END

CLOSE Backup_Item_Cursor
DEALLOCATE Backup_Item_Cursor

6.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_TUE]    Script Date: 12/11/2021 04:56:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[BACKUP_TUE]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
declare @strUserID char(21), @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @City tinyint, @Knights smallint, @Fame tinyint
declare @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Points tinyint, @Gold int, @strSkill varchar(10), @strItem varchar(400), @strSerial varchar(400)

SET @strUserID = null SET @Rank = 0 SET @Title = 0 SET @Level = 0 SET @Exp = 0 SET @Loyalty = 0 SET @City = 0 SET @Knights = 0 SET @Fame = 0
SET @Str = 0 SET @Sta = 0 SET @Dex = 0 SET @Intel = 0 SET @Cha = 0 SET @Points = 0 SET @Gold = 0 SET @strSkill = null SET @strItem = null SET @strSerial = null

declare @row tinyint
SET @row = 0

DECLARE Backup_Cursor CURSOR
	FOR
	SELECT strUserId, Rank, Title, [Level], [Exp], Loyalty, City, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial FROM USERDATA

	OPEN Backup_Cursor

	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_TUE_USERDATA where strUserID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_TUE_USERDATA (strUserID, Rank, Title, [Level], [Exp], Loyalty, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial)
		VALUES (@strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial)
	END
	IF @row > 0 and @City <> 255
	BEGIN
		UPDATE BK_TUE_USERDATA 
		SET Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Knights = @Knights, Fame = @Fame, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Points = @Points, Gold = @Gold, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial
		WHERE strUserID = @strUserID
	END
	
	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial
END

CLOSE Backup_Cursor
DEALLOCATE Backup_Cursor

declare @nMoney int, @WarehouseData varchar(1600), @strWareSerial varchar(1600)
SET @nMoney = 0 SET @WarehouseData = null SET @strWareSerial = null

DECLARE Backup_Item_Cursor CURSOR
	FOR
	SELECT strAccountID, nMoney, WarehouseData, strSerial FROM WAREHOUSE

	OPEN Backup_Item_Cursor

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_TUE_WAREHOUSE where strAccountID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_TUE_WAREHOUSE (strAccountID, nMoney, warehouseData, strSerial)
		VALUES (@strUserID, @nMoney, @WarehouseData, @strWareSerial)
	END
	IF @row > 0
	BEGIN
		UPDATE BK_TUE_WAREHOUSE
		SET nMoney = @nMoney, warehouseData = @WarehouseData, strSerial = @strWareSerial WHERE strAccountID = @strUserID
	END

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial
END

CLOSE Backup_Item_Cursor
DEALLOCATE Backup_Item_Cursor

7.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_WED]    Script Date: 12/11/2021 04:56:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[BACKUP_WED]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
declare @strUserID char(21), @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @City tinyint, @Knights smallint, @Fame tinyint
declare @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Points tinyint, @Gold int, @strSkill varchar(10), @strItem varchar(400), @strSerial varchar(400), @strQuest varchar(400)

SET @strUserID = null SET @Rank = 0 SET @Title = 0 SET @Level = 0 SET @Exp = 0 SET @Loyalty = 0 SET @City = 0 SET @Knights = 0 SET @Fame = 0
SET @Str = 0 SET @Sta = 0 SET @Dex = 0 SET @Intel = 0 SET @Cha = 0 SET @Points = 0 SET @Gold = 0 SET @strSkill = null SET @strItem = null SET @strSerial = null SET @strQuest = null

declare @row tinyint
SET @row = 0

DECLARE Backup_Cursor CURSOR
	FOR
	SELECT strUserId, Rank, Title, [Level], [Exp], Loyalty, City, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial, strQuest FROM USERDATA

	OPEN Backup_Cursor

	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial, @strQuest

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_WED_USERDATA where strUserID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_WED_USERDATA (strUserID, Rank, Title, [Level], [Exp], Loyalty, Knights, Fame, Strong, Sta, Dex, Intel, Cha, Points, Gold, strSkill, strItem, strSerial, strQuest)
		VALUES (@strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial, @strQuest)
	END
	IF @row > 0 and @City <> 255
	BEGIN
		UPDATE BK_WED_USERDATA 
		SET Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Knights = @Knights, Fame = @Fame, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Points = @Points, Gold = @Gold, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial, strQuest = @strQuest
		WHERE strUserID = @strUserID
	END
	
	FETCH NEXT FROM Backup_Cursor INTO @strUserID, @Rank, @Title, @Level, @Exp, @Loyalty, @City, @Knights, @Fame, @Str, @Sta, @Dex, @Intel, @Cha, @Points, @Gold, @strSkill, @strItem, @strSerial, @strQuest
END

CLOSE Backup_Cursor
DEALLOCATE Backup_Cursor

declare @nMoney int, @WarehouseData varchar(1600), @strWareSerial varchar(1600)
SET @nMoney = 0 SET @WarehouseData = null SET @strWareSerial = null

DECLARE Backup_Item_Cursor CURSOR
	FOR
	SELECT strAccountID, nMoney, WarehouseData, strSerial FROM WAREHOUSE

	OPEN Backup_Item_Cursor

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial

WHILE @@FETCH_STATUS = 0
BEGIN
	select @row = count(*) from BK_WED_WAREHOUSE where strAccountID = @strUserID
	IF @row = 0 
	BEGIN
		INSERT INTO BK_WED_WAREHOUSE (strAccountID, nMoney, warehouseData, strSerial)
		VALUES (@strUserID, @nMoney, @WarehouseData, @strWareSerial)
	END
	IF @row > 0
	BEGIN
		UPDATE BK_WED_WAREHOUSE
		SET nMoney = @nMoney, warehouseData = @WarehouseData, strSerial = @strWareSerial WHERE strAccountID = @strUserID
	END

	FETCH NEXT FROM Backup_Item_Cursor INTO @strUserID, @nMoney, @WarehouseData, @strWareSerial
END

CLOSE Backup_Item_Cursor
DEALLOCATE Backup_Item_Cursor

8.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[BACKUP_ACCOUNTS_DAILY]    Script Date: 12/11/2021 04:54:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[BACKUP_ACCOUNTS_DAILY]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
BEGIN TRAN

IF NOT EXISTS (select * from sysobjects where id = object_id(N'[dbo].[BACKUP_ACCOUNTS_DAILY_LOGS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
	CREATE TABLE [dbo].[BACKUP_ACCOUNTS_DAILY_LOGS](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[Day] [varchar](255) NOT NULL CONSTRAINT [DF_BACKUP_ACCOUNTS_DAILY_LOGS_Day]  DEFAULT ((0)),
		[Date] [smalldatetime] NOT NULL CONSTRAINT [DF_BACKUP_ACCOUNTS_DAILY_LOGS_BackupDate]  DEFAULT (getdate()),
	CONSTRAINT [PK_BACKUP_ACCOUNTS_DAILY_LOGS] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
END

DECLARE @CurrentDay tinyint
SET @CurrentDay = DATEPART(dw,GETDATE())

IF @CurrentDay = 1
BEGIN
	EXEC BACKUP_SUN
	INSERT INTO BACKUP_ACCOUNTS_DAILY_LOGS (Day) VALUES ('Pazar')
END
ELSE IF @CurrentDay = 2
BEGIN
	EXEC BACKUP_MON
	INSERT INTO BACKUP_ACCOUNTS_DAILY_LOGS (Day) VALUES ('Pazartesi')
END
ELSE IF @CurrentDay = 3
BEGIN
	EXEC BACKUP_TUE
	INSERT INTO BACKUP_ACCOUNTS_DAILY_LOGS (Day) VALUES ('Salı')
END
ELSE IF @CurrentDay = 4
BEGIN
	EXEC BACKUP_WED
	INSERT INTO BACKUP_ACCOUNTS_DAILY_LOGS (Day) VALUES ('Çarşamba')
END
ELSE IF @CurrentDay = 5
BEGIN
	EXEC BACKUP_THU
	INSERT INTO BACKUP_ACCOUNTS_DAILY_LOGS (Day) VALUES ('Perşembe')
END
ELSE IF @CurrentDay = 6
BEGIN
	EXEC BACKUP_FRI
	INSERT INTO BACKUP_ACCOUNTS_DAILY_LOGS (Day) VALUES ('Cuma')
END
ELSE IF @CurrentDay = 7
BEGIN
	EXEC BACKUP_SAT
	INSERT INTO BACKUP_ACCOUNTS_DAILY_LOGS (Day) VALUES ('Cumartesi')
END

COMMIT TRAN

------------------------------------------------------------------------

8.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_DAILY]    Script Date: 12/11/2021 05:14:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[LEVEL_CHART_DAILY]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
BEGIN TRAN

IF NOT EXISTS (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_DAILY_LOGS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
	CREATE TABLE [dbo].[LEVEL_CHART_DAILY_LOGS](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[Day] [varchar](255) NOT NULL CONSTRAINT [DF_[LEVEL_CHART_DAILY_LOGS_Day]  DEFAULT ((0)),
		[Date] [smalldatetime] NOT NULL CONSTRAINT [DF_LEVEL_CHART_DAILY_LOGS_BackupDate]  DEFAULT (getdate()),
	CONSTRAINT [PK_LEVEL_CHART_DAILY_LOGS] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
END

DECLARE @CurrentDay tinyint
SET @CurrentDay = DATEPART(dw,GETDATE())

IF @CurrentDay = 1
BEGIN
	EXEC LEVEL_CHART_SUN_PROC
	INSERT INTO LEVEL_CHART_DAILY_LOGS (Day) VALUES ('Pazar')
END
ELSE IF @CurrentDay = 2
BEGIN
	EXEC LEVEL_CHART_MON_PROC
	INSERT INTO LEVEL_CHART_DAILY_LOGS (Day) VALUES ('Pazartesi')
END
ELSE IF @CurrentDay = 3
BEGIN
	EXEC LEVEL_CHART_TUE_PROC
	INSERT INTO LEVEL_CHART_DAILY_LOGS (Day) VALUES ('Salı')
END
ELSE IF @CurrentDay = 4
BEGIN
	EXEC LEVEL_CHART_WED_PROC
	INSERT INTO LEVEL_CHART_DAILY_LOGS (Day) VALUES ('Çarşamba')
END
ELSE IF @CurrentDay = 5
BEGIN
	EXEC LEVEL_CHART_THU_PROC
	INSERT INTO LEVEL_CHART_DAILY_LOGS (Day) VALUES ('Perşembe')
END
ELSE IF @CurrentDay = 6
BEGIN
	EXEC LEVEL_CHART_FRI_PROC
	INSERT INTO LEVEL_CHART_DAILY_LOGS (Day) VALUES ('Cuma')
END
ELSE IF @CurrentDay = 7
BEGIN
	EXEC LEVEL_CHART_SAT_PROC
	INSERT INTO LEVEL_CHART_DAILY_LOGS (Day) VALUES ('Cumartesi')
END

COMMIT TRAN

9.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_FRI_PROC]    Script Date: 12/11/2021 05:14:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[LEVEL_CHART_FRI_PROC]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
SET NOCOUNT ON

if exists (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_FRI]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LEVEL_CHART_FRI]
CREATE TABLE [dbo].[LEVEL_CHART_FRI] (
	[nLevel] [int]  ,
	[nCount] [int] NULL ,
) ON [PRIMARY]

declare @nLevel int
declare @nCount int
declare @nEnd int


set @nLevel = 1
set @nCount = 0
set @nEnd = 91

while @nLevel < @nEnd
begin
	select @nCount = count(*) from userdata where [level]=@nLevel
	
	insert into [LEVEL_CHART_FRI] ( nLevel, nCount ) VALUES (@nLevel, @nCount)
	
	set @nLevel = @nLevel + 1

end
 

SET NOCOUNT OFF

10.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_MON_PROC]    Script Date: 12/11/2021 05:15:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[LEVEL_CHART_MON_PROC]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
SET NOCOUNT ON

if exists (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_MON]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LEVEL_CHART_MON]
CREATE TABLE [dbo].[LEVEL_CHART_MON] (
	[nLevel] [int]  ,
	[nCount] [int] NULL ,
) ON [PRIMARY]

declare @nLevel int
declare @nCount int
declare @nEnd int


set @nLevel = 1
set @nCount = 0
set @nEnd = 91

while @nLevel < @nEnd
begin
	select @nCount = count(*) from userdata where [level]=@nLevel
	
	insert into [LEVEL_CHART_MON] ( nLevel, nCount ) VALUES (@nLevel, @nCount)
	
	set @nLevel = @nLevel + 1

end
 

SET NOCOUNT OFF

11.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_SAT_PROC]    Script Date: 12/11/2021 05:15:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[LEVEL_CHART_SAT_PROC]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
SET NOCOUNT ON

if exists (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_SAT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LEVEL_CHART_SAT]
CREATE TABLE [dbo].[LEVEL_CHART_SAT] (
	[nLevel] [int]  ,
	[nCount] [int] NULL ,
) ON [PRIMARY]

declare @nLevel int
declare @nCount int
declare @nEnd int


set @nLevel = 1
set @nCount = 0
set @nEnd = 91

while @nLevel < @nEnd
begin
	select @nCount = count(*) from userdata where [level]=@nLevel
	
	insert into [LEVEL_CHART_SAT] ( nLevel, nCount ) VALUES (@nLevel, @nCount)
	
	set @nLevel = @nLevel + 1

end
 

SET NOCOUNT OFF

12.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_SUN_PROC]    Script Date: 12/11/2021 05:15:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[LEVEL_CHART_SUN_PROC]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
SET NOCOUNT ON

if exists (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_SUN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LEVEL_CHART_SUN]
CREATE TABLE [dbo].[LEVEL_CHART_SUN] (
	[nLevel] [int]  ,
	[nCount] [int] NULL ,
) ON [PRIMARY]

declare @nLevel int
declare @nCount int
declare @nEnd int


set @nLevel = 1
set @nCount = 0
set @nEnd = 91

while @nLevel < @nEnd
begin
	select @nCount = count(*) from userdata where [level]=@nLevel
	
	insert into [LEVEL_CHART_SUN] ( nLevel, nCount ) VALUES (@nLevel, @nCount)
	
	set @nLevel = @nLevel + 1

end
 

SET NOCOUNT OFF

12.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_THU_PROC]    Script Date: 12/11/2021 05:15:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[LEVEL_CHART_THU_PROC]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
SET NOCOUNT ON

if exists (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_THU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LEVEL_CHART_THU]
CREATE TABLE [dbo].[LEVEL_CHART_THU] (
	[nLevel] [int]  ,
	[nCount] [int] NULL ,
) ON [PRIMARY]

declare @nLevel int
declare @nCount int
declare @nEnd int


set @nLevel = 1
set @nCount = 0
set @nEnd = 91

while @nLevel < @nEnd
begin
	select @nCount = count(*) from userdata where [level]=@nLevel
	
	insert into [LEVEL_CHART_THU] ( nLevel, nCount ) VALUES (@nLevel, @nCount)
	
	set @nLevel = @nLevel + 1

end
 

SET NOCOUNT OFF

13.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_TUE_PROC]    Script Date: 12/11/2021 05:16:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[LEVEL_CHART_TUE_PROC]
AS
/*
Author : AKUMA
E-Mail : [email protected]
*/
SET NOCOUNT ON

if exists (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_TUE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LEVEL_CHART_TUE]
CREATE TABLE [dbo].[LEVEL_CHART_TUE] (
	[nLevel] [int]  ,
	[nCount] [int] NULL ,
) ON [PRIMARY]

declare @nLevel int
declare @nCount int
declare @nEnd int


set @nLevel = 1
set @nCount = 0
set @nEnd = 91

while @nLevel < @nEnd
begin
	select @nCount = count(*) from userdata where [level]=@nLevel
	
	insert into [LEVEL_CHART_TUE] ( nLevel, nCount ) VALUES (@nLevel, @nCount)
	
	set @nLevel = @nLevel + 1

end
 

SET NOCOUNT OFF

14.Adım

Kod:

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[LEVEL_CHART_WED_PROC]    Script Date: 12/11/2021 05:16:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Object:  Stored Procedure dbo.LEVEL_CHART_WED_PROC    Script Date: 6/6/2006 6:03:32 PM ******/

ALTER PROCEDURE [dbo].[LEVEL_CHART_WED_PROC] AS

SET NOCOUNT ON

if exists (select * from sysobjects where id = object_id(N'[dbo].[LEVEL_CHART_WED]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LEVEL_CHART_WED]
CREATE TABLE [dbo].[LEVEL_CHART_WED] (
	[nLevel] [int]  ,
	[nCount] [int] NULL ,
) ON [PRIMARY]

declare @nLevel int
declare @nCount int
declare @nEnd int


set @nLevel = 1
set @nCount = 0
set @nEnd = 91

while @nLevel < @nEnd
begin
	select @nCount = count(*) from userdata where [level]=@nLevel
	
	insert into [LEVEL_CHART_WED] ( nLevel, nCount ) VALUES (@nLevel, @nCount)
	
	set @nLevel = @nLevel + 1

end
 

SET NOCOUNT OFF

BU KODLAR BİTTİ. ŞİMDİ DB YE UYGULAYACAĞIMIZ KOD.

Kod:

USE [Kn_ONLİNE]
GO
/****** Object:  StoredProcedure [dbo].[EVERY_DAILY]    Script Date: 12/11/2021 04:45:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[EVERY_DAILY]
AS
BEGIN TRAN

-- ROLLBACK SYSTEM
EXEC KO_S1.dbo.BACKUP_ACCOUNTS_DAILY

-- LEVEL CHART DAILY
EXEC KO_S1.dbo.LEVEL_CHART_DAILY

COMMIT TRAN

BU KODU HERGÜN 1 DEFA QA DA ÇALIŞTIRIN.

vALLA BU KADAR YAPTIM UMARIM BEĞENİRSİNİZ Bİ TEŞEKKÜR EDERSİNİZ..

BU PAYLAŞIMI KULLANIPTA YORUM VE TEŞEKKÜR ETMEYEN AJDARDIR(BAŞKA BEDDUA BULAMADIM

)
EMEK KARSILIĞI +REP

Bakalım yapan varmı ;

zorromania · 23 May 2009

Cevap: Akuma rolback sistemi paylasım

emeğine ve ellerine sağlık

nurullah_ben · 24 May 2009

Cevap: Akuma rolback sistemi paylasım

güzel emeğe saygı

ForDiedAnDLivE · 24 May 2009

Cevap: Akuma rolback sistemi paylasım

kardeşim ben bunu ztn paylaştım sitede benden alıntı yapmışsın konunun adı bile aynı.. ayıptır..

pala · 24 May 2009

Cevap: Akuma rolback sistemi paylasım

upsssssssssssss

ßu®нαη · 24 May 2009

Cevap: Akuma rolback sistemi paylasım

Paylaşım Güzel ama biraz sitedeki paylaşımlara bakarak konu açsaydın daha güzel olurdu emeğe saygı duyalım genede teşekkürler.

ByRuB1 · 24 May 2009

Cevap: Akuma rolback sistemi paylasım

Paylaşım Güzel Ama Harbi Uzun

onurdinyo · 24 May 2009

Cevap: Akuma rolback sistemi paylasım

hehehe uzunmus ama deger akumanın ve paylasan herkezin ellerine saglık

h3ra · 25 May 2009

Cevap: Akuma rolback sistemi paylasım

upppppppppppppp

KoDestekGm · 25 May 2009

Cevap: Akuma rolback sistemi paylasım

yorumlar icin tesekkurler

agrement · 12 Ağu 2009

Cevap: Akuma rolback sistemi paylasım

Güzel Paylaşım Sağol

Zibidi · 12 Ağu 2009

Cevap: Akuma rolback sistemi paylasım

Alıntı Yapmasını Biliyorsunuz ama nasıl çalıştığını bilmiyosunuz. nasıl çalıştığını da anlatsan güzel olur.

2Pac · 12 Ağu 2009

Cevap: Akuma rolback sistemi paylasım

teşekkürler ezih emre

MrDeMoNLoRD · 13 Ağu 2009

Cevap: Akuma rolback sistemi paylasım

Emeğe Saygı TeşekkürLer . . .

by_bts · 13 Ağu 2009

Cevap: Akuma rolback sistemi paylasım

Eklerken DB nize Hata Verecektir ! KO_S1 Bolumlerini Kendi Db'nize Göre Ayarlayınız Ayrıca Eksik Proclar var Tek bununla bitmiyor !

Akuma rolback sistemi paylasım

KoDestekGm

New Member

zorromania

Member

nurullah_ben

SS Bilisim ve İnternet

ForDiedAnDLivE

New Member

pala

New Member

ßu®нαη

Database EditöR

ByRuB1

BeDawa Server Kurulur...!

onurdinyo

Member

h3ra

Member

KoDestekGm

New Member

agrement

Active Member

Zibidi

New Member

2Pac

Member

MrDeMoNLoRD

• Helper Cüce •

by_bts

Member

Online istatistikleri

About Us

En yeni üyeler

Akuma rolback sistemi paylasım

New Member

Member

SS Bilisim ve İnternet

New Member

New Member

**Database EditöR**

BeDawa Server Kurulur...!

Member

Member

New Member

Active Member

New Member

Member

• Helper Cüce •

Member

Online istatistikleri

About Us

En yeni üyeler

Stay Connected

Database EditöR