1299 Server Hakkında Genel Bilgiler Patchler

11 Temmuz 2008 – 14:04

Aradığını bulamadıysanız arama yapın!

Önce Clientlerden
http://files.filefront.com/150x+Clie…/fileinfo.html
1505 Client
ftp://ftp.download.com/pub/ppd/10367…up_1299_01.exe
1299 Client (dasyaları tam değil usko itemleri görünmüyor upladım onları altta)

Klasörler

GM Kodları

/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

/ban yada /forbidconnect 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)

/Arrest nick adamın yanına ışınlanmak için Bir gün gm olursanız belki işe yarar
er

/offpermant (banı açar)

/permıtchat (mute açar)

/summonuser (yanınıza player ceker)

/view (görünür)

/unview (görünmez)

+unikmonster (rasgele boss cıkarır)

+monsummonall (mesela 1 yerine 10 boss cıkarır)

+mopen (savaş baslatır)

+open (savaş baslatır)

+open2 (savaş baslatır)

+open3 (savaş baslatır)

+exp_add (ex event baslatır)

+money_add (para event baslatır)
/forbidconnect
——————————————–

BOSS KODLARI

+moncatch 12365 bach
+moncatch 11970 Bishob
+moncatch 13624 Lesath
+moncatch 12363 Barrkk
+moncatch 12364 bakirra
+moncatch 12768 Lobo
+moncatch 12182 lycoun
+moncatch 12767 Lupus
+moncatch 12183 bone collecter
+moncatch 12888 orc bandit officer archer
+moncatch 12889 Orc bandit offlicer Mage
+moncatch 12890 orc bandit officer blade
+moncatch 12364 Bach
+moncatch 12363 bakirra
+moncatch 12362 Barrkk
+moncatch 12767 lobo
+moncatch 12183 Javana
+moncatch 12181 Lycaon
+moncatch 12182 Bone collec
+moncatch 11969 bishop
+moncatch 13623 Lesath
+moncatch 14048 Duke
+moncatch 14441 Orc Sniper
+moncatch 12217 Dark Stone
+moncatch 14814 DARm mare
+moncatch 11971 Giant Golem
+moncatch 12172 Troll King
+moncatch 12278 DEATH MARE
+moncatch 14823 HQ
+moncatch 14826 DF
+moncatch 14835 Talos
+moncatch 14836 Dragon tooth
+moncatch 14824 Shaula
+moncatch 14825 Samma
+moncatch 14751 harpy
+moncatch 14834 SQ
+moncatch 12363 barrkirra
+moncatch 12885 2. shaula
+moncatch 13685 Kekurıkukaraka

SUMMON

+monsummon koyun ve bu kodları devamında yazın
+monsummon 111 gibi

111 Kekurikekukaka
506 Lobo
1005 Hyde
507 Lupus
906 Antares

508 Lycaon
607 Barrkk
1205 Duke

608 Barkirra
1106 bone collecter
1206 Bishop
1207 Bach
1305 Javana
907 Shaula
908 Lesath
1107 Dragon tooth
1400 attila
1306 Samma
2005 Snake Queen
2105 Deruvish founder
1725 Troll King
2205 Harpy Queen
2817 Orc bandit leader
2818 Orc bandit leader
2819 orc bandit leader
2405 Talos
3001 Dark Mare
3002 Death Mare
3003 Shade Mare
3004 Dread Mare
4001 Chrestmas Tree
4101 Etaroth (Küçük) (Yeşik Kutu Çıkıyo)
4102 Etaroth (Büyük) (Mavi Kutu çıkıyo)
4201 Ape
4301 Tyon
4401 Hornet
4501 Linch
4601 Ozzy
4701 Grell
5001 Tree ghost variant
5002 Tree ghost King
5003 Tree ghost
5201 The Messenger of Patoz
5501 İsiloon
5502 İsiloon’s Soldier
5601 İsiloon’s Soldier
5801 isimsiz (kekon) exp
5901 isimsiz (kekon) exp
6001 isimsiz (kekon) exp
6101 isimsiz (büyük kekon) exp
6201 isimsiz (kekon) exp
6301 isimsiz (kekon) exp
6401 isimziz (kekon) exp
6501 isimsiz (kekon) exp (çoz zor ölüyo)
6601 isimsiz (kekon) az exp
6701 Humman Guard Tower
6901 Cz deki stinger
6902 Stegodon
6903 Death knight
6904 Mastadon
6905 Watcher
6906 Blood seeker
6907 Beast
6908 Blood Don
6909 Baron
6910 Cardinal
6911 Haunga
6912 Lamia
6913 Deruvish
6914 Riote
6915 Troll
6916 Lamiros
6917 Apostle
6918 Troll Warrior
6919 Raven Harpy
6920 Atross
6921 Stone golem
6922 Giant golem
6923 Dark Mare
6924 Meganthereon
6927 paralyzer
6928 Harpy
6929 Dark eyes
6951 Lupus (içi boş)
6950 lobo (içi boş)
6952 Lycaon (içi boş)
6953 Barrkk (içi boş)
6954 Barkirra (içi boş)
113 Kekon mage
114 kecoon berserker
115 Kecoon Dragoon
116 kekurikekukaka
117 kekurikekukaka
151 Kecoon scout
150 Kecoon
154 Kecoon exile
158 Kecoon bone collecto
161 Kekurikekukaka
200 bulcan (maradondaki değil)
201 wold bulcan (maradondaki değil)
202 Bulky bulcan (maradondaki değil)
203 Giant bulcan (maradondaki değil)
204 Bulture (maradondaki değil)
205 small bulcan (maradondaki değil)
206 Keilan
207 Shilan
251 wold bulcan (maradondaki)
250 bulcan (maradondaki)
252 Bulky bulcan (maradondaki)
253 Giant bulcan (maradondaki)
254 Bultore (maradondaki)
255 Small Bulcan
271 Lutterslan
301 Giant gavolt
300 Gavolt
302 Fury gavolt
303 spoiler
304 Gloomwing
401 Ganesa
400 Glyptodont
402 Stegodon
403 Mastodon
404 Megarodon
500 Werewolf
600 Smilodon
700 worm
800 bandicoot
900 Scorpion
1000 Zombie

