BÜTÜN Q.A kodları

**tarafından Admin Perş. Tem. 17, 2008 11:58 am**

Admin: Yönetici; Mesaj Sayısı : 677
Yaş : 33
Nerden : çanakkale
İş/Hobiler : öğrenci
Lakap : webci
Ruh Hali :
işletim sistemin :
Seviye :
Madalyaların :
Metin Alanı : Vatanını Seven Görevini En İyi Yapandı®.ElitSepet TeaM<<<< YÖNETİCİ
Sanal Hayvan :
Rap Derecesi :
Kayıt tarihi : 15/07/08

Rap Puanın
Aktiflik:
(4999/5000)
Başarı puanı:
(98787/98787)
Güçlülük :
(4999/5000)

Post n°1

BÜTÜN Q.A kodları

tarafından Admin Perş. Tem. 17, 2008 11:58 am

90/1 Yapma
Kod:

Kod:

update LEVEL_UP set Exp = '1'

--------------------------------------------------
Bütün İtemlerin Ağılık İstememesi
Kod:

Kod:

update ITEM set Weight = '0'

--------------------------------------------------
Npc + larını Belirleme Ordaki 199009 sonunda 9 +9 oluo 7 yaparsanız +7 olur...
Kod:

Kod:

update K_NPC set iSellingGroup = '199009' where strName = 'Npc İsmi'

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

NCS SCripti
Kod:

Kod:

Exec NameChange 'EskiIsim', 'YeniIsim'

--------------------------------------------------
TB_Userdan Kısa Acc silme

Kod:

delete from tb_user where straccountid = 'char ismi'

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

Magicden Kısa Skill Silmesi ......

Kod:

delete from magic where magicnum = 'skill kodu'

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

Sadece Server I. Karus ve I.El moya [D] sembol ekleme

Kod:

Kod:

CREATE PROCEDURE np_icon AS DECLARE --This script has been made by BERKİN GÜLER in 12.09.2007 --Bu script BERKİN GÜLER tarafından 12.09.2007 tarihinde yapılmıştır @berkin varchar(100), @cigdm varchar(100), @i int BEGIN TRANSACTION SELECT @berkin=strUserID FROM USERDATA WHERE Nation = '1' ORDER BY Loyalty UPDATE USERDATA SET strUserID = '[D]' + @berkin WHERE strUserID = @berkin SELECT @cigdm=strUserID FROM USERDATA WHERE Nation = '2' ORDER BY Loyalty UPDATE USERDATA SET strUserID = '[D]' + @cigdm WHERE strUserID = @cigdm IF @@error<>0 begin rollback transaction print 'Hata oluştu!' end else begin print 'ICON EKLEME ISLEMI BASARILI.' print @berkin + 've' + @cigdm + ',' + '[D]' + @berkin + 've' + '[D]' + @cigdm + 'olarak degistirildi!' end COMMIT TRANSACTION GO

--------------------------------------------------
Char Tahttan Kalkmıyor Diyenler için Sql Scripti
Kod:

Kod:

insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','1500 0','2','101','Dark Lunar') insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','1500 0','2','0','BATTLE_ZONE???') insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000' ,'2','0','Colony Zone') update ZONE_INFO set ServerNo = '1'

--------------------------------------------------
Charı Gm Yapma Scripti
Kod:

Kod:

update userdata set Authority = '0' where struserid = 'Karakter ismi'

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

Charı Normal Char Yapma Scripti
Kod:

Kod:

update userdata set Authority = '1' where struserid = 'Karakter İsmi'

--------------------------------------------------
Charı Banlama Scripti
Kod:

Kod:

update userdata set Authority = '255' where struserid = 'Karakter İsmi'

--------------------------------------------------
AC Kıyafetleri DB'den Kaldırmak:

Kod:

Database'den Item_Ext 13, 14, 15, 16 ve 17 Tablolarından :

Kod:

41-50 Arasını => 41 Ve 50 Dahil 71-80 Arasını => 71 Ve 80 Dahil 541-550 Arasını => 541 Ve 550 Dahil 304-309 Arasını => 304 Ve 309 Dahil 313-318 Arasını => 313 Ve 318 Dahil 322-327 Arasını => 322 Ve 327 Dahil 331-336 Arasını => 331 Ve 336 Dahil hepsini siLiniz!

