17 Haziran 2009 Çarşamba

Dilek Ağacı NPC' si [Tek tuş=LeveL 70 + Skill Stat / Itemler ]

1299 Private Serverlarda, oyunu daha kolaylaştırmak için geliştirilmiş bir NPC, BILAL tarafından yapılmıştır.

Özellikleri:

Direk 70 LeveL Oluyorsunuz.
Bifrost İtemleri
High Class İtemleri
Juraid Itemleri
JapKO Itemleri

İtemler:

Spears
Clubs
Axes
Swords
Shields
Staffs
Daggers
Hammers
Accessories
Armors [Valkry,Graypton,Bahamut]

Kullanım:

Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.
SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.
Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.

Kod:

insert into k_npc values (13765 , 'LEVEL&ITEM' , 25100 , 100 , 0 , 0 , 1 , 0 , 28 , 1 , 1 , 1 , 0 , 90 , 0 , 0 , 100000 , 0 , 0 , 15000 , 497 , 0 , 0 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 255 , 255 , 255 , 255 , 255 , 255 , 255 , 200 , 30 , 35 , 35 , 0 , 0 , 1 , 1 , 0)

Kod:

insert into k_npcpos values (21 , 13765 , 100 , 0 , 0 , 0 , 6 , 292 , 333 , 292 , 333 , 333 , 292 , 292 , 333 , 1 , 1000 , 0 , 0 , '' )

21.Evt nin sonuna ekleyiniz.

Kod:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;; By BILAL Valentine DB Team ;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
 
EVENT 40501
E SELECT_MSG 15394 3004 22102 32102 22103 32103 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32102
A CHECK_LV 1 20
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E PROMOTE_USER_NOVICE
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E LEVEL_UP
E SAY -1 -1 3005 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32103
E RUN_EVENT 66643
END
 
EVENT 66643; ITEM Bolumu
E SELECT_MSG 15394 3006 22104 32104 22105 32105 22106 32106 22112 32112 22107 32107 22108 32108 22109 32109 22110 32110 22111 32111 22227 32227
END
 
EVENT 32104; SPEARS
E RUN_EVENT 52105
END
 
EVENT 52105; ONE HANDED TWO HANDED SPEARS
E SELECT_MSG 15394 3006 22113 32113 22114 32114 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32113; ONE HANDED SPEAR
E RUN_EVENT 42113
END
 
EVENT 42113
E SELECT_MSG 15394 3006 22115 32115 22116 32116 22117 32117 22118 32118 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32115; SPEAR OF SELFNAME
E GIVE_ITEM 910121308
END
 
EVENT 32116; CHAOS NEBIROS
E GIVE_ITEM 159430778
END
 
EVENT 32117; LUGIAS
E GIVE_ITEM 159301518
END
 
EVENT 32118; CLARTEN SHORT SPEAR
E GIVE_ITEM 159201338
END
 
EVENT 32114
E RUN_EVENT 42114
END
 
EVENT 42114; TWO HANDED SPEAR
E SELECT_MSG 15394 3006 22119 32119 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32119; RAPTOR
E GIVE_ITEM 156210048
END
 
EVENT 32105; CLUBS
E RUN_EVENT 42105
END
 
EVENT 42105; CLUBS
E SELECT_MSG 15394 3006 22120 32120 22121 32121 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32120
E RUN_EVENT 42120
END
 
EVENT 42120; ONE HANDED CLUB
E SELECT_MSG 15394 3006 22122 32122 22123 32123 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32122; IMPACT
E GIVE_ITEM 141110048
END
 
EVENT 32123; SHINITA SECULAR FAN
E GIVE_ITEM 199201358
END
 
EVENT 32121
E RUN_EVENT 42121
END
 
EVENT 42121; TWO HANDED CLUB
E SELECT_MSG 15394 3006 22124 32124 22125 32125 22126 32126 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32124; HELL BREAKER
E GIVE_ITEM 149101228
END
 
EVENT 32125; IRON IMPACT
E GIVE_ITEM 146210048
END
 
EVENT 32126; banger bloom
E GIVE_ITEM 149205858
END
 
EVENT 32106
E RUN_EVENT 42106
END
 
EVENT 42106; AXES
E SELECT_MSG 15394 3006 22127 32127 22128 32128 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32127; ONE HANDED AXE
E RUN_EVENT 42127
END
 
EVENT 42127
E SELECT_MSG 15394 3006 22129 32129 22130 32130 22131 32131 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32129; DEEP SCAR
E GIVE_ITEM 131110048
END
 
EVENT 32130; GiGANTiC AXE 1H LR
E GIVE_ITEM 130450278
END
 
EVENT 32131; death blinding axe
E GIVE_ITEM 139202328
END
 
EVENT 32128
E RUN_EVENT 42128
END
 
EVENT 42128; Two handed axe
E SELECT_MSG 15394 3006 22132 32132 22133 32133 22134 32134 22135 32135 22136 32136 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32132; Blade Axe
E GIVE_ITEM 136210048
END
 
EVENT 32133; CHAOS BAAL
E GIVE_ITEM 139430778
END
 
EVENT 32134; AVEDON
E GIVE_ITEM 139301528
END
 
EVENT 32135; GIGA 2H LR
E GIVE_ITEM 135750278
END
 
EVENT 32136
E GIVE_ITEM 139201748
END
 
EVENT 32107
E RUN_EVENT 42107
END
 
EVENT 42107
E SELECT_MSG 15394 3006 22137 32137 22138 32138 22139 32139 22140 32140 22141 32141 22142 32142 22143 32143 22144 32144 22145 32145 -1 -1
END
 
EVENT 32137; SHiELD OF SELFNAME
E GIVE_ITEM 910126308
END
 
EVENT 32138; DOL
E GIVE_ITEM 179101298
END
 
EVENT 32139; CS
E GIVE_ITEM 170250268
END
 
EVENT 32140; Syphioric
E GIVE_ITEM 179301588
END
 
EVENT 32141; DS
E GIVE_ITEM 179102328
END
 
EVENT 32142; GABS BLESSiNG
E GIVE_ITEM 197420348
END
 
EVENT 32143; nonflammable shield
E GIVE_ITEM 179201368
END
 
EVENT 32144; harakiri shield
E GIVE_ITEM 179401988
END
 
EVENT 32145; scorpion shield
E GIVE_ITEM 170250278
END
 
EVENT 32108; STAFFS
E RUN_EVENT 42108
END
 
EVENT 42108
E SELECT_MSG 15394 3006 22146 32146 22147 32147 22148 32148 22149 32149 22151 32151 22152 32152 22153 32153 22154 32154 22155 32155 22161 32161
END
 
EVENT 32146: STAFF OF SELFNAME
E GIVE_ITEM 910123578
END
 
EVENT 32147; UNDEFEATABLE FULiTOL
E GIVE_ITEM 182410798
END
 
EVENT 32148; KATANA STAFF
E GIVE_ITEM 189503788
END
 
EVENT 32149; ELixir Staff
E GIVE_ITEM 181110518
E GIVE_ITEM 181110168
E GIVE_ITEM 181110188
END
 
EVENT 32150; KREAKLY MAGICIAN STAFF iptal
E GIVE_ITEM 189701878
E GIVE_ITEM 189801878
E GIVE_ITEM 189901878
END
 
EVENT 32151; DElİGTH STAFF FLOWER
E GIVE_ITEM 189509608
E GIVE_ITEM 189505618
E GIVE_ITEM 189508598
END
 
EVENT 32152; MONKS STAFF OF DESTRUCTION
E GIVE_ITEM 189501348
END
 
EVENT 32153; hell blood
E GIVE_ITEM 189601548
END
 
EVENT 32154; garp
E GIVE_ITEM 189602558
END
 
