Hos Geldiniz | Hiiaxi Forum
Co-Administrator | Süper Moderatör | Moderatör Alımları Başlamıştır !

Konu Acıcak Paylaşım Yapıcak ArkadasLara Verilecektir !!

Admin Iletişim : bii@sktr.net [ MSN ADRESI ]



 
AnasayfaAramaKayıt OlGiriş yap

Paylaş
 

 Genel Database Sorunları Ve çözümleri Sürekli güncellenecektir..

Aşağa gitmek 
YazarMesaj
BornTh3aLive.
Aktif Üye
Aktif Üye
BornTh3aLive.

Tecrübe Puanı Tecrübe Puanı : 39
Mesaj Sayısı Mesaj Sayısı : 27
Yaş Yaş : 28

Genel Database Sorunları Ve çözümleri Sürekli güncellenecektir.. Empty
MesajKonu: Genel Database Sorunları Ve çözümleri Sürekli güncellenecektir..   Genel Database Sorunları Ve çözümleri Sürekli güncellenecektir.. EmptyPaz Mart 14, 2010 4:09 pm

Selamlar.

Gördügüm kadarıyla herkez'in database hakkın'da Bir sürü sıkıntıları var ve bazı sıkıntılarınıza cevap bulamıyorsunuz. Bende Size Böyle Bir konu açıp Database hakkında Genel Sorunlarınızın çözümlerini veriyorum..

1.(SORU) Başlangıç itemlerini JustPlay arkadaşımızın verdigi editor karakterlere girerken dc sorunu..
2.(Cevap) Load_user_data Prosedurunuz'ü açın ve

Kod: DECLARE @itemaldimi int select @itemaldimi = [level] FROM USERDATA WHERE StrUserID = @id if @itemaldimi = '1' begin exec baslangicitem @id update userdata set [level] = '10' where strUserID = @id end

bu kodun hemen altına
Kod: SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame, Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly FROM USERDATA WHERE strUserId = @id SET @nRet = @@RowCount

bu kodu tekrar ekleyiniz sorununuz düzelicektir..

2.(SORU) Başlangıç level,stat,skil,np degiştiremiyorum.
2(Cevap) Öncelikle Başlangıç Degiştirmek için Öncelikle Bir db'den Create New Char Prosedürünü Kopyalayıp Kendi Create New char Prosedürünüz ile degiştirin daha sonra userdata'dan Gerekli level np yerlerini kendinize göre degiştirin.

3.(SORU)Drop Ayarlarını Nasıl Yapıcam.
3(Cevap) Drop Ayarlarını Program kısmından Drop editörlerle Rahatlıkla degiştirebilirsiniz. Buyrun Drop editör link
[Linkleri görebilmek için üye olun veya giriş yapın.]

4(SORU) + Basma Oranlarını Nasıl Ayarlarım
4(Cevap) Herşeyin Bir Editörü var artık bunuda editör ile halledebilirsiniz..Buyrun link [Linkleri görebilmek için üye olun veya giriş yapın.]

5(SORU) Db Degiştirmek Export Etmek.
5(Cevap) Başlat-Microsoft Sql Server-enterprise manager-database-kn_online-sag clıck-tüm görevler Restore database-from device kutucuguna tıkla-select devices-add-ordan databasen nerde ise seç-1 ok- 2.ok--options force restore over existing database kutucugunu isaretle -tamam - bu kadar.