--------------------------------------------------
NCS Aktif etmek için

Kod:

Kod:

create procedure [NameChange] (@oldname varchar(30),@newname varchar(30)) AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2) begin tran Update account_char set strcharid1 = @newname where strcharid1 = @oldname Update account_char set strcharid2 = @newname where strcharid2 = @oldname Update account_char set strcharid3 = @newname where strcharid3 = @oldname Update userdata set struserid = @newname Where struserid = @oldname Update knights_user set struserid = @newname Where struserid = @oldname Update knights set chief = @newname where chief = @oldname Update knights set vicechief_1 = @newname where vicechief_1 = @oldname Update knights set vicechief_2 = @newname where vicechief_2 = @oldname Update knights set vicechief_3 = @newname where vicechief_3 = @oldname commit tran

--------------------------------------------------
Account Bulma:

Kod:

Kod:

declare @name varchar(21) set @name = 'Karakter İsmi' SELECT * from ACCOUNT_CHAR where strcharid1 = @name or strcharid2 = @name or strcharid3 = @name

--------------------------------------------------
Ban'lanan Üyelerin NP'lerini Sıfırlamak:

Kod:

Kod:

UPDATE USERDATA SET Loyalty = 0 WHERE Authority = 255

-

-------------------------------------------------
Character'i GM Yapmak:

Kod:

Kod: update userdata set Authority = '0' where struserid = 'Karakter İsmi' Unuqe itemlerin storedaki fıyatını arttırma Kod: -------------------------------------------------- update item_basic SET iPriceSale = 2150000000 WHERE (bySellGroup = 0) -------------------------------------------------- Full Character Edit: Kod: update userdata set Strong = '255',Sta = '255',Dex = '255',Intel = '255',Cha = '255', Level = '100',Loyalty = '100000000',Points = '255',Gold = '2100000000' where struserid = 'Karakter İsmi' Herkese 21 gb verme -------------------------------------------------- Kod: update userdata set gold = '2100000000'

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

İstediğiniz Account'un Item'lerini Silin:

Kod:

Kod:

UPDATE warehouse SET WareHouseData = '' WHERE strAccountID = 'Hesap Adı'

-
-------------------------------------------------
Tüm itemleri +10 a %100 yapma scripti

PHP Code:

Kod:

UPDATE UPGRADEEXT0 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT1 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT2 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT3 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT4 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT5 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT6 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT7 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT8 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT9 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT10 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT11 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT12 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT13 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT14 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT15 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT16 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT17 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT18 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT19 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT20 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT21 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT22 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT23 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

--------------------------------------------------
CZ'deki Kuleleri Aktif Yapmak:

Kod:

Kod:

6701 Guard tower 5301 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6701 0 0 0 6751 Guard tower 5401 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6751 0 0 0 9001 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9001 0 0 4 9002 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9002 0 0 4 9003 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9003 0 0 4 9004 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9004 0 0 4

-

-------------------------------------------------
Full Character Edit:

Kod:

Kod:

update userdata set Strong = '255',Sta = '255',Dex = '255',Intel = '255',Cha = '255', Level = '100',Loyalty = '100000000',Points = '255',Gold = '2100000000' where struserid = 'Karakter İsmi'

--------------------------------------------------
İstediğiniz Account'un Item'lerini Silin:

Kod:

Kod:

UPDATE warehouse SET WareHouseData = '' WHERE strAccountID = 'Hesap Adı'

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

item edit

Kod:

siDamage : vurus gücü (1k ve üstünde yaparsan takinca ölebilirsin ama) -------------------------------------------------- siDefence : kaç ac verecegi ayardir 300 yaparsan defansin 300 artar siDefenceDagger,Axe,Arrow,Spear,Mace vb : bu silahlara karsi kaç defans olacagidir bunlar defanslardi -------------------------------------------------- Silahin Light - Ice - Posion - Fire yanisini ayarlama byDamageFire : fire hasari ekler byDamageIce : ice hasari ekler byDamageThuner : lightning hasari erkler byDamagePosion : posion hasari erkler bunlar da damageler yanmasini istediginize yüksek bir sayi koyun digerlerine 0 deyin ( item_ext23.tbl ile editlenmeden olmayabilir ) Dip Not : Exc uyarin için saol -------------------------------------------------- GELELIM BONUSLARAA... siBonusStr : str bonus siBonusMagic Attack : mp bonus siBonusDex : dex bonus siBonusInt : int bonus siBonusHp : hp bonus siBonusMsp : mana bonus -------------------------------------------------- gerekensinimleri ayarlama siNeedLevel : kaç levelda takilabilecegini anlatir siNeedRank : 1 yaparsaniz sadece krallar takabilir 0 yaparsaniz userlara da açilir siNeedStr : str ihtiyaci siNeedInt,Dex,Hp vs vs : verilen statlarda olunmazsa takilamayacak Resistler siRegistFire, siRegistIce, siRegistElec, siRegistPosion Fire = fire resisti Ice= ice resisti Elec= Lr Posion = posion resisti vs..

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