EVENT 32155;Elysium
E GIVE_ITEM 189603568
END
 
EVENT 32161
E RUN_EVENT 42161
END
 
EVENT 42161; SECOND PAGE
E SELECT_MSG 15394 3006 22156 32156 22157 32157 22158 32158 22159 32159 22160 32160 22161 32161 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32156; WOE
E GIVE_ITEM 189101308
END
 
EVENT 32157; LR EREnion
E GIVE_ITEM 189301278
END
 
EVENT 32158; GLacier Erenion
E GIVE_ITEM 189201268
END
 
EVENT 32159; RONS
E GIVE_ITEM 189401288
END
 
EVENT 32160; AZTEC GOLD MOLOK FULİTOL FAUN
E GIVE_ITEM 182430818
E GIVE_ITEM 183230848
E GIVE_ITEM 184430878
END
 
EVENT 32109
E RUN_EVENT 42109
END
 
EVENT 42109; DAGGERS
E SELECT_MSG 15394 3006 22162 32162 22164 32164 22165 32165 22166 32166 22167 32167 22168 32168 22169 32169 22170 32170 22171 32171 -1 -1
END
 
EVENT 32162; Dagger of selfname
E GIVE_ITEM 910119308
END
 
EVENT 32163; HARD BANDE DAGGER iptal
E GIVE_ITEM 119206328
END
 
EVENT 32164;shard
E GIVE_ITEM 111210048
END
 
EVENT 32165; SHERiON
E GIVE_ITEM 119301508
END
 
EVENT 32166; COLD-HEARTED DAGGER
E GIVE_ITEM 119102418
END
 
EVENT 32167: DARK VANE
E GIVE_ITEM 119101208
END
 
EVENT 32168; LOUSLY PiCKPOCKET RAUM
E GIVE_ITEM 128440838
END
 
EVENT 32169; rAUM ON SEVERE DiET
E GIVE_ITEM 128420818
END
 
EVENT 32170; bloodly of the tiger
E GIVE_ITEM 119201318
END
 
EVENT 32171
E GIVE_ITEM 119202648
END
 
EVENT 32110; HAMMERS
E RUN_EVENT 42110
END
 
EVENT 42110; HAMMERS
E SELECT_MSG 15394 3006 22172 32172 22173 32173 22174 32174 22175 32175 22176 32176 22177 32177 22178 32178 22179 32179 22180 32180 -1 -1
END
 
EVENT 32172; lupus hammer 
E GIVE_ITEM 190250288
END
 
EVENT 32173; lobo hammer
E GIVE_ITEM 190250278
END
 
EVENT 32174; dragon tooth hammer
E GIVE_ITEM 190610318
END
 
EVENT 32175; Smite hammer
E GIVE_ITEM 199101248
END
 
EVENT 32176; katasha trap bone mace
E GIVE_ITEM 199202708
END
 
EVENT 32177; MACE OF SELFNAME
E GIVE_ITEM 910125378
END
 
EVENT 32178; HOLY ANiMOR
E GIVE_ITEM 199301578
END
 
EVENT 32179; LYCAON HAMMER
E GIVE_ITEM 190250298
END
 
EVENT 32180; STONE SPLiTTER
E GIVE_ITEM 199102418
END
 
EVENT 32111
E RUN_EVENT 42111
END
 
EVENT 42111; Accessories
E SELECT_MSG 15394 3006 22181 32181 22182 32182 22183 32183 22184 32184 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32181
E RUN_EVENT 42181
END
 
EVENT 32182
E RUN_EVENT 42182
END
 
EVENT 32183
E RUN_EVENT 42183
END
 
EVENT 32184
E RUN_EVENT 42184
END
 
EVENT 42181; Amulets
E SELECT_MSG 15394 3006 22185 32185 22186 32186 22187 32187 22188 32188 22189 32189 22190 32190 22191 32191 22192 32192 -1 -1 -1 -1
END
 
EVENT 32185; Iron Neck
E GIVE_ITEM 320310411
END
 
EVENT 32186; elemental pendant
E GIVE_ITEM 320110313
END
 
EVENT 32187: Priest Pendant
E GIVE_ITEM 320110323
END
 
EVENT 32188; Warrior pendant
E GIVE_ITEM 320110303
END
 
EVENT 32189; Amulet of str
E GIVE_ITEM 320610343
END
 
EVENT 32190; Amulet Of dex
E GIVE_ITEM 320510353
END
 
EVENT 32191; AMULET OF health
E GIVE_ITEM 320510383
END
 
EVENT 32192; Amulet of MP
E GIVE_ITEM 320310373
END
 
EVENT 42182; Earrings
E SELECT_MSG 15394 3006 22193 32193 22194 32194 22195 32195 22196 32196 22197 32197 22198 32198 22199 32199 22200 32200 22201 32201 -1 -1
END
 
EVENT 32193; Platinum earring
E GIVE_ITEM 310410243
END
 
EVENT 32194; SSE
E GIVE_ITEM 310410263
END
 
EVENT 32195; WSE
E GIVE_ITEM 310610273
END
 
EVENT 32196; AGATE Earring
E GIVE_ITEM 310410283
END
 
EVENT 32197; EME
E GIVE_ITEM 310610253
END
 
EVENT 32198; Howling Rooster
E GIVE_ITEM 310512143
END
 
EVENT 32199; Lich Kings Pride
E GIVE_ITEM 310513153
END
 
EVENT 32200; Lillimes
E GIVE_ITEM 310514163
END
 
EVENT 32201; Minotaurs
E GIVE_ITEM 310511133
END
 
EVENT 42183; Belts
E SELECT_MSG 15394 3006 22202 32202 22203 32203 22211 32211 22205 32205 22206 32206 22210 32210 22207 32207 22208 32208 22209 32209 22212 32212
END
 
EVENT 32202; Iron Belt
E GIVE_ITEM 340610371
END
 
EVENT 32203; GLASS
E GIVE_ITEM 340410391
END
 
EVENT 32211; SKELETON BELT
E GIVE_ITEM 340410453
END
 
EVENT 32205; STRING OF SKULLS
E GIVE_ITEM 340410163
END
 
EVENT 32206; SASH OF SORROWS
E GIVE_ITEM 340510143
END
 
EVENT 32210; Judicious Belt
E GIVE_ITEM 340610153
END
 
EVENT 32207; BELT OF DEX
E GIVE_ITEM 340610413
END
 
EVENT 32208; BELT OF STR
E GIVE_ITEM 340510403
END
 
EVENT 32209; BELT OF LiFE
E GIVE_ITEM 340110313
END
 
EVENT 32212; ELF BELT
E GIVE_ITEM 340410433
END
 
EVENT 42184; Rings
E SELECT_MSG 15394 3006 22213 32213 22214 32214 22215 32215 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32213; ROC
E GIVE_ITEM 330110303
END
 
EVENT 32214; ROL
E GIVE_ITEM 330150323
END
 
EVENT 32215; ROM
E GIVE_ITEM 330150313
END
 
EVENT 32112
E RUN_EVENT 42112
END
 
EVENT 42112;SWORDS
E SELECT_MSG 15394 3006 22221 32221 22222 32222 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32221
E RUN_EVENT 42221
END
 
EVENT 32222
E RUN_EVENT 42222
END
 
EVENT 42221; ONE HANDED SWORD
E SELECT_MSG 15394 3006 22216 32216 22217 32217 22218 32218 22219 32219 22220 32220 22221 32221 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32216; GRAHAM
E GIVE_ITEM 121310048
END
 
EVENT 32217; HANGUK
E GIVE_ITEM 129101218
END
 
EVENT 32218; Nameless white
E GIVE_ITEM 129201328
END
 
