Jump to content
Araştır
  • Diğer seçenekler ...
Sonuçları bul ...
Sonuçları bul ...

borx

Uzaklaştırılmış
 Profili  İçeriklerini bul

  • İçerik sayısı

    89

  • Katılım

  • Son ziyaret

  • Puan

    1,774 [ Bağış Yap ]

İletiler : borx

  1. Oluşturuldu:

     

    Klasik hata ve bug günlüğünden herkese selamlar . Bugün yine farklı sorunlar ile burdayım 🙂 db de denk gelen sorunlar şu şekilde.





    src dosyaları mevcut. hangi hata srcnin neresinden editleniyor müsait bir zamanda yardım edecek arkadaşlara şimdiden teşekkürler

    Yuvarlak içerisine aldığım yerlerdeki isimleri kendim düzenleyebilirmiyim. yani değiştirmek istiyorum. yada komple silelim sorun yok 🙂

     

  8. tarihinde gönderildi

    Alıntı
    o kadar çözemiyoruz ki sorunu anca şunu önerebilcem directx güncelle ya da ekran kartın overclocklu falansa normal haline almayı dene.



    Beton atmak lazım altına.. başka çözüm bulamadık. ottoman maradona geçeyim dedimde onda da npcleri eklemek filan lazımmış bilemeyiz onları :D

  20. tarihinde gönderildi

    USE [kn_online]
    GO
    /****** Object: StoredProcedure [dbo].[INSERT_UPGRADE] Script Date: 10.06.2018 18:45:48 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[INSERT_UPGRADE]
    @itemname varchar(50), -- NAME OF ITEM TO UPGRADE
    @index int, -- RANDOMNUMBER as indexNumber
    @reqmon int, -- Required Money for upgrades (240K for unique's 0 for Normal Items)
    @TYPE tinyint -- Type 1 Only Bus Upgrade, Type 2 only Trina Upgrade, Type 3 Trina + Bus Upgrades at once.
    AS

    DECLARE @origitem varchar(4),@giveitem varchar(4), @give int, @otype int, @rate smallint, @reqitem int,@reqitem2 int
    set @otype = -1
    IF @TYPE = 1 or @TYPE = 3
    BEGIN
    set @rate=10000 -- Random rate for now. Can be editted lateron
    set @reqitem=379021000 -- Required Item for Upgrading.
    set @reqitem2=0

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and num like '%001)' and strname like '%1)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and num like '%002)' and strname like '%2)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+2241, 5001, @itemname, '+1 To +2', @otype, CAST(@origitem AS smallint), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 0, @rate, @give
    --+2 to +3 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%2)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%3)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int )
    insert into item_upgrade_new select @index+355, 5001, @itemname, '+2 To +3', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 0, @rate, @give
    --+3 to +4 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%3)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%4)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+461, 5001, @itemname, '+3 To +4 ', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 3, @rate, @give
    --+4 to +5 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%4)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%5)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int )
    insert into item_upgrade_new select @index+521, 5001, @itemname, '+4 To +5', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 5, @rate, @give
    --+5 to +6 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%5)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%6)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+6521, 5001, @itemname, '+5 To +6', @otype, CAST(@origitem AS smallint), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 8, @rate, @give
    --+6 to +7 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%6)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%7)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+722, 5001, @itemname, '+6 To +7', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 10, @rate, @give
    --+7 to +8 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%7)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%8)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int )
    insert into item_upgrade_new select @index+81, 5001, @itemname, '+7 To +8', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 11 ,@rate, @give
    --+8 to +9 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%8)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%9)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+933, 5001, @itemname, '+8 To +9', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 12, @rate, @give
    --+9 to +10 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%9)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%10)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+101, 5001, @itemname, '+9 To +10', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 13, @rate, @give
    END

    IF @TYPE = 2 or @TYPE = 3
    BEGIN
    set @rate=10000
    set @reqitem=700002000
    set @reqitem2=379021000

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%1)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%2)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+2, 5001, @itemname, '1to2', @otype, CAST(@origitem AS smallint), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 0, @rate, @give
    --+2 to +3 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%2)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%3)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int )
    insert into item_upgrade_new select @index+3, 5001, @itemname, '2to3', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 0, @rate, @give
    --+3 to +4 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%3)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%4)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+4, 5001, @itemname, '3to4', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 3, @rate, @give
    --+4 to +5 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%4)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%5)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int )
    insert into item_upgrade_new select @index+5, 5001, @itemname, '4to5', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 5, @rate, @give
    --+5 to +6 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%5)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%6)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+6, 5001, @itemname, '5to6', @otype, CAST(@origitem AS smallint), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 8, @rate, @give
    --+6 to +7 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%6)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%7)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+7, 5001, @itemname, '6to7', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 10, @rate, @give
    --+7 to +8 code


    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%7)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%8)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int )
    insert into item_upgrade_new select @index+8, 5001, @itemname, '7to8', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 11, @rate, @give
    --+8 to +9 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%8)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%9)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+9, 5001, @itemname, '8to9', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 12, @rate, @give
    --+9 to +10 code

    select top 1 @origitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%9)%'
    select top 1 @giveitem= SUBSTRING(CAST ( num AS varchar ( 9)), 7,10) from item where strname like '%'+@itemname+'%' and strname like '%10)%'
    set @give=CAST(@giveitem AS int)-CAST(@origitem AS int)
    insert into item_upgrade_new select @index+10, 5001, @itemname, '9to10', @otype, CAST(@origitem AS smallint ), @reqitem, @reqitem2, 0, 0, 0, 0, 0, 0, @reqmon, 13, @rate, @give
    END
    select * from item_upgrade_new where strname=@itemname



    UPG PROSEDURU

  21. Oluşturuldu:

    Evet arkadaşlar databasemizde Trinas Piece ekli.. İteme baktığımda isminin altında " unconfirmed nation " yazıyor.. Trinayı aktif etmek için bir kod gördüm ve denedim
    " UPDATE ITEM_UPGRADE SET nGenRate='8000'
    WHERE nOriginItem like '%8' AND nReqItem1='700002000' "

    (0) Rows yazıyor yani bir değişiklik yapmıyor anladığım kadarıyla..


    2.Problem ise oto_reset kodu ile res attığımda Clan gradesi güncelleniyor fakat np sembolleri gelmiyor..


    OTO_RESET prosedürü ;

    USE [kn_online]
    GO
    /****** Object: StoredProcedure [dbo].[OTO_RESET] Script Date: 10.06.2018 10:21:22 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER OFF
    GO
    ALTER PROCEDURE [dbo].[OTO_RESET] AS


    exec UPDATE_KNIGHTS_RATING
    exec UPDATE_USER_KNIGHTS_RANK
    exec UPDATE_USER_PERSONAL_RANK
    --güncellemeleri yaptık
    update KNIGHTS set Points = '999999'
    update KNIGHTS set Flag ='12'
    update KNIGHTS set ClanPointFund ='100000000'
    --clanları royal yaptık.
    update USERDATA set Loyalty='0', LoyaltyMonthly='0' where Authority='255'
    --banlıların np sıfırladık.

    (8 row(s) affected)

    (8 row(s) affected)

    (5 row(s) affected)

    (5 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (200 row(s) affected)


    Yazıyor fakat np sembolleri gelmiyor.. Şimdiden teşekkürler

  25. Oluşturuldu:

    local serverımıza uzun uğraşlar sonucu bir chaotic generator ekleyebildik 🆗
    fakat tıkladığımızda hiçbir tepki vermiyor. tbl editör ile yapılacak birkaç işlem var sanırsam. Bilgisi olan arkadaşlar bu konu üzerinden bizlere destek olurlarsa seviniriz. Ayrıca orjinal myko clienti ile girdiğimzde hiç gözükmüyor başka bir client ile sorunsuz görebiliyoruz ama dediğim gibi tepki vermiyor .

×
×
  • Yeni Oluştur...