Quote:
CREATE procedure MX_SelectCharacter
@Name nvarchar(10)
as
set nocount on
Update Character set Quest=0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF9CFFFF
where Name=@name and Class='64'
Update Character set Leaderpoint ='15' where Name=@Name and Leaderpoint>65000
SELECT AccountID, cLevel, Class, LevelUpPoint, Experience, Strength, Dexterity, Vitality, Energy, Leaderpoint, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, DbVersion FROM [Character] where [Name]=@Name
set nocount off
GO
This should work