Merhaba Ziyaretçi
Forumumuza hoşgeldiniz.Sitemizi daha yararlı şekilde kullanabilmek için lütfen kayıt olun veya giriş yapın.

Tamamiyle Fixlenmiş En Düzgün Kareli ve Karesiz NP Simgesi

Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Prosedür & Kod Paylaşımları kategorisinde Stark tarafından oluşturulan Tamamiyle Fixlenmiş En Düzgün Kareli ve Karesiz NP Simgesi başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 583 kez görüntülenmiş, 0 yorum ve 0 tepki puanı almıştır...
Kategori Adı Prosedür & Kod Paylaşımları
Konu Başlığı Tamamiyle Fixlenmiş En Düzgün Kareli ve Karesiz NP Simgesi
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan Stark

Stark

K.Destek Yöneticisi
27 May 2013
2,664
0
Selam Sorunsuzdur Arkadaşlar Dikkatlice Yaparsanız Sorun Çıkmaz











Öncelikle Procedurelerden



USER_KNIGHTS_RATING_UPDATE ve UPDATE_PERSONAL_RANK



Bunları Siliyoruz...







SQL Query Analizeri Açıyorsunuz










Kod:

TRUNCATE TABLE USER_KNIGHTS_RANK

TRUNCATE TABLE USER_PERSONAL_RANK

USER_KNIGHTS_RANK Tablomuza Yeni Bir Sütün Ekliyoruz









Kod:

ALTER TABLE USER_KNIGHTS_RANK ADD UpdateDate smalldatetime NOT NULL DEFAULT getdate();

Sonra Her İki Irkın İlk 100 Rank ını Alabilmek İçin Bu Tabloları Oluşturuyoruz..









Kod:

CREATE TABLE [dbo].[ELMORAD_USER_RANK](

[nRank] [int] IDENTITY(1,1) NOT NULL,

[strUserID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Loyalty] [int] NOT NULL,

[LoyaltyMonthly] [int] NOT NULL,

[nRankUp] [int] NOT NULL

) ON [PRIMARY]



CREATE TABLE [dbo].[KARUS_USER_RANK](

[nRank] [int] IDENTITY(1,1) NOT NULL,

[strUserID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Loyalty] [int] NOT NULL,

[LoyaltyMonthly] [int] NOT NULL,

[nRankUp] [int] NOT NULL

) ON [PRIMARY]





USER Rank Tablolarımız Oluşmuştur.







Şimdi Yukarıda Boşalttığımız USER_KNIGHTS_RANK ı Dolduruyoruz.










Kod:

INSERT INTO USER_KNIGHTS_RANK VALUES ( 1, 'Gold', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 2, 'Silver', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 3, 'Silver', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 4, 'Silver', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 5, 'Mirage', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 6, 'Mirage', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 7, 'Mirage', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 8, 'Mirage', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 9, 'Mirage', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 10, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 11, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 12, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 13, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 14, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 15, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 16, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 17, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 18, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 19, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 20, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 21, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 22, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 23, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 24, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 25, 'Shadow', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 26, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 27, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 28, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 29, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 30, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 31, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 32, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 33, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 34, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 35, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 36, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 37, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 38, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 39, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 40, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 41, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 42, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 43, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 44, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 45, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 46, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 47, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 48, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 49, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 50, 'Mist', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 51, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 52, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 53, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 54, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 55, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 56, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 57, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 58, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 59, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 60, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 61, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 62, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 63, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 64, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 65, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 66, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 67, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 68, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 69, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 70, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 71, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 72, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 73, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 74, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 75, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 76, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 77, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 78, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 79, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 80, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 81, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 82, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 83, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 84, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 85, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 86, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 87, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 88, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 89, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 90, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 91, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 92, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 93, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 94, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 95, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 96, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 97, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 98, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 99, 'Training', null, null, 0, null, null, 0, 0, getdate() );

INSERT INTO USER_KNIGHTS_RANK VALUES ( 100, 'Training', null, null, 0, null, null, 0, 0, getdate() );

USER_PERSONAL_RANK ımızıda Dolduruyoruz..









Kod:

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()) ;

Şimdi Geldik Procedurelerimizi Oluşturmaya







USER_KNIGHTS_RATING_UPDATE









Kod:

CREATE PROCEDURE [dbo].[USER_KNIGHTS_RATING_UPDATE]

AS

/*

Author : Ceribrio

*/

DECLARE @tUpdateDate SMALLDATETIME



set @tupdatedate = getdate()



truncate table KARUS_USER_RANK

insert KARUS_USER_RANK

select top 100 strUserID, Loyalty, LoyaltyMonthly, 101

from USERDATA

where Nation = 1 and Authority = '1'

order by Loyalty desc



truncate table ELMORAD_USER_RANK

insert ELMORAD_USER_RANK

select top 100 strUserID, Loyalty, LoyaltyMonthly, 101

from USERDATA

where Nation = 2 and Authority = '1'

order by Loyalty desc



UPDATE KARUS_USER_RANK

Set nRankUP = R.shIndex - KARUS_USER_RANK.nRank

from USER_KNIGHTS_RANK R