EVENT 32219; Thief God Sword
E GIVE_ITEM 129203348
END
 
EVENT 32220; CUTTER HAND
E GIVE_ITEM 129401828
END
 
EVENT 42222; TWO HANDED SWORD
E SELECT_MSG 15394 3006 22223 32223 22224 32224 22225 32225 22226 32226 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32223; TWO HANDED SWORD OF SELFNAME
E GIVE_ITEM 910120358
END
 
EVENT 32224; CHAOS WIRINOM
E GIVE_ITEM 127430758
END
 
EVENT 32225; SWORDLY OF THE TIGER
E GIVE_ITEM 149401838
END
 
EVENT 32226; MS
E GIVE_ITEM 126410048
END
 
EVENT 32227
E RUN_EVENT 42227
END
 
EVENT 42227
E SELECT_MSG 15394 3006 22228 32228 22229 32229 22230 32230 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32228
E RUN_EVENT 42228
END
 
EVENT 42228; VALKYRiE
E SELECT_MSG 15394 3006 22231 32231 22232 32232 22233 32233 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32231; HP
E GIVE_ITEM 508014510
E GIVE_ITEM 508011510
E GIVE_ITEM 508013510
E GIVE_ITEM 508014510
E GIVE_ITEM 508015510
END
 
EVENT 32233; DEX www.knightonlinepvp.net
E GIVE_ITEM 508014520
E GIVE_ITEM 508012520
E GIVE_ITEM 508013520
E GIVE_ITEM 508015520
E GIVE_ITEM 508011520
END
 
EVENT 32232; STR
E GIVE_ITEM 508012020
E GIVE_ITEM 508015020
E GIVE_ITEM 508013020
E GIVE_ITEM 508011020
E GIVE_ITEM 508014020
END
 
EVENT 32229
E RUN_EVENT 42229
END
 
EVENT 42229; GRYPHON
E SELECT_MSG 15394 3006 22234 32234 22235 32235 22236 32236 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32234; HP
E GIVE_ITEM 808013510
E GIVE_ITEM 808014510
E GIVE_ITEM 808011510
E GIVE_ITEM 808015510
E GIVE_ITEM 808012510
END
 
EVENT 32235; STR
E GIVE_ITEM 808012020
E GIVE_ITEM 808011020
E GIVE_ITEM 808013020
E GIVE_ITEM 808014020
E GIVE_ITEM 808015020
END
 
EVENT 32236; DEX
E GIVE_ITEM 808013520
E GIVE_ITEM 808014520
E GIVE_ITEM 808015520
E GIVE_ITEM 808012520
E GIVE_ITEM 808011520
END
 
EVENT 32230
E RUN_EVENT 42230
END
 
EVENT 42230; BAHAMUT
E SELECT_MSG 15394 3006 22237 32237 22238 32238 22239 32239 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END
 
EVENT 32237; HP
E GIVE_ITEM 608014510
E GIVE_ITEM 608015510
E GIVE_ITEM 608012510
E GIVE_ITEM 608011510
E GIVE_ITEM 608013510
END
 
EVENT 32238; STR
E GIVE_ITEM 608014020
E GIVE_ITEM 608012020
E GIVE_ITEM 608015020
E GIVE_ITEM 608013020
E GIVE_ITEM 608011020
END
 
EVENT 32239; DEX
E GIVE_ITEM 608014520
E GIVE_ITEM 608015520
E GIVE_ITEM 608011520
E GIVE_ITEM 608012520
E GIVE_ITEM 608013520
END

Dilek Ağacı NPC'si (Data'ya Atılacak) [MediaFire]
Dilek Ağacı NPC'si (Data'ya Atılacak) [Rapidshare]
Dilek Ağacı NPC'si (Data'ya Atılacak) [Dosya.Tc]

Montesque Ardream Database V1 [2 Adet Krowaz & Darkland - Yeni Skiller - Yeni Itemler]

Database Özellikler:

2 Adet Krowaz
2 Adet Darkland
Yeni Zone 2 tane [ Cape Quest]
Yeni Skiller
Yeni itemler
Tüm İtemler Sorunsuz Hero Armor , Jpko İtemler Rebirth İtemler
Bosslar Ardreama Göre Ayarlandı
Krowaz ve Darkland Ardreama Göre Ayarlandı
Gateler Sorunsuz Çalısmaktadır.
Ardreamda Yeni Görevler
Özel Ardream Npcleri
Ardream Npc ve Monsterlar Usko Style
Sorunsuz Delos Savaşı
Sorunsuz İsim Geçmektedir
Towerlar Sorunsuz
Rebirth İtemler ;

Kod:

