NERO database v2 ve NERO database'in buglarının fixlenmesi için gereken CODE'lar

Önceki başlık Sonraki başlık Aşağa gitmek

NERO database v2 ve NERO database'in buglarının fixlenmesi için gereken CODE'lar

Mesaj tarafından _FETHEDEN_ Bir Salı Haz. 22, 2010 12:19 pm

•Oto Üyelik

•Potlar sınırlı.

•Oto Master (+60)

•Ally bugu Vb. yok.

•JAPKO & Korea İtemleri Ekli.

•CZ de Potcular Ekli.

•Eslant'ta potcular ekli.

•CZ de Ronark Moument Ekli.

•Bi-Frost da Bi-Frost Moument Ekli.

•Stat bugu fix, relogda stat düzeliyor.

•Bi-Frost yaratıkları, npcleri eklidir.

•Prize Fix, Ebenezer kapanma durumu yok.

•CZ Guard Towerleri 1000-2000 arası vuruyor.

•Delosa 1. Clanın Bayrağı Konuluyor Her Resette.

•Andream Guard Towerleri 1000-2000 arası vuruyor.

•Bi-Frost kuleleri, bankası, sundriesti var ve çalışıyor.

•Tüm karakterler eşit o fazla vuruyor, bu fazla vuruyor yok.

•Maradonda 2 Tane Banka var, Usko stil, Biri Human Biri Karus.

•Andream guard towerler eklidir, npcleri eklidir. (usko style)

•Andream ekli, emc ve lüfersonda giriş npcsi var, giriş (30-59)

•Bi-Frost ekli, emc ve lüfersonda giriş npcsi var, giriş (70-80)

•Vip Room ekli, emc ve lüfersonda giriş npcsi var, giriş (70-80)

•Oyun içi NCS aktif 1 adet NCS ile oyun içi ncs yapabiliyorsunuz.

•30 lvl e kadar ezik charlar konuşamaz. (mute-küfür engellemek amaçlı)

•El morad & Lüfersonda Guard of Tower ekli savaşlarda ayrı bir zevk oluyor.

•GM'ler relogda edit, clanı bozulur, 21GB para verilir, 80 lvl olur, NP'si 100 e düşer.

•Dark Land ekli, monsterler, NPCler var, emc ve lüfersonda giriş npcsi var (70-80)

•Krowaz Dominion ekli, monsterler, NPCler var, emc ve lüfersonda giriş npcsi var (70-80)

•100-500 NP alımı 58-80 lvl arasıdır (NPT engel)

•Felankor Floor ekli, felankor ve çıkış npcleri ekli, emc ve lüfersonda giriş npcsi var, giriş 70-80 lvl arası.

•Andreamda [Andream] Quest ekli, 5 Stone of Paramun ve Stone of Brahman karşılığı Classa göre +8 silah veriliyor.

•Eslantta [Eslant] Quest ekli, 10 adet Stone of Troll Shaman karşılığı classa göre rebirht shell set +8 veriliyor.

•Maradonda [Peddler] Hemes ekli name change var, valkyrie, gryphon, bahamut certificate götürüp set alabiliyorsunuz.

•Eslantta [ESlant] 70 Quest ekli stone of lard orc götürerek 1 kere yapılabilen 70 quest silahınızı alıyorsunuz.

•Maradonda Chaotic Generator aktif, gem ve fragment kırdırabilirsiniz.

•EMC & Lüfersonda Exchange Manager ekli, 10k np karşılığı ncs, valkyrie, gryphon, bahamut certificate alabiliyorsunuz.

Armorlar



•Gryphon Armor

•Bahamut Armor

•Valkyrie Armor

•Hero Armor

•Legend Armor

•Rebirth Chitin Shell

•Hero, Gryphon, Bahamut, Valkyrie armor & helmet certificate

Ekli Olan Zoneler



•Bi-Frost (70-80)

•Ardream (30-59-Master Kontrol)

•Vip Room (70-80-Clanca)

•Dark Land (70-80)

•Colony Zone (70-80)

•Felankor Floor (70-80)

•Krowaz Dominion (70-80)

Drop List
--Fp Drop Listesi--

Small Bulcan : +8 Gövde, pantolon Mage FP
Bulcan : +8 Gövde Priest, Asas, Warrior FP
Bulture : +8 ayaklık Priest, Asas, Warrior FP
Wild Bulcan : +8 Pads Priest, Asas, warrior FP
Bandicot : +8 Kolluk, Ayaklık, Kafalık Mage FP
Giant Bulcan : +8 Kolluk Priest, Asas, Warrior FP
Bulky Bulcan : +8 Kafalık Priest, Asas, Warrior FP

--Shell Drop Listesi-- --Chitin Drop Listesi-- --Bütün Zone Drop Listesi-- --Bifrost Drop Listesi- --Krowaz Drop Listesi -- --Dark Land Drop Listesi--
Trol : +5 Ayaklık Warrior, Rogue Shell
Trol Captain : +5 Üstlük Warrior, Asas Shell
Trol Warrior : +5 Kolluk Warrior, Asas Shell
Harpy : +5 Ayaklık, Kolluk mage, priest shell
Crimson Wing : +5 Kafalık Warrior, Asas Shell
Trol Berserker : +5 Pantolon Warrior, Asas Shell
Falcon : +5 Gövde Pantolon Kafalık Mage, Priest shell


Flame Rock : +5 Kolluk Ayaklık Priest mage Çitin
Uruk Tron : +5 Pantolon üstlük priest, mage Çitin
Giant Golem : +5 Pantolon Gögüslük Warrior, Asas Çitin
Stone Golem : +5 Kolluk Kafalık Ayaklık Warrior, Asas Çitin


