• HyperFilter | DoS Protection | DDoS Protection | DoS Mitigation | DDoS Mitigation | AntiDoS | AntiDDoS | Proxy Shielding

"Failed Creating Database" Hatası Alıyorum Diyenler İçeri

Cevap: "Failed Creating Database" Hatası Alıyorum Diyenler İçeri



ALTER PROCEDURE CREATE_NEW_CHAR



@nRet smallint OUTPUT,

@AccountID char(21),

@index tinyint,

@CharID char(21),

@Race tinyint,

@class smallint,

@Hair tinyint,

@Face tinyint,

@Str tinyint,

@Sta tinyint,

@Dex tinyint,

@Intel tinyint,

@Cha tinyint



AS



DECLARE @Row tinyint, @Nation tinyint, @zone tinyint, @PosX int, @PosZ int

SET @Row = 0 SET @Nation = 0 SET @zone = 0 SET @PosX = 0 SET @PosZ = 0



SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID



IF @Row >= 5 SET @nRet = 1



IF @Nation = 1 AND @Race > 10 SET @nRet = 2

ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2

ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2



IF @nRet > 0

RETURN



SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

IF @Row > 0

BEGIN

SET @nRet = 3

RETURN

END



--SET zone = @Nation

SET @zone =21

SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @zone



BEGIN TRAN

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID





INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )

VALUES (@CharID, @Nation, @Race, @class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @zone, @PosX, @PosZ )



exec baslangicitem @CharID

IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END



COMMIT TRAN

SET @nRet = 0

GO
Genişletmek için tıkla ...



Sql 2008 Create New Char uyumlusudur arkadaslar kullanabilirsiniz..
 
Cevap: "Failed Creating Database" Hatası Alıyorum Diyenler İçeri



qerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr213213
 

Online istatistikleri

Çevrimiçi kullanıcılar
435
Çevrimiçi ziyaretçiler
2,501
Toplam ziyaretçi
2,936
Toplamlar, gizli ziyaretçiler içerebilir.

OnlineHile Links

En yeni üyeler

OnlineHile Sosyal

Geri
Üst