Pvp Serverler | Metin2 | Pvp Server | Private Serverler | Metin2 Pvp Serverler | Knight



Join the forum, it's quick and easy

Pvp Serverler | Metin2 | Pvp Server | Private Serverler | Metin2 Pvp Serverler | Knight

Pvp Serverler | Metin2 | Pvp Server | Private Serverler | Metin2 Pvp Serverler | Knight

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Pvp Serverler | Metin2 | Pvp Server | Private Serverler | Metin2 Pvp Serverler | Knight

Pvp Serverler | Metin2 | Private Serverler | Pvp Serverlar | Metin2 Private Serverlar | Knight Online Private Serverlar | Pvp Hileler | Pvp Server Tanıtımlar | Pvp Koxp | Private Serverlar Düpe Yöntemleri | PVP SERVERLER,PVP SERVER,PVP,FİFA 2011,PES 2011


    1299 PVP KURULUMU Oyun İçi NCS (Bugsuz)

    Admin
    Admin
    Admin
    Admin


    <b>Mesaj Sayısı</b> Mesaj Sayısı : 1103
    <b>Rep Puanı</b> Rep Puanı : 414804 Rep Gücü : 0 Kayıt tarihi : 16/09/10 Pvp Server Kurulumu :  1299 PVP KURULUMU Oyun İçi NCS (Bugsuz) Metin2
     1299 PVP KURULUMU Oyun İçi NCS (Bugsuz) Knightw

     1299 PVP KURULUMU Oyun İçi NCS (Bugsuz) Empty 1299 PVP KURULUMU Oyun İçi NCS (Bugsuz)

    Mesaj tarafından Admin Cuma 7 Ocak - 6:51

    Selamlar,

    Verilen Procedure Tamamiyle Kötüydü Tamamen Düzelttim

    Nick Kontrolü Yapıyor Eğer Kullanımdaysa NCS Uygulamıyor

    nRet = 1 Karakter Adında Biri Var  1299 PVP KURULUMU Oyun İçi NCS (Bugsuz) Smile

    nRet = 0 ise İşlem Tamam Olayı

    Alttaki Procedureyi Kullanabilirsiniz...


    CREATE PROCEDURE CHANGE_NEW_ID
    @byType char(21),
    @AccountID char(21),
    @OldCharID char(21),
    @NewCharID char(21),
    @nRet smallint output
    AS
    /*
    Author : AKUMA
    */
    DECLARE @CheckUserID int
    SELECT @CheckUserID = COUNT(strUserID) FROM USERDATA WHERE strUserID = @NewCharID
    IF @CheckUserID = 0
    BEGIN
    -- Change Account All Information
    UPDATE ACCOUNT_CHAR SET strCharID1 = @NewCharID WHERE strCharID1 = @OldCharID AND strCharID1 is not null
    UPDATE ACCOUNT_CHAR SET strCharID2 = @NewCharID WHERE strCharID2 = @OldCharID AND strCharID2 is not null
    UPDATE ACCOUNT_CHAR SET strCharID3 = @NewCharID WHERE strCharID3 = @OldCharID AND strCharID3 is not null
    UPDATE USERDATA SET strUserId = @NewCharID WHERE strUserId = @OldCharID AND strUserId is not null
    -- Change Information a User in Knights
    UPDATE KNIGHTS_USER SET strUserId = @NewCharID WHERE strUserId = @OldCharID AND strUserId is not null
    UPDATE KNIGHTS SET Chief = @NewCharID WHERE Chief = @OldCharID AND Chief is not null
    UPDATE KNIGHTS SET ViceChief_1 = @NewCharID WHERE ViceChief_1 = @OldCharID AND ViceChief_1 is not null
    UPDATE KNIGHTS SET ViceChief_2 = @NewCharID WHERE ViceChief_2 = @OldCharID AND ViceChief_2 is not null
    UPDATE KNIGHTS SET ViceChief_3 = @NewCharID WHERE ViceChief_3 = @OldCharID AND ViceChief_3 is not null
    -- Change Information a User is King
    UPDATE KING_SYSTEM SET strKingName = @NewCharID WHERE strKingName = @OldCharID AND strKingName is not null
    UPDATE KING_ELECTION_LIST SET strName = @NewCharID WHERE strName = @OldCharID AND strName is not null
    -- Change User Friend List Information
    UPDATE FRIEND_LIST SET strUserID = @NewCharID where strUserID = @OldCharID
    -- User Rental Item
    UPDATE RENTAL_ITEM SET strLenderCharID = @NewCharID WHERE strLenderCharID = @OldCharID AND strLenderCharID is not null
    UPDATE RENTAL_ITEM SET strBorrowerCharID = @NewCharID WHERE strBorrowerCharID = @OldCharID AND strBorrowerCharID is not null
    UPDATE
    RENTAL_ITEM_LIST SET strBorrowerCharID = @NewCharID WHERE
    strBorrowerCharID = @OldCharID AND strBorrowerCharID is not null
    -- Change CurrentUser
    UPDATE CURRENTUSER SET strCharID = @NewCharID WHERE strCharID = @OldCharID
    -- Change Saved Magic
    UPDATE USER_SAVED_MAGIC SET strCharID = @NewCharID WHERE strCharID = @OldCharID
    -- Change Skill Shorcut
    UPDATE USERDATA_SKILLSHORTCUT SET strCharID = @NewCharID WHERE strCharID = @OldCharID
    -- Name Change is Sucessfull
    SET @nRet = 0
    RETURN
    END
    ELSE
    BEGIN
    -- Entered ID is Already Being Used Another Character
    SET @nRet = 1
    RETURN
    END

      Forum Saati Perş. 28 Mart - 8:27