* Oto Pre
* Oto Üyelik
* Oto Master
* Oto Grade
* Oto NpSembol
* Oto krallık
* Her Char Eşit
* Oyuna 200 M İle Basliyorsunuz
* 25k Np İle Basliyorsunuz
* 80 Skilleri Sorunsuz
* Usko İtemS
* UsKO Cape
* Delos Sorunsuz
* Arena Sorunsuz
* Tüm Gateler Calisiyor
* +monsummon Calisiyor
* Dupe Fix
* Savas Fix
* Karakter Gelme Yeri Fix
* Fixed ByTaoJo Event Eklidir [ Kodu: 31313 ]
* Bifrost Ekli
* Ped Sistemi
* İtem rentaL
* Kareli karesiz np sembol sorunsuz çalışıyor.
* Forgotten Temple sorunsuz çalışıyor
* Sınırsız Pot Basabilirsiniz Sadece 1 Tane Alin Yeter
* Tüm Charlar Eşittir.
Upgrade Orani
Takilar
+1 %100
+2 %75
+3 %50
+4 %0
+5 %0
Silahlar
+1 %100
+2 %100
+3 %100
+4 %100
+5 %100
+6 %100
+7 %100
+8 %50
+9 %25
+10 %0
Exp
1 1
2 1
3 1
4 1
5 1
6 1
7 1
8 1
9 1
10 1
11 1
12 1
13 1
14 1
15 1
16 1
17 1
18 1
19 1
20 1
21 1
22 1
23 1
24 1
25 1
26 1
27 1
28 1
29 1
30 1
31 1
32 1
33 1
34 1
35 1
36 1
37 1
38 1
39 1
40 1
41 1
42 1
43 1
44 1
45 1
46 1
47 1
48 1
49 1
50 1
51 1
52 1
53 1
54 1
55 3000000
56 3000000
57 4000000
58 5000000
59 6000000
60 7000000
61 8000000
62 9000000
63 10000000
64 11000000
65 12000000
66 13000000
67 14000000
68 15000000
69 16000000
70 20000000
71 25000000
72 28000000
73 30000000
74 35000000
75 38000000
76 40000000
77 45000000
78 48000000
79 50000000
80 100000000
By TaoJo (Zor Database) Drop Listesi
Bach = ROL
BisHoP = ROM
DUKE = ROC
SAMMA = Giantic axe +7 and Gigantic axe +0
Worm = +7 Ms - +7 MD - +7 Toto Club
Atross = Magic Shield - Scream Scroll - Judgemend Scrool
Riote = Mage 62 kaadı - Weith Scrool - Bleased Dex
Earth Worm = Rogue Chitin Helmet +7 - Rogue Chitin Gaunlet +7 - Rogue Chitin Boots +7
Blood Worm = Rogue chitin Pauldron +7 - Rogue Chitin Pad +7
Lesath = CS +7 - CB +7
Shaula = SS +7
Lobo = Lobo Staff +7 - Lobo Hammer +7 - Lobo Pendant
Lycaon = Lycaon Pendant = Lycaon Staff +7 = Lycaon Hammer +7
Lupus = Lupus Hammer +7 = Lupus Staff +7 = Lupus Pendant
Dark Mare = Exp Deep Scar +1 - Exp Blade Axe +1 - Exp Mirage +1
Lycan = BuS
Spoiler = 1m
Dark Eyes = +8 CLeawer and Bus
Tyon = Bus
Treant = Weapon Enchant Scroll
Ancient = Armor Enchant Scroll
Troll = Rogue Shell boot +7 - Rogue Shell helmet +7 - Rogue shell Gaunlet +7
Stone Golem = Warrior Shell Boot +7 - Warrior Shell Gauntlet +7 - Warrior Shell Helmet +7 Burdan Devam Drop Editor Olayına
Apostle = Priest Chitin Shell Boot +7 - Priest chitin Shell gauntlet +7 - PRiest chitin Shell helmet +7
Troll Captain = Warrior Shell Pad +7 - Warrior Shell Pauldron +7
Troll Berseker = Rogue Shell pad +7 - Rogue Shell Pauldron +7
Troll warrior = Priest Shell PAD +7 - Priest Shell Pauldron +7
Snatcher = 2000 Buf sc - 350 ac - AP Sc
Carrion Carriew = Dex 15 Sc - Str 15 SC - SW SC
Bandicot = Warrior Chitin Helmet +7 - Warrior Chitin Gaunlet +7 - Warrior Chitin Boots +7
Small Bandicot = Warrior Chitin pad +7 - Warrior Chitin Pauldron +7
Bulcan = Priest Chitin Helmet +7 - Priest Chitin Gauntlet +7 - Priest Chitin Boots +7
Small Bulcan = Priest Chitin Pads +7 - Priest Chitin Pauldron +7
Scavencer Bandicoot = Mage Chitin Helmet +7 - Mage Chitin Gauntlet +7 - Mage Chitin Boots +7
Cannibal Bandicoot = Mage Chitin Pad +7 - Mage Chitin Pauldron +7
Gloomwing = +9 Wood Staff - Ruby Eariring Hp +9 - Golden Pendant Hp +9
Fury Gavolt = Red Pearl Ring +9 Hp - Red Pearl Ring +9 Str - Red Pearl Ring +9 Dex
Wild Bandicoot = Ruby Earring +9 İnt - Ruby Earring +9 Str - Ruby Earring +9 Dex
Wild Bulcan = Golden Pendant +9 İnt - Golden Pendant +9 Str - Golden Pendant +9 Dex
Giant Bulcan =Linen Belt +9 Hp - Linen Belt +9 Dex - Linen Belt + Str
Caitharos (Pelerin Atı) = Brain Of Centaur - Centaur Bow
Barkirra = Sword Of Beast +7
Barrkk = Tooth +7
Kekurikekukaka = Kekuri Ring +0 - Kekuri Belt +0
Giant Golem = Complete Helmet +7 - Complete Glove +7 - Complete Boots +7
Flame Rock = Complete Robe +7 - Complete Pants +7
Atilla = Elemental Pendant +1 - Priest Pendant +1 - Warrior Pendant +1
Antares = Noah ^^ Scorpion Style Fixledim
Hyde = Noah ^^ Gene Scorpion Style Fix
Dragon Tooth = Noah ^^ Scorpion Style Fix...
Felankor = Ring Of Felankor +0
Ultima = Ring OF FeLanKor +0 and Ultima Spear
BossOgo (Fixed By TaoJo) = Sadece Para ^^ Np Vermemekte ^^
Talos = İron Belt
Snake QueeN = İron Neck + Amulet Of dex + Amulet Of str
İsilioon = İron Belt + İron Neck
Falcon = +7 Shard - +7 Raptor +7 İron İmpact
Harpy QueeN = Warrior Earring - Rogue Earring - Mage Earring
ßy TaoJo Pratik Qualyre Analyzer Kodları
Bu Kodları Qualyzer Analzyer da Kullancagız ^^
EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI','YENICHARADI'
exec karusyap 'id' ===== Karus Carı Human yapar ( İd Kısmına Oyuna Giris İd sini yazacaksınız)
exec humanyap 'id' ===== Human Carı Karus yapar ( İd Kısmına Oyuna Giris İd sini yazacaksınız)
EXEC ACCOUNT_PASSWORD_CHANGE 'Karakterin Oyundaki İsmi','Karakterin Yeni Şifresi' ==== Car Sifresi Degistirme
update userdata set Authority = '0' where struserid = 'Karakter İsmi' ==== Gm Yapma
EXEC USER_KNIGHTS_RATING_UPDATE ==== Clanları Güncelleme
EXEC UPDATE_PERSONAL_RANK ===== Np Sembollerini Günceller
update magic set useitem='0' where useitem='389014000' ==== Mana Potunu Sınırsız Yapmak İcin
update magic set useitem='0' where useitem='389020000' ==== CAN Potunu Sınırsız Yapmak İcin
Skill Damageleri.
-------Edit By TaoJo -----------
-------HeLL blade warior 80--------
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 206580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 206580)
------Edit By TaoJo ---------
------Holwing Sword Warrior 70----
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 106570)
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 206570)
-------Edit By TaoJo ---------
------Sword Dancing warrior 60----
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 105560)
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 106560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 205560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 206560)
--------Edit By TaoJo -----------
----------Spike Binding 72(seri Olmasını Onler)--------
UPDATE MAGIC
SET Recasttime = 255
WHERE (magicnum = 208675)
--------Edit By TaoJo -----------
----------Spike Rogue 55--------
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 208655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 208655)
--------Edit By TaoJo -----------
----------Thrust Rogue 35---------
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 208635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 208635)
--------Edit By TaoJo -----------
----------Pierce Rogue 15---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208615)
--------Edit By TaoJo -----------
----------Stab Rogue 5---------
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 208005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 208005)
--------Edit By TaoJo -----------
----------CuT Rogue 40---------
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 208640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 208640)
--------Edit By TaoJo -----------
-------------Rogue 70---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208670)
--------Edit By TaoJo -----------
----------Critical Rogue 80---------
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 208685)
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 108685)
--------------------Edit By TaoJo -----------
----------Critical Rogue 80(180 saniyede Basılabilr)---------
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 208685)
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 108685)
------------ Edit By TaoJo --------------
----------Archery Rogue 55 (5Li Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207555)
------------- Edit By TaoJo --------------
----------Archery Rogue 55 (3Lü Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108515)
------------- Edit By TaoJo --------------
----------Priest 72 Skill ---------
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 111551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 212551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 211551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 112551)
File ByTaoJoDbV1.rar (1859 KB) uploaded!
Password:Www.KodataBase.Co M [ Aradaki Boslugu Siliniz! ]
* Fixed ByTaoJo Event Eklidir [ Kodu: 31313 ]
Cok Zor kesilmektetir Hemde 5k Np Ve Cok Exp Vermektetir.
İlk Db'em Oldugu İçin Sorun Cıkabilir Diye İcine Ufak Bir Prodücür Kodlari Ekledim Lütfen Kontrol Edin Sonra Kurun
:
ArkadasLar Baktım İş Çıgrından çıktı Herkes Kafasına qöre Takılıyor Canım Sıkıldı ßende 120 LVL sınırı yapıyım dedim Maksat Yeşillik oLsun
CREATE PROCEDURE HighWhyToHeLL
@id char(100)
AS
declare @lwl char(10)
select @lwl = level from userdata where struserid = @id
----Edited HighWhyToHeLL-----
if @lwl = '80'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '81' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '81'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '82' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '82'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '83' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '83'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '84' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '84'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '85' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '85'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '86' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '86'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '87' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '87'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '88' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '88'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '89' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '89'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '90' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '90'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '91' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '91'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '92' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '92'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '93' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '93'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '94' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '94'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '95' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
Go
----Edited HighWhyToHeLL-----
if @lwl = '95'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '96' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '96'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '97' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '98'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '99' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '99'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '100' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
if @lwl = '100'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '101' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
id @lwl = '101'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '102' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
id @lwl = '102'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '103' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
id @lwl = '103'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '104' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '104'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '105' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '105'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '106' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '106'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '107' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL----
id @lwl = '107'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '108' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL----
id @lwl = '108'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '109' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '109'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '110' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '110'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '111' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '111'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '112' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL----
id @lwl = '112'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '113' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL----
id @lwl = '113'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '114' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL----
id @lwl = '114'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '115' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----------------------
----Edited HighWhyToHeLL-----
id @lwl = '115'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '116' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '116'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '117' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL-----
id @lwl = '117'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '118' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '118'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '119' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL-----
id @lwl = '119'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '120' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----------------------
Load User Data ßunun ALtına
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
Bunu EkLeyin
exec HighWhyToHeLL @id
LvL Up TabLosu
81 1
82 1
83 1
84 1
85 1
86 1
87 1
88 1
89 1
90 1
91 1
92 1
93 1
94 1
95 1
96 1
97 1
98 1
99 1
100 1
101 1
102 1
103 1
104 1
105 1
106 1
107 1
108 1
109 1
110 1
111 1
112 1
113 1
114 1
115 1
116 1
117 1
118 1
119 1
120 1
Editlenmiş Ebenezer [TIKLA]
* Oto Üyelik
* Oto Master
* Oto Grade
* Oto NpSembol
* Oto krallık
* Her Char Eşit
* Oyuna 200 M İle Basliyorsunuz
* 25k Np İle Basliyorsunuz
* 80 Skilleri Sorunsuz
* Usko İtemS
* UsKO Cape
* Delos Sorunsuz
* Arena Sorunsuz
* Tüm Gateler Calisiyor
* +monsummon Calisiyor
* Dupe Fix
* Savas Fix
* Karakter Gelme Yeri Fix
* Fixed ByTaoJo Event Eklidir [ Kodu: 31313 ]
* Bifrost Ekli
* Ped Sistemi
* İtem rentaL
* Kareli karesiz np sembol sorunsuz çalışıyor.
* Forgotten Temple sorunsuz çalışıyor
* Sınırsız Pot Basabilirsiniz Sadece 1 Tane Alin Yeter
* Tüm Charlar Eşittir.
Upgrade Orani
Takilar
+1 %100
+2 %75
+3 %50
+4 %0
+5 %0
Silahlar
+1 %100
+2 %100
+3 %100
+4 %100
+5 %100
+6 %100
+7 %100
+8 %50
+9 %25
+10 %0
Exp
1 1
2 1
3 1
4 1
5 1
6 1
7 1
8 1
9 1
10 1
11 1
12 1
13 1
14 1
15 1
16 1
17 1
18 1
19 1
20 1
21 1
22 1
23 1
24 1
25 1
26 1
27 1
28 1
29 1
30 1
31 1
32 1
33 1
34 1
35 1
36 1
37 1
38 1
39 1
40 1
41 1
42 1
43 1
44 1
45 1
46 1
47 1
48 1
49 1
50 1
51 1
52 1
53 1
54 1
55 3000000
56 3000000
57 4000000
58 5000000
59 6000000
60 7000000
61 8000000
62 9000000
63 10000000
64 11000000
65 12000000
66 13000000
67 14000000
68 15000000
69 16000000
70 20000000
71 25000000
72 28000000
73 30000000
74 35000000
75 38000000
76 40000000
77 45000000
78 48000000
79 50000000
80 100000000
By TaoJo (Zor Database) Drop Listesi
Bach = ROL
BisHoP = ROM
DUKE = ROC
SAMMA = Giantic axe +7 and Gigantic axe +0
Worm = +7 Ms - +7 MD - +7 Toto Club
Atross = Magic Shield - Scream Scroll - Judgemend Scrool
Riote = Mage 62 kaadı - Weith Scrool - Bleased Dex
Earth Worm = Rogue Chitin Helmet +7 - Rogue Chitin Gaunlet +7 - Rogue Chitin Boots +7
Blood Worm = Rogue chitin Pauldron +7 - Rogue Chitin Pad +7
Lesath = CS +7 - CB +7
Shaula = SS +7
Lobo = Lobo Staff +7 - Lobo Hammer +7 - Lobo Pendant
Lycaon = Lycaon Pendant = Lycaon Staff +7 = Lycaon Hammer +7
Lupus = Lupus Hammer +7 = Lupus Staff +7 = Lupus Pendant
Dark Mare = Exp Deep Scar +1 - Exp Blade Axe +1 - Exp Mirage +1
Lycan = BuS
Spoiler = 1m
Dark Eyes = +8 CLeawer and Bus
Tyon = Bus
Treant = Weapon Enchant Scroll
Ancient = Armor Enchant Scroll
Troll = Rogue Shell boot +7 - Rogue Shell helmet +7 - Rogue shell Gaunlet +7
Stone Golem = Warrior Shell Boot +7 - Warrior Shell Gauntlet +7 - Warrior Shell Helmet +7 Burdan Devam Drop Editor Olayına
Apostle = Priest Chitin Shell Boot +7 - Priest chitin Shell gauntlet +7 - PRiest chitin Shell helmet +7
Troll Captain = Warrior Shell Pad +7 - Warrior Shell Pauldron +7
Troll Berseker = Rogue Shell pad +7 - Rogue Shell Pauldron +7
Troll warrior = Priest Shell PAD +7 - Priest Shell Pauldron +7
Snatcher = 2000 Buf sc - 350 ac - AP Sc
Carrion Carriew = Dex 15 Sc - Str 15 SC - SW SC
Bandicot = Warrior Chitin Helmet +7 - Warrior Chitin Gaunlet +7 - Warrior Chitin Boots +7
Small Bandicot = Warrior Chitin pad +7 - Warrior Chitin Pauldron +7
Bulcan = Priest Chitin Helmet +7 - Priest Chitin Gauntlet +7 - Priest Chitin Boots +7
Small Bulcan = Priest Chitin Pads +7 - Priest Chitin Pauldron +7
Scavencer Bandicoot = Mage Chitin Helmet +7 - Mage Chitin Gauntlet +7 - Mage Chitin Boots +7
Cannibal Bandicoot = Mage Chitin Pad +7 - Mage Chitin Pauldron +7
Gloomwing = +9 Wood Staff - Ruby Eariring Hp +9 - Golden Pendant Hp +9
Fury Gavolt = Red Pearl Ring +9 Hp - Red Pearl Ring +9 Str - Red Pearl Ring +9 Dex
Wild Bandicoot = Ruby Earring +9 İnt - Ruby Earring +9 Str - Ruby Earring +9 Dex
Wild Bulcan = Golden Pendant +9 İnt - Golden Pendant +9 Str - Golden Pendant +9 Dex
Giant Bulcan =Linen Belt +9 Hp - Linen Belt +9 Dex - Linen Belt + Str
Caitharos (Pelerin Atı) = Brain Of Centaur - Centaur Bow
Barkirra = Sword Of Beast +7
Barrkk = Tooth +7
Kekurikekukaka = Kekuri Ring +0 - Kekuri Belt +0
Giant Golem = Complete Helmet +7 - Complete Glove +7 - Complete Boots +7
Flame Rock = Complete Robe +7 - Complete Pants +7
Atilla = Elemental Pendant +1 - Priest Pendant +1 - Warrior Pendant +1
Antares = Noah ^^ Scorpion Style Fixledim
Hyde = Noah ^^ Gene Scorpion Style Fix
Dragon Tooth = Noah ^^ Scorpion Style Fix...
Felankor = Ring Of Felankor +0
Ultima = Ring OF FeLanKor +0 and Ultima Spear
BossOgo (Fixed By TaoJo) = Sadece Para ^^ Np Vermemekte ^^
Talos = İron Belt
Snake QueeN = İron Neck + Amulet Of dex + Amulet Of str
İsilioon = İron Belt + İron Neck
Falcon = +7 Shard - +7 Raptor +7 İron İmpact
Harpy QueeN = Warrior Earring - Rogue Earring - Mage Earring
ßy TaoJo Pratik Qualyre Analyzer Kodları
Bu Kodları Qualyzer Analzyer da Kullancagız ^^
EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI','YENICHARADI'
exec karusyap 'id' ===== Karus Carı Human yapar ( İd Kısmına Oyuna Giris İd sini yazacaksınız)
exec humanyap 'id' ===== Human Carı Karus yapar ( İd Kısmına Oyuna Giris İd sini yazacaksınız)
EXEC ACCOUNT_PASSWORD_CHANGE 'Karakterin Oyundaki İsmi','Karakterin Yeni Şifresi' ==== Car Sifresi Degistirme
update userdata set Authority = '0' where struserid = 'Karakter İsmi' ==== Gm Yapma
EXEC USER_KNIGHTS_RATING_UPDATE ==== Clanları Güncelleme
EXEC UPDATE_PERSONAL_RANK ===== Np Sembollerini Günceller
update magic set useitem='0' where useitem='389014000' ==== Mana Potunu Sınırsız Yapmak İcin
update magic set useitem='0' where useitem='389020000' ==== CAN Potunu Sınırsız Yapmak İcin
Skill Damageleri.
-------Edit By TaoJo -----------
-------HeLL blade warior 80--------
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 206580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 206580)
------Edit By TaoJo ---------
------Holwing Sword Warrior 70----
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 106570)
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 206570)
-------Edit By TaoJo ---------
------Sword Dancing warrior 60----
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 105560)
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 106560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 205560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 206560)
--------Edit By TaoJo -----------
----------Spike Binding 72(seri Olmasını Onler)--------
UPDATE MAGIC
SET Recasttime = 255
WHERE (magicnum = 208675)
--------Edit By TaoJo -----------
----------Spike Rogue 55--------
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 208655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 208655)
--------Edit By TaoJo -----------
----------Thrust Rogue 35---------
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 208635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 208635)
--------Edit By TaoJo -----------
----------Pierce Rogue 15---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208615)
--------Edit By TaoJo -----------
----------Stab Rogue 5---------
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 208005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 208005)
--------Edit By TaoJo -----------
----------CuT Rogue 40---------
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 208640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 208640)
--------Edit By TaoJo -----------
-------------Rogue 70---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208670)
--------Edit By TaoJo -----------
----------Critical Rogue 80---------
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 208685)
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 108685)
--------------------Edit By TaoJo -----------
----------Critical Rogue 80(180 saniyede Basılabilr)---------
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 208685)
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 108685)
------------ Edit By TaoJo --------------
----------Archery Rogue 55 (5Li Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207555)
------------- Edit By TaoJo --------------
----------Archery Rogue 55 (3Lü Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108515)
------------- Edit By TaoJo --------------
----------Priest 72 Skill ---------
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 111551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 212551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 211551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 112551)
File ByTaoJoDbV1.rar (1859 KB) uploaded!
Password:Www.KodataBase.Co M [ Aradaki Boslugu Siliniz! ]
* Fixed ByTaoJo Event Eklidir [ Kodu: 31313 ]
Cok Zor kesilmektetir Hemde 5k Np Ve Cok Exp Vermektetir.
İlk Db'em Oldugu İçin Sorun Cıkabilir Diye İcine Ufak Bir Prodücür Kodlari Ekledim Lütfen Kontrol Edin Sonra Kurun
:ArkadasLar Baktım İş Çıgrından çıktı Herkes Kafasına qöre Takılıyor Canım Sıkıldı ßende 120 LVL sınırı yapıyım dedim Maksat Yeşillik oLsun
CREATE PROCEDURE HighWhyToHeLL
@id char(100)
AS
declare @lwl char(10)
select @lwl = level from userdata where struserid = @id
----Edited HighWhyToHeLL-----
if @lwl = '80'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '81' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '81'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '82' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '82'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '83' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '83'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '84' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '84'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '85' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '85'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '86' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '86'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '87' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '87'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '88' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '88'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '89' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
----Edited HighWhyToHeLL-----
if @lwl = '89'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '90' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '90'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '91' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '91'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '92' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '92'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '93' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '93'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '94' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '94'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '95' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
Go
----Edited HighWhyToHeLL-----
if @lwl = '95'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '96' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '96'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '97' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '98'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '99' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
if @lwl = '99'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '100' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
if @lwl = '100'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '101' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
id @lwl = '101'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '102' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
id @lwl = '102'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '103' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
---Edited HighWhyToHeLL-----
id @lwl = '103'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '104' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '104'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '105' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '105'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '106' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '106'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '107' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL----
id @lwl = '107'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '108' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL----
id @lwl = '108'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '109' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '109'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '110' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '110'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '111' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '111'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '112' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL----
id @lwl = '112'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '113' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL----
id @lwl = '113'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '114' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL----
id @lwl = '114'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '115' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----------------------
----Edited HighWhyToHeLL-----
id @lwl = '115'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '116' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '116'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '117' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL-----
id @lwl = '117'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '118' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----Edited HighWhyToHeLL-----
id @lwl = '118'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '119' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
-----Edited HighWhyToHeLL-----
id @lwl = '119'
begin
update userdata set points = points + 3 where struserid = @id and exp = '1'
update userdata set level = '120' where struserid = @id and exp = '1'
update userdata set exp = '0' where struserid = @id and exp = '1'
end
GO
----------------------
Load User Data ßunun ALtına
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
Bunu EkLeyin
exec HighWhyToHeLL @id
LvL Up TabLosu
81 1
82 1
83 1
84 1
85 1
86 1
87 1
88 1
89 1
90 1
91 1
92 1
93 1
94 1
95 1
96 1
97 1
98 1
99 1
100 1
101 1
102 1
103 1
104 1
105 1
106 1
107 1
108 1
109 1
110 1
111 1
112 1
113 1
114 1
115 1
116 1
117 1
118 1
119 1
120 1
Editlenmiş Ebenezer [TIKLA]
Moderatör tarafında düzenlendi:
