Bilgi Bankası

Knight Online 1299 - Soacs-ZirveSoacs | Timecore.cpp Hatası Çözümü - Fix Query Kodu

Knight Online - Soacs | ZirveSoacs | TimeCore.cpp Hatası Giderme Query Kodu 1299


Öncelikle sunucunuza uzak masaüstü bağlantısı yapınız. Eğer bağlantı yapmayı bilmiyorsanız buradan öğrenebilirsiniz.

Sunucunuzda masaüstün'de bulunan Query Analyzer adlı programı çalıştırın, daha sonrasında karşınıza çıkan pencere aşağıdaki resimdeki gibi olacaktır aynı şekilde yapıp ok diyoruz.

Knight Online
Daha sonrasında sağ üstteki master yazısına tıklayıp kn_online adlı veritabanını seçiyoruz. Knight Online
Programdaki yani query analyzer programındaki beyaz alana aşağıda verdiğimiz query kodunu giriyoruz ve bir kere F5 tuşuna basıyorsunuz. Knight Online
Knight Online, private serverinizi zirvesunucum'dan aldıysanız uygulayabileceğiniz gereken kod :
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER_KNIGHTS_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[USER_KNIGHTS_RANK]
GO

CREATE TABLE [dbo].[USER_KNIGHTS_RANK] (
	[shIndex] [smallint] NOT NULL ,
	[strName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[strElmoUserID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[strElmoKnightsName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[nElmoLoyalty] [int] NULL ,
	[strKarusUserID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[strKarusKnightsName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[nKarusLoyalty] [int] NULL ,
	[nMoney] [int] NOT NULL 
) ON [PRIMARY]
GO

INSERT INTO USER_KNIGHTS_RANK VALUES ( 1, 'Gold', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 2, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 3, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 4, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 5, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 6, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 7, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 8, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 9, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 10, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 11, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 12, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 13, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 14, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 15, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 16, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 17, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 18, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 19, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 20, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 21, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 22, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 23, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 24, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 25, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 26, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 27, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 28, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 29, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 30, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 31, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 32, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 33, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 34, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 35, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 36, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 37, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 38, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 39, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 40, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 41, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 42, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 43, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 44, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 45, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 46, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 47, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 48, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 49, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 50, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 51, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 52, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 53, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 54, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 55, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 56, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 57, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 58, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 59, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 60, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 61, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 62, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 63, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 64, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 65, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 66, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 67, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 68, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 69, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 70, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 71, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 72, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 73, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 74, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 75, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 76, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 77, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 78, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 79, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 80, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 81, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 82, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 83, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 84, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 85, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 86, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 87, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 88, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 89, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 90, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 91, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 92, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 93, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 94, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 95, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 96, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 97, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 98, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 99, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 100, 'Training', null, null, 0, null, null, 0, 0);

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER_PERSONAL_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[USER_PERSONAL_RANK]
GO

CREATE TABLE [dbo].[USER_PERSONAL_RANK] (
	[nRank] [smallint] NOT NULL ,
	[strPosition] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[nElmoUP] [smallint] NOT NULL ,
	[strElmoUserID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[nElmoLoyaltyMonthly] [int] NULL ,
	[nElmoCheck] [int] NOT NULL ,
	[nKarusUP] [smallint] NOT NULL ,
	[strKarusUserID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[nKarusLoyaltyMonthly] [int] NULL ,
	[nKarusCheck] [int] NOT NULL ,
	[nSalary] [int] NOT NULL ,
	[UpdateDate] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO


INSERT INTO USER_PERSONAL_RANK VALUES ( 1, 'Gold',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 2, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 3, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 4, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 5, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 6, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 7, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 8, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 9, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 10, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 11, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 12, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 13, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 14, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 15, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 16, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 17, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 18, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 19, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 20, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 21, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 22, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 23, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 24, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 25, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 26, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 27, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 28, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 29, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 30, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 31, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 32, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 33, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 34, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 35, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 36, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 37, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 38, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 39, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 40, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 41, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 42, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 43, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 44, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 45, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 46, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 47, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 48, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 49, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 50, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 51, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 52, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 53, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 54, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 55, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 56, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 57, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 58, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 59, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 60, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 61, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 62, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 63, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 64, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 65, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 66, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 67, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 68, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 69, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 70, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 71, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 72, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 73, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 74, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 75, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 76, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 77, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 78, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 79, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 80, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 81, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 82, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 83, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 84, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 85, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 86, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 87, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 88, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 89, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 90, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 91, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 92, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 93, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 94, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 95, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 96, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 97, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 98, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 99, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 100, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());

truncate TABLE KING_SYSTEM

insert into [KING_SYSTEM] values ('1','7','2002','5','4','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','10','2100000016','2100000064','[ZirveSunucum.com]','NULL')
insert into [KING_SYSTEM] values ('2','7','2002','5','4','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','494030753','10','2100012599','2100050399','[zirvesunucum.com]','NULL')

  • 2 Bu dökümanı faydalı bulan kullanıcılar:
Bu cevap yeterince yardımcı oldu mu?

Knight Online - 1299 - Guard Tower Damage (Atak) Oranini Guncelleme Degistirme

Knight Online - Guard Tower Damage (Atak) Ayarları Öncelikle sunucunuza uzak masaüstü...

Knight Online - 1299 - GM Event, GM Tıklanabilir Yapma

Bu kodu SQL Server'de uygulayıp, karakterinizi tıklanabilir hale getirebilirsiniz, bu kodu...

Knight Online - 1299 - Banlanan Kullanıcıların NP'lerini Sıfırlama

Knight Online - Banlanan Kullanıcıların NP Sıfırlama Öncelikle sunucunuza uzak masaüstü...

Knight Online - 1299 - Soacs & ZirveSoacs - GM Kodlari

/// Gm Kodları : Bilinen ve Bilinmeyen Komutlar \\\ Açıklamaları ile birlikte yazılmıştır,...

Knight Online - 1299 - Butun Droplari Sifirlama Query Kodu

Knight Online - Bütün Dropları Sıfırlama Query Kodu Öncelikle sunucunuza uzak masaüstü...

E-Bülten

Yeniliklerden ve kampanyalardan haberdar olmak için e-bülten'e mail adresinizi paylaşın!