Balrog : +5 Shard, +5 Raptor
Dread Mare : +5 Dread Shield
Dark Knight : +5 iron impacht
Apostle of Flames : +5 hell breaker
Troll Shaman : Stone of Troll Shaman
Wild Bandicoot : Absolute Power Scroll
Apostle of Colds : +5 cold-heart dagger
Paramun : +5 Dark vane, Stone of Paramun
Apostle : +5 md, +5 salamander, +5 glave
Earth Worm : +7 dex, +7 hp, +7 str pendant
Worm Gold : gold coin, silver bar (%10 şans)
Titan : +5 dol +5 holy animor, +5 smite hammer
Brahman : +5 Totomic spear, +5 impack, +5 mirage sword, Stone of Brahman
Blood Worm : +7 cleawer, +7 destoyer, +7 alchemy staff, +7 priest impack
Cannibal Bandicoot : Scream Scroll, Judgment Scroll, Magic Shield Scroll
Ewil Wizard : +5 elixir staff, +5 glacier erenion, +5 wrath of erenion, +5 lighting erenion


Envy : +5 avedon, Fragment of Avarice
Sloth : +5 lugias, Fragment of Sloth
Greed : +0 foverin, Fragment of Rage
Wratch : +0 flame ring, Fragment of Lechery
Glutton : +0 shio tears, Fragment of Gluttony
Ego : +5 sherion, +5 lugias, Fragment of Arrogance
Lust : +5 garp, +5 elysium, +5 hell blood, Fragment of Jealousy
Ultima : +5 Chitin Shield, +5 Scorpion Shield, Stone of Ultima


Knight Of Betrayal : Gabs Blessing (+6) (shield)
Giga Hammer : Undefeatable Leonar (+6) >>> (hammer)
Minotaur : Undefeatable Wirinom (+6) >>> (axe)
Query : Aztec Gold Molok (+6) >>> (staff)
Krowaz : Undefeatable Nebiros (+6) >>> (spear)
Cuff Binder : Sweet Kiss Baal (+6) >>> (axe)
Doom Guard : Undefeatable Raum (+6) >>> (dagger)


Minotaur : Silvery Gem, 10K NP
Lillime : Red Gem, 10K NP
Leech King : Yellow Gem, 10K NP
Cockatrice : Blue Gem, 10K NP
Bone Dragon : Green Gem, 10K NP
Deva Bird : Black Gem, 10K NP

Upgrade Oranları
+1 = %100
+2 = %100
+3 = %100
+4 = %100
+5 = %100
+6 = %100
+7 = %100
+8 = %20
+9 = %5
+10 = %1
Upgrade Takı Oranları
+1 = %100
+2 = %75
+3 = %10
+4 = %5
+5 = %1



Database + Map
[Linkleri görebilmek için üye olun veya giriş yapın.]


1)Her şeyden önce Orc Watcher'a aşağıdaki dropları yerleştiriniz.Yerleştirmeden önce Orc Watcher'ın tüm droplarını siliniz.
1.Drop = 1500 Buff+ Scroll
2.Drop = 300 Defence+ Scroll
3.Drop = Power of Lion Scroll
4.Drop = Attack+ Scroll

2)Küpe ve pendant +7 olarak droplarda varken,yüzük ve belt droplarda yok.Onları da yerleştiriniz.

a) Scavenger Bandicoot'un dropları aşağıdaki gibi olsun.
1.Drop = Spphire Ring (+7) {str bonus}
2.Drop = Spphire Ring (+7) {dex bonus}
3.Drop = Spphire Ring (+7) {healt bonus}

b) Rabid Bandicoot'un dropları da aşağıdaki gibi olsun.
1.Drop = Belt (+7) {str bonus}
2.Drop = Belt (+7) {dex bonus}
3.Drop = Belt (+7) {healt bonus}

3)Stat bugunu düzeltin.Aşağıdaki prosedürler ile...
CREATE PROCEDURE [dbo].[REPAIR_USER_STAT_POINTS]
@strUserID varchar(21)
AS
/*
Author : Ceribrio
*/
DECLARE @Level int, @Point tinyint, @Class int,@NewPoint int

SELECT @Level = Level,@Class = Class,@Point = Points FROM USERDATA WHERE strUserId = @strUserID

IF @Level >= 74 AND @Point = 31
BEGIN
/*
IF @Level = 71
BEGIN
SET @NewPoint = 210
END
ELSE IF @Level = 72
BEGIN
SET @NewPoint = 215
END
ELSE IF @Level = 73
BEGIN
SET @NewPoint = 220
END
ELSE IF @Level = 74
*/
IF @Level = 74
BEGIN
SET @NewPoint = 225
END
ELSE IF @Level = 75
BEGIN
SET @NewPoint = 230
END
ELSE IF @Level = 76
BEGIN
SET @NewPoint = 235
END
ELSE IF @Level = 77
BEGIN
SET @NewPoint = 240
END
ELSE IF @Level = 78
BEGIN
SET @NewPoint = 245
END
ELSE IF @Level = 79
BEGIN
SET @NewPoint = 250
END
ELSE IF @Level = 80
BEGIN
SET @NewPoint = 255
END