6(SORU)Archer(Okçu) Skillerini Aktif etme
6(Cevap) Altta Verdigim Kodu Query analyzerden giriceksiniz..(nasıl gircem) Başlat-microsoft sql server-query analyzer-üstte bir kutucugu işaretle sql srver yazan yere 1 tane .(nokta) koy ve ok de sonra üstten db adın ne ise seç (genelde Kn_online'dir) Sonra Kodu yapıştır f5 bas bu işlemi sırayla yap vercegim kodları.

1.kod

Kod: delete from magic where type1='2' truncate table magic_type2 delete from magic_type3 where inum='108566' delete from magic_type3 where inum='208566' delete from magic_type4 where inum='108562' delete from magic_type4 where inum='208562'

2.kod

Kod: 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 1070, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 1075, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 1075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 107510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 1075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 107515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 1075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 1075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 1075, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 1075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 107535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 1075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 107540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 1075, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 1075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 107550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 1075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 107555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 1075, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 1075, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 107560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 1075, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 1080, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 1085, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 1085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 108510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 1085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 108515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 1085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 1085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 1085, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 1085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 108535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 1085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 108540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 1085, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 1085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 108550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 1085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 108555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 1085, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 1085, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 1085, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108562, 'Ice Shot', 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 0, 0, 0, 1, 145, 7, 62, 1085, 300, 0, 7, 391010000, 13, 60, 100, 2, 4, 0, 0, 0 ) insert into magic values ( 108566, 'Lightning Shot', 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 0, 1, 154, 7, 66, 1085, 300, 0, 7, 391010000, 13, 60, 100, 2, 0, 3, 0, 0 ) insert into magic values ( 108570, 'Dark Pursuer', 'Dark Pursuer', '100% accurate arrow with 350% damage', 0, 0, 0, 1, 550, 7, 70, 1085, 300, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 202003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 2020, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 2070, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 2075, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 2075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 207510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 2075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 207515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 2075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 2075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 2075, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 2075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 207535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 2075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 207540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 2075, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 2075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 207550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 2075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 207555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 2075, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 2075, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 2075, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 2080, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 2085, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 2085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 208510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 2085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 208515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 2085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 2085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 2085, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 2085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 208535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 2085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 208540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 2085, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 2085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 208550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 2085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 ) insert into magic values ( 208555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 2085, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 2085, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 2085, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208562, 'Ice Shot', 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 0, 0, 0, 1, 145, 7, 62, 2085, 300, 0, 7, 391010000, 13, 60, 100, 2, 4, 0, 0, 0 ) insert into magic values ( 208566, 'Lightning Shot', 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 0, 1, 154, 7, 66, 2085, 300, 0, 7, 391010000, 13, 60, 100, 2, 0, 3, 0, 0 ) insert into magic values ( 208570, 'Dark Pursuer', 'Dark Pursuer', '100% accurate arrow with 350% damage', 0, 0, 0, 1, 550, 7, 70, 2085, 300, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 ) insert into magic_type2 values ( 102003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 ) insert into magic_type2 values ( 107505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 ) insert into magic_type2 values ( 107520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 107530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107540, 'Arc Shot', 'Inflict 250% damage', 0, 100, 250, 100, 1, 1 ) insert into magic_type2 values ( 107545, 'Explosive Shot', 'Strongest Fire Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107550, 'Viper', 'Strongest Poison Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 107555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 ) insert into magic_type2 values ( 107557, 'Shadow Shot', '100% accurate arrow with 200% damage', 2, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 107560, 'Shadow Hunter', '100% accurate arrow with 300% damage', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 108003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 ) insert into magic_type2 values ( 108505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 ) insert into magic_type2 values ( 108520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 108530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108540, 'Arc Shot', 'Inflict 250% damage', 0, 100, 250, 100, 1, 1 ) insert into magic_type2 values ( 108545, 'Explosive Shot', 'Strongest Fire Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108550, 'Viper', 'Strongest Poison Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 108555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 ) insert into magic_type2 values ( 108557, 'Shadow Shot', '100% accurate arrow with 200% damage', 2, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 108560, 'Shadow Hunter', '100% accurate arrow with 300% damage', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 108562, 'Ice Shot', 'Inflict 300% damage and has a chance to slow down enemy', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 108566, 'Lightning Shot', 'Inflict 300% damage and stuns for 3 seconds', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 108570, 'Dark Pursuer', '100% accurate arrow with 350% damage', 2, 100, 350, 100, 1, 1 ) insert into magic_type2 values ( 202003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 ) insert into magic_type2 values ( 207505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 ) insert into magic_type2 values ( 207520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 207530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207540, 'Arc Shot', 'Inflict 250% damage', 0, 100, 250, 100, 1, 1 ) insert into magic_type2 values ( 207545, 'Explosive Shot', 'Strongest Fire Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207550, 'Viper', 'Strongest Poison Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 207555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 ) insert into magic_type2 values ( 207557, 'Shadow Shot', '100% accurate arrow with 200% damage', 2, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 207560, 'Shadow Hunter', '100% accurate arrow with 300% damage', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 208003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 ) insert into magic_type2 values ( 208505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 ) insert into magic_type2 values ( 208520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 208530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208540, 'Arc Shot', 'Inflict 250% damage', 0, 100, 250, 100, 1, 1 ) insert into magic_type2 values ( 208545, 'Explosive Shot', 'Strongest Fire Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208550, 'Viper', 'Strongest Poison Arrow', 0, 100, 100, 100, 1, 1 ) insert into magic_type2 values ( 208555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 ) insert into magic_type2 values ( 208557, 'Shadow Shot', '100% accurate arrow with 200% damage', 2, 100, 200, 100, 1, 1 ) insert into magic_type2 values ( 208560, 'Shadow Hunter', '100% accurate arrow with 300% damage', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 208562, 'Ice Shot', 'Inflict 300% damage and has a chance to slow down enemy', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 208566, 'Lightning Shot', 'Inflict 300% damage and stuns for 3 seconds', 2, 100, 300, 100, 1, 1 ) insert into magic_type2 values ( 208570, 'Dark Pursuer', '100% accurate arrow with 350% damage', 2, 100, 350, 100, 1, 1 ) insert into magic_type3 values ( 108566, 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 1, -150, 0, 0, 0, 3 ) insert into magic_type3 values ( 208566, 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 1, -150, 0, 0, 0, 3 ) insert into magic_type4 values ( 108562, 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 40, 0, 10, 100, 65, 0, 100, 100, 100, 0, 100, 0, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100 ) insert into magic_type4 values ( 208562, 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 40, 0, 10, 100, 65, 0, 100, 100, 100, 0, 100, 0, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100 )

3.kod

Kod: a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 1075, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 108552, 'Counter Strike', 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 1085, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 207552, 'Counter Strike', 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 2075, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 ) insert into magic values ( 208552, 'Counter Strike', 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 2085, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 ) insert into magic_type2 values ( 107552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 ) insert into magic_type2 values ( 108552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 ) insert into magic_type2 values ( 207552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 ) insert into magic_type2 values ( 208552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 )

