هايل يا 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 جاهز من غير مشاكل