IF @Class = 201 OR @Class = 205 OR @Class = 206 OR @Class = 101 OR @Class = 105 OR @Class = 106
BEGIN
UPDATE USERDATA Set Strong = '97',Dex = '60',Sta = '65',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
END
ELSE IF @Class = 202 OR @Class = 207 OR @Class = 208 OR @Class = 102 OR @Class = 107 OR @Class = 108
BEGIN
UPDATE USERDATA Set Strong = '60',Dex = '102',Sta = '60',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
END
ELSE IF @Class = 203 OR @Class = 209 OR @Class = 210 OR @Class = 103 OR @Class = 109 OR @Class = 110
BEGIN
UPDATE USERDATA Set Strong = '50',Dex = '70',Sta = '50',Intel = '70',Cha = '82',Points = @NewPoint WHERE strUserId = @strUserId
END
ELSE IF @Class = 204 OR @Class = 211 OR @Class = 212 OR @Class = 104 OR @Class = 111 OR @Class = 112
BEGIN
UPDATE USERDATA Set Strong = '65',Dex = '60',Sta = '65',Intel = '82',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
END
END

Yukarıdaki prosedürü uyguladıktan sonra LOAD_USER_DATA prosedürünü açıp aşağıdaki kısmı buluyoruz.
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

Yukarıdaki kısmı bulduysak bu kısmın hemen üzerine aşağıdaki code'u ekliyoruz.
-- # Repair Stat Start #
-- # Ganks , Ceribrio'a teşekkürler ! #
EXEC REPAIR_USER_STAT_POINTS @id
-- # Repair Stat End #

Not = Stat sıfırlattıgımızda 31 Point gelecektir , Eğer BUnlardan 1 tanesini bile her hangi bir stata verirseniz script işlem yapmaz , Stat sıfırlayınca , 31 Stat Points olarak relog atarsanız , Gerekeni yapacaktır ! .

4)Krowaz ve Quest itemlerini 70+ yapınız.Aşağıdaki code ile.
Update Item Set ReqLevel ='70' Where strName Like '%%'
Update Item Set ReqLevel ='70' Where strName Like '%Gabs%'
Update Item Set ReqLevel ='70' Where strName Like '%Wirinom%'
Update Item Set ReqLevel ='70' Where strName Like '%Nebiros%'
Update Item Set ReqLevel ='70' Where strName Like '%Leonard%'
Update Item Set ReqLevel ='70' Where strName Like '%Baal%'
Update Item Set ReqLevel ='70' Where strName Like '%Raum%'
Update Item Set ReqLevel ='70' Where strName Like '%Windforce%'
Update Item Set ReqLevel ='70' Where strName Like '%Faun%'
Update Item Set ReqLevel ='70' Where strName Like '%Molok%'
Update Item Set ReqLevel ='70' Where strName Like '%Fulitol%'

5)Aşağıdaki code'lar ile yan karakter dupesini fixleyiniz.Çok büyük sıkıntılar oluşur !

"a-Z / 0-9 / _" Karakterleri Sadece ID ve Şifrede Kullanabilir, Kesinlikle Hiç Bir ASCII Karakter ile Oyuna Giremez.

Kullanılabilecek Küçük Harfler : abcdefghijklmnoprstuvyzxwq
Kullanılabilecek Büyük Harfler : ABCDEFGHIJKLMNOPRSTUVYZXWQ
Kullanılabilecek Sayılar : 0123456789
Kullanılabilecek Karakterler : _ (alttan tire, aşağıda isterseniz onu da kaldırabilirsiniz)

CREATE FUNCTION [dbo].[IsValidCharacters](@SData varchar(8000))
RETURNS INT
AS
/*
Author : AKUMA
Update : 16.10.2009 - 15:30
*/
BEGIN

DECLARE @SDataLen int
DECLARE @Loop int
DECLARE @Letter varchar(1)
DECLARE @RXLetters varchar(8000)
DECLARE @Match tinyint

SET @RXLetters = 'qwertyuopasdfghjklizxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890_'
SET @SDataLen = LEN(@SData)
SET @Loop = 1
SET @Match = 0

WHILE @Loop < (@SDataLen + 1)
BEGIN

SET @Letter = RTRIM(LTRIM(SUBSTRING(@SData,@Loop,1)))

IF CHARINDEX(@Letter,@RXLetters) = 0
BEGIN
SET @Match = 1
BREAK
END

SET @Loop = @Loop + 1
END

RETURN @Match
END



ACCOUNT_LOGIN,ACCOUNT_LOGIS,MAIN_LOGIN veya MYST_LOGIN Ana Login'iniz hangisi ise içinde aşağıdaki gibi bir kısım olacaktır;

CREATE PROCEDURE [dbo].[ACCOUNT_LOGIN]
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS

-- Tam Buraya



Yukarı kısmı ana login'inizden bulduktan sonra AS'nin 1 satır altındaki satıra aşağıdaki code'u ekliyoruz.

IF dbo.IsValidCharacters(@AccountID) = 1
BEGIN
SET @nRet = 2 -- Hesap Bulunamadı.
RETURN
END

IF dbo.IsValidCharacters(@Password) = 1
BEGIN
SET @nRet = 3 -- Şifreniz Hatalıdır.
RETURN
END


Aşağıdaki code'ları da önlem olarak uyguluyoruz.

DELETE PROC PROC_INSERT_CURRENTUSER

CREATE PROCEDURE PROC_INSERT_CURRENTUSER
@AccountID char(21),
@CharID char(21),
@ServerNo int,
@ServerIP char(15),
@ClientIP char(15),
@nRet smallint output
AS
/*
Author : AKUMA
Update : 26.07.2009 - 22:12
*/

INSERT INTO CURRENTUSER (nServerNo, strAccountID, strCharID, strServerIP, strClientIP) VALUES (@ServerNo, @AccountID, @CharID,@ServerIP,@ClientIP)

DECLARE @RAccountID char(21)

SELECT @RAccountID = strAccountID FROM ACCOUNT_CHAR WHERE strCharID1 = @CharID and strCharID1 IS NOT NULL
SELECT @RAccountID = strAccountID FROM ACCOUNT_CHAR WHERE strCharID2 = @CharID and strCharID2 IS NOT NULL
SELECT @RAccountID = strAccountID FROM ACCOUNT_CHAR WHERE strCharID3 = @CharID and strCharID3 IS NOT NULL