——————————————–
UNİQUE İTEM KODLARI

379068000 [GOLD BAR]
700002000 [TİRNA]
310110205 [brONZE EARNİNİG]
310610215 [SİLVER EARNİNİG]
310510235 [CRİSTAL EARNİNİG]
310410245 [PLATIUM EARNİNİG]
310610255 ELF EARNİNİG
310610275 WARRİOR EARNİNİG
310410285 AGATA EARNİNİG
310510295 OPAL EARNİNİG
320110305 WARIOR PENDANT
320110316 ELEMENTAL PENDANT
320110325 PİREST PENDANT
320510335 AMULET OF CURSE
320510355 AMULET DEX
320510384 AMULET HEALT
320610435 BLUE NECKLA
320310395 ELEMANTAL
910158138 MAGE PENDAT
320610345 AMULET OF STR
320310415 IRON NECKLA
330110305 ROC
330150315 ROM
330150325 ROF
330110335 OPAL RİNG
330610345 AGATA RİNG
330410365 DİAMOND RİNG
330610385 GOLD RİNG
340110305 KEKURY BELT
340610365 CRSİTAL
340410395 GLASS BELT
340510405 BELT OF STR
340410455 SKELOTON BETL
310310425 CLERİC EARNİNİG
330310475 KEKURY RİNG
119101210 DARK VANE
179101300 DOL
130450280 GİGA
160450290 CHİTİN BOW

ACCOUNT VE KULELER İÇİN KODLAR

Account Bulma:
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:

UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255

Character’i GM Yapmak:

update userdata set Authority = ‘0′
where struserid = ‘Karakter İsmi’

CZ’deki Kuleleri Aktif Yapmak:

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:

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

UPDATE warehouse
SET WareHouseData = ”
WHERE strAccountID = ‘Hesap Adı’
—————————————

QUERRY ANALYZER KODLARI

80/1 Yapma

update LEVEL_UP set Exp = ‘1′
————————————————–
Bütün İtemlerin Ağılık İstememesi

update ITEM set Weight = ‘0′
————————————————–
Npc + larını Belirleme Ordaki 199009 sonunda 9 +9 oluo 7 yaparsanız +7 olur…

update K_NPC set iSellingGroup = ‘199009′
where strName = ‘Npc İsmi’
————————————————–
NCS SCripti

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

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

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

update userdata set Authority = ‘0′
where struserid = ‘Karakter ismi’
————————————————–

Charı Normal Char Yapma Scripti

update userdata set Authority = ‘1′
where struserid = ‘Karakter İsmi’
————————————————–
Charı Banlama Scripti

update userdata set Authority = ‘255′
where struserid = ‘Karakter İsmi’
————————————————–
AC Kıyafetleri DB’den Kaldırmak:

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

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:

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:

UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255
————————————————–
Character’i GM Yapmak:

update userdata set Authority = ‘0′
where struserid = ‘Karakter İsmi’

————————————————–

Unuqe itemlerin storedaki fıyatını arttırma

update item_basic
SET iPriceSale = 2150000000
WHERE (bySellGroup = 0)

————————————————–

Full Character Edit:

Herkese 21 gb verme

update userdata set gold = ‘2100000000′

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:

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 BONUSLARA…

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

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

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

karus-elmorad

CREATE procedure [nt2]
@Account char(30)

begin tran

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

——————————————-

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

TÜRK BAYRAĞI EKLEMEK İÇİN Q.A KODLARI (DROPUNU SİZ AYARLAYACAKSINIZ)

insert into [ITEM] Values (135820000,’Turkish Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135830000,’American Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135840000,’Canadian Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135850000,’German Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135860000,’Danish Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135870000,’Polish Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135880000,’Korean Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135890000,’Chinese Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135900000,’Japanese Flag’,97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)