işte bu kadar.

7(SORU)Oyundan Çıkınca İtemler Siliniyor.
7(Cevap) Başlat-çalıştır-odbcad32.exe yaz tıkla-odbc ayarlarında Yaptıgınızda-sql eklerken şuanda sql yok resim koyamıyorum.. Ama odbc eklerken Karakter verilerinde çeviri gerçekleştir kutucugunun işaretini kaldırın..

8(SORU)Oto Üyelik Ekleme (Manuel İse)
8(Cevap) Bu alttaki kod Entersipe Manager'den Stroed Prosedure'yi Komple Degiştir..

Kod: CREATE PROCEDURE ACCOUNT_LOGIN @AccountID varchar(21), @Password varchar(13), @nRet smallint OUTPUT AS delete from currentuser where straccountid = @AccountID select @nRet = count(straccountid) from tb_user where straccountid = @AccountID if @nRet = 0 begin insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6') end DECLARE @Nation tinyint, @CharNum smallint SET @Nation = 0 SET @CharNum = 0 DECLARE @pwd varchar(13) SET @pwd = null SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6 IF @pwd IS null BEGIN SET @nRet = 0 RETURN END ELSE IF @pwd <> @Password BEGIN SET @nRet = 0 RETURN END DECLARE @PremiumServiceDEC varchar(21) select @PremiumServiceDEC = count(straccountid) FROM premium_service WHERE strAccountID = @AccountID if @PremiumServiceDEC = 0 begin insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3) end SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @@ROWCOUNT = 0 BEGIN SET @nRet = 1 RETURN END IF @CharNum = 0 BEGIN SET @nRet = 1 RETURN END ELSE BEGIN SET @nRet = @Nation+1 RETURN END GO

9(SORU) Database'den İtem Silme
9(Cevap) Database'den item Silmek İsteyenler İçin Editör buyrun..
[Linkleri görebilmek için üye olun veya giriş yapın.]
Rar Pass:Rocker-ko-cuce.com