delos için

Kod:

Kod:

insert into [K_WARPINFO] Values (21,316,'Delos','Delos Desert',5000,30,529,5,253,5) insert into [K_WARPINFO] Values (21,416,'Delos','Delos Desert',5000,30,529,5,253,5) insert into [K_WARPINFO] Values (30,321,'Moradon','Delos Zone',0,21,315,0,400,10) insert into [K_WARPINFO] Values (30,301,'Moradon','Delos Zone',0,21,315,0,400,10) insert into [K_OBJECTEVENT] Values (30,4030,1,0,5,30,1,650,0,650) insert into [K_OBJECTEVENT] Values (30,4031,1,0,5,32,1,550,0,255) insert into [EVENT] Values (30,2001,0,1,1,1,1,1,32,529,253,1,1) insert into [EVENT] Values (30,2002,0,1,1,1,1,1,32,529,253,1,1) insert into [ZONE_INFO] Values (2,30,'elmorad_1212.smd',15000,15000,15000,1,0,'wa r_a_ch') insert into [ZONE_INFO] Values (2,32,'elmorad_1212.smd',15000,15000,15000,1,0,'du ngeon_b1_th')

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

**tarafından Admin Perş. Tem. 17, 2008 11:59 am**

Admin

Admin: Yönetici; Mesaj Sayısı : 677
Yaş : 33
Nerden : çanakkale
İş/Hobiler : öğrenci
Lakap : webci
Ruh Hali :
işletim sistemin :
Seviye :
Madalyaların :
Metin Alanı : Vatanını Seven Görevini En İyi Yapandı®.ElitSepet TeaM<<<< YÖNETİCİ
Sanal Hayvan :
Rap Derecesi :
Kayıt tarihi : 15/07/08

Rap Puanın
Aktiflik:
(4999/5000)
Başarı puanı:
(98787/98787)
Güçlülük :
(4999/5000)

Post n°2

Geri: BÜTÜN Q.A kodları

tarafından Admin Perş. Tem. 17, 2008 11:59 am

Nation Transfer Scripti;

Kod:

El Morad Olan Charı Karus yapmak için için [ exec nt1 'accountname' ] Karus Olan Charı El Morad yapmak için için [ exec nt2 'accountname' ]

--------------------------------------------------
elmorad-karus

Kod:

Kod:

