doyouwhisperurname
Yeni Üye
Yaş : 30
Kayıt tarihi : 12/11/08
Mesaj Sayısı : 101
Nerden :
|
Konu: Gs , Fb Launcher Pelerin İşaret Halkasi vesaire.. C.tesi Kas. 15, 2008 9:36 am |
|
|
Yepyeni LauncherLar
GALATASARAY Link= http://www.mediafire.com/?ganfodm4zel
FENERBAHCE Link= http://www.mediafire.com/?inhnnwanjya
Usko Launcher...!! Link= http://www.mediafire.com/?n3jmvkjjqqk
Taraftar Pelerinleri..! Gs Pelerin..! Link= http://www.mediafire.com/?hmgdxmgnyoo
Fb Pelerin..! Link= http://www.mediafire.com/?wzgmeqtt5ao
Bjk Pelerin..!! Link= http://www.mediafire.com/?zjdxwzm0zjj
Yeni İşaret Halkası..!!
Link= http://www.dosya.tc/YeniTargetSymbol.zip.html
Beyler Resimli gosteremiyom Ama super bisi ben bunlardan kullanıyom
%70 Türkçe Menü..!! Link= http://www.mediafire.com/?zgqzqy0wwxb
Oyunun İçine Kullanıcı Sıralaması Ekleme
Db'ye Eklenecek Kodlar..!
Kod: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CLAN_SIRALAMA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CLAN_SIRALAMA] GO
Kod
CREATE TABLE [dbo].[CLAN_SIRALAMA] ( [ClanName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Sira] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ) ON [PRIMARY] GO
Kod CREATE TABLE [dbo].[KULLANICI_SIRALAMA] ( [KullaniciName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Loyalty] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Sira] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ) ON [PRIMARY] GO
Query Analyzer'e Yazılacak..!
Kod insert into k_npc values (2541 , '[Kullanici Siralamasi]' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2542 , '[1.] sadasd ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2543 , '[2.] essss ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2544 , '[3.] ArdreamKinq ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2545 , '[4.] Asd ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2546 , '[5.] arefasfa ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2547 , '[Clan Siralamasi]' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2548 , '[1.] Tottle ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2549 , '[2.] Gns ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2550 , '[3.] Ganks ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2556 , '[4.] asd ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0) insert into k_npc values (2557 , '[5.] fOREveR ' , 11000 , 100 , 150210000 , 170210000 , 1 , 5 , 11 , 1 , 1 , 1 , 0 , 60 , 0 , 0 , 6000 , 0 , 0 , 3000 , 194 , 194 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 3000 , 90 , 7 , 14 , 35 , 0 , 0 , 0 , 0 , 0)
Kod Kod insert into k_npcpos values (21 , 2541 , 103 , 0 , 0 , 0 , 0 , 364 , 369 , 364 , 369 , 364 , 369 , 364 , 369 , 1 , 3600 , 0 , 3 , '0364036903640369') insert into k_npcpos values (21 , 2542 , 103 , 0 , 0 , 0 , 0 , 366 , 368 , 366 , 368 , 366 , 368 , 366 , 368 , 1 , 3600 , 0 , 3 , '0366036803660368') insert into k_npcpos values (21 , 2543 , 103 , 0 , 0 , 0 , 0 , 367 , 369 , 367 , 369 , 367 , 369 , 367 , 369 , 1 , 3600 , 0 , 3 , '0367036903670369') insert into k_npcpos values (21 , 2544 , 103 , 0 , 0 , 0 , 0 , 367 , 370 , 367 , 370 , 367 , 370 , 367 , 370 , 1 , 3600 , 0 , 3 , '0367037003670370') insert into k_npcpos values (21 , 2545 , 103 , 0 , 0 , 0 , 0 , 366 , 366 , 366 , 366 , 366 , 366 , 366 , 366 , 1 , 3600 , 0 , 3 , '0366036603660366') insert into k_npcpos values (21 , 2546 , 103 , 0 , 0 , 0 , 0 , 366 , 365 , 366 , 365 , 366 , 365 , 366 , 365 , 1 , 3600 , 0 , 3 , '0366036503660365')
Kod insert into k_npcpos values (21 , 2547 , 103 , 0 , 0 , 0 , 0 , 376 , 396 , 376 , 396 , 376 , 396 , 376 , 396 , 1 , 3600 , 0 , 3 , '0376039603760396') insert into k_npcpos values (21 , 2548 , 103 , 0 , 0 , 0 , 0 , 377 , 396 , 377 , 396 , 377 , 396 , 377 , 396 , 1 , 3600 , 0 , 3 , '0376039603760396') insert into k_npcpos values (21 , 2549 , 103 , 0 , 0 , 0 , 0 , 377 , 397 , 377 , 397 , 377 , 397 , 377 , 397 , 1 , 3600 , 0 , 3 , '0377039603770396') insert into k_npcpos values (21 , 2550 , 103 , 0 , 0 , 0 , 0 , 378 , 398 , 378 , 398 , 378 , 398 , 378 , 398 , 1 , 3600 , 0 , 3 , '0378039803780398') insert into k_npcpos values (21 , 2556 , 103 , 0 , 0 , 0 , 0 , 378 , 399 , 378 , 399 , 378 , 399 , 378 , 399 , 1 , 3600 , 0 , 3 , '0378039903780399') insert into k_npcpos values (21 , 2557 , 103 , 0 , 0 , 0 , 0 , 375 , 395 , 375 , 395 , 375 , 395 , 375 , 395 , 1 , 3600 , 0 , 3 , '0375039503750395')
Kod CREATE PROCEDURE [dbo].[oyuniciguncelle] AS
begin begin transaction truncate table clan_siralama truncate table kullanici_siralama insert kullanici_siralama (kullaniciname, loyalty) select top 5 struserid, loyalty from userdata order by loyalty desc, loyaltymonthly desc, [level] asc exec oyunicikullanici if @@ERROR != 0 begin rollback transaction return end else begin commit transaction return end end
begin begin transaction insert clan_siralama (clanname) select top 5 idname from knights order by points desc, members asc if @@ERROR != 0 begin rollback transaction return end else begin commit transaction return end end
update k_npc set StrName = '[1.] '+(select ClanName from clan_siralama where Sira = 1) where sSid = 2548 update k_npc set StrName = '[2.] '+(select ClanName from clan_siralama where Sira = 2) where sSid = 2549 update k_npc set StrName = '[3.] '+(select ClanName from clan_siralama where Sira = 3) where sSid = 2550 update k_npc set StrName = '[4.] '+(select ClanName from clan_siralama where Sira = 4) where sSid = 2556 update k_npc set StrName = '[5.] '+(select ClanName from clan_siralama where Sira = 5) where sSid = 2557 update k_npc set StrName = '[1.] '+(select KullaniciName from kullanici_siralama where Sira = 1) where sSid = 2542 update k_npc set StrName = '[2.] '+(select KullaniciName from kullanici_siralama where Sira = 2) where sSid = 2543 update k_npc set StrName = '[3.] '+(select KullaniciName from kullanici_siralama where Sira = 3) where sSid = 2544 update k_npc set StrName = '[4.] '+(select KullaniciName from kullanici_siralama where Sira = 4) where sSid = 2545 update k_npc set StrName = '[5.] '+(select KullaniciName from kullanici_siralama where Sira = 5) where sSid = 2546
GO
NE kadar İşinize Yarar Bilmiyom Ama Emek verdim en azından olumsuz Yorum Yapmayın |
|