10(SORU) Ebenezer Kapat Veriyor..
10(Cevap) Ebenezer'in Bir sürü Kapat Verme Neden'i Vardır..
Bunlardan bazıları Saldırı,Level Sınırı,Savaş Bugu.
Nasıl Engelleyebilirim..
(Saldırı Engel için Osmanx Forumda Paylaştıgı Firewall Kullanabilirsiniz en iyi yöntem.
(Level Sınırı Db'de 66 , 67 oldugunuzda kapat verir Ebenezer editör indirp level sınırını ayarlayıp sorundan kurtulabilirsiniz.
(Savaş Bugu (Savaş bugu Hakkında Forumda Bir Çok Paylaşım olmuş arama yaparak bulabilirsiniz.)

11(SORU)Npc'lere Nasıl Simge Eklerim
11(Cevap) Bu kodu query analyzer Giriyoruz. Ve patch dagıtıyoruz userlere.

Kod: update k_npc set spid = '22008' where ssid = 22000 update k_npc set spid = '22008' where ssid = 16097 update k_npc set spid = '22008' where ssid = 26061 update k_npc set spid = '12008' where ssid = 16061 update k_npc set spid = '12008' where ssid = 16096 update k_npc set spid = '12008' where ssid = 12000 update k_npc set spid = '22209' where ssid = 506 update k_npc set spid = '22209' where ssid = 22202 update k_npc set spid = '22209' where ssid = 13005 update k_npc set spid = '22209' where ssid = 13115 update k_npc set spid = '11518' where ssid = 16089 update k_npc set spid = '11518' where ssid = 12117 update k_npc set spid = '11518' where ssid = 12118 update k_npc set spid = '11518' where ssid = 13003 update k_npc set spid = '11518' where ssid = 13113 update k_npc set spid = '22108' where ssid = 22100 update k_npc set spid = '22108' where ssid = 22102 update k_npc set spid = '22108' where ssid = 22203 update k_npc set spid = '22108' where ssid = 503 update k_npc set spid = '22108' where ssid = 13006 update k_npc set spid = '12109' where ssid = 13002 update k_npc set spid = '12109' where ssid = 12100 update k_npc set spid = '12109' where ssid = 12102 update k_npc set spid = '22109' where ssid = 22106 update k_npc set spid = '22109' where ssid = 22200 update k_npc set spid = '22109' where ssid = 504 update k_npc set spid = '22109' where ssid = 13004 update k_npc set spid = '12208' where ssid = 12202 update k_npc set spid = '12208' where ssid = 13008 update k_npc set spid = '12208' where ssid = 12200 update k_npc set spid = '12108' where ssid = 16062 update k_npc set spid = '12108' where ssid = 11045 update k_npc set spid = '12108' where ssid = 12120 update k_npc set spid = '12108' where ssid = 12208 update k_npc set spid = '22208' where ssid = 21047 update k_npc set spid = '22208' where ssid = 22120 update k_npc set spid = '22208' where ssid = 22208 update k_npc set spid = '22208' where ssid = 505 update k_npc set spid = '22208' where ssid = 13007 update k_npc set spid = '22208' where ssid = 26062

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

12(SORU) Guard Towerlerin İsimlerini Nasıl Degiştirebilirim.
12(Cevap) Bu alltaki Kodu query analyzere Girerek Degiştirebilirsiniz.Kodda Yeni Ve eski Adını yazın towerlerin

Kod: Update k_Npc set strname = 'YeniTowerADI' where strname = 'EskiTowerAdi'

Evet Arkadaşlar Şimdilik Bu kadar Her gün Sorunlarınıza Göre Güncellenicektir..




[Linkleri görebilmek için üye olun veya giriş yapın.]
Sayfa başına dön Aşağa gitmek
 
Genel Database Sorunları Ve çözümleri Sürekli güncellenecektir..
Sayfa başına dön 
1 sayfadaki 1 sayfası

Bu forumun müsaadesi var:Bu forumdaki mesajlara cevap veremezsiniz
Hos Geldiniz | Hiiaxi Forum :: Yardım :: Database Yardım-
Buraya geçin: