CREATE PROCEDURE level90@id char(100) ASdeclare @lwl char(10)select @lwl = level from userdata where struserid = @id if @lwl = '80'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '81' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'endif @lwl = '81'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '82' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'end---made in shellx---if @lwl = '82'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '83' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'end---made in shellx---if @lwl = '83'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '84' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'end---made in shellx---if @lwl = '84'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '85' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'end---made in shellx---if @lwl = '85'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '86' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'end---made in shellx---if @lwl = '86'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '87' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'end---made in shellx---if @lwl = '87'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '88' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'endif @lwl = '88'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '89' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'endif @lwl = '89'beginupdate userdata set points = points + 3  where struserid = @id and exp = '1900000000'update userdata set level = '90' where struserid = @id and exp = '1900000000'update userdata set exp = '0' where struserid = @id and exp = '1900000000'endGO

SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,      Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly    FROM    USERDATA WHERE strUserId = @id

exec level90 @id

81 190000000082 190000000083 190000000084 190000000085 190000000086 190000000087 190000000088 190000000089 190000000090 1900000000