1886 - PK/FARM DATABASE - Bütün Zoneler Ekli - Clan War - Krowaz - Chaos - Bdw -UTC-ROSSETA

İndir :

Gizli içerik:

** Gizli İçerik: Bu gizli içeriği görmek için mesaj sayınız 10 veya daha yüksek olmalıdır **.

Kod:

Karakter hatası için karaeski'ye teşekkürler 

Alıntı Karaeski Nickli Üyeden Alıntı Mesajı göster
Teşekkürler..
Karakter oluşturma prosedüründe hata vardı giderildi

Kod:
USE [kn_online]
GO
/****** Object:  StoredProcedure [dbo].[CREATE_NEW_CHAR]    Script Date: 29.10.2015 11:13:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




ALTER PROCEDURE [dbo].[CREATE_NEW_CHAR]
@strAccountID varchar(21),
@index tinyint,
@strCharID varchar(21),
@bRace tinyint,
@sClass smallint,
@nHair int,
@bFace tinyint,
@bStr tinyint,
@bSta tinyint,
@bDex tinyint,
@bIntel tinyint,
@bCha tinyint
AS


DECLARE @bNation tinyint
DECLARE @bCharCount tinyint
DECLARE @bCount tinyint


SELECT @bNation = bNation, @bCharCount = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @strAccountID


IF (@bNation = 1 AND @bRace > 10)
    RETURN 2
ELSE IF (@bNation = 2 AND @bRace < 10)
    RETURN 2
ELSE IF (@bNation <> 1 AND @bNation <> 2)
    RETURN 2


SELECT @bCount = COUNT(strUserID) FROM USERDATA WHERE strUserID = @strCharID


IF (@bCount > 0)
    RETURN 3


BEGIN TRAN
    IF (@index = 0)
        UPDATE ACCOUNT_CHAR SET strCharID1 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
    ELSE IF (@index = 1)
        UPDATE ACCOUNT_CHAR SET strCharID2 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
    ELSE IF (@index = 2)
        UPDATE ACCOUNT_CHAR SET strCharID3 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID


    IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
    BEGIN
        ROLLBACK TRAN
        RETURN 4
    END
            INSERT INTO [kn_online].[dbo].[MAIL_BOX]
        (bStatus , strSenderID , strRecipientID , strSubject, strMessage, bType, nItemID, sCount , sDurability, nSerialNum, nCoins, bDeleted)
        VALUES
        (1, 'RISUS GAME', @strCharID, 'HOSGELDINIZ', 'RISUS GAME GİFT', 2, 800035000, 1 , 1 , 0, 0, 0)


    INSERT INTO USERDATA (strUserID, Nation, Race, Class, HairRGB, Face, Strong, Sta, Dex, Intel, Cha) 
    VALUES (@strCharID, @bNation, @bRace, @sClass, @nHair, @bFace, @bStr, @bSta, @bDex, @bIntel, @bCha)


update userdata set class = 106 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 101
update userdata set class = 108 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 102
update userdata set class = 110 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 103
update userdata set class = 112 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 104
update userdata set class = 206 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 201
update userdata set class = 208 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 202
update userdata set class = 210 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 203
update userdata set class = 212 , gold = '1000000000', points = '222' ,strskill ='x' , [level] = '69', Exp = '200000000'  where struserid = @strCharID and @sclass = 204
 
 
update userdata set class = 106 where struserid = @strCharID and @sclass = 101
update userdata set class = 108 where struserid = @strCharID and @sclass = 102
update userdata set class = 110 where struserid = @strCharID and @sclass = 103
update userdata set class = 112 where struserid = @strCharID and @sclass = 104
update userdata set class = 206 where struserid = @strCharID and @sclass = 201
update userdata set class = 208 where struserid = @strCharID and @sclass = 202
update userdata set class = 210 where struserid = @strCharID and @sclass = 203
update userdata set class = 212 where struserid = @strCharID and @sclass = 204








    IF (@@ERROR <> 0)
    BEGIN
        ROLLBACK TRAN
        RETURN 4
    END
COMMIT TRAN


RETURN 0

 

asdasdasdasd

 

Program Yazımlımlamayı Beceremiyorum Gösterebilirsiniz

 

teşekkürler

 

teşekkürler

 

nasıl yapcam yardım

 

tesekkurler

 

saolllllllllllllll

 

teşekürler

---------- Post added at 02:56 PM ---------- Previous post was at 02:55 PM ----------

linkler gözükmüyor

 

++++++++++++++

 

çok saol teşekkürler

 

asdasdasdasdasdas

 

+++++++++++++++++++++++++++++++++++

 

teşekkürler.

 

Teşekkürler