Complete Helmet Rebirth (+8)
Complete Boots Rebirth (+8)
Rogue Chitin Shell Pauldron Rebirth (+8)
Priest Chitin Shell Gauntlet Rebirth (+8)
Priest Chitin Shell Pads Rebirth (+8)
Rogue Chitin Shell Boots Rebirth (+8)
Chitin Shell Helmet Rebirth (+8)
Chitin Shell Boots Rebirth (+8)
Complete Robe Rebirth (+8)
Chitin Shell Pads Rebirth (+8)
Priest Chitin Shell Helmet Rebirth (+8)
Complete Pants Rebirth (+8)
Priest Chitin Shell Pauldron Rebirth (+8)
Priest Chitin Shell Boots Rebirth (+8)
Rogue Chitin Shell Pads Rebirth (+8)
Chitin Shell Pauldron Rebirth (+8)
Complete Glove Rebirth (+8)
Rogue Chitin Shell Gauntlet Rebirth (+8)
Rebirth Scroll
Rebirth Smite Hammer(+10)
Rebirth Enion Bow(+9)
Rebirth Holy Animor(+9)
Rebirth Hell Blood(+10)
Rebirth Raptor (+9)
Rebirth Hell Breaker(+8)
Rebirth Dark Vane(+10)
Rebirth Defender of the Lord(+9)
Rebirth Lightning Erenion(+10)
Rebirth Raptor (+10)
Rebirth Sherion(+8)
Rebirth Defender of the Lord(+10)
Rebirth Rons Staff(+10)
Rebirth Garp(+10)
Rebirth Sweet Kiss Wirinom(+8)
Rebirth Chaos Wirinom(+10)
Rebirth Trainer Kate Fulitol(+10)
Rebirth Chaos Baal(+8)
Rebirth Sweet Kiss Nebiros(+10)
Rebirth Weak Dwarf Raum(+8)
Rebirth Weak Dwarf Raum(+9)
Rebirth Double Possession(+9)
Rebirth Secular Fan(+8)
Rebirth Dark Vane(+8)
Rebirth Hanguk Sword(+9)
Rebirth Garp(+8)
Rebirth Warm Downpour Windforce(+10)
Rebirth Aztec Gold Molok(+10)
Rebirth Sweet Kiss Baal(+8)
Rebirth Undefeatable Nebiros(+10)
Rebirth Gabs Blessing(+9)
Rebirth Priest Impact(+10)
Rebirth Sherion(+10)
Rebirth Sherion(+9)
Rebirth Wreath of Erenion(+10)
Rebirth Elysium(+8)
Rebirth Lousy Pickpocket Windforce(+10)
Rebirth Trainer Kate Faun(+9)
Rebirth Undefeatable Baal(+8)
Rebirth Weak Dwarf Nebiros(+10)
Rebirth Lousy Pickpocket Raum(+10)
Rebirth Elixir Staff (+8)
Rebirth Defender of the Lord(+8)
Rebirth Sweet Kiss Wirinom(+10)
Rebirth Undefeatable Molok(+8)
Rebirth Undefeatable Faun(+9)
Rebirth Trainer Kate Faun(+8)
Rebirth Monks Staff of Destruction(+10)
Rebirth Lugias(+9)
Rebirth Hell Blood(+8)
Rebirth Syphioric(+8)
Rebirth Sweet Kiss Nebiros(+9)
Rebirth Mean Leonar(+9)
Rebirth Undefeatable Leonar(+9)
Rebirth Undefeatable Leonar(+10)
Rebirth Nonflammable Shield(+10)
Rebirth Priest Impact(+9)
Rebirth Shard (+8)
Rebirth Iron Impact (+8)
Rebirth Dark Vane(+9)
Rebirth Hanguk Sword(+10)
Rebirth Hanguk Sword(+8)
Rebirth Garp(+9)
Rebirth Syphioric(+10)
Rebirth Windforce on Severe Diet(+8)
Rebirth Trainer Kate Fulitol(+8)
Rebirth Aztec Gold Faun(+9)
Rebirth Weak Dwarf Raum(+10)
Rebirth Helenid Cross Bow(+10)
Rebirth Syphioric(+9)
Rebirth Lousy Pickpocket Windforce(+8)
Rebirth Warm Downpour Windforce(+8)
Rebirth Undefeatable Wirinom(+9)
Rebirth Chaos Wirinom(+8)
Rebirth Aztec Gold Fulitol(+10)
Rebirth Undefeatable Faun(+8)
Rebirth Trainer Kate Faun(+10)
Rebirth Aztec Gold Faun(+10)
Rebirth Weak Dwarf Leonar(+9)
Rebirth Cut Snake Tail(+9)
Rebirth Monks Staff of Destruction(+9)
Rebirth Nameless White Cherry Blossom(+9)
Rebirth Secular Fan(+9)
Rebirth Enion Bow(+8)
Rebirth Wreath of Erenion(+8)
Rebirth Elysium(+10)
Rebirth Lousy Pickpocket Windforce(+9)
Rebirth Undefeatable Molok(+10)
Rebirth Aztec Gold Molok(+9)
Rebirth Undefeatable Baal(+10)
Rebirth Sweet Kiss Baal(+9)
Rebirth Chaos Nebiros(+10)
Rebirth Undefeatable Nebiros(+9)
Rebirth Weak Dwarf Leonar(+10)
Rebirth Gabs Blessing(+10)
Rebirth Death Wing Bow(+9)
Rebirth Shard (+9)
Rebirth Elixir Staff (+9)
Rebirth Smite Hammer(+8)
Rebirth Lightning Erenion(+8)
Rebirth Wreath of Erenion(+9)
Rebirth Rons Staff(+9)
Rebirth Helenid Cross Bow(+8)
Rebirth Holy Animor(+10)
Rebirth Hell Blood(+9)
Rebirth Lousy Pickpocket Windforce(+8)
Rebirth Windforce on Severe Diet(+9)
Rebirth Undefeatable Wirinom(+10)
Rebirth Undefeatable Faun(+10)
Rebirth Chaos Nebiros(+8)
Rebirth Weak Dwarf Nebiros(+8)
Rebirth Undefeatable Raum(+9)
Rebirth Raum on Severe Diet(+9)
Rebirth Cut Snake Tail(+10)
Rebirth Hell Breaker(+9)
Rebirth Lightning Erenion(+9)
Rebirth Lousy Pickpocket Windforce(+9)
Rebirth Weak Dwarf Windforce(+10)
Rebirth Undefeatable Wirinom(+8)
Rebirth Weak Dwarf Wirinom(+9)
Rebirth Aztec Gold Fulitol(+9)
Rebirth Trainer Kate Molok(+9)
Rebirth Lousy Pickpocket Raum(+9)
Rebirth Death Wing Bow(+8)
Rebirth Double Possession(+8)
Rebirth Kentaraus Face
Rebirth Raptor (+8)
Rebirth Elixir Staff (+10)
Rebirth Avedon(+10)
Rebirth Avedon(+8)
Rebirth Lousy Pickpocket Windforce(+10)
Rebirth Weak Dwarf Wirinom(+8)
Rebirth Weak Dwarf Wirinom(+10)
Rebirth Undefeatable Fulitol(+9)
Rebirth Weak Dwarf Baal(+10)
Rebirth Undefeatable Leonar(+8)
Rebirth Lousy Pickpocket Raum(+8)
Rebirth Undefeatable Raum(+8)
Rebirth Death Wing Bow(+10)
Rebirth Double Possession(+10)
Rebirth Nameless White Cherry Blossom(+10)
Rebirth Secular Fan(+10)
Rebirth Smite Hammer(+9)
Rebirth Glacier Erenion(+9)
Rebirth Glacier Erenion(+8)
Rebirth Lugias(+10)
Rebirth Weak Dwarf Windforce(+9)
Rebirth Trainer Kate Molok(+8)
Rebirth Sweet Kiss Baal(+10)
Rebirth Sweet Kiss Nebiros(+8)
Rebirth Gabs Blessing(+8)
Rebirth Nonflammable Shield(+8)
Rebirth Iron Impact (+10)
Rebirth Hell Breaker(+10)
Rebirth Glacier Erenion(+10)
Rebirth Rons Staff(+8)
Rebirth Lugias(+8)
Rebirth Helenid Cross Bow(+9)
Rebirth Chaos Wirinom(+9)
Rebirth Chaos Nebiros(+9)
Rebirth Nonflammable Shield(+9)
Rebirth Shard (+10)
Rebirth Avedon(+9)
Rebirth Enion Bow(+10)
Rebirth Weak Dwarf Windforce(+8)
Rebirth Aztec Gold Molok(+8)
Rebirth Chaos Baal(+9)
Rebirth Chaos Baal(+10)
Rebirth Mean Leonar(+8)
Rebirth Raum on Severe Diet(+10)
Rebirth Holy Animor(+8)
Rebirth Elysium(+9)
Rebirth Sweet Kiss Wirinom(+9)
Rebirth Undefeatable Fulitol(+8)
Rebirth Undefeatable Fulitol(+10)
Rebirth Aztec Gold Faun(+8)
Rebirth Undefeatable Baal(+9)
Rebirth Weak Dwarf Baal(+8)
Rebirth Weak Dwarf Baal(+9)
Rebirth Weak Dwarf Leonar(+8)
Rebirth Undefeatable Raum(+10)
Rebirth Nameless White Cherry Blossom(+8)
Rebirth Warm Downpour Windforce(+9)
Rebirth Windforce on Severe Diet(+10)
Rebirth Trainer Kate Fulitol(+9)
Rebirth Aztec Gold Fulitol(+8)
Rebirth Undefeatable Molok(+9)
Rebirth Trainer Kate Molok(+10)
Rebirth Weak Dwarf Nebiros(+9)
Rebirth Undefeatable Nebiros(+8)
Rebirth Mean Leonar(+10)
Rebirth Cut Snake Tail(+8)
Rebirth Monks Staff of Destruction(+8)
Rebirth Raum on Severe Diet(+8)
Rebirth Priest Impact(+8)

Sorunsuz Montesque Server Files
Montesque Anti Cheat
2 Adet Ebenezer 1.En son LeveL 59 2. En Son LeveL 83

Exe Packlemedim İsteyen Değiştirebilir Diye Pack Programı Vericem
Montesque Ardream Database V1

Montesque Andream Database v1 Full Patch & Server Files [MediaFire]

Packsiz Sorunsuz Myko Fix Hile Fix Exe [Verdiğim Server FilesLere Uyumlu]
İsteyenlerede Packli Exe [Verdiğim Server FilesLere Uyumlu]
Pack Programı

Gerekli Kodlar

Kod:

