New Job System By Message #Xan

[codyblack]

هايل يا Xan بس توضيح بسيط
لكل الناس الي حصلها مشاكل ف add procedure
انت عندك ف _Char مفيش column اسمه TradeRank
انا شوفته و عدلت فيه للناس الي عندها مشكله مثلا انت عايزه يبقي ل trader query هيبقي كده

If (@TargetCharName like @SenderCharName and @Message = 'JOB') declare @CharID int = (SELECT CharID from _Char where CharName16 = @SenderCharName) declare @Tlvl int =(SELECT level from _CharTrijob where CharID =@CharID ) ----**************** LV. 2 Made By #Xan If (@TargetCharName like @SenderCharName and @Message = 'JOB') if (@Tlvl =2) BEGIN if(select JobLvl_Trader from _Char where CharName16 = @SenderCharName)<= 2 BEGIN exec _ADD_ITEM_EXTERN @SenderCharName,'ITEM_ETC_ARENA_COIN',10,1 update _Char set JobLvl_Trader =3 Where CharID =@CharID end end ----**************** LV. 3 Made By #Xan If (@TargetCharName like @SenderCharName and @Message = 'JOB') if (@Tlvl =3) BEGIN if(select JobLvl_Trader from _Char where CharName16 = @SenderCharName) <= 3 BEGIN exec _ADD_ITEM_EXTERN @SenderCharName,'ITEM_ETC_ARENA_COIN',30,1 update _Char set JobLvl_Trader =4 Where CharID =@CharID end end ----**************** LV. 4 Made By #Xan If (@TargetCharName like @SenderCharName and @Message = 'JOB') if (@Tlvl =4) BEGIN if(select JobLvl_Trader from _Char where CharName16 = @SenderCharName) <= 4 BEGIN exec _ADD_ITEM_EXTERN @SenderCharName,'ITEM_ETC_ARENA_COIN',40,1 update _Char set JobLvl_Trader =5 Where CharID =@CharID end end ----**************** LV. 5 Made By #Xan If (@TargetCharName like @SenderCharName and @Message = 'JOB') if (@Tlvl =5) BEGIN if(select JobLvl_Trader from _Char where CharName16 = @SenderCharName) <= 5 BEGIN exec _ADD_ITEM_EXTERN @SenderCharName,'ITEM_ETC_ARENA_COIN',50,1 update _Char set JobLvl_Trader =6 Where CharID =@CharID end end ----**************** LV. 6 Made By #Xan If (@TargetCharName like @SenderCharName and @Message = 'JOB') if (@Tlvl =6) BEGIN if(select JobLvl_Trader from _Char where CharName16 = @SenderCharName) <= 6 BEGIN exec _ADD_ITEM_EXTERN @SenderCharName,'ITEM_ETC_ARENA_COIN',60,1 update _Char set JobLvl_Trader =7 Where CharID =@CharID end end ----**************** LV. 7 Made By #Xan If (@TargetCharName like @SenderCharName and @Message = 'JOB') if (@Tlvl =7) BEGIN if(select JobLvl_Trader from _Char where CharName16 = @SenderCharName) <= 7 BEGIN exec _ADD_ITEM_EXTERN @SenderCharName,'ITEM_ETC_ARENA_COIN',70,1 update _Char set JobLvl_Trader =1 Where CharID =@CharID update _CharTrijob set level =1 , Contribution = 0 , Exp = 0 where CharID =@CharID end end

عايزه يبقي ل Thief هتعمل add tany
و تغير JobLvl_Trader ل JobLvl_Robber
لو لل hunter
JobLvl_Trader ل JobLvl_Hunter
و طبعا انا شيلت Lvl 1 علشان ف table _Char كله lvl 1
و بكده يكون query جاهز من غير مشاكل