CREATE procedure [nt1] @Account char(30) AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2) begin tran declare @char1 varchar(21) set @char1 = (select strcharid1 from account_char where straccountid = @account) declare @char2 varchar(21) set @char2 = (select strcharid2 from account_char where straccountid = @account) declare @char3 varchar(21) set @char3 = (select strcharid3 from account_char where straccountid = @account) declare @clannumber1 smallint set @clannumber1 = (select idnum from knights where chief = @char1) declare @clannumber2 smallint set @clannumber2 = (select idnum from knights where chief = @char2) declare @clannumber3 smallint set @clannumber3 = (select idnum from knights where chief = @char3) update account_char set bnation = '1' where bnation = '2' and straccountid = @Account update userdata set nation = '1' where nation = '2' and struserid = @char1 Update userdata set race = '1' where class in ('201','205') and struserid = @char1 Update userdata set race = '2' where race = '12' and class in ('207','211','202','204') and struserid = @char1 update userdata set race = '3' where race = '13' and class in ('204','211') and struserid = @char1 update userdata set race = '4' where class in ('203','209') and struserid = @char1 update userdata set class = '105' where class = '205' and struserid = @char1 update userdata set class = '107' where class = '207' and struserid = @char1 update userdata set class = '109' where class = '209' and struserid = @char1 update userdata set class = '111' where class = '211' and struserid = @char1 update userdata set class = '101' where class = '201' and struserid = @char1 update userdata set class = '102' where class = '202' and struserid = @char1 update userdata set class = '103' where class = '203' and struserid = @char1 update userdata set class = '104' where class = '204' and struserid = @char1 update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1 delete from knights where chief = @char1 delete from knights_user where sidnum = @clannumber1 delete from knights_rating where shindex = @clannumber1 update userdata set knights = 0, fame = 0 where knights = @clannumber1 update userdata set nation = '1' where nation = '2' and struserid = @char2 Update userdata set race = '1' where class in ('201','205') and struserid = @char2 Update userdata set race = '2' where race = '12' and class in ('207','211','202','204') and struserid = @char2 update userdata set race = '3' where race = '13' and class in ('204','211') and struserid = @char2 update userdata set race = '4' where class in ('203','209') and struserid = @char2 update userdata set race = '4' where class = '209' and struserid = @char2 update userdata set class = '105' where class = '205' and struserid = @char2 update userdata set class = '107' where class = '207' and struserid = @char2 update userdata set class = '109' where class = '209' and struserid = @char2 update userdata set class = '111' where class = '211' and struserid = @char2 update userdata set class = '101' where class = '201' and struserid = @char2 update userdata set class = '102' where class = '202' and struserid = @char2 update userdata set class = '103' where class = '203' and struserid = @char2 update userdata set class = '104' where class = '204' and struserid = @char2 update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2 delete from knights where chief = @char2 delete from knights_user where sidnum = @clannumber2 delete from knights_rating where shindex = @clannumber2 update userdata set knights = 0, fame = 0 where knights = @clannumber2 update userdata set nation = '1' where nation = '2' and struserid = @char3 Update userdata set race = '1' where class in ('201','205') and struserid = @char3 Update userdata set race = '2' where race = '12' and class in ('207','211','202','204') and struserid = @char3 update userdata set race = '3' where race = '13' and class in ('204','211') and struserid = @char3 update userdata set race = '4' where class in ('203','209') and struserid = @char3 update userdata set class = '105' where class = '205' and struserid = @char3 update userdata set class = '107' where class = '207' and struserid = @char3 update userdata set class = '109' where class = '209' and struserid = @char3 update userdata set class = '111' where class = '211' and struserid = @char3 update userdata set class = '101' where class = '201' and struserid = @char3 update userdata set class = '102' where class = '202' and struserid = @char3 update userdata set class = '103' where class = '203' and struserid = @char3 update userdata set class = '104' where class = '204' and struserid = @char3 update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3 delete from knights where chief = @char3 delete from knights_user where sidnum = @clannumber3 delete from knights_rating where shindex = @clannumber3 update userdata set knights = 0, fame = 0 where knights = @clannumber3 update userdata set knights = 0, fame = 0 where struserid = @char1 update userdata set knights = 0, fame = 0 where struserid = @char2 update userdata set knights = 0, fame = 0 where struserid = @char3 Update knights set vicechief_1 = '' where vicechief_1 = @char1 Update knights set vicechief_2 = '' where vicechief_2 = @char1 Update knights set vicechief_3 = '' where vicechief_3 = @char1 Update knights set vicechief_1 = '' where vicechief_1 = @char2 Update knights set vicechief_2 = '' where vicechief_2 = @char2 Update knights set vicechief_3 = '' where vicechief_3 = @char2 Update knights set vicechief_1 = '' where vicechief_1 = @char3 Update knights set vicechief_2 = '' where vicechief_2 = @char3 Update knights set vicechief_3 = '' where vicechief_3 = @char3 delete from knights_user where struserid = @char1 delete from knights_user where struserid = @char2 delete from knights_user where struserid = @char3 commit tran GO

-

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

**tarafından Admin Perş. Tem. 17, 2008 11:59 am**

Admin

Admin: Yönetici; Mesaj Sayısı : 677
Yaş : 33
Nerden : çanakkale
İş/Hobiler : öğrenci
Lakap : webci
Ruh Hali :
işletim sistemin :
Seviye :
Madalyaların :
Metin Alanı : Vatanını Seven Görevini En İyi Yapandı®.ElitSepet TeaM<<<< YÖNETİCİ
Sanal Hayvan :
Rap Derecesi :
Kayıt tarihi : 15/07/08

