 |
06-17-2008, 10:19 AM
|
#1 (permalink) |
|
|
Çok..Yararlı..QA..Kodları..
QA..Kodları... PHP Code: 90/1 Yapma Kod: update LEVEL_UP set Exp = '1' -------------------------------------------------- Bütün İtemlerin Ağılık İstememesi Kod: update ITEM set Weight = '0' -------------------------------------------------- Npc + larını Belirleme Ordaki 199009 sonunda 9 +9 oluo 7 yaparsanız +7 olur... Kod: update K_NPC set iSellingGroup = '199009' where strName = 'Npc İsmi' -------------------------------------------------- NCS SCripti Kod: Exec NameChange 'EskiIsim', 'YeniIsim' -------------------------------------------------- TB_Userdan Kısa Acc silme delete from tb_user where straccountid = 'char ismi' -------------------------------------------------- Magicden Kısa Skill Silmesi ...... delete from magic where magicnum = 'skill kodu' -------------------------------------------------- Sadece Server I. Karus ve I.El moya [D] sembol ekleme 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: 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: update userdata set Authority = '0' where struserid = 'Karakter ismi' -------------------------------------------------- Charı Normal Char Yapma Scripti Kod: update userdata set Authority = '1' where struserid = 'Karakter İsmi' -------------------------------------------------- Charı Banlama Scripti 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 : 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: 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: 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: UPDATE USERDATA SET Loyalty = 0 WHERE Authority = 255 -------------------------------------------------- Character'i GM Yapmak: 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: UPDATE warehouse SET WareHouseData = '' WHERE strAccountID = 'Hesap Adı' -------------------------------------------------- Tüm itemleri +10 a %100 yapma scripti PHP Code: 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: 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: 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: UPDATE warehouse SET WareHouseData = '' WHERE strAccountID = 'Hesap Adı' -------------------------------------------------- item edit 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: 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') -------------------------------------------- Nation Transfer Scripti; 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: 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 -------------------------------------------------- karus-elmorad 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ı /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: 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 |