IF @RAccountID IS NULL
BEGIN
SET @nRet = 0
RETURN
END
ELSE IF @RAccountID = ''
BEGIN
SET @nRet = 0
RETURN
END
ELSE IF @RAccountID <> @AccountID
BEGIN
SET @nRet = 0
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
END

6)Bi-frosttaki Lust'un kutusu açılmamaktadır.İçindeki Garp,Elysium ve Hell Blood'u kaldırın.Sadece Fragment of Lechery kalsın.Bu şekilde Lust'un kutusu açılacaktır.

7)Troll'ün droplarını komple kaldırın.Aşağıdaki dropları yerleştirin.
1.drop = Chitin Shell Boots (+5) {strenght bonus}
2.drop = Rogue Chitin Shell Boots (+5) {dexterity bonus}
3.drop = Priest Chitin Shell Boots (+5) {healt bonus}

8)Troll Warrior'un droplarını komple kaldırın.Aşağıdaki dropları yerleştirin.
1.drop = Chitin Shell Gauntlet (+5) {strenght bonus}
2.drop = Rogue Chitin Shell Gauntlet (+5) {dexterity bonus}
3.drop = Priest Chitin Shell Gauntlet (+5) {healt bonus}


9)Fragmentler sundries'e satılınca 500m para veriyor.Bunu bitirmek için aşağıdaki code'u uygulayınız.
update ITEM set BuyPrice = '10000' where strname like '%fragment%'

10)Fragmentler ve gemler relog atıldığında sayıları artıyor.Bunun nedeni üst üste birikmeleridir.Bunu engellemenin tek yolu aşağıdaki code'u uygulamaktır.
update ITEM set Countable = '0' where strname like '%Fragment%'
update ITEM set Countable = '0' where strname like '%Gem%'

*9)Krowaz'daki bazı yaratıklar,Darkland'taki tüm yaratıklar ve Vip room'daki Guardian çok yüksek(10k-5k) np veriyor.Bu sıkıntıyı aşağıdaki code'lar ile yok edelim.
UPDATE k_monster SET iloyalty = 0
UPDATE k_monster SET iloyalty = 50 WHERE strname= 'Atross'
UPDATE k_monster SET iloyalty = 25 WHERE strname= 'Riote'

11)Weapon ve Armor Enchant Scroll'ları ekleme,kullanabilme ve sundriesten alabilme...aşağıdaki işlemleri uygulayınız.

a)İlk olarak database'inizden Weapon ve Armor Enchant Scroll'ları siliniz.
DELETE FROM ITEM WHERE Num = 389155000
DELETE FROM ITEM WHERE Num = 389156000
DELETE FROM ITEM WHERE Num = 800061000
DELETE FROM ITEM WHERE Num = 800062000
DELETE FROM MAGIC WHERE MagicNum = 500049
DELETE FROM MAGIC WHERE MagicNum = 500050
DELETE FROM MAGIC WHERE MagicNum = 500051
DELETE FROM MAGIC WHERE MagicNum = 500052
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500049
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500050
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500051
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500052

b)Aşağıdaki kodları sırasıyla ekleyiniz.