--DropLarın KoLayLık ZorLuk AyarLama
EXEC KoLay_Drop
EXEC Zor_Drop
--Upgrade KoLayLık ZorLuk AyarLama
EXEC KoLay_Upgrade
EXEC Zor_Upgrade
--LeveL_Up KoLayLık ZorLuk AyarLama
EXEC KoLay_LeveL
EXEC Zor_LeveL
--Serverin KoLayLık ZorLuk AyarLama[GeneL]
EXEC Zor_ServeR 
EXEC KoLay ServeR

EXEC ACCOUNT_NATION_TRANSFER 'HESAP_IDSI
exec namechange 'suankisim', 'yenisim'
exec ilk5g0

OyunCanavari.Net Panel v3 [Küçük Boyutuyla Çok Hızlı Panel]

1299 Private Serverlarda, daha önce ziyaettin'in yapmış olduğu;

SanalHat Panel v4

'ü paylaşmıştık. Şimdi ise bu panel bir alt versiyonu olan Oyuncanavari.NET Panel v3 'ü paylaşıyoruz.

Özellikler

Flood koruması
Güvenlik sistemleri
Anti inject
Panel düzenlemek çok kolay!!!
Kurulum basit
Tasarım sade
Sadece 65 KB...
Sayfalar çok hızlı açılır
Gereksiz resimler ve serveri yoracak gereksiz özellikler yoktur...

Kurulum:

Aşağıdaki linkten dosyayı alın.
.rar'dan çıkarın ve AppServ içindeki www klasörü içine atınız.
Daha sonra frame/ayarlar.php'yi kendinize göre düzenleyin.

OyunCanavari.NET Panel v3 [MediaFire]
OyunCanavari.NET Panel v3 [Rapidshare]
OyunCanavari.NET Panel v3 [Dosya.Tc]

SanalHat Panel v4

1299 Private Serverlarda, bir çok kopanel teması yayımlamıştık.. Şimdi de yeni bir kopanel teması ile karşınızdayız.. Ziyaettin'in yapmış olduğu SanalHat Panel v4'ü sizinle paylaşacağız..

Özellikleri:

Flood koruması
Güvenlik sistemleri
Anti inject
Panel düzenlemek çok kolay!!!
Kurulum basit
Tasarım sade
Sadece 165 KB...
Sayfalar çok hızlı açılır
Gereksiz resimler ve serveri yoracak gereksiz özellikler yoktur...
Otomatik banner ayarlanır
MP3 Player eklendi
Power UP Store eklendi
Daha gelişmiş menu yapıldı
Eski versiyonda bulunan tüm hatalar giderildi.

Kurulum:

Aşağıdaki linkten dosyayı alın.
.rar'dan çıkarın ve AppServ içindeki www klasörü içine atınız.
Daha sonra frame/ayarlar.php'yi kendinize göre düzenleyin.

SanalHat Panel v4 [Rapidshare]

KingDooM Panel v1

1299 Private Serverlarda, daha önce bir çok kopanel paylaşmıştık.. Bugünde KingDooM'un yaptığı KingDooM Panelv1'yi paylaşacağız.. Ama daha öncesinde sizinle paylaştığımız kopanel temalarını aşağıda görebilirsiniz;

KingDooM Panel v1 İşlevi;

Gayet güzel bir tasarım
Anasayfa
Forum
GM Listesi
Ban Listesi
Kullanıcı Sıralaması
Clan Sıralaması

Kurulum:

Aşağıdaki linkten dosyayı alın.
.rar'dan çıkarın ve AppServ içindeki www klasörü içine atınız.
Daha sonra frame/settings.php'yi kendinize göre düzenleyin.

KingDooM Panel v1 [MediaFire]
KingDooM Panel v1 [Rapidshare]
KingDooM Panel v1 [dosya.tc]

16 Haziran 2009 Salı

