Tamamen Alıntıdır. Bana Ait Olan Hiç Birşey Yoktur
Sadece Derlemek Bize Kaldı. Fırsat Buldukca Güncellemeye Çalışacagım.
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
update userdata set Authority = '0'
where struserid = 'Karakter ismi'
Charı Normal Char Yapma Scripti
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
update userdata set Authority = '1'
where struserid = 'Karakter İsmi'
Charı Banlama Scripti
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
update userdata set Authority = '255'
where struserid = 'Karakter İsmi'
AC Kıyafetleri DB'den Kaldırmak
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 162px;
text-align: left;
overflow: auto">
Databaseden 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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 242px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 114px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255
Unuqe itemlerin storedaki fıyatını arttırma
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
update item_basic
SET iPriceSale = 2150000000
WHERE (bySellGroup = 0)
Full Character Edit
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
update userdata set gold = '2100000000'
İstediğiniz Account'un Item'lerini Silin
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE warehouse
SET WareHouseData = ''
WHERE strAccountID = 'Hesap Adı'
Tüm itemleri +10 a %100 yapma scripti
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 402px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 114px;
text-align: left;
overflow: auto">
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
Delos için
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 178px;
text-align: left;
overflow: auto">
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 )
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
[ exec nt1 'accountname' ]
Nation Transfer Scripti (Karus Olan Charı El Morad yapmak için için)
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
[ exec nt2 'accountname' ]
Elmorad-Karus
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
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
Oto Grade - Clan Rank
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
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 ...
SELECT nRank AS siralama, strName AS isim, nPoints AS toplam_np
FROM KNIGHTS_RATING
ORDER BY nRank
Karus Kadın Mage Yapımı
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 82px;
text-align: left;
overflow: auto">
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...
Acid Potu Sunderastan Kaldırmak
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
UPDATE ITEM SET SellingGroup = 0 Where Num = 389083000
1440 Pot ve Abyys Bless i silmek
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 210px;
text-align: left;
overflow: auto">
DELETE FROM ITEM
WHERE (Num = '379102000')
DELETE FROM ITEM
WHERE (Num = '379103000')
DELETE FROM ITEM
WHERE (Num = '379105000')
DELETE FROM ITEM
WHERE (Num = '379104000')
DELETE FROM ITEM
WHERE (Num = '379102000')
DELETE FROM ITEM
WHERE (Num = '379101000')
abyss holy waterları silme
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 338px;
text-align: left;
overflow: auto">
Delete from item
where num = '379101000'
delete from item
where num = '379102000'
delete from item
where num = '379103000'
delete from item
where num = '379108000'
delete from item
where num = '379113000'
delete from item
where num = '379098000'
delete from item
where num = '389015000'
delete from item
where num = '389064000'
delete from item
where num = '910005000'
delete from item
where num = '389083000'
Critical Atack Ayar
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
Human Critical:
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '108685'
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
Orc Critical:
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '208685'
Drop Sıfırlama
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 98px;
text-align: left;
overflow: auto">
update k_monster_item set iItem01 = '0'
update k_monster_item set iItem02 = '0'
update k_monster_item set iItem03 = '0'
update k_monster_item set iItem04 = '0'
update k_monster_item set iItem05 = '0'
Guard Tower Damage Ayarlama
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE MAGIC_TYPE3
SET FirstDamage = 1000(istediğiniz kadar yazabilirsiniz Damageyi)
WHERE (iNum = 300139)
Irk seçme ekranında kalıyorsa
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 82px;
text-align: left;
overflow: auto">
insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','15000','2','101','Dark Lunar')
insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','15000','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'
Mage 72 Skili
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 114px;
text-align: left;
overflow: auto">
update magic_type1
set hit = '10000'
where inum like '110_72'
update magic_type1
set hit = '10000'
where inum like '210_72'
Mage skill edit(atack Arttırma)
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 194px;
text-align: left;
overflow: auto">
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 109551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 110551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 209551)
NP sıfırlama
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1
BANLANAN OYUNCULARIN SİLMEK İÇİN
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255
Okcu 32 K bugu
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5
Oto Master
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
/****** Object: Stored Procedure dbo.LOAD_USER_DATA Script Date: 6/6/2006 6:03:33 PM ******/
/****** ??: ?? ???? dbo.LOAD_USER_DATA ???? ??: 2002-11-14 ?? 11:18:04 ******/
-- modifed by bluemansiiz 2008.05.09
-- 2004.04.22 ?????(LoyaltyMonthly) ?? arycoat
CREATE PROCEDURE LOAD_USER_DATA
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT
AS
-- inserted by samma 2003.07.10
DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
DECLARE @True smallint
SET @charid1 = null
SET @charid2 = null
SET @charid3 = null
SET @True = 0
SET @nRet = 0
/*
DECLARE @nPlayGameUserCount TINYINT
SET @nPlayGameUserCount = 0
SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
IF @nPlayGameUserCount > 0
BEGIN
SET @nRet = 0
RETURN
END
*/
SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @id = @charid1 or @id = @charid2 or @id = @charid3
SET @True = 1
IF @True = 0
BEGIN
SET @nRet = 0
RETURN
END
-- inserted by samma 2003.07.10
DECLARE @class char(21)
set @class = (select class from userdata where struserid = @id)
if @class = 105
begin
update userdata set class = 106 where struserid = @id
end
if @class = 107
begin
update userdata set class = 108 where struserid = @id
end
if @class = 109
begin
update userdata set class = 110 where struserid = @id
end
if @class = 111
begin
update userdata set class = 112 where struserid = @id
end
if @class = 205
begin
update userdata set class = 206 where struserid = @id
end
if @class = 207
begin
update userdata set class = 208 where struserid = @id
end
if @class = 209
begin
update userdata set class = 210 where struserid = @id
end
if @class = 211
begin
update userdata set class = 212 where struserid = @id
end
SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
FROM USERDATA WHERE strUserId = @id
SET @nRet = @@RowCount
exec rundupecheck2 @id
if @id='Shlt' or @id ='DammKengKar'
BEGIN
INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
END
RETURN
GO
Devamı Gelebilir
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
update userdata set Authority = '0'
where struserid = 'Karakter ismi'
Charı Normal Char Yapma Scripti
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
update userdata set Authority = '1'
where struserid = 'Karakter İsmi'
Charı Banlama Scripti
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
update userdata set Authority = '255'
where struserid = 'Karakter İsmi'
AC Kıyafetleri DB'den Kaldırmak
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 162px;
text-align: left;
overflow: auto">
Databaseden 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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 242px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 114px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255
Unuqe itemlerin storedaki fıyatını arttırma
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
update item_basic
SET iPriceSale = 2150000000
WHERE (bySellGroup = 0)
Full Character Edit
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
update userdata set gold = '2100000000'
İstediğiniz Account'un Item'lerini Silin
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE warehouse
SET WareHouseData = ''
WHERE strAccountID = 'Hesap Adı'
Tüm itemleri +10 a %100 yapma scripti
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 402px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 114px;
text-align: left;
overflow: auto">
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
Delos için
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 178px;
text-align: left;
overflow: auto">
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 )
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
[ exec nt1 'accountname' ]
Nation Transfer Scripti (Karus Olan Charı El Morad yapmak için için)
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
[ exec nt2 'accountname' ]
Elmorad-Karus
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
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
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
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
Oto Grade - Clan Rank
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
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 ...
SELECT nRank AS siralama, strName AS isim, nPoints AS toplam_np
FROM KNIGHTS_RATING
ORDER BY nRank
Karus Kadın Mage Yapımı
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 82px;
text-align: left;
overflow: auto">
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...
Acid Potu Sunderastan Kaldırmak
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 34px;
text-align: left;
overflow: auto">
UPDATE ITEM SET SellingGroup = 0 Where Num = 389083000
1440 Pot ve Abyys Bless i silmek
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 210px;
text-align: left;
overflow: auto">
DELETE FROM ITEM
WHERE (Num = '379102000')
DELETE FROM ITEM
WHERE (Num = '379103000')
DELETE FROM ITEM
WHERE (Num = '379105000')
DELETE FROM ITEM
WHERE (Num = '379104000')
DELETE FROM ITEM
WHERE (Num = '379102000')
DELETE FROM ITEM
WHERE (Num = '379101000')
abyss holy waterları silme
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 338px;
text-align: left;
overflow: auto">
Delete from item
where num = '379101000'
delete from item
where num = '379102000'
delete from item
where num = '379103000'
delete from item
where num = '379108000'
delete from item
where num = '379113000'
delete from item
where num = '379098000'
delete from item
where num = '389015000'
delete from item
where num = '389064000'
delete from item
where num = '910005000'
delete from item
where num = '389083000'
Critical Atack Ayar
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
Human Critical:
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '108685'
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 50px;
text-align: left;
overflow: auto">
Orc Critical:
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '208685'
Drop Sıfırlama
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 98px;
text-align: left;
overflow: auto">
update k_monster_item set iItem01 = '0'
update k_monster_item set iItem02 = '0'
update k_monster_item set iItem03 = '0'
update k_monster_item set iItem04 = '0'
update k_monster_item set iItem05 = '0'
Guard Tower Damage Ayarlama
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE MAGIC_TYPE3
SET FirstDamage = 1000(istediğiniz kadar yazabilirsiniz Damageyi)
WHERE (iNum = 300139)
Irk seçme ekranında kalıyorsa
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 82px;
text-align: left;
overflow: auto">
insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','15000','2','101','Dark Lunar')
insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','15000','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'
Mage 72 Skili
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 114px;
text-align: left;
overflow: auto">
update magic_type1
set hit = '10000'
where inum like '110_72'
update magic_type1
set hit = '10000'
where inum like '210_72'
Mage skill edit(atack Arttırma)
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 194px;
text-align: left;
overflow: auto">
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 109551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 110551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 209551)
NP sıfırlama
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1
BANLANAN OYUNCULARIN SİLMEK İÇİN
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255
Okcu 32 K bugu
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 66px;
text-align: left;
overflow: auto">
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5
Oto Master
PHP- Kodu:
<div class="alt2" dir="ltr" style="
margin: 0px;
padding: 6px;
border: 1px inset;
width: 640px;
height: 498px;
text-align: left;
overflow: auto">
/****** Object: Stored Procedure dbo.LOAD_USER_DATA Script Date: 6/6/2006 6:03:33 PM ******/
/****** ??: ?? ???? dbo.LOAD_USER_DATA ???? ??: 2002-11-14 ?? 11:18:04 ******/
-- modifed by bluemansiiz 2008.05.09
-- 2004.04.22 ?????(LoyaltyMonthly) ?? arycoat
CREATE PROCEDURE LOAD_USER_DATA
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT
AS
-- inserted by samma 2003.07.10
DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
DECLARE @True smallint
SET @charid1 = null
SET @charid2 = null
SET @charid3 = null
SET @True = 0
SET @nRet = 0
/*
DECLARE @nPlayGameUserCount TINYINT
SET @nPlayGameUserCount = 0
SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
IF @nPlayGameUserCount > 0
BEGIN
SET @nRet = 0
RETURN
END
*/
SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @id = @charid1 or @id = @charid2 or @id = @charid3
SET @True = 1
IF @True = 0
BEGIN
SET @nRet = 0
RETURN
END
-- inserted by samma 2003.07.10
DECLARE @class char(21)
set @class = (select class from userdata where struserid = @id)
if @class = 105
begin
update userdata set class = 106 where struserid = @id
end
if @class = 107
begin
update userdata set class = 108 where struserid = @id
end
if @class = 109
begin
update userdata set class = 110 where struserid = @id
end
if @class = 111
begin
update userdata set class = 112 where struserid = @id
end
if @class = 205
begin
update userdata set class = 206 where struserid = @id
end
if @class = 207
begin
update userdata set class = 208 where struserid = @id
end
if @class = 209
begin
update userdata set class = 210 where struserid = @id
end
if @class = 211
begin
update userdata set class = 212 where struserid = @id
end
SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
FROM USERDATA WHERE strUserId = @id
SET @nRet = @@RowCount
exec rundupecheck2 @id
if @id='Shlt' or @id ='DammKengKar'
BEGIN
INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
END
RETURN
GO
Devamı Gelebilir