Rap Puanın
Aktiflik:
(4999/5000)
Başarı puanı:
(98787/98787)
Güçlülük :
(4999/5000)

Post n°3

Geri: BÜTÜN Q.A kodları

tarafından Admin Perş. Tem. 17, 2008 11:59 am

karus-elmorad

Kod:

Kod:

CREATE procedure [nt2] @Account char(30) AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2) begin tran declare @char1 varchar(21) set @char1 = (select strcharid1 from account_char where straccountid = @account) declare @char2 varchar(21) set @char2 = (select strcharid2 from account_char where straccountid = @account) declare @char3 varchar(21) set @char3 = (select strcharid3 from account_char where straccountid = @account) declare @clannumber1 smallint set @clannumber1 = (select idnum from knights where chief = @char1) declare @clannumber2 smallint set @clannumber2 = (select idnum from knights where chief = @char2) declare @clannumber3 smallint set @clannumber3 = (select idnum from knights where chief = @char3) update account_char set bnation = '2' where bnation = '1' and straccountid = @Account update userdata set nation = '2' where nation = '1' and struserid = @char1 Update userdata set race = '11' where class = '105' and struserid = @char1 update userdata set race = '11' where class = '101' and struserid = @char1 Update userdata set race = '12' where race = '2' and class in ('107','111','102','104') and struserid = @char1 update userdata set race = '13' where race = '3' and class in ('104','111') and struserid = @char1 update userdata set race = '13' where class in ('203','209') and race = '4' and struserid = @char1 update userdata set class = '205' where class = '105' and struserid = @char1 update userdata set class = '207' where class = '107' and struserid = @char1 update userdata set class = '209' where class = '109' and struserid = @char1 update userdata set class = '211' where class = '111' and struserid = @char1 update userdata set class = '201' where class = '101' and struserid = @char1 update userdata set class = '202' where class = '102' and struserid = @char1 update userdata set class = '203' where class = '103' and struserid = @char1 update userdata set class = '204' where class = '104' and struserid = @char1 update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1 delete from knights where chief = @char1 delete from knights_user where sidnum = @clannumber1 delete from knights_rating where shindex = @clannumber1 update userdata set knights = 0, fame = 0 where knights = @clannumber1 update userdata set nation = '2' where nation = '1' and struserid = @char2 Update userdata set race = '11' where class = '105' and struserid = @char2 update userdata set race = '11' where class = '101' and struserid = @char2 Update userdata set race = '12' where race = '2' and class in ('107','111','102','104') and struserid = @char2 update userdata set race = '13' where race = '3' and class in ('104','111') and struserid = @char2 update userdata set race = '13' where class in ('203','209') and race = '4' and struserid = @char2 update userdata set class = '205' where class = '105' and struserid = @char2 update userdata set class = '207' where class = '107' and struserid = @char2 update userdata set class = '209' where class = '109' and struserid = @char2 update userdata set class = '211' where class = '111' and struserid = @char2 update userdata set class = '201' where class = '101' and struserid = @char2 update userdata set class = '202' where class = '102' and struserid = @char2 update userdata set class = '203' where class = '103' and struserid = @char2 update userdata set class = '204' where class = '104' and struserid = @char2 update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2 delete from knights where chief = @char2 delete from knights_user where sidnum = @clannumber2 delete from knights_rating where shindex = @clannumber2 update userdata set knights = 0, fame = 0 where knights = @clannumber2 update userdata set nation = '2' where nation = '1' and struserid = @char3 Update userdata set race = '11' where class = '105' and struserid = @char3 update userdata set race = '11' where class = '101' and struserid = @char3 Update userdata set race = '12' where race = '2' and class in ('107','111','102','104') and struserid = @char3 update userdata set race = '13' where race = '3' and class in ('104','111') and struserid = @char3 update userdata set race = '13' where class in ('203','209') and race = '4' and struserid = @char3 update userdata set class = '205' where class = '105' and struserid = @char3 update userdata set class = '207' where class = '107' and struserid = @char3 update userdata set class = '209' where class = '109' and struserid = @char3 update userdata set class = '211' where class = '111' and struserid = @char3 update userdata set class = '201' where class = '101' and struserid = @char3 update userdata set class = '202' where class = '102' and struserid = @char3 update userdata set class = '203' where class = '103' and struserid = @char3 update userdata set class = '204' where class = '104' and struserid = @char3 update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3 delete from knights where chief = @char3 delete from knights_user where sidnum = @clannumber3 delete from knights_rating where shindex = @clannumber3 update userdata set knights = 0, fame = 0 where knights = @clannumber3 update userdata set knights = 0, fame = 0 where struserid = @char1 update userdata set knights = 0, fame = 0 where struserid = @char2 update userdata set knights = 0, fame = 0 where struserid = @char3 Update knights set vicechief_1 = '' where vicechief_1 = @char1 Update knights set vicechief_2 = '' where vicechief_2 = @char1 Update knights set vicechief_3 = '' where vicechief_3 = @char1 Update knights set vicechief_1 = '' where vicechief_1 = @char2 Update knights set vicechief_2 = '' where vicechief_2 = @char2 Update knights set vicechief_3 = '' where vicechief_3 = @char2 Update knights set vicechief_1 = '' where vicechief_1 = @char3 Update knights set vicechief_2 = '' where vicechief_2 = @char3 Update knights set vicechief_3 = '' where vicechief_3 = @char3 delete from knights_user where struserid = @char1 delete from knights_user where struserid = @char2 delete from knights_user where struserid = @char3 commit tran GO

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

