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 538 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..





 
Üst Alt