NPC Editör [Kolaylıkla NPC'lerinizi Editleyebileceksiniz.]

1299 Private Serverlarda, server sahiplerinin gereksinimlerini daha hızlı ve kolay bir şekilde gerçekleştirebilmek için hazırlanmış bir çok yardımcı program sunmuştuk size. Şimdi ise serverınızda bulunan npclerin;

Adını
Vereceği Parasını
Vereceği EXP'yi
Defansını
Levelini
Vereceği NP'sini
NPC'nin sahip olduğu HP miktarı
NPC'nin sahip olduğu MP miktarı
Atack Yapıp Yapmayacağı
Atack Hızı
Sol ve Sağ Eline Verilecek İtemler
Koşma Hızı, Yürüme Hızı
Lighting,Flame,Glacier Resistanslarını editleyebileceğiniz çok güzel bir program..

Kurulum:

Aşağıdaki herhangi bir linkten dosyayı indirin ve .rar'dan çıkarın.
İçinde bulunan "NPC Editör.exe" 'yi çalıştırın.
Daha sonra Local ve ya Uzak Bağlantı'sını seçiniz.
Editledikten sonra Kaydet diyerek çıkıyoruz.

NPC Editör [MediaFire]
NPC Editör [Rapidshare]

NPC Editör [dosya.tc]

+10,+9 İtemleri +8'e ve +5,+4 Uniqueleri +3 veya +1 Çekme.

1299 Private Serverlarda, genellikle +8 ve üstü itemler tercih ediliyor.. Fakat DB'nizde +9 ve +10 itemler olup bunların +'sını 8'e çekmek istiyorsanız.. Aşağıda tam size göre bir paylaşım var .

Aşağıdaki Kodlar Tamamen AKUMA'ya aittir. Kodların amacı;

Bu Procedur +10 İtemleri +8 / +5 Uniqueleri +3 e veya +1 e Çekmenize yarar Girişte Tarama Yapar.

Denenmiştir , Hiçbir Sakıncası , Hiçbir BUGU Yoktur!

İlk Once ITEM Tablomuzda biraz değişiklik yapalım , +10 itemler +0 yazıyor , Onları +10 olarak değiştirelim.

Kod:

DECLARE @Num int,@strName varchar(100),@ProcessCount int
 /*
Author : Ceribrio
*/
DECLARE CRS_ITEM_TABLE CURSOR FOR
SELECT Num,strName FROM ITEM WHERE strName LIKE '%(+0)%' AND Kind <> 91 AND Kind <> 92 AND Kind <> 93 AND Kind <> 94
 
SET @ProcessCount = 0
 
OPEN CRS_ITEM_TABLE
 
FETCH NEXT FROM CRS_ITEM_TABLE INTO @Num,@strName
 
WHILE (@@FETCH_STATUS = 0)
BEGIN
 
DECLARE @ItemName varchar(100),@ItemNum int,@RealItemName varchar(100),@CheckItemName varchar(100),@NewItemName varchar(100),@FindCount int
 
SELECT @ItemNum = Num, @ItemName = strName FROM ITEM WHERE Num = @Num - 2
 
SELECT @FindCount = Count(Num) FROM ITEM WHERE Num = @ItemNum
 
    IF @FindCount <> 0
    BEGIN
        SET @RealItemName = RTRIM(LTRIM(REPLACE(@strName,'(+0)','')))        
        SET @CheckItemName = RTRIM(LTRIM(REPLACE(@ItemName,'(+8)','')))
 
            IF @RealItemName = @CheckItemName
            BEGIN
                SET @NewItemName = @RealItemName + ' (+10)'
                UPDATE ITEM SET strName = @NewItemName WHERE Num = @Num
                SET @ProcessCount = @ProcessCount + 1
            END
    END
 
FETCH NEXT FROM CRS_ITEM_TABLE INTO @Num,@strName
END
 
CLOSE CRS_ITEM_TABLE
 
DEALLOCATE CRS_ITEM_TABLE
 
PRINT 'Değiştirilen İtem Sayısı : ' + RTRIM(LTRIM(STR(@ProcessCount)))

Bu kodu Query'den çalıstırın ve bekleyin ... 5- 10 Dakika ve daha fazla sürebilir ...

Eklenecek tablolarımız :

Kod:

/****** Object:  Table [dbo].[RESULT_CHECK_USER_ITEMS]    Script Date: 07/12/2008 14:12:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RESULT_CHECK_USER_ITEMS](
    [Num] [int] NULL,
    [stacksize] [smallint] NULL,
    [Durability] [smallint] NULL,
    [strUserId] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [InventorySlot] [int] NULL,
    [ItemName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [extname] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
 
GO
SET ANSI_PADDING OFF

Kod:

/****** Object:  Table [dbo].[RESULT_CHECK_USER_ITEMS_LOGS]    Script Date: 07/12/2008 14:13:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RESULT_CHECK_USER_ITEMS_LOGS](
    [strUserId] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OldItemNum] [int] NULL,
    [OldItemName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OptimizedItemNum] [int] NULL,
    [OptimizedItemName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
 
GO
SET ANSI_PADDING OFF

Editlenecek Tablo ;

Kod:

Userdata'yı Desing Table diyerek açın ve , En Son'a bir Satır Ekleyin , İsmi UserStatus olsun , int Olacak ... Nulls İşaretsiz olacak ! ve Default değeri 0 olacak !

Eklenecek Prosedürler :

Eğer +4 +5 Takıların , +1 Olmasını istiyorsanız Bunu Ekleyin ! Bir Alttakini eklemeyin !

Kod:

CREATE PROCEDURE [dbo].[CHECK_USER_ITEMS] 
(@strUserID varchar(50))
AS
 
/*
Author : Ceribrio
*/
 
BEGIN
DECLARE @Authority int,@UserStatus int
 
SELECT @Authority = Authority,@UserStatus = UserStatus FROM USERDATA WHERE strUserID = @strUserID
 
IF (@Authority <> 0) OR (@UserStatus <> 1)
BEGIN
 
TRUNCATE TABLE RESULT_CHECK_USER_ITEMS
EXEC CHECK_FIND_USER_ITEMS @strUserID
 
   DECLARE @Num int,@ItemName varchar(100),@InventorySlotNumber int
 
   DECLARE CRS_RESULT_CHECK_USER_ITEMS CURSOR FOR
   SELECT Num,ItemName,InventorySlot FROM RESULT_CHECK_USER_ITEMS WHERE strUserID = @strUserID AND ItemName <> 'Free Slot'
 
   OPEN CRS_RESULT_CHECK_USER_ITEMS
 
   FETCH NEXT FROM CRS_RESULT_CHECK_USER_ITEMS INTO @Num, @ItemName, @InventorySlotNumber
   WHILE (@@FETCH_STATUS = 0)
   BEGIN
 
       DECLARE @ItemStrName varchar(100),@ItemNum int,@NewItemNum int,@Kind tinyint,@ItemType int,@CheckNum int
 
       SET @ItemStrName = ''
       SET @ItemNum = 0
       SET @NewItemNum = 0
       SET @Kind = 0
       SET @ItemType = 0
       SET @CheckNum = 0
 
       IF CHARINDEX('+10',@ItemName) <> 0
       BEGIN
           SELECT @ItemNum = Num,@Kind = Kind FROM ITEM WHERE Num = @Num
           SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 2
           IF (@Kind != 91) OR (@Kind != 92) OR (@Kind != 93) OR (@Kind != 94)
           BEGIN
           SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
               IF @CheckNum <> 0
               BEGIN
               UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum,ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
               INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
               END
           END 
       END
       ELSE IF CHARINDEX('+9',@ItemName) <> 0
       BEGIN
           SELECT @ItemNum = Num,@Kind = Kind FROM ITEM WHERE Num = @Num
           SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 1
           IF (@Kind != 91) OR (@Kind != 92) OR (@Kind != 93) OR (@Kind != 94)
           BEGIN
           SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
               IF @CheckNum <> 0
               BEGIN
               UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum,ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
               INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
               END
           END 
       END
       ELSE IF CHARINDEX('+5',@ItemName) <> 0
       BEGIN
           SELECT @ItemNum = Num,@Kind = Kind,@ItemType = ItemType FROM ITEM WHERE Num = @Num
           IF @Kind = 91 OR @Kind = 92 OR @Kind = 93 OR @Kind = 94
           BEGIN
               SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
               IF @CheckNum <> 0
               BEGIN
                   IF @ItemType = 4
                   BEGIN
                   SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 4
                   UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum, ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                   INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                   END
               END
           END 
       END
       ELSE IF CHARINDEX('+4',@ItemName) <> 0
       BEGIN
           SELECT @ItemNum = Num,@Kind = Kind,@ItemType = ItemType FROM ITEM WHERE Num = @Num
           IF @Kind = 91 OR @Kind = 92 OR @Kind = 93 OR @Kind = 94
           BEGIN
               SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
               IF @CheckNum <> 0
               BEGIN
                   IF @ItemType = 4
                   BEGIN
                   SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 3
                   UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum, ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                   INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                   END
               END
           END 
       END
       ELSE IF CHARINDEX('+3',@ItemName) <> 0
       BEGIN
           SELECT @ItemNum = Num,@Kind = Kind,@ItemType = ItemType FROM ITEM WHERE Num = @Num
           IF @Kind = 91 OR @Kind = 92 OR @Kind = 93 OR @Kind = 94
           BEGIN
               SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
               IF @CheckNum <> 0
               BEGIN
                   IF @ItemType = 4
                   BEGIN
                   SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 2
                   UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum, ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                   INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                   END
               END
           END 
       END
       ELSE IF CHARINDEX('+2',@ItemName) <> 0
       BEGIN
           SELECT @ItemNum = Num,@Kind = Kind,@ItemType = ItemType FROM ITEM WHERE Num = @Num
           IF @Kind = 91 OR @Kind = 92 OR @Kind = 93 OR @Kind = 94
           BEGIN
               SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
               IF @CheckNum <> 0
               BEGIN
                   IF @ItemType = 4
                   BEGIN
                   SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 1
                   UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum, ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                   INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                   END
               END
           END 
       END
 
   FETCH NEXT FROM CRS_RESULT_CHECK_USER_ITEMS INTO @Num, @ItemName, @InventorySlotNumber
   END
 
   CLOSE CRS_RESULT_CHECK_USER_ITEMS
 
   DEALLOCATE CRS_RESULT_CHECK_USER_ITEMS
 
EXEC CHECK_ENCODE_USER_ITEMS @strUserID
 
END
 
END

Eğer +4 +5 takıların , +3 olmasını istiyorsanız Bunu Ekleyin Bir Üsttekini eklemeyin !

Kod:

CREATE PROCEDURE [dbo].[CHECK_USER_ITEMS] 
(@strUserID varchar(50))
 AS
 
/*
Author : Ceribrio
*/
 
BEGIN
DECLARE @Authority int,@UserStatus int
 
SELECT @Authority = Authority,@UserStatus = UserStatus FROM USERDATA WHERE strUserID = @strUserID
 
IF (@Authority <> 0) OR (@UserStatus <> 1)
BEGIN
 
TRUNCATE TABLE RESULT_CHECK_USER_ITEMS
EXEC CHECK_FIND_USER_ITEMS @strUserID
 
    DECLARE @Num int,@ItemName varchar(100),@InventorySlotNumber int
 
    DECLARE CRS_RESULT_CHECK_USER_ITEMS CURSOR FOR
    SELECT Num,ItemName,InventorySlot FROM RESULT_CHECK_USER_ITEMS WHERE strUserID = @strUserID AND ItemName <> 'Free Slot'
 
    OPEN CRS_RESULT_CHECK_USER_ITEMS
 
    FETCH NEXT FROM CRS_RESULT_CHECK_USER_ITEMS INTO @Num, @ItemName, @InventorySlotNumber
    WHILE (@@FETCH_STATUS = 0)
    BEGIN
 
        DECLARE @ItemStrName varchar(100),@ItemNum int,@NewItemNum int,@Kind tinyint,@ItemType int,@CheckNum int
 
        SET @ItemStrName = ''
        SET @ItemNum = 0
        SET @NewItemNum = 0
        SET @Kind = 0
        SET @ItemType = 0
        SET @CheckNum = 0
 
        IF CHARINDEX('+10',@ItemName) <> 0
        BEGIN
            SELECT @ItemNum = Num,@Kind = Kind FROM ITEM WHERE Num = @Num
            SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 2
            IF (@Kind != 91) OR (@Kind != 92) OR (@Kind != 93) OR (@Kind != 94)
            BEGIN
            SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
                IF @CheckNum <> 0
                BEGIN
                UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum,ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                END
            END 
        END
        ELSE IF CHARINDEX('+9',@ItemName) <> 0
        BEGIN
            SELECT @ItemNum = Num,@Kind = Kind FROM ITEM WHERE Num = @Num
            SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 1
            IF (@Kind != 91) OR (@Kind != 92) OR (@Kind != 93) OR (@Kind != 94)
            BEGIN
            SELECT @CheckNum = COUNT(Num) FROM ITEM WHERE Num = @NewItemNum
                IF @CheckNum <> 0
                BEGIN
                UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum,ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                END
            END 
        END
        ELSE IF CHARINDEX('+5',@ItemName) <> 0
        BEGIN
            SELECT @ItemNum = Num,@Kind = Kind,@ItemType = ItemType FROM ITEM WHERE Num = @Num
            IF @Kind = 91 OR @Kind = 92 OR @Kind = 93 OR @Kind = 94
            BEGIN
                    IF @ItemType = 4
                    BEGIN
                    SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 4
                    UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum, ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                    INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                    END
            END 
        END
        ELSE IF CHARINDEX('+4',@ItemName) <> 0
        BEGIN
            SELECT @ItemNum = Num,@Kind = Kind,@ItemType = ItemType FROM ITEM WHERE Num = @Num
            IF @Kind = 91 OR @Kind = 92 OR @Kind = 93 OR @Kind = 94
            BEGIN
                    IF @ItemType = 4
                    BEGIN
                    SELECT @ItemStrName = strName,@NewItemNum = Num FROM ITEM WHERE Num = @ItemNum - 3
                    UPDATE RESULT_CHECK_USER_ITEMS SET Num = @NewItemNum, ItemName = '# DÜZELTİLDİ : ' + RTRIM(LTRIM(@ItemStrName)) + ' #' WHERE ItemName = @ItemName AND InventorySlot = @InventorySlotNumber
                    INSERT INTO RESULT_CHECK_USER_ITEMS_LOGS VALUES (@strUserID,@Num,@ItemName,@NewItemNum,@ItemStrName)
                    END
            END 
        END
 
 
    FETCH NEXT FROM CRS_RESULT_CHECK_USER_ITEMS INTO @Num, @ItemName, @InventorySlotNumber
    END
 
    CLOSE CRS_RESULT_CHECK_USER_ITEMS
 
    DEALLOCATE CRS_RESULT_CHECK_USER_ITEMS
 
EXEC CHECK_ENCODE_USER_ITEMS @strUserID
 
END
 
END

Kod:

CREATE procedure [dbo].[CHECK_ENCODE_USER_ITEMS]
@StrUserID varchar(30)
AS
DECLARE
@length int,
@row int,
@i int,
@Num int,
@pos int,
@dur int,
@dur1 int,
@ext int,
@StackSize1 int,
@strName varchar(30),
@strExtName varchar(30),
@CNum varbinary(4),
@cdur varchar(2),
@Source tinyint,
@NEWNum int,
@StackSize int,
@cstack varchar(2),
@InventorySlot int
 
    set @InventorySlot=0
    set @i = 14*0
    set @length = 401
 
select @row=count( * ) from userdata where struserid=@StrUserID
 
if @row>0 
  begin
 
 
Select @Num=Num,
@dur = Durability,
@StackSize1 = stacksize,
        @StrUserID = strUserID
        From RESULT_CHECK_USER_ITEMS
        Where strUserID = @StrUserID and InventorySlot=@InventorySlot
 
    Set @CNum = Substring(cast(@Num as varbinary(4)), 4, 1) + Substring(cast(@Num as varbinary(4)), 3, 1) + Substring(cast(@Num as varbinary(4)), 2, 1) + Substring(cast(@Num as varbinary(4)), 1, 1)
    Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))
    Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as varbinary(2)), 1, 1) as varchar(2))
 
 
    update UserData set strItem = cast(cast(cast(@CNum as varchar(4)) + @Cdur + @Cstack as varchar(8))   as binary(400)) where strUserID = @strUserID
 
 
