Hỏi Về TẶNG LEVEL POINT ZEN CHỈ NV ĐẦU TIÊN KHỞI TẠO

[HoiHoiDV]

Cho mình hỏi cách tặng reset level point zen thì mình biết rồi
Nhưng mình muốn hỏi là add làm sao cho nó chỉ tặng được 1 nv đầu tiên của tài khoản thôi
mà nó có 5 the he từ 1-5 add the he nào cũng là Full all nhân vật đều được tặng hết ai chỉ mình với
Vậy là add the he nào chỉ được tặng 1 nv đầu tiên
Pro giúp em với ?


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, 1, 1, 1, 400, @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, 100000
FROM DefaultClassType WHERE Class = @Class


thuoc the he 2
else if( @thehe = 2 )
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, 1, 1, 1, 400, @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, 50000
FROM DefaultClassType WHERE Class = @Class
end
-- Neu thuoc the he 3
else if( @thehe = 3 )
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, 1, 1, 1, 400, @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, 50000
FROM DefaultClassType WHERE Class = @Class
end
-- Neu thuoc the he 4
else if( @thehe = 4 )
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, 5, 5, 400, 2000, @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, 20000000
FROM DefaultClassType WHERE Class = @Class
end
-- Neu thuoc the he 9 : Event
else if( @thehe = 9 )
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, 5, 5, 400, 2000, @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, 10000000
FROM DefaultClassType WHERE Class = @Class
end
-- Neu thuoc the he khac chua dinh nghia
else
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, 5, 5, 400, 2000, @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
FROM DefaultClassType WHERE Class = @Class

[vodkacb]

Mình không nhớ cách tặng cho nhân vật đầu tiên rồi.
Nhưng mình vẫn nhớ cách tặng cho toàn bộ nhân vật
Bạn đang dùng thế hệ 1 thì edit ở thế hệ 1
Các thế hệ 2 3 là dành cho ai mở server thứ 2 thứ 3.
còn cách config theo ảnh sau
XANH DA TRỜI LÀ POINT
ĐỎ LÀ LEVEL
TÍM LÀ RS
VÀ XANH LÀ CÂY LÀ ZEN

[Only registered and activated users can see links. ]