1.code
INSERT INTO ITEM VALUES (389155000,'Weapon Enchant Scroll (+0)',97,15,0,0,0,0,0,30,1,700000,0,0,1,500049,0,1,99,0,0,0,0,0,0,0,255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO ITEM VALUES (389156000,'Armor Enchant Scroll (+0)',97,15,0,0,0,0,0,30,1,300000,0,0,1,500050,0,1,99,0,0,0,0,0,0,0,255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO ITEM VALUES (800061000,'Weapon Enchant Scroll (+0)',255,15,0,0,0,0,0,1,30,700000,10000,0,0,500051,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO ITEM VALUES (800062000,'Armor Enchant Scroll (+0)',255,15,0,0,0,0,0,1,30,300000,10000,0,0,500052,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

2.code
INSERT INTO MAGIC VALUES (500049,'Weapon Enchant Scroll','Weapon Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,389155000,0,0,100,4,0,0,1,0)
INSERT INTO MAGIC VALUES (500050,'Armor Enchant Scroll','Armor Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,389156000,0,0,100,4,0,0,1,0)
INSERT INTO MAGIC VALUES (500051,'Weapon Enchant Scroll','Weapon Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,800061000,0,0,100,4,0,0,1,0)
INSERT INTO MAGIC VALUES (500052,'Armor Enchant Scroll','Armor Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,800062000,0,0,100,4,0,0,1,0)

3.code
INSERT INTO MAGIC_TYPE4 VALUES (500049,'Weapon Enchant Scroll','Armor Enchant Scroll',13,0,1800,100,100,0,100,5,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (500050,'Armor Enchant Scroll' ,'Armor Enchant Scroll',14,0,1800,100,100,30,100,100,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (500051,'Weapon Enchant Scroll','Armor Enchant Scroll',13,0,1800,100,100,0,100,5,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (500052,'Armor Enchant Scroll','Armor Enchant Scroll',14,0,1800,100,100,30,100,100,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)

12)Shard'ın atağı buglu onu da düzeltelim.
Kod:
update item set damage = '66' where strname like '%Shard (+1)%'
update item set damage = '70' where strname like '%Shard (+2)%'
update item set damage = '74' where strname like '%Shard (+3)%'
update item set damage = '78' where strname like '%Shard (+4)%'
update item set damage = '82' where strname like '%Shard (+5)%'
update item set damage = '86' where strname like '%Shard (+6)%'
update item set damage = '92' where strname like '%Shard (+7)%'
update item set damage = '101' where strname like '%Shard (+8)%'
update item set damage = '114' where strname like '%Shard (+9)%'
update item set damage = '134' where strname like '%Shard (+10)%'

13)Seri scroll'u engelleyelim.
update MAGIC set ReCastTime= '255' where MagicNum = '800011000'
update MAGIC set ReCastTime= '255' where MagicNum = '800012000'
update MAGIC set ReCastTime= '255' where MagicNum = '800013000'
update MAGIC set ReCastTime= '255' where MagicNum = '810081000'


14)Humanlarda National Point simgesi çıkmıyor.Akumanın prosedürü ile halletmeniz gerekiyor.
Öncelikle aşağıdaki code ile Procedure'lerden USER_KNIGHTS_RATING_UPDATE ve UPDATE_PERSONAL_RANK Bunları Siliyoruz...
TRUNCATE TABLE USER_KNIGHTS_RANK
TRUNCATE TABLE USER_PERSONAL_RANK

a) Şimdi Yukarıda Boşalttığımız USER_KNIGHTS_RANK'ı Dolduruyoruz.
INSERT INTO USER_KNIGHTS_RANK VALUES ( 1, 'Gold', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 2, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 3, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 4, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 5, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 6, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 7, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 8, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 9, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 10, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 11, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 12, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 13, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 14, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 15, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 16, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 17, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 18, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 19, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 20, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 21, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 22, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 23, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 24, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 25, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 26, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 27, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 28, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 29, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 30, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 31, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 32, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 33, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 34, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 35, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 36, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 37, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 38, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 39, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 40, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 41, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 42, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 43, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 44, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 45, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 46, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 47, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 48, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 49, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 50, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 51, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 52, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 53, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 54, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 55, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 56, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 57, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 58, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 59, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 60, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 61, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 62, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 63, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 64, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 65, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 66, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 67, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 68, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 69, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 70, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 71, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 72, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 73, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 74, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 75, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 76, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 77, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 78, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 79, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 80, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 81, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 82, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 83, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 84, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 85, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 86, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 87, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 88, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 89, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 90, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 91, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 92, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 93, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 94, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 95, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 96, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 97, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 98, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 99, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 100, 'Training', null, null, 0, null, null, 0, 0);


b) USER_PERSONAL_RANK'ımızı da dolduruyoruz.
INSERT INTO USER_PERSONAL_RANK VALUES ( 1, 'Gold',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 2, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 3, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 4, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 5, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 6, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 7, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 8, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 9, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 10, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 11, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 12, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 13, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 14, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 15, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 16, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 17, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 18, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 19, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 20, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 21, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 22, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 23, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 24, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 25, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 26, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 27, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 28, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 29, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 30, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 31, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 32, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 33, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 34, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 35, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 36, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 37, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 38, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 39, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 40, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 41, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 42, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 43, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 44, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 45, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 46, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 47, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 48, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 49, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 50, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 51, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 52, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 53, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 54, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 55, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 56, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 57, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 58, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 59, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 60, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 61, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 62, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 63, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 64, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 65, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 66, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 67, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 68, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 69, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 70, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 71, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 72, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 73, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 74, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 75, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 76, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 77, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 78, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 79, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 80, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 81, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 82, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 83, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 84, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 85, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 86, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 87, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 88, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 89, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 90, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 91, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 92, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 93, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 94, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 95, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 96, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 97, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 98, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 99, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 100, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());

c) Şimdi Geldik Prosedürlerimizi oluşturmaya
USER_KNIGHTS_RATING_UPDATE prosedürü

CREATE PROCEDURE USER_KNIGHTS_RATING_UPDATE
AS
/*
Author : AKUMA
*/
SET NOCOUNT ON
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[USER_RATING_TEMP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[USER_RATING_TEMP]
CREATE TABLE [dbo].[USER_RATING_TEMP] (
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] [char] (21) NULL,
[strKnightsName] [char] (21) NULL ,
[nLoyalty] [int] NULL ,
) ON [PRIMARY]
INSERT INTO USER_RATING_TEMP SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.Loyalty
FROM USERDATA INNER JOIN
KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum
WHERE (USERDATA.Nation = 1) and (USERDATA.City <> 255 ) and (USERDATA.Authority = 1)
ORDER BY USERDATA.Loyalty DESC
INSERT INTO USER_RATING_TEMP SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.Loyalty
FROM USERDATA INNER JOIN
KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum
WHERE (USERDATA.Nation = 2) and (USERDATA.City <> 255 ) and (USERDATA.Authority = 1)
ORDER BY USERDATA.Loyalty DESC
CREATE INDEX [IX_RATING_RANK] ON [dbo].[USER_RATING_TEMP]([nRank]) ON [PRIMARY]
DECLARE @strCharID char(21)
DECLARE @strKnightsID char(21)
DECLARE @nIndex smallint
DECLARE @nLoyalty int
SET @strCharID = NULL
SET @strKnightsID = NULL
SET @nIndex = 0
SET @nLoyalty = 0
DECLARE JOBS CURSOR FOR
SELECT nRank, strUserID, strKnightsName, nLoyalty FROM USER_RATING_TEMP
OPEN JOBS
FETCH NEXT FROM JOBS
INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty
WHILE @@fetch_status = 0
BEGIN
IF @nIndex < 101
UPDATE USER_KNIGHTS_RANK SET strKarusUserID = @strCharID, strKarusKnightsName = @strKnightsID, nKarusLoyalty = @nLoyalty WHERE shIndex = @nIndex
ELSE
UPDATE USER_KNIGHTS_RANK SET strElmoUserID = @strCharID, strElmoKnightsName = @strKnightsID, nElmoLoyalty = @nLoyalty WHERE shIndex = @nIndex-100

FETCH NEXT FROM JOBS
INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty
END
CLOSE JOBS
DEALLOCATE JOBS
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[USER_RATING_TEMP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[USER_RATING_TEMP]
SET NOCOUNT OFF




d) UPDATE_PERSONAL_RANK prosedürü

CREATE PROCEDURE UPDATE_PERSONAL_RANK
AS
/*
Author : AKUMA
*/
DECLARE @tUpdateDate SMALLDATETIME
SET @tUpdateDate =CONVERT(VARCHAR(15) , GETDATE(),102)
SET @tUpdateDate = DATEADD(HH,DATEPART(HH,dateadd(mi, 10, GETDATE())),@tUpdateDate)
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KARUS_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[KARUS_USER_RANK]
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[ELMORAD_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[ELMORAD_USER_RANK]
CREATE TABLE [dbo].[KARUS_USER_RANK](
[nRank] [int] IDENTITY(1,1) NOT NULL,
[strUserID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Loyalty] [int] NOT NULL,
[LoyaltyMonthly] [int] NOT NULL,
[nRankUp] [int] NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[ELMORAD_USER_RANK](
[nRank] [int] IDENTITY(1,1) NOT NULL,
[strUserID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Loyalty] [int] NOT NULL,
[LoyaltyMonthly] [int] NOT NULL,
[nRankUp] [int] NOT NULL
) ON [PRIMARY]
truncate table KARUS_USER_RANK
insert KARUS_USER_RANK
select top 100 strUserID, Loyalty, LoyaltyMonthly, 101
from USERDATA
where Nation = 1 and Authority = 1
order by LoyaltyMonthly desc
truncate table ELMORAD_USER_RANK
insert ELMORAD_USER_RANK
select top 100 strUserID, Loyalty, LoyaltyMonthly, 101
from USERDATA
where Nation = 2 and Authority = 1
order by LoyaltyMonthly desc
UPDATE KARUS_USER_RANK
Set nRankUP = R.nRank - KARUS_USER_RANK.nRank
from USER_PERSONAL_RANK R
where R.strKarusUserID = KARUS_USER_RANK.strUserID
UPDATE ELMORAD_USER_RANK
Set nRankUP = R.nRank - ELMORAD_USER_RANK.nRank
from USER_PERSONAL_RANK R
where R.strElmoUserID = ELMORAD_USER_RANK.strUserID

INSERT INTO USER_PERSONAL_RANK
select E.nRank, R.strPosition, E.nRankUP, E.strUserID, E.LoyaltyMonthly, R.nSalary, K.nRankUP, K.strUserID, K.LoyaltyMonthly, R.nSalary, R.nSalary, @tUpdateDate
from ELMORAD_USER_RANK E, KARUS_USER_RANK K, USER_PERSONAL_RANK R
WHERE (E.nRank = K.nRank AND E.nRank = R.nRank and R.UpdateDate < @tUpdateDate)
ORDER BY E.nRank
DELETE FROM USER_PERSONAL_RANK
WHERE UpdateDate < @tUpdateDate
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KARUS_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[KARUS_USER_RANK]
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[ELMORAD_USER_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[ELMORAD_USER_RANK]

15)Krowaz'dan çıkan itemlerin bazıları +8 bazıları +6 çıkıyor.O dropları kaldırın.Hepsini +1 olarak yerleştirin.
Aşağıdaki şekilde olmalıdır.
Knight Of Betrayal : Gabs Blessing (+1)
Giga Hammer : Undefeatable Leonard (+1)
Minotaur : Undefeatable Wirinom (+1)
Query : Aztec Gold Molok (+1)
Krowaz : Undefeatable Nebiros (+1)
Cuff Binder : Sweet Kiss Baal (+1)
Doom Guard : Undefeatable Raum (+1)

16)Krowaz itemlerini upgrade'e açınız.Aşağıdaki code'lar bunun için.

Gabs Blessing
insert into [ITEM_UPGRADE] Values (121342,5001,'Gabs Blessing','+0',12,192,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121343,5001,'Gabs Blessing','+1',12,331,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121344,5001,'Gabs Blessing','+2',12,332,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121345,5001,'Gabs Blessing','+3',12,333,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121346,5001,'Gabs Blessing','+4',12,334,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121347,5001,'Gabs Blessing','+5',12,335,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121348,5001,'Gabs Blessing','+6',12,336,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121349,5001,'Gabs Blessing','+7',12,337,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121350,5001,'Gabs Blessing','+8',12,338,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

Undefeatable Leonard
insert into [ITEM_UPGRADE] Values (121242,5001,'Undefeatable Leonard','+0',11,898,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121243,5001,'Undefeatable Leonard','+1',11,421,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121244,5001,'Undefeatable Leonard','+2',11,422,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121245,5001,'Undefeatable Leonard','+3',11,423,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121246,5001,'Undefeatable Leonard','+4',11,424,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121247,5001,'Undefeatable Leonard','+5',11,425,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121248,5001,'Undefeatable Leonard','+6',11,426,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121249,5001,'Undefeatable Leonard','+7',11,427,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121250,5001,'Undefeatable Leonard','+8',11,428,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

Undefeatable Wirinom
insert into [ITEM_UPGRADE] Values (120013,5001,'Undefeatable Wirinom','+0',2,284,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120014,5001,'Undefeatable Wirinom','+1',2,731,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120015,5001,'Undefeatable Wirinom','+2',2,732,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120016,5001,'Undefeatable Wirinom','+3',2,733,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120017,5001,'Undefeatable Wirinom','+4',2,734,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120018,5001,'Undefeatable Wirinom','+5',2,735,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120019,5001,'Undefeatable Wirinom','+6',2,736,379021000,0,0,0,0,0,0,0,200000,8,7500,1)
insert into [ITEM_UPGRADE] Values (120020,5001,'Undefeatable Wirinom','+7',2,738,379021000,0,0,0,0,0,0,0,200000,8,4500,1)
insert into [ITEM_UPGRADE] Values (120021,5001,'Undefeatable Wirinom','+8',2,739,379021000,0,0,0,0,0,0,0,200000,8,2500,1)

Aztec Gold Molok
insert into [ITEM_UPGRADE] Values (121062,5001,'Aztec Gold Molok','+0',10,317,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121063,5001,'Aztec Gold Molok','+1',10,841,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121064,5001,'Aztec Gold Molok','+2',10,842,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121065,5001,'Aztec Gold Molok','+3',10,843,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121066,5001,'Aztec Gold Molok','+4',10,844,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121067,5001,'Aztec Gold Molok','+5',10,845,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121068,5001,'Aztec Gold Molok','+6',10,846,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121069,5001,'Aztec Gold Molok','+7',10,847,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121070,5001,'Aztec Gold Molok','+8',10,848,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

Undefeatable Nebiros
insert into [ITEM_UPGRADE] Values (120332,5001,'Undefeatable Nebiros','+0',7,312,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120333,5001,'Undefeatable Nebiros','+1',7,751,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120334,5001,'Undefeatable Nebiros','+2',7,752,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120335,5001,'Undefeatable Nebiros','+3',7,753,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120336,5001,'Undefeatable Nebiros','+4',7,754,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120338,5001,'Undefeatable Nebiros','+5',7,755,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120339,5001,'Undefeatable Nebiros','+6',7,756,379021000,0,0,0,0,0,0,0,200000,8,7500,1)
insert into [ITEM_UPGRADE] Values (120340,5001,'Undefeatable Nebiros','+7',7,757,379021000,0,0,0,0,0,0,0,200000,8,7500,1)
insert into [ITEM_UPGRADE] Values (120341,5001,'Undefeatable Nebiros','+8',7,758,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

Sweet Kiss Baal
insert into [ITEM_UPGRADE] Values (120682,5001,'Sweet Kiss Baal','+0',4,286,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120683,5001,'Sweet Kiss Baal','+1',4,781,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120684,5001,'Sweet Kiss Baal','+2',4,782,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120685,5001,'Sweet Kiss Baal','+3',4,783,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120686,5001,'Sweet Kiss Baal','+4',4,784,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120687,5001,'Sweet Kiss Baal','+5',4,785,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120688,5001,'Sweet Kiss Baal','+6',4,786,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (120689,5001,'Sweet Kiss Baal','+7',4,787,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (120690,5001,'Sweet Kiss Baal','+8',4,788,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

Undefeatable Raum
insert into [ITEM_UPGRADE] Values (120442,5001,'Undefeatable Raum','+0',0,901,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120443,5001,'Undefeatable Raum','+1',0,801,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120444,5001,'Undefeatable Raum','+2',0,802,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120445,5001,'Undefeatable Raum','+3',0,803,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120446,5001,'Undefeatable Raum','+4',0,804,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120447,5001,'Undefeatable Raum','+5',0,805,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120448,5001,'Undefeatable Raum','+6',0,806,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (120449,5001,'Undefeatable Raum','+7',0,807,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (120450,5001,'Undefeatable Raum','+8',0,808,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

17)Bazı itemleri de upgrade'e açalım.

Cold-Hearted Dagger
insert into [ITEM_UPGRADE] Values (120422,5001,'Cold-Hearted Dagger','+0',0,294,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120423,5001,'Cold-Hearted Dagger','+1',0,411,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120424,5001,'Cold-Hearted Dagger','+2',0,412,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120425,5001,'Cold-Hearted Dagger','+3',0,413,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120426,5001,'Cold-Hearted Dagger','+4',0,414,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120427,5001,'Cold-Hearted Dagger','+5',0,415,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120428,5001,'Cold-Hearted Dagger','+6',0,416,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (120429,5001,'Cold-Hearted Dagger','+7',0,417,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (120430,5001,'Cold-Hearted Dagger','+8',0,418,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

Spear of Murky Waters
insert into [ITEM_UPGRADE] Values (120302,5001,'Spear of Murky Waters','+0',7,311,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120303,5001,'Spear of Murky Waters','+1',7,411,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120304,5001,'Spear of Murky Waters','+2',7,412,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (120305,5001,'Spear of Murky Waters','+3',7,413,379021000,0,0,0,0,0,0,0,200000,8,9900,1)
insert into [ITEM_UPGRADE] Values (120306,5001,'Spear of Murky Waters','+4',7,414,379021000,0,0,0,0,0,0,0,200000,8,9000,1)
insert into [ITEM_UPGRADE] Values (120308,5001,'Spear of Murky Waters','+5',7,415,379021000,0,0,0,0,0,0,0,200000,8,7500,1)
insert into [ITEM_UPGRADE] Values (120309,5001,'Spear of Murky Waters','+6',7,416,379021000,0,0,0,0,0,0,0,200000,8,6000,1)
insert into [ITEM_UPGRADE] Values (120310,5001,'Spear of Murky Waters','+7',7,417,379021000,0,0,0,0,0,0,0,200000,8,4500,1)
insert into [ITEM_UPGRADE] Values (120311,5001,'Spear of Murky Waters','+8',7,418,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

Dread Shield
insert into [ITEM_UPGRADE] Values (121322,5001,'Dread Shield','+0',12,191,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121323,5001,'Dread Shield','+1',12,321,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121324,5001,'Dread Shield','+2',12,322,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121325,5001,'Dread Shield','+3',12,323,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121326,5001,'Dread Shield','+4',12,324,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121327,5001,'Dread Shield','+5',12,325,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (121328,5001,'Dread Shield','+6',12,326,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121329,5001,'Dread Shield','+7',12,327,379021000,0,0,0,0,0,0,0,200000,8,7900,1)
insert into [ITEM_UPGRADE] Values (121330,5001,'Dread Shield','+8',12,328,379021000,0,0,0,0,0,0,0,200000,8,1500,1)

18)Shio Tears,Flame Ring,Foverin,Elf Belt vb. itemler +0'dan +1'e basınca yanıyor,bu sıkıntıyı yok etmek için aşağıdaki code'u uygulayınız.
update ITEM_UPGRADE set ngenrate=10000

19)Yukarıdaki işlemleri sırasıyla uyguladıktan sonra upgrade oranlarını editör ile tekrar ayarlayınız.Ayarlamazsanız bastığınız şey geçecektir +10'a kadar gider. Smile
Hem takı hem item upgrade oranlarını ayarlayınız.

20)Mage 75 skill'i ve asas master 80 skill'i çalışmıyor.(bulamadım)

21)Savaş bugu mevcuttur.Fixlemek için;Ai server'ın içindeki numarası yazan evt'leri bulun ve evt'lerin içindeki code'ların en altına aşağıdaki code'ları ekleyin.

a) 101.evt
TYPE 0

ROOM 01
NATION 2
POS 275 570 325 600
A 2 0 0
E 100 1 12
END

ROOM 02
NATION 2
POS 195 119 273 139
A 2 0 0
E 100 1 11
END

ROOM 03
NATION 1
POS 912 772 933 790
A 2 0 0
E 100 1 1
END

ROOM 04
NATION 1
POS 635 308 665 355
A 2 0 0
E 100 1 2
END

ROOM 05
NATION 2
POS 163 860 200 890
A 1 11041 0
E 100 0 0
END

ROOM 06
NATION 1
POS 784 81 805 159
A 1 21041 0
E 100 0 0
END

b) 102. evt

TYPE 0

ROOM 01
NATION 1
POS 120 100 180 200
A 1 21041 0
E 100 0 0
END

ROOM 02
NATION 1
POS 450 140 465 240
A 2 0 0
E 100 1 1
END

ROOM 03
NATION 1
POS 180 420 200 510
A 2 0 0
E 100 1 2
END

ROOM 04
NATION 2
POS 540 760 555 855
A 2 0 0
E 100 1 11
END

ROOM 05
NATION 2
POS 790 490 810 585
A 2 0 0
E 100 1 12
END

ROOM 06
NATION 2
POS 836 820 900 925
A 1 11041 0
E 100 0 0
END

c) 103. evt

TYPE 0

ROOM 01
NATION 1
POS 10 14 355 256
A 1 21041 0
E 100 0 0
END

ROOM 02
NATION 1
POS 562 278 771 491
A 2 0 0
E 100 1 1
END

ROOM 03
NATION 1
POS 605 39 803 251
A 2 0 0
E 100 1 2
END

ROOM 04
NATION 2
POS 227 504 460 728
A 2 0 0
E 100 1 11
END

ROOM 05
NATION 2
POS 180 746 386 968
A 2 0 0
E 100 1 12
END

ROOM 06
NATION 2
POS 651 728 1006 998
A 1 11041 0
E 100 0 0
END



Yapılması Tavsiye edilen şeyler.

1)Bazı şeyleri sınırsız yapabiliriz.

a) Sınırsız ''Power of Lion Scroll'' için aşağıdaki kodu uygulayınız.
update magic set useitem='0' where useitem='800028000'

b)Sınırsız ''Speed Up Rice Cake'' için aşağıdaki kodu uygulayınız.(wormdan zaten düşüyor)
update magic set useitem='0' where useitem='800035000'

c)Sınırsız ''Attack+ Scroll'' için aşağıdaki kodu uygulayınız.
update magic set useitem='0' where useitem='800014000'

d)HP ve MP potları sınırsız yapabilirsiniz.

2)Dark Vane bi-frost'taki gluttondan +0 olarak düştüğü için onun en değerli bıçak olması rekabeti artıracaktır.
update item set damage = damage + 4 where strname like '%Dark Vane%'

3)Party'e adam aldıkça gelen exp artsın.
AISERVER.ini 'ye giriyoruz.party exp var. '0' dır.onu '8' yapıyoruz.Böylece partye yeni dahil olan userler oldukça gelen experience point artacaktır.

4)Exp kasılan Troll shaman slotlarının sayısını artırabilirsiniz.

5)Quest yaratıkları gereksiz,atak yapmıyorlar.Silin.
DELETE FROM K_MONSTER WHERE strname Like '%[Quest]%'


[Linkleri görebilmek için üye olun veya giriş yapın.]

_FETHEDEN_
Benimle iyi olun, yeni üyeyim
Benimle iyi olun, yeni üyeyim

Mesaj Sayısı : 1
Kayıt tarihi : 22/06/10

Kullanıcı profilini gör

Sayfa başına dön Aşağa gitmek

Geri: NERO database v2 ve NERO database'in buglarının fixlenmesi için gereken CODE'lar

Mesaj tarafından Misafir Bir Perş. Eyl. 16, 2010 7:00 am

ellerinize saglık güzel bir database

Misafir
Misafir


Sayfa başına dön Aşağa gitmek

Önceki başlık Sonraki başlık Sayfa başına dön


 
Bu forumun müsaadesi var:
Bu forumdaki mesajlara cevap veremezsiniz