set @i=@i+8
set @InventorySlot=@InventorySlot+1
 
 
 
WHILE @InventorySlot < 50
Begin
 
Select @Num=Num,
@dur = Durability,
@StackSize1 = stacksize,
        @StrUserID = strUserID
        From RESULT_CHECK_USER_ITEMS
        Where strUserID = @StrUserID and InventorySlot=@InventorySlot
 
    Set @CNum = Substring(cast(@Num as varbinary(4)), 4, 1) + Substring(cast(@Num as varbinary(4)), 3, 1) + Substring(cast(@Num as varbinary(4)), 2, 1) + Substring(cast(@Num as varbinary(4)), 1, 1)
    Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))
    Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as varbinary(2)), 1, 1) as varchar(2))
 
 
    update UserData set strItem = cast( substring(strItem, 1, @i) + cast(cast(@CNum as varchar(4)) + @Cdur + @Cstack as varchar(8)) + substring(strItem, @i+8, 401-@i) as binary(400)) where strUserID = @strUserID
 
 
set @i=@i+8
set @InventorySlot=@InventorySlot+1
 
end
end

Kod:

CREATE procedure [dbo].[CHECK_FIND_USER_ITEMS] 
@StrUserID varchar(30)
AS
DECLARE
@length int,
@i int,
@Num int, 
@dur int,
@duar int,
@StackSize1 int,
@InventorySlot int,
@Row int,
@name varchar(100),
@extname varchar(100),
@ext int
 
 
    set @i = 14*0+1
    set @length = 401
 
select @row=count(*) from userdata where struserid=@StrUserID
 
delete from RESULT_CHECK_USER_ITEMS where struserid=@StrUserID
 
if @row>0 
  begin
 
WHILE @i < @length
Begin
 