GM KomutLarı

Kod:

/clear (0-100 arası değer yazın) (ideali 50) (Açık hava) /rain (0-100 arası değer yazın) (ideali 50) (Yağmurlu hava) /snow (0-100 arası değer yazın) (ideali 50) (Karlı hava) /goto xxx,xxx ( xxx,xxx koordinatına ışınlanırsınız) /count (serverdaki online player sayısını gösterir) /notice ne yazmak istiyorsan yaz (Notice yazarsınız) /time (0-24) (Oyun saatini ayarlarsınız mesela 24 yapınca gece olur) 'Q' harfine basılı tutup koşarsanız çok hızlı koşarsınız (Orc base'den Human Base'ye 10 saniyede gidersiniz sanırım) /ban yada /forbid_connect nick (kimi banlamak istiyorsanız onun nickini yazın) /mute yada /forbid_chat nick (kimi mutelemek istiyorsanız onun nickini yazın) /unmute yada /allow_chat nick (kimin mutesini açmak istiyorsanız onun nickini yazın)

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

Oto Grade - Clan Rank

database inizde bulunan "stored procedure" kısmına girin.
en altta update_knights procedure ünü bulun.

orada declare kısmından önceki bölüme
Kod:

Kod:

exec rank_knights yazın. yani şöyle görünücek; Kod: -- sungyong 2002.08.22 create -- modify 2007 Metriyks1536 xD CREATE PROCEDURE UPDATE_KNIGHTS @nRet smallint OUTPUT, @Type tinyint, @UserId char(21), @KnightsIndex smallint, @Domanation tinyint AS exec rank_knights DECLARE @Row tinyint DECLARE @Members tinyint DECLARE @KnightsNumber smallint DECLARE @ViceChief_1 char(21) DECLARE @ViceChief_2 char(21) DECLARE @ViceChief_3 char(21) . . . . . ve sonra shu kodları giriniz ... kod: SELECT nRank AS siralama, strName AS isim, nPoints AS toplam_np FROM KNIGHTS_RATING ORDER BY nRank

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

Karus Kadın Mage Yapımı

Kod:

1-) Usko(ROFD)'nun Item Dosyasını Kendi Serverimizin Item Dosyasıyla Değiştiriyoruz. 2-) Oyunda Bir Priest Açıyoruz. 3-) Enterprise Manager'den USERDATA Tablosunu Açıyoruz. 4-) Priestimizi Bulup Classını 109 Olarak Değiştiriyoruz...

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

Beygir Olmak

Kod:

Karus Warrior Race : 5 Karus Erkek Race : 6

Karus Cüce Race : 7
Karus Kadın Race : 8
Elmorad Barbar Race : 14
Elmorad Erkek Race : 15
Elmorad Bayan Race : 16

BÜTÜN Q.A kodları

BÜTÜN Q.A kodları

Geri: BÜTÜN Q.A kodları

Geri: BÜTÜN Q.A kodları

Similar topics

Similar topics

Arama

Sonuç : Mesajlar Konular
çıkıntı araştırma