StartPoints&Zen la un caracter nou

Scris de **GiuFs** Joi Feb 03, 2011 1:08 am

Cod:: 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, Level, 300, @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,200000 FROM DefaultClassType WHERE Class = @Class SET @Result = @@Error