Select @Num=cast(cast(substring(cast(substring(strItem, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),
@dur = cast(cast(cast( substring(strItem, @i+5, 1) as varbinary(1))+cast(substring(strItem, @i+4, 1) as varbinary(1)) as varbinary(2)) as int),
@StackSize1 = cast(cast(cast( substring(strItem, @i+7, 1) as varbinary(1))+cast(substring(strItem, @i+6, 1) as varbinary(1)) as varbinary(2)) as int),
        @StrUserID = strUserID
        From UserData
        Where strUserID = @StrUserID
 
 
if @Num=0 
begin
set @extname='Free Slot'
set @name='Free Slot'
end
else
begin
set @extname='Not Find'
set @name='Not Using'
 
select @extname=strName from item where Num=@Num
 
if @extname='Not Find' 
begin
 
set @ext=-1
set @name='Not Find'
 
select @extname=strName,@ext=Slot from item where Num= cast(substring(cast(@Num as varchar(9)), 1, 6)+'000' as int) --cast(substring(cast(@Num as varbinary(4)),0,5) as int)*1000
if @ext>-1
begin
set @duar=-1
    If @ext = 0
        select @duar = Duration,@name=strName  From item where Num = cast(substring(cast(@Num as varchar(9)), 7, 9) as int)
end
end
end
 
insert into RESULT_CHECK_USER_ITEMS (Num,stacksize,Durability,struserid,InventorySlot,ItemName,extname) values(@Num,@stacksize1,@dur,@StrUserID,(@i-1) / 8,@extname,@name )
 
set @i=@i+8
 
end
end

ve Queryden ÇalıstıRınız ;

Kod:

update userdata set UserStatus = '0'

Burada Her hangi bir charın UserStatus'u 1 yaparsanız, o charı kontrol etmeyecektir !
GM'leri zaten kontrol etmez ...

ve En SOn Olarak ,

LOAD_USER_DATA proc'unu açarak ,

Oto Master varsa Hemen Altına yok İse ,

Kod:

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

Bu Kodun hemen üstüne , Ekliyoruz !

Değiştirilen itemleri ; "RESULT_CHECK_USER_ITEMS_LOGS" Tablosundan gorebiliriz

15 Haziran 2009 Pazartesi

DB'nize Yeni Skiller Ekleyin.. [Flame Resistans,Fire To Blow,Flame Ball,Flame Rain,Big Ignition]

1299 Private Serverlarda, daha önce görmediğiniz efektlerle dolu yeni 5 Tane mage skilli vereceğim..Bu skiller;

Flame Resistans
Fire To Blow
Flame Ball
Flame Rain
Big Ignition

KoMaster, KoreA Ko Skill Efektlerini birleştirerek yukarıdaki skilleri meydana getirmiş.. Sizde Eklemek için aşağıdaki kodları Tables lere ekleyin..

MAGIC Tables

Kod:

210582    ?????                            Flame Rain                        Flame Rain                                                                                              0    0    0    0    113    7    62    2105    1200    0    9    0    15    255    100    3    0    25    1    0
    210583    ?????ova                           ?????                            ?????nova                                                                                                0    0    0    0    2901    10    60    2105    800    0    9    0    15    153    30    3    0    25    1    0
    210589    Ufle                              ??? ???                           ??? ??? ?? ??? ???? ???? ???                                                                            0    0    0    0    113    7    67    2105    750    0    9    0    15    203    100    3    0    25    1    0
    210588    ?????                            Alev topu                         Yuksek Hasar                                                                                            0    0    0    0    113    7    80    2105    2500    0    9    0    15    203    30    3    0    25    1    0
    210599    ?????                            Flame Resistans                   Flma Resist                                                                                             0    0    0    0    701    2    65    2105    500    0    9    0    15    153    30    4    0    25    1    0
    210567    ?????                            Big Ignityoin                     0                                                                                                       0    0    0    0    113    7    67    2105    320    0    9    0    15    0    30    3    0    25    1    0
    210584    ?????                            yeni                              yen,                                                                                                    0    0    0    0    113    7    61    2105    550    0    9    0    15    255    100    3    0    25    1    0
    110582    ?????                            Flame Rain                        Flame Rain                                                                                              0    0    0    0    113    7    62    1105    1200    0    9    0    15    255    100    3    0    25    1    0
    110583    ?????ova                           ?????                            ?????nova                                                                                                0    0    0    0    2901    10    60    1105    800    0    9    0    15    153    30    3    0    25    1    0
    110589    Ufle                              ??? ???                           ??? ??? ?? ??? ???? ???? ???                                                                            0    0    0    0    113    7    67    1105    750    0    9    0    15    203    100    3    0    25    1    0
    110588    ?????                            Alev topu                         Yuksek Hasar                                                                                            0    0    0    0    113    7    80    1105    2500    0    9    0    15    203    30    3    0    25    1    0
    110599    ?????                            Flame Resistans                   Flma Resist                                                                                             0    0    0    0    701    2    65    1105    500    0    9    0    15    153    30    4    0    25    1    0
    110567    ?????                            Big Ignityoin                     0                                                                                                       0    0    0    0    113    7    67    1105    320    0    9    0    15    0    30    3    0    25    1    0
    110584    ?????                            yeni                              yen,                                                                                                    0    0    0    0    113    7    61    1105    550    0    9    0    15    255    100    3    0    25    1    0

MAGİC_TYPE3

Kod:

210567    Big Igni                          0                                                                                                       0    0    1    -1674    0    -568    10    1
    110583    ????? Nova                       ?????nova                                                                                                15    0    1    -6541    -1558    -900    20    1
    210583    ????? Nova                       ?????nova                                                                                                15    0    1    -6541    -1558    -900    20    1
    210588    Alev Topu                         Alev Topu                                                                                               0    0    1    -9854    0    0    0    1
    110588    Alev Topu                         Alev Topu                                                                                               0    0    1    -9854    0    0    0    1
    110567    Big Igni                          0                                                                                                       0    0    1    -1674    0    -568    10    1
    210584    Bas                               ??? ??? ?? ??? ???? ???? ???                                                                            0    0    1    -3879    0    0    0    1
    110589    Ufle                              ??? ??? ?? ??? ???? ???? ???                                                                            0    0    1    -5125    -800    0    10    1
    210589    Ufle                              ??? ??? ?? ??? ???? ???? ???                                                                            0    0    1    -5125    -800    0    10    1
    210582    Alev Yagmuru                      ??? ??? ?? ??? ???? ???? ???                                                                            0    0    1    -4584    0    0    0    1
    110582    Alev Yagmuru                      ??? ??? ?? ??? ???? ???? ???                                                                            0    0    1    -4585    0    0    0    1
    110584    Bas                               ??? ??? ?? ??? ???? ???? ???                                                                            0    0    1    -3879    0    0    0    1

MAGİC_TYPE4

Kod:

110599    news                              ??? ?? ???? 80 ?????                                                                                    8    0    300    100    100    0    100    100    100    0    100    0    100    100    100    0    0    0    0    0    200    0    0    0    0    0    100
    210599    news                              ??? ?? ???? 80 ?????                                                                                    8    0    300    100    100    0    100    100    100    0    100    0    100    100    100    0    0    0    0    0    200    0    0    0    0    0    100

DB'nize Yeni Skiller Ekleyin [MediaFire]
DB'nize Yeni Skiller Ekleyin [Dosya.Tc]
DB'nize Yeni Skiller Ekleyin [Rapidshare]

1299 Private Server Tanıtım,Database,Client ve Procedure Paylaşım Blogu

17 Haziran 2009 Çarşamba

Dilek Ağacı NPC' si [Tek tuş=LeveL 70 + Skill Stat / Itemler ]

Montesque Ardream Database V1 [2 Adet Krowaz & Darkland - Yeni Skiller - Yeni Itemler]

OyunCanavari.Net Panel v3 [Küçük Boyutuyla Çok Hızlı Panel]

SanalHat Panel v4

KingDooM Panel v1

16 Haziran 2009 Salı

NPC Editör [Kolaylıkla NPC'lerinizi Editleyebileceksiniz.]

+10,+9 İtemleri +8'e ve +5,+4 Uniqueleri +3 veya +1 Çekme.

15 Haziran 2009 Pazartesi

DB'nize Yeni Skiller Ekleyin.. [Flame Resistans,Fire To Blow,Flame Ball,Flame Rain,Big Ignition]

Sayfalar

Facebook

Bütün 1299 Client

Bütün 1299 Patch

Bütün 1299 Skin

İzleyiciler

Arşiv

Yorumlar

Toplist

Ziyaret