Bác nào pro nhìn giúp em cái này em nhìn ko ra

[khongphaixoan]

Mấy bác chỉ cho em chỗ add tiền cho các tài khoản trong mu ik em nhìn mãi ko ra tks các bác nhiều.......

Code:

CREATE Procedure [dbo].[WZ_CreateCharacter]

@AccountID varchar(10),
@Name varchar(10),
@Class tinyint

AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @Result tinyint
DECLARE @iGUID int
DECLARE @BonusMoney int
SET @Result = 0x00
SELECT @iGUID = memb_guid FROM MEMB_INFO WHERE memb___id = @AccountID

IF EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
BEGIN
SET @Result = 0x01
GOTO ProcEnd
END

BEGIN TRAN

IF NOT EXISTS ( SELECT Id FROM AccountCharacter WHERE Id = @AccountID )
BEGIN
INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)

SET @Result = @@Error
END
ELSE
BEGIN
Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)
SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID

IF( ( @g1 Is NULL) OR (Len(@g1) = 0))
BEGIN
UPDATE AccountCharacter SET GameID1 = @Name
WHERE Id = @AccountID

SET @BonusMoney = 100000000
SET @Result = @@Error
END
ELSE IF( @g2 Is NULL OR Len(@g2) = 0)
BEGIN
UPDATE AccountCharacter SET GameID2 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE IF( @g3 Is NULL OR Len(@g3) = 0)
BEGIN
UPDATE AccountCharacter SET GameID3 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE IF( @g4 Is NULL OR Len(@g4) = 0)
BEGIN
UPDATE AccountCharacter SET GameID4 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE IF( @g5 Is NULL OR Len(@g5) = 0)
BEGIN
UPDATE AccountCharacter SET GameID5 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE
BEGIN
SET @Result = 0x03
GOTO TranProcEnd
END
END

IF( @Result 0 )
BEGIN
GOTO TranProcEnd
END
ELSE
BEGIN
INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership, Money )

SELECT @AccountID As AccountID, @Name As Name, 1, 32000, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,@BonusMoney As Money
FROM DefaultClassType WHERE Class = @Class

SET @Result = @@Error
END

TranProcEnd
IF ( @Result 0 )
ROLLBACK TRAN
ELSE
COMMIT TRAN

ProcEnd
SET NOCOUNT OFF
SET XACT_ABORT OFF

SELECT
CASE @Result
WHEN 0x00 THEN 0x01
WHEN 0x01 THEN 0x00
WHEN 0x03 THEN 0x03
ELSE 0x02
END AS Result
END
GO

[mattroilan]

INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership, Money )

SELECT @AccountID As AccountID, @Name As Name, 1, 32000, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,@BonusMoney As Money
FROM DefaultClassType WHERE Class = @Class

[lequangvu]

CREATE Procedure [dbo].[WZ_CreateCharacter]

@AccountID varchar(10),
@Name varchar(10),
@Class tinyint

AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @Result tinyint
DECLARE @iGUID int
DECLARE @BonusMoney int
SET @Result = 0x00
SELECT @iGUID = memb_guid FROM MEMB_INFO WHERE memb___id = @AccountID

IF EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
BEGIN
SET @Result = 0x01
GOTO ProcEnd
END

BEGIN TRAN

IF NOT EXISTS ( SELECT Id FROM AccountCharacter WHERE Id = @AccountID )
BEGIN
INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)

SET @Result = @@Error
END
ELSE
BEGIN
Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)
SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID

IF( ( @g1 Is NULL) OR (Len(@g1) = 0))
BEGIN
UPDATE AccountCharacter SET GameID1 = @Name
WHERE Id = @AccountID

SET @BonusMoney = 100000000
SET @Result = @@Error
END
ELSE IF( @g2 Is NULL OR Len(@g2) = 0)
BEGIN
UPDATE AccountCharacter SET GameID2 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE IF( @g3 Is NULL OR Len(@g3) = 0)
BEGIN
UPDATE AccountCharacter SET GameID3 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE IF( @g4 Is NULL OR Len(@g4) = 0)
BEGIN
UPDATE AccountCharacter SET GameID4 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE IF( @g5 Is NULL OR Len(@g5) = 0)
BEGIN
UPDATE AccountCharacter SET GameID5 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
END
ELSE
BEGIN
SET @Result = 0x03
GOTO TranProcEnd
END
END

IF( @Result 0 )
BEGIN
GOTO TranProcEnd
END
ELSE
BEGIN
INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership, Money )

SELECT @AccountID As AccountID, @Name As Name, 1, 32000, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,@BonusMoney As Money
FROM DefaultClassType WHERE Class = @Class

SET @Result = @@Error
END

TranProcEnd
IF ( @Result 0 )
ROLLBACK TRAN
ELSE
COMMIT TRAN

ProcEnd
SET NOCOUNT OFF
SET XACT_ABORT OFF

SELECT
CASE @Result
WHEN 0x00 THEN 0x01
WHEN 0x01 THEN 0x00
WHEN 0x03 THEN 0x03
ELSE 0x02
END AS Result
END
GO

[Domino9990]

mattroilan chỉ mới đúng chứ bác lequangvu????????????

[mattroilan]

mattroilan chỉ mới đúng chứ bác lequangvu????????????

lequangvu chỉ đúng đấy...

có điều từ xưa tới nay tớ thay luôn @BonusMoney As Money trong code dưới thành số tiền luôn thôi

SELECT @AccountID As AccountID, @Name As Name, 1, 32000, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,@BonusMoney As Money
FROM DefaultClassType WHERE Class = @Class

[Domino9990]

lequangvu chỉ đúng đấy...

có điều từ xưa tới nay tớ thay luôn @BonusMoney As Money trong code dưới thành số tiền luôn thôi

SELECT @AccountID As AccountID, @Name As Name, 1, 32000, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,@BonusMoney As Money
FROM DefaultClassType WHERE Class = @Class

ohm vậy hả? xưa giờ chỉ thay cái Money giờ mới bít cái này , hix, mình thật cổ lổ sỉ.

[bingbox]

SET @BonusMoney = 100000000 money là tiền

[nguyentuanphu]

cho mình hỏi nếu nhu cai script tren thì tặng rs 10 thì chỉnh như thế nào?

[thuynga]

INSERT INTO dbo.Character(AccountID, Name, Resets, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money )
SELECT @AccountID As AccountID, @Name As Name, 20, 400, 1000, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership, 1000000

mình cấu hình trong WZ_creatcharater thế nầy mà sao khi tạo nhân vật leve nó vẫn là 1 , và chỉ có 500 point cộng hả các bác

[Domino9990]

mình cấu hình trong WZ_creatcharater thế nầy mà sao khi tạo nhân vật leve nó vẫn là 1 , và chỉ có 500 point cộng hả các bác

thay đổi nhân vật vào lại là lv 400 số 20 là gì thế???????