where R.strKarusUserID = KARUS_USER_RANK.strUserID



UPDATE ELMORAD_USER_RANK

Set nRankUP = R.shIndex - ELMORAD_USER_RANK.nRank

from USER_KNIGHTS_RANK R

where R.strElmoUserID = ELMORAD_USER_RANK.strUserID





INSERT INTO USER_KNIGHTS_RANK

SELECT E.nRank, R.strName, E.strUserID, (select idname from knights where idnum = (select knights from userdata where struserid = E.strUserID)),E.Loyalty,K.strUserID,

(select idname from knights where idnum = (select knights from userdata where struserid = K.strUserID)),K.Loyalty,0,@tUpdateDate

from ELMORAD_USER_RANK E, KARUS_USER_RANK K, USER_KNIGHTS_RANK R

WHERE (E.nRank = K.nRank AND E.nRank = R.shIndex and R.UpdateDate < @tUpdateDate)

ORDER BY E.nRank



DELETE FROM USER_KNIGHTS_RANK

WHERE UpdateDate < @tUpdateDate

UPDATE_PERSONAL_RANK Proceduresi









Kod:

CREATE PROCEDURE [dbo].[UPDATE_PERSONAL_RANK]

AS

/*

Author : Ceribrio

*/

DECLARE @tUpdateDate SMALLDATETIME



set @tupdatedate = getdate()



truncate table KARUS_USER_RANK

insert KARUS_USER_RANK

select top 100 strUserID, Loyalty, LoyaltyMonthly, 101

from USERDATA

where Nation = 1 and Authority = '1'

order by LoyaltyMonthly desc



truncate table ELMORAD_USER_RANK

insert ELMORAD_USER_RANK

select top 100 strUserID, Loyalty, LoyaltyMonthly, 101

from USERDATA

where Nation = 2 and Authority = '1'

order by LoyaltyMonthly desc



UPDATE KARUS_USER_RANK

Set nRankUP = R.nRank - KARUS_USER_RANK.nRank

from USER_PERSONAL_RANK R

where R.strKarusUserID = KARUS_USER_RANK.strUserID



UPDATE ELMORAD_USER_RANK

Set nRankUP = R.nRank - ELMORAD_USER_RANK.nRank

from USER_PERSONAL_RANK R

where R.strElmoUserID = ELMORAD_USER_RANK.strUserID





INSERT INTO USER_PERSONAL_RANK

select E.nRank, R.strPosition, E.nRankUP, E.strUserID, E.LoyaltyMonthly, R.nSalary, K.nRankUP, K.strUserID, K.LoyaltyMonthly, R.nSalary, R.nSalary, @tUpdateDate

from ELMORAD_USER_RANK E, KARUS_USER_RANK K, USER_PERSONAL_RANK R

WHERE (E.nRank = K.nRank AND E.nRank = R.nRank and R.UpdateDate < @tUpdateDate)

ORDER BY E.nRank



DELETE FROM USER_PERSONAL_RANK

WHERE UpdateDate < @tUpdateDate

Evet Geçmiş Olsun







Gel Gelelim Bize Faydalarına








1. GM ler ve Banlı Çarlar Kesinlikle Kareli veya Karesiz NP Simgesi Alamıyor.



2. İlk 100 e Simge Gelmektedir Kareli ve Karesiz Olarak.



3. Kesinlikle Hatasızdır Mükemmel Çalışmaktadır.







NOT : Eğer USERDATA nızda Hem Karusta Hem Elmorad User Olarak 100 e Ulaşmamışsa Kullanmayınız Sistem Bozulabilir Kısacası Human Oyuncu Sayısı Min 100 Karus Oyuncu Sayısıda Min 100 ise Çalıştırınız DB deki Çar Sayısından Bahsediyorum







İsteğe Göre SQL Agent a Job Olarak Ekleyebilir









Kod:

EXEC USER_KNIGHTS_RATING_UPDATE

EXEC UPDATE_PERSONAL_RANK

Genel Açıklama : Elle Birşey Girmiyoruz Tek Olması Gereken Şart 100 Human ve 100 Karus Char Olması Eğer Bunun Altında Varsa Sistem Bozulur Nasıl Bozulur Sadece O Anki ORC ları Oraya Dizer Humanları Dizer İlk 20 İlk 30 Ne Varsa Ondan Devam Eder Düzeltmek İsterseniz









Kod:

TRUNCATE TABLE USER_KNIGHTS_RANK

TRUNCATE TABLE USER_PERSONAL_RANK

Sonra İnsert USER_KNIGHTS_RANK ve PERSONAL_RANK leri Yapınız



Düzelir.







Tabi 100 ORC/Human şart Yine Ben Bozanlar İçin Dedim Sadece








Arkadaşlar Elle Birşey Girmiyorsunuz EXEC leri SQL Zamanlanmış Görevlere Ekleyin O Kadar







100 Kullanıcı Olmassa Sorun Çıkarır Diğer Kayıtları Komple Siler Gider 20 Kullanıcıysa O Kadar Kullanıcı yı Alır Deneyin Görün..











Konu Servertanitimi.NeT Forumundan Alınmıştır Yani Abimin Forumundan,
 
Üst Alt