Guest HackHunter Posted July 11, 2011 Share Posted July 11, 2011 Dute la stored procedures al DB-ului muonline, cauta WZ_CreateCharacter si cauta: if( @Result <> 0 )beginGOTO TranProcEnd end elsebeginINSERT 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,200000FROM DefaultClassType WHERE Class = @Class SET @Result = @@Error Link to comment Share on other sites More sharing options...
Recommended Posts