hỏi về tạo zen ở nhân vật

[phuongnam9119]

mọi người cho mình hỏi làm sau để khi tạo nhân vật đầu tiên thì có zen tặng còn các nhân vật thứ 2 3... thì k cho zen tặng nữa .

cám ơn

[hieunova]

Mở Procedure WZ_CreateCharacter tìm đoạn sau:

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, 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,2000000
    FROM  DefaultClassType WHERE Class = @Class
    SET @Result  = @@Error
end

Sửa thành như sau, tặng bao nhiêu zen thì sửa chỗ @n0va_zen:

begin
    DECLARE @n0va_zen int,@n0va_firstcharacter tinyint = (SELECT COUNT(Name) FROM Character WHERE AccountID=@AccountID)
    IF ( @n0va_firstcharacter = 0 ) SET @n0va_zen = 10000000;
    ELSE SET @n0va_zen = 0;
    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, 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,@n0va_zen
    FROM  DefaultClassType WHERE Class = @Class
    SET @Result  = @@Error
end

[YouTobe]

[Only registered and activated users can see links. ]

Thử thì báo lỗi

[phuongnam9119]

-- Neu thuoc the he 1
            if( @thehe = 1 )
                begin
                    INSERT INTO dbo.Character(AccountID, Name, Resets, ResetNBB, 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, 250, 5, 400, 65000, @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, 2000000000 
                    FROM  DefaultClassType WHERE Class = @Class 
                end 

sửa như nào nhỉ