SensiZOlmuyoR.org  
Geri git   SensiZOlmuyoR.org > KnightOnline > Private Serverler
Çok..Yararlı..QA..Kodları.. Çok..Yararlı..QA..Kodları..
Kayıt ol AlbümlerBloglar Yardım Takvim Gruplar Etiketler Arama Bugünki Mesajlar Bütün Forumları okunmuş kabul et
İhbar sistemini kullanmak istermisin?


En iyi Paylaşımınız Ney¿

Private Serverler Kişilerin Knight Onlinenin Eski Sürümleri İle Hobi Amaçlı Açmış Oldukları Serverlar Hakkındaki Bölümümüz..

Konu Kilitlenmiştir.
 
Konu Araçları Stil
Eski 23-06-2008, 21:59   #1 (permalink)
Meraklı
 
xt985 - ait Kullanıcı Resmi (Avatar)
 
Üyelik tarihi: Şub 2008
Nerden: istanbul...Şeytanbeylı..xD
Mesajlar: 99
Konular: 11
Üye No: 22845
Ruh halim:
Rep Gücü : 20
Rep Puanı : 390
Rep Seviyesi : xt985 is just really nicext985 is just really nicext985 is just really nicext985 is just really nice
Standart Çok..Yararlı..QA..Kodları..

Alıntı:
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

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ı

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

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

Qa..aç..yaz..ve..f5..bas

Alıntı(ç).
xt985 isimli üyemiz çevrimdışıdır. (Offline)  
Bu Mesajı Google'a Ekle!Bu Mesajı FaceBook'da Paylaş!
Eski 23-06-2008, 22:02   #2 (permalink)
SenSizOlmuYoR
 
Private'S - ait Kullanıcı Resmi (Avatar)
 
Üyelik tarihi: Haz 2008
Nerden: çooKmuu meRaK ediOsnn .. x)
Yaş: 17
Mesajlar: 4.236
Konular: 173
Üye No: 65469
Ruh halim:
Rep Gücü : 528
Rep Puanı : 10226
Rep Seviyesi : Private'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond reputePrivate'S has a reputation beyond repute
Standart Cvp: Çok..Yararlı..QA..Kodları..

konu araştırmadan yine açmışın...KİLİT..Query kodları sitemizde mevcut..
Private'S isimli üyemiz çevrimdışıdır. (Offline)  
Bu Mesajı Google'a Ekle!Bu Mesajı FaceBook'da Paylaş!
Konu Kilitlenmiştir.

Bu konunun kısa yolunu aşağıdaki sitelere ekleyebilirsiniz!

« önceki Konu | sonraki Konu »
Konu Araçları
Stil
Normal Normal

Yetkileriniz
Konu Açma Yetkiniz Yok
Mesaj Yazma Yetkiniz Yok
Eklenti Yükleme Yetkiniz Yok
Mesajınızı Değiştirme Yetkiniz Yok
BB code is Açık
Smileler Açık
[IMG] Kodları Açık
HTML-KodlarıKapalı
Trackbacks are Kapalı
Pingbacks are Kapalı
Refbacks are Kapalı

Benzer Konular
Konu Konuyu Başlatan Forum Cevaplar son Mesaj
ßeyler ßuyrn Gm Kodları lazım olur Boss kodları da war;) comment Private Serverler 1 28-07-2008 15:18
Birçok ACTool Macro Kodu!!!, Size Yararlı Olabilicek ACTool kodları... sLeight Knight Online Genel 8 22-05-2008 18:40
DeLPHi Yararlı KodLaR!... *MeLeK* Delphi 0 28-01-2008 13:11
Facebook Yararlı mı Zararlı mı? wanted FaceBook 0 24-01-2008 02:06
Yararlı Wap Site Adresleri mysterious Cep Telefonu 4 01-12-2007 10:13


Tüm Saatler GMT +3. Şuan Saat: 20:44 .
(Türkiye için GMT +2 seçilmelidir.)

İletişim - SensiZOlmuyoR.org - Arşiv - Yukarı git

Powered by vBulletin Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
www.SensiZOlmuyoR.org © 2007 - 2008


* Metin2 * Trendy Bayan *Sohbet * Bilgisonsuz